Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0042486Retail ModulesWeb POSpublic2019-12-09 11:282019-12-20 09:06
Reportersanti_lozano 
Assigned Toprakashmurugesan88 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR20Q1 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerOBPS
Support ticket13457
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0042486: Exempt Verified Returns not getting correct product tax rate
DescriptionVerified returns of a product with tax rate exempt is not working well. It gets the exempt tax rate with the more recent valid from date, if there are more than one it gets all of them, not the product one. Client has reported it and added a patch to correct this (note that it should also be reviewed, attached here)
Steps To Reproduce* go to Openbravo livebuilds section Retail Stable pgsql backend link (open also webpos link)
* change role to The White Valley Group Admin
* open Tax Rate window. Filter Tax Category column by Exento and Exento Servicios, filter also Sales/Purchase Type column with Sales Tax. Change the Valid from Date of Ventas exentas to 01-01-2001 (in order to have the two sales exempt tax rates valid from the same date).
* go to the webpos, enter with vallblanca user
* Add Car Seats (this is a product with an exempt tax category) to the ticket and pay it
* go to menu, Verified Returns, select the previous ticket made
* note that once added the return line it gets all the exempt taxes (you could also create a new tax category and category rate exempt and it would also appear here see images attached)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0046978 closed ranjith_qualiantech_com Wrong setup in the tax rate Entregas a Canarias,Ceuta y Melilla (%N=>0%) 
Attached Filesdiff 13457-dataOrderTaxes.diff (1,120) 2019-12-09 11:28
https://issues.openbravo.com/file_download.php?file_id=13634&type=bug
png 13457 - tax rates.png (131,744) 2019-12-09 11:30
https://issues.openbravo.com/file_download.php?file_id=13635&type=bug
png

png 13457 - 3 taxes appearing return.png (127,195) 2019-12-09 11:30
https://issues.openbravo.com/file_download.php?file_id=13636&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2019-12-09 11:28santi_lozanoNew Issue
2019-12-09 11:28santi_lozanoAssigned To => Retail
2019-12-09 11:28santi_lozanoFile Added: 13457-dataOrderTaxes.diff
2019-12-09 11:28santi_lozanoOBNetwork customer => OBPS
2019-12-09 11:28santi_lozanoSupport ticket => 13457
2019-12-09 11:28santi_lozanoResolution time => 1577660400
2019-12-09 11:28santi_lozanoTriggers an Emergency Pack => No
2019-12-09 11:30santi_lozanoFile Added: 13457 - tax rates.png
2019-12-09 11:30santi_lozanoFile Added: 13457 - 3 taxes appearing return.png
2019-12-09 12:17PracticsIssue Monitored: Practics
2019-12-09 12:18juanjoalmendroIssue Monitored: juanjoalmendro
2019-12-12 13:06prakashmurugesan88Assigned ToRetail => prakashmurugesan88
2019-12-16 11:38hgbotCheckin
2019-12-16 11:38hgbotNote Added: 0116335
2019-12-16 11:39hgbotCheckin
2019-12-16 11:39hgbotNote Added: 0116336
2019-12-16 11:39hgbotStatusnew => resolved
2019-12-16 11:39hgbotResolutionopen => fixed
2019-12-16 11:39hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/65b34fe141484bb2bad4fc8f789737fb467c88a7 [^]
2019-12-16 11:39hgbotCheckin
2019-12-16 11:39hgbotNote Added: 0116337
2019-12-20 09:06marvintmReview Assigned To => marvintm
2019-12-20 09:06marvintmStatusresolved => closed
2019-12-20 09:06marvintmFixed in Version => RR20Q1
2021-06-08 10:23ranjith_qualiantech_comRelationship addedrelated to 0046978

Notes
(0116335)
hgbot   
2019-12-16 11:38   
Repository: erp/pmods/org.openbravo.retail.sampledata
Changeset: 1e7dca2e1deb70e1bf18249ddd00dbf03c5a13fc
Author: Prakash M <prakash <at> qualiantech.com>
Date: Mon Dec 16 12:33:16 2019 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.sampledata/rev/1e7dca2e1deb70e1bf18249ddd00dbf03c5a13fc [^]

Related to issue 42486 : Fixed tax rate configuration issue

* Unable to add product for stephane cluster

---
M referencedata/sampledata/The_White_Valley_Group/C_TAX_ZONE.xml
---
(0116336)
hgbot   
2019-12-16 11:39   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 65b34fe141484bb2bad4fc8f789737fb467c88a7
Author: Prakash M <prakash <at> qualiantech.com>
Date: Mon Dec 16 12:33:10 2019 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/65b34fe141484bb2bad4fc8f789737fb467c88a7 [^]

Fixed issue 42486 : Exempt Verified Returns not getting correct product tax rate

---
M web/org.openbravo.retail.posterminal/js/data/dataordertaxes.js
---
(0116337)
hgbot   
2019-12-16 11:39   
Repository: tools/automation/pi-mobile
Changeset: 449661e8fae148d2ae9cba8ba53490468ff508c8
Author: Prakash M <prakash <at> qualiantech.com>
Date: Mon Dec 16 11:21:02 2019 +0530
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/449661e8fae148d2ae9cba8ba53490468ff508c8 [^]

Related to issue 42486 : changed tax name verification

---
M src-test/org/openbravo/test/mobile/retail/extmodules/selenium/tests/taxexempt/TaxExemptBP.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/multipricelists/I32217_MPLDiscountOnlyForOneCustomerAndDifferentTaxes.java
---