You use this batch job to create suggestions for changing the agreed item unit prices for your sales prices in the Sales Price table on the basis of the unit price on the item cards. When the batch job has been completed, you can see the result in the Sales Price Worksheet window. You can also use the Suggest Sales Price on Wksh. batch job to create suggestions for new sales prices.
This batch job only creates suggestions and it does not implement the suggested changes. If you are satisfied with the suggestions and want to implement them, that is insert them in the Sales Price table, you can use the Implement Price Change batch job. This batch job is found under Functions in the Sales Price Worksheet window.
You can define what is included in the batch job by setting filters. To set additional fields on the Item tab, click the Field field, then click the AssistButton that appears to the right. You can also determine what is included in the batch job by filling in the fields on the Options tab. Fill in the fields as follows:
No.: Here you can specify the numbers of the items to be included in the batch job. To see the existing item numbers, click the Filter field, then click the AssistButton that appears to the right.
Vendor No.: If you want to change prices for one particular vendor, this is where you can specify the number of the vendor to be included in the batch job. To see the existing vendor numbers, click the Filter field, then click the AssistButton that appears to the right.
Inventory Posting Group: Here you can specify the inventory posting groups to be included in the batch job. To see the existing inventory posting groups, click the Filter field, then click the AssistButton that appears to the right.
Click the up-arrow at the lower left-hand corner of the window to see the result of the filters you have defined for the table.
Sales Type: Here you can enter the sales type for the sales price agreement. To see the existing sales types, click the AssistButton to the right in the field.
Sales Code: Enter the code for the sales type that the sales price agreement will update. To see the existing sales codes, click the AssistButton to the right in the field.
Unit of Measure Code: Here you can specify the unit of measure code that will be used to determine the new prices. To see the unit of measure code options, click the AssistButton to the right in the field.
Currency Code: Here you can specify the currencies that will be used for the new prices. To see the existing currency codes, click the AssistButton to the right in the field.
Starting Date: Enter the date when the price changes will take effect.
Ending Date: Enter the date to which the price changes are valid.
Only Amounts Above: Here you can enter the lowest unit price that will be changed. Only prices that are higher than this will be changed. If a price is lower than or equal to this amount, a line for it will be created in the Sales Price Worksheet window, but with the same unit price as on the item card.
Adjustment Factor: Enter the factor that the prices on the item card will be multiplied by (for example, 1.2).
Rounding Method: Enter a code for the rounding method that will be used to determine the new prices. To see the existing rounding method codes, click the AssistButton to the right in the field.
Create New Prices: Place a check mark in the check box if you want the batch job to create new price suggestions (for example, a new combination of currency, sales code and time). Don't insert a check mark if you only want to adjust existing sales prices.
Click OK to start the batch job. If you do not want to run the batch job now, click Cancel to close the window.