Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008386Openbravo ERP07. Sales managementpublic2009-04-01 18:012009-04-25 00:00
Reporternetworkb 
Assigned Torajagopal 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Version2.40MP3 
Target Version2.40MP3Fixed in Version2.50MP1 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0008386: Process "generate commission" does not filter inactives commision lines
DescriptionWhen you generate commission it includes inactive commission lines.
Steps To Reproducein Sales Management || Transactions || Sales Invoice || Header
. create invoice I: select partner A, date D and sales representative B
. create line invoice with any product and any qty
. process invoice

in Sales Management || Setup || Commission || Header
. create commission with sales representative B and Frequency Type monthly
. create line inactive with only selected partner A
. in header, press "generate commission" with date D

in Sales Management || Transactions || Commission Payment || Header
. a commission payment has been generated even if the commission line was inactive
Proposed SolutionReview C_Commission_Process procedure in order that the SQL does not include inactive commission lines.
Additional Information
Tagsmain
Relationships
depends on backport 00084362.40MP3 closed rajagopal Process "generate commission" does not filter inactives commision lines 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-04-01 18:01networkbNew Issue
2009-04-01 18:01networkbAssigned To => rafaroda
2009-04-01 18:01networkbOBNetwork customer => Yes
2009-04-01 18:01networkbRegression testing => No
2009-04-03 17:23networkbProposed Solution updated
2009-04-03 17:24networkbversion => 2.40MP3
2009-04-03 17:32rafarodaAssigned Torafaroda => sathiyan
2009-04-03 17:32rafarodaDescription Updated
2009-04-03 17:32rafarodaProposed Solution updated
2009-04-03 17:32rafarodaSteps to Reproduce Updated
2009-04-03 17:32rafarodaStatusnew => scheduled
2009-04-03 17:32rafarodafix_in_branch => pi
2009-04-06 10:26rajagopalAssigned Tosathiyan => rajagopal
2009-04-07 13:14rafarodafix_in_branchpi =>
2009-04-07 13:14rafarodaSummaryprocess "generate commission" does not filter to inactives's lines => Process "generate commission" does not filter inactives commision lines
2009-04-07 13:14rafarodaDescription Updated
2009-04-08 09:19hgbotCheckin
2009-04-08 09:19hgbotNote Added: 0015268
2009-04-08 09:19hgbotStatusscheduled => resolved
2009-04-08 09:19hgbotResolutionopen => fixed
2009-04-08 09:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1981bfff8d14bda776d05e13cd1cc966dc210143 [^]
2009-04-22 11:23psarobeTag Attached: main
2009-04-24 11:06sureshbabuStatusresolved => closed
2009-04-24 11:06sureshbabuNote Added: 0015677
2009-04-24 11:06sureshbabuFixed in Version => main
2009-04-25 00:00anonymoussf_bug_id0 => 2780815

Notes
(0015268)
hgbot   
2009-04-08 09:19   
Repository: erp/devel/pi
Changeset: 1981bfff8d14bda776d05e13cd1cc966dc210143
Author: Rajagopal Baskaran <rajagopal.baskaran <at> openbravo.com>
Date: Wed Apr 08 12:45:20 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/1981bfff8d14bda776d05e13cd1cc966dc210143 [^]

Fixes bug 8386: Process \"generate commission\" does not filter inactive commission lines has been fixed.

---
M src-db/database/model/functions/C_COMMISSION_PROCESS.xml
---
(0015677)
sureshbabu   
2009-04-24 11:06   
Tested inactive lines are not included for commission calculation.



But a commission payment document is created with Zero amount which needs to get clarified with Pablo.