Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034091Localization Pack: SpainMulti Dimensional Tax Reportpublic2016-09-26 15:592016-11-15 14:23
Reporterngarcia 
Assigned Tomarkmm82 
PriorityhighSeverityminorReproducibilityalways
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0034091: Multidimensional Tax Report should hide the Tax Base Amount of the manual tax adjustments in invoices
DescriptionMultidimensional Tax Report should hide the Tax Base Amount of the manual tax adjustments in invoices
Steps To ReproduceAs group admin role:
   Create a new Purchase Invoice
   Add a line and select a rate of 21%
   Add a manual record in the Tax tab with the same rate and Tax Amount of 0.01
   Check the Taxable Amount is updated to 0.05, the Total Gross Amount is updated but the the Total Net Amount remains the same
   Post it and check the tax amounts of the tax tab are used, but not the taxable amount
   Launch the Multidimensional Tax Report and check the adjustment record is shown on it. As the tax base amount is then summed up, the total does not match the total net amount of the invoice. This is not correct.
   The Total Document Amt. does not match the invoice's total gross amount as it is duplicated
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0025506 new psanjuan Openbravo ERP It should be possible to adjust the total gross amount of a purchase invoice 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-09-26 15:59ngarciaNew Issue
2016-09-26 15:59ngarciaAssigned To => Triage Finance
2016-09-26 16:02ngarciaRelationship addedrelated to 0025506
2016-09-26 16:03ngarciaIssue Monitored: networkb
2016-09-27 09:58psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=13222#r13222
2016-09-27 10:50psanjuanNote Added: 0090289
2016-10-11 09:49aferrazAssigned ToTriage Finance => markmm82
2016-10-11 09:52aferrazNote Edited: 0090289bug_revision_view_page.php?bugnote_id=0090289#r13350
2016-10-17 16:26markmm82Statusnew => scheduled
2016-10-20 19:31markmm82Note Added: 0090738
2016-10-25 15:36psanjuanNote Added: 0090869
2016-10-25 15:41psanjuanNote Edited: 0090869bug_revision_view_page.php?bugnote_id=0090869#r13478
2016-10-25 18:55psanjuanNote Edited: 0090869bug_revision_view_page.php?bugnote_id=0090869#r13479
2016-10-25 19:01psanjuanNote Edited: 0090869bug_revision_view_page.php?bugnote_id=0090869#r13480
2016-10-25 19:05psanjuanNote Edited: 0090869bug_revision_view_page.php?bugnote_id=0090869#r13481
2016-10-27 15:21psanjuanNote Edited: 0090869bug_revision_view_page.php?bugnote_id=0090869#r13494
2016-10-27 16:07psanjuanNote Edited: 0090869bug_revision_view_page.php?bugnote_id=0090869#r13495
2016-10-27 16:09psanjuanNote Edited: 0090869bug_revision_view_page.php?bugnote_id=0090869#r13496
2016-10-27 16:15psanjuanNote Added: 0090962
2016-10-27 16:16psanjuanNote Edited: 0090962bug_revision_view_page.php?bugnote_id=0090962#r13498
2016-10-27 16:23psanjuanNote Edited: 0090962bug_revision_view_page.php?bugnote_id=0090962#r13499
2016-11-03 13:14psanjuanNote Edited: 0090869bug_revision_view_page.php?bugnote_id=0090869#r13541
2016-11-03 13:14psanjuanNote Edited: 0090962bug_revision_view_page.php?bugnote_id=0090962#r13542
2016-11-03 13:18psanjuanNote Added: 0091076
2016-11-03 13:23psanjuanNote Edited: 0091076bug_revision_view_page.php?bugnote_id=0091076#r13544
2016-11-03 13:23psanjuanNote Edited: 0091076bug_revision_view_page.php?bugnote_id=0091076#r13545
2016-11-03 13:44psanjuanNote Added: 0091077
2016-11-15 13:34psanjuanNote Edited: 0090869bug_revision_view_page.php?bugnote_id=0090869#r13737
2016-11-15 13:40psanjuanNote Edited: 0091076bug_revision_view_page.php?bugnote_id=0091076#r13738
2016-11-15 13:45psanjuanNote Edited: 0091077bug_revision_view_page.php?bugnote_id=0091077#r13740
2016-11-15 13:51psanjuanNote Added: 0091558
2016-11-15 13:52psanjuanNote Edited: 0091077bug_revision_view_page.php?bugnote_id=0091077#r13741
2016-11-15 13:52psanjuanNote Edited: 0091558bug_revision_view_page.php?bugnote_id=0091558#r13743
2016-11-15 13:54psanjuanNote Added: 0091559
2016-11-15 14:08psanjuanNote Edited: 0091559bug_revision_view_page.php?bugnote_id=0091559#r13745
2016-11-15 14:11psanjuanNote Edited: 0091559bug_revision_view_page.php?bugnote_id=0091559#r13746
2016-11-15 14:14psanjuanNote Added: 0091562
2016-11-15 14:23psanjuanNote Added: 0091563

