Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0034091
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Localization Pack: Spain] Multi Dimensional Tax Reportminoralways2016-09-26 15:592016-11-15 14:23
ReporterngarciaView Statuspublic 
Assigned Tomarkmm82 
PriorityhighResolutionopenFixed in Version
StatusscheduledFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0034091: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to feature request 0025506 newpsanjuan Openbravo ERP It should be possible to adjust the total gross amount of a purchase invoice 

-  Notes
(0090289)
psanjuan (manager)
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 (developer)
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 (manager)
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 (manager)
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 (manager)
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 (manager)
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 (manager)
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 (manager)
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 (manager)
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 (manager)
2016-11-15 14:23

 Test Plan above verified.

Issue fix can be reviewed.

- Issue History
Date Modified Username Field Change
2016-09-26 15:59 ngarcia New Issue
2016-09-26 15:59 ngarcia Assigned To => Triage Finance
2016-09-26 16:02 ngarcia Relationship added related to 0025506
2016-09-26 16:03 ngarcia Issue Monitored: networkb
2016-09-27 09:58 psanjuan Steps to Reproduce Updated View Revisions
2016-09-27 10:50 psanjuan Note Added: 0090289
2016-10-11 09:49 aferraz Assigned To Triage Finance => markmm82
2016-10-11 09:52 aferraz Note Edited: 0090289 View Revisions
2016-10-17 16:26 markmm82 Status new => scheduled
2016-10-20 19:31 markmm82 Note Added: 0090738
2016-10-25 15:36 psanjuan Note Added: 0090869
2016-10-25 15:41 psanjuan Note Edited: 0090869 View Revisions
2016-10-25 18:55 psanjuan Note Edited: 0090869 View Revisions
2016-10-25 19:01 psanjuan Note Edited: 0090869 View Revisions
2016-10-25 19:05 psanjuan Note Edited: 0090869 View Revisions
2016-10-27 15:21 psanjuan Note Edited: 0090869 View Revisions
2016-10-27 16:07 psanjuan Note Edited: 0090869 View Revisions
2016-10-27 16:09 psanjuan Note Edited: 0090869 View Revisions
2016-10-27 16:15 psanjuan Note Added: 0090962
2016-10-27 16:16 psanjuan Note Edited: 0090962 View Revisions
2016-10-27 16:23 psanjuan Note Edited: 0090962 View Revisions
2016-11-03 13:14 psanjuan Note Edited: 0090869 View Revisions
2016-11-03 13:14 psanjuan Note Edited: 0090962 View Revisions
2016-11-03 13:18 psanjuan Note Added: 0091076
2016-11-03 13:23 psanjuan Note Edited: 0091076 View Revisions
2016-11-03 13:23 psanjuan Note Edited: 0091076 View Revisions
2016-11-03 13:44 psanjuan Note Added: 0091077
2016-11-15 13:34 psanjuan Note Edited: 0090869 View Revisions
2016-11-15 13:40 psanjuan Note Edited: 0091076 View Revisions
2016-11-15 13:45 psanjuan Note Edited: 0091077 View Revisions
2016-11-15 13:51 psanjuan Note Added: 0091558
2016-11-15 13:52 psanjuan Note Edited: 0091077 View Revisions
2016-11-15 13:52 psanjuan Note Edited: 0091558 View Revisions
2016-11-15 13:54 psanjuan Note Added: 0091559
2016-11-15 14:08 psanjuan Note Edited: 0091559 View Revisions
2016-11-15 14:11 psanjuan Note Edited: 0091559 View Revisions
2016-11-15 14:14 psanjuan Note Added: 0091562
2016-11-15 14:23 psanjuan Note Added: 0091563

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker