Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0020835
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2012-06-22 10:232012-06-29 11:00
ReportermaiteView Statuspublic 
Assigned Tojonalegriaesarte 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision5f9870e3e4e3
ProjectionnoneETAnoneTarget Version3.0MP13
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0020835: 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')';
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0050084)
hgbot (developer)
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 (reporter)
2012-06-26 12:10

 It is not considered as a risky change
(0050172)
hudsonbot (developer)
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 (reporter)
2012-06-29 11:00

 verified

- Issue History
Date Modified Username Field Change
2012-06-22 10:23 maite New Issue
2012-06-22 10:23 maite Assigned To => mirurita
2012-06-22 10:23 maite Modules => Core
2012-06-22 10:24 maite Target Version => 3.0MP13
2012-06-22 10:24 maite Issue Monitored: networkb
2012-06-22 10:39 mirurita Assigned To mirurita => jonalegriaesarte
2012-06-25 13:21 jonalegriaesarte Assigned To jonalegriaesarte => caristu
2012-06-25 13:22 jonalegriaesarte Assigned To caristu => jonalegriaesarte
2012-06-26 12:09 hgbot Checkin
2012-06-26 12:09 hgbot Note Added: 0050084
2012-06-26 12:09 hgbot Status new => resolved
2012-06-26 12:09 hgbot Resolution open => fixed
2012-06-26 12:09 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5f9870e3e4e3cb43c81c9158c721ddbf4916d9f0 [^]
2012-06-26 12:10 jonalegriaesarte Note Added: 0050085
2012-06-27 05:29 hudsonbot Checkin
2012-06-27 05:29 hudsonbot Note Added: 0050172
2012-06-29 11:00 xabiermerino Note Added: 0050274
2012-06-29 11:00 xabiermerino Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker