Epicor UAT Test Script Worksheet
User acceptance testing is where an Epicor project is won or lost. This worksheet keeps the script, tester, status and defects together and calculates the pass rate you need for the go live decision.
| Test ID | Process | Step | Expected result | Tester | Status | Passed (1/0) | Defects | Date run | |
|---|---|---|---|---|---|---|---|---|---|
Set Passed to 1 when status is Pass so the pass rate updates. Write steps in business language, use real customers, parts and jobs from your data, and have each tester sign off their own area.
Test plan review
An optional review of your UAT scope, scripts and exit criteria.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Add a row per test case with a short ID, the business process, the step and the result you expect. Assign a tester from the business, not the project team. During testing, update status, set Passed to 1 for passes and record defects found. The summary calculates pass rate and defects per test so you can report progress each day. Export to Excel for the steering group.
- Write steps in business terms
- Use real data
- Assign business testers
- Update daily
Designing good test cases
Cover whole processes end to end, from quote to cash or procurement to payment, and not only individual screens. Include negative cases such as invalid parts, missing approvals and credit holds. Add cases for your customizations, BPM directives and reports, since these are where the standard test scripts do not reach.
Reading the results
A high pass rate with untested areas is misleading, so count blocked and not run tests too. Look at where defects cluster by process. Agree entry and exit criteria before testing starts, such as no open critical defects and a minimum pass rate for each process, and record any accepted risks with owners.
Common mistakes
Testing with clean demo data hides problems that appear with real master data. Letting consultants run the tests instead of users hides usability and training gaps. Failing to retest after a fix is the third common error, so re-run failed cases and record the new date.
Frequently Asked Questions
What is UAT in an Epicor project?
User acceptance testing is when business users run real processes in a test or pilot environment to confirm Epicor works for them before go live. It checks configuration, data, customizations and reports against real needs, and ends with a documented sign off.
How many test cases do I need?
Enough to cover each core process and each customization, usually dozens to a few hundred depending on scope. Quality matters more than count: end to end scenarios with realistic data find more problems than many isolated screen checks.
What pass rate is acceptable?
Set it before testing. Many teams require all critical cases to pass and a high overall rate with no open critical defects. The right threshold depends on your risk tolerance, so record exceptions and who accepted them.
Who should run the tests?
The people who will do the work after go live. They know the exceptions and will spot gaps a consultant would miss. The project team supports, logs defects and retests, but should not be the main testers.
If you want help building a test script from your actual processes and customizations, Netray can support the effort.
Related Tools
Epicor DMT Data Load Plan Worksheet
Sequence your Epicor Data Management Tool loads with record counts, rates and estimated run time, then export the plan to Excel.
EpicorEpicor BPM Directive Design Template
A fill-in design document for BPM method and data directives covering trigger, conditions, actions, testing and rollback.
EpicorEpicor BPM Directive Inventory Worksheet
Inventory your BPM directives, score complexity and retest effort, and see total upgrade retest hours. Export to Excel.
EpicorEpicor Customization Change Request Template
A change request form for Epicor customizations that captures the business need, impact, test plan and approvals before anyone opens the tool.
More Epicor tools
See all- Epicor Kinetic Customization Change Request Form Template
- Epicor Kinetic Go-Live Cutover Plan Template
- Epicor Kinetic User Access Request Form Template
- Epicor Kinetic BPM Directive Inventory Worksheet
- Epicor Kinetic Scheduled Task Register Worksheet
- Epicor Kinetic Custom Report Inventory Worksheet
- Epicor Kinetic Data Migration Mapping Worksheet
- Epicor Kinetic Data Load Effort Calculator
- Epicor Business Object Services Reference
New to Epicor ERP? Start with the Epicor ERP guide and toolkit, or plan with Training Path Builder, ERP Certification Study Planner, Upgrade Path Planner.
Keep exploring
Free tools
- Epicor Kinetic Data Load Effort CalculatorEstimate total data migration hours for an Epicor project from record counts, error rate and number of test cycles.
- Epicor Upgrade Regression Test Effort CalculatorSize the regression testing for an Epicor upgrade from test cases, failure rate, fix time and tester count.
- ERP UAT Test Script TemplateA user acceptance test worksheet with example order-to-cash and procure-to-pay scripts, tester columns and result tracking you can export to Excel.
ERP fixes and how-tos
- Epicor Kinetic Export to Excel Not WorkingFix Epicor Kinetic export to Excel and copy to Excel failures on grids and dashboards: browser downloads, Office on the client, row limits and permissions.
- How to Add AI to Epicor Kinetic On-Premises Without Moving Your DataReference architecture for a private AI assistant on Epicor Kinetic on-premises: BAQ and REST v2 access, SQL replica, local LLM, roles, audit and rollout.
- Convert Epicor Classic Dashboards to KineticHow to convert Epicor Classic dashboards to Kinetic during an upgrade: what carries over, what must be rebuilt, and how to verify each dashboard.
AI on your ERP
- Private AI for Epicor Kinetic Cloud, Outside the Multi-Tenant BoundaryRun a private LLM on Epicor Kinetic private cloud or Kinetic Cloud data via BAQs, REST v2 and Data Fabric, keeping sensitive manufacturing data off shared AI.
- AI for Epicor Kinetic Job Shops: Quote History, Job Variance and Schedule RiskPrivate AI for Epicor Kinetic job shops: quote-to-job history, JobHead and JobOper variance, subcontract delays and schedule risk, via REST and BAQs.
Integrations
- How to add an AI chatbot to Epicor KineticAdd an AI chatbot to Epicor Kinetic: an internal assistant for planners and buyers or a customer portal bot, grounded in BAQs and runnable fully on-prem.
- How to add AI agents to Epicor KineticHow to add AI agents to Epicor Kinetic: a tool layer over the REST v2 API and BAQs, MRP exception triage, PO expediting, and human approval before any write.
Software
- Epicor KineticEpicor Kinetic explained for manufacturers: modules, REST API, BAQs, deployment, strengths, limits and alternatives to compare before choosing or upgrading.
- Epicor CPQEpicor CPQ is a cloud configure-price-quote product with visual 3D configuration for manufacturers. Modules, ERP integrations and alternatives explained.