0% found this document useful (0 votes)
38 views66 pages

Factory Management System Unit Test

The document outlines a unit test for the Factory Management System, specifically for the Smart Factory project. It includes detailed test cases and results for various functionalities, such as screen layout, input validation, authority checks, and export functions. The testing results indicate both successful and unsuccessful test cases, highlighting areas that need improvement.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
38 views66 pages

Factory Management System Unit Test

The document outlines a unit test for the Factory Management System, specifically for the Smart Factory project. It includes detailed test cases and results for various functionalities, such as screen layout, input validation, authority checks, and export functions. The testing results indicate both successful and unsuccessful test cases, highlighting areas that need improvement.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

IVS JOINT STOCK COMPANY

Asean Business Divison

Unit Test

Customer :

System Name :

Project Name :

Version :

Status :

System Released on :

Preserved in :

Created by :

Created on :

Last Revised by :

Last Revised on :

Copyright © 2013
IVS

Factory Management System

Smart Factory

1.0

Copyright © 2013
System Name Factory Management System Function ID Approved By
Project Name Smart Factory Function Name Production Issue Approved On
Document Name Unit test Created By 12/30/1899 Revised By
Document ID Created On 30-12-1899 Revised On

Document History

Date Version Author Comments


12/30/1899 1.0 30-Dec-99 Initial Creation

Tracking 3/66 IVS Project


Note

Tracking 4/66 IVS Project


System Name Factory Management System Function ID
Project Name Smart Factory Function Name Production Issue
Document Name Unit test Created By LPBTAN
Document ID Created On 13/9/2024

[Production Issue] Add screen

Add
Approved By Note
Issue Approved On
Revised By
Revised On
ote
System Name Factory Management System Function ID 1st Tester Date
Project Name Smart Factory Function Name Production Issue 2nd Tester Date
Document Name Unit test Created By LPBTAN 3rd Tester Date
Document ID Created On 13/9/2024 Note

