View source | Discuss this page | Page history | Printable version   

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:

In the following sections it is explained the configuration for this set of data.

Client

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:


QAdataTreeOrg.PNG

Roles and users

Products and categories

At least we have the same products that the smoke test creates plus new ones for Spain and USA organizations:

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:

Volume discounts

We have two volume discounts differentiate by organization and currency. One for Spain and one for USA

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

Retrieved from "http://wiki.openbravo.com/wiki/QA_testing_data_set"

This page has been accessed 5,803 times. This page was last modified on 16 November 2012, at 11:45. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.