Epicor Prophet 21 · Live
Business Intelligence
24 live views over one P21 database. Sample data — demo only.
Live Operations
AIGinger (P21 Assistant)
Ask Ginger in plain English — read live P21 data and create orders or receipts, with your approval before any write.
Ad-hoc Analysis
AIWeb Query
Ask for any cut of the data in plain English — Ginger writes the SQL, runs it read-only, and returns the table.
Live Operations
AIIncoming POs
Open purchase orders waiting at the dock — receive everything with one click using all the defaults, or line by line.
Live Operations
AICycle Counts
What should you be counting? Overdue items by ABC class — pick them, count them, and Ginger posts the adjustment with your approval.
Live Operations
AIAutomatic Shipping
Batch-confirm pick tickets that shipped as planned — set criteria, build the batch, and Ginger ships them with your approval.
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.
Operations
Service Items
Serialized equipment under service — click an item to add or modify its service orders.
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.
Operations
Production
Open production orders — assembly items, quantities to build, shortages, and expected completion dates.
Sales
Sales History
Every invoiced product line — revenue, COGS, and gross profit by item, customer, and branch.
Sales & CRM
P21 Leads
Prospect and pipeline tracking — log, assign, and follow up on leads from your sales team.
Sales
Customer Ranking
Every customer scored 0–100 — sales count and quantity lift the score, RMA count and quantity drag it down.
Purchasing
Supplier Report Card
One row per vendor — on-time rate, fill rate, lead time stability, and 12-month spend. Sort by any KPI.