Result
No. Test Item Detail Fields / Reference / Remark Target
1st 2nd
1 Basic item
1.1 Source has been described following development's standard reference [[Link]] ○
1.2 Source comment has been described following development's standard reference [[Link]] ○
2 Screen layout
2.1 The screen title is correct? ○
2.2 The screen layout is same as design? ○
2.3 Image of buttons are correct (Delete, Save, Back, Update, ...)? ○
2.4 Message block has been displayed correctly? ○
2.5 Error messages are displayed correctly? ○
2.6 All control (button, label...) have been layout correctly in compare to design? ○
2.7 Have any omitted word, incorrected word in label or title of all control (button, label) ○
2.8 Text field is left aligned ○
2.9 Number, Currency field is right aligned ○
2.10 Date, Time field is right aligned ○
Currency = VND: #,###
2.11 Currency field is under "xxx,[Link]" format Currency = USD: #,### ○
Currency = JPY: #,###
2.12 Tab index has been set correctly? Left to right, up to down ○
2.13 Format of displayed date is correct? yyyy/mm/dd ○
2.14 When click Enter key, Submit action is created? ×
2.15 Password is displayed by "*" (asterisk) ×
2.16 Confirm Password is displayed by "*" (asterisk) ○
2.17 Mandatory fields has red "(*)" at the beginning of field ○
2.18 Menu (status, sub menu list) has been set correctly? ○
2.19 Status of all textbox has been set correctly? Editable/Readonly/Hidden ○
2.20 Status of all button has been set correctly? Enable/Disable/Invisible ○
2.21 Status of all compobox has been set correctly? Editable/Readonly/Hidden ○
3 Search/List Screen
3.1 Number of displayed records is correct? ×
3.2 Are the input value in search condition re-displayed? ×
3.3 If search result has data, number of records is correct ×
3.4 If search result has more than 100 row, do system show error message correctly and exit event? ×
3.5 Sort order are correct. ×
3.6 Group by default is correct? ×
3.7 Group by options are correct? ×
3.8 The result grid can be sorted by clicking the header titles. ×
3.9 Width of columns can resize manually. ×
3.10 Height of rows (include Header row) can not resize manually ×
4 Input/DetailSQL
Preventing Screen
injection attacks
4.1 When sql keyword is inputted, is displayed correctly? Input value is displayed as the original inp ○
4.2 Ex: " ' "; "--",contains
Combobox "' ; DROP table
value M_XXXX;"
correctly? ○
4.3 In controls to input character, is maxlength correctly set? = size of database field ○
4.4 Message type is suitable? "Error", "Warning", "Information", … ○
5 Authority
5.1 User, that do not have right to Add New in this function, can't register new data ○
5.2 User, that do not have right to Modify in this function, can't modify data ○
5.3 User, that do not have right to Delete in this function, can't delete data ○
5.4 User, that do not have right to View in this function, can't open the function ○
5.5 Menu list is correct with role of logined user? ○
6 Export function ( Export to file, print Document)
6.1 Output filename is correct with design? ○
6.2 Output data is correct ○
6.3 8.3.1 Output 0 record ○
6.4 8.3.1 Output 1 record ○
6.5 8.3.1 Output many records ○
6.6 Output order is correct ○
6.7 Format of output file is as the same as the template file ○
6.8 Edited data is not saved to the database ○
7 Common function
7.1 In case at least 1 field is modified, a confirmation message (save or not save) is shown ○
7.2 When insert/update/delete data, a confirmation message is shown ○
7.3 There is a message to indicate saved data correctly ○
7.4 Can save data correctly with mandatory fields input only ○
7.5 Can save data correctly with every fields input ○
7.6 On screen input data and DB data is matched ○
7.7 Saved data is displayed correctly ○
7.8 revised_id, deleted_id are correct ○
7.9 revised_date, deleted_date are correct ○
7.10 Is event log created correct? Insert into table TBL_LOG ○
7.11 When show/insert/update data, had been trimmed? Check each field ○
8 Additonal case: Maxlength
8.1 Operating Unit 50 ○
8.2 Warehouse 50 ○
8.3 Document Type 50 ○
8.4 Document No 50 ○
8.5 Created By 50 ○
8.6 Created Date 50 ○
8.7 Document Date 50 ○
8.8 Issued By 50 ○
8.9 Status 50 ○
8.10 Description 150 ○
8.11 No. (Grid View) ○
8.12 Instruction No (Grid View) ○
8.13 Operation (Grid View) ○
8.14 Item Code (Grid View) ○
8.15 Item Name (Grid View) ○
8.16 Unit (Grid View) ○
8.17 Quality Status (Grid View) ○
8.18 Quantity (Grid View) ○
8.19 Lot No (Grid View) ○
8.20 Location (Grid View) ○
8.21 Production Date (Grid View) ○
8.22 Remark (Grid View) ○
9 Additonal case: Control displays all characters when input full text
9.1 Operating Unit displays all characters ○
9.2 Warehouse displays all characters ○
9.3 Document Type displays all characters ○
9.4 Document No displays all characters ○
9.5 Created By displays all characters ○
9.6 Created Date displays all characters ○
9.7 Document Date displays all characters ○
9.8 Issued By displays all characters ○
9.9 Status displays all characters ○
9.10 Description displays all characters ○
9.11 No. (Grid View) displays all characters ○
9.12 Instruction No (Grid View) displays all characters ○
9.13 Operation (Grid View) displays all characters ○
9.14 Item Code (Grid View) displays all characters ○
9.15 Item Name (Grid View) displays all characters ○
9.16 Unit (Grid View) displays all characters ○
9.17 Quality Status (Grid View) displays all characters ○
9.18 Quantity (Grid View) displays all characters ○
9.19 Lot No (Grid View) displays all characters ○
9.20 Location (Grid View) displays all characters ○
9.21 Production Date (Grid View) displays all characters ○
9.22 Remark (Grid View) displays all characters ○
10 Additonal case: Format of displayed is correct?
10.1 Operating Unit char ○
10.2 Warehouse char ○
10.3 Document Type char ○
10.4 Document No char ○
10.5 Created By char ○
10.6 Created Date datetime ○
10.7 Document Date datetime ○
10.8 Issued By char ○
10.9 Status char ○
10.10 Description char ○
10.11 No. (Grid View) number ○
10.12 Instruction No (Grid View) char ○
10.13 Operation (Grid View) char ○
10.14 Item Code (Grid View) char ○
10.15 Item Name (Grid View) char ○
10.16 Unit (Grid View) char ○
10.17 Quality Status (Grid View) char ○
10.18 Quantity (Grid View) char ○
10.19 Lot No (Grid View) char ○
10.20 Location (Grid View) char ○
10.21 Production Date (Grid View) number ○
10.22 Remark (Grid View) char ○
11 Additonal case: When input full text, the string is saved to DB correctly
11.1 Operating Unit ○
11.2 Warehouse ○
11.3 Document Type ○
11.4 Document No ○
11.5 Created By ○
11.6 Created Date ○
11.7 Document Date ○
11.8 Issued By ○
11.9 Status ○
11.10 Description ○
11.11 No. (Grid View) ○
11.12 Instruction No (Grid View) ○
11.13 Operation (Grid View) ○
11.14 Item Code (Grid View) ○
11.15 Item Name (Grid View) ○
11.16 Unit (Grid View) ○
11.17 Quality Status (Grid View) ○
11.18 Quantity (Grid View) ○
11.19 Lot No (Grid View) ○
11.20 Location (Grid View) ○
11.21 Production Date (Grid View) ○
11.22 Remark (Grid View) ○
12 Additonal case: Alignment
12.1 Operating Unit Left ○
12.2 Warehouse Left ○
12.3 Document Type Left ○
12.4 Document No Left ○
12.5 Created By Left ○
12.6 Created Date Center ○
12.7 Document Date Center ○
12.8 Issued By Left ○
12.9 Status Left ○
12.10 Description Left ○
12.11 No. (Grid View) Center ○
12.12 Instruction No (Grid View) Center ○
12.13 Operation (Grid View) Left ○
12.14 Item Code (Grid View) Left ○
12.15 Item Name (Grid View) Left ○
12.16 Unit (Grid View) Left ○
12.17 Quality Status (Grid View) Left ○
12.18 Quantity (Grid View) Left ○
12.19 Lot No (Grid View) Left ○
12.20 Location (Grid View) Left ○
12.21 Production Date (Grid View) Center ○
12.22 Remark (Grid View) Left ○
Result 0/159
Result 0/159
Result 0/159

