Stock, purchasing and warehouse control in Business Central

Stock is where an ERP either earns its keep or quietly loses money. For a wholesaler in the West Midlands, a retailer shipping from the North West or a light manufacturer in Yorkshire, Business Central inventory management decides whether the figure on screen matches the pallet on the floor. This page explains how the product handles stock, purchasing and warehouse work, and what UK buyers should settle with an integrator before they sign.

Microsoft lists purchasing and inventory among the core modules a functional consultant configures, next to financial management, sales and fixed assets. In practice that means stock and Business Central purchasing share the same item records, the same ledger and the same posting rules as your accounts. There is no overnight batch between a goods receipt and the finance view.

How Business Central structures stock

Everything starts with the item card. Each product has a unit of measure, a costing method, a posting group that decides which ledger accounts move, and a replenishment setup. Get these right and the rest follows; get them wrong and every report inherits the mistake.

Items, variants and units of measure

Items can carry variants for size, colour or finish, so a single product family does not become dozens of unrelated codes. Alternative units of measure let you buy by the pallet, hold by the carton and sell by the each without separate items. Substitutes and cross-references help when a supplier uses its own part number.

A practical point for UK firms that trade online and wholesale: agree one naming convention for items before migration. Duplicate or near-duplicate items are the commonest legacy problem, and our page on data migration to Business Central covers how to clean them first.

Locations, warehouses and bins

A location can be a simple stock point or a managed warehouse. At the simple end, you hold quantities per location and transfer between them. At the managed end, you add bins, zones and directed movements: receive into a dock bin, put away to a pick bin, pick against a shipment, replenish the pick face from bulk.

The question to ask is not "what is the most advanced option?" but "how many people touch stock, and how often do they get it wrong?" A business with a few staff and a tidy stockroom may be better served by lighter bin discipline. A busy distribution site usually needs the full receive, put-away and pick flow.

Lots, serial numbers and expiry

Item tracking lets you assign lot or serial numbers on the way in and carry them out to the customer. Expiry dates can sit alongside lots, which food and drink businesses and healthcare suppliers rely on for first-expiry-first-out handling and recall exercises. Our guides to food and beverage ERP and healthcare ERP go deeper on the traceability expectations in those sectors.

Purchasing: from supplier to invoice

The Business Central purchase process follows a path most buyers will recognise: a quote or requisition, a purchase order, a receipt, a purchase invoice and a payment. Each step can be posted separately, which is how you keep received-not-invoiced stock visible on the balance sheet.

Vendors, prices and approvals

Vendor cards hold payment terms, currency, posting groups and default locations. Purchase prices and discounts can be set per supplier, and approval workflows let you route orders above a threshold to a budget holder before they reach the supplier. A UK finance director will usually want these approvals mapped to the delegated authority already in place, not invented during the project.

Receiving and matching invoices

Goods can be received against the order, then invoiced when the supplier's bill arrives. Differences between the order, the receipt and the invoice are visible before posting, which keeps the accounts payable team from paying for goods that never arrived. For firms moving towards structured e-invoices, our overview of e-invoicing in an ERP explains what to prepare.

Purchase invoices carry VAT through the UK localisation that Microsoft supplies directly, so input VAT lands in the right accounts. Your accountant should still review the set-up, particularly for reverse-charge services and imported goods. The wider obligations are covered in our guide to Making Tax Digital and your ERP, and the finance side of the product is described on the Business Central accounting and finance page.

Imports, landed cost and item charges

Since the UK left the EU single market, many buyers import more directly and see freight, duty and handling arrive as separate bills. Item charges let you assign those later costs to the receipts they belong to, so the stock value and the margin on the eventual sale reflect what the goods really cost. If you import regularly, ask for a demonstration of this on a real supplier invoice, not on a sample.

Drop shipments and special orders

When a customer order is fulfilled straight from a supplier, a drop shipment links the sales order to the purchase order without the goods touching your warehouse. Special orders do something similar for non-stocked, made-to-order goods. Both are useful for trade counters and merchants who list a wide range but hold only fast-moving lines.

Replenishment and planning

Reordering is where the system saves buyers the most time, provided the data behind it is honest.

Each item can follow a replenishment approach: order to demand, fill to a maximum, or reorder at a fixed quantity once a threshold is crossed. The planning run reads demand from sales, transfers and production, subtracts stock and open supply, and proposes purchase or transfer orders. Buyers review them, adjust and convert them to orders.

Three inputs decide whether the suggestions are useful:

• Lead times that reflect what suppliers actually deliver, not what the price list promises.
• Safety stock set per item or category, reviewed when demand shifts.
• Supplier assignment, so that proposals land with the right vendor first time.

For manufacturers, the same engine ties into production. Microsoft describes the production module, part of the Premium edition, as built on bills of materials, routings, work and machine centres and production orders, connected to planning, inventory, warehouse and costing. Our page on Business Central manufacturing and the guide to manufacturing ERP show where that begins. The edition difference is explained under versions and editions.

Receiving, picking and shipping

Day to day, warehouse staff care less about the data model than about the next task. A sensible set-up gives them a short list: what to receive, where to put it, what to pick, what to ship.

1. Receive against the purchase order, capturing lot or serial details where needed.
2. Put away to the bin the system suggests, or the one the operator confirms.
3. Pick against a sales order or shipment, in a sequence that follows the layout of the building.
4. Ship and post, which relieves stock and triggers the sales invoice.

Returns follow the same path in reverse, which matters for e-commerce sellers handling a steady flow of customer returns. If that is your profile, read our notes on e-commerce ERP alongside this page.

Carriers and shipping agents

Shipping agent codes and package tracking references can be held on shipments, which gives customer service a way to answer "where is my parcel?" without leaving the ERP. Live rate shopping and label printing for specific UK carriers are normally handled by an extension or an integration, not by the base product. The integrations page describes how those connections are usually built, and the logistics ERP guide covers the wider picture for transport-heavy businesses.

Barcodes and mobile working

Warehouse work goes faster when people scan instead of type. Business Central is available on phones and tablets, and scanning is a standard requirement in receiving, picking and counting. Rugged handheld terminals tend to come through partner extensions. Test any candidate device with your own labels, your own lighting and your own wi-fi coverage; a scanner that works in a demo room can struggle in a cold store or a mezzanine.

Stocktakes, counts and valuation

Accurate stock depends on routine counting. Physical inventory journals let you count a location or a selection of items, compare the result with the system and post the differences. Many UK businesses prefer cycle counting, where a slice of the range is counted regularly, to a single annual shutdown for the year-end audit.

Valuation depends on the costing method chosen per item: first-in first-out, average, standard or specific. The choice affects margin reporting and the figures your accountant sees at year end. Standard costing suits repeatable manufacturing; first-in first-out or average often suits trading businesses. Because stock movements post to the ledger, finance and operations look at one set of numbers, which shortens the month-end conversation.

Do not leave this to the end of the project. Costing method, posting groups and opening stock value should be agreed with your accountant before any data is loaded. The implementation page shows where this sits in a typical project plan.

Choosing the right depth for your business

Not every firm needs every feature. A useful way to scope the work:

Regional context matters too. A Scottish or Welsh distributor may transfer stock between depots over long distances, where transit visibility matters; a London-based wholesaler may have tight storage and need disciplined bin management. Our regions index lists integrators by area, and the page on Business Central in the UK explains how the product is supplied and supported here.

Before you speak to an integrator

Write down how stock really moves today, including the workarounds. List your item categories, your tracking needs, your suppliers' lead-time habits and the devices you want to use. Our requirements template gives you a structure for that, and the licensing and pricing page explains what drives cost.

Ask each candidate to walk through a goods receipt, a pick and a stocktake using your own item data, not a scripted demo. That single session usually shows how well an integrator understands warehouse work. ERP Integrator is a free matching service: we introduce you to integrators suited to your project, and they carry out the implementation. We are not affiliated with Microsoft. Our page on how it works explains the process.

Software names mentioned are trademarks of their respective publishers and are referred to for information only. This site is independent and is not affiliated with any software publisher.