details: https://code.openbravo.com/erp/devel/pi/rev/da93237b9d93
changeset: 28173:da93237b9d93
user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
date: Thu Dec 31 12:25:57 2015 +0100
summary: Fixed bug 31810: Balance Sheet and PL does not show the Year and
Reference Year
The ad_client_id passed to the query is surronded by single quotes, so the sqlc
query is adapted accordingly
diffstat:
src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql | 8
++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diffs (23 lines):
diff -r 64dfe1cd7ea5 -r da93237b9d93
src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql
Mon Dec 28 17:49:06 2015 +0000
+++ b/src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql
Thu Dec 31 12:25:57 2015 +0100
@@ -189,15 +189,15 @@
SELECT O.AD_ORG_ID AS PADRE, Y.C_YEAR_ID AS ID, Y.YEAR || ' (' ||
C.NAME || ')' AS NAME
FROM C_YEAR Y, C_CALENDAR C, AD_ORG O
WHERE C.C_CALENDAR_ID = Y.C_CALENDAR_ID
- AND C.AD_CLIENT_ID = ?
+ AND C.AD_CLIENT_ID = '1'
AND EXISTS (
SELECT 1 FROM AD_ORG ORG
- WHERE AD_ORG_ISINNATURALTREE(O.AD_ORG_ID,
ORG.AD_ORG_ID, ?) = 'Y'
+ WHERE AD_ORG_ISINNATURALTREE(O.AD_ORG_ID,
ORG.AD_ORG_ID, '1') = 'Y'
AND C.C_CALENDAR_ID = ORG.C_CALENDAR_ID
)
ORDER BY O.NAME, Y.YEAR
]]></Sql>
- <Parameter name="Client" />
- <Parameter name="Client" />
+ <Parameter name="Client" type="replace" optional="false" after="AND
C.AD_CLIENT_ID = " text="'1'"></Parameter>
+ <Parameter name="Client" type="replace" optional="false" after="WHERE
AD_ORG_ISINNATURALTREE(O.AD_ORG_ID, ORG.AD_ORG_ID, " text="'1'"></Parameter>
</SqlMethod>
</SqlClass>
------------------------------------------------------------------------------
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
