+1 480 485 7373
Microsoft Teams
Business Central warehouse control levels, from light to strict
Business Central inventory costing: the choice you cannot casually undo
Each item carries a costing method. Business Central will not let you change it once the item has ledger entries. FIFO suits most distributors, and Average smooths out volatile purchase prices. Standard is common for manufacturers who want fixed costs and variance reporting. Specific follows a serial number for high-value goods.
Business Central adjusts cost after the fact. Say a purchase invoice arrives at a different price from the receipt, or you assign an item charge for freight. The Adjust Cost - Item Entries job then pushes that change through to every sale that consumed the stock. If nobody schedules that job, margins on sales look wrong and inventory value drifts from the G/L.
We also decide with you whether expected cost posting is on. It posts received-not-invoiced value to interim accounts, which some controllers want and others find noisy.
Business Central inventory and warehouse features worth knowing before go-live
Item tracking
Item tracking codes decide whether an item needs a lot, serial or package number on inbound, outbound or both. They also decide whether to enforce expiration dates.
- ✓Lot and serial numbers
- ✓Expiration dates
- ✓Item tracing forwards and back
- ✓Warranty dates
Replenishment
Reordering policies on the item or stockkeeping unit drive the requisition worksheet, which proposes purchase orders or transfers.
- ✓Fixed reorder quantity
- ✓Maximum quantity
- ✓Lot-for-lot
- ✓Safety stock and lead times
Locations and transfers
Transfer orders move stock between warehouses with an in-transit location, so goods on the truck still show as yours.
- ✓Multiple locations
- ✓In-transit codes
- ✓Stockkeeping units per location
- ✓Item variants for size or color
Physical inventory
Physical inventory orders and recordings support full counts, while counting periods on items drive cycle counts by class.
- ✓Count sheets and recordings
- ✓Cycle count frequency
- ✓Adjustments posted with reason codes
- ✓Bin-level counts
Where Business Central inventory projects usually go wrong
- ✓Turning on directed put-away and pick for a small team that then confirms documents all day, not moving boxes.
- ✓Loading opening stock without lot or serial numbers and then turning on tracking, which leaves unexplained balances.
- ✓Leaving the cost adjustment job unscheduled, so inventory valuation and the balance sheet disagree at month-end.
- ✓Creating a new item for every size and color instead of using variants. That bloats the item list and breaks reporting.
- ✓Assuming the handheld scanning experience comes out of the box. Business Central works on a phone or tablet browser, but most barcode-heavy warehouses add an AppSource scanning app.
- ✓Counting stock while receipts and shipments keep posting. The expected quantities in the physical inventory journal then go stale before anyone enters the count.
Our route from spreadsheet stock to posted Business Central inventory
- 1
Walk the floor
We follow goods from the receiving door to the shipping door, on a video call if needed. We note who touches what and where your team still uses paper.
- 2
Pick the control level
Based on volume and team size, we recommend one Business Central inventory and warehouse level per location. Different locations can run different levels.
- 3
Clean the item master
We agree and load units of measure, variants, tracking codes, costing methods and reorder policies before any stock quantity.
- 4
Count and load
Opening balances come from a fresh count. We post them through an item journal with bins and lots, so the first day starts accurate.
- 5
Practice real days
Your team receives, picks, ships and counts in a sandbox using real orders before the switch.
Business Central inventory and warehouse questions
Do we need Premium for warehouse management?
No. Locations, bins, item tracking, warehouse receipts and shipments, and directed put-away and pick are all part of Essentials. Premium adds manufacturing and service management, not extra warehouse features. If you only assemble kits, assembly orders are in Essentials too.
Can Business Central handle barcode scanning?
Business Central runs in a mobile browser and in the mobile app, and item references can hold barcodes. For high-volume scanning with rugged handhelds, most companies add a specialist scanning app from AppSource. We help you compare a few options against your own process rather than pushing one.
How does it handle stock in several warehouses?
Each warehouse is a location with its own settings, and stock moves between them on transfer orders. Stockkeeping units let the same item have different reorder points, vendors or costs per location. Availability pages show quantities by location, including stock in transit.
Which costing method should we choose?
It depends on your products and your accountant's view. However, FIFO is the usual choice for distribution and Standard for many manufacturers. Nobody can change the method once an item has transactions, so we settle it in writing before loading data. For items where each unit is unique and valuable, Specific costing with serial numbers is available.
Can we start simple and add bins later?
Yes, and that is often wise. You can introduce bins per location once people are comfortable. When you switch, a journal moves the stock into bins. Stepping up to warehouse receipts or directed pick later is also possible, but plan it for a quiet period.
Talk to us about your project.
Tell us what you run today and what has to change. A senior consultant replies with a written next step.