Adjust Item Costs/Prices Batch Job

This batch job is used to adjust several fields (Last Direct Cost, Standard Cost, Unit Price, Profit % and Indirect Cost %) on the item or stockkeeping unit cards. For example, you can change Last Direct Cost by 5% on all items from a specific vendor. The changes are processed immediately when the batch job is started. The fields on the item card that are dependent on the adjusted field are also changed.

Note

This batch job cannot be used to change alternative unit prices or direct unit costs. You can change unit prices by using the Suggest Item Price on Wksh. or the Suggest Sales Price on Wksh. batch job.

If you want to include more information, on the Item tab you can select additional fields to be included in your report. To do this, press F3, click the AssistButton and then select the relevant field(s).

You can specify further what is included in the report by setting filters. If you do not set any filters, the report will include all your records. You can also determine what is shown in the report by filling in the fields on the Options tab.

To print the report, click Print. To see the report on the screen before printing it, click Preview. If you want to save your report and print it later, click Cancel. The program automatically saves your settings.

To set filters in the report, fill in the fields as follows:

Item

No.: In the Filter field, you can specify the numbers of the items that you want to include in the batch job.

Vendor No.: In the Filter field, you can specify the numbers of the vendors that you want to include in the batch job.

Inventory Posting Group: In the Filter field, you can specify the inventory posting groups that you want to include in the batch job.

Click the up-arrow in the lower left-hand corner of the window to see the results of the filters you have defined for the table.

Options

Adjust: You can select to have the batch job base the adjustment on item cards or stockkeeping unit cards.

Adjust Field: Select the field that will be adjusted by the batch job. You can select only one field at a time.

Adjustment Factor: Enter the factor that the prices 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. If this field is left blank, the program will use the default rounding precision.