Openbravo Issue Tracking System - Retail Modules
View Issue Details
0038678Retail ModulesWeb POSpublic2018-06-01 11:012018-06-22 13:55
gorkaion 
ranjith_qualiantech_com 
urgentmajoralways
closedfixed 
5
 
RR18Q3 
guilleaer
No
0038678: Wrong Tax Calculation with group taxes where base is Line Net Amount + Tax Amount
In an environment using a Price List that DO NOT include taxes.

Having a Tax Category with 2 rates where the second's tax base amount includes the tax amount of the 1st one. For example the Mexican IEPS + IVA that is configured in livebuilds in the published MPs machines. In this tax the IVA taxable amount is the net amount plus the IEPS tax amount.

When adding 2 lines to a ticket using products with that TAX the calculated Taxable amount for the IVA is wrong. Note that when there is only one line the amounts are correct.

Once the ticket is closed and synchronized the tax amounts by line are correct. But total receipt taxes are not correct.
On livebuilds for PR18Q1.3

Go to Product window and add a price using price list version "The White Valley Group Sale Price list (Opening Store)" to products:
PD4 Product Dependant 4 (for example 200)
PD5 Product Dependant 5 (for example 175)

Go to Assortment window and add those products to "Posets Products List (Opening Store)"

Open a POS using pos terminal "PS-1" (Possets)

Add PD4 product and check that taxes are correct.
-- IVA Taxable is 306 = 200+106
Add PD5 product and check that taxes are not correct.
-- IVA Taxable is 481 != 375 + 198.75

Pay and close the ticket. Open it in the backend.
- Check that Tax at header are wrong.
- Check taht Taxes at lines (Line Tax tab) are correct.
- Total Gross Amount of the Order is also wrong as it is based on the Header based Taxes.

No tags attached.
diff issue38678.diff (855) 2018-06-05 19:47
https://issues.openbravo.com/file_download.php?file_id=11831&type=bug
Issue History
2018-06-01 11:01gorkaionNew Issue
2018-06-01 11:01gorkaionAssigned To => Retail
2018-06-01 11:01gorkaionResolution time => 1529618400
2018-06-01 11:01gorkaionTriggers an Emergency Pack => No
2018-06-01 12:43jfrancesIssue Monitored: jfrances
2018-06-01 13:02gsuarezIssue Monitored: gsuarez
2018-06-01 13:12juabaezIssue Monitored: juabaez
2018-06-05 19:47marvintmFile Added: issue38678.diff
2018-06-06 08:01ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2018-06-06 08:20ranjith_qualiantech_comStatusnew => scheduled
2018-06-06 12:30hgbotCheckin
2018-06-06 12:30hgbotNote Added: 0104971
2018-06-06 12:30hgbotStatusscheduled => resolved
2018-06-06 12:30hgbotResolutionopen => fixed
2018-06-06 12:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/ea83ef4fde6d33884d23aa61b1b59154dc047fd7 [^]
2018-06-06 12:30hgbotCheckin
2018-06-06 12:30hgbotNote Added: 0104972
2018-06-22 13:55guilleaerReview Assigned To => guilleaer
2018-06-22 13:55guilleaerStatusresolved => closed
2018-06-22 13:55guilleaerFixed in Version => RR18Q3

Notes
(0104971)
hgbot   
2018-06-06 12:30   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: ea83ef4fde6d33884d23aa61b1b59154dc047fd7
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Wed Jun 06 16:00:20 2018 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/ea83ef4fde6d33884d23aa61b1b59154dc047fd7 [^]

Fixed issue 38678 : Modified Tax Calculation in Product excluding Price

* Total tax should be calculated based on each lines net amount

---
M web/org.openbravo.retail.posterminal/js/data/dataordertaxes.js
---
(0104972)
hgbot   
2018-06-06 12:30   
Repository: tools/automation/pi-mobile
Changeset: bc0c4336d22634475a9d28dd89cc820142f834b8
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Wed Jun 06 16:00:31 2018 +0530
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/bc0c4336d22634475a9d28dd89cc820142f834b8 [^]

Verifies issue 38678 : Added automated test 'I38678_VerifyReceiptTax'

---
A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/I38678_VerifyReceiptTax.java
---