Many users struggle to understand how inventory transactions flow into the General Ledger (GL) in Microsoft Dynamics 365 Business Central. This blog aims to break down the process and explain the key concepts so you can confidently manage inventory and financial reconciliation.
Why Inventory Posting Matters
Inventory transactions—such as purchase receipts, sales shipments, and adjustments—impact both physical stock and financial value. Business Central ensures these changes are reflected in two places:
- Item Ledger Entries: Track quantity or stock changes.
- Value Entries: Track monetary value and cost changes.
These entries form the foundation for posting to the General Ledger, ensuring accurate financial reporting.
The Flow of Transactions
When you post an inventory-related document (e.g., a purchase order or sales invoice), Business Central creates:
- Item Ledger Entries for quantity changes.
- Value Entries for cost changes.
- Item Application Entries to link inbound and outbound transactions for cost flow.
At regular intervals—or automatically if configured—these value entries are posted to the GL to reconcile inventory with financial accounts. This step is critical for accurate COGS, inventory valuation, and compliance.
Key Accounts and Posting Groups
Posting groups map transactions to the correct GL accounts:
- Inventory Posting Group: Determines which inventory accounts are used.
- General Business Posting Group: Defines accounts based on customer/vendor type.
- General Product Posting Group: Defines accounts based on item type.
These groups combine in the General Posting Setup to specify accounts for inventory, adjustments, and COGS. Proper setup avoids reconciliation issues and ensures transparency.
Automatic vs. Manual Posting
- Automatic Cost Posting: Posts inventory costs to the GL as soon as transactions occur.
- Manual Posting: Requires running the Post Inventory Cost to G/L batch job. Before doing this, run Adjust Cost – Item Entries to ensure costs are up to date.
Tip: If you enable Expected Cost Posting, interim accounts will reflect expected costs until invoices are posted.
Example Scenario
Purchase Order:
- Receive and invoice 10 items at LCY 7 each, plus LCY 1 overhead.
- Item Ledger Entry: Quantity +10, Cost Amount 80.
- Value Entries: Direct Cost 70, Indirect Cost 10.
Sale:
- Ship 10 items.
- Item Ledger Entry: Quantity -10, Cost Amount -80.
- Value Entry: Direct Cost -80.
These entries then flow to GL accounts for inventory and COGS based on posting group setup.
Best Practices
- Regularly run Adjust Cost – Item Entries to keep costs accurate.
- Use Post Inventory Cost to G/L to reconcile ledgers.
- Review posting group configurations to prevent mismatches.
- Leverage reports like Inventory Valuation and Reconciliation for audit and compliance.
Further Reading