Result
Note
2nd 3rd
UTP_outline-01

In Case Sub case Expected result No.

Mode = Add 1.1


Mode = Edit
Status = Non- 1.2
1 Load Load default data allocated

Mode = Edit
1.2
Mode = Allocated

Left to Right, Top to


2 Tab Index 2.1
Bottom

Go to [Get Item]
3 Get Items 3.1
screen

All values in fields is


4 Clear 4.1
empty

Set blank all 5.1


5.2
5.3
5.4
Show a validation 5.5
5 Mode=Add message 5.6
Validation
5.7
5.8
5.9
5.10
Save Save successfully 5.11
5.12
5.13
5.14
5.15
5.16
5.17
5.18
5.19
5.20
Update successfully 5.21
Show [Inventory]
6 Inventory 6.1
screen
7 Export Show [Export] value 7.1

Don't change Value Screen is closed 8.1

8 Close
8 Close Show confirm
Don't save 8.2
Change value message
Save Update successfully 8.3
General Header

Authorize Common Document Date


Warehouse (*) Issued By (*) Status (*) Description
(*)

○ ○

○ ○

○ ○

○ 1 2 3 5 6

○ ○

○ ○

○ ○
○ ○
○ ○
○ ○
○ ○
○ ○
○ ○ ○
○ ○ ○ ○
○ ○ ○ ○ ○
○ ○ ○ ○ ○ ○
○ ○ ○ ○ ○ ○
○ ○
○ ○
○ ○
○ ○
○ ○
○ ○ ○
○ ○ ○ ○
○ ○ ○ ○ ○
○ ○ ○ ○ ○ ○
○ ○ ○ ○ ○ ○

○ ○

○ ○

○ ○
○ ○

○ ○
System Name Factory Management SystemFunction ID 1st Tester Date
Project Name Smart Factory Function Name Production Issue 2nd Tester Date
Document Name Unit test Created By LPBTAN 3rd Tester Date
Document ID Created On 13/9/2024 Note

Test Screen Result


No. Pre-Requisites Expected result Target 1st 2nd 3rd
1 Load
- Click Manage Stock > Transaction Management >
Transaction Issue > Production Issue - Show the [Add] screen
1. Prepare a user account with full
+ [Warehouse], [Document Date], [Issued By], [Status]
right on [Production Issue] screen
1.1 and [Description] is editable ○
2. Prepare data as sheet [DataTest-
There are 8 button:[Get Item], [Save], [Save and Next],
Prerequisite-01]
[Inventory], [Print Sheet], [Export] [Clear], [Close]

- Click Manage Stock > Transaction Management >


Transaction Overview - Show the [Edit] screen
'- [Transaction Type] = "Production Issue" + [Warehouse], [Document Date], [Issued By], [Status]
1.2 Continue above case - Click [Search] button and [Description] is editable ○
- Double-click row with [Status] = "Non-allocated" There are 6 button:[Get Item], [Save], [Inventory], [Print
Sheet], [Export], [Close]
- Click Manage Stock > Transaction Management >
Transaction Overview - Show the [Edit] screen
'- [Transaction Type] = "Production Issue" + [Issued By] and [Description] is editable
1.3 Continue above case - Click [Search] button ○
There are 6 button:[Save], [Inventory], [Print Sheet],
- Double-click row with [Status] = "Allocated" [Export], [Cancel], [Close]

2 Tab Index
- Click Manage Stock > Transaction Management >
1. Prepare a user account with full Transaction Issue > Production Issue When you press [Tab] on keyboard. Control will be
right on [Production Issue] screen focused on [Warehouse] then you press [Tab] on the
2.1 ○
2. Prepare data as sheet [DataTest- keyboard the focused control will move form left to right,
Prerequisite-01] top to bottom

- Click Manage Stock > Transaction Management >


