Calculate pending prices in a worksheet

Before you start

Be sure that you have a populated worksheet with the Hold status that includes the records for which you want to calculate prices, and that this list of price records meets your requirements.

Also, make sure that the options you want to use as a price basis have the correct values.

1. Go to the Sales price worksheets (AR202010) window.
2. By using the standard functionality of this window, create a new worksheet and populate it with the price records or open an existing worksheet.
   For details, see: Create a worksheet.
3. Click the Calculate pending prices button in the table toolbar.
4. In the Calculate pending prices dialog box that is brought up, do the following:
   1. In the Price adjustment area of the dialog box, specify the price increase or decrease as a percentage of the basis. Do the following:
      • In the % of original price field, enter the percentage at which the new pending prices will be calculated by using the selected price basis.
      • In the Decimal places field, type the number of places after the decimal point that will be shown for prices.
      • Select the Update with zero price when basis is zero check box if you want the pending price parameter of the price record to be updated with the value zero if the selected price basis for this record is zero.
   2. In the Price basis area, specify the basis for calculating new pending prices by selecting one of the following options:
      • Last cost + mark-up %:
        Select this option if you want to calculate prices based on the stock items' last costs increased by the mark-up percentage specified for the items.

      The option is not applicable for non-stock items.

      • Average/standard cost + mark-up %:
        Select this option if you want to calculate prices based on the stock items' average/standard costs increased by the mark-up percentage specified for the items. In case of non-stock items, the system uses the current cost, instead of the average or standard cost.
      • Source price:
        Select this option if you want to calculate prices based on the item's source price (displayed in the Source price column).
      • MSRP:
        Select this option if you want to calculate prices based on the manufacturer's suggested retail price.
      • Pending price:
        Select this option if you want to recalculate pending prices based on currently pending prices.
      • Replacement cost:
        An option that you select to calculate pending prices based on the item's replacement cost.
5. Do one of the following:
   • Click Update to update the pending prices with the new values.
   • Click Cancel to close the dialog box without updating price records.
6. In the window toolbar, click .

After you have updated the price records with the new pending prices, you can release the worksheet to make effective the pending prices of the items.