Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0011558 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | minor | always | 2009-11-30 17:43 | 2010-01-21 00:00 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | vinothbabu | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP11 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 46aebc07641f | |||
| Projection | none | ETA | none | Target Version | 2.50MP11 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50MP8 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0011558: Funds transfer does not show cash created in * organization | |||||||
| Description | If a Cash was created in * organization, it will not be shown in Funds Transfer window. | |||||||
| Steps To Reproduce | 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0022505) psarobe (manager) 2009-12-07 20:07 |
The same happens with Banks |
|
(0022929) balamurugan (reporter) 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 (developer) 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 (reporter) 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 (developer) 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 (developer) 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 (reporter) 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 (developer) 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 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-11-30 17:43 | networkb | New Issue | |
| 2009-11-30 17:43 | networkb | Assigned To | => rafaroda |
| 2009-12-07 20:07 | psarobe | Note Added: 0022505 | |
| 2009-12-07 20:07 | psarobe | Priority | immediate => urgent |
| 2009-12-07 20:07 | psarobe | Status | new => scheduled |
| 2009-12-11 11:53 | rafaroda | Assigned To | rafaroda => dalsasua |
| 2009-12-17 08:48 | balamurugan | Assigned To | dalsasua => balamurugan |
| 2009-12-18 09:02 | balamurugan | Note Added: 0022929 | |
| 2009-12-18 09:04 | balamurugan | Assigned To | balamurugan => dalsasua |
| 2009-12-19 17:22 | balamurugan | Note Edited: 0022929 | |
| 2009-12-31 14:30 | balamurugan | Assigned To | dalsasua => balamurugan |
| 2009-12-31 14:40 | hgbot | Checkin | |
| 2009-12-31 14:40 | hgbot | Note Added: 0023180 | |
| 2009-12-31 14:40 | hgbot | Status | scheduled => resolved |
| 2009-12-31 14:40 | hgbot | Resolution | open => fixed |
| 2009-12-31 14:40 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/cb8dd33cde603c19e7f48d6db9871e2911c08bf2 [^] |
| 2010-01-05 09:17 | sureshbabu | Note Added: 0023213 | |
| 2010-01-05 09:17 | sureshbabu | Status | resolved => new |
| 2010-01-05 09:17 | sureshbabu | Resolution | fixed => open |
| 2010-01-13 11:13 | rafaroda | Status | new => scheduled |
| 2010-01-13 11:13 | rafaroda | fix_in_branch | => pi |
| 2010-01-19 01:41 | hudsonbot | Checkin | |
| 2010-01-19 01:41 | hudsonbot | Note Added: 0023526 | |
| 2010-01-19 13:57 | vinothbabu | Assigned To | balamurugan => vinothbabu |
| 2010-01-19 14:00 | hgbot | Checkin | |
| 2010-01-19 14:00 | hgbot | Note Added: 0023566 | |
| 2010-01-19 14:00 | hgbot | Status | scheduled => resolved |
| 2010-01-19 14:00 | hgbot | Resolution | open => fixed |
| 2010-01-19 14:00 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/cb8dd33cde603c19e7f48d6db9871e2911c08bf2 [^] => http://code.openbravo.com/erp/devel/pi/rev/46aebc07641fc7844e4e6522ebe47d378b75ce72 [^] |
| 2010-01-20 07:07 | arunkumar | Note Added: 0023593 | |
| 2010-01-20 07:07 | arunkumar | Status | resolved => closed |
| 2010-01-20 07:07 | arunkumar | Fixed in Version | => 2.50MP11 |
| 2010-01-20 23:26 | hudsonbot | Checkin | |
| 2010-01-20 23:26 | hudsonbot | Note Added: 0023675 | |
| 2010-01-21 00:00 | anonymous | sf_bug_id | 0 => 2935923 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |