Openbravo Issue Tracking System - Retail Modules
View Issue Details
0051712Retail ModulesWeb POSpublic2023-02-27 23:342023-03-08 13:19
axelmercado 
Triage Omni OMS 
urgentminoralways
newopen 
5
pi 
pi 
aferraz
No
0051712: Tax application error in POS
When we have 2 taxes that are applicable in a country and we make a sale of a product where these taxes apply, we can observe that both apply.
In livebuilds:
1- For example, 2 similar taxes are configured: Entregas IVA 21% and Entregas IVA 22.

2- In the POS if we sell any product, both taxes are applied.

3- In the backoffice, if we go to the Sales Order window, we can see that it has as tax Entregas IVA 21%, but in the lines appear both taxes.

Video: https://drive.google.com/file/d/1NmDg6Ytw2a6Tfpz5xKrvjh4G1mhuEv9D/view [^]
Create an Event Handler to warn end user when creating or updating a Tax Rate with an already existing configuration in the back office.
No tags attached.
duplicate of defect 0048580 closed ebecerra POS2 2693: Tax engine is not working well when several tax zones are defined 
related to defect 0048737 closed aferraz Retail Modules Performance problem in Tax Engine having tax rules with many tax zones 
png Screenshot from 2023-02-28 12-00-20.png (111,912) 2023-02-28 12:00
https://issues.openbravo.com/file_download.php?file_id=18176&type=bug
png

png Screenshot from 2023-02-28 12-00-46.png (130,216) 2023-02-28 12:00
https://issues.openbravo.com/file_download.php?file_id=18177&type=bug
png

png Screenshot from 2023-02-28 12-59-53.png (91,920) 2023-02-28 13:00
https://issues.openbravo.com/file_download.php?file_id=18181&type=bug
png

png Screenshot from 2023-02-28 13-01-28.png (161,557) 2023-02-28 13:01
https://issues.openbravo.com/file_download.php?file_id=18183&type=bug
png

png Screenshot from 2023-02-28 13-01-48.png (232,337) 2023-02-28 13:01
https://issues.openbravo.com/file_download.php?file_id=18184&type=bug
png

png Screenshot from 2023-02-28 13-44-37.png (236,272) 2023-02-28 13:52
https://issues.openbravo.com/file_download.php?file_id=18187&type=bug
png

png Screenshot from 2023-02-28 13-44-39.png (234,718) 2023-02-28 13:52
https://issues.openbravo.com/file_download.php?file_id=18188&type=bug
png

png Screenshot from 2023-02-28 13-49-00.png (237,005) 2023-02-28 13:52
https://issues.openbravo.com/file_download.php?file_id=18189&type=bug
png

png Screenshot from 2023-02-28 13-51-35.png (297,058) 2023-02-28 13:52
https://issues.openbravo.com/file_download.php?file_id=18190&type=bug
Issue History
2023-02-27 23:34axelmercadoNew Issue
2023-02-27 23:34axelmercadoAssigned To => Retail
2023-02-27 23:34axelmercadoTriggers an Emergency Pack => No
2023-02-28 07:51PracticsIssue Monitored: Practics
2023-02-28 09:23psanjuanNote Added: 0147086
2023-02-28 09:23psanjuanAssigned ToRetail => axelmercado
2023-02-28 09:23psanjuanStatusnew => feedback
2023-02-28 09:26PracticsNote Added: 0147087
2023-02-28 09:28psanjuanNote Added: 0147088
2023-02-28 11:55psanjuanNote Added: 0147106
2023-02-28 11:55psanjuanAssigned Toaxelmercado => aferraz
2023-02-28 11:55psanjuanSeveritycritical => major
2023-02-28 11:55psanjuanStatusfeedback => scheduled
2023-02-28 11:59psanjuanNote Edited: 0147106bug_revision_view_page.php?bugnote_id=0147106#r25596
2023-02-28 11:59psanjuanFile Added: Screenshot from 2023-02-28 11-49-59.png
2023-02-28 12:00psanjuanFile Deleted: Screenshot from 2023-02-28 11-49-59.png
2023-02-28 12:00psanjuanFile Added: Screenshot from 2023-02-28 12-00-20.png
2023-02-28 12:00psanjuanFile Added: Screenshot from 2023-02-28 12-00-46.png
2023-02-28 12:01psanjuanFile Added: Screenshot from 2023-02-28 12-01-02.png
2023-02-28 12:54psanjuanNote Edited: 0147106bug_revision_view_page.php?bugnote_id=0147106#r25597
2023-02-28 12:55psanjuanNote Added: 0147107
2023-02-28 12:57psanjuanNote Edited: 0147107bug_revision_view_page.php?bugnote_id=0147107#r25599
2023-02-28 12:59psanjuanFile Deleted: Screenshot from 2023-02-28 12-01-02.png
2023-02-28 13:00psanjuanFile Added: Screenshot from 2023-02-28 12-59-53.png
2023-02-28 13:01psanjuanFile Added: Screenshot from 2023-02-28 13-01-28.png
2023-02-28 13:01psanjuanFile Added: Screenshot from 2023-02-28 13-01-48.png
2023-02-28 13:05psanjuanNote Edited: 0147106bug_revision_view_page.php?bugnote_id=0147106#r25600
2023-02-28 13:05psanjuanNote Edited: 0147107bug_revision_view_page.php?bugnote_id=0147107#r25601
2023-02-28 13:29aferrazRelationship addedrelated to 0048580
2023-02-28 13:31aferrazRelationship addedrelated to 0048737
2023-02-28 13:47aferrazReview Assigned To => aferraz
2023-02-28 13:47aferrazRelationship replacedduplicate of 0048580
2023-02-28 13:47aferrazNote Added: 0147108
2023-02-28 13:47aferrazStatusscheduled => closed
2023-02-28 13:47aferrazResolutionopen => duplicate
2023-02-28 13:52aferrazFile Added: Screenshot from 2023-02-28 13-44-37.png
2023-02-28 13:52aferrazFile Added: Screenshot from 2023-02-28 13-44-39.png
2023-02-28 13:52aferrazFile Added: Screenshot from 2023-02-28 13-49-00.png
2023-02-28 13:52aferrazFile Added: Screenshot from 2023-02-28 13-51-35.png
2023-03-01 09:27psanjuanNote Added: 0147152
2023-03-08 13:10aferrazNote Added: 0147379
2023-03-08 13:10aferrazStatusclosed => new
2023-03-08 13:10aferrazResolutionduplicate => open
2023-03-08 13:10aferrazAssigned Toaferraz => Triage Omni OMS
2023-03-08 13:10aferrazSeveritymajor => minor
2023-03-08 13:12aferrazProposed Solution updated
2023-03-08 13:19aferrazProposed Solution updated
2023-03-08 13:22psanjuanNote Edited: 0147379bug_revision_view_page.php?bugnote_id=0147379#r25661

Notes
(0147086)
psanjuan   
2023-02-28 09:23   
Hello Axel,
Please attached 2 images in which we can see the full set up of these two tax rates.
Let us also know the OB version, and the customer being used (setup of the customer, mainly location).
thanks,
Patricia.
(0147087)
Practics   
2023-02-28 09:26   
Hola Patricia, has visto el video que grabé yo mismo? Que te falta en ese video?
(0147088)
psanjuan   
2023-02-28 09:28   
Why this issue is critical. First thing I see is that these two taxes should not belong to the same tax category as the rate is not the same. One is 21 and the other one is 22. Is this a real example or just a test?.
Please remove critical severity.
(0147106)
psanjuan   
2023-02-28 11:55   
(edited on: 2023-02-28 13:05)
Steps to reproduce:
- configure a tax rate (1=Exportaciones) that includes Spain as From Country and UK as Destination country with no Destination Region.
- configure a second tax rate (2) sames as above one, but just adding a Destination region "Avon" (of UK).
-Create a BP located in UK with no region.
- Create a Sales in the POS for that UK customer, Delivery Terms = Home Delivery, verify that both tax rates (1) and (2) are selected. This is not correct as in this case the one without region should have been taken into account as the BP does not have a region.

Moreover, If a region is configured in the BP, the POS selects the proper one, but as the POS does not allow the creation of BP with Region, if two tax rates apply one with region, and another one without, the one without region should be used.

(0147107)
psanjuan   
2023-02-28 12:55   
(edited on: 2023-02-28 13:05)
This issue can be reproduced in 21Q3.
It can not be reproduce in main (see images attached).

To be analized.

In any case, if two tax rates are exactly the same, both will be shown in the POS.

(0147108)
aferraz   
2023-02-28 13:47   
When we define two tax rates with exactly the same configuration (same tax category, starting date, origin/destination country, origin/destination region, etc.) both taxes will apply to the sale.

In case both tax rates have the same configuration, but with a different destination region, the tax with destination region equals the store region (when delivering at store) or equals the customer region (when doing home delivery) will apply.
(0147152)
psanjuan   
2023-03-01 09:27   
Backport of issue 48580 to 21Q3 to be created.
(0147379)
aferraz   
2023-03-08 13:10   
(edited on: 2023-03-08 13:22)
Reopening the issue as it describes the scenario of having two tax rates with exactly the same configuration.
Severity changed to minor as this is a configuration problem and proposed solution updated to warn the end user when creating this wrong configuration in the backoffice.

Openbravo POS Tax Engine is not going to be changed, under the assumption that two tax rates must not be exactly the same.

The scenario about having two tax rates with the same configuration but different destination region is already fixed in 0048580.