Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011558Openbravo ERP09. Financial managementpublic2009-11-30 17:432010-01-21 00:00
Reporternetworkb 
Assigned Tovinothbabu 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP8 
Target Version2.50MP11Fixed in Version2.50MP11 
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
Summary0011558: Funds transfer does not show cash created in * organization
DescriptionIf a Cash was created in * organization, it will not be shown in Funds Transfer window.
Steps To ReproduceGo 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-11-30 17:43networkbNew Issue
2009-11-30 17:43networkbAssigned To => rafaroda
2009-11-30 17:43networkbOBNetwork customer => Yes
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 [^]