Toolbox

Main Page

Upload file

What links here

Recent changes

Help

Search

Participate

Projects:IDL Extension Invoices/QA Test Cases

1 QA TestCases

QA TestCases

All these test cases are done with sample data "Entity: SmallBazaar" Module "Taxes: configuration for Spain (Impuestos para España) 1.2.24" are necessary for taxes

Number	Description	Sale	Purchase
1	Everything OK	OK	OK
2	Not Null Values (Leave null values in not null fields)	OK	OK
3	Data Corrupted (Value don't match, name don't match... )	OK	OK
4	Use Default Values from Entities (User Contact, PriceList, Payment Terms, etc....)	OK	OK
5	Use Default Values from IDL	OK	OK
6	Document No / Order Reference Logic	OK	OK
7	PriceListVersion / Price Unit Logic	OK	OK
8	Type of lines (Product, Invoice, Nothing)	OK	OK
9	Taxes (null taxes)	OK	OK
10	Process / Not Process lines	OK	OK

Everything OK

File for Sales Invoice OK:

"Is Sales Order Transaction","Organization","Document No.","Order Reference","Description Header","Transaction Document","Invoice Date","Accounting Date","Tax Date","Business Partner","User/Contact","Price List","Sales Representative / Company Agent","Print Discount","Form of Payment","Payments Terms","Project","Financial Invoice Line","Account","Product","Description Lines","Invoiced Quantity","PriceListVersion","Net Unit Price","Net List Price","Tax","Process","Withholding","Exclude for Withholding"
"Y","A","1_0001_A","123","HeadDesc1A","AR Invoice","2011-02-22","2011-02-22","2011-02-24","mafalda","Mafalda","Mafalda sales","Our Sales Agent","N","Bank Deposit","Immediate","mafalda","FALSE",,"donuts","DesLines","1",,"231","53","VAT 4%","FALSE",,
"Y","A","1_0002_A","23","HeadDesc2A","AR Invoice","2011-02-22","2011-02-22","2011-02-24","mcgiver","John McGiver","General Sales","Our Sales Agent","N","Cash","1m","riley","FALSE",,"boots","DesLines","2",,"56",,"Entregas IVA 16%","FALSE",,
"Y","A","1_0002_A","23","HeadDesc2A","AR Invoice","2011-02-22","2011-02-22","2011-02-24","mcgiver","John McGiver","General Sales","Our Sales Agent","N","Cash","1m","riley","N",,"boots","DesLines","3",,"7",,"Entregas IVA 16%","FALSE",,
"Y","A","1_0002_A","23","HeadDesc2A","AR Invoice","2011-02-22","2011-02-22","2011-02-24","mcgiver","John McGiver","General Sales","Our Sales Agent","N","Cash","1m","riley","N",,"boots","DesLines","4",,"3",,"VAT 4%","FALSE",,
"Y","A","1_0003_A","674567","DD","AR Credit Memo","2011-02-22","2011-02-22","2011-02-24","Redbunny","Bugs bunny","General Sales","Our Sales Agent","N","Check","Immediate","mafalda","FALSE",,"donuts","DesLines","7",,"4",,"Entregas IVA 16%","FALSE",,
"Y","A","1_0003_A","674567","DD","AR Credit Memo","2011-02-22","2011-02-22","2011-02-24","Redbunny","Bugs bunny","General Sales","Our Sales Agent","N","Check","Immediate","mafalda","FALSE",,"donuts","DesLines","9",,"231",,"Entregas IVA 16%","FALSE",,
"Y","A","1_0004_A","42","DDD","AR Invoice","2011-02-20","2011-02-22","2011-02-20","mafalda","Mafalda","Mafalda sales","Our Sales Agent","N","Bank Deposit","Immediate","consulting","N",,"donuts","DesLines","342",,"1",,"VAT 4%","FALSE",,
"Y","A","1_0005_A","56345","asdas","AR Invoice","2011-02-22","2011-02-22","2011-02-24","sailor","Olivia Oyl","General Sales","Our Sales Agent","N","Cash","Immediate","consulting","FALSE",,"donuts","DesLines","453",,"11",,"Entregas IVA 16%","FALSE",,
"Y","A","1_0005_A","56345","asdas","AR Invoice","2011-02-22","2011-02-20","2011-02-24","sailor","Olivia Oyl","General Sales","Our Sales Agent","N","Cash","Immediate","consulting","N",,"donuts","DesLines","758",,"3454","89","VAT 4%","FALSE",,
"Y","A","1_0005_A","56345","asdas","AR Invoice","2011-02-22","2011-02-22","2011-02-24","sailor","Olivia Oyl","General Sales","Our Sales Agent","N","Cash","Immediate","consulting","FALSE",,"donuts","DesLines","80789",,"3454","4","Entregas IVA 16%","FALSE",,

