Use Visual Integrator to import into AP Invoice Data Entry
Description
Cause
Resolution
  1. Open Modules, Visual Integrator, Main, Import Job Maintenance.
  2. Enter a name in the Job Name field.
  3. Select AP_InvoiceHeader in the Table Name field.
  4. Click Accept.
  5. Click Yes to confirm this is a new job.
  6. Go to the Data tab.
  7. 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
  8. Add more fields if you need to overwrite defaults or populate other fields (for example, comments).
  9. Click Accept and then Yes to execute the job.
  10. Click Browse to select the source file for the import.
  11. 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]

 

Steps to duplicate
Related Solutions

How to import into Business Framework data entry files for Sage 100
Access File Layouts (field and table schema) or the TRSG (Technical Reference and Support Guide)
How to use the Next operation in Visual Integrator to assign a Next Automatic Number