Prophet 21 guides

Prophet 21 is an ERP system built for wholesale distributors. These guides are for the people who keep it running: administrators, report writers and developers. They explain how the parts fit, and they help you choose the change that is cheapest to own over the next several upgrades.

If you are new to the system, read them in order. If you have a specific job, jump to the one that matches it.

1. How a Prophet 21 system fits togetherA conceptual map of a Prophet 21 installation, from the SQL Server database and middleware tier to the clients, background services and hosting.Explanation · Introductory · 6 min read
2. DynaChange Rules, Designer, a report or an integration?A decision guide for Prophet 21 change requests. Match the request to the lightest tool that solves it, and know what each option costs you at upgrade time.Decision guide · Intermediate · 5 min read
3. Planning a Prophet 21 data importPlan a Prophet 21 data load you can trust, with dependency order, rehearsal loads in a non-production copy and reconciliation that decides when it is done.How-to · Intermediate · 5 min read
4. Custom transactional forms with Crystal ReportsThe custom-copy pattern for Prophet 21 transactional forms, how to make form changes that survive upgrades and how to test them before customers see them.How-to · Intermediate · 5 min read
5. Reading Prophet 21 data with SQL, safelyQuery a Prophet 21 database without risking data or slowing users, with a read-only login, locking on a busy ERP and short starter queries on orders and items.How-to · Intermediate · 5 min read
6. Prophet 21 integration options, and how to chooseHow to connect Prophet 21 with other systems through APIs, file imports, database reads or middleware, and the questions that decide between them.Decision guide · Intermediate · 6 min read
7. SQL Server care for an on-premises ERP databaseA working checklist for the SQL Server under an on-premises ERP such as Prophet 21 software, from backups and restore tests to memory, tempdb and patching.How-to · Intermediate · 14 min read