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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0007894
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajorhave not tried2009-03-02 13:262009-07-17 11:55
ReporterAinhoaPagolaView Statuspublic 
Assigned Tovmromanos 
PriorityimmediateResolutionfixedFixed in Versionpi
StatusclosedFix in branchFixed in SCM revisionf5aad4f1e30c
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.5
OS VersionUbuntu 8.4Database version8.3Ant version1.7
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0007894: Details for Trial Balance Report not working in PostgreSQL

DescriptionIn 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

Steps To ReproduceGo 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.
Tags250 QA
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
has duplicate defect 0007772 closedrafaroda On Trial Balance Report, the Detail link shows an error 
blocks defect 0007774 closedvmromanos On Trial Balance Report, the HTML Format and the printed version are not the same 

-  Notes
(0014301)
rafaroda (developer)
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 (reporter)
2009-03-03 13:23

It is only reproduceable in Trunk.
(0015157)
hgbot (developer)
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 (reporter)
2009-04-03 16:57

Tested working fine
(0017823)
hgbot (developer)
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 (reporter)
2009-07-17 11:55

Tested working fine

- Issue History
Date Modified Username Field Change
2009-03-02 13:26 AinhoaPagola New Issue
2009-03-02 13:26 AinhoaPagola Assigned To => rafaroda
2009-03-02 13:26 AinhoaPagola Regression testing => No
2009-03-03 13:12 rafaroda Note Added: 0014301
2009-03-03 13:12 rafaroda Assigned To rafaroda => dalsasua
2009-03-03 13:12 rafaroda Status new => feedback
2009-03-03 13:23 AinhoaPagola Status feedback => new
2009-03-03 13:23 AinhoaPagola version => trunk
2009-03-03 13:23 AinhoaPagola Note Added: 0014304
2009-03-04 08:45 rafaroda Priority normal => high
2009-03-04 08:45 rafaroda Severity minor => major
2009-03-04 08:45 rafaroda Status new => scheduled
2009-03-04 09:03 rafaroda Relationship added blocks 0007774
2009-03-04 09:05 rafaroda Relationship added has duplicate 0007772
2009-04-01 17:42 psarobe Tag Attached: 250 QA
2009-04-02 15:22 pjuvara Priority high => urgent
2009-04-03 10:05 pjuvara Priority urgent => immediate
2009-04-03 11:10 vmromanos Assigned To dalsasua => vmromanos
2009-04-03 12:07 hgbot Checkin
2009-04-03 12:07 hgbot Note Added: 0015157
2009-04-03 12:07 hgbot Status scheduled => resolved
2009-04-03 12:07 hgbot Resolution open => fixed
2009-04-03 12:07 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a052f315df1eb8fa998871a2d0094a0ce826049c [^]
2009-04-03 16:57 sureshbabu Status resolved => closed
2009-04-03 16:57 sureshbabu Note Added: 0015177
2009-04-03 16:57 sureshbabu Fixed in Version => 2.50beta
2009-04-15 12:00 anonymous sf_bug_id 0 => 2764932
2009-07-03 13:12 hgbot Checkin
2009-07-03 13:12 hgbot Note Added: 0017823
2009-07-03 13:12 hgbot Status closed => resolved
2009-07-03 13:12 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/a052f315df1eb8fa998871a2d0094a0ce826049c [^] => http://code.openbravo.com/erp/devel/pi/rev/f5aad4f1e30c60fc99d186a92ef8fdfb51460229 [^]
2009-07-17 11:55 sureshbabu Status resolved => closed
2009-07-17 11:55 sureshbabu Note Added: 0018357
2009-07-17 11:55 sureshbabu Fixed in Version 2.50MP1 => pi


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker