Updating inventory default prices
I need to update inventory prices and I don't have Excel installed on the computer to use Import from XLS.
Step-by-step guide
Create a CSV file with PartNo and DefaultPrice, RRPPrice, LastCost with relevant data
Load Inventory > Utilities > Inventory Import
Select the CSV file and make sure "Update existing inventory" is ticked
Click Import - bottom right
A message displays the results of records updated and details of any errors
Where the inventory item does not exist, there is no warning.