The item ledger in Microsoft Dynamics 365 Business Central is the master record of every stock movement in the system. Every sale, purchase, transfer, production consumption, assembly and adjustment is recorded as a permanent item ledger entry. It is the inventory equivalent of the general ledger: an immutable audit trail of every transaction that has affected stock quantity and value. Inventory valuations and cost of goods sold calculations both derive from the item ledger.
How the item ledger works in Business Central
Every time stock moves, whether through a sales shipment, purchase receipt, production output, warehouse transfer or physical adjustment, Business Central creates item ledger entries recording the item, quantity, location, date, document reference and value. Entries are permanent and cannot be deleted. Corrections require reversal or adjustment entries. The item ledger feeds the inventory valuation report, the cost of goods sold in the GL and all stock-related reports.
Item ledger in practice
- A warehouse manager traces exactly when a batch of components was received, which purchase order it came from, which production order consumed it and when the finished goods shipped, providing full end-to-end traceability.
- A finance director uses the inventory valuation report, derived from item ledger entries, to confirm closing stock value for month-end accounts.
- A stock controller investigates an inventory discrepancy using the item ledger, identifying a goods receipt posted to the wrong location code.
- An auditor reviews item ledger entries to verify that cost of goods sold in the P&L reconciles to stock movements, providing assurance on inventory valuation.
How Advantage ensures item ledger accuracy in Business Central
Accurate item ledger data depends on correct item setup, including costing method and unit of measure, disciplined posting processes and proper use of locations. Advantage configures these settings during implementation and trains warehouse teams to post transactions correctly, preventing the discrepancies that undermine inventory control.
Frequently asked questions
What is the difference between item ledger entries and value entries?
Item ledger entries record the quantity movements of stock. Value entries record the financial cost associated with each movement. Together they give the complete physical and financial inventory picture in Business Central.
Why does my inventory valuation not match the balance sheet?
Discrepancies usually mean stock transactions have not been adjusted to the general ledger, or that the costing method is incorrectly configured. Advantage provides inventory reconciliation reviews to identify and resolve these issues.
Can a wrongly posted item ledger entry be corrected?
Item ledger entries are permanent and cannot be edited or deleted. Corrections are made by posting reversing entries. Business Central provides undo functions for some document types that create the required reversing entries automatically.
