Epicor Prophet 21 and Database Compatibility Level

A common question amongst those who administrate the Epicor Prophet 21 ERP system revolves around Microsoft SQL Server and the setting that controls compatibility level on the Prophet 21 database.  Compatibility levels in SQL Server are primarily used to control backward compatibility for legacy applications.  Essentially, if you are running SQL Server 2016, but your […]

Continue reading
prophet 21 database

Prophet 21 Database : Basic Performance Settings

The Prophet 21 database, which runs on Microsoft SQL Server, is large and highly complex.  To get the best performance from the system, administrators should make sure that they have at least some of the basic database properties configured for better performance.  People dedicate entire careers to SQL performance tuning, and this post is not […]

Continue reading
p21 database indexing

P21 Database: Adding a Missing Index

It should be commonly understood that any ERP system is built to appeal generally to a wide variety of companies. Epicor is no exception to the rule.  This is a fundamental principle of how you make money selling software.  You build a product with broad appeal, and then customize it where you have to here […]

Continue reading
dynachange screen designer

5 Tips for Prophet 21 DynaChange Screen Designer

One of the more powerful features in Epicor’s Prophet 21 ERP system is the DynaChange Screen Designer.  This feature of P21 allows you to change the layout of windows on the screen.  This allows companies to improve workflows, streamline data entry, and make the user’s experience better overall.  Below are 5 things you can do […]

Continue reading
sql query prophet 21

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

Prophet 21 Help: Automating Item Bin Deletion

Epicor’s Prophet 21 has several useful functions that are designed to help keep your database clean and running in top condition.  Unfortunately, many of these functions require you to execute via the user interface, meaning that a human has to get involved.  One of my coworkers jokingly describes this as: “the monkey has to be […]

Continue reading