D365 Finance and Supply Chain UAT Test Case Worksheet
User acceptance testing is where business owners confirm the system supports their daily work. This worksheet gives you a simple tracker for scenarios, results and defects with progress and pass rate calculated for you.
| Test ID | Business process | Scenario | Expected result | Tester | Result | Defect ID | Run (1 if executed) | Passed (1 if pass) | |
|---|---|---|---|---|---|---|---|---|---|
Set Run to 1 when a case is executed and Passed to 1 when it passes. Link test IDs to Req IDs in your fit-gap register and to Azure DevOps test plans.
Generate regression tests from your process docs
Optional: a private assistant that drafts test cases from your design documents for human review.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Write scenarios in business language, such as a purchase order received and invoiced with three-way match, not a click path. Assign a tester from the business, run the case in the UAT environment, then mark Run and Passed. Link failed cases to a defect ID. The summary shows execution progress and the pass rate of cases actually run, which is a better signal than a pass count alone.
- Scenarios should span a whole process end to end
- Testers must be real users, not consultants
- Include negative and security cases
- Record defect IDs so retests are traceable
Coverage across D365 processes
Organize cases by end-to-end process: procure to pay, order to cash, plan to produce, record to report, and inventory and warehouse. Add security tests that confirm segregation of duties, and period-end cases that matter to finance. Stable, repeatable cases can later be recorded with the Task recorder and automated with the Regression Suite Automation Tool to support One Version updates.
Exit criteria
Agree the exit criteria before testing starts: for example, all must-have processes executed, no open severity 1 or 2 defects, and agreed workarounds for lower severities. A pass rate is only meaningful when the denominator reflects real coverage, so check the executed percentage first.
Common mistakes
UAT often fails because testers are borrowed from other work, test data is unrealistic, or scenarios are narrowly scripted so that real-world exceptions are never touched. Another is treating UAT as training. Keep a separate training track so test cycles remain focused on acceptance.
Frequently Asked Questions
How is UAT different from SIT?
System integration testing is run by the project team to confirm components and integrations work together. UAT is run by business users to confirm the system supports their real processes and meets acceptance criteria before go-live.
How many UAT cycles are normal?
Two cycles are common, with a retest of fixes in between. Complex rollouts add more. Plan time for defect fixing and retesting, not only for first-run execution.
Can I automate UAT?
Parts of it, yes. Repeatable flows can be recorded and run with the Regression Suite Automation Tool, but business acceptance still needs a human decision. Automation is most valuable for regression after updates.
What data should testers use?
Use a recent, masked copy or migrated data close to production quality. Synthetic demo data hides real problems such as long descriptions, special characters and unusual unit conversions.
If you want to turn recorded business processes into repeatable regression tests, Netray can help design a private pipeline that generates and maintains test cases from your documentation.
Related Tools
D365 Finance and Supply Chain Fit-Gap Analysis Worksheet
An editable fit-gap register that totals gap hours and cost by fit type, so you can see the true size of customization before you commit.
Microsoft DynamicsD365 Finance and Supply Chain Functional Design Document Template
A fill-in functional design document for a D365 F&O gap, covering requirement, process, data, security and test approach, with sign-off lines.
Microsoft DynamicsD365 Finance and Supply Chain Cutover Plan Template
A cutover runbook skeleton for a D365 F&O go-live: freeze, extraction, load, validation, go/no-go and rollback, with sign-off lines.
Microsoft DynamicsD365 Finance and Supply Chain Change Request Form Template
A change request form for D365 projects and production support with impact on scope, effort, security, data and testing, plus approval lines.
More Microsoft Dynamics tools
See all- D365 F&O OData URL Builder
- D365 Data Management Import Worksheet Template
- D365 Batch Job Checklist
- D365 Security Role Design Worksheet
- D365 One Version Update Test Checklist
- D365 Finance and Supply Chain Data Migration Mapping Worksheet
- D365 Finance and Supply Chain Integration Interface Register
- D365 Finance and Supply Chain Implementation Effort Estimator
- D365 F&O Inventory Dimensions Reference
Keep exploring
Free tools
- D365 Finance and Supply Chain Data Migration Mapping WorksheetAn editable source-to-target field mapping sheet with transformation rule, owner and load status for D365 F&O data migration.
- D365 Finance and Supply Chain Change Request Form TemplateA change request form for D365 projects and production support with impact on scope, effort, security, data and testing, plus approval lines.
- D365 Finance and Supply Chain Functional Design Document TemplateA fill-in functional design document for a D365 F&O gap, covering requirement, process, data, security and test approach, with sign-off lines.
ERP fixes and how-tos
- Dynamics 365 Supply Chain Management API: OData, Custom Services and Data PackagesD365 Supply Chain / F&O APIs explained: OData data entities, custom services, the data management package API, Entra ID authentication and when to use each.
- How to Refresh a Dynamics 365 F&SCM Sandbox From ProductionStep by step: refresh a Dynamics 365 Finance and Supply Chain sandbox from production using LCS database movement, plus the post-refresh checklist most teams skip.
- Dynamics 365 Supply Chain Wave Planning and Inventory JournalsHow wave planning and inventory journals work in Dynamics 365 Supply Chain Management: wave templates, wave steps, work templates, journal names and posting.
AI on your ERP
- AI for Dynamics 365 Finance and Supply Chain beyond CopilotAI for D365 Finance and Supply Chain beyond Microsoft Copilot: private LLM grounded on data entities and OData, on-prem-capable via Local Business Data.
- AI for Dynamics 365 Finance and Supply Chain ProcurementAI for Dynamics 365 Finance and Supply Chain procurement: purchase orders, vendor invoices, product receipts and approvals via OData and data lake exports.
Integrations
- How to use ChatGPT with Dynamics 365 Finance and Supply ChainUsing ChatGPT with Dynamics 365 Finance and Supply Chain: custom GPT actions over OData, exports versus live access, data controls and when to go private.
- How to connect Microsoft Teams to Dynamics 365 Finance and Supply ChainConnect Dynamics 365 Finance and Supply Chain to Microsoft Teams: business events, adaptive cards, Power Automate approvals and Entra ID auth, with limits.
Software
- Microsoft Dynamics 365 Finance and Supply ChainDynamics 365 Finance and Supply Chain Management explained for manufacturers: modules, data entities, OData, deployment, strengths, limits and alternatives.
- Dynamics 365 Field ServiceDynamics 365 Field Service handles work orders, resource scheduling and mobile technicians on Microsoft Dataverse. Modules, integrations and alternatives.