Logistics · Manufacturing
Will AI automation work with our existing ERP, TMS or WMS?
"Our systems are too old for that" is the most common reason operations teams don't explore automation. It's rarely true. This guide explains the ways an automation can connect to your ERP, TMS or WMS, from modern APIs to 20-year-old green screens, and what to check before you start.
The short answer
Yes, almost always. AI automation doesn't replace your ERP, TMS or WMS. It does the reading, checking and keying that people do between those systems, and then puts the result into them. What varies is how it connects, and that affects cost, speed and how much care is needed.
Four ways to connect, from best to last resort
1. An API
Most current cloud systems, such as Microsoft Dynamics 365 Business Central, NetSuite and modern TMS and WMS platforms, offer APIs that let other software read data and create records like orders, jobs and receipts. This is the cleanest route: fast, reliable and easy to monitor.
2. Imports and EDI
Many established and on-premise systems can import files (CSV, XML or EDI messages) on a schedule or from a watched folder. If your system already takes orders by EDI from big customers, an automation can often produce the same format for everyone else.
3. Reading from the database
For lookups, such as customer accounts, part numbers, open orders and job references, read-only access to the database or a reporting copy is often the simplest option. Writing directly into a system's database is a different matter, and usually best avoided because it bypasses the system's own rules.
4. Through the screens
When a system has no API or import, the automation can work through the same screens a person uses, including older desktop and terminal applications. It works, and it's sometimes the only option, but screen changes can break it, so it needs monitoring and should be kept to the steps that genuinely have no alternative.
Questions to ask your vendor or IT partner
- Does our version have an API, and is it included in our licence?
- Can it import orders, jobs or receipts from files or EDI, and from which folder or endpoint?
- Can we have read-only access to the data, or a reporting copy?
- Are there limits on API calls or concurrent users that we need to plan for?
- Do we have a test environment we can use before going live?
Keeping it safe
- Least privilege. Give the automation its own account with only the permissions it needs.
- Validate before writing. Check data against your own records before anything is created in a core system.
- Audit everything. Keep a log of what was read, what was decided and what was written, linked to the source document.
- Stay in your region. The automation can run in your own cloud account, with AI services set up to process data in UK or EU regions and not to use it for training.
- Plan for downtime. If a system is unavailable, work should queue and resume, not fail silently.
Frequently asked questions
Our ERP is on-premise. Can a cloud-based automation connect to it?
Yes. A small, secure connector inside your network can pass data between the automation and your on-premise system without opening it up to the internet.
Do we need our software vendor's permission?
Using documented APIs and imports is normally covered by your licence. Check with your vendor about API access, any extra licence costs and support terms before relying on screen-based automation.
What if we're planning to replace our ERP in a year or two?
Automation built around clear inputs, rules and outputs can usually be reconnected to the new system with modest effort, and the rules you have captured will help the migration.
Can the automation update several systems at once?
Yes. For example, it can create an order in the ERP, a job in the TMS and a confirmation email to the customer in one flow, with each step logged.
