details: http://code.openbravo.com/erp/devel/pi/rev/a052f315df1e
changeset: 3502:a052f315df1e
user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
date: Fri Apr 03 12:00:15 2009 +0200
summary: Fixed bug 7894: Details for Trial Balance Report not working in
PostgreSQL
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceDetail_data.xsql | 6
+++---
1 files changed, 3 insertions(+), 3 deletions(-)
diffs (23 lines):
diff -r 6f4717cb73b4 -r a052f315df1e
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceDetail_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceDetail_data.xsql
Fri Apr 03 10:47:33 2009 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceDetail_data.xsql
Fri Apr 03 12:00:15 2009 +0200
@@ -12,7 +12,7 @@
* under the License.
* The Original Code is Openbravo ERP.
* The Initial Developer of the Original Code is Openbravo SL
- * All portions are Copyright (C) 2001-2006 Openbravo SL
+ * All portions are Copyright (C) 2001-2009 Openbravo SL
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************
@@ -54,8 +54,8 @@
<Parameter name="orgFamily" type="replace" optional="true"
after="f.AD_ORG_ID IN(" text="'2'"/>
<Parameter name="adUserClient" type="replace" optional="true"
after="F.AD_CLIENT_ID IN (" text="'1'"/>
<Parameter name="adUserOrg" type="replace" optional="true"
after="F.AD_ORG_ID IN(" text="'1'"/>
- <Parameter name="parDateFrom" optional="true" after="AND 1=1"><![CDATA[AND
F.DATEACCT >= ?]]></Parameter>
- <Parameter name="parDateTo" optional="true" after="AND 1=1"><![CDATA[AND
F.DATEACCT < ?]]></Parameter>
+ <Parameter name="parDateFrom" optional="true" after="AND 1=1"><![CDATA[AND
F.DATEACCT >= TO_DATE(?)]]></Parameter>
+ <Parameter name="parDateTo" optional="true" after="AND 1=1"><![CDATA[AND
F.DATEACCT < TO_DATE(?)]]></Parameter>
<Parameter name="idFamily" type="replace" optional="true" after="AND
F.ACCOUNT_ID IN (" text="'3'"/>
<Parameter name="id"/>
<Parameter name="id"/>
------------------------------------------------------------------------------
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
