Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006660Openbravo ERP09. Financial managementpublic2008-12-18 18:132008-12-31 13:49
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006660: General Ledger Report, Filter field: From Amount does not work on postgresql 8.3
Description.. because of missing to_number call
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0006661 closed shuehner General Ledger Report, Filter field: From Amount does not work on postgresql 8.3 
related to defect 00056742.50 closed shuehner Audit for missing to_number in XSQL for Postgresql from v8.3 and excessive to_number in ID fields 
related to defect 0006714 closed Hennadzi General Ledger Report, Filter field: From Amount does not work on postgresql 8.3 (again) 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-18 18:13shuehnerNew Issue
2008-12-18 18:13shuehnerAssigned To => shuehner
2008-12-18 18:13shuehnersf_bug_id0 => 2445725
2008-12-18 18:13shuehnerRegression testing => No
2008-12-18 18:14shuehnerStatusnew => scheduled
2008-12-18 18:14shuehnerfix_in_branch => trunk
2008-12-18 18:14svnbotCheckin
2008-12-18 18:14svnbotNote Added: 0011552
2008-12-18 18:14svnbotStatusscheduled => resolved
2008-12-18 18:14svnbotResolutionopen => fixed
2008-12-18 18:14svnbotsvn_revision => 11393
2008-12-18 18:24shuehnerNote Added: 0011555
2008-12-19 16:34shuehnerRelationship addedrelated to 0005674
2008-12-22 14:36shuehnerRelationship addedrelated to 0006714
2008-12-31 13:49lakshmiStatusresolved => closed
2008-12-31 13:49lakshmiNote Added: 0011794

Notes
(0011552)
svnbot   
2008-12-18 18:14   
Repository: openbravo
Revision: 11393
Author: huehner
Date: 2008-12-18 18:14:37 +0100 (Thu, 18 Dec 2008)

Fixed 6660
add missing to_number calls to fix filter on postgresql 8.3

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

https://dev.openbravo.com/websvn/openbravo/?rev=11393&sc=1 [^]
(0011555)
shuehner   
2008-12-18 18:24   
Missing steps to reproduce here:
Go to: Financial Management || Accounting || Analysis Tools || General Ledger Report || General Ledger Report
Use the filter field from amount on postgresql 8.3

There are 4 combinations to changed here:
1. Hide matched Debt/Payments: not marked
   From Account/To Account (some value selected)
2. Hide matched Debt/Payments: is marked
   From Account/To Account (some value selected)
3. Hide matched Debt/Payments: not marked
   From Account/To Account (both combos empty line marked)
4. Hide matched Debt/Payments: is marked
   From Account/To Account (both combos empty line marked)
(0011794)
lakshmi   
2008-12-31 13:49   
Verified the issue and it works in (Windows/Postgres)Openbravo 2.50 (r11619). So i closed this issue