Business Central inventory management for items, locations and costing
Business Central inventory management records what you hold, where it sits, what it cost and when to buy more. We set up items, units of measure, locations and costing. Then we add reorder rules, load opening quantities with their value, and build counting routines. As a result, the quantity on screen matches the quantity on the shelf.
Last updated
What Business Central inventory management handles
The item card is the center. It holds the base unit of measure and any others, the item category, search attributes and the costing method. It also holds the posting groups that choose which G/L accounts a movement touches. Variants cover one item in many colors or sizes, so you avoid separate cards.
Stock lives per location. Transfer orders move it between sites with an in-transit step. If you plan an item differently at each site, stockkeeping units hold the reorder rules per location. Every receipt, shipment and adjustment writes an item ledger entry with a matching value entry.
Talk about your stock →
- ✓Item cards and variants
- ✓Units of measure
- ✓Locations and transfers
- ✓Stockkeeping units
- ✓Item ledger entries
Signs your inventory setup needs work
Do you see negative stock on items sitting on the shelf? Does your sales team phone the warehouse before promising anything? Is the inventory value in the ledger different from the valuation report? Do buyers keep their own spreadsheet because suggested orders make no sense? Each sign points to a gap.
New projects need the same thinking up front. You cannot change an item's costing method freely once entries exist. The unit of measure structure also shapes every document that follows. So the decisions from the first workshop are the ones you live with. They deserve extra care.
Describe your inventory pain →- ✓Negative on-hand quantities
- ✓Ledger and valuation disagree
- ✓Buyers ignore suggestions
- ✓Counts always find differences
- ✓Sales cannot see availability
Costing choices that shape your margins
Business Central offers five costing methods. You choose one per item. Distributors often use FIFO or Average. Manufacturers with steady processes tend to pick Standard and study the variances. Specific suits serialized, high-value goods. We explain what each method does to cost of goods sold. Then we suggest one per item group.
Cost adjustment is the engine behind it. Say a purchase invoice arrives at a different amount from the receipt. The system then adjusts the cost of the sales that used that stock. We set automatic cost posting and adjustment to suit your volume. We also show finance how inventory periods protect closed months.
Ask about costing methods →- ✓Method chosen per item
- ✓Automatic cost adjustment
- ✓Freight as item charges
- ✓Inventory posting setup
- ✓Inventory periods closed
How we set up inventory management in Business Central
First, we clean the item list before we load it. We merge duplicates, agree on units, and assign categories and attributes. Then we import items with configuration packages. We post opening quantities through an item journal at a unit cost that finance signs off. So the opening value agrees with the closing value in your old system.
Replenishment comes next. Each item gets a reordering policy, such as fixed reorder quantity, maximum quantity, order or lot-for-lot. We add lead time and safety stock where you know them. After that, we run the planning worksheet in a sandbox with your buyers. We tune the settings until the suggestions look like orders they would place.
Plan the item setup →- ✓Item list cleaned
- ✓Opening stock valued
- ✓Reordering policies assigned
- ✓Planning suggestions tuned
- ✓Availability views explained
What you keep, and traps to avoid
You finish with accurate on-hand figures by location. Your sales team reads availability from the order line. Buyers rely on purchase suggestions, and the valuation report ties to the ledger. We also set up physical inventory journals and cycle counting. So counting becomes a steady routine instead of an annual shutdown.
The traps are well known. Allowing negative inventory hides process errors and distorts cost. Likewise, using item journal adjustments to fix every difference skips the question of why it happened. We set sensible defaults and explain the reason for each one. That way, nobody switches them off later.
Request an inventory check →- ✓Negative inventory allowed
- ✓Adjustments without a cause
- ✓Blank lead times
- ✓Duplicate item numbers
- ✓Counts done once only
Business Central inventory management questions
Is Business Central inventory management part of Essentials or Premium?
Inventory, locations, transfers, item tracking and basic warehousing are all in Essentials. Premium adds manufacturing and service management. A distributor that does not make products normally needs only Essentials. We confirm that once we understand how you work. So you never pay for features that your team will not use.
Can we change an item's costing method later?
Not easily. Once an item has ledger entries, the costing method is locked on the card. To change it, you create a new item and move the stock across. That is why we settle the method for each item group before we load any data. It saves you a messy fix after go-live.
How does Business Central inventory management decide what to reorder?
Each item or stockkeeping unit has a reordering policy. It holds settings such as reorder point, maximum quantity and lead time. The requisition or planning worksheet then compares demand and supply. After that, it proposes purchase or transfer orders. Your buyers then check the proposals and place the orders they agree with.
Do we need bins to use inventory in Business Central?
No. You can track stock by location only. Bins are an option when you want to record the exact shelf. You can also add warehouse documents later for receiving and picking. Many companies start simply and add bins once the basics are steady. That way, nobody feels buried in new steps on day one.
Can we track lots, serial numbers and expiry dates?
Yes. Item tracking codes decide whether an item follows by lot, serial or package number. They also decide whether expiry dates are required. The system records the tracking on every movement. So you can trace a recall, and pick first-expired-first-out where that matters. It is a core part of Business Central inventory management.
Book a discovery call
Let's talk through your move to Business Central.
A focused call with a senior consultant. We learn how your business runs today, give you an honest view on whether Business Central fits, and outline scope and next steps before you commit to anything.
What happens after you send the form