# China ERP UAT Test Script Worksheet

> Source: https://netray.co/tools/china-erp-uat-test-script-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable UAT tracker with executed and passed counts per script and an overall pass rate for go/no-go.

## Category

erp-migration

## Region

China

## Audience

- Test lead
- ERP project manager
- Process owner

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Script ID

**Key:** id

**Type:** text

#### Business process

**Key:** process

**Type:** text

#### Area

**Key:** area

**Type:** select

**Options:**

- Finance
- Procurement
- Sales
- Inventory
- Production
- Quality
- Integration

#### Tester

**Key:** tester

**Type:** text

#### Steps

**Key:** steps

**Type:** number

#### Steps passed

**Key:** passed

**Type:** number

#### Pass rate

**Key:** pass_pct

**Type:** number

**Expr:** if(gt(steps,0), passed / steps * 100, 0)

**Format:** percent

#### Open defects

**Key:** defects

**Type:** number

#### Result

**Key:** result

**Type:** select

**Options:**

- Not run
- Pass
- Fail
- Blocked

**Rows:**

**Id:** UAT-001

**Process:** Create purchase order with 13% VAT and receive goods

**Area:** Procurement

**Tester:** Buyer

**Steps:** 12

**Passed:** 12

**Defects:** 0

**Result:** Pass

**Id:** UAT-002

**Process:** Issue VAT fapiao from sales order

**Area:** Sales

**Tester:** Billing clerk

**Steps:** 10

**Passed:** 7

**Defects:** 2

**Result:** Fail

**Id:** UAT-003

**Process:** Backflush production order and report scrap

**Area:** Production

**Tester:** Supervisor

**Steps:** 15

**Passed:** 15

**Defects:** 0

**Result:** Pass

**Id:** UAT-004

**Process:** Month-end close and statutory trial balance

**Area:** Finance

**Tester:** Accountant

**Steps:** 20

**Passed:** 0

**Defects:** 0

**Result:** Not run

**Id:** UAT-005

**Process:** Bank payment file upload

**Area:** Integration

**Tester:** Treasury

**Steps:** 8

**Passed:** 3

**Defects:** 1

**Result:** Blocked

**Totals:**

#### Total steps

**Key:** steps

**Agg:** sum

**Format:** integer

#### Steps passed

**Key:** passed

**Agg:** sum

**Format:** integer

#### Open defects

**Key:** defects

**Agg:** sum

**Format:** integer

**Summary:**

#### Overall step pass rate

**Key:** overall

**Expr:** sum_passed / sum_steps * 100

**Format:** percent

**Primary:** true

**Notes:** Agree go/no-go thresholds before testing, for example zero open critical defects and all finance and shipping scripts passed. Testers should be business users, not the consultants.

## Content

**Intro:** User acceptance testing decides whether the plant is ready. This tracker shows pass rate and open defects per script so the go/no-go meeting works from numbers, not impressions.

**Sections:**

#### How to use it

**Body:** List one row per end to end script, name the business tester and count the steps. After each run, record steps passed, open defects and the result. The pass rate and the overall figure update automatically. Export the sheet after each test round and keep it as evidence for sign-off.

#### What to test in China

**Body:** Beyond core flows, include issuing and receiving VAT fapiao, tax code selection, bilingual documents and labels, bank payment files, statutory reports and role based approvals. Test with real data copies and real user roles, as test super users hide authorisation problems.

**Bullets:**

- Order to cash with fapiao issuing
- Procure to pay with input VAT
- Production backflush and scrap
- Period close and statutory reports

#### Common mistakes

**Body:** Do not count a script as passed when a workaround was used; mark it with a defect. Avoid testing only happy paths, so include returns, credit notes, partial receipts and reversals. Finally, retest every fixed defect and update the row, otherwise old failures linger in the totals.

**Cta:** Netray can talk through automating regression checks against your ERP data before and after each fix.

**Faq:**

#### What pass rate is acceptable?

**Answer:** It depends on risk. Many teams require all critical scripts passed and no open critical defects, with minor issues accepted by the process owner.

#### Who should run UAT?

**Answer:** Business users who will use the system daily. Consultants can support, but the sign-off must come from the business.

#### How many scripts do I need?

**Answer:** Enough to cover each end to end process and key exceptions. A mid-size plant often has dozens to a couple of hundred.

#### Can I export it?

**Answer:** Yes, the worksheet exports to Excel and CSV.

## Search terms

erp uat test script template, user acceptance testing excel erp, erp test case tracker, uat tracker template, china erp uat, kingdee uat test cases, go no go criteria erp

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json