Inventory Management in Business Central

Inventory management is the part of an ERP where two very different disciplines have to agree with each other. The warehouse cares about physical quantities, bins and pick lists. Finance cares about valuation, cost of goods sold and the balance sheet. Business Central sits in the middle and refuses to let those two views drift apart, because in Business Central inventory quantity and inventory value are the same transactions seen from two angles. Understand that single idea and most of the system stops feeling mysterious. Miss it, and you spend your implementation firefighting reconciliation differences you never understood the source of. This guide walks the whole surface, from how items are modelled to how a revaluation flows into the ledger, in the honest, practitioner-level detail I wish more documentation offered.

The message up front: in Business Central, inventory is not a spreadsheet of quantities that finance reconciles to separately. Every receipt, shipment, adjustment and revaluation posts item ledger entries and value entries together, and those value entries are what the general ledger sees. Quantity and money are one flow. The costing method you pick and the accuracy of your postings are not warehouse details, they are financial statement decisions.

1. What inventory management covers in Business Central

Inventory management in Business Central is broader than most people expect when they first open the application. At its narrowest it is the item card, the quantity on hand, and the movements that change that quantity. At its full width it reaches into purchasing, sales, warehousing, manufacturing, planning and finance, because inventory is the shared object that all of those functions act upon. When a purchase order is received, inventory goes up and a liability is recorded. When a sales order is shipped, inventory goes down and cost of goods sold is recognised. When a production order consumes components and outputs a finished good, inventory transforms from one set of items into another. Every one of those events is an inventory transaction underneath.

The engine at the centre of all of this is the item ledger. Every physical movement of a tracked item creates an item ledger entry that records what moved, how much, when, in which direction, at which location, and against which document. Alongside each item ledger entry, Business Central posts one or more value entries that carry the money: the cost of the goods, any expected or actual cost, and eventually the adjustments that settle the final cost once all the pieces are known. This dual structure, item ledger entries for quantity and value entries for money, is the backbone. Reports, valuation, cost of goods sold and inventory reconciliation all read from it.

It is worth being clear about what inventory management is not, so you scope it correctly. It is not order processing itself; sales and purchase documents drive inventory but live in their own areas. It is not warehouse execution in the narrow sense; the warehouse module adds bins, pick and put-away on top of inventory when you need them. And it is not planning; the requisition and planning worksheets calculate what to buy or make, then hand the result back to the order and inventory layers to execute. Inventory management is the shared foundation those functions stand on. For the wider tour of how these modules fit together, see the complete guide to Business Central features.

2. Items, item categories, variants and units of measure

Everything in inventory starts with the item card. An item in Business Central can be one of a few types, and choosing correctly at setup time saves a great deal of pain later. An Inventory item is a physical thing you hold stock of and value on the balance sheet. A Service type item represents labour or time and carries no stock. A Non-Inventory item is something you buy and sell but deliberately do not track quantities or value for, useful for consumables and pass-through goods you do not want cluttering the item ledger. Getting this distinction right matters because only inventory items generate the ledger entries and valuation behaviour the rest of this guide describes.

Beyond the item card itself, Business Central gives you several layers of structure to keep a large catalogue organised and to drive default behaviour:

• Item categories group items into a hierarchy and can carry default posting setups and attributes, so a new item added to a category inherits sensible defaults rather than being configured from scratch. Categories are the backbone of a tidy catalogue and of meaningful reporting by product group.
• Item attributes let you describe items with structured, searchable properties such as colour, size, material or voltage, without inventing a custom field for every characteristic. Attributes are filterable, which makes finding the right item in a large catalogue far quicker.
• Item variants are versions of the same base item that share a number but differ in some dimension, classically colour or size. Variants let you track stock separately per version while keeping one item definition, one description and one set of posting rules. A shirt in three colours is one item with three variants, not three items.
• Units of measure define how an item is counted and converted. Every item has a base unit of measure, the smallest unit the ledger records in, plus any number of alternative units with conversion factors, so you can buy in pallets, stock in boxes and sell in each, all resolving back to the base unit.

The unit of measure design deserves a moment of care, because it is where quiet errors creep in. Business Central always stores quantities internally in the base unit of measure. If you set the base unit to "box" and later need to sell single pieces, you are stuck with fractional boxes and rounding headaches. My rule is to set the base unit to the smallest unit you will ever transact in, then define purchase and sales units above it. Correcting a base unit after transactions exist is painful, so it is one of the few decisions genuinely worth slowing down for at setup.

3. Costing methods explained and how to choose

Costing method is the single most misunderstood setting in Business Central inventory, and it is set per item, on the item card, which means different items can use different methods in the same company. The costing method decides how Business Central assigns cost to goods as they leave inventory, which in turn decides the value of what remains and the cost of goods sold that hits the income statement. Getting it right is a finance decision as much as an operational one, and it is hard to change once transactions exist. Business Central offers five methods.

• FIFO (first in, first out): the oldest cost layers are consumed first when goods are issued. In a rising-cost environment FIFO leaves the newest, higher costs in stock and charges the older, lower costs to cost of goods sold. It mirrors the physical reality of most warehouses, which rotate stock oldest-first anyway, and it is a sound default for a great many businesses.
• LIFO (last in, first out): the most recent cost layers are consumed first. LIFO charges the newest costs to cost of goods sold and leaves older costs in stock. It is disallowed under IFRS and increasingly rare, so unless you have a specific, defensible reason and an accounting framework that permits it, avoid LIFO.
• Average: Business Central calculates a weighted average unit cost across the units on hand and applies that average to issues. The average is recalculated as new receipts arrive, within a defined valuation period and, importantly, per location and variant. Average smooths out cost fluctuations and is a strong choice for items where individual cost layers are not meaningful, such as commodities or bulk goods bought at fluctuating prices.
• Standard: each item carries a predetermined standard cost, and all issues post at that standard. The difference between standard and the actual purchase or production cost is captured as a variance, which is exactly the point: standard costing exposes purchase price and manufacturing variances for analysis. It is the classic method for manufacturing environments that manage by variance, but it demands discipline to maintain the standards and to review variances regularly.
• Specific: cost is tracked per individual unit or lot via item tracking, so each specific item carries its own exact cost from receipt to issue. This is the method for serialised, high-value or uniquely-costed goods, vehicles, machinery, jewellery, where every unit genuinely has its own cost and averaging would be meaningless. It requires item tracking to be in use.

Insight from the field: the most common costing mistake I see is treating the choice as an operational preference when it is a financial policy. FIFO and Average are the two you will use most; FIFO when cost layers and stock rotation matter, Average when you want a smoothed cost and do not care about individual layers. Reserve Standard for real manufacturing variance analysis and Specific for genuinely unique units. And whichever you pick, remember it is effectively permanent per item, because the method interacts with every historical layer. Changing it later is a data migration, not a settings tweak.

One nuance that trips people up: regardless of method, Business Central often posts an item's cost as an expected cost at the moment of shipment or receipt, then adjusts it to the final actual cost later, once invoices are posted and the cost adjustment routine runs. This is why an item can show one cost immediately after shipping and a slightly different one after the periodic adjust cost process. It is not an error; it is the system settling to the true cost as all the inputs arrive. Running the adjust cost routine regularly, and posting inventory cost to the general ledger, is what keeps the ledger truthful.

4. Locations and the choice between basic and advanced warehousing

A location in Business Central represents a physical place where you hold stock: a warehouse, a shop, a van, a third-party site. Inventory is always tracked per location, so quantity on hand is really quantity on hand at a location, and costing under the Average method is calculated per location as well. Even the simplest multi-site business benefits from modelling its sites as separate locations, because it turns "how much do we have" into "how much do we have, and where", which is the question that actually drives replenishment and fulfilment.

The bigger decision is how much warehouse sophistication each location needs, and Business Central lets you dial this up per location rather than forcing one model on the whole company. At the simple end, a location has no bins and no separate warehouse documents: receiving and shipping happen directly on the purchase and sales orders, and inventory moves the moment you post. At the advanced end, a location uses bins, directed put-away and pick, and dedicated warehouse documents that separate the physical handling from the financial posting. In between sits a middle ground where you use bins and warehouse receipts or shipments but not the full directed workflow.

