How do I get better reports and integrations from Epicor P21 or Eclipse?

By Ranjit Bhinge, founder of Blur Studio · Updated · 8 min read

Short answer: Epicor Prophet 21 and Epicor Eclipse are two ERP systems (software that runs orders, stock, purchasing and accounting) for wholesale distributors. Prophet 21 has a tool called Report Studio that builds reports and dashboards without coding and exports them to Excel. Eclipse has standard reports, "as of" reports and Epicor Data Analytics dashboards. For anything the standard tools miss, such as profit by customer after freight, the usual fix is a separate dashboard that reads the data and leaves your ERP alone.

Ranjit Bhinge

Your Epicor system holds every order, price and invoice, and you still wait half a day for the weekly numbers.

I'm Ranjit, and I run Blur Studio: 15+ years building software, 120 apps taken live, and clients who have gone on to raise $10M+. I build AI systems and processes that help businesses do a lot more with a lot less time. I also work differently from most of what else is out there, more on that further down this page. Say hello.

Two Epicor systems, two reporting tools

Epicor, a business software company, sells two ERP products that distributors often mix up. ERP stands for enterprise resource planning: one system that holds orders, stock, purchasing, pricing and the books. Prophet 21 (people say P21) is Epicor's ERP for distributors across many trades, from electrical to janitorial to tile. Eclipse is Epicor's ERP aimed at electrical, plumbing, HVAC and pipe, valve and fitting distributors. Your reports depend on which one you run. A closer look is in Prophet 21 alternatives.

As of November 2026, Epicor's pages say this about reporting:

  • Prophet 21: Epicor Report Studio builds operational reports and dashboards that can be exported to Excel, with no database or coding skills needed. Epicor says it draws on analytics from Epicor Grow. Its examples are up-to-the-minute financial reports, sales by employee and order type, and outstanding invoices by customer.
  • Eclipse: built-in standard reports and "as of" reporting, plus Epicor Data Analytics (EDA), which adds interactive dashboards and data analysis. An "as of" report shows figures as they stood on a past date, which helps at month end.

Prophet 21 also has Epicor Data Analytics. Epicor's Prophet 21 business intelligence page lists executive dashboards that can be personalized and viewed without logging in to Prophet 21, an accounts receivable dashboard, a sales rep dashboard and a Customer Buying Trend Analysis feature. Epicor describes the last one as a way to spot customers who have started buying less before they formally switch supplier. That is a useful early warning for a distributor. So the tool is not unique to Eclipse, and the difference between the two products is in what sits around it.

Epicor's Eclipse page does not mention an Excel export. Ask your Epicor partner what your version supports. Epicor's pages for both products show no prices, so ask what your current license covers before you assume a report needs a new purchase.

Report examples distributors ask for first

These are the reports I see owners and ops managers ask for most. The first four come standard in some form. The last four usually need more work.

ReportWhat it tells youUsually standard?
Open orders by customerWhat is promised and not yet shippedYes
Outstanding invoices by customerWho owes you money and for how longYes
Sales by rep and order typeWho is selling whatYes
Inventory by locationStock on hand, branch by branchYes
Margin by customer after freight and rebatesWhich accounts really make moneyOften needs custom work
Quotes lost last monthWhere bids went and whyOften needs custom work
Stock below reorder point with supplier lead timeWhat to buy this weekPartly
Orders waiting on a credit holdRevenue stuck at the front deskPartly

The standard ones answer the office's questions. The custom ones answer the owner's questions. That gap is why people search for "epicor reports not working" when the report runs fine and simply is not the report they need.

How to set up a report that is not in the standard list

Work down this list. Each step costs more than the one before it.

  1. Change the filters. Many missing numbers sit in a standard report with a different date range, branch or customer group.
  2. Use the built-in builder. In Prophet 21 that is Report Studio. In Eclipse it is Epicor Data Analytics and whatever report tools your partner set up.
  3. Export and finish in a spreadsheet. Fine for a one-off. It breaks when the person who built the spreadsheet leaves.
  4. Ask your Epicor partner for a custom report. Expect a fee. Ask who owns the report and how it is kept working after an upgrade.
  5. Read the data into a separate dashboard. Your ERP stays as it is, and the owner sees the numbers in a view built for the owner. My guide to KPI dashboards covers what to put on one.

Why Epicor reports stop working

When a report looks empty or wrong, check these in order, from most to least likely.

  1. The filters or date are wrong. An "as of" date left on an old month, or a branch filter left on, is the top cause.
  2. Your user role cannot see the data. Another user runs the same report and gets numbers. Ask your Epicor administrator to compare roles.
  3. Someone edited the report. A custom report changed by a former employee can stop matching the system.
  4. An upgrade changed something. A report built for an old version can fail after an update. Ask your partner to test custom reports in a test copy first.
  5. The date range is huge. A report covering several years can time out. Split it by quarter.
  6. It is a real bug. Open a case with Epicor support with the report name and screenshots.

How exports to Excel behave

Prophet 21's Report Studio exports to Excel, according to Epicor. Any export is a copy of the data at one moment. Two people who export on different days see different numbers, and that is the main reason spreadsheet reports start arguments. If you export weekly, put the export date in the file name and in a cell at the top of the sheet.

A second trap is the spreadsheet itself. Once a manager adds formulas to an export, the formulas stop working the day the column order changes. Keep exports raw, and put your own math on a second tab that points at the raw tab.

What integrations Epicor offers

