Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030192Openbravo ERP07. Sales managementpublic2015-06-15 16:072015-06-22 11:30
Reporterngarcia 
Assigned Toaferraz 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q2.3Fixed in Version 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket36569
Regression levelProduction - QA Approved
Regression date2015-02-18
Regression introduced in release3.0PR15Q2
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/a1c3c8123501 [^]
Triggers an Emergency PackNo
Summary0030192: Wrong commission amount if the invoice has fractionated payment terms but it is paid in the same commission period
DescriptionWrong commission amount if the invoice has fractionated payment terms but it is paid in the same commission period
Steps To ReproduceAs group admin role:
   Create a Commission
      Basis Document: Invoice
      Basis Status: Fully paid documents
      Basis Amount: Net amount
   Add a line to it:
      Based on Sales Rep.: 'Y'
      Business Partner Category: 'Customer - Tier 3'
      Multiplier amount: 0.13
   Create a Payment Term:
      Overdue Payment Days Rule: 60
   Add a line to it
      Percentage Due: 50
      Overdue Payment Days Rule: 30
   Create a Sales Invoice for 'Hoteles Buenas Noches, S.A.'
   Add the previously defined sales representative and payment terms
   Complete it
   Pay it in one payment
   Go to Commission window and click on Generate Commission process
   Go to Commission Payment window and check there is only one line with the Actual Amount different from the invoice's total net amount
Proposed Solution
Additional Information
TagsApproved
Relationships
blocks defect 0030184 closed aferraz Wrong commission amount if the invoice has fractionated payment terms but it is paid in the same commission period 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-06-16 19:42aferrazTypedefect => backport
2015-06-16 19:42aferrazTarget Version => 3.0PR15Q2.2
2015-06-17 09:38dmitry_mezentsevTag Attached: Approved
2015-06-22 10:59vmromanosTarget Version3.0PR15Q2.2 => 3.0PR15Q2.3
2015-06-22 11:29hgbotCheckin
2015-06-22 11:29hgbotNote Added: 0078403
2015-06-22 11:29hgbotStatusscheduled => resolved
2015-06-22 11:29hgbotResolutionopen => fixed
2015-06-22 11:29hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q2.3/rev/a08af337d59520233a97901938e07706a1aa6cf2 [^]
2015-06-22 11:30vmromanosReview Assigned To => vmromanos
2015-06-22 11:30vmromanosNote Added: 0078404
2015-06-22 11:30vmromanosStatusresolved => closed

Notes
(0078403)
hgbot   
2015-06-22 11:29   
Repository: erp/backports/3.0PR15Q2.3
Changeset: a08af337d59520233a97901938e07706a1aa6cf2
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue Jun 16 20:02:44 2015 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR15Q2.3/rev/a08af337d59520233a97901938e07706a1aa6cf2 [^]

Fixes issue 30192: Wrong commission amount

In case of Basis Status = "Fully paid documents", select query should not have distinct clause, as each line will be retrieved as percentage of invoice line amount.

---
M src-db/database/model/functions/C_COMMISSION_PROCESS.xml
---
(0078404)
vmromanos   
2015-06-22 11:30   
Code review + testing OK