Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0006660
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajorhave not tried2008-12-18 18:132008-12-31 13:49
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision11393
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase version8.3Ant version
Product VersionpiSCM revision11386 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0006660: General Ledger Report, Filter field: From Amount does not work on postgresql 8.3

Description.. because of missing to_number call
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0006661 closedshuehner General Ledger Report, Filter field: From Amount does not work on postgresql 8.3 
related to defect 00056742.50 closedshuehner Audit for missing to_number in XSQL for Postgresql from v8.3 and excessive to_number in ID fields 
related to defect 0006714 closedHennadzi General Ledger Report, Filter field: From Amount does not work on postgresql 8.3 (again) 

-  Notes
(0011552)
svnbot (reporter)
2008-12-18 18:14

Repository: openbravo
Revision: 11393
Author: huehner
Date: 2008-12-18 18:14:37 +0100 (Thu, 18 Dec 2008)

Fixed 6660
add missing to_number calls to fix filter on postgresql 8.3

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

https://dev.openbravo.com/websvn/openbravo/?rev=11393&sc=1 [^]
(0011555)
shuehner (administrator)
2008-12-18 18:24

Missing steps to reproduce here:
Go to: Financial Management || Accounting || Analysis Tools || General Ledger Report || General Ledger Report
Use the filter field from amount on postgresql 8.3

There are 4 combinations to changed here:
1. Hide matched Debt/Payments: not marked
   From Account/To Account (some value selected)
2. Hide matched Debt/Payments: is marked
   From Account/To Account (some value selected)
3. Hide matched Debt/Payments: not marked
   From Account/To Account (both combos empty line marked)
4. Hide matched Debt/Payments: is marked
   From Account/To Account (both combos empty line marked)
(0011794)
lakshmi (reporter)
2008-12-31 13:49

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 18:13 shuehner New Issue
2008-12-18 18:13 shuehner Assigned To => shuehner
2008-12-18 18:13 shuehner sf_bug_id 0 => 2445725
2008-12-18 18:13 shuehner Regression testing => No
2008-12-18 18:14 shuehner Status new => scheduled
2008-12-18 18:14 shuehner fix_in_branch => trunk
2008-12-18 18:14 svnbot Checkin
2008-12-18 18:14 svnbot Note Added: 0011552
2008-12-18 18:14 svnbot Status scheduled => resolved
2008-12-18 18:14 svnbot Resolution open => fixed
2008-12-18 18:14 svnbot svn_revision => 11393
2008-12-18 18:24 shuehner Note Added: 0011555
2008-12-19 16:34 shuehner Relationship added related to 0005674
2008-12-22 14:36 shuehner Relationship added related to 0006714
2008-12-31 13:49 lakshmi Status resolved => closed
2008-12-31 13:49 lakshmi Note Added: 0011794


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker