Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006656Openbravo ERP09. Financial managementpublic2008-12-18 17:162008-12-31 13:35
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
Summary0006656: Payment Report: Filter fiels Amount From & Amount to do not work on postgresql 8.3
DescriptionIn this report the filter fields: From Amount and To Amount to not work on postgresql 8.3
Steps To ReproduceGo to: Financial Management || Receivables & Payables || Analysis Tools || Payment Report || Payment Report
Use the filter fields: From Amount / to amount on pgsql 8.3
see error
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0006657 closed shuehner Payment Report: 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 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-18 17:16shuehnerNew Issue
2008-12-18 17:16shuehnerAssigned To => rafaroda
2008-12-18 17:16shuehnersf_bug_id0 => 2445619
2008-12-18 17:16shuehnerRegression testing => No
2008-12-18 17:17rafarodaPrioritynormal => high
2008-12-18 17:18rafarodaStatusnew => scheduled
2008-12-18 17:18rafarodaAssigned Torafaroda => shuehner
2008-12-18 17:18rafarodafix_in_branch => trunk
2008-12-18 17:29svnbotCheckin
2008-12-18 17:29svnbotNote Added: 0011535
2008-12-18 17:29svnbotStatusscheduled => resolved
2008-12-18 17:29svnbotResolutionopen => fixed
2008-12-18 17:29svnbotsvn_revision => 11383
2008-12-18 17:41shuehnerStatusresolved => new
2008-12-18 17:41shuehnerResolutionfixed => open
2008-12-18 17:41shuehnerNote Added: 0011538
2008-12-18 17:42svnbotCheckin
2008-12-18 17:42svnbotNote Added: 0011540
2008-12-18 17:42svnbotStatusnew => resolved
2008-12-18 17:42svnbotResolutionopen => fixed
2008-12-18 17:42svnbotsvn_revision11383 => 11386
2008-12-19 16:34shuehnerRelationship addedrelated to 0005674
2008-12-31 13:35lakshmiStatusresolved => closed
2008-12-31 13:35lakshmiNote Added: 0011792

Notes
(0011535)
svnbot   
2008-12-18 17:29   
Repository: openbravo
Revision: 11383
Author: huehner
Date: 2008-12-18 17:29:38 +0100 (Thu, 18 Dec 2008)

Fixed 6656
add missing to_number to amount filter fields to fix them on postgresql 8.3

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

https://dev.openbravo.com/websvn/openbravo/?rev=11383&sc=1 [^]
(0011538)
shuehner   
2008-12-18 17:41   
When the checkbox "Group By Business Partner" is not marked (it is by default) a different codepath is used which also has this error.
(0011540)
svnbot   
2008-12-18 17:42   
Repository: openbravo
Revision: 11386
Author: huehner
Date: 2008-12-18 17:42:25 +0100 (Thu, 18 Dec 2008)

Fixed 6656
Fix second instance of this issue in the report.

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

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