IMPORTING CUSTOMER/DEBTORS TRANSACTIONS

The code that must be entered in the MLE box is: DEBTORTRAN,aa,bb

Where aa is the Dissection Code to be assigned to all the line item records written to the FINHIST file. If this code is blank, then it is set to: ZTRFIN.

bb is set to the string: DUPCHECK to test for duplicated entries. If a duplicated entry is found (with the same value) then the input record is ignored. Similarly, if a duplicated entry is found, with zero value, then the record found is erased.

The Transactions will all be aged as “Current” – you should run the VERIFY menu item in order to reset all debtor balances and age the transactions according to the transaction dates.

The Transaction Amount must be positive for Invoices, Credit Notes and Payments. It must be signed (with a leading ‘-‘ sign) for Journals, where applicable.

The fields in the input record are defined below:

FieldMaximum Length
  
Account Number10
Document Number 10 (Mandatory)
Transaction Date (DD/MM/YY or DD/MM/YYYY)10 (Mandatory)
Transaction Reference10
Transaction Type (I=Invoice, J=Journal, C=Credit Note, P=Payment)1 (Mandatory)
Transaction Amount8 (Mandatory)
Narrative20
Tax Included in the ‘Transaction amount’ above8 (Optional)
Total Amount Paid (i.e. settled)8 (Optional)