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