ERP 2.50:QA test plan 2.50/Test cases
Test cases
1. Create import loader format
- Short description: Create the format to be able to import the data
- Steps:
- Login with permissions to Master Data Management || Import Data || Import Loader Format
- Click new and fill:
- Name: Orders
- Table: I_Order
- Format: Comma separated
- Move to field format tab and create new records following this:
Name | Column | Data type | Decimal point | Date format | Constant value |
Organization | ad_org_id | Constant | An organization <> than 0. The value would be the Id | ||
Warehouse | m_warehouse_id | Constant | The Id of the warehouse | ||
Document No | Documentno | String | |||
Document type | DocTypeName | String | |||
Business partner | bpartnervalue | String | |||
Product | Productvalue | String | |||
Quantity ordered | Qtyordered | Number | . |
| |
Price actual | priceactual | Number | . | ||
Currency ID | c_currency_id | String |
-
- Click new and fill:
- Name: Orders(full)
- Table: I_Order
- Format: Comma separated
- Move to field format tab and create new records following this:
- Click new and fill:
Name | Column | Data type | Decimal point | Date format | Constant value |
Organization | ad_org_id | Constant | An organization <> than 0. The value would be the Id | ||
Warehouse | m_warehouse_id | Constant | The Id of the warehouse | ||
Document No | Documentno | String | |||
Date Ordered | Dateordered | Date | DD-MM-YYYY | ||
Document type | DocTypeName | String | |||
Business partner | bpartnervalue | String | |||
Product | Productvalue | String | |||
Quantity ordered | Qtyordered | Number | . |
| |
Price actual | priceactual | Number | . | ||
Currency ID | c_currency_id | String |
-
- Click new and fill:
- Name: Orders(short)
- Table: I_Order
- Format: Comma separated
- Move to field format tab and create new records following this:
- Click new and fill:
Name | Column | Data type | Decimal point | Date format | Constant value |
Organization | ad_org_id | Constant | An organization <> than 0. The value would be the Id | ||
Warehouse | m_warehouse_id | Constant | The Id of the warehouse | ||
Date Ordered | Dateordered | Date | DD-MM-YYYY | ||
Document type | DocTypeName | String | |||
Business partner | bpartnervalue | String | |||
Product | Productvalue | String | |||
Quantity ordered | Qtyordered | Number | . |
| |
Price actual | priceactual | Number | . |
- Issues to verify: Verify that the format is in the combo box "Format file" which is in Master Data Management || Import Data || Import File Loader
2.Import file loader
- Short description: Test the import data process for Orders.
- Steps:
- Login with permissions to Master Data Management || Import Data || Import File Loader
- Select the file I_Orders.txt and the format for the orders
- Click OK. This is only to verify that the file is well format
- Select again the file and the format. Click Process
- Issues to verify:
- Go to Master Data Management->Import Data
- Verify that the orders are in the Import Order window
- Additional data: To import use the .txt that are in Orders
For "Orders" Import Format I_Orders.txt should be in the following format:
AA875875875RRTT,Standard Order,bellphone,shirts,400,13.4,102 BB7747FFQQ,POS Order,Millman,beer,500,10.6,100 |
For "Orders(full)" Import Format I_Orders.txt should be in the following format:
ORDFULLTEST1,19-02-2009,Standard Order,bellphone,shirts,400,13.4,102 ORDFULLTEST2,19-02-2009,Standard Order,bellphone,shirts,400,13.4,102 ORDFULLTEST2,19-02-2009,Standard Order,bellphone,paint,400,13.4,100 ORDFULLTEST3,19-02-2009,POS Order,Millman,beer,500,10.6,102 ORDFULLTEST3,19-02-2009,POS Order,Millman,beer,500,10.6,102 ORDFULLTEST4,19-02-2009,POS Order,Millman,foodkit,500,10.6,100 ORDFULLTEST4,19-02-2009,POS Order,Millman,beer,500,10.6,100 ORDFULLTEST5,19-02-2009,Warehouse Order,Millman,beer,500,10.6,102 ORDFULLTEST5,19-02-2009,Warehouse Order,Millman,foodkit,500,10.6,102 |
For "Orders(short)" Import Format I_Orders.txt should be in the following format:
19-02-2009,Standard Order,bellphone,shirts,400,13.4 20-02-2009,Standard Order,bellphone,shirts,400,13.4 20-02-2009,Standard Order,bellphone,paint,400,13.4 20-02-2009,POS Order,Millman,beer,500,10.6 20-02-2009,POS Order,Millman,beer,500,10.6 19-02-2009,POS Order,Millman,foodkit,500,10.6 19-02-2009,POS Order,Millman,beer,500,10.6 20-02-2009,POS Order,Millman,beer,500,10.6 20-02-2009,POS Order,Millman,foodkit,500,10.6 |
3. Import orders
- Short description:Import from the temporary orders table to the final one
- Steps:
- Login with permissions to Master Data Management || Import Data || Import Orders
- Entry in edition mode and click on button Import Order and then OK
- In the pop-up window verify that the checkbox "Complete and process orders automatically" is checked
- Issues to verify:Take a look in the field Import Error Message to see if there are any errors and Go to Sales management || Transactions || Sales order and verify that all the orders are there