Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0030192Openbravo ERP07. Sales managementpublic2015-06-15 16:072015-06-22 11:30
ngarcia 
aferraz 
immediatemajoralways
closedfixed 
5
 
3.0PR15Q2.3 
vmromanos
Core
Production - QA Approved
2015-02-18
3.0PR15Q2
https://code.openbravo.com/erp/devel/pi/rev/a1c3c8123501 [^]
No
0030192: Wrong commission amount if the invoice has fractionated payment terms but it is paid in the same commission period
Wrong commission amount if the invoice has fractionated payment terms but it is paid in the same commission period
As 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
Approved
blocks defect 0030184 closed aferraz Wrong commission amount if the invoice has fractionated payment terms but it is paid in the same commission period 
Issue History
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