Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006657Openbravo ERP09. Financial managementpublic2008-12-18 17: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 customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006657: 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
blocks defect 0006656 closed shuehner Payment Report: Filter fiels Amount From & Amount to do not work on postgresql 8.3 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-18 17:18rafarodaNew Issue
2008-12-18 17:18rafarodaAssigned To => shuehner
2008-12-18 17:18rafarodaStatusnew => scheduled
2008-12-18 17:36svnbotCheckin
2008-12-18 17:36svnbotNote Added: 0011536
2008-12-18 17:36svnbotStatusscheduled => resolved
2008-12-18 17:36svnbotResolutionopen => fixed
2008-12-18 17:36svnbotsvn_revision => 11384
2008-12-18 17:41shuehnerStatusresolved => new
2008-12-18 17:41shuehnerResolutionfixed => open
2008-12-18 17:41shuehnerNote Added: 0011539
2008-12-18 17:45svnbotCheckin
2008-12-18 17:45svnbotNote Added: 0011541
2008-12-18 17:45svnbotStatusnew => resolved
2008-12-18 17:45svnbotResolutionopen => fixed
2008-12-18 17:45svnbotsvn_revision11384 => 11387
2009-03-03 17:16psarobeStatusresolved => closed

Notes
(0011536)
svnbot   
2008-12-18 17:36   
Repository: openbravo
Revision: 11384
Author: huehner
Date: 2008-12-18 17:36:24 +0100 (Thu, 18 Dec 2008)

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

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

https://dev.openbravo.com/websvn/openbravo/?rev=11384&sc=1 [^]
(0011539)
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.
(0011541)
svnbot   
2008-12-18 17:45   
Repository: openbravo
Revision: 11387
Author: huehner
Date: 2008-12-18 17:44:58 +0100 (Thu, 18 Dec 2008)

Fixed 6657
Fix second instance of this issue in the report

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

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