Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0007774Openbravo ERP09. Financial managementpublic2009-02-23 18:212009-06-06 00:00
plujan 
vmromanos 
highminorhave not tried
closedfixed 
30
pi 
pi 
Core
No
0007774: On Trial Balance Report, the HTML Format and the printed version are not the same
When generating a Trial Balance Report, if I print generated report, both reports have differences. See attach. Here the list of differences I see:
*No matter what Organization I choose, the report shows my Client name as Enterprise
*From Account and To Account seems to be in Spanish on the report
*Conditions are only the dates, even if I filtered for other conditions
*Bottom line is "ADD AND KEEP GOING..." on screen but "CONTINUE ........" on the report
*Heading on the report is "REPORT TRIAL BALANCE" but menu option to access the window is "Trial Balance Report"
*Numeric fields has different alignment
1. Go Financial Management > Accounting > Analysis Tools > Trial Balance Report
2. Enter some filters to get data.
3. Click HTML Format button
4. The report is shown, there are some "Detail" links. Click one. An error message is displayed:
      
Error:
ERROR: operator does not exist: timestamp without time zone < character varying
250MP1
depends on defect 0007894 closed vmromanos Details for Trial Balance Report not working in PostgreSQL 
depends on backport 0007929 closed jayakumar On Trial Balance Report, the HTML Format and the printed version are not the same 
png BUG_250_trunk_TrialBalanceReportReport.PNG (75,924) 2009-02-23 18:21
https://issues.openbravo.com/file_download.php?file_id=925&type=bug
png
Issue History
2009-02-23 18:21plujanNew Issue
2009-02-23 18:21plujanAssigned To => rafaroda
2009-02-23 18:21plujanFile Added: BUG_250_trunk_TrialBalanceReportReport.PNG
2009-02-23 18:21plujanRegression testing => No
2009-02-23 18:21plujanIssue generated from0007772
2009-03-04 09:03rafarodaNote Added: 0014364
2009-03-04 09:03rafarodaAssigned Torafaroda => dalsasua
2009-03-04 09:03rafarodaPrioritynormal => high
2009-03-04 09:03rafarodaRelationship addeddepends on 0007894
2009-03-04 09:03rafarodaStatusnew => scheduled
2009-03-04 09:03rafarodafix_in_branch => pi
2009-04-23 16:05psarobeTag Attached: 250MP1
2009-05-13 18:10vmromanosAssigned Todalsasua => vmromanos
2009-05-13 18:44hgbotCheckin
2009-05-13 18:44hgbotNote Added: 0016336
2009-05-13 18:44hgbotStatusscheduled => resolved
2009-05-13 18:44hgbotResolutionopen => fixed
2009-05-13 18:44hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c892204dd7328d3cd8e7f6954711ec19cef34cd6 [^]
2009-06-05 11:06sureshbabuStatusresolved => closed
2009-06-05 11:06sureshbabuNote Added: 0017005
2009-06-05 11:06sureshbabuFixed in Version => pi
2009-06-06 00:00anonymoussf_bug_id0 => 2802022

Notes
(0014364)
rafaroda   
2009-03-04 09:03   
For point 4 "The report is shown, there are some "Detail" links. Click one. An error message is displayed: Error: ERROR: operator does not exist: timestamp without time zone < character varying"

Please refer to bug 7894 https://issues.openbravo.com/view.php?id=7894 [^]
(0016336)
hgbot   
2009-05-13 18:44   
Repository: erp/devel/pi
Changeset: c892204dd7328d3cd8e7f6954711ec19cef34cd6
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Wed May 13 18:42:20 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c892204dd7328d3cd8e7f6954711ec19cef34cd6 [^]

Fixed bug 7774: On Trial Balance Report, the HTML Format and the printed version are not the same

---
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.html
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.java
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalancePDF.fo
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalancePDF.xml
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
---
(0017005)
sureshbabu   
2009-06-05 11:06   
Tested working fine