Notes
(0090289)
psanjuan   
2016-09-27 10:50   
(edited on: 2016-10-11 09:52)
Not to take into account "Taxable Amount" adjustment done in "Tax" tab (records with Recalculate = N) is a provisional solution, while feature request is not implemented.
(0090738)
markmm82   
2016-10-20 19:31   
Test Plan:
As group admin role:
   Create a new Purchase Invoice
   Add a line and select a rate of 21%
   Add a manual record in the Tax tab with the same rate and Tax Amount of 0.01
   Check the Taxable Amount is updated, the Total Gross Amount is updated but the the Total Net Amount remains the same
   Post it and check the tax amounts of the tax tab are used, but not the taxable amount
   Launch the Multidimensional Tax Report and check the adjustment record is not shown on it.
   The Total Document Amt. does match the invoice's total gross amount. It is correct.
(0090869)
psanjuan   
2016-10-25 15:36   
(edited on: 2016-11-15 13:34)
Test Case 1 - single tax rate adjustment

In QA client.

As QA Testing Admin role, go to Purchase Invoice window.

Create a new one for Spain organization, Vendor A business partner.
Go to Lines and select "Service A" product. Enter 50 units.
Check that VAT 10% tax rate is selected. Save.

Go to Tax tab and add a new record with below setup:
Tax rate = VAT 10%
Tax Amount = 0.01
Tax Base Amount = it is recalculated to 0.10

Complete and post the invoice.

Check posting looks like:
100.00 (60000) DEBIT
10.01(472000) DEBIT
110.01 (40000) CREDIT

Check that Tax Base Amount remains as 100.00

Launch Multidimensional Tax Report with below setup:
From date = To date = today's date
Organization = Spain
Currency = EUR
BP = Vendor A
Tax = Yes
Purchase/Payments = Yes

Verify below info is shown in the report:
Doc. Type = AP Invoice
Invoice Number = 10000024
Tax Base Amount = 100.00
Tax Amount = 10.01
Total Doc Amount = 110.01

Test Case 2

Repeat same test as above for a Sales Invoice.

Launch Multidimensional Tax Report with below setup:
From date = To date = today's date
Organization = Spain
Currency = EUR
BP = Customer A
Tax = Yes
Sales/Receipts = Yes

Verify below info is shown in the report:
Doc. Type = AR Invoice
Invoice Number = 10000025
Tax Base Amount = 100.00
Tax Amount = 10.01
Total Doc Amount = 110.01
(0090962)
psanjuan   
2016-10-27 16:15   
(edited on: 2016-11-03 13:14)
Test Case 3 - single tax rate (including withholding) adjustement

In QA admin create a new tax rate including a 10% VAT and a withholding of -15%
Go to purchase invoice and create a new one for Spain org, Vendor A.

Go to lines and select Service A, enter 50 units.
Select the new tax rate created. Save

Go to Tax tab and check there are two lines.
Enter a new one with below setup:
Tax = VAT 10% + 15% R (10%)
Tax Amount = 0.01
Taxable Amount = 0.10
Recalculate = No

Complete and post the invoice.

Check below data:
Total gross amount = 95.01
Total net amount = 100.00
Tax = 10.01
Withholding tax = -15.00

Launch Multidimensional Tax report with below setup:
From date = To date = today's date
Organization = Spain
Currency = EUR
BP = Vendor A
Tax = Yes
Purchase/Payments = Yes

Verify below date is shown for tax rate "VAT 10% +15%R (10%)

Tax Base = 100.00
Tax Amount = 10.01 (now the report shows -4.99 = 10.00+0.01-15.00)
Total Document Amt = 95.01

Same way, Launch Multidimensional Tax report with below setup:
From date = To date = today's date
Organization = Spain
Currency = EUR
BP = Vendor A
Tax = NO
Withholding = Yes
Purchase/Payments = Yes

Verify below date is shown for tax rate "VAT 10% +15%R (-15%)