File for Purchase Invoice OK:

"Is Sales Order Transaction","Organization","Document No.","Order Reference","Description Header","Transaction Document","Invoice Date","Accounting Date","Tax Date","Business Partner","User/Contact","Price List","Sales Representative / Company Agent","Print Discount","Form of Payment","Payments Terms","Project","Financial Invoice Line","Account","Product","Description Lines","Invoiced Quantity","PriceListVersion","Net Unit Price","Net List Price","Tax","Process","Withholding","Exclude for Withholding"
"N","A","1_0001_A","123","HeadDesc1A","AP Invoice","2011-02-22","2011-02-22","2011-02-24","obelix","Esautomátix","Purchase","BBSalesUser","N","Bank Deposit","15d","millman","FALSE",,"marble","DesLines","1",,"231","53","VAT 4%","FALSE","PPrueba","FALSE"
"N","A","1_0002_A","23","HeadDesc2A","AP Invoice","2011-02-22","2011-02-22","2011-02-24","turtlelogistics",,"Purchase","BBSalesUser","N","Cash","1m","consulting","FALSE",,"flour","DesLines","2",,"56",,"VAT 16%","FALSE",,
"N","A","1_0002_A","23","HeadDesc2A","AP Invoice","2011-02-22","2011-02-22","2011-02-24","turtlelogistics",,"Purchase","BBSalesUser","N","Cash","1m","consulting","N",,"flour","DesLines","3",,"7",,"VAT 16%","FALSE",,
"N","A","1_0002_A","23","HeadDesc2A","AP Invoice","2011-02-22","2011-02-22","2011-02-24","turtlelogistics",,"Purchase","BBSalesUser","N","Cash","1m","consulting","N",,"flour","DesLines","4",,"3",,"VAT 4%","FALSE",,
"N","A","1_0003_A","674567","DD","AP CreditMemo","2011-02-22","2011-02-22","2011-02-24","john",,"Purchase","BBSalesUser","N","Check","15d","millman","FALSE",,"marble","DesLines","7",,"4",,"VAT 16%","FALSE","PPrueba","TRUE"
"N","A","1_0003_A","674567","DD","AP CreditMemo","2011-02-22","2011-02-22","2011-02-24","john",,"Purchase","BBSalesUser","N","Check","15d","millman","FALSE",,"marble","DesLines","9",,"231",,"VAT 16%","FALSE","PPrueba","TRUE"
"N","A","1_0004_A","42","DDD","AP Invoice","2011-02-20","2011-02-22","2011-02-20","obelix","Esautomátix","Purchase","BBSalesUser","N","Bank Deposit","Immediate","consulting","N",,"marble","DesLines","342",,"1",,"VAT 4%","FALSE",,
"N","A","1_0005_A","56345","asdas","AP Invoice","2011-02-22","2011-02-22","2011-02-24","bellphone","Christine Summers","Purchase","BBSalesUser","N","Cash","Immediate","consulting","FALSE",,"flour","DesLines","453",,"11",,"VAT 16%","FALSE",,
"N","A","1_0005_A","56345","asdas","AP Invoice","2011-02-22","2011-02-20","2011-02-24","bellphone","Christine Summers","Purchase","BBSalesUser","N","Cash","Immediate","consulting","N",,"marble","DesLines","758",,"3454","89","VAT 4%","FALSE",,
"N","A","1_0005_A","56345","asdas","AP Invoice","2011-02-22","2011-02-22","2011-02-24","bellphone","Christine Summers","Purchase","BBSalesUser","N","Cash","Immediate","consulting","FALSE",,"flour","DesLines","80789",,"3454","4","VAT 16%","FALSE",,

Not Null Values (Leave null values in not null fields)

Sales

Cannot be NULL: IsSalesOrderTransaction OK

