Epicor Prophet 21: When Should I Use DRP Forecasting?

Advanced Forecasting is an often spoken about subject at an Epicor Prophet 21 related event.  There is a good reason for this, its a complicated module.  There are a lot of moving parts to Prophet 21 ERP’s Advanced Forecasting, and it takes time to get your head wrapped completely around the concepts.  One of these […]

Continue reading

Prophet 21 SQL – Using P21 Views vs NOLOCK

I see this topic debated from time to time.   People who spend a fair amount of time writing queries against the Prophet 21 database are sometimes confused between using the views and writing queries directly against the tables.   Most of the time the standard answer I see is “Always use the Prophet 21 […]

Continue reading

Resisting Change: 5 People who Kill Projects (Part 3)

Change Resistors…Chapter 3 Previously, we discussed the Detractor, the Shield, the Holdback, and the Pacifist.  In this final post of the series on people who resist change, we will explore the traits of the Fortuneteller.   We will also briefly cover trust and some of the more drastic measures under the heading of “the Nuclear […]

Continue reading

Resisting Change: 5 People Who Kill Projects (Part 2)

More about Resisting Change In the last installment about people who resist change, we talked about the Detractor and the Shield.  Today we are going to talk about 2 more archetypes: the Holdback and the Pacifist. The Holdback The Holdback is a potential high-value asset to the organization.  She is either very tuned into the […]

Continue reading

Resisting Change: 5 People Who Kill Projects (Part 1)

Change is hard.   The most powerful force in many organizations is the status quo.  Moving the status quo even just a little can feel a lot like trying to push a fire truck up a hill in San Francisco.  This is the first in a series of articles that can help you identify and […]

Continue reading

Prophet 21 DynaChange Rule: Pre-SQL Hooks

Epicor introduced the Pre-SQL hook as a new feature for the DynaChange Rule in version 12.17.   This feature extends the reach of a DynaChange Rule to insert business logic, including modifying the SQL statement itself, before the statement executes.  This can be a slippery slope.  P21 is a complex application, and tinkering too much […]

Continue reading

P21 ERP: 5 Ideas for Prophet 21 DynaChange Rules

In a previous post, I laid out the business case for DynaChange Business Rules as an essential part of any Prophet 21 deployment.  Business rules are an important arrow in your company’s quiver that allow you to adapt P21 ERP to your business process and streamline operations.  In my experience, it is the little things […]

Continue reading

5 Reasons Employee Training is Critical for Success

How many times have you seen a new employee join the team but not be productive for months?  Why don’t companies do a better job making the investment in training a new employee?  We hire them, and then throw them to the wolves with a “oh they will figure it out” attitude.  It is completely […]

Continue reading

ERP Project Management is not a Part Time Job

Too many times I watch companies spend an immense amount of financial resources to get a new ERP system, and then skimp out in the one area that is the most critical to success…people.  Today, I beg those companies who are on the verge of deploying ERP not to be half-hearted about getting the right […]

Continue reading