Unity for SaaS · Epicor · Epicor Prophet 21

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.

How do SaaS products integrate with Prophet 21?

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.

What syncs

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 recordTypical directionWhat it's used for
Customers, ship-tos and contactsBoth waysThe accounts your app serves, each with its ship-to addresses and buyer contacts
Items and inventory by locationFrom P21Products, units of measure and available quantities at each branch or warehouse
Pricing and contract pricingFrom P21Customer-specific prices and contracts, so your app quotes what P21 will invoice
Sales ordersTo P21Orders captured in your app, created in P21 with the right ship-to, location and terms
Shipments and tracking numbersBoth waysCarriers, tracking numbers and freight that keep customers and invoices up to date
Invoices and open receivablesFrom P21Open invoices, credits and balances for payments, collections and customer portals
Cash receiptsTo P21Payments collected in your app, applied against the right open invoices
Vendors and purchase ordersBoth waysSuppliers and POs for procurement, AP automation and drop-ship platforms
How Unity connects

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.

Field notes

Prophet 21 problems we've already solved

These are the issues that stall do-it-yourself P21 integrations, and how Unity handles each one.

Pop-up prompts

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.

Partial creates

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.

Ship-tos and locations

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.

User permissions

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.

Use cases

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.

Why Unity

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.

150+Prophet 21 companies connected
8–12 wkstypical time to go live
350M+records processed on the platform
75+other systems you can add next
FAQ

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.

Connect, scale, sell more

Selling to Prophet 21 distributors?

Tell us what your product needs from Prophet 21. We'll show you how Unity connects it, under your brand.