Tax Base = 100.00
Tax Amount = -15.00 (now the report shows -4.99 = 10.00+0.01-15.00)
Total Document Amt = 95.01
(0091076)
psanjuan   
2016-11-03 13:18   
(edited on: 2016-11-15 13:40)
Test Case 4 - invoice including two different tax rates, and one of them is adjusted

In QA Admin, go to purchase invoice and create a new one for Vendor A.
Enter two lines, with below setup:
Line 1 - Product = Service A - Invoiced quantity = 50 - net unit price = 2.00 Line Net amount = 100.00 - Tax = VAT 10%

Line 2 - Product = Service B - Invoiced quantity = 70 - net unit price = 2.00 Line Net amount = 140.00 - Tax = VAT 3%

Save

Write down total gross amount = 254.20, Total Net Amount = 240.00

Go to Tax tab and create an adjustement for VAT 10% as shown below:
Tax = VAT 10% - VAT 10%
Tax amount = 0.01
Taxable Amount = 0.10

Save

Write down total gross amount = 254.21, Total Net Amount = 240.00
Invoice Number 1000030

Complete and post the invoice.

Verify below posting is shown:

240.00 (60000) DEBIT
14.21 (47200) DEBIT
254.21 (40000) CREDIT

Launch Multidimensional tax report with below setup:
From date /To date = current day
Currency EUR
BP = Vendor A
Tax = Yes
Purchase / Payments = Yes

Below data need to be shown for VAT 10% rate:
Tax Base = 100.00
Tax Amount = 10.01
Total Doc Amount = 254.21

Below data need to be shown for VAT 3% rate:
Tax Base = 140.00
Tax Amount = 4.20
Total Doc Amount = 254.21

Repeat same test as above for a Sales Invoice.
(0091077)
psanjuan   
2016-11-03 13:44   
(edited on: 2016-11-15 13:52)
Test Case 5 - Intracommunity VAT

Create a new tax rate, named "Intracommunity VAT 10%", with below setup:
Rate = 0
Summary = Yes
Purchase Tax = Yes
Valid from = 01-01-2016
Tax Category = VAT 10%

Create a child tax rate, named "Intracommunity VAT 10% (+10%), with below setup:
Rate = 10
Summary = No
Parent Tax rate = Intracommunity VAT 10%
Purchase Tax = Yes
Valid from = 01-01-2016
Tax Category = VAT 10%

Create another child tax rate, named "Intracommunity VAT 10% (-10%), with below setup:
Rate = -10
Summary = No
Parent Tax rate = Intracommunity VAT 10%
Purchase Tax = Yes
Valid from = 01-01-2016
Tax Category = VAT 10%

Go to purchase invoice and create a new one for Spain Org, Vendor Francia.
Select "Service A" product, enter 50 ordered quantity, and tax rate "Intracommunity VAT 10".
Complete and post the invoice.

Check that Total Gross amount = Total Net Amount = 100.00

Go to Tax tab and check that below info is shown:

Line 1 - Tax = Intracommunity VAT 10% (+10%) - Tax Amount = 10.00 - Taxable Amount = 100.00

Line 2 - Tax = Intracommunity VAT 10% (-10%) - Tax Amount = -10.00 - Taxable Amount = 100.00

Launch Multidimensional Tax Report with below setup:
From date / To date = current date
Currency = EUR
BP = Vendor Francia
Tax = Yes
Purchase /Payments = Yes

Below data is shown for Intracommunity VAT 10% (+10%)
Tax Base = 100.00
Tax Amount = 10.00
Total Doc Amount = 100.00

Below data is shown for Intracommunity VAT 10% (-10%)
Tax Base = 100.00
Tax Amount = -10.00
Total Doc Amount = 100.00
(0091558)
psanjuan   
2016-11-15 13:51   
(edited on: 2016-11-15 13:52)
Test Case 6 - Intracommunity VAT + Tax Amount Adjustment.

Go to purchase invoice and create a new one for Spain Org, Vendor Francia.
Select "Service A" product, enter 50 ordered quantity, and tax rate "Intracommunity VAT 10".

Go to Tax tab and check that below info is shown:

Line 1 - Tax = Intracommunity VAT 10% (+10%) - Tax Amount = 10.00 - Taxable Amount = 100.00

Line 2 - Tax = Intracommunity VAT 10% (-10%) - Tax Amount = -10.00 - Taxable Amount = 100.00

Add one line with below setup:
Tax: Intracommunity VAT (10%) (+10%)
Tax Amount = 0.01
Taxable Amount = recalculated to 0.10

Add another line with below setup:

