How to Troubleshoot Inventory Valuation Issues in Business Central (v27)

Introduction

Inventory valuation errors in Microsoft Dynamics 365 Business Central can lead to serious financial misstatements, compliance issues, and operational confusion. This guide provides a detailed framework for investigating, diagnosing, and resolving these issues. It’s designed for finance managers, controllers, IT administrators, and power users who need a deep technical understanding of how inventory valuation works in Business Central.

1. Typical Causes of Wrong Inventory Values

Misaligned inventory values often arise from a combination of configuration gaps, timing delays, and posting logic issues. Here's a breakdown of the most common causes:

1.1 Timing Differences in Posting

  • Issue: Value Entries may not be immediately posted to G/L due to asynchronous processes.

  • Mechanism: If the “Automatic Cost Posting” or “Automatic Cost Adjustment” settings are disabled or set to delay, discrepancies between inventory subledger and G/L can appear.

  • Prevention: Use the “Inventory - G/L Reconciliation” report regularly and automate cost posting where possible.

1.2 Incorrect Costing Method Configuration

  • Issue: Mismatched costing methods (FIFO, Average, Standard) lead to wrong cost evaluations.

  • Mechanism: Business Central applies different valuation logic per method. Average cost relies on periodic adjustments; FIFO depends on chronological issue handling.

  • Prevention: Ensure each item’s costing method aligns with business process, especially for kits or assemblies.

1.3 Missing or Incomplete Cost Adjustments

  • Issue: Value Entries exist, but no cost adjustments have occurred.

  • Mechanism: The Adjust Cost – Item Entries job updates Value Entries based on actual transaction timing and costing method. Missing this leads to inaccurate costs.

  • Prevention: Schedule Adjust Cost - Item Entries to run regularly, particularly before month-end close.

1.4 Negative Inventory

  • Issue: Posting sales or transfers when no quantity is available creates distorted valuation.

  • Mechanism: The system uses estimated cost until incoming inventory retroactively adjusts it.

  • Prevention: Use Inventory Availability warnings and disable negative inventory if possible.

1.5 Configuration Issues in Item Cards or Posting Groups

  • Issue: Incorrect General Product/Business Posting Groups cause wrong G/L account selection.

  • Mechanism: The General Posting Setup and Inventory Posting Setup define accounts for inventory, COGS, purchase, and adjustments.

  • Prevention: Review posting group assignments periodically and reconcile with G/L account setups.

1.6 Currency and Exchange Rate Impacts

  • Issue: Fluctuations in currency rates between transaction date and posting date lead to valuation gaps.

  • Mechanism: Business Central calculates cost based on local currency. Misalignment in exchange rate application impacts Value Entries.

  • Prevention: Use the Currency Exchange Rate table and periodically revalue entries.

1.7 Dimension Posting Errors

  • Issue: Dimensions missing in Value Entries or G/L entries break segment-based reporting.

  • Mechanism: Dimensions must flow through item ledger, value entry, and G/L posting processes.

  • Prevention: Enable dimension requirements in General Ledger Setup and validate default dimensions.

2. How to Trace Value Entries and Item Ledger Entries

Understanding how transactions flow through Business Central’s data model is key to diagnosis.

2.1 Core Tables and Relationships

Table NameDescription
Item Ledger Entry (32)Records all inventory movements (receipts, issues, transfers).
Value Entry (5802)Stores the cost and G/L link to item ledger entries.
G/L - Item Ledger Relation (5803)Links Value Entries to their G/L postings.

2.2 Navigation Steps

  • Item Ledger Entries: Go to Item > Ledger Entries > Item Ledger Entries

  • Value Entries: Use Navigate > Value Entries from an Item Ledger Entry

  • G/L Impact: Search for “G/L - Item Ledger Relation” in dev environment or use queries to cross-reference Entry No. with G/L Entry No.

2.3 Key Fields

  • Item Ledger Entry No.: Links back to the physical inventory move.

  • Entry Type: Differentiates Sale, Purchase, Adjustment, etc.

  • Cost Posted to G/L: Boolean flag confirming cost post completion.

  • Cost Amount (Actual): Realized cost of the transaction.

2.4 Troubleshooting Techniques

  • Filter Value Entries by Cost Posted to G/L = false to find pending costs.

  • Use Entry Type and Document No. to trace patterns by transaction class.

  • Compare expected vs. actual cost using Adjust Cost logic and history of cost changes.

3. Reconciliation Steps: Inventory to General Ledger

Use the Inventory to G/L Reconciliation process to align subledger values with general ledger totals.

3.1 Running the Report

  • Navigate to Inventory Valuation – G/L Reconciliation

  • Key filters:

    • Date Range

    • Item/Location/Dimension filters

    • Include WIP (if manufacturing is enabled)

3.2 Interpreting the Output

ColumnMeaning
Inventory ValueTotal item value from Value Entries.
Inventory (G/L)Posted G/L balance for inventory accounts.
VarianceDifference = Inventory Value – Inventory (G/L)

3.3 Investigating Variances

  • Drill into variance lines.

  • Compare Cost Amount (Actual) against Amount in G/L Entry.

  • Verify posting group logic via Inventory Posting Setup and Gen. Posting Setup.

3.4 Corrective Actions

ScenarioAction
Cost not posted to G/LRun Adjust Cost - Item Entries then Post Inv. Cost to G/L
Wrong G/L accountFix posting group mapping and post adjusting G/L entries
Transaction posted lateUse posting date filter corrections and memo entries

