QA testing data set

Contents 1 Introduction 1.1 Client 1.2 Organization 1.3 Roles and users 1.4 Products and categories 1.5 Price list 1.6 Business partner and categories 1.7 Price adjustments 1.8 Volume discounts 1.9 Taxes and categories

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

Category: QA Set Data