How to Import to AP_DeleteChangeVendors in Sage 100

Summary

How to import to AP_DeleteChangeVendors using Visual Integrator in Sage 100

Disclaimer

Backup Warning

Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.

Resolution

In order to have a successful import to AP_DeleteChangeVendors table, the following fields are needed.

  1. LineNo = Use Incr Assign with default of 00000000000000
  2. StartingAPDivisionNo
  3. StartingVendorNo
  4. EndingAPDivisionNo
  5. NewAPDivisionNo
  6. EndingVendorNo
  7. NewVendorNo
  8. Operation 1=Delete,2=Change
  9. AllFiles = assign to Y