Every unit sitting in a warehouse lives two separate lives inside D365 F&O at once — keeping both visible is exactly what inventory and warehouse analytics is for. Physically, it is a quantity in a location, something a warehouse worker can count. Financially, it is a cost sitting on the balance sheet, waiting to become cost of goods sold. D365 inventory management exists to keep those two lives in agreement, and most of its real complexity comes from exactly that reconciliation.
This guide will explore how D365 inventory management structures inventory dimensions, calculates inventory valuation across eight distinct costing methods, and reports on-hand inventory once both the physical and financial pictures actually need to match.
Every unit of inventory lives two lives: physical and financial
Not every dimension attached to an item actually affects its valuation. A tracking dimension, such as serial number, can carry a Financial inventory setting that determines whether that dimension is part of the cost calculation or purely a physical tracking detail.
- Turn Financial inventory off for serial number tracking, and every serial number of the same item shares one common valuation instead of being costed individually.
- Turn it on, and the system tracks cost at the serial level, useful for high-value, individually distinct items where two units of the same product genuinely cost different amounts.
This single setting is where D365 inventory management quietly draws the line between what warehouse staff track for physical accuracy and what finance actually needs for valuation.
The distinction sounds abstract until it shows up in a real discrepancy. A warehouse team confident that every serial number is accounted for physically can still hand finance a valuation that does not match, simply because Financial inventory was configured differently than the physical tracking setup implies. Neither side is wrong. They are answering two different questions that D365 inventory management happens to store on the same item record.
Inventory dimensions: what makes a unit specific enough to value
Product dimensions
Product dimensions describe the item itself independent of where it sits: color, size, style, or configuration. Two units differing only by product dimension are still, from a physical standpoint, distinct enough to track separately.
Storage dimensions
Storage dimensions describe where a unit physically is: site, warehouse, location, and further detail depending on warehouse configuration. These dimensions matter most for on-hand inventory visibility rather than valuation itself.
Tracking dimensions
Tracking dimensions, batch and serial number, are where the Financial inventory setting actually lives. A batch-tracked item with Financial inventory enabled can be valued batch by batch, which matters when input costs genuinely vary from one batch to the next.
Three dimension types, each configured separately, all feeding into one valuation. The Metrixs analytics suite is what keeps that structure visible in reporting instead of buried in setup.
Inventory valuation: eight costing methods, one real divide
D365 inventory management supports eight costing methods: FIFO, LIFO, Weighted average, Weighted average date, LIFO date, Standard cost, Moving average, and Non-valuated. Each is configured at the item model group level, not per transaction, so every item assigned to a group inherits the same valuation logic.
- Moving average, Standard cost, and Non-valuated are perpetual: no adjustment posts at inventory close, because the cost is either continuously recalculated or fixed by definition.
- FIFO, LIFO, Weighted average, Weighted average date, and LIFO date all post an adjustment at close, since the inventory close process matches issue transactions to receipt transactions and settles the actual cost only once that matching completes.
Getting this wrong usually traces back to that divide. A team expecting a moving average item to behave like FIFO at close, waiting for an adjustment that was never going to post, will spend real time investigating a discrepancy that is not actually an error.
On-hand inventory: what is actually visible right now
On-hand inventory shows current quantity by the full combination of product, storage, and tracking dimensions active on an item, so the same product in two warehouses, or two batches of the same item, appear as genuinely separate on-hand positions rather than one blended total.
- A quantity can be on-hand physically before it is on-hand financially, or after, depending on whether physical or financial posting happens first for a given transaction type.
- Reading on-hand inventory without knowing whether a number reflects physical or financial status is the single most common source of a warehouse-to-finance disagreement about what is actually in stock.
D365 inventory management surfaces both views, but rarely on the same screen at the same time. A warehouse manager checking on-hand quantity for a replenishment decision and a controller checking on-hand value for a balance sheet close are usually looking at two different pages, built for two different questions, despite both pulling from the same underlying transactions.
If physical and financial on-hand numbers keep disagreeing, a Metrixs consulting review can trace exactly where the two postings diverge.
Stock movements: keeping both tracks in sync
Every stock movement- a receipt, an issue, a transfer, an adjustment- posts on both the physical and financial sides, though not always at the same moment. The inventory close process is what finally settles issues against receipts and locks in the actual cost for periodic valuation methods.
- Inventory reversal reopens an already-closed period by posting an equal and opposite entry, used when a transaction needs to go into a period that has technically already settled.
- Inventory revaluation applies specifically to perpetual valuation models, moving average or standard cost, adjusting the on-hand value directly rather than waiting for a close process that, for those methods, was never going to touch it.
Transfers deserve a specific mention among stock movements, since a transfer between warehouses can be purely physical, purely financial, or both, depending on whether the two warehouses sit in the same legal entity and share the same valuation setup. A transfer that looks simple on a packing slip can carry real accounting complexity underneath it once inventory dimensions and costing methods differ between the source and destination.
Inventory value reports: where the two tracks get reconciled
D365 F&O does not leave reconciliation to guesswork. Inventory value reports show both physical and financial quantities and amounts, cost of goods sold or work in process values, filterable by item, time range, and inventory dimensions.
- Only dimensions with Financial inventory enabled actually show values on these reports, which is the same setting from earlier in this guide surfacing again at reporting time.
- These reports reconcile the general ledger to inventory for a chosen period, but they are built for that period, not for a multi-year trend across several fiscal years at once.
D365 inventory management treats reconciliation as a periodic exercise by design, correct for closing one month or one quarter, less suited to answering a question that spans several years of valuation history without someone assembling the periods manually one at a time.
| What you need | Native D365 F&O tools | A dedicated layer such as Metrixs |
|---|---|---|
| Multi-year inventory valuation trend | One period’s inventory value report at a time | Configurable history in one saved view |
| Physical vs. financial on-hand, side by side | Separate postings, reconciled manually | One reporting layer across both |
| Cross-entity on-hand visibility | Assembled entity by entity | Consolidated across entities automatically |
| Refresh | As current as the last inventory close | 15 to 30 minutes via Synapse Link |
How Metrixs extends D365 inventory management reporting
Metrixs reads inventory transactions, on-hand positions, costing configuration, and dimension data through Azure Synapse Link into the same dedicated Azure Data Lake used for the rest of D365 F&O, built across more than 6,000 backend tables.
- Inventory valuation held as configurable history, so a multi-year trend by item, warehouse, or costing method is a saved report, not a rebuilt export.
- Physical and financial on-hand inventory shown together, closing the gap that causes most warehouse-to-finance disagreements.
- Cross-entity inventory visibility consolidated automatically, including across a multi-entity or multi-ERP environment.
- Refresh every 15 to 30 minutes, inside the same 12-module, 100+ report, 1,000+ metric suite; most deployments live in under 6 weeks; client ROI 290% to 450%.
D365 inventory management still tracks and values every unit correctly on its own. Metrixs is where physical and financial inventory finally sit in one connected view instead of two reconciled by hand.
Physical on-hand and financial valuation, by warehouse, by item, by period, in one place. See what that looks like in the D365 F&O finance and accounting analytics use case.
Frequently asked questions
What costing methods does D365 inventory management support?
D365 inventory management supports eight costing methods: FIFO, LIFO, Weighted average, Weighted average date, LIFO date, Standard cost, Moving average, and Non-valuated. Each is set at the item model group level, so every item assigned to that group shares the same inventory valuation logic.
What is the Financial inventory setting in D365 F&O?
Financial inventory is a setting on tracking dimension groups, such as batch or serial number, that determines whether that dimension affects cost calculation or is tracked physically only. In D365 inventory management, turning it off means all units of an item share one valuation regardless of batch or serial differences.
Why do some costing methods not post an adjustment at inventory close?
Moving average, Standard cost, and Non-valuated are perpetual methods in D365 inventory management, meaning cost is continuously recalculated or fixed rather than settled through the close process. FIFO, LIFO, and the weighted average variants post an adjustment because they rely on matching issues to receipts during close.
What are inventory dimensions in D365 F&O?
D365 inventory management organizes inventory dimensions into three types: product dimensions such as color or size, storage dimensions such as site or warehouse, and tracking dimensions such as batch or serial number. Together they determine how specifically a unit of inventory is tracked and, depending on the Financial inventory setting, valued.
Why might on-hand inventory differ between physical and financial views?
Physical and financial postings for the same stock movement do not always occur at the same moment, so a quantity can be on-hand physically before or after it is on-hand financially. In D365 inventory management, reading on-hand inventory without accounting for this gap is a common source of warehouse-to-finance disagreement.
What do inventory value reports show in D365 F&O?
Inventory value reports show physical and financial quantities and amounts, including cost of goods sold and work in process values, filterable by item, time range, and inventory dimensions with Financial inventory enabled. They reconcile the general ledger to inventory for a chosen period.
The verdict
D365 inventory management genuinely handles the mechanics: inventory dimensions that define what makes a unit distinct, eight inventory valuation methods with a clear perpetual-versus-periodic divide, and inventory value reports that reconcile the general ledger to physical stock.
Where it stops is the multi-year, cross-entity view: physical and financial on-hand held as history, compared across warehouses and legal entities at once. Metrixs closes that gap, reading the same transactions and valuations, refreshing every 15 to 30 minutes, and shipping it as part of the same suite that already covers general ledger, budgeting, and procurement.
Ready to see your own physical and financial inventory as one connected view? Book a Metrixs reporting assessment, and we will map your inventory dimensions and costing setup against what the reporting layer already covers.
Related reading: Warehouse management in D365 F&O: use cases from receiving to shipping