Cannot be NULL: Organization OK

Neither Document nor Order Reference found for this line. OK

Cannot be NULL: TransactionDocument OK

Cannot be NULL: InvoiceDate OK

Cannot be NULL: BusinessPartner OK

Cannot be NULL: InvoicedQuantity OK

Price not found for this product: boots OK

Cannot be NULL: Process OK

Purchases

Cannot be NULL: IsSalesOrderTransaction OK

Cannot be NULL: Organization OK

Neither Document nor Order Reference found for this line. OK

Cannot be NULL: TransactionDocument OK

Cannot be NULL: InvoiceDate OK

Cannot be NULL: BusinessPartner OK

Cannot be NULL: InvoicedQuantity OK

Price not found for this product: boots OK

Cannot be NULL: Process OK

Data Corrupted (Value don't match, name don't match... )

Sales

Organization not found: asdf OK

Document Type not found: jhklkln OK

Dates must match with the pattern (yyyy-MM-dd): 32342314 OK

Business Partner not found: pokikj OK

User / Contact not found: dadsd OK

Price List not found jiojiojio OK

Sales Representative or Company Agent not found :pojkjnod OK

Form of Payment not found : Checkaweqwer OK

Payment Terms not found: 1masfafg OK

Project not found: ddd33 OK

Boolean values must be {TRUE, True, true, FALSE, False, false}: FALSETE OK

Account: Tested in "Type of lines (Product, Invoice, Nothing)" OK

Product not found : daffa OK

PriceListVersion: Tested in "PriceListVersion / Price Unit Logic" OK

Tax not found: 53745g OK

Withholding: Tested in "Purchase Invoice Section" OK

Purchases

Organization not found: asdf OK

Document Type not found: jhklkln OK

Dates must match with the pattern (yyyy-MM-dd): 32342314 OK

Business Partner not found: pokikj OK

User / Contact not found: dadsd OK

Price List not found jiojiojio OK

Sales Representative or Company Agent not found :pojkjnod OK

Form of Payment not found : Checkaweqwer OK

Payment Terms not found: 1masfafg OK

Project not found: ddd33 OK

Boolean values must be {TRUE, True, true, FALSE, False, false}: FALSETE OK

Account: Tested in "Type of lines (Product, Invoice, Nothing)" OK

Product not found : daffa OK

PriceListVersion: Tested in "PriceListVersion / Price Unit Logic" OK

Tax not found: 53745g OK

Withholding not found: asd OK

Use Default Values from Entities (User Contact, PriceList, Payment Terms, etc....)

File for Sales Invoice OK:

"Is Sales Order Transaction","Organization","Document No.","Order Reference","Description Header","Transaction Document","Invoice Date","Accounting Date","Tax Date","Business Partner","User/Contact","Price List","Sales Representative / Company Agent","Print Discount","Form of Payment","Payments Terms","Project","Financial Invoice Line","Account","Product","Description Lines","Invoiced Quantity","PriceListVersion","Net Unit Price","Net List Price","Tax","Process","Withholding","Exclude for Withholding"
"Y","A",,"123","HeadDesc1A","AR Invoice","2011-02-22",,,"mafalda",,,,,,,,"FALSE",,"donuts","DesLines","1",,"25","53","VAT 4%","FALSE",,
"Y","A",,"23","HeadDesc2A","AR Invoice","2011-02-22",,,"mcgiver",,,,,,,,"FALSE",,"boots","DesLines","7",,"56",,"Entregas IVA 16%","FALSE",,
"Y","A",,"23","HeadDesc2A","AR Invoice","2011-02-22",,,"mcgiver",,,,,,,,"N",,"boots","DesLines","3",,"7",,"Entregas IVA 16%","FALSE",,
"Y","A",,"23","HeadDesc2A","AR Invoice","2011-02-22",,,"mcgiver",,,,,,,,"N",,"boots","DesLines","4",,"3",,"VAT 4%","FALSE",,
"Y","A",,"674567","DD","AR Credit Memo","2011-02-22",,,"Redbunny",,,,,,,,"FALSE",,"donuts","DesLines","7",,"4",,"Entregas IVA 16%","FALSE",,
"Y","A",,"674567","DD","AR Credit Memo","2011-02-22",,,"Redbunny",,,,,,,,"FALSE",,"donuts","DesLines","9",,"231",,"Entregas IVA 16%","FALSE",,
"Y","A",,"42d","DDD","AR Invoice","2011-02-20",,,"mafalda",,,,,,,,"N",,"donuts","DesLines","9",,"1",,"VAT 4%","FALSE",,
"Y","A",,"56345","asdas","AR Invoice","2011-02-22",,,"sailor",,,,,,,,"FALSE",,"donuts","DesLines","453",,"12",,"Entregas IVA 16%","FALSE",,
"Y","A",,"56345","asdas","AR Invoice","2011-02-22",,,"sailor",,,,,,,,"N",,"donuts","DesLines","758",,"3454","89","VAT 4%","FALSE",,
"Y","A",,"56345","asdas","AR Invoice","2011-02-22",,,"sailor",,,,,,,,"FALSE",,"donuts","DesLines","80789",,"3454","4","Entregas IVA 16%","FALSE",,

