The following list describes some recommended techniques when editing cost text files in Microsoft® Excel.
Adjust the column widths so that all the exported data is visible.
DO NOT CHANGE SPREADSHEET FORMAT PRIOR TO SAVING THE FILE.
Do not rename columns.
Do not permanently insert or delete any columns.
Do not change the data format of any columns.
With the exception of cost data, all columns must remain the same as they were exported to ensure the subsequent data import is successful.
Enter any new or changed costs in the Unit Price column.
If a percentage increase/decrease to all costs is desired, insert a temporary column next to Column H (Unit Price).
Create a formula in the temporary column to calculate a percentage change on the costs in column H, then copy that formula down the column.
Finally, copy the cells in the temporary column and select Edit > Paste Special, values only, to the corresponding cells in column H.
Delete the temporary column.
Save the *.csv file
Close the *.csv file.
In Purchasing, import the revised supplier cost file. See Import Costs From a File for more information.
How to Export Supplier Costs to File
Select Activities to Export Costs
Select Supplier and Effective Dates to Export Costs