Ask Your Prophet 21 Data in Plain English
A conversational assistant that lets your team get answers from live Prophet 21 data by simply asking in plain English — no reports to build, no SQL, no screen-hopping. Ask a question the way you'd ask a colleague, and it understands you, queries your P21 data in real time, and answers in seconds.
Illustrative — answers come from your live P21 data.
Read-only against your live P21 — and every answer can show the exact query behind it.
How It Works
From a plain-English question to an auditable answer in four steps.
01You ask
Type a question in everyday language — the way you'd ask a colleague.
02It finds the area
Orders, inventory, purchasing & receiving, AP, AR, pricing & contracts, items, customers, or GL — and runs a read-only query against live data.
03It resolves names
Ask about “Dodge” and it finds the matching vendor(s) and confirms which one you mean before answering.
04It answers — with the receipts
An answer in seconds, with the exact query available on demand so results are transparent and auditable.
What You Can Ask
It identifies the right area of P21 — orders, inventory, purchasing & receiving, AP, AR, pricing & contracts, items, customers, or GL — and runs a read-only query against your live data.
Accounts Payable
- “Show the last 10 invoices for vendor Dodge Industrial.”
- “How much did we pay this vendor in the last 30 days?”
- “Which vendors do we owe the most right now?”
Accounts Receivable
- “Show open customer invoices over 30 days past due.”
- “What have we invoiced this customer this quarter?”
Inventory & Items
- “What's the on-hand quantity for item 6263-0249 across all locations?”
- “Which items are below their reorder point at the Wichita branch?”
Purchasing • Pricing • GL
- “What purchase orders are still open with this vendor?”
- “What's the contract price for this customer on this item?”
- “Show the period balance for the operating account.”
Built for Trust
It resolves names to records for you and never touches the data it reads.
Read-only
It can look, never change. Every query is validated and row-capped before it runs.
Your live data
Runs directly against P21 — nothing is copied or replicated.
Transparent
Any answer can reveal the exact query behind it.
Permissioned
Access is controlled by area and by the modules you've licensed.
Private
Hosted in our environment; your conversations and data are not retained or used for training.
Related Reading
Go Deeper
FAQ
Conversational AI for P21 — FAQ
Conversational AI for Prophet 21 is an assistant that answers questions about your live P21 data when you ask in plain English — no reports to build, no SQL, no screen-hopping. You type a question the way you'd ask a colleague — 'What did we pay this vendor last month?' — and it identifies the right area of Epicor Prophet 21, runs a read-only query against your live data, and answers in seconds. It covers AP, AR, inventory, purchasing, pricing and GL, resolves vague names like 'Dodge' to the actual vendor record before answering, and can show the exact query behind every result. ESS demos it live against sample P21 data.
Live data — the assistant queries Prophet 21 directly in real time, and nothing is copied or replicated into a separate reporting database. There is no overnight sync and no data-warehouse lag, so answers reflect the current state of orders, inventory, AP, AR, pricing and GL at the moment you ask. If a receipt was posted five minutes ago, the answer includes it. That immediacy is the point of talking to your ERP data instead of running yesterday's report: purchasing, collections and stocking decisions get made on what P21 knows right now, not on a snapshot.
No — the assistant is strictly read-only and cannot post, edit or delete anything in Prophet 21. Every plain-English question is turned into a validated, row-capped query before it runs, so there is no path from a chat message to a changed record. It can look, never touch: asking about open POs, vendor payments or item availability reads live P21 data and nothing more. That hard boundary is what makes it safe to roll out beyond the IT team — a CSR or buyer can ask anything they're permissioned for without any risk to the ERP.
Every answer can show its work: the exact query the assistant ran against Prophet 21 is available on demand, so you can verify precisely which records, filters and date ranges produced the result. That transparency makes answers auditable rather than a black box — if a number looks off, you inspect the query instead of guessing what the AI did. The assistant also resolves ambiguous names before answering, confirming which vendor or customer you meant, so the query targets the right P21 records in the first place. Trust comes from the receipts, not from promises.
Access is permissioned by functional area and by the P21 modules you've licensed. A user cleared for inventory questions can't pull accounts payable data, and the assistant only reaches the modules you actually own — it won't answer GL questions if GL is outside your license. Permissions mirror how you already segment responsibility in Prophet 21, so rolling out conversational access doesn't loosen any control you have in the ERP today. ESS configures the permission model with you during setup, so every team gets plain-English answers scoped to exactly the data they're supposed to see.
Yes — your conversations and your P21 data are not retained and are never used to train AI models. The assistant is hosted in our environment, runs read-only queries against your live Prophet 21 data, and keeps nothing afterward: questions, answers and query results are not stored for training or shared beyond your session. Combined with validated, row-capped queries and module-level permissions, that means talking to your ERP data introduces no new data-retention exposure. ESS walks through the security model in every demo, so your IT team can verify the boundaries before anything connects to production P21.
Ask Your Own P21 a Question
We'll connect a demo to sample Prophet 21 data and let you ask anything — read-only, with the query on demand.