Create a sales price worksheet

  1. Go to the Sales price worksheets (AR202010) window.
  2. Click .
  3. Write a description for the new sales price worksheet.
  4. To add items to the worksheet, you can:

    • Click in the table toolbar and select the item ID you want to add to the worksheet.
    • Click Add item in the table toolbar. In the Add item to worksheet pop-up window, you can select the desired item IDs and click Add or Add and close.
    • Click Copy prices in the table toolbar. In the pop-up window, you can select the source and destination price type of the items you want to copy to the new price worksheet, and define the effective date of the prices. Click Copy to copy.
    • Click to open the File upload dialog box. You can locate and import local files, Excel spreadsheets (.xlsx), and .csv files. See: Import data from a local file to a table.
  5. Click .

If you want to use promotional prices, select the Promotional check box and enter the promotion's expiration date.