Prophet 21 Upgrade Checklist
A Prophet 21 upgrade touches customizations, integrations, reports and every user. Most failures come from skipped testing or an unknown integration, not from the upgrade routine itself. This checklist walks the phases so nothing important is discovered on the morning of go-live.
0 of 36 items complete
13 critical items still open - these are the highest-risk gaps.
1. Planning and scope
2. Environments and backups
3. Customizations and reports
4. Integrations and devices
5. Testing and training
6. Cutover and post go-live
Critical items are the ones that most often cause failed cutovers or a rollback. Do not schedule go-live until every critical item is done or has a written, accepted risk.
Custom report upgrade review
Optional: send your custom report and view list and we will point out the ones most likely to need rework.
Optional. The tool and every export work without this. No spam.
How to use the checklist
Work through the six phases in order, ticking items as they are completed and flagging those that are not applicable. Critical items are marked because they are the ones that most often cause a rollback. Use it as a shared status page in project meetings and export the result to PDF for sign-off. Run the checklist twice: once at planning to scope effort, and again before the go and no-go meeting to confirm readiness.
Why the test copy matters most
An upgrade rehearsal on a real copy of production shows you timing, data issues and broken customizations before they affect the business. Restoring from backup also proves your backups work, which many teams have never checked. Insist that users, not just IT, test using their real daily scenarios, including edge cases like returns, special orders and drop ships. Anything that is only tested by the administrator will fail on the first real order.
Customizations and integrations
These are the two biggest sources of surprise. A report that reads a table directly can break if the schema changes. A third-party add-on may not yet support the target version. An integration may rely on a credential or endpoint that changes. Inventory them all early, prune what is unused, and test each with real sample transactions. If a vendor cannot confirm support for the target version, that is a schedule risk to raise immediately.
Common mistakes
Skipping month end testing is common, and the first close on the new version is the worst time to find a problem. Scheduling cutover at peak season or quarter end compresses the safety margin. Not writing down a rollback point means nobody knows when it is too late to go back. Finally, treating training as optional leaves users working around changed screens in ways that create data problems.
Frequently Asked Questions
How long does a Prophet 21 upgrade take?
It depends on version gap, database size, customizations and testing depth. The technical upgrade itself may take hours, while planning and testing commonly take weeks to a few months. Allow time for at least one full rehearsal on a production copy.
What breaks most often during an upgrade?
Custom reports, direct database views, third-party add-ons and integrations. Standard screens usually work, but anything built on assumptions about tables, fields or endpoints needs retesting. Inventory them early so they are not discovered during cutover.
Do I need a test environment?
Yes. Upgrading production without a rehearsed copy is the single biggest avoidable risk. The test copy proves timing, shows customization problems, and lets users practice before go-live.
When should I go live?
Choose a window away from month end, quarter end, year end and your seasonal peak, with leadership available for decisions. Many distributors upgrade over a weekend with a half-day buffer before Monday opening.
If you want custom reports and queries reviewed for upgrade impact, we can help analyse your exported report and view definitions and flag the ones that need attention.
Related Tools
Prophet 21 Data Cleanup Checklist
A checklist for cleaning item, customer, vendor, pricing and inventory data in Prophet 21 before an upgrade, migration or reporting project.
EpicorProphet 21 Pricing Library Design Worksheet
Plan each price page: who it applies to, which product group, the cost basis and multiplier, and the resulting gross margin, before anyone keys it into the system.
EpicorProphet 21 Inventory Replenishment Calculator
Work out order point, safety stock, EOQ and a max level for a distribution item, then compare against what your P21 replenishment parameters say.
EpicorEclipse ERP Cycle Count Procedure Template
A fill-in cycle count procedure for a distribution branch: scope, ABC frequencies, tolerances, recount and adjustment approval, ready to print or share.
More Epicor tools
See all- Prophet 21 Special Order Request Form Template
- Prophet 21 Vendor Return Authorization Request Template
- P21 Dead Stock Hold vs Liquidate Calculator
- P21 Price Matrix Multiplier and Margin Calculator
- Prophet 21 Inventory by Location SQL Generator
- Prophet 21 Open Order and Backorder SQL Generator
- Prophet 21 Order to Cash Go-Live Test Checklist
- Epicor Kinetic Job Status Reference
- Epicor BAQ Query Template Generator