Calculate Inventory Value Batch Job

This batch job calculates the inventory value for the date specified in Posting Date on the request form.

As the calculation of inventory value can be rather time-consuming, it is not desirable for the calculation to be cancelled because a precondition is not met. To prevent this situation occurring, a test report, Calc. Inventory Value - Test can be used, which checks preconditions for the inventory value calculation.

After you run the Calculate Inventory Value batch job, and before you actually post changes to inventory value, you can print a test report showing the journal lines.

You can define what is included in the batch job by setting filters. To set additional filters on the tab, press F3, click the AssistButton and then select the relevant filter(s).

You can also determine what is included in the batch job by filling in the fields on the Options tab.

Click OK to start the batch job. If you do not want to run the batch job now, click Cancel to close the window.

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

Item

No.: In the Filter field, you can enter the numbers of the items to be included in the batch job.

Costing Method: In the Costing Method field, you can enter the costing method of the items to be included in the batch job.

Location Filter: In the Filter field, you can enter the locations to be included in the batch job.

Variant Filter: In the Filter field, you can enter the item variants to be included in the batch job.

Click the Lookup button at the lower left-hand corner of the window to see the result of the filters that you have defined for the table.

Options

Posting Date: In this field, you can enter the date for the posting of this batch job. The program automatically enters the working date in this field, but you can change it.

Document No.: In this field, you can specify which document number will be entered in the Document No. field on the journal lines created by the batch job. The program automatically enters the next number from the number series on the journal batch, but you can manually change it.

Calculate Per: In this field, you can select one or the other option button, depending on whether you want to sum up the inventory value per item ledger entry or per item.

If you select Item, you can also select the following options:

By Location: In this field, you place a check mark in the check box if you want the lines to be grouped by location.

By Variant: In this field, you place a check mark in the check box if you want the lines to be grouped by variant.

Update Standard Cost: Place a check mark in this field if you want the program to update the standard cost on the item card. If the item is in stock on the posting date of the revaluation, a revaluation journal line will be created. The standard cost on the item card will then be updated when the revaluation journal line is posted. If the item is not in stock on the posting date, then the standard cost on the item card will be updated immediately.

Calculation Base: In this field, you can specify how the revaluation journal will suggest a new value for the Unit Cost (Revalued) field.

The options are: