Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0007894Openbravo ERP09. Financial managementpublic2009-03-02 13:262009-07-17 11:55
AinhoaPagola 
vmromanos 
immediatemajorhave not tried
closedfixed 
20Ubuntu 8.4
pi 
pi 
Core
No
0007894: Details for Trial Balance Report not working in PostgreSQL
In the Trial Balance Report there is a link that says "details".
Clicking on it the following error pops up:

Error:
ERROR: operator does not exist: timestamp without time zone < character varying

Go to: Financial Management || Accounting || Analysis Tools || Trial Balance Report.

Fill the required fields to generate the report.
Once you get the report.
Click on detail link.
250 QA
has duplicate defect 0007772 closed rafaroda On Trial Balance Report, the Detail link shows an error 
blocks defect 0007774 closed vmromanos On Trial Balance Report, the HTML Format and the printed version are not the same 
Issue History
2009-03-02 13:26AinhoaPagolaNew Issue
2009-03-02 13:26AinhoaPagolaAssigned To => rafaroda
2009-03-02 13:26AinhoaPagolaRegression testing => No
2009-03-03 13:12rafarodaNote Added: 0014301
2009-03-03 13:12rafarodaAssigned Torafaroda => dalsasua
2009-03-03 13:12rafarodaStatusnew => feedback
2009-03-03 13:23AinhoaPagolaStatusfeedback => new
2009-03-03 13:23AinhoaPagolaversion => trunk
2009-03-03 13:23AinhoaPagolaNote Added: 0014304
2009-03-04 08:45rafarodaPrioritynormal => high
2009-03-04 08:45rafarodaSeverityminor => major
2009-03-04 08:45rafarodaStatusnew => scheduled
2009-03-04 09:03rafarodaRelationship addedblocks 0007774
2009-03-04 09:05rafarodaRelationship addedhas duplicate 0007772
2009-04-01 17:42psarobeTag Attached: 250 QA
2009-04-02 15:22pjuvaraPriorityhigh => urgent
2009-04-03 10:05pjuvaraPriorityurgent => immediate
2009-04-03 11:10vmromanosAssigned Todalsasua => vmromanos
2009-04-03 12:07hgbotCheckin
2009-04-03 12:07hgbotNote Added: 0015157
2009-04-03 12:07hgbotStatusscheduled => resolved
2009-04-03 12:07hgbotResolutionopen => fixed
2009-04-03 12:07hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a052f315df1eb8fa998871a2d0094a0ce826049c [^]
2009-04-03 16:57sureshbabuStatusresolved => closed
2009-04-03 16:57sureshbabuNote Added: 0015177
2009-04-03 16:57sureshbabuFixed in Version => 2.50beta
2009-04-15 12:00anonymoussf_bug_id0 => 2764932
2009-07-03 13:12hgbotCheckin
2009-07-03 13:12hgbotNote Added: 0017823
2009-07-03 13:12hgbotStatusclosed => resolved
2009-07-03 13:12hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/a052f315df1eb8fa998871a2d0094a0ce826049c [^] => http://code.openbravo.com/erp/devel/pi/rev/f5aad4f1e30c60fc99d186a92ef8fdfb51460229 [^]
2009-07-17 11:55sureshbabuStatusresolved => closed
2009-07-17 11:55sureshbabuNote Added: 0018357
2009-07-17 11:55sureshbabuFixed in Version2.50MP1 => pi

Notes
(0014301)
rafaroda   
2009-03-03 13:12   
Ainhoa,

Can you please inform the product version and if this is also happening in 2.40?

Thanks.
(0014304)
AinhoaPagola   
2009-03-03 13:23   
It is only reproduceable in Trunk.
(0015157)
hgbot   
2009-04-03 12:07   
Repository: erp/devel/pi
Changeset: a052f315df1eb8fa998871a2d0094a0ce826049c
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Fri Apr 03 12:00:15 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a052f315df1eb8fa998871a2d0094a0ce826049c [^]

Fixed bug 7894: Details for Trial Balance Report not working in PostgreSQL

---
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceDetail_data.xsql
---
(0015177)
sureshbabu   
2009-04-03 16:57   
Tested working fine
(0017823)
hgbot   
2009-07-03 13:12   
Repository: erp/devel/pi
Changeset: f5aad4f1e30c60fc99d186a92ef8fdfb51460229
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Fri Apr 03 12:00:15 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f5aad4f1e30c60fc99d186a92ef8fdfb51460229 [^]

Fixed bug 7894: Details for Trial Balance Report not working in PostgreSQL

---
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceDetail_data.xsql
---
(0018357)
sureshbabu   
2009-07-17 11:55   
Tested working fine