Visual Integrator - how do I renumber a vendor and delete the old vendor number?

SOLVED

I used visual integrator on a test company to try to renumber an AP vendor.  I used AP Vendor Master table, downloaded a copy, changed  one vendor to test, and uploaded.   This worked to create another vendor with the new number, however, the original vendor and vendor number still exist.   

How do I use visual integrator to remove the original vendor and vendor number?  Am I using the correct table?    I'm using Sage 100 Premium, 2017 version.

Thanks.

  • +1
    verified answer

    Import into the AP_DeleteChangeVendors table, and run the utility to renumber.  You do NOT need to create the new vendor #'s before this.  Make sure the Start and End are the same value (which is how an import can help with typos, using the same source column for both), or you will merge multiple records into one.  (The fields are named dangerously).

  • 0 in reply to Kevin M

    Thank you.   I am having an issue with the delete and change vendors utility only listing the very last vendor from my imported file.

    I am exporting a list created by Visual Integrator Export Job, table AP_Vendor, and chosing APDivisionNo and VendorNo on the data tab.  I checked the csv file and all seem to be listed there.  I then import this list using AP_DeleteChangeVendors table, and choosing StartingAPDivisionNo and StartingVendorNo on the data tab. 

    I then run the Delete and Change Vendors utility, and on the change tab, but it only lists the very last vendor number from my imported file.

    Any idea what I'm doing wrong?

  • 0 in reply to L Energy

    You're missing the LineNo.  Either map to a column in your import file, or use the Incr Assign option.

  • 0 in reply to Kevin M

    This worked. Thank you!    I ended up using the Incr Assign option since it kept the starting vendor no. in sequential order in the utility.   I added LineNo, changed it to Incr Assign, and that was it.