Share via

Adjust Cost - Item Entries Batch Job

  • Article

Adjusts inventory values in value entries so that you use the correct adjusted cost for updating the general ledger and so that sales and profit statistics are up to date. The cost adjustment forwards any cost changes from inbound entries, such as those for purchases or production output, to the related outbound entries, such as sales or transfers. It may be relevant after posting any inventory transaction, but mostly in connection with:

  • inbound transactions

  • item charges

  • finishing production orders

  • inventory revaluation

The Adjust Cost - Item Entries batch job processes only value entries that have not yet been adjusted. If the batch job encounters a situation where changed inbound costs need to be forwarded to associated outbound entries, the batch job does this by creating new adjustment value entries, which are based on the information in the original value entries but contain the adjustment amount. The program uses the posting date of the original value entry in the adjustment entry, unless that date is in a closed inventory period. In that case, the program uses the starting date of the next open inventory period. If inventory periods are not used, the date in the Allow Posting From field of the General Ledger Setup window will define when the adjustment entry is posted.

The costing method on each item card determines how the program calculates the adjustment. You can read more about costing methods under Costing Method.

The batch job does not update the general ledger automatically unless the you have selected Automatic Cost Posting in the inventory setup. To update the general ledger manually, you must run the Post Inventory Cost to G/L batch job.

Options

Item No. Filter: Enter a filter in this field to run the Adjust Cost – Item Entries batch job for only certain items. You can leave this field blank to run the batch job for all items.

Item Category Filter: Enter a filter in this field to run the Adjust Cost – Item Entries batch job for only certain item categories. You can leave this field blank to run the batch job for all item categories.

Note

You can use either the Item No. Filter field or the Item Category Filter field, but you cannot use both filter fields at the same time. Using these filter fields means that not all the inventory will be adjusted. The main purpose of these filters is to limit the runtime of the batch job in special cases. Typically, you should run the cost adjustment batch job for all items.

Post to G/L: This field is available if Automatic Cost Posting is selected in the inventory setup. If you place a check mark in this field, the program posts the inventory values created during the adjustment batch job to the inventory accounts in the general ledger.

If you do not place a check mark in this field, the program does not automatically post the adjustment inventory value to the general ledger. You must therefore run the Post Inventory Cost to G/L batch job separately to ensure that these values are posted to the general ledger

Important

You can also set the program up to perform automatic cost adjustment every time you post inventory transactions. This allows you to operate with more accurate inventory and WIP values and profit statistics without having to rely on other users running the Adjust Cost - Item Entries batch job periodically.

Note

The Adjust Cost - Item Entries batch job is critically different from Adjust Item Costs/Prices batch job, which is used to make adjustments to the item card or the stockkeeping unit card.

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.