Business Central inventory AI
AI for Business Central Inventory: Ask About Stock, Bins, Costing and Variances
Short answer
AI for Business Central inventory lets planners and warehouse leads ask questions about stock, bin content, reorder policy and cost in plain English, answered from the Item Ledger Entry, Warehouse Entry and Value Entry data with the query shown. It finds mismatches between inventory and general ledger, ranks slow stock, and proposes count and reorder-point changes for human approval.
- ERP
- Dynamics 365 Business Central
- Industries
- Manufacturing, Distribution, Wholesale
- Written for
- Inventory Manager
Inventory in Business Central is stored in three overlapping views that do not always agree on first look: quantity in the Item Ledger Entry, value in the Value Entry, and for locations that use warehouse functionality, bin quantity in the Warehouse Entry and Bin Content. Add item tracking by lot or serial, multiple locations with transfer routes, and costing methods that differ by item, and a simple question like how much do we have and what is it worth turns into a careful reconciliation.
Most inventory managers solve this with a patchwork of Item Availability pages, the Inventory Valuation report, and Excel workbooks. Experienced people know which page tells the truth for which question. New staff do not. When the person who knows leaves, the knowledge leaves with them, and the questions end up in a queue for a consultant.
A language model is not a replacement for the costing engine or for the posting rules, and it should never post an item journal on its own authority. What it can do well is read the data, explain what it sees, compare records that humans do not have time to compare, and point to the lines that deserve attention. The key design choice is that it reads through supported APIs and shows its working.
This page describes what that looks like for Business Central, what it needs from your tenant, and where a simpler tool such as a saved page or Power BI report is the better answer.
What usually gets in the way
The problems we hear most from inventory manager teams running Dynamics 365 Business Central.
Quantity, value and bin disagree
Item Ledger Entry, Value Entry and Warehouse Entry are posted by different processes. When cost adjustment has not run, or a posting failed in a batch, the balances diverge and tracing the cause is manual.
Reorder settings go stale
Reorder Point, Safety Stock Quantity, Maximum Inventory and the chosen Reordering Policy are set at go-live and rarely reviewed. Demand shifts, and the planning engine keeps working from outdated numbers.
Slow and excess stock hides
Remaining quantity with no movement for a year sits on shelves and on the balance sheet. Finding it across items, locations and lots needs a report few people have time to build and read.
Cycle counts are not targeted
Physical Inventory Journals and Physical Inventory Counting Periods are often run by calendar rather than by risk. High-value, high-adjustment items get the same attention as stable low-value ones.
Lot and expiry visibility is poor
Item Tracking Lines and expiration dates are available but hard to view across locations. Near-expiry stock is found late, and recall traceability needs several pages to reconstruct.
Where AI earns its place in Dynamics 365 Business Central
Each use case names the ERP objects it reads or writes, so your ERP team can judge the integration effort before anyone commits budget.
Plain-English stock and availability questions
Ask what is available to promise for an item at a location, what is reserved against which orders, and what is inbound, with the source documents listed.
Touches: Item, Item Ledger Entry, Reservation Entry, Sales Line, Purchase Line, Prod. Order Component
Outcome: Customer service gets an answer with its basis in seconds rather than navigating Item Availability by Event and Period by hand.
Inventory to G/L reconciliation assistant
Compares the Inventory Valuation figures with inventory posting group accounts, explains differences such as unposted cost to G/L or expected cost, and lists the entries responsible.
Touches: Value Entry, G/L Entry, Inventory Posting Setup, Post Inventory Cost to G/L, Adjust Cost - Item Entries
Outcome: Month-end differences are explained with named entries rather than chased for days. It does not post corrections.
Reorder policy review
Analyzes consumption history and lead times per stockkeeping unit and suggests reorder point, safety stock and policy changes, grouped for a planner to accept or reject.
Touches: Stockkeeping Unit, Item (Reordering Policy, Safety Stock Quantity, Reorder Point), Item Ledger Entry, Item Vendor lead time
Outcome: Fewer stockouts and less excess when applied carefully. Gains depend on demand variability and data quality.
Slow-moving and obsolete stock list
Ranks stock by age since last movement and value, flags items with open demand or substitutes, and drafts a disposition proposal for review.
Touches: Item Ledger Entry (Remaining Quantity, Posting Date), Item Substitution, Bin Content, Inventory Valuation
Outcome: A reviewed list for finance and operations before year-end, produced in minutes. Write-down decisions stay with people.
Risk-based cycle count plan
Proposes which items and bins to count based on value, past adjustments and movement, then prepares the counting lines for the physical inventory journal as a draft.
Touches: Phys. Invt. Counting Period, Item Journal Line (Phys. Inventory), Warehouse Entry, Item Ledger Entry adjustments
Outcome: Counts focus on items that drift, which usually improves accuracy per hour counted. A small share of count time may be freed.
Lot, expiry and recall tracing
Answers which customers received a lot, which vendor supplied it, and what stock of that lot remains, by walking item tracking and application entries.
Touches: Item Ledger Entry (Lot No., Expiration Date), Item Application Entry, Item Tracking Lines, Posted Sales Shipment
Outcome: Trace time falls from hours of page-hopping to a documented list, which supports recall response.
Transfer and location balancing
Spots locations with excess and others with shortages of the same item and proposes transfer orders for a planner to approve.
Touches: Location, Transfer Header, Transfer Line, Stockkeeping Unit, Item Ledger Entry
Outcome: Reduces emergency purchases when stock exists elsewhere, subject to transfer lead time and cost.
Reference architecture
The assistant reads through Business Central APIs and a small set of custom API pages that expose ledger-level tables not in the standard API, aggregating server-side where possible so large ledgers are not pulled in full. A scheduled snapshot of inventory metrics supports trend questions without hammering production.
- 1
Access layer
Microsoft Entra application with OAuth 2.0 client credentials mapped to a Business Central user whose permission set is limited to inventory and item read access.
- 2
Data connectors
API v2.0 for items and locations, plus custom API pages over Item Ledger Entry, Value Entry, Warehouse Entry and Bin Content built in an AL extension, filtered and paged.
- 3
Snapshot and index
A nightly snapshot of on-hand, age and consumption per item and location stored outside the ERP for trend and slow-stock questions, with documents such as count procedures indexed for retrieval.
- 4
Model and reasoning
A self-hosted open-weight model with tool calls for each query type, instructed to show the filters used and refuse to estimate numbers it cannot read.
- 5
Approvals and write-back
Count lines, transfer orders and reorder changes are created as drafts or suggestions. Posting remains a user action under existing permissions and journal batch templates.
Integration notes for your ERP team
- Item Ledger Entry and Value Entry tables can be very large; always filter by item, location and posting date and use server-side paging, and consider a summarizing API page for aggregates.
- Run Adjust Cost - Item Entries on its normal schedule before relying on cost figures; the assistant should state the date of the last cost adjustment in valuation answers.
- For locations using bins, join Bin Content and Warehouse Entry rather than inferring bin stock from the item ledger, since Item Ledger Entry does not carry bin.
- Costing method matters: Standard, FIFO, Average and Specific costing behave differently on variances, and the assistant needs the item's costing method to explain differences correctly.
- Item tracking: lot and serial numbers sit on Item Ledger Entry and Reservation Entry, and expiration dates require the item tracking code to be configured for them.
- Writes go through standard journals with journal batches reserved for the assistant, so reviewers can see its drafts separately.
Deployment options
Customer cloud tenant
Business Central online users with Azure skills
Model and snapshot store run in the customer's own Azure subscription, connected to the BC environment through the API with private networking where available.
On-premises inference
On-prem BC and companies with strict data residency
A GPU server in the customer's data center, with the API calls staying inside the network. Updates to model weights are brought in by a controlled process.
Analytics-first pilot
Teams unsure whether AI beats a good Power BI report
Start with the snapshot and a handful of questions on a sandbox. If reports meet the need, stop there; if people want free-form questions, extend.
Compliance and data control
How the architecture supports your obligations. Certification and accountability stay with your organisation; the design keeps the evidence straightforward.
Financial reporting and audit
Inventory valuation and G/L figures are read, not changed. Every number in an answer links to ledger entries, giving auditors a trail.
FDA 21 CFR Part 820 and ISO 13485 traceability
For medical device customers, lot and serial tracing uses the item tracking and application entries, and the assistant does not alter genealogy. Validation of the tool for its use is the customer's responsibility.
FSMA 204 and food traceability
Lot and expiry queries support the traceability records a food business must keep. Completeness depends on how consistently item tracking is used at receipt and shipment.
Access control
Cost and value fields are hidden from roles that cannot see them in Business Central. The assistant applies the same restriction through the user's identity.
How an engagement runs
Phase 1 . 1-2 weeks
Data and policy review
- -Inventory and costing configuration review
- -Question inventory from planners and warehouse
- -Permission design
- -Sandbox access
Phase 2 . 3-4 weeks
Read-only assistant
- -Custom API pages for ledger tables
- -Stock, age and availability questions
- -Snapshot job and trend views
- -Accuracy test set
Phase 3 . 3-4 weeks
Analysis workflows
- -Reconciliation assistant
- -Reorder review suggestions
- -Risk-based count proposals
- -Reviewer feedback loop
Phase 4 . 2 weeks
Production and handover
- -Production connection
- -Monitoring and cost report
- -User training
- -Roadmap for transfers and tracing
Questions to ask any vendor, including us
A short list that separates real Dynamics 365 Business Central AI work from a chatbot demo.
- How do you avoid pulling entire ledger tables, and what is the effect on production performance?
- How does the assistant treat our costing methods and unadjusted cost?
- Will it explain differences between inventory and the general ledger with named entries?
- Can it read bin and lot data, and what do we need to enable in our configuration?
- Who approves changes to reorder points, and where are suggestions stored?
- How are custom fields and extensions on items handled?
- Could a Power BI report meet our need at lower cost?
- How is the model kept current with our data without retraining?
Frequently asked questions
Can AI fix inventory mismatches in Business Central?
It can find and explain them, but posting corrections should stay with a person. A typical case is a gap between inventory valuation and the general ledger caused by cost not yet posted to G/L. The assistant names the entries and the likely cause, and your finance team decides whether to run the batch job or post an adjustment.
Does it replace the planning engine?
No. Business Central's planning engine still calculates requirements from reorder policy, demand and supply. The assistant reviews the inputs, such as reorder point and safety stock, against actual consumption and suggests changes. Those changes are applied by a planner, and the planning engine keeps doing the calculation.
Will it work with warehouse management features?
Yes, if the data is exposed. Locations with bins use Warehouse Entry and Bin Content, which are not in the standard API, so we add custom API pages. Warehouse documents such as receipts and picks can be read the same way. Directed put-away setups need a review so answers reflect your bin rules.
Is Power BI enough instead?
For fixed dashboards of known measures, often yes, and it is cheaper. A language layer adds value when people ask new questions each day, need explanations rather than numbers, or want to combine ledger data with documents. Some teams use both, with the assistant querying the same snapshot the reports use.
How does it handle lots and expiry dates?
It reads item tracking data from the item ledger and reservation entries, so lot, serial and expiration answers depend on tracking being used consistently at receipt and shipment. If a location does not track lots, the assistant cannot invent that history, and it should say so instead of guessing.
What about performance on a large database?
Large ledgers are why queries are filtered, paged and where possible aggregated by a purpose-built API page. A nightly snapshot answers trend and age questions without live scans. We test with production-sized data in a sandbox and set limits, so a single question cannot slow the system for other users.
Can it run on-premises?
Yes. Business Central on-premises exposes the same API pages and web services, and the language model can run on a local GPU server. Nothing needs to leave your network. Plan for a controlled way to update model weights and for monitoring of GPU capacity as usage grows.
Related guides
AI for Dynamics 365 Business Central, on-premises or SaaS, beyond Copilot
AI for Business Central beyond Copilot: grounded question answering over BC's data via OData and APIs, for on-premises and SaaS tenants alike.
Business Central Manufacturing + AIAI for Business Central manufacturing operations, beyond Copilot
AI for Business Central manufacturing beyond Copilot: grounded answers on production orders, routings, and capacity via APIs v2.0, on-prem capable.
Business Central purchasing AIAI for Business Central Purchasing: Questions, Exceptions and Draft Orders on Your Own Data
AI for Business Central purchasing: ask plain-English questions on purchase orders, vendor lateness and invoice matching, with read-only access and approvals.
RAG + SQL + permissionsA Private LLM Grounded on Your ERP Data
How a private LLM answers questions on your ERP data: RAG plus text-to-SQL, role-based permissions inherited from the ERP, and where each fits.
Agents + approval gatesAI Agents for ERP, Running On-Prem
A practical guide to on-prem AI agents for ERP: what they can safely automate, where human approval belongs, and how to design the guardrails.
D365 F&SCM + private AIAI for Dynamics 365 Finance and Supply Chain beyond Copilot
AI for D365 Finance and Supply Chain beyond Microsoft Copilot: private LLM grounded on data entities and OData, on-prem-capable via Local Business Data.
Plan it with numbers
On-Prem LLM Total Cost of Ownership Calculator
Model the full multi-year cost of running LLMs on your own hardware, including GPU capex, power, cooling, support contracts, and operations staffing.
Free ToolGPU Sizing Calculator for LLM Inference
Work out how many GPUs you need to serve a given open-weight model to your user base, based on memory footprint and token throughput.
Free ToolOn-Prem AI Deployment Checklist
A 30-point pre-deployment checklist covering use cases, hardware, security, model operations, and rollout for self-hosted enterprise LLMs.
GuideAI Inventory Optimization Algorithms for ERP
Optimize inventory with AI algorithms integrated into your ERP. Reduce carrying costs 20-35% while improving fill rates using reinforcement learning and demand sensing.
GuideSyteLine Physical Inventory Procedures
Execute physical inventory in Infor SyteLine with freeze procedures, count sheet generation, variance reconciliation, and posting workflows for year-end audits.
GuideSyteLine Multi-Site Inventory Management
Configure cross-site inventory visibility in Infor SyteLine with inter-site transfers, shared warehouses, and real-time on-hand queries across multiple facilities.
Talk it through with an engineer who knows Dynamics 365 Business Central
Bring one real question your team cannot answer from the ERP today. We will map the data path, the model, and where it runs, and tell you honestly if AI is the wrong tool for it.