Suggest Sales Price on Wksh. Batch Job

You use this batch job to create suggestions for changing the agreed item unit prices in the Sales Price table on the basis of the existing prices in the table. When the batch job has been completed, you can see the result in the Sales Price Worksheet window. You can also use the Suggest Item Price on Wksh. batch job to create suggestions for new prices.

There are two ways of using this batch job: You can either simply update the sales prices with an adjustment factor, or you can copy a sales price agreement to another customer or customer price group.

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 Sales Prices 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:

Sales Prices

You use the Sales Prices tab to determine how to filter the records of the existing sales prices.

Note

If you only want to update the price agreements based on the Adjustment Factor, do not fill in this tab.

Sales Type: Here you can enter the sales type for the sales price agreement that the sales price should be copied from. Use the sales type of the original sales prices you want to copy. 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 prices will be copied from. Use the Sales Code of the original sales prices you want to copy. To see the existing sales codes, click the AssistButton to the right in the field.

Item 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 AssistButton to the right in the field.

Currency Code: Here you can specify the currencies to be included in the batch job. To see the existing currency codes, click the AssistButton to the right in the field.

Starting Date: Enter a date to specify the first date in the period for which sales prices will be shown.

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.

Options

You use the Options tab to determine who the sales prices should be applied to and on what conditions.

Sales Type: Here you can enter the sales type that the sales price agreement should be copied to. 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 prices will be copied to. To see the existing sales codes, click the AssistButton to the right in the field.

Unit of Measure: Here you can specify the unit of measure code that will be used to determine the new prices. To see the existing unit of measure codes, click the AssistButton 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 that appears to the right.

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 Prices 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 in the Sales Price table.

Adjustment Factor: Enter the factor that the prices in the sales price agreement 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 that appears to the right.

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.



© 2009 Microsoft Corporation. All rights reserved.