Share via

Calculate Inventory Value Batch Job

  • Article

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.

Note

For items that use the Average costing method, it is only possible to revalue at the beginning or end of an average cost period. If you try to run the calculate inventory value batch job for an average-cost item with a date that is not the beginning or end of an average cost period, the batch job will not run.

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 select whether 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: Select this field if you want the lines to be grouped by location.

By Variant: Select this field if you want the lines to be grouped by variant.

Update Standard Cost: Select 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:

  • <Blank>: The revaluation journal will suggest the same value as in the Unit Cost (Calculated) field .

  • Last Direct Unit Cost: The revaluation journal will calculate the value in the field based on the Last Direct Unit Cost on the Stockkeeping Unit card or the Item card.

  • Standard Cost - Assembly List: The revaluation journal will calculate the value in the field based on the bill of materials.

  • Standard Cost - Manufacturing : The revaluation journal will calculate the value in the field based on the production BOM.

Tip

For more information on how to work with batch jobs, see How to: Run Batch Jobs and How to: Set Filters. For assistance in finding specific pages, see Search.