How to import to AP_DeleteChangeVendors in Sage 100


How to import to AP_DeleteChangeVendors using Visual Integrator


Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions.
Sage Customer Support does not provide assistance for issues related to third party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions.


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


If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.