The practitioner's guidance is to enable only as much warehouse complexity as the physical operation genuinely needs. A small store with staff who know where everything is does not need directed bin logic; forcing it on them adds steps and friction for no benefit. A large distribution centre with thousands of bins and multiple pickers per zone needs the structure or it descends into chaos. Business Central lets each location choose its own level, which is exactly the right design, so match the setting to the site, not to an aspiration. Because warehousing is a deep topic of its own, from receipts and put-aways to picks, movements and cross-docking, I have written it up separately; see the dedicated Business Central warehouse management guide for the full treatment.

5. Item tracking: lot and serial numbers

Item tracking is how Business Central follows individual units or batches through inventory using serial numbers and lot numbers. A serial number identifies a single unique unit, one physical thing you can trace from receipt to sale. A lot number identifies a batch that shares an origin, a production run or a supplier delivery, and moves as a group. You configure tracking through an item tracking code assigned to the item, and that code decides whether serial or lot tracking is required on inbound movements, outbound movements, or both.

Item tracking earns its cost in specific situations rather than universally. Regulated industries such as pharmaceuticals, food and medical devices need lot traceability for recall and compliance: if a batch is defective, you must be able to find every place it went. High-value or warranty-bearing goods need serial tracking so you can trace an individual unit's history and honour or reject a warranty claim. Items with expiry dates use lot tracking combined with expiration handling so the system can enforce first-expiry-first-out picking. Where none of those pressures exist, item tracking adds handling overhead at every receipt and shipment for little return, so it is a capability to apply deliberately, not by default.

The honest trade-off: item tracking is powerful but it is not free. Every receipt, transfer and shipment of a tracked item now requires the operator to assign or select the correct serial or lot, and if the warehouse discipline is weak, you get tracking data that is present but wrong, which is worse than no tracking at all because it looks authoritative. Before switching on serial or lot tracking, be honest about whether the floor operation can sustain the discipline it demands. Tracking you cannot trust does not satisfy an auditor and it does not help a recall.

6. Reordering and replenishment

Holding the right amount of stock, enough to serve demand without tying up cash in shelves that do not move, is the operational heart of inventory management, and Business Central drives it through replenishment parameters set on each item. The item can be replenished by purchase, by production, by assembly or by transfer from another location, and the reordering parameters tell the planning engine how much and when.

The core parameters are grouped into reordering policies, and understanding the main ones keeps you from either starving the warehouse or drowning it in excess:

• Reorder point: the quantity at which replenishment should be triggered. When projected available stock falls to the reorder point, the planning engine proposes a new supply order. The reorder point should cover expected demand across the replenishment lead time plus a safety buffer, so stock does not run out while the resupply is in transit.
• Maximum inventory: used with the maximum-quantity reordering policy, this is the ceiling the system replenishes back up to when the reorder point is breached. Reorder point plus maximum inventory together define a classic min-max model: fall to the min, order back up to the max.
• Reorder quantity: a fixed lot size to order each time replenishment triggers, used with the fixed-reorder-quantity policy. Suits items with a natural order multiple, a pallet, a container, a supplier minimum.
• Safety stock: a buffer quantity held to absorb demand variability and supply delay. It effectively raises the reorder point and is your insurance against stockouts caused by the demand or lead time being worse than expected.
• Lead time and reordering cycle: how long resupply takes and how frequently the item is planned. These shape the timing of proposed orders so that supply arrives before stock runs dry.

The planning engine reads these parameters through the planning worksheet or the requisition worksheet, compares projected demand against projected supply, and proposes purchase, transfer or production orders to keep each item within its policy. The quality of the output depends entirely on the quality of the parameters, and that is where most replenishment programs succeed or fail. Reorder points set once at go-live and never revisited drift out of touch with real demand within a season. My advice is to treat replenishment parameters as living settings, reviewed periodically against actual consumption, rather than static configuration. For items that feed a production process, replenishment and planning connect directly into the manufacturing engine, covered in the Business Central manufacturing and production guide.

7. Inventory adjustments and physical counts