1. Prepare a user account with full Transaction Overview When you press [Tab] on keyboard. Control will be
right on [Production Issue] screen '- [Transaction Type] = "Production Issue" focused on [Warehouse] then you press [Tab] on the
2.2 - Click [Search] button ○
2. Prepare data as sheet [DataTest- keyboard the focused control will move form left to right,
Prerequisite-01] - Double-click row with [Status] = "Allocated" top to bottom

3 Get Items
- Click Manage Stock > Transaction Management >
1. Prepare a user account with full Transaction Issue > Production Issue
right on [Production Issue] screen - Click [Get item] button
-Show popup message: " [Warehouse] must be filled in!" ○
2. Prepare data as sheet [DataTest-
Prerequisite-01]

- Click Manage Stock > Transaction Management >


1. Prepare a user account with full Transaction Issue > Production Issue
right on [Production Issue] screen - Fill data for [Warehouse]
[Get Item] screen is opened ○
2. Prepare data as sheet [DataTest- - Click [Get item] button
Prerequisite-01]

4 Clear
- Click Manage Stock > Transaction Management >
1. Prepare a user account with full Transaction Issue > Production Issue
right on [Production Issue] screen - Click [Clear] button
4.1 All fields are empty. ○
2. Prepare data as sheet [DataTest-
Prerequisite-01]

5 Save
- Click Manage Stock > Transaction Management >
Transaction Issue > Production Issue
- Click [Save] button 1. Show message:
1. Prepare a user account with full
[Warehouse] must be filled in!
right on [Production Issue] screen
5.1 [Status] must be filled in! ○
2. Prepare data as sheet [DataTest-
[Issue By] must be filled in!
Prerequisite-01]
Transaction list must be filled in!

- Click Manage Stock > Transaction Management >


Transaction Issue > Production Issue
+ [Warehouse] = "NVL"
1. Show message:
- Click [Save] button
[Status] must be filled in!
5.2 Continue above case ○
[Issue By] must be filled in!
Transaction list must be filled in!

- Click Manage Stock > Transaction Management >


Transaction Issue > Production Issue
- Click [Add] button 1. Show message:
+ [Document Date] = "6/9/2024" [Warehouse] must be filled in!
5.3 Continue above case - Click [Save] button [Status] must be filled in! ○
[Issue By] must be filled in!
Transaction list must be filled in!

- Click Manage Stock > Transaction Management >


Transaction Issue > Production Issue
- Click [Add] button
1. Show message:
+ [Issued By] = "IVS01"
[Warehouse] must be filled in!
5.4 Continue above case - Click [Save] button ○
[Status] must be filled in!
Transaction list must be filled in!

- Click Manage Stock > Transaction Management >


Transaction Issue > Production Issue
1. Show message:
- Click [Add] button
+ [Status] = "Allocated"
[Warehouse] must be filled in!
5.5 Continue above case - Click [Save] button ○
[Issue By] must be filled in!
Transaction list must be filled in!

- Click Manage Stock > Transaction Management >


Transaction Issue > Production Issue
- Click [Add] button 1. Show message:
+ [Description] = "A" [Warehouse] must be filled in!
5.6 Continue above case - Click [Save] button [Status] must be filled in! ○
[Issue By] must be filled in!
Transaction list must be filled in!
- Click Manage Stock > Transaction Management >
Transaction Issue > Production Issue
1. Show message:
- Click [Add] button
+ [Warehouse] = "Production Warehouse"
[Status] must be filled in!
5.7 Continue above case + [Document Date] = "13/90/2024" ○
[Issue By] must be filled in!
- Click [Save] button
Transaction list must be filled in!

- Click Manage Stock > Transaction Management >


Transaction Issue > Production Issue
- Click [Add] button 1. Show message:
+ [Warehouse] = "Production Warehouse"
5.8 Continue above case + [Document Date] = "13/90/2024" [Status] must be filled in! ○
+ [Issued By] = "IVS01" Transaction list must be filled in!
- Click [Save] button

- Click Manage Stock > Transaction Management >


Transaction Issue > Production Issue
- Click [Add] button
+ [Warehouse] = "Production Warehouse" 1. Show message:
5.9 Continue above case + [Document Date] = "13/90/2024" Transaction list must be filled in! ○
+ [Issued By] = "IVS01"
+ [Status] = "Allocated"
- Click [Save] button

- Click Manage Stock > Transaction Management >


Transaction Issue > Production Issue
- Click [Add] button
+ [Warehouse] = "Production Warehouse" 1. Show message:
5.10 Continue above case + [Document Date] = "13/90/2024" Line 1: Available quantity is not enough! ○
+ [Issued By] = "IVS01"
+ [Status] = "Allocated"
- Click [Get Items] button
Push data from Get Item form
- Click Manage Stock > Transaction Management >
Transaction Issue > Production Issue
1. Show message:
- Click [Add] button
+ [Warehouse] = "Production Warehouse"
Line 1: Lot No must be filled in!
5.11 Continue above case + [Document Date] = "13/90/2024" ○
Line 1: Production Date must be filled in!
+ [Issued By] = "IVS01"
+ [Status] = "Allocated"
- Click [Get Items] button
Push data from Get Item form
- Click Manage Stock > Transaction Management >
Transaction Issue > Production Issue
- Click [Add] button 1. Show message:
+ [Warehouse] = "Production Warehouse"
5.12 Continue above case + [Document Date] = "13/90/2024" Line 1: Production Date must be filled in! ○
+ [Issued By] = "IVS01"
+ [Status] = "Allocated"
- Click [Get Items] button
Push data from Get Item form
- Click Manage Stock > Transaction Management >
Transaction Issue > Production Issue
- Click [Add] button
+ [Warehouse] = "Production Warehouse" 1. Show message:
5.13 Continue above case + [Document Date] = "13/90/2024" "Do you want to Save?" ○
+ [Issued By] = "IVS01"
+ [Status] = "Allocated"
- Click [Get Items] button
Push data from Get Item form
6 Inventory
1. Click Manage Stock > Transaction Management >
Transaction Overview
1. Prepare a user account with full 2. [Transaction Type] = "Production Issue"
right on [Production Issue] screen 3. Click [Search] button
6.1 Show [Inventory] screen with selected Item Code loaded ○
2. Prepare data as sheet [DataTest- 4. Double click row with [Document No] = "DN001"
Prerequisite-01] 5. Click [Inventory] button

7 Export
1. Click Manage Stock > Transaction Management >
Transaction Overview
1. Prepare a user account with full
2. [Transaction Type] = "Production Issue"
right on [Production Issue] screen
7.1 3. Click [Search] button Show [Export] screen ○
2. Prepare data as sheet [DataTest-
4. Double click row with [Document No] = "DN001"
Prerequisite-01]
5. Click [Export] button

8 Close
1. Click Manage Stock > Transaction Management >
1. Prepare a user account with full Transaction Issue > Production Issue -> Search
right on [Production Issue] screen 2. Click [Search] button
8.1 3. Double click row with [Document No] = "DN001" Close the form ○
2. Prepare data as sheet [DataTest-
Prerequisite-01] 4. Click [Close] button
5. Click [Yes] 1. The system show message "The information changes.
1. Click Manage Stock > Transaction Management > Do you want to save before exit?"
Transaction Issue > Production Issue -> Search 2. The system show message "Data has been
2. Click [Search] button successfully updated."
8.2 Continue above case 3. Double click row with [Document No] = "DN001" ○
3. Result as sheet [Expected Data-01] No.1
4. Change values: 4. [Production Issue] screen is closed
+ [Remark] = "Nguyen Van A" + Reload Girdview, the selected data row is updated on
4.
1. Click
Click [Close]
Managebutton
Stock > Transaction Management > gird
Transaction Issue > Production Issue -> Search
2. Click [Search] button
3. Double click row with [Document No] = "DN001"
4. Change values: Show a message: "Do you want to save?"
8.3 Continue above case + [Remark] = "Nguyen Van A" ○
+ The system will be closed and don't save any value.
4. Click [Close] button
5. Click [Yes]
Result 0/26
Result 0/26
Result 0/26

Evidence Note
1 General

General Header
Warehouse (*) Document Date (*) Issued By (*) Status (*) Description
Production Warehou 13/09/2024 IVS01 Allocated
1 General

General Header
Issued By
Warehouse (*) Document Date (*) Status (*) Description
(*)
Production Warehouse 13/09/2024 IVS01 Allocated
System Name Factory Management System Function ID
Project Name IWMS Function Name Production Issue
Document Name Unit test Created By LPBTAN
Document ID Created On 9/13/2024

[Get Items] screen


Approved By Note
sue Approved On
Revised By
Revised On
System Name Factory Management System Function ID 1st Tester Date
Project Name IWMS Function Name Production Issue 2nd Tester Date
Document Name Unit test Created By TNChau 3rd Tester Date
Document ID Created On 9/6/2024 Note

Result
No. Test Item Detail Fields / Reference / Remark Target
1st 2nd
1 Basic item
1.1 Source has been described following development's standard reference [[Link]] ○
1.2 Source comment has been described following development's standard reference [[Link]] ○
2 Screen layout
2.1 The screen title is correct? ○
2.2 The screen layout is same as design? ○
2.3 Image of buttons are correct (Delete, Save, Back, Update, ...)? ○
2.4 Message block has been displayed correctly? ○
2.5 Error messages are displayed correctly? ○
2.6 All control (button, label...) have been layout correctly in compare to design? ○
2.7 Have any omitted word, incorrected word in label or title of all control (button, label) ○
2.8 Text field is left aligned ○
2.9 Number, Currency field is right aligned ○
2.10 Date, Time field is right aligned ○
Currency = VND: #,###
2.11 Currency field is under "xxx,[Link]" format Currency = USD: #,### ○
Currency = JPY: #,###
2.12 Tab index has been set correctly? Left to right, up to down ○
2.13 Format of displayed date is correct? yyyy/mm/dd ○
2.14 When click Enter key, Submit action is created? ×
2.15 Password is displayed by "*" (asterisk) ×
2.16 Confirm Password is displayed by "*" (asterisk) ×
2.17 Mandatory fields has red "(*)" at the beginning of field ×
2.18 Menu (status, sub menu list) has been set correctly? ○
2.19 Status of all textbox has been set correctly? Editable/Readonly/Hidden ○
2.20 Status of all button has been set correctly? Enable/Disable/Invisible ○
2.21 Status of all compobox has been set correctly? Editable/Readonly/Hidden ○
3 Search/List Screen

Common_02 43/66 IVS Project


3.1 Number of displayed records is correct? ○
3.2 Are the input value in search condition re-displayed? ○
3.3 If search result has data, number of records is correct ○

3.4 If search result has more than 100 row, do system show error message correctly and exit event? ×

3.5 Sort order are correct. ○


3.6 Group by default is correct? ○
3.7 Group by options are correct? ○
3.8 The result grid can be sorted by clicking the header titles. ○
3.9 Width of columns can resize manually. ○
3.10 Height of rows (include Header row) can not resize manually ○
4 Input/Detail Screen
Preventing SQL injection attacks
4.1 When sql keyword is inputted, is displayed correctly? Input value is displayed as the original inp ×
Ex: " ' "; "--", "' ; DROP table M_XXXX;"
4.2 Combobox contains value correctly? ×
4.3 In controls to input character, is maxlength correctly set? = size of database field ×
4.4 Message type is suitable? "Error", "Warning", "Information", … ×
5 Authority
5.1 User, that do not have right to Add New in this function, can't register new data ×
5.2 User, that do not have right to Modify in this function, can't modify data ×
5.3 User, that do not have right to Delete in this function, can't delete data ×
5.4 User, that do not have right to View in this function, can't open the function ×
5.5 Menu list is correct with role of logined user? ×
6 Export function ( Export to file, print Document)
6.1 Output filename is correct with design? ×
6.2 Output data is correct ×
6.3 8.3.1 Output 0 record ×
6.4 8.3.1 Output 1 record ×
6.5 8.3.1 Output many records ×
6.6 Output order is correct ×
6.7 Format of output file is as the same as the template file ×
6.8 Edited data is not saved to the database ×
7 Common function
7.1 In case at least 1 field is modified, a confirmation message (save or not save) is shown ×
7.2 When insert/update/delete data, a confirmation message is shown ×

Common_02 44/66 IVS Project


7.3 There is a message to indicate saved data correctly ×
7.4 Can save data correctly with mandatory fields input only ×
7.5 Can save data correctly with every fields input ×
7.6 On screen input data and DB data is matched ×
7.7 Saved data is displayed correctly ×
7.8 revised_id, deleted_id are correct ×
7.9 revised_date, deleted_date are correct ×
7.10 Is event log created correct? Insert into table TBL_LOG ×
7.11 When show/insert/update data, had been trimmed? Check each field ×
8 Additonal case: Maxlength
8.1 Instruction No 50 ○
8.2 Operation 10 ○
8.3 BOM 50 ○
8.4 Instruction No (Grid View) ○
8.5 Operation (Grid view) ○
8.6 BOM Code (Grid View) ○
8.7 Item Code (Grid View) ○
8.8 Item Name (Grid View) ○
8.9 BOM Quantity (Grid View) ○
8.10 BOM Unit (Grid View) ○
8.11 Issue Quantity (Grid View) ○
8.12 Issue Unit (Grid View) ○
9 Additonal case: Control displays all characters when input full text
9.1 Instruction No Display all characters ○
9.2 Operation Display all characters ○
9.3 BOM Display all characters ○
9.4 Instruction No (Grid View) Display all characters ○
9.5 Operation (Grid view) Display all characters ○
9.6 BOM Code (Grid View) Display all characters ○
9.7 Item Code (Grid View) Display all characters ○
9.8 Item Name (Grid View) Display all characters ○
9.9 BOM Quantity (Grid View) Display all characters ○
9.10 BOM Unit (Grid View) Display all characters ○
9.11 Issue Quantity (Grid View) Display all characters ○
9.12 Issue Unit (Grid View) Display all characters ○

Common_02 45/66 IVS Project


