Create a supplier price worksheet

  1. Go to the Supplier price worksheets (AP202010) window.

  2. In the window toolbar, click icon-add.

  3. Fill in the Description field for the new supplier price worksheet.

  4. To add items to the worksheet, you can:

    • Click icon-add 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 icon-load-from-file to open the File upload dialog box. You can locate and import local files, Excel spreadsheets (.xlsx), and.csv files.
  5. Click icon-save.

Note

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

Last modified February 19, 2026