Business Central + discrete mfg AI
AI for Dynamics 365 Business Central in Discrete Manufacturing
Short answer
AI for Business Central in discrete manufacturing connects a private language model to production orders, production BOMs, routings, item ledger entries and the planning worksheet, so planners and plant managers can ask plain-English questions and get answers grounded in live data with the query shown. It runs next to your tenant or on-prem server, reads through API pages and OData, and drafts changes for human approval instead of writing silently.
- ERP
- Dynamics 365 Business Central, Business Central On-Premises
- Industries
- Discrete Manufacturing, Fabricated Products, Machinery Components
- Written for
- Operations Manager
Business Central is a common landing spot for discrete manufacturers that outgrew QuickBooks or Sage 50 but do not need a full Dynamics 365 Finance and Supply Chain footprint. A 40 to 250 person shop with job-style and repetitive work typically runs production orders, multi-level production BOMs, routings with work centers and machine centers, and the planning worksheet, often with a handful of AL extensions bolted on for labeling, EDI or quality.
The daily friction is rarely the engine itself. It is that the answers planners need sit across several pages: a released production order, its components and their reservations, the capacity ledger entries against the routing, the purchase lines that are supposed to cover the shortage, and the cost variance that will show up after Adjust Cost - Item Entries runs. Each is a separate list, filter and export, and the person who knows the path is usually one planner.
Microsoft's own Copilot features in Business Central are useful for sales-side text, item descriptions and some analysis, and for many shops that is enough. Where they stop is grounded, auditable questions over your customized production data, your own flushing methods and routing conventions, and any requirement that item costs, customer drawings and supplier terms stay inside a boundary you control.
This page describes what AI on Business Central looks like for a discrete manufacturer: the objects it reads, the integration surface that is actually available, where a private model genuinely helps, and where standard pages, Power BI or the planning worksheet are simply the better tool.
What usually gets in the way
The problems we hear most from operations manager teams running Dynamics 365 Business Central.
Shortages are found late and by hand
Component availability is spread across Prod. Order Component, reservation entries, open purchase lines and transfer orders. Finding why a released order cannot start usually means opening four pages and asking a buyer.
Planning worksheet output is trusted or ignored, rarely understood
After Calculate Regenerative Plan, planners face hundreds of action messages. Without clear reasons tied to reordering policy, lot accumulation period and safety lead time, they either accept everything or override from memory.
Routings and actual run times drift apart
Standard run times in routing lines age while capacity ledger entries show what really happened. Nobody has time to compare them across thousands of operations, so quotes and schedules stay optimistic.
Cost variances surface at month end
Production variances from output and consumption journals post after Adjust Cost - Item Entries and are read in value entries. Explaining a bad number to finance means a manual trace from the item up through BOM levels.
Customization limits generic tools
Extensions add fields to Production Order, Item and routing tables. Off-the-shelf analytics tools see the standard schema only, so questions about your own flags and statuses cannot be answered without custom work.
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.
Shortage explanation for released production orders
A planner asks why a released order cannot start. The assistant lists missing components, the supplying purchase lines with promised dates, existing reservations competing for the same stock and the nearest alternative item, with the underlying filters shown.
Touches: Production Order, Prod. Order Component, Reservation Entry, Purchase Line, Item Ledger Entry
Outcome: Replaces a multi-page hunt with one grounded answer; planners spend their time on the decision, not the trace.
Planning worksheet action-message triage
The agent reads the planning worksheet after a regenerative plan, groups suggested lines by cause (demand change, supply slip, reorder policy) and flags the few that need human judgment. Nothing is carried out until a planner approves it.
Touches: Requisition Line, Planning Component, Item planning parameters, Sales Line, Production Forecast Entry
Outcome: Reduces review of a long worksheet to the exceptions that matter; accepted lines are traceable to a stated reason.
Routing time versus actual comparison
The assistant compares standard run and setup times in routing lines with capacity ledger entries per work center and item family, and proposes where the routing is stale.
Touches: Routing Line, Capacity Ledger Entry, Work Center, Machine Center
Outcome: Gives estimators and schedulers evidence for routing updates; quote accuracy improves where the data was previously ignored.
Production variance explanation
Given an item or order, the agent walks output, consumption and capacity entries and the associated value entries to explain a material, capacity or overhead variance in plain language for finance.
Touches: Value Entry, Item Ledger Entry, Capacity Ledger Entry, Production Order
Outcome: Cuts the month-end back-and-forth between operations and cost accounting from days to a reviewed explanation.
Supplier follow-up drafting
The agent finds purchase lines past promised date that gate released orders and drafts follow-up emails for the buyer to review and send.
Touches: Purchase Header, Purchase Line, Vendor, Prod. Order Component
Outcome: A morning scan of overdue lines becomes a queue of drafts a buyer approves in minutes.
Engineering change impact check
Before a production BOM or routing version is certified, the assistant lists open orders, planned orders and stock affected by the change and the cost roll-up difference.
Touches: Production BOM Header, Production BOM Version, Routing Version, Prod. Order Line, Item
Outcome: Fewer surprises where a revision hits work already on the floor.
Plant manager daily briefing
A scheduled read-only summary of late orders, constrained work centers and material risks, with each statement linked to the page or filter that supports it.
Touches: Production Order, Work Center Calendar Entry, Capacity Ledger Entry, Sales Line
Outcome: Replaces a standing morning meeting prep exercise with a reviewed brief; managers still verify before acting.
Reference architecture
The AI layer sits beside Business Central, not inside it. It reads through published API pages, OData web services or, on-prem, a read replica of the SQL database, retrieves and reasons with an open-weight model hosted on your hardware or private cloud, and returns answers with the exact query shown. Any change is staged as a draft for a user to post.
- 1
Business Central data surface
Standard API v2.0 covers sales, purchasing and items. Most manufacturing objects need custom API pages or OData-published pages and queries written in AL, scoped read-only.
- 2
Access and identity
A Microsoft Entra app registration with a dedicated, minimal permission set, or per-user delegation so answers respect each user's company and permission scope.
- 3
Retrieval and semantic layer
A curated map of production order, BOM, routing and ledger concepts, including your extension fields, so the model chooses real columns instead of guessing.
- 4
Open-weight model serving
Llama, Qwen, Mistral or gpt-oss class models served with vLLM or Ollama on your GPUs or sovereign cloud, sized by user concurrency.
- 5
Approval and audit
Writes become drafts (journal lines, purchase lines, worksheet changes) a human posts. Every prompt, query and answer is logged against the user.
Integration notes for your ERP team
- Standard API v2.0 is a poor fit for production data; publish AL API pages for Production Order, Prod. Order Line, Prod. Order Component and Routing Line with read-only permissions.
- Use OData-published pages or queries for ledger data such as Capacity Ledger Entry and Value Entry, with filters on posting date to bound payload size.
- Authenticate service calls with an Entra app using client credentials, and give it a custom permission set rather than SUPER.
- On Business Central On-Premises, point retrieval at a SQL read replica; table names include the company and extension GUID suffix, so a mapping layer is needed.
- Throttle requests: the online service limits concurrent and per-minute calls, so cache slow-changing master data like items, routings and work centers.
- Treat extension fields explicitly; add them to the semantic map or the model will ignore them.
Deployment options
Private model beside a SaaS tenant
Shops on Business Central online that want model traffic off public AI endpoints
The model runs in your Azure subscription or on-site GPU box and calls tenant API pages with service-to-service OAuth. Data leaves the tenant only to your own infrastructure.
Fully on-prem with Business Central On-Premises
Plants with network restrictions or customer NDAs
Everything runs inside your network. A read replica or read-only SQL login avoids load on the production database, and the model server needs no outbound internet.
Hybrid with a sovereign cloud region
Multi-site groups with data residency rules
Retrieval indexes and model sit in a regional private cloud, with tenant access through scoped APIs and logged calls.
Compliance and data control
How the architecture supports your obligations. Certification and accountability stay with your organisation; the design keeps the evidence straightforward.
ISO 9001 and customer quality clauses
Answers cite the underlying records, supporting document control and traceability expectations; the AI does not replace a controlled procedure.
ITAR / EAR for defense-adjacent work
A customer running the stack in a US-person-only, controlled environment keeps technical data out of public model services. Compliance remains the customer's obligation.
SOX-style financial controls
Read-only by default, drafts only for postings, and a prompt log that supports review of anything that touched cost or inventory.
Customer NDAs and drawing control
Documents attached to items and orders stay on infrastructure you specify; the index respects the same access scope as the source.
GDPR where staff and supplier data apply
Minimization of personal fields in the index, retention limits on logs and region-pinned hosting.
Where Netray fits
ERPray
Natural-language questions, dashboards and read-only agents over production orders, planning and costing, with the query shown and Business Central permissions honored.
Custom build
For bespoke agents such as planning-worksheet triage, routing recalibration, or integration with MES, EDI or quality add-ons.
How an engagement runs
Phase 1 . 1 to 2 weeks
Discovery and data map
- -Inventory of extensions and custom fields
- -Priority question list from planners and finance
- -Access and security plan
Phase 2 . 2 to 3 weeks
Data surface build
- -Read-only API pages or OData endpoints
- -Semantic map of manufacturing objects
- -Test set of known-answer questions
Phase 3 . 3 to 4 weeks
Pilot with planners
- -Working assistant for shortages and worksheet triage
- -Accuracy review against known answers
- -Prompt and query logging
Phase 4 . 2 to 4 weeks
Harden and extend
- -Approval workflow for drafts
- -Operations runbook
- -Backlog of next agents
Questions to ask any vendor, including us
A short list that separates real Dynamics 365 Business Central AI work from a chatbot demo.
- Which Business Central objects will be exposed, and through what read-only interface?
- How are our extension fields and custom statuses included?
- Does each answer show the query or filter it used, so planners can verify it?
- Which model runs where, and does any prompt or data leave our environment?
- How do you handle API throttling in Business Central online?
- What can the assistant write, and who approves it?
- How are answers tested after each Business Central release wave?
Frequently asked questions
Is Microsoft Copilot in Business Central not enough for a manufacturer?
It can be, for sales text, item descriptions and basic analysis. The gap appears for grounded, auditable answers over production orders, BOMs and routings, especially with extension fields, and when policy forbids sending cost and drawing data to external services. Try Copilot and standard pages first; add a private layer only for the questions they cannot answer.
Can the AI release or change production orders?
By default it cannot. It reads, explains and drafts. A proposed change, such as a reschedule or a purchase line, is staged for a planner to review and post using Business Central's normal permissions, so the audit trail and costing behave exactly as they do today.
How does it get production data if the standard API is limited?
We publish custom API pages or OData endpoints in a small AL extension, scoped read-only to the manufacturing objects that matter. On-prem installs can also use a SQL read replica. Both approaches avoid scraping the user interface and keep access explicit and reviewable.
Will it handle our extension fields and local conventions?
Yes, if they are mapped. During discovery we inventory table extensions and page customizations and add them to the semantic layer with plain-language definitions. Fields not described are effectively invisible to the model, which is why the mapping step matters more than model choice.
Does it help with the planning worksheet or replace it?
It does not replace it. The planning engine still calculates the plan. The AI summarizes action messages, explains causes and highlights exceptions so planners review less. Poor planning parameters on items remain the biggest lever, and an assessment of reordering policies is often a better first step.
What hardware is needed for a mid-size plant?
A single server with one or two data-center GPUs usually serves a 7B to 32B parameter open-weight model for tens of concurrent users. Exact sizing depends on question volume and context length. Our GPU sizing tool gives a starting range, and a pilot confirms it.
What happens when Business Central upgrades?
Online tenants get two release waves a year. We keep a regression set of known questions and rerun it after sandbox preview, checking custom API pages for compatibility. Breaking changes show up before production, not after.
Related guides
AI 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 + private AIAI 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.
Ask your ERP anythingNatural Language Query for ERP Data: Ask SAP, Infor, or Oracle a Question in Plain English
See how natural language query over SAP, Infor, Oracle, and NetSuite data works: grounded text-to-SQL, role-based permissions, and a visible audit trail.
Forecasting plus a reason whyAI Demand Forecasting for Manufacturers: Better Numbers and an Explanation Planners Can Trust
AI demand forecasting explains ERP forecast changes in plain language, flags exceptions for planners, and handles short-history SKUs without Excel overrides.
Know what an ECO actually touchesAI for Engineering Change Impact on BOMs, Routings, and Open Orders
AI reads a proposed ECO against live BOM, routing, and open order data to show engineering exactly what a change touches before it gets released.
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.
Plan it with numbers
MRP Nervousness Assessment
A 10-question diagnostic that scores how badly your MRP plan churns between runs - and pinpoints which levers will stabilize it.
Free ToolManufacturing AI Readiness Assessment
Score your manufacturing operation's readiness for AI across data, systems, people, and governance, and get a prioritized roadmap for closing the gaps.
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.
GuideFinite Capacity Scheduling: A Practical Guide
Finite capacity scheduling explained: how it differs from infinite MRP loading, APS options for SyteLine and LN, data prerequisites, and AI-assisted scheduling.
GuideAn ERP Data Quality Framework
An ERP data quality framework for manufacturers: profiling item and BOM data, six quality dimensions, automated rules, scorecards, and remediation workflows.
GuideFrom AI Pilot to Production: The Playbook
Move an AI pilot to production: environment promotion, monitoring, rollback plans, and the ERP integration hardening manufacturers need before go-live.
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.