Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020835Openbravo ERP07. Sales managementpublic2012-06-22 10:232012-06-29 11:00
Reportermaite 
Assigned Tojonalegriaesarte 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP13Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020835: Problem when generating commission for business partner with more than one associated user
DescriptionProblem when generating commission for business partner with more than one associated user
Steps To ReproduceError obtained is "more than one row returned by a subquery used as an expression"
Proposed SolutionLine 262 in C_COMMISSION_PROCESS.xml function is
v_Cmd:=v_Cmd || ' AND h.SalesRep_ID = (SELECT AD_User_ID FROM AD_User WHERE C_BPartner_ID=''' || v_SalesRep_ID || ''')';

It should be replaced by:
v_Cmd:=v_Cmd || ' AND h.SalesRep_ID IN (SELECT AD_User_ID FROM AD_User WHERE C_BPartner_ID=''' || v_SalesRep_ID || ''' AND IsActive='Y')';
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-06-22 10:23maiteNew Issue
2012-06-22 10:23maiteAssigned To => mirurita
2012-06-22 10:23maiteModules => Core
2012-06-22 10:24maiteTarget Version => 3.0MP13
2012-06-22 10:24maiteIssue Monitored: networkb
2012-06-22 10:39miruritaAssigned Tomirurita => jonalegriaesarte
2012-06-25 13:21jonalegriaesarteAssigned Tojonalegriaesarte => caristu
2012-06-25 13:22jonalegriaesarteAssigned Tocaristu => jonalegriaesarte
2012-06-26 12:09hgbotCheckin
2012-06-26 12:09hgbotNote Added: 0050084
2012-06-26 12:09hgbotStatusnew => resolved
2012-06-26 12:09hgbotResolutionopen => fixed
2012-06-26 12:09hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5f9870e3e4e3cb43c81c9158c721ddbf4916d9f0 [^]
2012-06-26 12:10jonalegriaesarteNote Added: 0050085
2012-06-27 05:29hudsonbotCheckin
2012-06-27 05:29hudsonbotNote Added: 0050172
2012-06-29 11:00xabiermerinoNote Added: 0050274
2012-06-29 11:00xabiermerinoStatusresolved => closed

Notes
(0050084)
hgbot   
2012-06-26 12:09   
Repository: erp/devel/pi
Changeset: 5f9870e3e4e3cb43c81c9158c721ddbf4916d9f0
Author: Jon Alegría <jon.alegria <at> openbravo.com>
Date: Tue Jun 26 12:08:45 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5f9870e3e4e3cb43c81c9158c721ddbf4916d9f0 [^]

Fixes issue 0020835: Problem when generating commission for business partner
with more than one associated user
Added an IN clause instead of the equal and added the isactive filter

---
M src-db/database/model/functions/C_COMMISSION_PROCESS.xml
---
(0050085)
jonalegriaesarte   
2012-06-26 12:10   
It is not considered as a risky change
(0050172)
hudsonbot   
2012-06-27 05:29   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/cf3a7135839f [^]

Maturity status: Test
(0050274)
xabiermerino   
2012-06-29 11:00   
verified