No matter how disciplined the transactions, recorded quantity and physical quantity drift apart over time through miscounts, breakage, unrecorded movements and simple error. Keeping the book honest against reality is the job of inventory adjustments and physical counts, and Business Central provides structured tools for both.

Direct adjustments are made through the item journal, where you post positive adjustments to increase stock or negative adjustments to decrease it, each with a reason code that records why the change happened. Reason codes matter more than they seem: an adjustment without a reason is an unexplained change to a financial asset, and a warehouse that adjusts freely without recording why loses the ability to diagnose where its losses come from. Every adjustment posts item ledger and value entries just like any other movement, so an adjustment is not a quiet correction, it is a real transaction that changes inventory value and flows to the ledger.

For systematic verification, Business Central supports physical inventory counting through a dedicated worksheet or journal. The process is straightforward in shape: the system calculates the expected quantity per item and location, you record the actual counted quantity, and posting the count writes adjustment entries for any differences. Larger operations use cycle counting, counting a subset of items on a rotating schedule so that high-value or fast-moving items are verified frequently and the whole catalogue is covered over a period, rather than shutting the warehouse for one disruptive annual count. Business Central supports the counting cadence through phys. inventory counting periods that flag items as due for a count.

The point I stress in every implementation is that counting is only valuable if the differences are investigated, not just posted. A count that reveals a shortfall and simply writes it off has told you nothing about why the shortfall happened. The value of counting is the feedback loop: consistent differences on particular items or locations point to a process problem, theft, receiving errors, unrecorded issues, that no amount of adjustment posting will fix on its own. Post the correction, but chase the cause.

8. Item charges and landed cost

The purchase price of an item is rarely its true cost by the time it reaches your shelf. Freight, insurance, customs duty, handling and brokerage all add to what the goods actually cost you, and if those costs are not folded into inventory value, your margins are overstated and your costing is wrong. Business Central handles this through item charges, the mechanism for assigning additional costs to received goods so that inventory value reflects the true landed cost.

An item charge is a special kind of purchase line, a freight invoice, a duty charge, that you assign across one or more item receipt lines. The assignment can be spread by amount, by weight, by quantity or equally, so a shipping cost can be distributed proportionally across the items in the shipment. Once assigned and posted, the charge increases the inventory value of those specific items through their value entries, so the extra cost is genuinely capitalised into stock rather than expensed separately. When those items are later sold, their cost of goods sold includes their share of the freight and duty, which is exactly the accuracy landed costing exists to provide.

In practice, landed cost is where importers and distributors either get their margins right or quietly lie to themselves. If a container of goods costs twelve percent of its value in freight and duty, and that twelve percent is booked to a freight expense account instead of into the items, then every product looks more profitable than it is, and pricing decisions built on that false margin erode the business slowly. Assigning item charges to receipts is a little more work at posting time, and it is the difference between knowing your real product cost and guessing it. On imported inventory, I treat proper item charge assignment as non-negotiable.

9. Inventory valuation, revaluation and the general ledger link

This is the section that ties inventory to the financial statements, and it is where the "quantity and value are one flow" principle pays off. Inventory valuation is the total cost of the stock you hold, and Business Central derives it directly from the value entries attached to every item ledger entry. There is no separate inventory valuation spreadsheet to maintain: the inventory valuation report reads the same value entries the system posts on every movement, which is why, done correctly, inventory in Business Central reconciles to the general ledger by construction rather than by heroic month-end effort.

Two routines keep this link honest and must be understood. The first is adjust cost - item entries, the process that settles expected costs into actual costs once all invoices are posted, and that forwards cost from inbound entries to the outbound entries that consumed them. Until this runs, an item's cost of goods sold may sit at an expected value rather than its final actual value. The second is post inventory cost to G/L, which takes the value entries and posts the corresponding amounts into the general ledger inventory and cost accounts. You can run the ledger posting in a detailed per-entry mode or a summarised mode, and the interplay between these two routines is what determines whether your inventory subledger and your G/L agree at any given moment.

