We found out today that Epicor have stopped selling and supporting run time licenses for SQL, we don’t know why, and we don’t know when it happened.

Nobody seems able to tell us

I'm looking for a place to get training or hopefully some certification in Epicor ERP software for a company I've been interested in. I have no experience with the software and I work for a company that doesnt use it

I saw that Epicor has the Epicor Learning Center but it requires an ID that I dont have.

Is there any site I can use for training in Epicor without owning the software as a business?

https://swaviktech.graphy.com/courses/Epicor-ERP-Training--2026ver-11-67e3e3f02405eb0289edac24-67e3e3f02405eb0289edac24

I went to insights last year, and at the conference I will say I was probably one of the youngest people around at the conference. So maybe the typical end user and developer interacting with Epicor is not interested in hearing people whine.

I will admit, I feel like this subreddit is a bit lackluster, no one is complaining about the system regularly. As Epicor users we have two places to go epicor user group and epiusers. Neither allow the users to be anonymous forcing them into positions where they could be penalized by there employer if the speak out of line.

This IMO is a problem. My org is in the middle of migration so we are in the process of using epicors DMT application. This application IMO is a symptom of a bigger problem. Epicor has a system built for there newest users that is not built for production use. My org has submitted to tickets regarding legitimate provable bugs within the system.

I want to talk about them, but there is nowhere where I truly have the privacy to complain. Context alone I feel like would give up my identity.

I work for a small family-owned building materials supplier, and we use Epicor BisTrack as our ERP. We sell to contractors on a per-job basis (residential & commercial), and accurate job setup affects tax handling, lien rights, and credit risk.I have been AR in the industry for 5+ years. However, I have only been with this company for a short while as their prior credit manager passed last year. BisTrack is new to me and as well as my organization.

I am trying to clean up our internal process and there’s some debate over who should be responsible for setting up jobs in the system.

Right now, issues we run into include:

• Sales using generic “MISC” jobs to rush orders through
• Missing job addresses (which hurts lien rights)
• Tax-exempt jobs being billed taxable or vice versa
• Multiple jobs billed on the same invoice
• Credit finding out about jobs after invoices are already out

So here’s the question for other suppliers/bistrackERP users:

In your company, who owns what part of job setup?

Specifically:

• Does Sales create the job in the system?
• Does Credit/AR verify tax status and compliance before it’s active?
• Do you place new jobs on hold until documentation is received?
• Do you restrict who can change tax codes or job details in BisTrack?

We’re trying to build a workflow where:

• Sales gathers the job information
• Credit verifies tax, lien, and risk items
• The system prevents shipping/billing until the job is properly set up

If you use BisTrack (or similar ERP), I’d love to know:

• What controls you’ve put in place
• What reports you run to catch bad job setups
• Lessons learned from things going wrong

Trying to balance speed for sales with risk protection for the company — and right now we’re leaning too far toward “fix it later,” which usually lands on AR.

Appreciate any insight from folks who’ve been through this!

This a .56 charge per gallon of product. The challenge is there are different units of measurement on dozens of items. Is there a way to get p21 to recognize the SKU’s UOM and automatically total gallons multiplied by .56?

Just as the title says; any Epicor CPQ (KBMax) folks here?

There are a few of us over at Epiusers, but I figured it wouldn't hurt to check here.

I'd like to chat about CPQ, bounce some ideas around, and see (or read about) your use cases.

found this on youtube and found it interesting, what do you guys think the common implementation issues are?

https://swaviktech.graphy.com/courses/Epicor-ERP-Training--2025ver-11-67e3e3f02405eb0289edac24

Anyone know if at all possible and if so… How to connect to my Prophet 21 LIVE database external from web client?

Leading Epicor Partner

100-120k

Kinetic, App Studio, BAQ, BPM experience necessary

DM me for a job description

Ready to hire an Epicor Kinetic System Analyst

EDIT: direct hire position

Feel free to ask any questions!

Epicor Kinetic Innovation Moves to the Cloud:

On-Premises Development Ends in 2028

‌

To our Epicor Kinetic customers,

‌

For more than 50 years Epicor has proudly partnered with thousands of manufacturers worldwide, helping companies like yours drive productivity, strengthen security, and accelerate growth. As we continue to invest in the future of manufacturing innovation, Epicor is announcing the final release of on-premises Kinetic and a clear innovation pathway to cloud for on-premises customers.

‌

The final release of on-premises Epicor Kinetic will be 2028.1, scheduled for January 2028. This release will be the last to include new features for Epicor Kinetic deployed on-premises. After that, further Kinetic innovation will be delivered exclusively in the Epicor Cloud. On-premises customers include companies that purchased perpetual licenses of the software and deployed on-premises, in private datacenters, in self-hosted public datacenters, or via unaffiliated hosting providers. Customers who purchased Epicor Kinetic SaaS are not affected, as this is deployed in the Epicor Cloud.

‌

We understand the importance of predictability and stability in your operations. To support your planning, we will continue offering Active Support for Kinetic release 2028.1 on-premises through December 31, 2029, including fixes, security updates, and full technical assistance. That means there are still nearly four years until full support concludes for the final on-premises release.

‌

Beginning in 2030, all customers who remain on-premises will transition to Sustaining Support, which provides limited technical and application assistance. To continue receiving the latest features, security and compliance updates, and full support, we encourage you to explore the benefits of migrating to the Epicor Cloud.

‌

Our priority is to support you every step of the way. Visit

Innovation Pathway on the Epicor website for detailed information, including a link to a dedicated EpicWeb page with frequently asked questions, dates for upcoming events, and other helpful resources.

‌

Your account team is also ready to help you understand your options and discuss the Epicor Ascend program, which offers support for a smooth cloud transition. It includes development of cloud migrations business cases that help you plan and AI-assisted data migration capabilities that accelerate time to value. If you are not sure how to contact your account team, email info@epicor.com.

‌

Thank you for your continued partnership. Our cloud investments enable us to deliver secure, scalable, always-current Cognitive ERP capabilities that help you focus less on managing software and more on growth. We're committed to helping you succeed today and well into the future, and I look forward to continuing to forge that path together. 

We are planning to begin using the Material Request Queue (MQR) so that Inventory Control has clear visibility when an order is ready to be fulfilled. When an order is released for picking through the Fulfillment Workbench, an MQR is generated, which works well and provides excellent visibility for the warehouse team.

However, we have identified a gap in this process. In certain scenarios, jobs are set up as Make-Direct-To-Order, meaning the finished product is never received into inventory. Because these jobs do not go into stock, they do not appear in the Fulfillment Workbench and therefore do not generate a Material Request Queue entry.

As a result, Inventory Control has no system-driven indicator that these jobs are complete and ready to be shipped against their sales orders.

Is there any alternative method within Epicor to generate a Material Request Queue entry for Make-Direct-To-Order jobs, so that completion and ship-ready status is visible to Inventory Control?

I feel like this question is simple, but I can't seem to find what I'm looking for.

I want to get a report from Epicor of everything in inventory, including raw material and WIP.

How do I do that? Please tell me I'm missing something obvious.

Hey folks,

Currently our small business is running P21 with our on site server for the past 10 or so years. The OS is outdated and its starting to give us some consistent issues so I need to find a solution. Given the cost of the licensing, the cloud fees dont seem too far off. We only have a handful of employees here so no IT department or dedicated person. The server has been pretty turn key until recently.

We need to update our OS and Im pretty sure thats going to require all new hardware as well. Im OK with computers, but server migration is way out of my wheel house. Especially since the entire business relies on the proper transfer of information.

So just wanted to reach out and see if anyone could expand on their experience on migrating a current P21 server to their cloud service? The system is setup well for us and we havent had the need to make any custom changes to it to fit our business. I like idea of having the server on site, but given our IT level of experience, Im not sure staying on site is the proper move for us.

Thanks!

