How to Automate Collections in Epicor Prophet 21 for Distributors
Prophet 21 holds your invoices, customers and AR history. Here is how a 3 to 5 person distribution AR team automates the follow-up from a daily export, handles short pays and deductions, and rolls it out safely.

Pratheek Adi
Co-Founder & CTO

Table of contents
Share
Many industrial, electrical, plumbing and building products distributors run their business on Epicor Prophet 21. Orders, inventory, purchasing and invoicing all live there, and Epicor positions the product as an ERP built for distributors. What Prophet 21 does not do on its own is call the customer who is 20 days past due on six invoices. That still falls on your AR team.
This guide is for the controller or AR manager running a collections team of three or more people on Prophet 21. It covers what Prophet 21 already gives you, where the follow-up time goes at a distributor, and how to automate overdue invoice follow-up from a daily export without an integration project.
Can You Automate Collections in Epicor Prophet 21?
Yes. You can automate overdue invoice follow-up for Prophet 21 by sending a daily AR export to an AI collections agent, which then calls, texts and emails customers on your schedule and hands deductions and disputes back to your team. Prophet 21 stays your system of record. The agent works from the same open invoice data your collectors already pull, so there is no API project to start.
Want to see it on your own numbers? Get started and we will set up a pilot on your Prophet 21 aging report. Prefer to talk it through first? Book a 30-minute call.
What Does Prophet 21 Already Give Your AR Team?
Prophet 21 gives a distribution AR team the data it needs. According to Epicor's Prophet 21 Finance and Accounting page, the AR side lets you:
Track customers' outstanding invoices and set alerts on them.
Keep a history of past conversations with each customer.
Handle complex billing and tracking situations, which distributors with branch, job and ship-to accounts run into daily.
Epicor also sells Epicor Cash Collect, a cloud collections add-on that, per the same page, assigns accounts, creates prioritized tasks for collectors and automates billing reminders. Whatever tools you use, the work that remains is the same: someone has to reach the customer, get an answer and follow through.
Where Does the Collections Time Go at a Distributor?
At a distributor, collections time goes to volume and to small exceptions, not to a handful of large balances. A contractor customer can generate dozens of invoices a month across job accounts, counter sales and drop shipments. Each is modest, and each can stall for its own reason.
The usual backlog looks like this:
Short pays: the customer pays the invoice minus a disputed unit rate, a freight charge or a damaged line, and the remainder sits open.
Deductions taken without explanation, which turn into research before anyone can collect.
Missing PO or job numbers, so the customer's AP team cannot match the invoice.
Payments that arrive without remittance and sit as unapplied cash, which makes the aging look worse than it is.
Small balances nobody calls about, because a $150 counter invoice is never the best use of a collector's hour.
Our guides on customer deductions and short payments and on unapplied cash cover the cleanup side. This guide covers the follow-up side.
What Do You Need From Prophet 21 to Start?
You need three things, all of which your team can already pull:
An open invoice or AR aging export: customer, ship-to or job, invoice number, invoice date, due date, open balance and PO number.
Customer contacts: the AP email and phone on each customer, plus the job or branch contact where you have one.
Optionally, invoice copies, if you want them attached to reminders.
A scheduled daily export is enough. When a collector updates a contact in Prophet 21, the next day's export carries the change, so nobody maintains contacts in two places.
Prophet 21 data | What the AI agent does with it | Who owns exceptions |
|---|---|---|
Open invoices and due dates | Decides who gets a reminder today and on which channel | Collector reviews new accounts added to the slice |
PO and job number | Quotes them in every reminder so AP can match the invoice | Billing fixes invoices missing a PO |
Ship-to or job account | Keeps each reminder tied to the right job and contact | AR manager decides how accounts roll up |
AP email and phone | Sends email and text, places calls | Collector fixes bounced or wrong contacts in Prophet 21 |
Partial payments | Asks about the open remainder and records the reason given | Collector researches and resolves the deduction |
Credit hold status | Skips or flags accounts on hold | Credit manager decides on releases |
How Do You Roll It Out Without an Integration Project?
Start with one slice of the aging report, prove it, then widen the slice. A rollout that keeps your team in control looks like this:
Pick the first slice. Small balances past due are a good start, for example invoices under $1,000, because they are the ones your team never reaches.
Start with a set group of customers. Begin with around 100 accounts, read the replies for a few days, then add more.
Let the agent follow up by email, text and phone on your schedule, logging every touch against the invoice.
Route anything that needs a person to a person. Unit rate disputes, deductions, returns and promises to pay go to your team with the full history attached.
Raise the threshold as trust builds, and add your larger contractor and job accounts once the first slice runs cleanly.
What to measure in the first 30 days
Share of the slice that paid or gave a payment date without a collector touching it.
Number of accounts handed back to your team, and the reasons: deductions, disputes, wrong contacts.
Movement in the 31 to 60 day bucket for the customers in the slice versus the rest of the ledger.
Hours your collectors got back each week, and what they spent them on.
If the handbacks are mostly wrong contacts, fix the contact data in Prophet 21 before widening the slice. If they are mostly deductions, that is a billing or rate-file problem worth raising with your sales team.
What stays with your collectors
Deductions and short pays that need research against unit rates, freight or returns.
Credit hold decisions. A credit hold policy keeps those consistent; the agent only flags.
Key accounts where a relationship call from someone who knows the customer matters. See resolving invoice disputes for how to run the hard conversations.
What Should Reminders to Distribution Customers Say?
Distribution reminders work when they give AP everything needed to match and pay in one message. A reminder that only states the balance gets set aside.
Contractor and job accounts
Lead with the job name or number, the PO, the invoice numbers and the delivery dates. Group the invoices for one job together so the customer's project manager can approve them in one pass.
Short pays
Name the invoice, the amount paid and the amount still open, and ask one question: what was the remainder held for? The reason the customer gives goes straight to your collector, who can approve a credit or push back with backup.
Small counter accounts
Keep it short: invoice number, amount, a way to pay. These customers often simply missed it, and a polite reminder clears the balance without a phone call.
Common Questions From Prophet 21 AR Teams
Bounced emails and wrong numbers
When a reminder bounces, the account is flagged so a collector can fix the contact in Prophet 21. The next export picks up the fix and outreach resumes.
Accounts your team is already working
Mark them for removal and outreach stops on them, so a customer never hears from two people about the same invoice.
How Abivo Helps Distributors on Prophet 21
Abivo's AI collections agent, Kate, works from your daily Prophet 21 export. Kate follows up on overdue invoices by phone, text and email, asks for the PO and remittance details AP needs, logs every touch, and hands deductions, disputes and promises to pay to your team with the conversation attached. Your collectors spend their day on research and key accounts instead of chasing small balances.
For a wider view, see our roundup of the best collections software for industrial distributors and our guide on how to reduce DSO at a distribution company, plus the guides for wholesale distributors and building materials distributors. On a different system? Here is how to automate collections in ECI e-automate and how to export an AR aging report from Acumatica, and the systems we work with are on our integrations page. For results from a field services business, read how OFS Group unlocked trapped AR with AI.
Practical Takeaways for Prophet 21 AR Teams
Export once a day. An open invoice export with PO numbers and AP contacts is all an AI agent needs to start.
Put the PO and job number in every reminder. Unmatched invoices are stuck, not late.
Group invoices by job or ship-to so customers get one message, not six.
Start with small balances and about 100 customers, then raise the cutoff.
Keep deductions, credit holds and key accounts with your collectors.
Clear unapplied cash before you start, so customers are not chased for invoices they already paid.
FAQ
Does Abivo integrate directly with Epicor Prophet 21?
Abivo works from a scheduled export of your open invoices and customer contacts, so no direct integration or IT project is needed to start.
Which Prophet 21 invoices should an AI agent handle first?
Start with small past-due balances, for example under $1,000, for a set group of about 100 customers. Widen the group and raise the threshold once the first slice runs cleanly.
What happens when a customer short pays an invoice?
The agent asks the customer why the remainder was held and passes the answer to your collector with the full conversation attached. Your team decides whether to credit or collect.
Will customers know the reminder came from us?
Yes. Reminders go out under your company name and use the contacts on the customer's account.
Do we have to change how we invoice in Prophet 21?
No. Your team keeps invoicing as it does today. The one habit that helps is making sure PO numbers are on invoices before they go out.
Running Prophet 21 with three or more people on collections? Get started and we will set up a pilot on your own aging report. Prefer to talk it through first? Book a 30-minute call.







