Prophet 21 integration for SaaS companies
Epicor Prophet 21 is the ERP behind many wholesale distributors. Unity connects your product to it, syncing customers, ship-tos, items, orders, invoices and payments through P21's own APIs, under your brand, managed by our team.
- Customers
- Orders
- Payments
- Shipments
- P21 version 12 and later
- Epicor cloud or on-premises
- Multiple companies
- Multiple locations
Prophet 21 is built for distributors, so an integration has to respect ship-tos, locations, contract pricing and P21's order-entry rules. Unity reads data through P21's OData data services and creates transactions through its Transaction API, so every order and payment follows the same business rules as one keyed in by your customer's staff. For on-premises P21, a lightweight agent inside the customer's network handles the connection. Our team builds the integration, delivers it under your brand and keeps it running through P21 upgrades.
Prophet 21 records Unity maps for SaaS products
Each map uses P21's own transaction services, so records land with the locations, terms and pricing your customer's team expects.
| Prophet 21 record | Typical direction | What it's used for |
|---|---|---|
| Customers, ship-tos and contacts | Both ways | The accounts your app serves, each with its ship-to addresses and buyer contacts |
| Items and inventory by location | From P21 | Products, units of measure and available quantities at each branch or warehouse |
| Pricing and contract pricing | From P21 | Customer-specific prices and contracts, so your app quotes what P21 will invoice |
| Sales orders | To P21 | Orders captured in your app, created in P21 with the right ship-to, location and terms |
| Shipments and tracking numbers | Both ways | Carriers, tracking numbers and freight that keep customers and invoices up to date |
| Invoices and open receivables | From P21 | Open invoices, credits and balances for payments, collections and customer portals |
| Cash receipts | To P21 | Payments collected in your app, applied against the right open invoices |
| Vendors and purchase orders | Both ways | Suppliers and POs for procurement, AP automation and drop-ship platforms |
P21's own APIs, not direct database writes
Prophet 21 runs in Epicor's cloud or on the customer's own servers. Unity works the same way in both.
Reads through data services
Unity pulls customers, items, inventory and open invoices through P21's OData data services, which works in Epicor's cloud, where direct SQL access is read-only.
Writes through the Transaction API
Orders, cash receipts and other records are created through P21's Transaction API, so they pass the same validation and business rules as records entered on screen.
Every company and location
Distributors often run several companies and many branches in one P21 system. Unity maps each location and keeps each company's data separate.
Changes picked up on a schedule
P21 doesn't push changes to outside systems, so Unity checks for new and changed records every few minutes and moves them in order.
Prophet 21 problems we've already solved
These are the issues that stall do-it-yourself P21 integrations, and how Unity handles each one.
An order stops on a question nobody answers
P21 asks questions during order entry, like which ship-to or which location to use. An API call can't click a button, so the order fails. Unity sends every value P21 would ask for up front.
A failed order still uses up an order number
When a create fails partway, P21 can keep a cancelled record and skip a document number. Unity validates the order before it's sent and raises a case with P21's own message if it still fails.
Orders without a valid ship-to or branch
Every P21 order needs a ship-to and a source location. Unity creates missing ship-tos first and maps your app's warehouses to the right P21 locations.
Fields the integration user can't edit
P21 can lock fields by user role, so an update fails with a "column is disabled" error. Unity sets up the integration user with the right role during the project.
Which SaaS products connect to Prophet 21?
Payments and accounts receivable
Pull open invoices into your platform, collect payment, and create cash receipts in P21 applied to the right invoices.
Transportation management (TMS)
Send orders from P21 to your TMS for load planning, then return carriers, tracking numbers and actual freight costs.
B2B ecommerce and customer portals
Show each customer their own pricing, stock by branch and order history, and create P21 orders the moment they check out.
Sales, quoting and CRM
Give reps customer balances, contract prices and order status, and turn quotes into P21 orders.
Procurement, AP automation and rebates
Sync vendors and purchase orders, push approved bills, and return payment status and rebate data to your app.
Unity is a managed integration service for SaaS companies, built on the Intelligrate iPaaS. We build your Prophet 21 integration, put your brand on it, monitor it, fix errors and handle upgrades. Integration updates can even flow into your own help desk. See how Unity works for SaaS.
Prophet 21 integration questions
Which Prophet 21 versions does Unity support?
Prophet 21 version 12 and later, whether P21 runs in Epicor's cloud or on the customer's own servers.
Does Unity work with Prophet 21 in Epicor's cloud?
Yes. Unity uses P21's own APIs rather than direct database access, so it works the same way in Epicor's cloud, where SQL access is read-only, as it does on-premises.
Does Unity write directly to the Prophet 21 database?
No. Unity creates records through P21's Transaction API, so they follow the same business rules as records entered on screen. Writing straight to the database skips those rules and can leave data out of step.
Can Unity handle contract pricing and multiple ship-tos?
Yes. Unity reads customer-specific and contract pricing from P21 and syncs each customer's ship-to addresses, so orders created from your app carry the right price and destination.
How quickly do changes in Prophet 21 reach our app?
Within minutes. P21 doesn't send changes to outside systems on its own, so Unity checks for new and changed records on a short schedule.
How long does a Prophet 21 integration take?
A first Prophet 21 integration typically goes live in eight to twelve weeks. Each new customer after that is mostly configuration, since the maps are already built.
Your customers run other ERPs too
- All Unity integrations for SaaS
- SAP Business One
- All Microsoft Dynamics integrations
- Microsoft Dynamics 365 Business Central
- Microsoft Dynamics 365 Finance & Supply Chain
- Microsoft Dynamics GP
- All Epicor integrations
- Epicor Kinetic
- Infor SyteLine / CloudSuite Industrial
- All Infor integrations
- Infor VISUAL
- Infor LN
- Infor M3
- Infor SX.e
- Infor XA
- NetSuite
- Acumatica