|
Notes |
|
|
(0085330)
|
|
AtulOpenbravo
|
2016-03-30 12:27
(edited on: 2016-03-31 13:21) |
|
- Configure Tax Payment functionality following this guide: http://wiki.openbravo.com/wiki/Tax_Payment [^] [^]
- Login as F&B Admin.
- Go to GL Item and create a record with name "IVA GL Item".
- Go to Tax Register Type.
- Create a record with name as "IVA Sales", sales transaction = yes, GL Item as "IVA GL Item".
- Create a Line under it with "Entregas IVA 21% - IVA Normal" Tax and Document Type as "AR Invoice".
- In Tax Register Type.
- Create a record with name as "IVA Purchase", sales transaction = no, GL Item as "IVA GL Item".
- Create a Line under it with "Adquisiciones IVA 21% - IVA Normal" Tax and Document Type as "AP Invoice".
- Create Tax Payment record for valid date range and BP ans set "generate payment" option.
- Run "Create VAT register" process and "Process" tax payment.
- Press "Print" icon from tax payment record, select "Report Tax Payment by VAT" in the report type combo and print it.
- Check that "Total Payment" amount is correct as in the Payment linked in the Tax Payment record.
|
|
|
|
|
|
|
|
(0085360)
|
|
psanjuan
|
2016-03-31 13:39
(edited on: 2016-03-31 13:43) |
|
Test Plan
Scenario 1 - Purchase VAT > Sales VAT
Configure Tax Payment functionality following this guide:
http://wiki.openbravo.com/wiki/Tax_Payment [^]
Login as F&B Admin. Use F&B España Org.
Go to GL Item and create a record with name "IVA GL Item".
Accounting tab:
F&B España Euro Gl item Debit account = 47000 HP deudora por IVA
F&B España Euro Gl item Credit account = 475000 HP acreedora por IVA
Go to Tax Register Type.
- Create a record for "IVA Sales", sales transaction = yes, GL Item as "IVA GL Item".
- Create a Line under it with "Entregas IVA 21% - IVA Normal" Tax and Document Type as "AR Invoice".
- Create another record for "IVA Purchase", sales transaction = no, GL Item as "IVA GL Item".
- Create a Line under it with "Adquisiciones IVA 21% - IVA Normal" Tax and Document Type as "AP Invoice".
Create Tax Payment record for valid date range (01-01-2016 - 31-03-2016) and BP (Tax Authority) and set "generate payment" option.
Run "Create VAT register" process and "Process" tax payment.
Check that Purchase VAT shown is for instance = 93.75 and Sales VAT shown is for instance = 2.14, therefore Sales VAT - Purchase VAT = -91.31
Press "Print" icon from tax payment record, select "Report Tax Payment by VAT" in the report type combo and print it either in HTML format or in PDF format.
Check that "Total Payment" amount is = -91.31 that means a negative VAT Settlement that implies a payment in from Tax Authorities.
Check that the payment created is a payment in for an amount = 91.31
Scenario 1 - Purchase VAT < Sales VAT
Dated on April 2014 enter a sales invoice and a purchase invoice by using the sales/purchase tax rates set up in both sales tax register and purchase tax register. Make sure that the amount of the sales invoice is > than the amount of the purchase invoice.
complete and post the invoices.
Go to Tax Payment window and create a new one for the period 01-04-2016 to 30-04-2016. Create VAT Register. Check below data:
Sales VAT = 3213.00
Purchase VAT = 74.55
Process it.
check that a payment out has been created for an amount = 3138.45 which is correct. That needs to be paid to the Tax Authorities.
Go back to tax payment window and press print option. Select Report Tax Payment By VAT in either HTML or PDF format.
Check that the total amount shown there is = 3138.45 which is OK.
|
|
|
|
|
Test plan above verified.
Issue can be code reviewed and closed. |
|
|
|
(0085423)
|
|
hgbot
|
|
2016-04-04 19:26
|
|
Repository: erp/devel/pi
Changeset: 0d3069b6fb40b4b98adc9d3fff7f7edaa60294d4
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Mar 30 15:32:26 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/0d3069b6fb40b4b98adc9d3fff7f7edaa60294d4 [^]
Fixes Issue 32463: "Total payment" not correct in ReportRegisterByVatJR report
IsSale value in the data file was compared with different name as in jrxml query to negate tax line values in case of sales or purchase transaction in variable calculation. Now they are kept uniform in both jrxml as well as data xsql file.
---
M src/org/openbravo/erpReports/ReportRegisterByVatJR.jrxml
---
|
|
|
|
|
|
|
|
|
|