details: https://code.openbravo.com/erp/devel/pi/rev/55b1b3b28000
changeset: 17634:55b1b3b28000
user: Naiara Garcia <naiara.garcia <at> openbravo.com>
date: Wed Aug 08 12:12:27 2012 +0200
summary: Fixed issue 21271: in general ledger report (XLS) the project name
should be the columns identifiers
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql | 6
+++---
1 files changed, 3 insertions(+), 3 deletions(-)
diffs (30 lines):
diff -r 711a787f62d5 -r 55b1b3b28000
src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
Thu Aug 09 00:09:41 2012 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
Wed Aug 08 12:12:27 2012 +0200
@@ -151,7 +151,7 @@
CASE ?
WHEN 'BPartner' THEN (select to_char(name) from c_bpartner b
where b.c_bpartner_id = c_bpartner.c_bpartner_id)
WHEN 'Product' THEN (select to_char(value || ' - ' || name)
from m_product p where p.m_product_id = m_product.m_product_id)
- WHEN 'Project' THEN (select to_char(name) from c_project pj
where pj.c_project_id = c_project.c_project_id)
+ WHEN 'Project' THEN (select to_char(value || ' - ' || name)
from c_project pj where pj.c_project_id = c_project.c_project_id)
ELSE '' END AS groupbyname,
CASE WHEN AMTACCTDR <> 0 THEN 'Y' ELSE 'N' END AS ISDEBIT,
CASE WHEN FACT_ACCT.FACTACCTTYPE = 'O' THEN 1 ELSE (CASE WHEN
FACT_ACCT.FACTACCTTYPE = 'N' THEN 2 ELSE (CASE WHEN FACT_ACCT.FACTACCTTYPE =
'R' THEN 3 ELSE (CASE WHEN FACT_ACCT.FACTACCTTYPE = 'C' THEN 4 END) END) END)
END AS FACTACCTTYPE
@@ -237,7 +237,7 @@
CASE ?
WHEN 'BPartner' THEN (select to_char(name) from c_bpartner b
where b.c_bpartner_id = c_bpartner.c_bpartner_id)
WHEN 'Product' THEN (select to_char(value || ' - ' || name)
from m_product p where p.m_product_id = m_product.m_product_id)
- WHEN 'Project' THEN (select to_char(name) from c_project pj
where pj.c_project_id = c_project.c_project_id)
+ WHEN 'Project' THEN (select to_char(value || ' - ' || name)
from c_project pj where pj.c_project_id = c_project.c_project_id)
ELSE '' END AS groupbyname,
CASE WHEN AMTACCTDR <> 0 THEN 'Y' ELSE 'N' END AS ISDEBIT,
CASE WHEN FACT_ACCT.FACTACCTTYPE = 'O' THEN 1 ELSE (CASE WHEN
FACT_ACCT.FACTACCTTYPE = 'N' THEN 2 ELSE (CASE WHEN FACT_ACCT.FACTACCTTYPE =
'R' THEN 3 ELSE (CASE WHEN FACT_ACCT.FACTACCTTYPE = 'C' THEN 4 END) END) END)
END AS FACTACCTTYPE
@@ -380,7 +380,7 @@
c_bpartner.c_bpartner_id as bpid, m_product.m_product_id as pdid,
c_project.c_project_id as pjid,
(select name from c_bpartner b where b.c_bpartner_id =
c_bpartner.c_bpartner_id) as bpname,
(select value || ' - ' || name from m_product p where
p.m_product_id = m_product.m_product_id) as pdname,
- (select name from c_project pj where pj.c_project_id =
c_project.c_project_id) as pjname,
+ (select value || ' - ' || name from c_project pj where
pj.c_project_id = c_project.c_project_id) as pjname,
CASE WHEN AMTACCTDR <> 0 THEN 'Y' ELSE 'N' END AS ISDEBIT,
CASE WHEN FACT_ACCT.FACTACCTTYPE = 'O' THEN 1 ELSE (CASE WHEN
FACT_ACCT.FACTACCTTYPE = 'N' THEN 2 ELSE (CASE WHEN FACT_ACCT.FACTACCTTYPE =
'R' THEN 3 ELSE (CASE WHEN FACT_ACCT.FACTACCTTYPE = 'C' THEN 4 END) END) END)
END AS FACTACCTTYPE
FROM FACT_ACCT
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
