Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0006656

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] 09. Financial management

major

have not tried

2008-12-18 17:16

2008-12-31 13:35

Reporter

shuehner

View Status

public

Assigned To

shuehner

Priority

high

Resolution

fixed

Fixed in Version

Status

closed

Fix in branch

pi

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Any

Database

Any

Java version

OS Version

Database version

Ant version

Product Version

pi

SCM revision

11375

Review Assigned To

Web browser

Modules

Core

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0006656: Payment Report: Filter fiels Amount From & Amount to do not work on postgresql 8.3

Description

In this report the filter fields: From Amount and To Amount to not work on postgresql 8.3

Steps To Reproduce

Go 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

Tags

No tags attached.

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on	backport	0006657		closed	shuehner	Payment Report: Filter fiels Amount From & Amount to do not work on postgresql 8.3
related to	defect	0005674	2.50	closed	shuehner	Audit for missing to_number in XSQL for Postgresql from v8.3 and excessive to_number in ID fields

Notes
(0011535) svnbot (reporter) 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 (administrator) 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 (reporter) 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 (reporter) 2008-12-31 13:35	Verified the issue and it works in (Windows/Postgres)Openbravo 2.50 (r11619). So i closed this issue

Issue History
Date Modified	Username	Field	Change
2008-12-18 17:16	shuehner	New Issue
2008-12-18 17:16	shuehner	Assigned To	=> rafaroda
2008-12-18 17:16	shuehner	sf_bug_id	0 => 2445619
2008-12-18 17:16	shuehner	Regression testing	=> No
2008-12-18 17:17	rafaroda	Priority	normal => high
2008-12-18 17:18	rafaroda	Status	new => scheduled
2008-12-18 17:18	rafaroda	Assigned To	rafaroda => shuehner
2008-12-18 17:18	rafaroda	fix_in_branch	=> trunk
2008-12-18 17:29	svnbot	Checkin
2008-12-18 17:29	svnbot	Note Added: 0011535
2008-12-18 17:29	svnbot	Status	scheduled => resolved
2008-12-18 17:29	svnbot	Resolution	open => fixed
2008-12-18 17:29	svnbot	svn_revision	=> 11383
2008-12-18 17:41	shuehner	Status	resolved => new
2008-12-18 17:41	shuehner	Resolution	fixed => open
2008-12-18 17:41	shuehner	Note Added: 0011538
2008-12-18 17:42	svnbot	Checkin
2008-12-18 17:42	svnbot	Note Added: 0011540
2008-12-18 17:42	svnbot	Status	new => resolved
2008-12-18 17:42	svnbot	Resolution	open => fixed
2008-12-18 17:42	svnbot	svn_revision	11383 => 11386
2008-12-19 16:34	shuehner	Relationship added	related to 0005674
2008-12-31 13:35	lakshmi	Status	resolved => closed
2008-12-31 13:35	lakshmi	Note Added: 0011792

Copyright © 2000 - 2009 MantisBT Group