Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021031Openbravo ERP07. Sales managementpublic2012-07-12 09:472012-07-13 14:20
Reporterplujan 
Assigned Tomirurita 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionmain 
Target Version3.0MP13Fixed in Version3.0MP13 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browserMozilla Firefox
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021031: Discounts are not applied properly for Price Including Taxes price lists
DescriptionWhen applying a 10% discount for a product using a Price Including Taxes price list, I get a wrong calculation of the taxes.
Steps To Reproduce1. Enter as F&B Admin user
2. Go to Price List window
3. Edit "Tarifa de Ventas" record by marking it as Including Taxes
4. Go to Sales Order window
5. Create a new document for "Alimentos y Supermercados" business partner
6. Create a new line for "Agua sin gas 1L"
7. Book the order
8. Expected amounts:
      Line 10: 1.29 (price including taxes is 1.53)
      Line 20: -0.13 (10% discount)
      Tax: taxable 1.16, tax (VAT 18%) 0.21
      Total: 1.37 (1.53 minus 10%)
   Current (wrong amounts):
      Line 10: 1.29 (correct)
      Line 20: -0.13 (correct)
      Tax: taxable 1.16 (correct), tax 0.37 (wrong)
      Total: 1.53 (wrong)
      
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0035428 closed aferraz Do not calculate Net Price and Net Amount outside triggers when creating new Order/Invoice with Price Including Taxes 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-07-12 09:47plujanNew Issue
2012-07-12 09:47plujanAssigned To => psarobe
2012-07-12 09:47plujanWeb browser => Mozilla Firefox
2012-07-12 09:47plujanModules => Core
2012-07-12 11:06psarobeWeb browserMozilla Firefox => Mozilla Firefox
2012-07-12 11:06psarobeAssigned Topsarobe => mirurita
2012-07-12 11:06psarobeStatusnew => scheduled
2012-07-12 13:37hgbotCheckin
2012-07-12 13:37hgbotNote Added: 0050530
2012-07-12 13:37hgbotStatusscheduled => resolved
2012-07-12 13:37hgbotResolutionopen => fixed
2012-07-12 13:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5e61ae4a9e68d720898297d8c5355937f3e80a6c [^]
2012-07-13 12:11psarobeNote Added: 0050552
2012-07-13 12:11psarobeStatusresolved => closed
2012-07-13 12:11psarobeFixed in Version => 3.0MP13
2012-07-13 14:20hgbotCheckin
2012-07-13 14:20hgbotNote Added: 0050568
2017-03-06 18:41aferrazRelationship addedrelated to 0035428

Notes
(0050530)
hgbot   
2012-07-12 13:37   
Repository: erp/devel/pi
Changeset: 5e61ae4a9e68d720898297d8c5355937f3e80a6c
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Thu Jul 12 13:35:58 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5e61ae4a9e68d720898297d8c5355937f3e80a6c [^]

Fixes issue 21031: problem with discounts and Price Including Taxes price lists

---
M src-db/database/model/functions/C_INVOICE_POST.xml
M src-db/database/model/functions/C_ORDER_POST1.xml
---
(0050552)
psarobe   
2012-07-13 12:11   
Works fine. Also tested in invoices and works fine
(0050568)
hgbot   
2012-07-13 14:20   
Repository: erp/devel/pi
Changeset: 6ebfbe6577f59537dc57a51d23f6cde02752e839
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Fri Jul 13 14:10:26 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6ebfbe6577f59537dc57a51d23f6cde02752e839 [^]

Related to issue 21031: apply rounding to gross amounts

---
M src-db/database/model/functions/C_INVOICE_POST.xml
---