Revaluation is the deliberate act of changing the value of stock you already hold, without changing its quantity. You do it when the recorded cost of on-hand inventory no longer reflects its true or realisable value, a market price collapse, an obsolescence write-down, a correction of a costing error. Business Central handles revaluation through the revaluation journal, where you adjust the unit cost of existing inventory and post the change as a value entry, which then flows to the ledger through the same posting routine as everything else. The quantity is untouched; only the money moves. This is how a write-down to net realisable value or an obsolescence provision is executed at the inventory level rather than as a manual journal that would leave the subledger and ledger out of step.

A caution on the reconciliation: the most common month-end pain I see is an inventory subledger that will not tie to the general ledger inventory account, and the cause is almost always one of two things: the adjust cost routine has not been run, so expected and actual costs disagree, or someone has posted a manual journal directly to the inventory G/L account, bypassing the item ledger entirely. Never post manually to the inventory control account. Let every change to inventory value flow through item journals, revaluation journals and item charges, then let the cost adjustment and G/L posting routines carry it to the ledger. Break that rule and you inherit a reconciliation gap that grows every month.

The way inventory posts to the ledger, which accounts receive the cost, the variance, the direct-cost-applied and overhead amounts, is governed by the general and inventory posting setups, which map item posting groups and location dimensions to specific accounts. That mapping is the bridge between the operational item world and the chart of accounts, and getting it right at setup is what makes the whole valuation-to-ledger flow automatic. For how these postings sit within the broader finance module, the chart of accounts and the closing process, see the Business Central financial management guide.

10. Inventory reporting and analysis

Inventory data is only worth collecting if it informs decisions, and Business Central exposes the item ledger through a range of reports and analysis tools that turn raw movements into operational and financial insight. Understanding what each is for keeps you from building custom reports for questions the system already answers.

• Inventory valuation: the definitive statement of what your stock is worth at a point in time, per item and location, derived from value entries. This is the report finance relies on for the balance sheet inventory figure and the one to reconcile against the G/L inventory account.
• Item availability views: availability by location, by variant, by period, by event and by BOM level, answering the everyday question of what can be promised and when. These views blend on-hand stock with inbound supply and outbound demand so a salesperson or planner sees projected availability, not just current quantity.
• Inventory turnover and aging: analysis of how fast stock moves and how long it has been sitting. Slow-moving and aged stock is trapped cash and a write-down risk, and surfacing it is how you keep the working capital tied up in inventory under control.
• Analysis reports and item analysis views: configurable analysis by item, category, location, dimension and period, letting you slice sales, purchases and movements the way your business thinks rather than the way the standard reports assume.
• Power BI and account schedules: for dashboards and trend analysis, inventory data flows into Power BI content and into financial reporting, so inventory metrics sit alongside the rest of the business scorecard rather than in an isolated warehouse report.

The analytical habit that separates a well-run inventory operation from a poorly-run one is not the sophistication of the reports, it is the regularity of looking at a small number of the right ones. Turnover by category to find dead stock, valuation reconciled to the ledger every month, and availability checked before promising delivery dates. Those three, watched consistently, catch most of the problems that inventory reporting exists to surface. A wall of dashboards nobody reads is no better in inventory than it is anywhere else.

Final thoughts

Inventory management in Business Central rewards the practitioner who respects a single principle: quantity and value are the same transactions seen from two sides. The item ledger records what moved, the value entries record what it cost, and the general ledger sees the money through posting routines that, run properly, keep the subledger and the ledger in agreement by construction. Once that is internalised, the individual pieces, costing methods, item charges, revaluation, reconciliation, stop feeling like disconnected features and start feeling like facets of one coherent model.

The decisions that matter most are the ones that are hard to reverse: the base unit of measure, the costing method per item, the posting setup that maps inventory to the chart of accounts, and whether a location needs full warehouse structure or none. Slow down on those, get them right, and the day-to-day of receiving, shipping, counting and reporting becomes routine. Rush them, and you spend the life of the system working around a foundation you cannot easily change. Inventory is where accuracy and money meet, and in Business Central the tools to keep both honest are all there. The discipline to use them is the part only you can supply.

Related reading: The complete guide to Business Central features, Business Central warehouse management, Business Central manufacturing and production, Business Central financial management.