File for Purchases Invoice OK:

"Is Sales Order Transaction","Organization","Document No.","Order Reference","Description Header","Transaction Document","Invoice Date","Accounting Date","Tax Date","Business Partner","User/Contact","Price List","Sales Representative / Company Agent","Print Discount","Form of Payment","Payments Terms","Project","Financial Invoice Line","Account","Product","Description Lines","Invoiced Quantity","PriceListVersion","Net Unit Price","Net List Price","Tax","Process","Withholding","Exclude for Withholding"
"N","A",,"123","HeadDesc1A","AP Invoice","2011-02-22",,,"obelix",,,,,,,,"FALSE",,"marble","DesLines","1",,"231","53","VAT 4%","FALSE","PPrueba","FALSE"
"N","A",,"23","HeadDesc2A","AP Invoice","2011-02-22",,,"turtlelogistics",,,,,,,,"FALSE",,"flour","DesLines","2",,"56",,"VAT 16%","FALSE",,
"N","A",,"23","HeadDesc2A","AP Invoice","2011-02-22",,,"turtlelogistics",,,,,,,,"N",,"flour","DesLines","3",,"7",,"VAT 16%","FALSE",,
"N","A",,"23","HeadDesc2A","AP Invoice","2011-02-22",,,"turtlelogistics",,,,,,,,"N",,"flour","DesLines","4",,"3",,"VAT 4%","FALSE",,
"N","A",,"674567","DD","AP CreditMemo","2011-02-22",,,"john",,,,,,,,"FALSE",,"marble","DesLines","7",,"4",,"VAT 16%","FALSE","PPrueba","TRUE"
"N","A",,"674567","DD","AP CreditMemo","2011-02-22",,,"john",,,,,,,,"FALSE",,"marble","DesLines","9",,"231",,"VAT 16%","FALSE","PPrueba","TRUE"
"N","A",,"42","DDD","AP Invoice","2011-02-20",,,"obelix",,,,,,,,"N",,"marble","DesLines","342",,"1",,"VAT 4%","FALSE",,
"N","A",,"56345","asdas","AP Invoice","2011-02-22",,,"bellphone",,,,,,,,"FALSE",,"flour","DesLines","453",,"11",,"VAT 16%","FALSE",,
"N","A",,"56345","asdas","AP Invoice","2011-02-22",,,"bellphone",,,,,,,,"N",,"marble","DesLines","758",,"3454","89","VAT 4%","FALSE",,
"N","A",,"56345","asdas","AP Invoice","2011-02-22",,,"bellphone",,,,,,,,"FALSE",,"flour","DesLines","80789",,"3454","4","VAT 16%","FALSE",,

Use Default Values from IDL

File for Sales Invoice OK:

