An additional “Import File” button has been added to the following Payment Allocation screens:
- Debtor Payment Allocations
- Auto Payment Allocations
- STD Payment Allocations
- Creditor Payment Allocations
- Bills Payment Allocation
The Import File button will become available once you have opened a record, such as opening a Supplier’s record in Creditor Payment allocation.
The specifications for the Payment Allocation import file are as follows:
- Tab delimited text file.
- First line must be a heading line.
- The column headings “Reference” and “Amount” must exist in the file. These headings are not case sensitive and can be in any order. All other columns will be ignored.
- Amount column must hold valid numeric values.
When a file is imported, the system will find each “Reference” and load it into the “Ref No” field in the Allocations section of the Payment Allocation screen. The “Amount” value will be entered in the “Pay” field. An additional screen listing the results of the import will be displayed alongside the “Payment Allocation” screen. This will show all records that where matched / mismatched or invalid from the import file.
