Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006654Openbravo ERP09. Financial managementpublic2008-12-18 16:182009-03-03 17:16
Reportershuehner 
Assigned Toshuehner 
PriorityhighSeveritymajorReproducibilityhave 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
Summary0006654: Payment Tracker; Filter fiels Amount From & Amount to do not work on postgresql 8.3
DescriptionThis filter fields to not work on pgsql 8.3 because of missing to_number calls
Steps To Reproducego to: Financial Management || Receivables & Payables || Analysis Tools || Payment Tracker || Payment Tracker
Use the Amount From & Amount To filters on postgresql 8.3
See error
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0006653 closed shuehner Payment Tracker; Filter fiels Amount From & Amount to do not work on postgresql 8.3 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-18 16:18rafarodaNew Issue
2008-12-18 16:18rafarodaAssigned To => shuehner
2008-12-18 16:18rafarodaStatusnew => scheduled
2008-12-18 16:39svnbotCheckin
2008-12-18 16:39svnbotNote Added: 0011530
2008-12-18 16:39svnbotStatusscheduled => resolved
2008-12-18 16:39svnbotResolutionopen => fixed
2008-12-18 16:39svnbotsvn_revision => 11377
2009-03-03 17:16psarobeStatusresolved => closed

Notes
(0011530)
svnbot   
2008-12-18 16:39   
Repository: openbravo
Revision: 11377
Author: huehner
Date: 2008-12-18 16:39:35 +0100 (Thu, 18 Dec 2008)

Fixed 6654
Add missing to_number to fix Amount filter on postgresql 8.3

---
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportDebtPaymentTrack_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=11377&sc=1 [^]