Bring up the Query Generator through menu: Tools > Queries > Query Generator, click execute, select pencil to edit the query, paste the following query into the window, and select execute:
SELECT T0.[ItemCode], T0.[PriceList], T0.[Price], T0.[Currency] FROM ITM1 T0 INNER JOIN OPLN T1 ON T0.[PriceList] = T1.[ListNum] WHERE T1.[ListName] =[%0]
Choose the toolbar button to export to excel. Name the file, keeping it as a tab delimited text file. A system message will show regarding the currency. Select No.
Open the file with excel, remove the first column and header, modify the price, insert a column with value "Manual" or appropriate UoM code in column I , then save the file as a tab delimited text file:
Complete a backup of the database to allow for a restore in case there are problems.
Choose menu: Administration > Data Import/Export > Data Import > Import From Excel.
From the drop down boxes, select:
- "Items" as the "Data Type to Import"
- "Item No." as column A
- "Price List Code" as column B (column C and D will be automatically filled out as shown
- Select the saved filename using the "..." at "File to import"
- Click "Import" when ready
Select the check boxes as shown below.
A message with the results will be shown when system finished updating, you will find the information in system message log as well as if any error messages:
You could now verify the change and/or fix the issue for the failed records.