Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0011558Openbravo ERP09. Financial managementpublic2009-11-30 17:432010-01-21 00:00
networkb 
vinothbabu 
urgentminoralways
closedfixed 
5
2.50MP8 
2.50MP112.50MP11 
Core
No
0011558: Funds transfer does not show cash created in * organization
If a Cash was created in * organization, it will not be shown in Funds Transfer window.
Go to Financial Management > Receivables and Payables > Setup > Cashbook.
Create a new record, as * as Organization. Enter a name and save it.
go to Financial Management > Receivables and Payables > Transactions > Funds Transfer. Click on Cash combo. It does not appear the new cash.
No tags attached.
Issue History
2009-11-30 17:43networkbNew Issue
2009-11-30 17:43networkbAssigned To => rafaroda
2009-12-07 20:07psarobeNote Added: 0022505
2009-12-07 20:07psarobePriorityimmediate => urgent
2009-12-07 20:07psarobeStatusnew => scheduled
2009-12-11 11:53rafarodaAssigned Torafaroda => dalsasua
2009-12-17 08:48balamuruganAssigned Todalsasua => balamurugan
2009-12-18 09:02balamuruganNote Added: 0022929
2009-12-18 09:04balamuruganAssigned Tobalamurugan => dalsasua
2009-12-19 17:22balamuruganNote Edited: 0022929
2009-12-31 14:30balamuruganAssigned Todalsasua => balamurugan
2009-12-31 14:40hgbotCheckin
2009-12-31 14:40hgbotNote Added: 0023180
2009-12-31 14:40hgbotStatusscheduled => resolved
2009-12-31 14:40hgbotResolutionopen => fixed
2009-12-31 14:40hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cb8dd33cde603c19e7f48d6db9871e2911c08bf2 [^]
2010-01-05 09:17sureshbabuNote Added: 0023213
2010-01-05 09:17sureshbabuStatusresolved => new
2010-01-05 09:17sureshbabuResolutionfixed => open
2010-01-13 11:13rafarodaStatusnew => scheduled
2010-01-13 11:13rafarodafix_in_branch => pi
2010-01-19 01:41hudsonbotCheckin
2010-01-19 01:41hudsonbotNote Added: 0023526
2010-01-19 13:57vinothbabuAssigned Tobalamurugan => vinothbabu
2010-01-19 14:00hgbotCheckin
2010-01-19 14:00hgbotNote Added: 0023566
2010-01-19 14:00hgbotStatusscheduled => resolved
2010-01-19 14:00hgbotResolutionopen => fixed
2010-01-19 14:00hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/cb8dd33cde603c19e7f48d6db9871e2911c08bf2 [^] => http://code.openbravo.com/erp/devel/pi/rev/46aebc07641fc7844e4e6522ebe47d378b75ce72 [^]
2010-01-20 07:07arunkumarNote Added: 0023593
2010-01-20 07:07arunkumarStatusresolved => closed
2010-01-20 07:07arunkumarFixed in Version => 2.50MP11
2010-01-20 23:26hudsonbotCheckin
2010-01-20 23:26hudsonbotNote Added: 0023675
2010-01-21 00:00anonymoussf_bug_id0 => 2935923

Notes
(0022505)
psarobe   
2009-12-07 20:07   
The same happens with Banks
(0022929)
balamurugan   
2009-12-18 09:02   
(edited on: 2009-12-19 17:22)
Since the Organization Dropdown in Funds Transfer process window is populated with the organizations Main, A, B, etc. not "*" , both Cash and Bank dropdown boxes don't show their entries created in "*". Please clarify this existing functionality is correct or not.

Since the subquery filters the organizations based on isTransactionsAllowed='Y'
column of the table ad_orgtype, The "*" org is not populated. (isTransactionsAllowed='N' for "*" org).

Please see the below query,
SELECT td0.AD_Org_ID AS ID,
    (COALESCE(TO_CHAR(TO_CHAR(td0.Name)),'')) AS NAME,
    '' AS DESCRIPTION
FROM AD_Org td0
WHERE td0.AD_Client_ID IN ('0','1000000')
    AND td0.AD_Org_ID IN ('0','1000000','1000002','1000003','1000004','1000005','1000006','1000007','1000008','1000009')
    AND EXISTS (SELECT 1 FROM ad_orgtype WHERE ad_orgtype.ad_orgtype_id=td0.ad_orgtype_id AND IsTransactionsAllowed='Y')
    and IsReady='Y'
    AND (td0.isActive = 'Y' OR td0.AD_Org_ID = ('0') )
    ORDER BY 2

(0023180)
hgbot   
2009-12-31 14:40   
Repository: erp/devel/pi
Changeset: cb8dd33cde603c19e7f48d6db9871e2911c08bf2
Author: Balamurugan Ramadoss <balamurugan.ramadoss <at> openbravo.com>
Date: Thu Dec 31 19:08:55 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/cb8dd33cde603c19e7f48d6db9871e2911c08bf2 [^]

Fixes Bug 11558: Funds transfer does not show cash created in * organization

---
M src/org/openbravo/erpCommon/ad_process/CashBankOperations_data.xsql
---
(0023213)
sureshbabu   
2010-01-05 09:17   
Hi Bala,


As per our discussion, i think the below query at line 1.10 not providing the expected result.

Right now, current system expecting the user to create at least one Cash Book/Bank in the child organization, then only it allows to inherits its parent Cashbook/Bank in Funds transfer window





     1.4 SELECT P.AD_ORG_ID AS PADRE, C.C_BANKACCOUNT_ID AS ID, C.DISPLAYEDACCOUNT AS NAME
     1.5 FROM AD_ORG O, AD_ORG P, C_BANKACCOUNT C
     1.6 WHERE O.AD_ORG_ID = C.AD_ORG_ID
     1.7 - AND AD_ISORGINCLUDED(C.AD_ORG_ID,P.AD_ORG_ID,O.AD_CLIENT_ID) <> -1
     1.8 - AND (P.AD_CLIENT_ID = O.AD_CLIENT_ID OR P.AD_ORG_ID = '0')
     1.9 + AND AD_ISORGINCLUDED(P.AD_ORG_ID,C.AD_ORG_ID,P.AD_CLIENT_ID) <> -1
    1.10 + AND P.AD_ORG_ID IN (SELECT AD_ORG_ID FROM C_BANKACCOUNT)
    1.11 AND O.AD_ORG_ID IN ('1')
    1.12 - AND O.AD_CLIENT_ID IN ('2')
    1.13 + AND P.AD_CLIENT_ID IN ('2')
    1.14 ORDER BY PADRE, NAME
    1.15 ]]>
(0023526)
hudsonbot   
2010-01-19 01:41   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/cb8dd33cde60 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/7f3a35240cf9 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15846.obx [^]
(0023566)
hgbot   
2010-01-19 14:00   
Repository: erp/devel/pi
Changeset: 46aebc07641fc7844e4e6522ebe47d378b75ce72
Author: Vinoth Babu <vinoth.babu <at> openbravo.com>
Date: Tue Jan 19 17:33:20 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/46aebc07641fc7844e4e6522ebe47d378b75ce72 [^]

Fixes bug 11558 Does not show cash created in * organization

---
M src/org/openbravo/erpCommon/ad_process/CashBankOperations_data.xsql
---
(0023593)
arunkumar   
2010-01-20 07:07   
Now the cashbook created with * organization has been shown in Receivables and Payables > Transactions > Funds Transfer -> Cash combo box.

Tested & Working fine.
(0023675)
hudsonbot   
2010-01-20 23:26   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/46aebc07641f [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/fa6621f85351 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15942.obx [^]