Log in / create account
Openbravo.com
Issues
Forge
University
View source | Discuss this page | Page history | Printable version   

ERP 2.50:Acceptance Testing

Languages: 

English  |  日本語 | Translate this article...


This document contains the list of tasks performed by Openbravo every time that a release is packaged from the SVN tree.

Contents

General functional use case testing

General issues

From now we are going to have a sample data in order to make easier the verification of the test cases. This sample data will be built as we are going through the acceptance test. See the diagram below

AcceptanceTest.PNG

The acceptance test is divided in three parts:

Test cases

The structure for the test cases is:


Application Dictionary

1.Create tables

2.Create functions

3.Create references

4.Add tables to dictionary

5.Create window

    [java] 507  [main] ERROR org.openbravo.data.Sqlc - SQL error in query: 
    [java]         SELECT C_Roomattend.AD_Client_ID, 
    [java] (CASE WHEN C_Roomattend.AD_Client_ID IS NULL THEN ' ' ELSE  (COALESCE(TO_CHAR(table1.Name),' ') ) END) AS AD_Client_IDR, 
    [java] C_Roomattend.AD_Org_ID, 
    [java] (CASE WHEN C_Roomattend.AD_Org_ID IS NULL THEN ' ' ELSE  (COALESCE(TO_CHAR(table2.Name),' ') ) END) AS AD_Org_IDR, 
    [java] C_Roomattend.Typeattender, 
    [java] (CASE WHEN C_Roomattend.Typeattender IS NULL THEN ' ' ELSE  ( COALESCE(TO_CHAR(list1.name), ' ') ) END) AS TypeattenderR, 
    [java] C_Roomattend.Department, 
    [java] (CASE WHEN C_Roomattend.Department IS NULL THEN ' ' ELSE  ( COALESCE(TO_CHAR(list2.name), ' ') ) END) AS DepartmentR, 
    [java] C_Roomattend.C_Bpartner_ID, 
    [java] (CASE WHEN C_Roomattend.C_Bpartner_ID IS NULL THEN ' ' ELSE  (COALESCE(TO_CHAR(table3.Name),' ') ) END) AS C_Bpartner_IDR, 
    [java] C_Roomattend.Meetingrole, 
    [java] C_Roomattend.C_Roomschedule_ID, 
    [java] (CASE WHEN C_Roomattend.C_Roomschedule_ID IS NULL THEN ' ' ELSE  () END) AS C_Roomschedule_IDR,

the problem is that you didn't mark one column as Identifier for C_Roomattend table.

Administration master data 

1.Initial client setup

2.Delete client

Note: Prior to version 2.40 systems using postgres will need to be rebooted before continuing 

3.Import/Export Translation

4.Create user

5.Create role

6.Create Import Loader Format
Name Column Data type Decimal point Constant value
Organization ad_org_id Constant . 0
Search key value String .
Name name String .
Uom_id C_Uom_Id Number .
Description description String .
Product type ProductType Constant . I
Product category value ProductCategory_value String . 
7.Import file loader

8. Create Product category

9. Create Business partner category



10. Import products

11. Import Business partners

12. Import Taxes

13. Create Attribute set

14. Create Pricelist

Note: If you don't want to create all the pricelist using the application please use this Oracle script or this PostgreSQL script 

15. Create Payment term

Note: If you don't want to create all the payment terms using the application please use this Oracle script or this PostgreSQL 

16. Create Invoice Schedule

17. Edit products

Note: If you don't want to edit all the products using the application please use this Oracle script or this PostgreSQL script 

18. Edit Business partner

Note: If you don't want to edit all the business partner using the application please use this Oracle script or this PostgreSQL script 

19. Create Physical inventory

20. Import account

If you cannot execute correctly the last statement, means the import accounts has failed

Please see Chart of accounts for more information

Administration accounting data

1. Create fiscal calendar

2. Editing Document sequence

3. Create G/L Item

4. Update Business partner to add a business partner tax category

Administration financial data

1. Create remittance type

2. Create Bank

Procurement management

1. Create a purchase order

2. Create Goods receipt

3. Create Purchase Invoice

4. Accounting Purchase Invoice

5. Pay the Purchase Invoice

Sales Management

1. Create Standard Sales Order

2. Create goods shipment

3. Create Sales invoice

4. Accounting Sales Invoice

5. Create Settlement

6. Create Remittance

7. Create Bank Statement

8. Generate invoices process

Production management

1. Edit a product BOM

2. Create BOM production

3. Create Cost centre

Create a cost centre to use for calculate costs based on the work effort 


4. Create a Process/Activity

5. Create a process plan

6. Create Work requirement

The field Quantity on Header tab indicates the number of times that we want to process the process plan 

7. Create Work effort

Project and Service management

TEST CASES FOR THIS MODULE ARE WORK IN PROGRESS

Preconditions: Create the products SERVICE A, SERVICE B with the following attributes:

Prices: 

1. Create a Project Type

2. Create a Multiphase Project

3 a. Create a simple Service Project

3 b. Create a complex Service Project

4. Create some Expense Sheets

5. Track and process Invoiceable Expenses

6. Track and process Employee Expenses

Accounting processes

1. Reset accounting process

2. Generate accounting process

3. Create a G/L journal

If "Total Debit Amount" is different than "Total Credit Amount" OB should not allow you to complete


Assets: Create Amortization Plan

1. Amortize Asset by percentage in complete years

2. Amortize Asset by percentage in non complete years

3. Amortize Asset by time in complete years

4. Amortize Asset by time in non complete years

5. Amortize Asset by time in complete months

6. Amortize Asset by time in non complete months



7. Amortize Asset with Previously Depreciated Amount

Retrieved from "http://wiki.openbravo.com/wiki/ERP_2.50:Acceptance_Testing"

This page has been accessed 76,590 times. This page was last modified on 3 April 2012, at 10:59. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.