Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0015727Openbravo ERP09. Financial managementpublic2011-01-21 11:002011-05-24 10:56
adrianromero 
dalsasua 
urgentmajoralways
closedfixed 
5
3.0RC3 
 
Core
No
0015727: Error in Bank Account combo in Funds Transfer process
Error in Bank Account combo in Funds Transfer process. Combo is not filtering by client so you are able to select bank account of another client and run process successfully.
1. Create and configure another Client
2. Define Bank and Bank Account at * organization level for Client1
3. Define Bank and Bank Account at * organization level for Client2
4. Go to Financial Management || Receivables & Payables || Transactions || Funds Transfer || Funds Transfer : and realize that you are able to see bank accounts of both clients
Problem is that combo's select (called selectBankDouble in file CashBankOperations_data.xsql) is not filtering by
C_BANKACCOUNT.ad_client_id
closingMay2011
blocks backport 00155602.50MP26 closed dalsasua Error in Bank Account combo in Funds Transfer process 
Issue History
2011-01-21 11:00adrianromeroNew Issue
2011-01-21 11:00adrianromeroAssigned To => dalsasua
2011-01-21 11:00adrianromeroModules => Core
2011-01-21 11:00adrianromeroIssue generated from0015560
2011-01-21 11:00adrianromeroRelationship addedblocks 0015560
2011-01-21 11:00adrianromeroStatusnew => scheduled
2011-01-21 11:00adrianromerofix_in_branch => pi
2011-01-21 12:10hgbotCheckin
2011-01-21 12:10hgbotNote Added: 0033805
2011-01-21 12:10hgbotStatusscheduled => resolved
2011-01-21 12:10hgbotResolutionopen => fixed
2011-01-21 12:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3df926d8f22a70f932caa138551ef2eacfb66662 [^]
2011-01-24 17:16adrianromeroNote Added: 0033836
2011-05-24 10:08dalsasuaTag Attached: closingMay2011
2011-05-24 10:56dalsasuaStatusresolved => closed

Notes
(0033805)
hgbot   
2011-01-21 12:10   
Repository: erp/devel/pi
Changeset: 3df926d8f22a70f932caa138551ef2eacfb66662
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Fri Jan 21 12:08:35 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/3df926d8f22a70f932caa138551ef2eacfb66662 [^]

Fixes issue 0015727: Error in Bank Account combo in Funds Transfer process
It has been fixed the two SQL sentences with the problem of not properly filtering by client: selectBankDouble and selectCashDouble

---
M src/org/openbravo/erpCommon/ad_process/CashBankOperations_data.xsql
---
(0033836)
adrianromero   
2011-01-24 17:16   
* Testing the issue

Follow the steps to test and notice that now only bank accounts of the running client are visible.

* Other areas affected

No other areas affected. It has only been modified the SQL sentences executed in the Funds Transfer process callouts.