In D365 F&O, production accounting follows a “Physical” vs. “Financial” update logic. Temporary “Estimated” entries are posted during the process and are fully reversed and replaced by “Actual” entries when the production order is Ended.
- Material and Route Consumption (The WIP Phase) When you post a Picking List (Materials) or a Route Card (Labor/Machine time), D365 records the value of these resources in Work in Progress (WIP) accounts.
Material Consumption ($25,550,000): This represents the raw materials taken from the warehouse and moved into the production floor.
Route Consumption ($5,250,000): This is the cost of labor or machine hours applied.
Debit 150200 (WIP-Labor): Increases the value of the “unfinished” product.
Credit 600500 (Direct Labor Applied): This is an Absorption Account. It offsets the payroll expenses already recorded in the General Ledger, showing that the labor was “absorbed” into a product rather than just being a period expense.
- Report as Finished (The Physical Phase) The Report as Finished (RAF) stage signifies that the items are physically complete and sitting in the Finished Goods (FG) warehouse, even though the final “Financial” cost hasn’t been locked in yet.
Debit 140200 (Finished Goods Inventory): Increases inventory at an Estimated cost (usually based on the BOM/Route estimation or standard cost).
Credit 150150 (Production WIP): Reduces the WIP account, moving the value out of “Work in Progress” and into “Finished Goods.”
Amount $30,200,750: This is your total estimated manufactured cost (Materials + Labor + Indirects).
- Indirect Costs ($200,750) These are overheads (e.g., electricity, depreciation, or rent) calculated via the Costing Sheet.
The system uses Estimated indirect cost absorbed (600510) as an offset to pull these “invisible” costs into the product’s value.
- Production Control / Ending (The Settlement Phase) The voucher PCV-14187 is the most critical. It occurs when you change the production order status to Ended. This process performs three main actions:
Reverses all Physical/Estimated entries: You see $30,200,750 being credited back out of FG Inventory to “clear the slate.”
Clears WIP: All temporary WIP accounts (150150, 150200, 150250) are zeroed out.
Posts Final Financial Cost: The system calculates the Actual cost ($31,000,750).
Why is there a difference?
Estimated Cost: $30,200,750
Final Cost accounted: $31,000,750
Analysis: The $800,000 difference is a Production Variance. This happens if you consumed more material than planned, if labor took longer, or if the unit price of raw materials changed between the time you started and finished the order.
- The Root Cause: Material Usage Variance The entire $800,000 variance comes from a single raw material: MS-RM-101 (Cost Group: RM-RAM).
Estimated Consumption: 1,000 units
Realized Consumption: 1,050 units
Variance in Quantity: 50 units (Over-consumption)
Because the unit price for this item is $16,000 ($16,000,000 ÷ 1,000), the 50 extra units consumed resulted in an additional cost of $800,000. In Dynamics 365, this is classified as a Quantity Variance or Usage Variance. It suggests that the production process was less efficient than planned for this specific component—perhaps due to scrap, rework, or a calculation error in the BOM.
The Picking List is where the $800,000 “leakage” occurred. In D365 F&O, this journal records the physical movement of raw materials from the warehouse to WIP.
The Culprit (MS-RM-101): * The Plan: 1,000 units at $16,000/unit.
The Reality: 1,050 units were “picked” and posted.
Financial Impact: As soon as this journal was posted, the system debited WIP-Materials (150150) for $16.8M instead of the estimated $16M.
The Others: Items MS-RM-102 through MS-RM-105 were posted exactly at their estimated quantities.
- Areas of Zero Variance It is equally important to note the areas where the production was perfectly aligned with the estimate:
Other Materials: Items MS-RM-102 through MS-RM-105 had zero variance. The realized consumption and costs exactly matched the estimates.
Route/Labor Efficiency: * OP-ASS (Assembly): Took exactly the 50 hours estimated.
OP-PCK (Packing): Took exactly the 25 hours estimated. Since the hours and the hourly rates matched, there was no Substitution or Efficiency Variance for labor.
Indirect Costs (Overheads):
Electricity and Machine Depreciation were “Output unit based.” Since the final good quantity (500 pcs) matched the estimated quantity, these overheads were applied exactly as planned.
For auditors, having a clear, documented breakdown of why a $30.2M estimate became a $31M actual cost is crucial. Dynamics 365 Finance & Operations provides specific tools to extract this exact “Standard vs. Realized” comparison.
Here is how you can pull these details, offering both a quick on-screen analysis and a formal report for your audit trail.
Method 1: The Quick On-Screen View (Best for Ad-Hoc Analysis) Before running a full report, you can view the exact breakdown directly on the production order. This is typically the fastest way to investigate a variance before answering auditor questions.
Navigate to Production control > Production orders > All production orders.
Select your specific production order (e.g., PRO-001648).
On the Action Pane, go to the Manage costs tab.
In the Costing group, click on View calculation details.
Select the Overview costing tab.
What you will see: This form provides a side-by-side grid of Estimated consumption/cost versus Realized consumption/cost. If you filter this grid by your specific Cost Group (e.g., RM-RAM), the $800,000 variance for the 50 extra units of MS-RM-101 will be immediately visible and highlighted.
Method 2: The “Cost Estimates and Costing” Report (Best for Auditors) When auditors request a formal document showing the financial settlement of the production order, this is the standard report to generate.
Navigation: Go to Production control > Inquiries and reports > Costing > Cost estimates and costing.
Recommended Parameter Setup: When the report dialog opens, set the following parameters to ensure the data is clean and focused:
Records to include: Click Filter and set the Production field to your specific order number (PRO-001648).
Level of detail: Set to Item and resource (or Cost group if the auditors prefer to see it summarized by Material vs. Labor vs. Overhead).
Include estimated cost: Yes (This is your $30,200,750 baseline).
Include realized cost: Yes (This is your $31,000,750 actual).
Show variances: Yes (This forces the report to calculate and display the exact delta column).
How to Guide the Auditors Through the Report When you hand this PDF to the auditors, you can direct their attention to how the system classifies the variance:
The Baseline: Show them the Estimated Cost column matching the $30,200,750 originally posted to Finished Goods (Account 140200) during the “Report as Finished” stage.
The Variance: Point them to the specific line for item MS-RM-101. The report will clearly show a Quantity Variance of 50 units, resulting in an unfavorable cost variance of $800,000.
The Settlement: Explain that voucher PCV-14187 (from your initial data) is the financial result of this exact report. The system took the total realized cost ($31,000,750) and used it to reverse the estimates and settle the Work in Progress (WIP) accounts to zero.
By providing both the posting profile extraction and this specific variance report, your auditors will have a complete, traceable map of the entire $31M production cycle.
| S.No | Posting Type | Account | Account Name | Nature of Transaction | Setup Navigation Path |
|---|---|---|---|---|---|
| 1 | Estimated cost of materials consumed | 140100 | Raw Materials Inventory | Physical Update: Reduces raw material inventory value at the Picking List stage. | Inventory management > Setup > Posting > Posting > Production tab |
| 2 | Estimated cost of materials consumed, WIP | 150150 | Production WIP-Materials | Physical Update: Offsets the raw material issue; holds the value in WIP. | Inventory management > Setup > Posting > Posting > Production tab |
| 3 | Estimated manufactured cost | 140200 | Finished Goods Inventory | Physical Update: Increases finished goods value at the Report as Finished (RAF) stage. | Inventory management > Setup > Posting > Posting > Production tab |
| 4 | Estimated manufactured cost, WIP | 150150 | Production WIP-Materials | Physical Update: Offsets the RAF entry; reduces the material value in WIP. | Inventory management > Setup > Posting > Posting > Production tab |
| 5 | Cost of materials consumed | 140100 | Raw Materials Inventory | Financial Update: Reverses the physical entry and posts the final actual material cost. | Inventory management > Setup > Posting > Posting > Production tab |
| 6 | Cost of materials consumed, WIP | 150150 | Production WIP-Materials | Financial Update: Reverses physical WIP and performs final financial settlement of materials. | Inventory management > Setup > Posting > Posting > Production tab |
| 7 | Manufactured cost | 140200 | Finished Goods Inventory | Financial Update: Reverses the RAF physical entry and posts the final actual cost of the product. | Inventory management > Setup > Posting > Posting > Production tab |
| 8 | Manufactured cost, WIP | 150150 | Production WIP-Materials | Financial Update: Final financial settlement of the product WIP value. | Inventory management > Setup > Posting > Posting > Production tab |
| 9 | Estimated cost of manufacturing consumed, WIP | 150200 | Production WIP-Labor | Physical Update: Records the labor/resource value in WIP at the Route Card stage. | Production control > Setup > Routes > Cost categories (Ledger tab) |
| 10 | Estimated manufacturing cost absorbed | 600500 | Direct Labor Applied | Physical Update: Offset account that "absorbs" labor costs into the product value (P&L). | Production control > Setup > Routes > Cost categories (Ledger tab) |
| 11 | Estimated cost of indirect cost consumed, WIP | 150250 | Production WIP-Overhead | Physical Update: Records overheads (e.g., electricity) in WIP via the Costing Sheet. | Inventory management > Setup > Costing > Costing sheets (Node setup) |
| 12 | Estimated indirect cost absorbed | 600510 | Absorbed Machine Depreciation Cost | Physical Update: Offset account that "absorbs" overhead costs into the product value (P&L). | Inventory management > Setup > Costing > Costing sheets (Node setup) |
| 13 | Cost of manufacturing consumed, WIP | 150100 | Production WIP-Clearing | Financial Update: Clears the temporary labor WIP and settles it into the finished product. | Production control > Setup > Routes > Cost categories (Ledger tab) |
| 14 | Manufacturing cost absorbed | 600500 | Direct Labor Applied | Financial Update: Reverses physical absorption and records the final actual labor absorption. | Production control > Setup > Routes > Cost categories (Ledger tab) |
| 15 | Cost of indirect cost consumed, WIP | 150100 | Production WIP-Clearing | Financial Update: Clears the temporary overhead WIP and settles it into the finished product. | Inventory management > Setup > Costing > Costing sheets (Node setup) |
| 16 | Indirect cost absorbed | 600510 | Absorbed Machine Depreciation Cost | Financial Update: Reverses physical absorption and records final actual overhead absorption. | Inventory management > Setup > Costing > Costing sheets (Node setup) |