# ERP UAT Defect Log Worksheet (Severity, Owner, Retest Status) > Source: https://netray.co/tools/erp-uat-defect-log-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A defect log for ERP user acceptance testing with severity, owner, status and ageing, ready to export to Excel. ## Category erp-migration ## Audience - ERP test lead - ERP project manager - Business key user ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Defect ID **Key:** id **Type:** text #### UAT script **Key:** script **Type:** text #### Summary **Key:** summary **Type:** text #### Severity **Key:** severity **Type:** select **Options:** - 1 Blocker - 2 Major - 3 Minor - 4 Cosmetic #### Type **Key:** type **Type:** select **Options:** - Configuration - Data - Custom code - Interface - Security role - Training - Requirement #### Assigned to **Key:** owner **Type:** text #### Status **Key:** status **Type:** select **Options:** - New - In progress - Fixed, retest - Closed - Deferred #### Raised **Key:** raised **Type:** date #### Age (days) **Key:** age **Type:** number **Rows:** **Id:** D-101 **Script:** P2P-04 **Summary:** Goods receipt posts to wrong inventory location **Severity:** 2 Major **Type:** Configuration **Owner:** Inventory consultant **Status:** In progress **Raised:** 2026-10-12 **Age:** 8 **Id:** D-102 **Script:** O2C-07 **Summary:** Pack list missing customer PO number **Severity:** 3 Minor **Type:** Custom code **Owner:** Developer **Status:** Fixed, retest **Raised:** 2026-10-13 **Age:** 7 **Id:** D-103 **Script:** FIN-02 **Summary:** AP clerk cannot access vendor bank change screen **Severity:** 2 Major **Type:** Security role **Owner:** Security lead **Status:** New **Raised:** 2026-10-15 **Age:** 5 **Id:** D-104 **Script:** MFG-11 **Summary:** Work order cannot be released, routing missing **Severity:** 1 Blocker **Type:** Data **Owner:** Data lead **Status:** In progress **Raised:** 2026-10-16 **Age:** 4 **Totals:** #### Total defects **Key:** id **Agg:** count **Format:** integer #### Oldest defect (days) **Key:** age **Agg:** max **Format:** integer #### Average age (days) **Key:** age **Agg:** avg **Format:** decimal **Notes:** Enter age as days since raised. Typical exit rule: zero open blockers and an agreed number of open major defects with workarounds before cutover. ## Content **Intro:** During UAT the defect log becomes the most watched document in the project. This worksheet keeps severity, type, owner and age in one place so the go-live decision rests on facts. **Sections:** #### How to use the log **Body:** Log each failed test step once, linked to the UAT script ID so retests are easy to find. Write a summary a developer can act on: what you did, what happened and what you expected. Choose severity using your agreed definitions. Pick the defect type honestly, because the mix tells you where the problem sits: many Data defects point to migration quality, many Training defects point to missing enablement. Update status daily during a test cycle and export to Excel for the daily triage call. **Bullets:** - Link to the script ID - One defect per row - Update daily during UAT - Retest before closing #### Severity definitions **Body:** Write the definitions before testing starts. A common scheme: Blocker means a core process cannot be executed and no workaround exists. Major means a core process works only with a workaround or has wrong financial or inventory results. Minor means a non-critical function is affected with an easy workaround. Cosmetic means wording, layout or label issues. Sponsors usually set go-live criteria on blockers and majors, for example none open blockers and an agreed small number of majors with approved workarounds. **Bullets:** - Blocker: no workaround - Major: wrong results or heavy workaround - Minor: easy workaround - Cosmetic: no business effect #### Reading the numbers **Body:** Watch three signals: open blockers and majors, ageing, and the inflow rate. A falling inflow with a stable test pass rate suggests convergence. A rising average age suggests a fix bottleneck, often one overloaded developer or a vendor wait. Compare defect types across cycles. If the same data defects reappear after each load, fix the migration rules rather than patching records in test. #### Common mistakes **Body:** Teams mix change requests into the defect list, which inflates defects and hides scope creep. Others close defects without retest. A third mistake is logging vague items such as screen is wrong. Always route a defect that is really a new requirement through change control. Keep a clear Deferred status for agreed post go-live fixes, with an owner and a date, so deferral is a decision and not a loss. **Cta:** If the same data defects keep reappearing, we can discuss validating migrated data against the source with read-only AI queries. **Faq:** #### What is a UAT defect log? **Answer:** A record of every failure found during user acceptance testing with severity, owner, status and linked test script. It drives daily triage and provides evidence for the go-live decision. #### What is the difference between a defect and a change request? **Answer:** A defect means the system does not behave as agreed. A change request means the agreed requirement itself changes. Mixing them hides scope growth and distorts quality metrics. #### How many open defects are acceptable at go-live? **Answer:** Set exit criteria before testing. Common practice is zero open blockers and no unapproved majors, with every remaining defect carrying a documented workaround and a fix date. #### Who should triage defects? **Answer:** A small daily group: the test lead, a functional consultant, a developer and a business key user. They confirm severity, assign owners and agree retest dates. ## Search terms ERP UAT defect log template, UAT defect tracker excel, defect log template, user acceptance testing issue log, ERP testing defect report, UAT bug tracking spreadsheet, defect severity matrix ERP --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json