Epicor Prophet 21
Business Intelligence
P21 is a distribution ERP managing purchasing, inventory, sales, AR, and GL in a single SQL Server database. Sample data — numbers for demo only.
Executive Metrics
Cash Conversion Cycle
How many days to turn a PO into cash. Tracks inventory age, DSO, and DPO.
Customer Analysis
Customer Aging & DSO
AR aged across 30/60/90/120/150-day buckets with per-customer DSO.
Service Orders
Actual vs. Estimate
Compare estimated vs. actual price and cost for service items on production orders.
Sales
Sales Trend Analysis
Analyze sales trends using the Sales Master Inquiry for period-over-period comparisons.
Sales
Who Bought What
Every invoice line for the last 365 days — customer, item, price, COGS, and margin.
Inventory
Safety Stock Setup
Configure safety stock levels to prevent stockouts while minimizing carrying costs.
Sales
Profit Exception
Order lines with margin outside expected range — catch below-cost sales and pricing errors.
Accounts Receivable
AR Trial Balance
Open customer invoice balances aged by due date — reconcile AR to the GL on a monthly basis.
Accounts Payable
AP Trial Balance
Open vendor invoice balances aged by due date — reconcile AP to the GL on a monthly basis.
Finance
Revenue
Monthly revenue trends, year-over-year comparison, and breakdown by branch and product group.
Operations
Service Orders
Process and track service orders, labor, parts, and billing through completion.
Purchasing
Supplier On-Time Delivery
Compare required vs. actual receipt dates — see which suppliers are driving stockouts.
Inventory
Turn & Earn
Rank items by turns × margin — find your stars and your dead stock.
Executive Metrics
Branch Performance
Compare sales, margin, and operational KPIs across branches and locations.
Sales
Sales History
Every invoiced product line — revenue, COGS, and gross profit by item, customer, and branch.
Purchasing
Purchase Orders
Open PO status, receipts, and variance analysis against forecasted demand.