Step-by-step guide 

1, Use search function to find Sales Price Worksheet

2, Select the option for run the batch job suggest change to existing sales price

(1) Suggest Item Price on Wksh... - suggest change sales price by adjustment factor to existing unit price on item cards.

     The unit price on the item card will not change by using implement price change function in sales price worksheet.

(2) Suggest Sales Price on Wksh... - suggest change sales price by adjustment factor to existing sales prices for the customer, customer group or sales campaigns.


3, Enter the options for run the suggest sales price

Sales Type / Sales Code - fill with the type and name if type is customer the new price to be change for. 

Adjustment Factor - fill in the percentage if you wanted to increase the item prices by some percentage (e.g.) input 1.10 if increase 10% in item price. 

Create New Price toggle - turn on the toggle if you want the batch job to create new prices. 

Filter Item

Filter the item which is need to update the price by the batch job 

For the example below, the price update only for the Gen. Prod. Posting Group is Product and has Assembly BOM

Choose OK to fill in the lines on the Sales Price Worksheet page with the suggested new prices.

4- Suggestions to be created, review the suggested new unit price it calculated by system according to the options filled in step (1)

5- Once the new price is reviewed and confirmed.  Click Actions => Functions => Implement Price Change for update the prices in the system.


  • No labels