- Open Modules, Visual Integrator, Main, Import Job Maintenance.
- Enter a name in the Job Name field.
- Select AP_InvoiceHeader in the Table Name field.
- Click Accept.
- Click Yes to confirm this is a new job.
- Go to the Data tab.
- Ensure the import file contains these fields, in this exact order:
- H.BatchNo (System requires only if you have Batch Entry enabled in Accounts Payable Options)
- H.APDivisionNo (you must assign to 00 if you haven't enabled AP Divisions)
- H.VendorNo
- H.InvoiceNo
- L.AccountKey
- L.DistributionAmt
- Add more fields if you need to overwrite defaults or populate other fields (for example, comments).
- Click Accept and then Yes to execute the job.
- Click Browse to select the source file for the import.
- Click Accept to run the import job and Yes to confirm the correct company.
Additional Information If you get "XX: Division required" error despite a correct division number, custom scripting is blocking the entry because the invoice already exists. The error message incorrectly references the division number. [BCB:155:Chat 100 US:ECB] |