Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0006701Openbravo ERP09. Financial managementpublic2008-12-19 17:412008-12-31 15:21
shuehner 
shuehner 
normalmajorhave not tried
closedfixed 
5
pi 
 
Core
No
0006701: Create Tax Report does not on postgresql 8.3
because of stricter 8.3 casting rules (problem similar like missing to_number) and two missing to_date calls
Go to: Financial Management || Accounting || Analysis Tools || Tax Report Setup
add a new entry
mark it as report
save the new entry
Go to: Financial Management || Accounting || Analysis Tools || Tax Report
Enter date filter and select tax report setup entry
Press ok
No tags attached.
Issue History
2008-12-19 17:41shuehnerNew Issue
2008-12-19 17:41shuehnerAssigned To => shuehner
2008-12-19 17:41shuehnersf_bug_id0 => 2449936
2008-12-19 17:41shuehnerRegression testing => No
2008-12-19 17:42svnbotCheckin
2008-12-19 17:42svnbotNote Added: 0011618
2008-12-19 17:42svnbotStatusnew => resolved
2008-12-19 17:42svnbotResolutionopen => fixed
2008-12-19 17:42svnbotsvn_revision => 11428
2008-12-31 15:14lakshmiNote Added: 0011800
2008-12-31 15:21lakshmiStatusresolved => closed

Notes
(0011618)
svnbot   
2008-12-19 17:42   
Repository: openbravo
Revision: 11428
Author: huehner
Date: 2008-12-19 17:42:56 +0100 (Fri, 19 Dec 2008)

Fixed 6701
add missing to_date calls and convert lists of orgs to be lists of strings
to fix the process on pgsql 8.3

---
U trunk/src/org/openbravo/erpCommon/ad_process/CreateTaxReport.java
U trunk/src/org/openbravo/erpCommon/ad_process/CreateTaxReport_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=11428&sc=1 [^]
(0011800)
lakshmi   
2008-12-31 15:14   
Verified the issue and it works in Openbravo 2.50 (r11619). So i closed this issue