Create a supplier price worksheet

  1. Go to the Supplier price worksheets (AP202010) window.
  2. In the window toolbar, click .
  3. Fill in the Description field for the new supplier 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, 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 Import data from a local file to a table dialog box. You can locate and import local files, Excel spreadsheets (.xlsx), and .csv files.
  5. Click .

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