How to import to AP_DeleteChangeVendors in Sage 100

Description

How to import to AP_DeleteChangeVendors using Visual Integrator

Disclaimer

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.

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

Support

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