Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0006653Openbravo ERP09. Financial managementpublic2008-12-18 16:132008-12-31 13:27
shuehner 
shuehner 
highmajorhave not tried
closedfixed 
5
pi 
 
Core
No
0006653: Payment Tracker; Filter fiels Amount From & Amount to do not work on postgresql 8.3
This filter fields to not work on pgsql 8.3 because of missing to_number calls
go to: Financial Management || Receivables & Payables || Analysis Tools || Payment Tracker || Payment Tracker
Use the Amount From & Amount To filters on postgresql 8.3
See error
No tags attached.
depends on backport 0006654 closed shuehner Payment Tracker; Filter fiels Amount From & Amount to do 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 
Issue History
2008-12-18 16:13shuehnerNew Issue
2008-12-18 16:13shuehnerAssigned To => rafaroda
2008-12-18 16:13shuehnersf_bug_id0 => 2445478
2008-12-18 16:13shuehnerRegression testing => No
2008-12-18 16:17rafarodaPrioritynormal => high
2008-12-18 16:17rafarodaSeverityminor => major
2008-12-18 16:18rafarodaStatusnew => scheduled
2008-12-18 16:18rafarodaAssigned Torafaroda => shuehner
2008-12-18 16:18rafarodafix_in_branch => trunk
2008-12-18 16:20svnbotCheckin
2008-12-18 16:20svnbotNote Added: 0011527
2008-12-18 16:20svnbotStatusscheduled => resolved
2008-12-18 16:20svnbotResolutionopen => fixed
2008-12-18 16:20svnbotsvn_revision => 11375
2008-12-19 16:33shuehnerRelationship addedrelated to 0005674
2008-12-31 13:27lakshmiStatusresolved => closed
2008-12-31 13:27lakshmiNote Added: 0011791

Notes
(0011527)
svnbot   
2008-12-18 16:20   
Repository: openbravo
Revision: 11375
Author: huehner
Date: 2008-12-18 16:20:29 +0100 (Thu, 18 Dec 2008)

Fixed 6653
Add missing to_number to fix Amount filter fields on postgresql 8.3

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

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