Projects:IDL Extension Invoices/QA Test Cases
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