For Eclipse, Epicor says its API (a way for other software to talk to Eclipse) delivers REST endpoints, runs on a .NET Core engine, and supports get, insert and update activities for selected parts of Eclipse. Premium API bundles cover areas such as sales order management and warehouse integrations. Epicor Commerce is Epicor's cloud ecommerce product, and it is integrated with Eclipse. Epicor's Prophet 21 pages list eCommerce and CRM as features. They describe a software development kit and a customization suite called DynaChange for extending the system without changing its source code, and say the data sits in Microsoft SQL Server, on your own servers or in the cloud. They do not describe a public API in the way the Eclipse page does, so ask your partner what your version exposes and what your support terms allow. For more detail, see Epicor Eclipse versus Prophet 21.

Epicor's product pages list no ready-made connector for HubSpot (a CRM, which is a customer database for sales teams) or Shopify (an online store platform). In practice there are three ways to link them:

  • A middleware tool: a service that sits between the two systems and moves data on a schedule. Cheapest to start, but it has monthly fees and a fixed set of fields.
  • A custom connection: someone writes code against the Epicor API or database. Costs more up front, and moves exactly the fields you want.
  • A scheduled file: Epicor exports a file, and the other system imports it. Crude, but it works for small jobs such as nightly customer lists.

Whichever you pick, decide which system wins when the two disagree. For customer names and credit limits it should be Epicor. For marketing contacts it is usually HubSpot. If you sell online, the Shopify B2B and ERP integration guide shows what to sync and what to leave alone. For a general view of joining systems, see AI integration services.

What reporting does Eclipse job management add?

If you bid project work in Eclipse, margin by job already has a home. Epicor's job management page describes a Financial Summary that tracks transactions through the whole job history and reports costs and margins as the job moves. It compares the initial totals with the current totals and change orders, and shows a summary by vendor, customer invoices and vendor invoices. A bid board shows which bids are due each day, and for a lost job you can record the competitor and the reason. That last field is what makes the "quotes lost last month" row in the table above possible without a custom build, as long as staff fill it in every time. Epicor describes this add-on as built for large commercial lighting and switchgear projects, so ask whether it fits your kind of work.

What makes a good first saved report?

Pick one that is asked for every week, has one clear owner, and can be checked against a number someone already trusts. Open orders by customer is a good example. Build it once, save it, and write down three things on the report itself: the filters it uses, who owns it and the date it was last checked. Then run it beside the old method for two weeks. If the numbers match, retire the old method. If they differ, find out why before you add a second report, because a mismatch on the simple report will repeat on every harder one.

Worked example: margin by customer after freight

These figures are made up to show the idea. A distributor sells to a contractor customer. Last month the sales report showed $48,000 in sales and $36,000 in cost of goods, a $12,000 margin or 25 percent. The owner thought that was a decent account.

The standard report left out three things: $2,400 in freight the company paid on delivered orders, $1,100 in returns credits, and $900 in rebates owed under a volume deal. Take those off and the real margin is $7,600, or about 16 percent. Same customer, same month, a very different decision about whether to give the next discount.

That report needs data from orders, freight bills, credits and rebate terms. A single standard report rarely joins them. A small dashboard that reads each source and combines them does.

How I'd approach this

I would start with the owner's three questions, not with the tool. Write down the three numbers you want every Monday. Then check whether Report Studio or EDA can produce each one with a saved report. If it can, set it up once, schedule it, and stop exporting by hand.

For the numbers that need data from more than one place, I would not ask your Epicor partner to bend the ERP. I would read the data out and build a small dashboard beside it. That keeps your upgrade path clean, and it gives you something the owner can open on a phone. If you also want something to summarize the numbers in plain words each week, that is a good first use of AI, and my guide on AI for small business explains where it pays off.

Before you spend, ask your partner three things in writing: who owns any custom report, whether it is tested before each upgrade, and what happens to it if you change partners.

Questions people ask

What reports come with Epicor Eclipse?

Epicor says Eclipse has built-in standard reports and "as of" reporting. Epicor Data Analytics adds interactive dashboards and data analysis. Ask your partner which modules your license includes.

Can Epicor Prophet 21 export reports to Excel?

Yes. Epicor says Report Studio reports and dashboards can be exported to Excel. Epicor's Eclipse page does not mention Excel export, so ask your partner what your Eclipse version supports.

Does Epicor Prophet 21 integrate with HubSpot?

Epicor's product pages list no ready-made HubSpot connector. Distributors usually use a middleware tool or a custom connection. Decide first which system is the source of truth for customer data.

Does Epicor Eclipse have an API?

Yes. Epicor says the Eclipse API delivers REST endpoints and supports get, insert and update activities for selected parts of Eclipse. Premium API bundles cover areas such as sales order management and warehouse integrations.

Why does my Epicor report show no data?

Check the date, the "as of" setting and any branch filter first. Then check your user role, whether someone edited the report, and whether a recent upgrade broke it. See my KPI dashboard guide if the real problem is that the report never showed the right number.

When do I need a dashboard on top of Epicor?

When the number you want needs data from more than one place, such as orders, freight, rebates and quotes, or when the owner wants it on a phone without logging in to the ERP.

More in this topic: B2B: ERP reporting and integrations (10 guides) →

Sources

Ready for the next step?

A 30 minute call. If you do not need me, I will tell you.

Ranjit Bhinge You talk to me, Ranjit. I reply within a few hours.

Not sure what you need? Tell me what is going on. I will point you the right way, even if it is not me.

Blur Studio · 30 minute call

Book a 30 minute call

You talk to me, Ranjit. If you do not need me, I will tell you.

  • We talk about your business and what is going on.
  • You leave with a clear next step, even if it is not me.
  • I reply to every message within a few hours.
Loading the calendar…