Changing Vendor No

Question

Hello I need to change all items with Vendor No# NOV02 to NOV04 would I do this within VI??

Kevin M · Accepted Answer

Import to CI_Item, with your source file containing three columns (or two if you don't use AP Divisions). CSV is the easiest to work with. 
 VI job columns are ItemCode, PrimaryAPDivision (hard code to "00" if you don't have AP divisions enabled), PrimaryVendorNo, using "Replace" with the column numbers matching your source file. 
 Try in a test company code first.

daburke · Answer

When you change the primary vendor on the item you will also need ensure that there is an item vendor record for the item and vendor. In the maintenance screen if you try to set the primary vendor to a vendor that is not listed as a vendor for that item (press the vendor button) it will not save the primary vendor.

Sage 100

Changing Vendor No

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING