Automated purchasing from demand forecast: the ERP proposes what to buy and when (Business Central)

Automated purchasing from demand forecast: the ERP proposes what to buy and when (Business Central)

Sebastian Stefanczyk · BramviaOctober 21, 2026 2 min read

Bramvia — Business Central Experts

Deciding purchases item by item, with a spreadsheet and gut feeling, ends in stockouts and dead stock. How the ERP proposes purchases from real demand, lead times and safety stock.

Short answer: instead of reviewing items one by one, the ERP works out every day what to buy, how much and when, from real demand, open orders, each vendor's lead time and safety stock. The buyer reviews the proposal and turns it into purchase orders in one click. At 800 items reviewed a month, moving to proposal review saves around 15 hours a month, and above all cuts stockouts and dead stock.

Next step: see below how stock evolves week by week and when stockouts would hit.

Calculator and simulator: Safety stock simulator. Simulates 90 days of inventory with variable demand and supplier delays. In the example, with no safety stock there are 11 stock-out days and 89.8% of orders are served in full; with 120 units, 1 stock-out day and 99.7%, at a holding cost of about 1,000 a year; with 300 units there are no stock-outs but it costs about 1,540 a year. Open the demo

The problem: buying on gut feeling

With thousands of items, nobody can review them all every week. People buy what they remember, what a rep asks for urgently or what they bought last year. The result is stockouts in what sells and dead stock in what doesn't.

How the ERP does it

  1. Calculates demand from history, seasonality and open orders.
  2. Uses lead times for each vendor and safety stock for each item.
  3. Proposes purchases: what, how much, from whom and when, grouped by vendor.
  4. Warns about expected stockouts and stock that hasn't moved for months.
  5. Creates purchase orders when the buyer approves.

What a person still does

The buyer decides: negotiates, adjusts for a promotion or a supplier change, and approves. Instead of reviewing items one by one, they handle exceptions and negotiate better. With tariffs moving, landed cost per receipt belongs in the same decision.

A worked example

Before With automatic proposals
Items reviewed a month 800 800
Time per item 1.5 minutes 0.3 minutes
Hours a month 20 4
Time freed 16 hours a month

The big saving is not that: it is the stock. If better purchasing takes inventory days from 70 to 60 with $20,000 a day of cost of goods sold, about $200,000 of working capital is freed, and stockouts stop costing sales.

In Business Central

The planning and requisition worksheets calculate proposals from each item's parameters (reorder point, safety stock, lead time), and the sales forecast can use AI models. See buffer inventory and days inventory outstanding for the numbers.

FAQ

What if demand changes suddenly? The proposal is recalculated daily from real orders; the buyer adjusts the exceptions.

Does it work for imports with long lead times? Yes, with each vendor's real lead time and the landed cost of each receipt.

How much does it save? In time, hours a month; in money, mostly less dead stock and fewer lost sales. Run your numbers in the AI hours calculator.

Related: dead stock and inventory carrying cost.

Free assessment · Evaluación gratuita

Tell us your current system and how many users you have. First reply within one working day. / Cuéntanos tu sistema actual y cuántos usuarios sois. Respondemos en un día laborable.


Bramvia · bramvia.net

Bramvia in: Spain · United States · Mexico · United Kingdom · Ireland · Canada · Colombia · Argentina · Chile · Peru · Australia · New Zealand · South Africa · Philippines · Poland · MCP server · Safety stock calculator