The Virtual Warehouse Part Maintenance feature is designed to help alleviate the complexities that you may run into in a dataload. The process works on the premise that your inventory is attached to a supplier and you want to update your inventory with the electronic price file your supplier has given you. This means that if the supplier is not attached to the inventory you have in System Five this process will not work for you. It is important that you test this in training if you are going to be updating based on the supplier not being the primary supplier of that item. Whether the supplier is a primary, or alternate supplier affects how the update will run and which settings are necessary.
Please take some time to review the Online help for this topic by going to the index Virtual Warehouse Part Maintenance. This topic has a brief explanation of the individual windows, buttons and fields you might encounter in Virtual Warehouse Part Maintenance.
There are different ways each company manages their parts and prices. On one side some companies do things their own way. They have their own part numbering, their own prices, and their own rules for how things work. On the other side some companies use the suppliers part numbers, the suggested markups or prices, and standard ways of doing things. Then there are all of the scenarios in between. I am going to try and identify some scenarios and basic ways of doing things. One of them might help you, or be a starting point to work from.
This is a great way to proceed for many customers.
Example File Format(CSV)
PartNo, CostPrice, ListPrice 12345, 45.00, 69.99 abc, 10.00, 20 xyz, 100, 120
I will record a video, or videos for this section(s).