The main purpose of cost adjustment is to forward cost changes from cost sources to cost recipients, according to an item’s costing method, to provide correct inventory valuation.
An item can be sales invoiced before it has been purchase invoiced, so that the recorded inventory value of the sale does not match the actual purchase cost. Cost adjustment updates the cost of goods sold (COGS) for historic sales entries to ensure that they match the costs of the inbound transactions to which they are applied. For more information, see Design Details: Item Application.
The following are secondary purposes, or functions, of cost adjustment:
Invoice finished production orders:
Update the unit cost on the item card.
Inventory costs must be adjusted before the related value entries can be reconciled with the general ledger. For more information, see Design Details: Reconciliation with the General Ledger.
The task of detecting if cost adjustment should occur is primarily performed by the Item Jnl.-Post Line routine, while the task of calculating and generating cost adjustment entries is performed by the Adjust Cost – Item Entries batch job.
To be able to forward costs, the detection mechanism determines which sources have changed in costs and to which destination these costs should be forwarded. The following three detection functions exist in Dynamics NAV:
This detection function is used for items that use FIFO, LIFO, Standard, and Specific costing methods and for fixed applications scenarios. The function works as follows:
This detection function is used for items that use the Average costing method. The function works as follows:
This detection function is used in conversion scenarios, production and assembly. The function works as follows:
The Order Level function is used to detect adjustments in assembly posting. The following graphic shows the adjustment entry structure:
For more information, see Design Details: Assembly Order Posting.
Cost adjustment can be performed in two ways:
It is good practice to run the cost adjustment automatically when you post because unit costs are more frequently updated and therefore more accurate. The disadvantage is that the performance of the database can be affected by running the cost adjustment so often.
Because it is important to keep the unit cost of an item up to date, it is recommend that you run the Adjust Cost - Item Entries batch job as often as possible, during nonworking hours. Alternatively, use automatic cost adjustment. This ensures that the unit cost is updated for items daily.
Regardless if you run the cost adjustment manually or automatically, the adjustment process and its consequences are the same. Dynamics NAV calculates the value of the inbound transaction and forwards that cost to any outbound transactions, such as sales or consumptions, which have been applied to the inbound transaction. The cost adjustment creates value entries that contain adjustment amounts and amounts that compensate for rounding.
The new adjustment and rounding value entries have the posting date of the related invoice. Exceptions are if the value entries fall in a closed accounting period or inventory period or if the posting date is earlier than the date in the Allow Posting From field in the General Ledger Setup window. If this occurs, the batch job assigns the posting date as the first date of the next open period.
When you run the Adjust Cost - Item Entries batch job, you have the option to run the batch job for all items or for only certain items or categories.
We recommend that you always run the batch job for all items and only use the filtering option to reduce the runtime of the batch job, or to fix the cost of a certain item.
The following example shows if you post a purchased item as received and invoiced on 01-01-20. You later post the sold item as shipped and invoiced on 01-15-20. Then, you run the Adjust Cost - Item Entries and Post Inventory Cost to G/L batch jobs. The following entries are created.
Value Entries
| Posting Date | Item Ledger Entry Type | Cost Amount (Actual) | Cost Posted to G/L | Invoiced Quantity | Entry No. |
|---|---|---|---|---|---|
| 01-01-20 | Purchase | 10.00 | 10.00 | 1 | 1 |
| 01-15-20 | Sale | -10.00 | -10.00 | -1 | 2 |
Relation Entries in the G/L – Item Ledger Relation Table
| G/L Entry No. | Value Entry No. | G/L Register No. |
|---|---|---|
| 1 | 1 | 1 |
| 2 | 1 | 1 |
| 3 | 2 | 1 |
| 4 | 2 | 1 |
General Ledger Entries
| Posting Date | G/L Account | Account No. (En-US Demo) | Amount | Entry No. |
|---|---|---|---|---|
| 01-01-20 | [Inventory Account] | 2130 | 10.00 | 1 |
| 01-01-20 | [Direct Cost Applied Account] | 7291 | -10.00 | 2 |
| 01-15-20 | [Inventory Account] | 2130 | -10.00 | 3 |
| 01-15-20 | [COGS Account] | 7290 | 10.00 | 4 |
Later, you post a related purchase item charge for 2.00 LCY invoiced on 02-10-20. You run the Adjust Cost - Item Entries batch job and then run the Post Inventory Cost to G/L batch job. The cost adjustment batch job adjusts the cost of the sale by -2.00 LCY accordingly, and the Post Inventory Cost to G/L batch job posts the new value entries to the general ledger. The result is as follows.
Value Entries
| Posting Date | Item Ledger Entry Type | Cost Amount (Actual) | Cost Posted to G/L | Invoiced Quantity | Adjustment | Entry No. |
|---|---|---|---|---|---|---|
| 02-10-20 | Purchase | 2.00 | 2.00 | 0 | No | 3 |
| 01-15-20 | Sale | -2.00 | -2.00 | 0 | Yes | 4 |
Relation Entries in the G/L – Item Ledger Relation Table
| G/L Entry No. | Value Entry No. | G/L Register No. |
|---|---|---|
| 5 | 3 | 2 |
| 6 | 3 | 2 |
| 7 | 4 | 2 |
| 8 | 4 | 2 |
General Ledger Entries
| Posting Date | G/L Account | Account No. (En-US Demo) | Amount | Entry No. | |
|---|---|---|---|---|---|
| 02-10-20 | [Inventory Account] | 2130 | 2.00 | 5 | |
| 02-10-20 | [Direct Cost Applied Account] | 7291 | -2.00 | 6 | |
| 01-15-20 | [Inventory Account] | 2130 | -2.00 | 7 | |
| 01-15-20 | [COGS Account] | 7290 | 2.00 | 8 |
To set up cost adjustment to run automatically when you post an inventory transaction, use the Automatic Cost Adjustment field in the Inventory Setup window. This field enables you to select how far back in time from the current work date that you want automatic cost adjustment to be performed. The following options exist.
| Option | Description |
|---|---|
| Never | Costs are not adjusted when you post. |
| Day | Costs are adjusted if posting occurs within one day from the work date. |
| Week | Costs are adjusted if posting occurs within one week from the work date. |
| Month | Costs are adjusted if posting occurs within one month from the work date. |
| Quarter | Costs are adjusted if posting occurs within one quarter from the work date. |
| Year | Costs are adjusted if posting occurs within one year from the work date. |
| Always | Costs are always adjusted when you post, regardless of the posting date. |
The selection that you make in the Automatic Cost Adjustment field is important for performance and the accuracy of your costs. Shorter time periods, such as Day or Week, affect system performance less, because they provide the stricter requirement that only costs posted in the last day or week can be automatically adjusted. This means that the automatic cost adjustment does not run as frequently and therefore affects system performance less. However, it also means that unit costs may be less accurate.
The following example shows an automatic cost adjustment scenario:
If you have set up the automatic cost adjustment to apply to postings that occur within a month or a quarter from the current work date, then the automatic cost adjustment runs and forwards the cost of the purchase to the sale.
If you have set up the automatic cost adjustment to apply to postings that occur within a day or a week from the current work date, then the automatic cost adjustment does not run, and the cost of the purchase is not forwarded to the sale until you run the Adjust Cost - Item Entries batch job.
How to: Adjust Item Costs
Design Details: Inventory Costing
Design Details: Reconciliation with the General Ledger
Design Details: Inventory Posting
Design Details: Variance
Design Details: Assembly Order Posting
Design Details: Production Order Posting
Managing Inventory Costs
Finance
Working with Dynamics NAV
© 2017 Microsoft. All rights reserved.