Below is the key that details the three items needed for importing into the Auto Payment Post tab. An easy option to build the file is to have an excel spreadsheet with the information laid out as below (With no column headers) and saved in CSV comma delimited format.
Item | Keys To | Example |
Reference # | Reference field in A/R | 201542 |
Check Date | Payment Date | 10/29/2018 |
Check Amount | A/R Payment Amount and invoice amount (always one entry) | 2150.11 |
Invoice Number | Invoice Number | 611-10884 |
0 Comments