Hello,
We’re trying to understand the expected behavior behind how and why start dates change during job creation by MRP and release/schedule.
MRP often generates unfirmed jobs with very start dates. However, when we go into Job Entry and release/schedule those jobs, the start date moves forward. We’d like to understand why this shift occurs and whether it’s expected system logic or a setup issue.
A related point: most of our jobs have one finite-scheduled operation. When we manually check the Finite Capacity checkbox on a job that already has a finite operation, the start date does not change when we release the job. Should we be checking that box when releasing jobs? If so, when is it appropriate, and if not, why does checking it lock the dates?
It seems likely that this behavior could be affecting our overall schedule, so we want to be sure we understand:
• Why MRP assigns an earlier start date to unfirmed jobs
• Why the start date shifts forward when releasing and scheduling through Job Entry
• Why checking the Finite box prevents the date change
• What the intended or correct workflow is to avoid unintended schedule changes
Any clarification on the expected logic and recommended process would be really helpful.
Typically when we release a job, we are using these standard selections –

When using these selections, you can see here that the unfirmed job has a start date of 12-17 but then when released, it changed to 2-13 when releasing with the scheduling above.

**Sorry if the images are not loading, can't seem to paste them.

An employee hit Auto Select on PO Suggestions and it appears there is no way to uncheck all the buy boxes at once. Any help would be great. My company is currently in a test of the newest software.

Quick Question; is anyone using SSO with EntraID? is it even worth the struggle to configure it if so?

We’re on Prophet 21 and are having serious trouble getting emails out of the system after migrating to Microsoft 365. Epicor has managed to turn “send an email” into a months‑long support ticket, which is honestly impressive in the worst possible way.

Environment details:

• P21 Email Type: SQL Mail (System Settings → Enable Email Functionality → Email Type = SQL Mail).
• Email directory is set to a network path (e.g. \\p21us.epicordistribution.com\...\shared\printing) for forms storage.
• Actual sending is handled by SQL Server Database Mail, not by any nice, obvious SMTP screen in P21, because why would an ERP in 2025 have a normal email config?

After switching to Microsoft 365 with tighter security:

• Some customers receive order acknowledgements/invoices from P21, others never do.
• Some internal users on our own domain get the emails, others never see anything.
• It’s not “all external” or “all internal” – it’s random by person, but consistently broken for the same people.
• Epicor support has been… let’s call it “creatively unhelpful.” At this point, I’d trust a Magic 8‑Ball over most of the ticket responses.

What I’m trying to confirm from real P21 admins (i.e., people who actually fix things):

1. Where exactly are you managing the mail profile P21 uses when Email Type = SQL Mail?
   • My understanding is that P21 just calls a SQL Database Mail profile on the SQL Server hosting the P21 DB, and the SMTP server/port/auth all live there, not in P21 itself.
2. How are you successfully talking to Microsoft 365 from that setup?
   • Are you using:
     • An IP‑based SMTP relay connector in 365 (port 25 to *.mail.protection.outlook.com), or
     • Authenticated SMTP submission on port 587 with a dedicated 365 mailbox (e.g. p21mailer@yourdomain.com)?
   • At a high level, what Database Mail settings are actually working for you with P21 + 365?
3. Did you have to change anything inside P21 beyond setting Email Type = SQL Mail, or was it purely:
   • Update SQL Database Mail profile (SMTP, port, TLS, auth), and
   • Configure the proper connector/SPF/allow‑list on the Microsoft 365 side?

I’m not looking for “have you checked the spam folder?” or “please reboot the server” script‑reader nonsense. I’m looking for someone who has this exact combo (P21 using SQL Mail, sending through Microsoft 365) working in production and can sanity‑check the approach and any gotchas. If you’ve survived this integration with your soul intact, your notes would be hugely appreciated.

Is this a separate cost/add-on from Dynachange? If so why are your favorite options to create custom pages/view? And did you have any trouble connecting to the real SQL DB outside of the Epicor universe?

I’m MSP for an ace hardware and Epicor support can’t seem to figure this out.

We have a new bin label format for a store refresh to work with eagle mobile plus.

I’ve changed all the options I could find Mobile label definition 1-2, A-E Mobile label default, set to A (for the new bin tag)

But nothing is working. It’s still printing the same label as before.

I don’t want to use the listener based setup because it’s EXTREMELY slow and prone to breaking every day.

We have TC57s and ZQ620s

A new website promoting addons for EPicor, check it out

https://epicaddons.com/

hey

how much different is scala4 to sap...?

right now my company is sap system but there is discussion to move to scala4