QA testing data set
Contents |
Introduction
This data set is just for testing purposes. You can find it in PI. Several goals are intended to reach with this data set:
- Have a complete set up configuration that will allow to test any scenario. This will make not to waste time setting up a specific scenario
- The main configuration is based on the current smoke test and for being more concrete in master data test suite. This will allow:
- To run any test suite from the smoke test without running the master data test suite
- To run any test suite even if the master data has previously executed meaning that if for example Sales test suite has a false positive instead of running all the smoke test from scratch you just can run the Sales test suite again pointing to this client. This will save a lot of time
- Help writing dbunit test cases
- Help writing selenium test cases
In the following sections it is explained the configuration for this set of data.
Client
- Name: QA Testing
- User client: QAAdmin
- Password: QAAdmin
Organization
This set of data has multi-organization with different COA (chart of accounts) that will allow us to test the security model and accounting entries for different COA.The organization tree structure is:
- Main
- Organization type: Organization. This means that transactions are not allowed to be done in this organization
- It has an Spanish chart of accounts related to a general ledger configuration. This way the USA organization will inherit this COA and all the products, business partner created for USA organization will have Spanish accounts related in the accounting tab
- Location/Address: Country Spain
- Spain
- Organization type: Legal with accounting. This means that transactions are allowed
- It has not associated a chart of accounts nor a general ledger configuration but inherits it from Main organization, that is the Spanish char of accounts (Currency EUR). So whenever there is a transactions in this organization (i.e Sales invoice) a new accounting entry will be generated using the Spanish accounts
- Location/Address: Country Spain. It's important to remark here the country because of the taxes calculation.
- USA
- Organization type: Legal with accounting. This means that transactions are allowed
- It has associated one US Chart of accounts and general ledger configuration and also inherits the general ledger configuration and chart of accounts from Main. So whenever there is a transactions in this organization (i.e Sales invoice) two accounting entries will be generated. One related to the Spanish general ledger configuration and CoA and the other to the USA general ledger configuration and CoA.
- Location/Address: Country EEUU. It's important to remark here the country because of the taxes calculation.
Roles and users
- Roles
- QA Testing Admin: Has access to all windows and to all organizations. The users related to this role are MainUser, Openbravo, QAAdmin
- Spain Admin: Has access to all windows and only to Spain organization and (*). The users related to this role are QAAdmin, SpainUser
- USA Admin: Has access to all windows and only to USA organization and (*). The users related to this role are QAAdmin, USAUser
- Sales Admin: Has access to all sales management module and for two organizations: Spain and USA. The users related to this role are QAAdmin, userC
- Users
- MainUser/MainUser: The related role is QA Testing Admin
- Openbravo/openbravo: Related roles are QA Testing Admin
- QAAdmin/QAAdmin: The related roles are QA Testing Admin, Spain Admin, USA Admin, Sales Admin
- SpainUser/SpainUser: The related role is Spain Admin
- USAUserUSAUser: The related role is USA Admin
- userC/userC: The related role is Sales Admin
Products and categories
At least we have the same products that the smoke test creates plus new ones for Spain and USA organizations:
- (*) organization:
- Raw material A,B,C that belong to Raw materials category
- BOM A,B,C that belong to Bill of Materials category
- Final good A,B,C that belong to Finished Goods category
- Distribution good A,B,C that belong to Distribution Goods category
- Service A,B that belong to Services category
- Discount 10%, 20% that belong to Discounts category
- All of these products has the two COA (Spain and USA)
- Spain organization
- Spain-Distribution good A,B,C that belong to Distribution Goods category
- These product has assigned the Spanish COA
- USA organization
- USA-Distribution good A,B,C that belong to Distribution Goods category
- These product has assigned the Spanish COA and USA COA
Price list
Because of having a data set with multi-org and multi-currency we have different price lists in different currencies:
Name | Organization | Currency | Products | Valid From |
Purchase | (*) | EUR | Raw material A,B,C and service A,B | 01-01-2010 |
Sales | (*) | EUR | Distribution good A,B,C and Final good A,B,C | 01-01-2010 |
Customer A | (*) | EUR | Final good A,B,C and Service A,B,C | 01-01-2009 |
Customer B | (*) | EUR | Final good A,B,C | 01-01-2009 |
Sales Spain | Spain | EUR | Spain-Distribution good A,B,C | 01-01-2009 |
Sales USA | USA | USD | USA-Distribution good A,B,C | 01-01-2009 |
Purchase Spain | Spain | EUR | Spain-Distribution good A,B,C | 01-01-2009 |
Purchase USA | USA | USD | USA-Distribution good A,B,C | 01-01-2009 |
Business partner and categories
In order to test security model, taxes calculation, etc we have different business partners in different organizations in different locations. Here you have all of them grouped by Organization:
Name | Organization | Country | Category | Price list | Form of payment | Payment term | Is Customer | Is vendor | Has discounts | Has Volume Disc | Has Price Adjust. |
Customer A | (*) | Spain | Customer | Customer A | Money Order | 30 days, 5 | Yes | No | No | No | No |
Customer B | (*) | Spain | Customer | Customer B | Money Order | 30 days, 5 | Yes | No | No | No | No |
Vendor A | (*) | Spain | Vendor | Purchase | Wire Transfer | 90 days | No | Yes | No | No | No |
Vendor B | (*) | Spain | Vendor | Purchase | Wire Transfer | 90 days | No | Yes | No | No | No |
Customer Barcelona | Spain | Spain | Customer | Sales Spain | Bank Deposit | 90 days | Yes | No | No | No | Yes |
Customer Madrid | Spain | Spain | Customer | Sales Spain | Bank Deposit | 90 days | Yes | No | No | No | No |
Customer Boston | USA | United States | Customer | Sales USA | Bank Deposit | 90 days | Yes | No | No | No | Yes |
Customer New York | USA | United States | Customer | Sales USA | Bank Deposit | 90 days | Yes | No | No | No | Yes |
Customer France | (*) | France | Customer | Sales | Bank Deposit | 90 days | Yes | No | No | No | Yes |
Customer Germany | (*) | Germany | Customer | Sales | Bank Deposit | 90 days | Yes | No | No | No | No |
Vendor Barcelona | Spain | Spain | Vendor | Purchase Spain | Bank Deposit | 90 days | No | Yes | No | No | No |
Vendor Madrid | Spain | Spain | Vendor | Purchase Spain | Bank Deposit | 90 days | No | Yes | No | No | No |
Vendor New York | USA | United States | Vendor | Purchase USA | Bank Deposit | 90 days | No | Yes | No | No | No |
Vendor Boston | USA | United States | Vendor | Purchase USA | Bank Deposit | 90 days | No | Yes | No | No | No |
Vendor France | (*) | France | Vendor | Purchase | Bank Deposit | 90 days | No | Yes | No | No | No |
Vendor Germany | (*) | Germany | Vendor | Purchase | Bank Deposit | 90 days | No | Yes | No | No | No |
Vendor with discounts 10%,20% | (*) | USA | Vendor | Purchase | Bank Deposit | 90 days | No | Yes | Yes | No | No |
Vendor with discount 10% | (*) | Spain | Vendor | Purchase | Money Order | 90 days | No | Yes | Yes | No | No |
Vendor Spain with Volume Discount | Spain | Spain | Vendor | Purchase Spain | Bank Remittance | 30 days,5 | No | Yes | No | Yes | No |
Vendor USA with Volume Discount | USA | United States | Vendor | Purchase USA | Bank Deposit | 90 days | No | Yes | No | Yes | No |
Customer with discounts 10%,20% | (*) | United States | Customer | Sales | Money Order | 30 days, 5 | Yes | No | Yes | No | No |
Customer with discounts 10% | (*) | Spain | Customer | Sales | Money Order | 90 days | Yes | No | Yes | No | No |
Customer Spain with volume discount | Spain | Spain | Customer | Sales | Bank Remittance | 90 days | Yes | No | No | Yes | No |
Customer USAwith volume discount | Sapin | Spain | Customer | Sales | Wire Transfer | 30 days, 5 | Yes | No | No | Yes | No |
Price adjustments
We have defined three price adjustment depending on discount amount, discount % and Fixed price:
- Price adjustment (Discount amount):
- Discount amount: 45
- Include Price Lists: All selected
- Purchase
- Sales USA
- Included Business partner: All selected
- Customer New York
- Included Products: All selected
- Distribution good A, Final good A, Raw material A
- Price adjustment (Discount %)
- Discount %: 8
- Included Product categories: All selected
- Distribution goods
- Included Business Partners: Customer Boston, Customer Barcelona
- Price adjustment (Fixed Price)
- Fixed price: 12.35
- Included Business Partners: All selected
- Customer France
- Included Products:All selected
- Distribution good C
Volume discounts
We have two volume discounts differentiate by organization and currency. One for Spain and one for USA
- Volume discounts Spain (EUR)
- Currency: EUR
- Organization: Spain
- Included products: All selected
- Spain- Distribution good A, Spain- Distribution good B
- Business partner:
- Vendor Spain with Volume Discount, Customer Spain with volume discount
- Volume discount USA (US dollars)
- Currency: USD
- Organization: USA
- Included products categories: All selected
- Distribution goods
- Business partner:
- Vendor USA with volume Discount, Customer USA with volume discount
Taxes and categories
We have defined different taxes for different organizations and countries and we also have business partners in different countries such us Germany, France, Spain and United States. With this setup you can test if the taxes are applied correctly or not depending in all this variables
Name | Organization | Tax Category | Parent tax rate | Rate | Country | Destination Country |
VAT(3)+CHARGE(0.5) | Spain | VAT 3% | 3.5 | Spain | Spain | |
VAT(3) | Spain | VAT 3% | VAT(3)+CHARGE(0.5) | 3 | Spain | Spain |
CHARGE(0.5) | Spain | VAT 3% | VAT(3)+CHARGE(0.5) | 0.5 | Spain | Spain |
VAT 3% | Spain | VAT 3% | 3 | Spain | Spain | |
VAT 10% | Spain | VAT 10% | 10 | Spain | Spain | |
VAT 3% USA | USA | VAT 3% | 3 | United States | United States | |
VAT 10% USA | USA | VAT 10% | 10 | United States | United States | |
Exempt 10% | Main | VAT 10% | 0 | |||
Exempt 3% | Main | VAT 3% | 0 |