Tax: Intracommunity VAT (10%) (-10%)
Tax Amount = -0.01
Taxable Amount = recalculated to 0.10

Complete and post the invoice.

Check that Total Gross amount = Total Net Amount = 100.00

Launch Multidimensional Tax Report with below setup:
From date / To date = current date
Currency = EUR
BP = Vendor Francia
Tax = Yes
Purchase /Payments = Yes

Below data is shown for Intracommunity VAT 10% (+10%)
Tax Base = 100.00
Tax Amount = 10.01
Total Doc Amount = 100.00

Below data is shown for Intracommunity VAT 10% (-10%)
Tax Base = 100.00
Tax Amount = -10.01
Total Doc Amount = 100.00
(0091559)
psanjuan   
2016-11-15 13:54   
(edited on: 2016-11-15 14:11)
Test Case 7 - Exempt tax rate included.

In QA Admin, go to purchase invoice and create a new one for Vendor A.
Enter two lines, with below setup:

Line 1 - Product = Service A - Invoiced quantity = 50 - net unit price = 2.00 Line Net amount = 100.00 - Tax = VAT 10% -15%R

Line 2 - Product = Service B - Invoiced quantity = 70 - net unit price = 2.00 Line Net amount = 140.00 - Tax = Exempt

Save

Write down total gross amount = 235.00, Total Net Amount = 240.00

Go to Tax tab and create an adjustement for VAT 10% as shown below:
Tax = VAT 10% + 15% R (10%)
Tax amount = 0.01
Taxable Amount = 0.10

Save

Write down total gross amount = 235.01, Total Net Amount = 240.00
Invoice Number 1000038

Complete and post the invoice.

Verify below posting is shown:

240.00 (60000) DEBIT
10.01 (47200) DEBIT
235.01(40000) CREDIT
15.00 (47510) CREDIT

Launch Multidimensional tax report with below setup:
From date /To date = current day
Currency EUR
BP = Vendor A
Tax = Yes
Purchase / Payments = Yes

Below data need to be shown for Exempt rate:
Tax Base = 140.00
Tax Amount = 0.00
Total Doc Amount = 235.01

Below data need to be shown for VAT 10% -15%R (+10%) rate:
Tax Base = 100.00
Tax Amount = 10.01
Total Doc Amount = 235.01

Launch Multidimensional tax report with below setup:
From date /To date = current day
Currency EUR
BP = Vendor A
Witholding = Yes
Purchase / Payments = Yes

Below data need to be shown for VAT 10% -15%R (-15%) rate:
Tax Base = 100.00
Tax Amount = -15.00
Total Doc Amount = 235.01
(0091562)
psanjuan   
2016-11-15 14:14   
Test Case 8 - Sales Invoice including an exempt VAT rate and two different rates being adjusted.
 
Repeat same test as above for a Sales Invoice but including below tax sales invoice lines and rates:

Line 1 - Product= Service A, Invoiced Qty = 50, Net Unit Price = 2.00, Tax = VAT 10%
Line 2 - Product = Service B, Invoiced Qty = 70, Net Unit Price = 2.00, Tax = VAT 3%
Line 3 - Product = Insurance, Invoiced Qty = 1, Net Unit Price = 1300.00 Tax = Exempt.

Check Total Gross amount = 1554.20, Total Net Amount = 1540.00

Go to tax tab and enter below adjustments:

For tax VAT 10%
Tax amount = 0.01
Taxable Amount recalculated to 0.10

For tax VAT 3%
Tax amount = 0.02
Taxable Amount recalculated to 0.67

Write down Total Gross Amount = 1554.23, Total Net Amount = 1540.00

Complete and Post the invoice.

Verify below posting:

1554.23 (43000) DEBIT
1540.00 (70000) CREDIT
14.23 (47700) CREDIT


Launch Multidimensional tax report with below setup:
From date /To date = current day
Currency EUR
BP = Customer A
Tax = Yes
Sales / Receipts = Yes

Verify below data is shown for Exempt tax rate:
Tax Base = 1300.00
Tax Amount = 0.00
Total Doc Amount = 1554.23

Verify below data is shown for VAT 10% tax rate:
Tax Base = 100.00
Tax Amount = 10.01
Total Doc Amount = 1554.23

Verify below data is shown for VAT 3% tax rate:
Tax Base = 140.00
Tax Amount = 4.22
Total Doc Amount = 1554.23
(0091563)
psanjuan   
2016-11-15 14:23   
Test Plan above verified.

Issue fix can be reviewed.