4. Cost Adjustment: When and Why It Matters

Cost adjustment is critical to accurate inventory valuation in BC. It's responsible for distributing actual costs after indirect effects (like inbound invoices or returns) arrive.

4.1 Core Logic

  • Applies FIFO, Average, or Standard cost principles.

  • Retroactively adjusts outbound transactions to reflect true cost.

  • Can impact COGS, Inventory, or WIP depending on scenario.

4.2 Adjustment Modes

  • Automatic Cost Adjustment: Triggered on posting; limited to selected entry types.

  • Manual Run: Use Adjust Cost - Item Entries from search or batch job.

4.3 Parameter Options

OptionEffect
Item FilterAdjust only selected SKUs
Posting DateCut-off for cost flow adjustments
Calculate per EntryEnables transaction-level granularity

4.4 Posting to G/L

  • Use Post Inventory Cost to G/L batch job after adjustment.

  • Check the Cost Posted to G/L flag for completion.

5. Common Mistakes in Manufacturing Costing

Manufacturing introduces added complexity with work-in-progress (WIP), routings, and capacity costs.

5.1 Cost Rollup Misconfigurations

  • Issue: Production BOMs or Routings are missing cost components.

  • Fix: Run Calc. Standard Cost and roll up new costs before posting production orders.

5.2 Output and Consumption Timing

  • Issue: Output posted without consumption or vice versa.

  • Fix: Use Expected Cost posting setup to bridge temporary valuation.

5.3 Incorrect Capacity Cost Allocation

  • Issue: Routing work centers don’t carry expected overhead.

  • Fix: Check Work Center and Machine Center cost settings.

5.4 WIP Valuation Gaps

  • Issue: WIP is not transferred to Finished Goods correctly.

  • Fix: Close production orders and post all related output and consumption.

5.5 Period-End Finalization

  • Always:

    • Post final cost adjustments

    • Recalculate and roll-up standard costs

    • Reconcile WIP and post final outputs

Appendix: G/L Audit Automation Utility

As part of this guide, a downloadable Business Central AL extension is provided to automate the validation process of inventory valuation postings. This utility includes:

  • A detailed audit report that compares each Value Entry’s expected G/L accounts against the actual G/L accounts posted.

  • A list page for interactive review and filtering of mismatches.

  • A page extension on Value Entries with an action to trigger the audit.

  • Export to Excel functionality for documentation and review.

Download

You can download or contribute to the open-source project here:

🔗 https://github.com/GmsoftLtd/ValueEntryAudit

Comments

Post a Comment

Popular posts from this blog

Understanding Database Indexes in Business Central (and How They Can Help You)

Image
When I first started working with Business Central, the word “indexes” felt too technical for me — like something only developers or database admins cared about. But then I discovered the Database Missing Indexes page . At first, I thought it listed all the indexes that exist in the database. Later, I realized it’s even more interesting: it actually shows the indexes that don’t exist yet, but SQL thinks should be there . That page became a game-changer for me in understanding why some reports and pages are slow, and how I can help point my team toward performance fixes. What Are Indexes, Anyway?  Indexes are like shortcuts. Imagine a giant cookbook with 1,000 recipes. If I want to find every recipe with “chicken,” I don’t flip through each page — I go to the index in the back. Databases work the same way. If I filter a table by Posting Date , an index lets the system jump straight to those rows instead of scanning everything. When no index exists for the filter, the system has to ...
Read more
Image
Dynamics 365 Business Central · Manufacturing · APICS/ASCM Business Central & APICS/ASCM for Manufacturers: A Practical, No‑Nonsense Guide for Consultants, IT Leaders, and Plant Managers By Grigorios Mavrogeorgis · Approx. 15–20 min read Who this is for Business Central consultants who need precise setup guidance. IT decision-makers evaluating ERP fit for manufacturing. Manufacturing managers who want to understand how BC will run their shop—today, not in theory. Table of contents APICS (now ASCM): What It Is and Why It Matters How Closely Business Central Aligns to APICS/ASCM The Three Primary Manufacturing Types—With Real Examples Configuring Business Central for Each Manufacturing Type JIT Manufacturing: Principles and Benefits Implementing JIT in Business Central: A Step‑by‑Step Blueprint End-to-End Configuration Recipes Practical Navigation & Setup Pointers Key Takeaways References 1) APICS (now ASCM): What It Is and Why It Matters APICS...
Read more
  Business Central Costing for Manufacturing — User Manual   Applies to: Microsoft Dynamics 365 Business Central (SaaS & On‑Prem). Screens and labels may vary slightly by version. The concepts are stable across recent versions. Suggested Blogger Labels: Business Central, Dynamics 365, Manufacturing, Costing, Standard Costing, FIFO, Average Costing, Work Centers, Machine Centers, WIP, Variances, Subcontracting, Month-end Close, Reporting 1) What this guide covers A practical, end‑to‑end playbook for setting up costing in Business Central (BC) for manufacturing and allocating costs to work centers and items. It includes: Costing concepts in BC (item costs, capacity costs, overheads, variances) Master data you need (Items, BOMs, Routings, Work/Machine Centers) The minimum viable setup for accurate costing How to allocate costs to work centers and roll them into item costs Posting flows, WIP, and G/L integration Day‑...
Read more