Use a printed price worksheet to aid entering prices manually. The worksheet prints the current price for products with spaces for writing in the new prices. Write the new vender prices on your worksheet and then enter the new prices into the system.
To print price worksheets for manual updates:
From the Maintenance > Price Maintenance menu, select Price Sheet Entry to display the Price Sheet Entry window.
Complete the information on the Price Sheet Entry window for all bases that affect pricing for the price line.
If you type ENTER in theCalculation Basiscolumn for any of the bases, the worksheet displays a column of old prices followed by a column of blank lines where youenter the new prices.If theCalculation Basiscolumn does not contain ENTER, no worksheet prints.
Do the following to organize the product list before printing the worksheet:
Rearrange the product list in the price line for easy product location.
Sort the products on the price sheet to organize products or limit the list on the worksheet.
To determine if you should include or exclude products in the worksheet that have been assigned a Delete status on the Product Maintenance window, select Include Deleted items.
Select File >Print Worksheetto generate the worksheet.
The worksheet prints to your Hold file and the Phantom messages you when the worksheet is available.
Transfer the data from the vendor's price sheet onto your worksheet by hand.
Select File >Enter Prices to display the Price Sheet Entry/Update dialog box. The items listed should match the items on the worksheet.
Note: You must have the PRICE.SHEET.UPDATE authorization key to use the Enter Prices hot key.
See Also: