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:

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:

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,beer,100,10.5,102 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,beer,100,10.5,100 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,beer,100,10.5 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

Category: QA Test plan 2.50 ERP