Import Accounts Payable Invoices
Vendors sometimes provide export files containing invoice information that can be imported into ACS.
Typically, these imports are CSV (comma separated value) files: simple text files with field values separated by commas.
- Under Manage Records, select the Transactions tab.
- In
the drop-down list, select Accounts
Payable Invoices and click Go
.
- Click Add/Edit Invoices, then Import.
- Click Browse.
- Locate and select the CSV file you want to import, and click Next.
- If you have saved mappings previously and want to re-use one, use Select a mapping. You can also edit or delete the mapping. If you are not using a previous mapping, click Create a new mapping from your import file. Click Next.
- On the Configure tab, specify what information ACS should check for in the import file. For more information, see the tabs below.
- On the Mapping tab, select the Import Field that you want to correspond with each ACS Field.
- On the View Import Data tab, preview a sample of the values that will be imported. For more information, see the tabs below. Click Next.
- A data preview page displays. Only error-free data will be imported. When ready, click Import.