0032463: "Total payment" field not correctly calculated in ReportRegisterByVatJR.jrxml report

Openbravo Issue Tracking System - Openbravo ERP
View Issue Details

ID	Project	Category	View Status	Date Submitted	Last Update
0032463	Openbravo ERP	09. Financial management	public	2016-03-11 13:13	2016-06-17 19:36

Reporter	maite
Assigned To	AtulOpenbravo
Priority	urgent	Severity	major	Reproducibility	always
Status	closed	Resolution	fixed
Platform		OS	5	OS Version
Product Version
Target Version		Fixed in Version	3.0PR16Q3
Merge Request Status
Review Assigned To	aferraz
OBNetwork customer
Web browser
Modules	Core
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency Pack	No

Summary	0032463: "Total payment" field not correctly calculated in ReportRegisterByVatJR.jrxml report
Description	"Total payment" field is current adding sales and purchase tax when it should subtract purchase tax from sales tax amount
Steps To Reproduce	0. Configure Tax Payment functionality following this guide: http://wiki.openbravo.com/wiki/Tax_Payment [^] 1. Create Tax Payment record for valid date range and BP ans set "generate payment" option 2. Run "Create VAT register" process and "Process" tax payment 3. Press "Print" icon from tax payment record, select "Report Tax Payment by VAT" in the report type combo and print it 4. Realize that "Total Payment" amount is not correct
Proposed Solution
Additional Information
Tags	No tags attached.
Relationships
Attached Files

Issue History
Date Modified	Username	Field	Change
2016-03-11 13:13	maite	New Issue
2016-03-11 13:13	maite	Assigned To	=> Triage Finance
2016-03-11 13:13	maite	Modules	=> Core
2016-03-11 13:13	maite	Resolution time	=> 1460844000
2016-03-11 13:13	maite	Triggers an Emergency Pack	=> No
2016-03-11 13:13	maite	Target Version	=> 3.0PR16Q2
2016-03-11 13:14	maite	Issue Monitored: networkb
2016-03-30 08:59	AtulOpenbravo	Assigned To	Triage Finance => AtulOpenbravo
2016-03-30 08:59	AtulOpenbravo	Status	new => scheduled
2016-03-30 12:27	AtulOpenbravo	Note Added: 0085330
2016-03-30 15:13	psanjuan	Note Added: 0085339
2016-03-31 13:21	psanjuan	Note Edited: 0085330	bug_revision_view_page.php?bugnote_id=0085330#r11596
2016-03-31 13:39	psanjuan	Note Added: 0085360
2016-03-31 13:43	psanjuan	Note Edited: 0085360	bug_revision_view_page.php?bugnote_id=0085360#r11598
2016-03-31 13:44	psanjuan	Note Added: 0085361
2016-04-04 10:14	aferraz	Target Version	3.0PR16Q2 =>
2016-04-04 19:26	hgbot	Checkin
2016-04-04 19:26	hgbot	Note Added: 0085423
2016-04-04 19:28	hgbot	Status	scheduled => resolved
2016-04-04 19:28	hgbot	Resolution	open => fixed
2016-04-04 19:28	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/0d3069b6fb40b4b98adc9d3fff7f7edaa60294d4 [^]
2016-04-04 19:35	aferraz	Review Assigned To	=> aferraz
2016-04-04 19:35	aferraz	Note Added: 0085424
2016-04-04 19:35	aferraz	Status	resolved => closed
2016-04-04 19:35	aferraz	Fixed in Version	=> 3.0PR16Q3
2016-06-17 19:36	hudsonbot	Checkin
2016-06-17 19:36	hudsonbot	Note Added: 0087417

Notes

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.