View source | View content page | Page history | Printable version   

Projects:IDL Extension Invoices/QA Test Cases

Contents

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

"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",,
"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

Purchases

--

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

Sales

Purchases

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

"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",,
"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

"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",,,,,,,,,,,,,,,,,,,,,,,,,,

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

--

Withholding : PPrueba

ExcludeForWithholding : TRUE

Document No / Order Reference Logic

Sales

--

Purchases

--

PriceListVersion / Price Unit Logic

Sales

--

Purchases

--

Type of lines (Product, Invoice, Nothing)

Sales

--

Purchases

--

Taxes (null taxes)

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

--

Process / Not Process lines

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.