How to move skus across to new vendor card 

• Before moving items to a new vendor, you need to confirm the items' pricing on the new vendor number. You should have an updated price list from the supplier to confirm this. If they advise pricing stays the same as the old vendor number, the below will show you how to action. 

1. Open the item page and select Item pricing information

2. Put in the current vendor no the items are loaded against (I.E if we are moving 000022 to 000032 then use 000022 in item pricing).

3. Click preview then the save icon once generated and save it to your NAV desktop as "Item Pricing".

4. Copy and paste Item Pricing into your local computer and import it into a google sheet (this will serve as your worksheet). Name the google sheet as follows: today's date, supplier's name, vendor number and the ticket number of your ticket. Paste the link as a note in your ticket.

5. Make a copy of the pricing template update link - Here

6. Copy the No. column from your worksheet and paste into SKU column of the pricing template.
   
   

7. Enter the new vendor number (in this example 000032) and update the date column with the date from which you need this price to take effect.
   
   

8. Copy the purchase price column from your worksheet into the price column on the update template.

9. Remove the headers and any examples on the pricing template and download as CSV.
   
   

10.  Copy this CSV to your NAV desktop.

11. On the item page, click the Import Purch. Prices on the top ribbon and select the CSV file and hit ok.

12. Once finished, you can move move the items across to the new vendor number.

13. Go to Departments > Utilities > Reports and Analysis > Update Vendor No in Item Card (3rd last) and add the new vendor no in the New Vendor No field and the old vendor no in the item field.
    
    

14. IMPORTANT You will need to add more filters if you're not moving all of the SKUs as this tool automatically moves all SKUs. 

    • If you need to move specific SKUs,  you will need to do this in batches. The batches will depend on the  number of characters that each SKU contains but will typically be between 80 and 125 SKUs.

    • If the SKUs on your list are coming from more than one vendor, you will need to also batch them based on their original vendor as the tool requires the original vendor to be specified.
      
      

15. When you confirm the change, NAV will eventually go unresponsive - this is how you know it is working.
    
    

16. Once NAV becomes responsive again, sense check the change was completed by checking a list of the SKUs that were due to be moved on the item tab on NAV. Spot check some of these to ensure their pricing was updated too.