Adept Interface and Setup
Accounts payable invoices and credit notes can be imported into the AFD database using a predefined CSV spreadsheet format.
This spreadsheet format will allow the importing of multiple invoices within the one file. All invoices in the one file must relate to the same company within Adept.
The CSV file format required is outlined below:
Control Record - Header
Invoice Record
GL Distribution Record
Notes
- For each Invoice record, there must be one or more GL Distribution records immediately following it in the interface file and the total GL Distribution Amount should equal to the Invoice Amount.
- Credit amounts must be signed negative, i.e. prefixed with a "-".
- The batch created in ADEPT is named in the format "APCCnnnnnnnn", where "CC" is Company Code and "nnnnnnnn" is a sequence number.
- It should be noted that as a generic interface no control is exercised over each batch, i.e. if the process is passed the same batch twice it will be processed twice, and if a batch is not selected its absence will not be detected.
- Information on any error detected is highlighted on the screen. Major errors will abort the process.