Import Invoices Field Descriptions
Read more about the fields used to import invoices in Accounts Payable.
The Configure Tab
- Import File has a header record
- Select if your CSV file contains a header record
- Use field values instead of field names to create mapping
-
Select if there's no header record in the CSV file
- Lookup Account By
- Pulls the AR Account Code or Name in ACS
- Lookup Project by
- Pulls the Project Code or Name found in Define Lists
- Lookup Payee by
- Pulls from Vendor records, not Employee records
The Mapping Tab
The selections you make on the Configure tab determine the import fields. Those selections are also required.
If multiple dates are within the same invoice ID, Accounts Payable uses the date of the first line in the invoice and ignores any others. If Month and Year fields are not in the imported file, Accounts Payable uses the Date field.
If you plan to import similar files in the future, click Save Map. You can reuse these same selections for future imports.
The View Import Data Tab
If an invoice has no errors, it displays on this tab, and you can import it.
If an invoice has errors, they display on the Errors Detected tab. You can make manual changes to those invoices, then click Reverify Data to move them to the Ready to Import tab.
Some fields only accept certain types of data (letters, numbers or dates). Some fields also truncate after you enter a set number of characters.