Design details: Revaluation

You can revalue the inventory based on the valuation base that most accurately reflects the inventory value. You can also backdate a revaluation to correctly update the cost of goods sold (COGS) for items you've already sold. Items that use the Standard costing method and aren't completely invoiced can also be revalued.

In Business Central, the following flexibility is supported regarding revaluation:

  • The revaluable quantity can be calculated for any date, also back in time.
  • For items using Standard costing method, expected cost entries are included in revaluation.
  • Inventory decreases affected by revaluation are detected.

Calculate the revaluable quantity

The quantity you can revalue is the remaining inventory that's available on a given date. The quantity is the total of completely invoiced item ledger entries that you post on or before the revaluation date.

Note


Items using the Standard costing method are treated differently when calculating the revaluable quantity per item, location, and variant. The quantities and values of item ledger entries that are not completely invoiced are included in the revaluable quantity.

After a revaluation has been posted, you can post an inventory increase or decrease with a posting date that comes before the revaluation posting date. However, this quantity will not be affected by the revaluation. To balance the inventory, only the original revaluable quantity is considered.

Because you can revaluate on any date, you must have conventions for when you consider an item as part of inventory. For example, when the item is on inventory and when the item is work in process (WIP).

Example

The following example illustrates when a WIP item transitions to become part of inventory. The example is based on the production of a chain with 150 links.

[WIP inventory and revaluation.]

1Q: The user posts the purchased links as received. The following table shows the resulting item ledger entry.

Posting DateItemEntry TypeQuantityEntry No.
01-01-20LINKPurchase1501

Note


Now an item using the Standard costing method is available for revaluation.

1V: The user posts the purchased links as invoiced and the links become part of inventory, from a financial point of view. The following table shows the resulting value entries.

Posting DateEntry TypeValuation DateCost Amount (Actual)Item Ledger Entry No.Entry No.
01-15-20Direct Cost01-01-20150.0011

2Q + 2V: The user posts the purchased links as consumed for the production of the iron chain. From a financial point of view, the links become part of WIP inventory. The following table shows the resulting item ledger entry.

Posting DateItemEntry TypeQuantityEntry No.
02-01-20LINKConsumption-1501

The following table shows the resulting value entry.

Posting DateEntry TypeValuation DateCost Amount (Actual)Item Ledger Entry No.Entry No.
02-01-20Direct Cost02-01-20-150.0022

The valuation date is set to the date of the consumption posting (02-01-20), as a regular inventory decrease.

3Q: The user posts the chain as output and finishes the production order. The following table shows the resulting item ledger entry.

Posting DateItemEntry TypeQuantityEntry No.
02-15-20CHAINOutput13

3V: The user runs the Adjust Cost - Item Entries batch job, which posts the chain as invoiced to indicate that all material consumption has been completely invoiced. From a financial point of view, the links are no longer part of WIP inventory when the output is completely invoiced and adjusted. The following table shows the resulting value entries.

Posting DateEntry TypeValuation DateCost Amount (Actual)Item Ledger Entry No.Entry No.
01-15-20Direct Cost01-01-20150.0022
02-01-20Direct Cost02-01-20-150.0022
02-15-20Direct Cost02-15-20150.0033

Expected cost in revaluation

The quantity you can revalue is the sum of the quantity for completely invoiced item ledger entries that you posted on or before the revaluation date. When some items are received or shipped but not invoiced, you can't calculate their inventory value. Items that use the Standard costing method are not limited in this way.

Note


Another type of expected cost that can be revalued is WIP inventory, within certain rules. For more information, see WIP Inventory Revaluation.

When you calculate the revaluable quantity for items that use the Standard costing method, the calculation includes item ledger entries that aren't completely invoiced. These entries are revalued when you post the revaluation. When you invoice the revalued entry, you create the following value entries:

  • The usual invoiced value entry with an entry type of Direct Cost. The cost amount on this entry is the direct cost from the source line.
  • A value entry with an entry type of Variance. This entry records the difference between the invoiced cost and the revalued standard cost.
  • A value entry with an entry type of Revaluation. This entry records the reversal of the revaluation of the expected cost.

Example

The following example is based on the production of the chain in the previous example. This example illustrates how the three types of entries are created, based on the following scenario:

  1. You post the purchased links as received with a unit cost of LCY 2.00.

  2. You post a revaluation of the links with a new unit cost of LCY 3.00, updating the standard cost to LCY 3.00.

  3. You post the original purchase of the chain links as invoiced, which creates the following value entries:

    1. An invoiced value entry with an entry type of Direct Cost.
    2. A value entry with an entry type of Revaluation to record the reversal of the revaluation of the expected cost.
    3. A value entry with an entry type of Variance, recording the difference between the invoiced cost and the revalued standard cost.

The following table shows the results.

StepPosting DateEntry TypeValuation DateCost Amount (Expected)Cost Amount (Actual)Item Ledger Entry No.Entry No.
1.01-15-20Direct Cost01-15-20300.000.0011
2.01-20-20Revaluation01-20-20150.000.0012
3.a.01-15-20Direct Cost01-15-20-300.000.0013
3.b.01-15-20Revaluation01-20-20-150.000.0014
3.c.01-15-20Variance01-15-200.00450.0015