10 Additonal case: Format of displayed is correct?
10.1 Instruction No char ○
10.2 Operation datetime ○
10.3 BOM datetime ○
10.4 Instruction No (Grid View) char ○
10.5 Operation (Grid view) char ○
10.6 BOM Code (Grid View) char ○
10.7 Item Code (Grid View) char ○
10.8 Item Name (Grid View) char ○
10.9 BOM Quantity (Grid View) char ○
10.10 BOM Unit (Grid View) char ○
10.11 Issue Quantity (Grid View) char ○
10.12 Issue Unit (Grid View) char ○
11 Additonal case: When input full text, the string is saved to DB correctly
11.1 Instruction No ○
11.2 Operation ○
11.3 BOM ○
11.4 Instruction No (Grid View) ○
11.5 Operation (Grid view) ○
11.6 BOM Code (Grid View) ○
11.7 Item Code (Grid View) ○
11.8 Item Name (Grid View) ○
11.9 BOM Quantity (Grid View) ○
11.10 BOM Unit (Grid View) ○
11.11 Issue Quantity (Grid View) ○
11.12 Issue Unit (Grid View) ○
12 Additonal case: Alignment
12.1 Instruction No Left ○
12.2 Operation Center ○
12.3 BOM Center ○
12.4 Instruction No (Grid View) Left ○
12.5 Operation (Grid view) Left ○
12.6 BOM Code (Grid View) Left ○
12.7 Item Code (Grid View) Left ○
12.8 Item Name (Grid View) Left ○

Common_02 46/66 IVS Project


12.9 BOM Quantity (Grid View) Left ○
12.10 BOM Unit (Grid View) Left ○
12.11 Issue Quantity (Grid View) Left ○
12.12 Issue Unit (Grid View) Left ○

Common_02 47/66 IVS Project


Result 0/76
Result 0/76
Result 0/76

ult
Note
3rd

Common_02 48/66 IVS Project


Common_02 49/66 IVS Project
Common_02 50/66 IVS Project
Common_02 51/66 IVS Project
Common_02 52/66 IVS Project
UTP_outline-00

In Case Sub case

Don’t permission on this


screen
1 Load
Have permission on this
screen
2 Tab Index
All fields are blank

Data is existed in
database Search by input fileds

3 Search

Data is not existed in


Search by input fileds
database

0 row
4 Push
n row
5 Close
Summary

Expected result No. Common


Instruction No Operation BOM

Don’t display Search on tab Search 1.1 ○

Display Search on tab Search 1.2 ○

Left to Right, Top to Bottom 2.1 1 2 4


3.1 ○
3.2 ○
3.3 ○
3.4 ○
3.5 ○ ○
Show data result 3.6 ○ ○ ○
3.7 ○
3.8 ○
3.9 ○
3.10 ○ ○
3.11 ○ ○ ○
4.1 ○
Error message
4.2 ○
[Production Issue] screen Get Items is
5.1 ○
closed
Grid View

Instruction No Operation BOM Code Item Code Item Name BOM Quantity BOM Unit

1 2 3 4 9 10
Issue Quantity Issue Unit

11 12
System Name Factory Management System Function ID 1st Tester Date
Project Name IWMS Function Name Production Issue 2nd Tester Date
Document Name Unit test Created By 12/30/1899 3rd Tester Date
Document ID Created On 12/30/1899 Note

Result
No. Pre-Requisites Test Screen Expected result Target Evidence
1st 2nd 3rd
1 Load
Click Manage Stock > Transaction
1. Prepare a user account without right Management > Transaction Issue >
on [Production Issue] screen Get Items Production Issue -> Get Items
1.1 You cannot access to [Production Issue] screen Get Items ○
2. Prepare data as sheet [DataTest-
Prerequisite-02]

Click Manage Stock > Transaction


Management > Transaction Issue > You can access to [Production Issue] screen Get Items.
Show all controls in [Production Issue] screen Get Items
1. Prepare a user account with full right Production Issue -> Get Items
and enable status:
on [Production Issue] screen Get Items
1.2 + All fields are empty. ○
2. Prepare data as sheet [DataTest-
+ Gridview is empty.
Prerequisite-02]
+ There are 2 buttons: [OK], [Close].

2 Tab Index
Click Manage Stock > Transaction
1. Prepare a user account with full right Management > Transaction Issue >
on [Production Issue] screen Get Items Production Issue -> Get Items When you press [Tab] on keyboard. Control will be focused
2.1 ○
2. Prepare data as sheet [DataTest- status from left to right and from top to bottom
Prerequisite-02]

3 Search
Click Manage Stock > Transaction
1. Prepare a user account with full right Management > Transaction Issue >
on [Production Issue] screen Get Items Production Issue -> Get Items - Show a message box "1 row(s) found!"
3.1 Click [Search] button or press [Enter] key ○
2. Prepare data as sheet [DataTest- - The result is as sheet [Expected Data-02] No.1.
Prerequisite-02]

Click Manage Stock > Transaction


Management > Transaction Issue >
Production Issue -> Get Items
1. Input value : - Show a message box "1 row(s) found!"
3.2 (same as above) ○
+ [Instruction No] = "PI230601" - The result is as sheet [Expected Data-02] No.1.
2. Click [Search] button or press [Enter] key

Click Manage Stock > Transaction


Management > Transaction Issue >
Production Issue -> Get Items - Show a message box "1 row(s) found!"
3.3 (same as above) 1. Input value : ○
- The result is as sheet [Expected Data-02] No.1.
+ [Operation] = "B LINE (SINGLE SAVO)"
2. Click [Search] button or press [Enter] key

UTP-02 57/66 IVS Project


Click Manage Stock > Transaction
Management > Transaction Issue >
Production Issue -> Get Items - Show a message box "1 row(s) found!"
3.4 (same as above) 1. Input value : ○
- The result is as sheet [Expected Data-02] No.1.
+ [BOM] = "BOM_CKVN3FCT"
2. Click [Search] button or press [Enter] key
Click Manage Stock > Transaction
Management > Transaction Issue >
Production Issue -> Get Items - Show a message box "1 row(s) found!"
3.5 (same as above) 1. Input value : ○
- The result is as sheet [Expected Data-02] No.1.
+ [Instruction No] = "PI230601"
+ [Operation] = "B LINE (SINGLE SAVO)"
2. Click
Click [Search]
Manage button
Stock or press [Enter] key
> Transaction
Management > Transaction Issue >
Production Issue -> Get Items - Show a message box "1 row(s) found!"
3.6 (same as above) 1. Input value : ○
- The result is as sheet [Expected Data-02] No.1.
+ [Instruction No] = "PI230601"
+ [BOM] = "BOM_CKVN3FCT"
2. Click
Click [Search]
Manage button
Stock or press [Enter] key
> Transaction
Management > Transaction Issue >
Production Issue -> Get Items - Show a message box "1 row(s) found!"
3.7 (same as above) 1. Input value : ○
- The result is as sheet [Expected Data-02] No.1.
+ [Instruction No] = "PI230601"
+ [Operation] = "B LINE (SINGLE SAVO)"
4 Push + [BOM] = "BOM_CKVN3FCT"
- Click Manage Stock > Transaction
1. Prepare a user account with full right Management > Transaction Issue >
on [Production Issue] screen Get Items Production Issue -> Get Items
4.1 - Click [Push] button - Show error message: "No row is selected" ○
2. Prepare data as sheet [DataTest-
Prerequisite-02]

- Click Manage Stock > Transaction


Management > Transaction Issue >
Production Issue -> Get Items
4.2 (same as above) - Click button [Search] - Data is pushed to detail screen ○
- Chose 1 or n row
- Input [BOM Quantity] = 10
-- Click
Click Manage
[Push] button
Stock > Transaction
Management > Transaction Issue >
Production Issue -> Get Items - Show popup messsage: "Line 1: [Quantity] must be less
4.3 (same as above) - Click button [Search] than or equal [4042.3]! ○
- Chose 1 or n row "
- Input [BOM Quantity] = 10
5 Close - Input [Issue Quantity] = 5000
- Click Manage Stock > Transaction
1. Prepare a user account with full right Management > Transaction Issue >
on [Production Issue] screen Get Items Production Issue -> Get Items
5.1 - Click [Close] button ○
2. Prepare data as sheet [DataTest- - The [Production Issue] screen Get Items is closed
Prerequisite-02]

UTP-02 58/66 IVS Project


Result 0/14
Result 0/14
Result 0/14

Note

UTP-02 59/66 IVS Project


UTP-02 60/66 IVS Project
1 Get Item
Summary
Instruction No Operation BOM Instruction No
PI230601 B LINE (SINGLE SAVO) BOM_CKVN3FPI230601
Grid View
Operation BOM Code Item Code Item Name
B LINE (SINGLE SAVO) BOM_CKVN3FCT CKVN1FCT FC TEST SUN SCREEN
BOM Quantity BOM Unit Issue Quantity Issue Unit
0.53 Pcs 4042 Pcs
1 Get Item
Summary
Instruction No Operation BOM Instruction No
PI230601 B LINE (SINGLE SA BOM_CKVN3FPI230601
Grid View
Operation BOM Code Item Code Item Name
B LINE (SINGLE SAVO) BOM_CKVN3FCT CKVN1FCT FC TEST SUN SC
BOM Quantity BOM Unit Issue Quantity Issue Unit
0.53 Pcs 4042 Pcs

You might also like