Steps to get to Visual Integrator (VI) and create a import job

1. Open Modules, Visual Integrator, Main menu, Import Job Maintenance
2. Enter the name of the job in Job Name field
3. Select the table AP_InvoiceHeader in the Table Name field
4. Click Accept
5. Click Yes to confirm this is a new job
6. Select the Data tab
7. The import should contain the following fields, at a minimum,  on the Data tab in this exact order:
   1. H.BatchNo (only required if Batch Entry is enabled in Accounts Payable Options
   2. H.APDivisionNo (Assign to 00 if Accounts Payable Divisions is not enabled in AP Options)
   3. H.VendorNo
   4. H.InvoiceNo
   5. L.AccountKey
   6. L.DistributionAmt
8. Additional fields may be added to import if default values are to be overwritten or if another field is to be populated such as a comment.
9. Click Accept and click Yes to execute the job
10. Click the Browse button to browse to the sourcefile to be used for the import job
11. Click Accept to run the import job and click Yes to confirm it is importing into the correct company

 

Additional information

If import attempt results in error "XX: Division required" message referring to Division number despite the Division number specified in the job as numeric and being a correct division number (and vendor number) this may be due to custom scripting/programming which is rejecting the invoice because it is already exists and would block entry of that invoice being imported but message is displayed as Division number error.

 

.