"Is Sales Order Transaction","Organization","Document No.","Order Reference","Description Header","Transaction Document","Invoice Date","Accounting Date","Tax Date","Business Partner","User/Contact","Price List","Sales Representative / Company Agent","Print Discount","Form of Payment","Payments Terms","Project","Financial Invoice Line","Account","Product","Description Lines","Invoiced Quantity","PriceListVersion","Net Unit Price","Net List Price","Tax","Process","Withholding","Exclude for Withholding"
,,"5_0001_A",,,,,,,,,,,,,,,,,,,,,,,,,,
,,"5_0002_A",,,,,,,,,,,,,,,,,,,,,,,,,,
,,"5_0002_A",,,,,,,,,,,,,,,,,,,,,,,,,,
,,"5_0002_A",,,,,,,,,,,,,,,,,,,,,,,,,,
,,"5_0003_A",,,,,,,,,,,,,,,,,,,,,,,,,,
,,"5_0003_A",,,,,,,,,,,,,,,,,,,,,,,,,,
,,"5_0004_A",,,,,,,,,,,,,,,,,,,,,,,,,,
,,"5_0005_A",,,,,,,,,,,,,,,,,,,,,,,,,,
,,"5_0005_A",,,,,,,,,,,,,,,,,,,,,,,,,,
,,"5_0005_A",,,,,,,,,,,,,,,,,,,,,,,,,,

Default Values Tested

BusinessPartner : mafalda

Organization : B

InvoicedQuantity : 10

DescriptionLine : DescriptionDEFAULT

SalesRepresentativeCompanyAgent : Our Sales Agent

AccountingDate : 2011-02-22

DescriptionHeader : DHeader

FinancialInvoiceLine : FALSE

FormOfPayment : Bank Deposit

InvoiceDate : 2011-02-22

IsSalesOrderTransaction : TRUE

NetListPrice : 123

NetUnitPrice : 14235

OrderReference : 1qqr5

PaymentsTerms : 1m

PriceList : General Sales

PrintDiscount : FALSE

Process : FALSE

Product : donuts

Project : consulting

Tax : Entregas IVA 16%

TaxDate : 2011-02-20

TransactionDocument : AR Invoice

UserContact : Mafalda

File for Purchases Invoice (Only Test Specific Fields Withholding) OK

Withholding : PPrueba

ExcludeForWithholding : TRUE

Document No / Order Reference Logic

Sales

Load using DocNo : OK

Load using Order Referece : OK

Try to load DocNo twice -> This invoice had been imported before DocumentNo :1_0001_A OK

Try to load Order Reference twice -> This invoice had been imported before * Order Reference :5_1_2 OK

Test Auto Mode : OK

Purchases

Load using DocNo : OK

Load using Order Referece : OK

Try to load DocNo twice -> This invoice had been imported before DocumentNo :1_0001_A OK

Try to load Order Reference twice -> This invoice had been imported before * Order Reference :5_1_2 OK

Test Auto Mode : OK

PriceListVersion / Price Unit Logic

Sales

Prices Logic Tested OK

Purchases

Prices Logic Tested OK

Type of lines (Product, Invoice, Nothing)

Sales

Line with Product OK

Line with GL Item OK

- G/L Item not found or not checked with "Enable In Financial Invoices": Retención IRPFR OK

Line with Nothing OK

Invoice with all types of lines OK

Purchases

Line with Product OK

Line with GL Item OK

- G/L Item not found or not checked with "Enable In Financial Invoices": Retención IRPFR OK

Line with Nothing OK

Invoice with all types of lines OK

Taxes (null taxes)

If you have a line with amount and without tax you will receive the next message (the same error that is showed in the application) :
- ERROR: el nuevo registro para la relación «c_invoiceline» viola la restricción check «c_invoiceline_check2»

ADD CONSTRAINT c_invoiceline_check2 CHECK (linenetamt = 0::numeric OR c_tax_id IS NOT NULL);

Process / Not Process lines

All Not Proceeded OK

All Processed OK

Processed and Not Processed Mixed OK

Process with Errors -> PREVIOUS Invoice with DocumentNo / OrderReference : PME_0002_A / 23 can't be processed : ERROR: The Period does not exist or it is not opened OK

Retrieved from "http://wiki.openbravo.com/wiki/Projects:IDL_Extension_Invoices/QA_Test_Cases"

This page has been accessed 548 times. This page was last modified on 20 March 2018, at 09:33. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.

Toolbox

Search

Participate

Projects:IDL Extension Invoices/QA Test Cases

Contents

QA TestCases

Everything OK

Not Null Values (Leave null values in not null fields)

Data Corrupted (Value don't match, name don't match... )

Use Default Values from Entities (User Contact, PriceList, Payment Terms, etc....)

Use Default Values from IDL

Document No / Order Reference Logic

PriceListVersion / Price Unit Logic

Type of lines (Product, Invoice, Nothing)

Taxes (null taxes)

Process / Not Process lines