Changing Vendor No

SOLVED

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

  • 0

    Do you mean changing Primary Vendor in Item Maintenance?  Yes, you can do that with VI (import to CI_Item).

  • 0 in reply to Kevin M

    Yes I do mean change Primary Vendor.. 

    I have run several imports that were already created but I'm not sure how to configure job to replace or change a field.. You wouldn't happened to have a small example..  Below is one that we use to import Discount price changes I receive a spreadsheet from Inventory Mgr with all new Discount price changes then import.  So I assume its setup similar to this, maybe not...  

    Thanks as always for any help.. 

  • +1 in reply to Bob@TED
    verified 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.

  • 0
    SUGGESTED

    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.