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.