Openbravo Issue Tracking System - Openbravo Localizations
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0047419Openbravo LocalizationsLocalization Francepublic2021-07-20 18:432022-05-19 15:30
Reporterpsanjuan 
Assigned Toigor_trebol 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionOpenbravo Appliance 14.04
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Support ticket
OBNetwork customer
Regression introduced in release
Summary0047419: Wrong tax calculation for sales to not exempt customers from a Store located in Guadeloupe to a customer located in Guadeloupe
DescriptionWrong tax calculation for sales to not exempt customers from a Store located in Guadeloupe to a customer located in Guadeloupe
Steps To ReproduceConfigure the organization located in France, Guadeloupe region.
Configure the Anonymous BP located in France, Guadeloupe region. Make sure this customer is not configured as Exempt.

Configure a product with Home Delivery, and related to the tax category TVA Normale.

Book a sale for that customer and product from POS.
Verify that below two rates are shown. See POS image attached:

TVA 8.5 DOM-TOM
Export DOM-TOM Normale

This is not correct. Only the TVA 8.5 DOM-TOM should be shown.

Proposed SolutionIt is required to change the setup of below listed Tax Rates, therefore the regions in the Header are moved to the Tax Zone. See image below (issue47419-wrongsetup) and (issue47419-correctsetup):

Export DOM-TOM Normale
Regions fields in the header must be empty.
there a new record needs to be created in the Tax Zone tab with below setup:
From Country = France
From Region = Auvergne-Rhône-Alpes
Destination Country = France
Destination Region = Guadelupe

Same applies to Export DOM-TOM Réduite:
Regions fields in the header must be empty.
there a new record needs to be created in the Tax Zone tab with below setup:
From Country = France
From Region = Auvergne-Rhône-Alpes
Destination Country = France
Destination Region = Guadelupe
Additional Information
TagsNOR
Relationships
related to defect 0047264 closed Triage Omni OMS Modules Configuration of 'Region' and 'Destination Region' in the 'Tax rate' header does not work, for instance 8.5 DOM-TOM 
related to feature request 0045755 closed vmromanos Openbravo Localizations New taxes required set as Tax Exempt=Yes 
related to defect 0047281 closed vmromanos Openbravo Localizations Some Exempt tax rates are not configured properly 
related to defect 0048737 closed aferraz Retail Modules Performance problem in Tax Engine having tax rules with many tax zones 
Attached Filespng Issue_47419.png (143,997) 2021-07-20 18:45
https://issues.openbravo.com/file_download.php?file_id=16024&type=bug
png

png issue47419-wrongsetup.png (215,157) 2021-10-29 10:20
https://issues.openbravo.com/file_download.php?file_id=16314&type=bug
png

png issue47419-correctsetup.png (160,781) 2021-10-29 10:20
https://issues.openbravo.com/file_download.php?file_id=16315&type=bug
png

png correct_POS-setup.png (215,860) 2021-10-29 10:22
https://issues.openbravo.com/file_download.php?file_id=16316&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2021-07-20 18:43psanjuanNew Issue
2021-07-20 18:45psanjuanFile Added: Issue_47419.png
2021-07-20 18:45psanjuanAssigned To => psanjuan
2021-07-20 22:34rafarodaTag Attached: NOR
2021-07-20 22:35rafarodaRelationship addedrelated to 0047264
2021-07-20 22:37rafarodaRelationship addedrelated to 0045755
2021-07-20 22:37rafarodaRelationship addedrelated to 0047281
2021-08-26 14:33rafarodaResolution time => 1630792800
2021-10-29 10:00psanjuanNote Added: 0132738
2021-10-29 10:11psanjuanNote Edited: 0132738bug_revision_view_page.php?bugnote_id=0132738#r23252
2021-10-29 10:15psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=23254#r23254
2021-10-29 10:15psanjuanProposed Solution updated
2021-10-29 10:17psanjuanFile Added: Screenshot from 2021-10-29 10-10-17.png
2021-10-29 10:17psanjuanFile Deleted: Screenshot from 2021-10-29 10-10-17.png
2021-10-29 10:20psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=23255#r23255
2021-10-29 10:20psanjuanProposed Solution updated
2021-10-29 10:20psanjuanFile Added: issue47419-wrongsetup.png
2021-10-29 10:20psanjuanFile Added: issue47419-correctsetup.png
2021-10-29 10:22psanjuanFile Added: correct_POS-setup.png
2021-10-29 12:33aferrazAssigned Topsanjuan => fernando_merino
2022-05-05 14:12psanjuanAssigned Tofernando_merino => aferraz
2022-05-17 13:29aferrazAssigned Toaferraz => igor_trebol
2022-05-19 15:00igor_trebolNote Added: 0137537
2022-05-19 15:00igor_trebolStatusnew => closed
2022-05-19 15:00igor_trebolResolutionopen => fixed
2022-05-19 15:30aferrazRelationship addedrelated to 0048737

Notes
(0132738)
psanjuan   
2021-10-29 10:00   
(edited on: 2021-10-29 10:11)
The regions configured in the tax rates is correct because:
See Export DOM-TOM Normale tax rate.
- sales from (Region) Auvergne-Rhone-Alpes to (Destination Region) Guadalupe is an Export DOM-TOM
- sales from (Region) Guadalupe to Italy or to any EU Country are also Export DOM-TOM
- sales from Guadalupe to Guadalupe are TVA 8.5 DOM-TOM
(0137537)
igor_trebol   
2022-05-19 15:00   
This problem is solved in issue 0048737 and is not happening in newer versions.