Determine whether revaluation affects an inventory decrease

Use the date of the posting or the revaluation to determine whether an inventory decrease is affected by a revaluation.

The following table shows the criteria that's used for an item that doesn't use the Average costing method.

ScenarioEntry No.TimingAffected by revaluation
AEarlier than revaluation entry numberEarlier than revaluation posting dateNo
BEarlier than revaluation entry no.Equal to revaluation posting dateNo
CEarlier than revaluation entry no.Later than revaluation posting dateYes
DLater than revaluation entry no.Earlier than revaluation posting dateYes
ELater than revaluation entry no.Equal to revaluation posting dateYes
FLater than revaluation entry no.Later than revaluation posting dateYes

Example

The following example illustrates revaluation of an item that uses the FIFO costing method. The example is based on the following scenario:

  1. On 01-01-20, you post a purchase of 6 units.
  2. On 02-01-20, you post a sale of 1 unit.
  3. On 03-01-20, you post a sale of 1 unit.
  4. On 04-01-20, you post a sale of 1 unit.
  5. On 03-01-20, you calculate the inventory value for the item, and post a revaluation of the item’s unit cost from LCY 10.00 to LCY 8.00.
  6. On 02-01-20, you post a sale of 1 unit.
  7. On 03-01-20, you post a sale of 1 unit.
  8. On 04-01-20, you post a sale of 1 unit.
  9. You run the Adjust Cost - Item Entries batch job.

The following table shows the resulting value entries.

ScenarioPosting DateEntry TypeValuation DateValued QuantityCost Amount (Actual)Item Ledger Entry No.Entry No.
01-01-20Purchase01-01-20660.0011
03-01-20Revaluation03-01-204-8.0015
A02-01-20Sale02-01-20-1-10.0022
B03-01-20Sale03-01-20-1-10.0033
C04-01-20Sale04-01-20-1-10.0044
04-01-20Sale04-01-20-12.0049
D02-01-20Sale03-01-20-1-10.0056
02-01-20Sale03-01-20-12.00510
E03-01-20Sale03-01-20-1-10.0067
03-01-20Sale03-01-20-12.00611
F04-01-20Sale04-01-20-1-10.0078
04-01-20Sale04-01-20-12.00712

WIP inventory revaluation

Revaluating WIP inventory implies that you revalue components that are registered as WIP inventory.

It's important to have conventions that control when an item is WIP inventory from a financial point of view. In Business Central, the following conventions exist:

  • A purchased component becomes part of the raw material inventory when you post a purchase as invoiced.
  • A purchased/sub-assembled component becomes part of the WIP inventory when you post its consumption with a production order.
  • A purchased/sub-assembled component remains part of the WIP inventory until you invoice a production order (manufactured item).

The way the valuation date for the value entry of consumption is set follows the same rules as for non-WIP inventory. To learn more, go to Determine whether revaluation affects an inventory decrease.

You can revalue WIP inventory under the following conditions:

  • The revaluation date is before the posting dates of the corresponding item ledger entries of type Consumption.
  • You haven't invoiced the production order.

Caution


The Inventory Valuation - WIP report shows the value of posted production order entries, and might be a little confusing for revalued WIP items.

Revaluate items with the Average costing method

You can only revaluate items that use the Average costing method if Calculate Per is Item.

You can only do revaluation at the end of the period selected in the Average Cost Period field on the Inventory Setup page.

Revaluation won't affect negative transactions in the current month, which is why fully applied inbound entries aren't included either.

Example

This example shows what happens when you calculate the inventory value on the Item Revaluation Journal page. On the Inventory Setup page, Item is chosen in the Average Cost Calc. Type field, and Month is chosen in the Average Cost Period field.

The following table shows item ledger entries for the sample average-cost item, ITEM1.

Posting DateItem Ledger Entry TypeQuantityCost Amount (Actual)Entry No.
25-04-23Purchase55.001
26-04-23Purchase33.002
27-04-23Sale-5-5.003
28-04-23Sale-1-1.004
13-05-23Purchase220.005
17-06-23Sale-6-22.006

The following table shows the result of running the Calculate Inventory Value report with different posing dates.

Posting DateQuantityComment
30-04-232Includes only the remaining quantity from entry 2. Entry 1 is completely applied before the posting date, and entry 5 is after posting date.
31-05-234Includes the remaining quantities from entries 2 and 13.
30-06-230No remaining quantity at posting date.

The result of the following entries will be 0, regardless of the posting date.

Posting DateItem Ledger Entry TypeQuantityCost Amount (Actual)Entry No.
13-05-23Purchase55.001
26-04-23Sale-55.002

Design Details: Inventory Costing
Design Details: Costing Methods
Design Details: Inventory Valuation Managing Inventory Costs
Finance
Work with Business Central

Find free e-learning modules for Business Central here