Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0006714Openbravo ERP09. Financial managementpublic2008-12-22 13:402008-12-31 15:39
shuehner 
Hennadzi 
normalmajorhave not tried
closedfixed 
5
pi 
 
Core
No
0006714: General Ledger Report, Filter field: From Amount does not work on postgresql 8.3 (again)
The fix for issue 6493 in revision r11423 did break the filter field "From Amount" again on postgresql 8.3 when the two new xsql-functions which are introduced in this commit are used (selectTree, selectTreeHiding) because these two methods are missing the TO_NUMBER call for the paramAmtFrom parameter.

The original report was fixed in issue 6660 r11393.
Use the General Ledger Report on pgsql 8.3
Use the Amount From filter
use the other parameters to execute a codepath where the methods selectTree and selectTreeHiding are executed
Add the missing TO_NUMBER calls and text the two affected codepaths.
comsup_sprint3, multi-org
related to defect 0006660 closed shuehner General Ledger Report, Filter field: From Amount does not work on postgresql 8.3 
related to defect 0006493 closed dalsasua General ledger report does not work in 2.40mp1 
depends on backport 0006745 closed Hennadzi General Ledger Report, Filter field: From Amount does not work on postgresql 8.3 (again) 
Issue History
2008-12-22 13:40shuehnerNew Issue
2008-12-22 13:40shuehnerAssigned To => rafaroda
2008-12-22 13:40shuehnersf_bug_id0 => 2458464
2008-12-22 13:40shuehnerRegression testing => No
2008-12-22 13:41shuehnerNote Added: 0011653
2008-12-22 14:36shuehnerRelationship addedrelated to 0006660
2008-12-22 14:36shuehnerRelationship addedrelated to 0006493
2008-12-22 14:42shuehnerAssigned Torafaroda => dalsasua
2008-12-28 11:41rafarodaStatusnew => scheduled
2008-12-28 11:41rafarodaAssigned Todalsasua => Hennadzi
2008-12-28 11:41rafarodafix_in_branch => trunk
2008-12-30 14:03svnbotCheckin
2008-12-30 14:03svnbotNote Added: 0011768
2008-12-30 14:03svnbotStatusscheduled => resolved
2008-12-30 14:03svnbotResolutionopen => fixed
2008-12-30 14:03svnbotsvn_revision => 11612
2008-12-30 14:04HennadziTag Attached: comsup_sprint3
2008-12-30 14:04HennadziTag Attached: multi-org
2008-12-31 15:39lakshmiStatusresolved => closed
2008-12-31 15:39lakshmiNote Added: 0011807

Notes
(0011653)
shuehner   
2008-12-22 13:41   
This should be backported to r2.40 as 6660 did fix the problem on r2.40 and this issue opens up the problem again.
(0011768)
svnbot   
2008-12-30 14:03   
Repository: openbravo
Revision: 11612
Author: hennadzi
Date: 2008-12-30 14:03:30 +0100 (Tue, 30 Dec 2008)

Fixed bug 0006714: General Ledger Report, Filter field: From Amount does not work on postgresql 8.3 (again)

---
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=11612&sc=1 [^]
(0011807)
lakshmi   
2008-12-31 15:39   
Verified the issue and it works in Openbravo 2.50 (r11619). So i closed this issue