Inventory Valuation and WIP in Business Central: Why CFOs Should Not Rely on One

For manufacturing companies, year-end inventory valuation is rarely straightforward.

Raw materials may still be in stock. Production orders may be partially processed. Some components may already have been consumed, capacity may have been posted, but finished goods may not yet be completed or received into inventory.

This is exactly where many Finance Managers make a dangerous assumption in Microsoft Dynamics 365 Business Central:

“If I run the Inventory Valuation report with expected costs included, I already have the full inventory value.”

In manufacturing scenarios, this assumption can lead to an incomplete view of inventory and work in progress.

Business Central provides two key reports that must be read together:

1. Inventory Valuation — Report 1001


2. Inventory Valuation – WIP / Production Order – WIP — Report 5802

Microsoft states that the Inventory Valuation report can include expected costs when expected cost posting is used, while the WIP report details starting WIP, consumption, capacity, output, and ending WIP for each production order, supporting reconciliation to the WIP balance sheet account.

The key message for CFOs is simple:

To obtain a complete inventory value at period-end, the Inventory Valuation report and the WIP report must be analyzed together.

The business case: raw material, production consumption, and unfinished production

Let’s consider a simple manufacturing scenario.

The company manages:

• 
  Item MP01: raw material, valued at average cost


• 
  Item PF01: finished good, valued at standard cost

A positive adjustment is posted for 100 pieces of raw material at €1 each.

At this point, the raw material inventory value is clear and simple.

Step 1: Raw material receipt and initial inventory valuation

After the positive adjustment, Business Central correctly reflects the raw material value in inventory.

This is usually the part of the process that Finance teams understand well. The quantity exists. The cost exists. The inventory value is visible.

The issue starts when production begins.

Once materials are consumed by a production order, part of the value leaves raw material inventory. But that does not mean the value has disappeared. It has simply moved into production.

This is where WIP becomes essential.

Step 2: Consumption and routing progress without output posting

In the case analyzed, raw material consumption is posted and two production routing operations are advanced. However, no output is posted yet.

From an accounting and controlling perspective, this is a critical moment.

The raw material has been consumed. Labor or capacity may have been posted. But the finished good is not yet available in inventory.

If the Finance team only looks at standard inventory value, it may appear that inventory has decreased.

But economically, part of that value is now sitting in work in progress.

In the example, the inventory value is composed of:

• 
  €80 of remaining raw material inventory


• 
  €22 of WIP value

Total value: €102

The company started from €100 of raw material value. The total value has increased by €2 due to production processing.

This is exactly the type of detail that can be missed when the WIP report is not included in the month-end or year-end closing process.

Why the Inventory Valuation report alone is not enough

The Inventory Valuation report is fundamental. It shows inventory balances, increases, decreases, and values over the selected period. Microsoft also explains that, when expected cost posting is used, the report can include expected costs that reconcile to interim inventory accounts.

However, in a manufacturing process, expected cost does not automatically replace a proper WIP analysis.

This is the common misunderstanding.

The Include Expected Cost option may help include certain expected cost components, but it does not provide the same analytical view as the WIP report for open production orders.

The WIP report is designed specifically to show production order WIP, including consumption, capacity, output, and ending WIP by production order.

For CFOs, the practical implication is clear:

Expected cost is not the same thing as full WIP reconciliation.

Step 3: Final operation and output posting

In the next step, the final production phase is posted and output is registered.

At this stage, Business Central starts showing the finished good in inventory, even if the production order has not yet been fully closed.

In the example, the inventory value can be interpreted as:

• 
  €80 raw material


• 
  €50 finished good


• 
  €23 variance

The presence of expected values and variances must be carefully reviewed because the production order is not yet completely finalized.

This is another point where Finance teams often misread the numbers.

They see the finished good in inventory and assume the valuation is final. But if the production order is still open, the accounting picture may still be temporary.

Step 4: Closing the production order and cost adjustment

When the production order is closed, Business Central performs an alignment process.

Because the finished good is valued at standard cost, the system finalizes the finished product value according to the standard cost setup.

At this point, it is important to run the Adjust Cost – Item Entries batch job.

This step is not optional in a controlled closing process. It ensures item costs are adjusted and value entries are correctly aligned before final reporting.

After the cost adjustment process, the WIP value at the reporting date is updated to zero, because the production order is no longer open. The finished good value becomes definitive, and expected cost is no longer shown.

The key lesson: Inventory Valuation + WIP must be reviewed together

The main conclusion from this case is practical:

For manufacturing companies with open production orders, the year-end inventory value should not be based only on the Inventory Valuation report.

The correct approach is to analyze:

1. 
   Inventory Valuation report
   
   To determine the value of raw materials, components, and finished goods in inventory.


2. 
   Inventory Valuation – WIP report
   
   To determine the value of production orders that are still in progress.

Only by combining these two views can Finance obtain a complete and reliable value for inventory and work in progress.

Practical recommendations for CFOs and Finance Managers

1. Do not close the month using only inventory balances

Inventory balance is not enough in manufacturing. Open production orders may contain material and capacity value that must be reviewed separately.

2. Always identify open production orders at period-end

Before closing the period, Finance should ask Operations for a clear list of production orders that are:

• 
  released


• 
  partially consumed


• 
  partially routed


• 
  with output not yet posted


• 
  technically completed but not financially closed

3. Reconcile WIP before posting final accounting entries

The WIP report should be reconciled to the relevant balance sheet WIP account. This is especially important when production spans across month-end or year-end.

4. Run cost adjustment before final reporting

The Adjust Cost – Item Entries process should be part of the closing checklist. Without it, inventory and production costs may remain incomplete or temporary.

5. Pay attention to standard cost variances

When finished goods are valued at standard cost, variances must be understood and explained. They are not just technical system outputs; they affect margin analysis and management reporting.

A typical mistake: treating expected cost as final cost

One of the most frequent mistakes is relying on expected cost as if it were final cost.

This is risky.

Expected cost can be useful for interim visibility, but Finance must understand what is still temporary, what has been finalized, and what remains in WIP.

In practical terms:

• 
  expected cost helps visibility


• 
  WIP explains unfinished production


• 
  production order closure finalizes the process


• 
  cost adjustment aligns the valuation

Skipping one of these steps can create misleading inventory values.

Conclusion: WIP is not a technical detail — it is a financial control point

For CFOs, WIP valuation in Business Central is not just a manufacturing topic.

It affects:

• 
  inventory valuation


• 
  gross margin


• 
  balance sheet accuracy


• 
  period-end closing quality


• 
  audit readiness


• 
  management reporting

The most important takeaway is this:

In Business Central, the Inventory Valuation report with expected costs included does not eliminate the need to analyze the WIP report.

For manufacturing companies, accurate financial reporting requires a combined reading of inventory value and production WIP.

A reliable closing process should therefore include both reports, clear reconciliation rules, and a disciplined review of open production orders before finalizing the numbers.