details: /erp/devel/pi/rev/3df698af8ada
changeset: 6964:3df698af8ada
user: Balamurugan Ramadoss <balamurugan.ramadoss <at> openbravo.com>
date: Fri Apr 09 14:39:57 2010 +0530
summary: Fixes Issue 12466: Not Posted Transaction Report doesn't show the
records.
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql | 16
+++++-----
1 files changed, 8 insertions(+), 8 deletions(-)
diffs (68 lines):
diff -r ef2cfd4b2a7a -r 3df698af8ada
src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql Fri Apr
09 14:05:03 2010 +0530
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql Fri Apr
09 14:39:57 2010 +0530
@@ -32,21 +32,21 @@
and issotrx = 'Y'
and docstatus <> 'VO'
and 'Y'=(select max(isactive) from c_acctschema_table where
ad_table_id='318' and ad_client_id=?)
- union
+ union all
select ad_client_id, documentno, dateacct,
ad_column_identifier('M_InOut',to_char(m_inout_id), TO_CHAR(?)) as name, 0 as
GRANDTOTAL, coalesce(to_char((select printname from c_doctype_trl where
c_doctype_id=m_inout.c_doctype_id and ad_language=to_char(?) and
ad_client_id=?)), 'Goods Shipments') as document
from m_inout
where processed = 'Y'
and posted = 'N'
and issotrx = 'Y'
and 'Y'=(select max(isactive) from c_acctschema_table where
ad_table_id='319' and ad_client_id=?)
- union
+ union all
select ad_client_id, documentno, dateacct,
ad_column_identifier('M_InOut',to_char(m_inout_id), TO_CHAR(?)) as name, 0 as
GRANDTOTAL, coalesce(to_char((select printname from c_doctype_trl where
c_doctype_id=m_inout.c_doctype_id and ad_language=to_char(?) and
ad_client_id=?)), 'Goods Receipts') as document
from m_inout
where processed = 'Y'
and posted = 'N'
and issotrx = 'N'
and 'Y'=(select max(isactive) from c_acctschema_table where
ad_table_id='319' and ad_client_id=?)
- union
+ union all
select ad_client_id, documentno, dateacct,
ad_column_identifier('C_Bpartner',to_char(C_bpartner_id), TO_CHAR(?)),
GRANDTOTAL, coalesce(to_char((select printname from c_doctype_trl where
c_doctype_id=c_invoice.c_doctype_id and ad_language=to_char(?) and
ad_client_id=?)), 'Purchase Invoices') as document
from c_invoice
where processed = 'Y'
@@ -54,19 +54,19 @@
and issotrx = 'N'
and docstatus <> 'VO'
and 'Y'=(select max(isactive) from c_acctschema_table where
ad_table_id='318' and ad_client_id=?)
- union
+ union all
select ad_client_id, name, dateacct,
ad_column_identifier('C_Cash',to_char(C_Cash_id), TO_CHAR(?)),
c_cash.STATEMENTDIFFERENCE, coalesce(to_char((select printname from
c_doctype_trl where c_doctype_id=(select min(c_doctype_id) from c_doctype where
ad_client_id=? and docbasetype='CMC') and ad_language=to_char(?) and
ad_client_id=?)), 'Cash Journal') as document
from C_Cash
where processed = 'Y'
and posted = 'N'
and 'Y'=(select max(isactive) from c_acctschema_table where
ad_table_id='407' and ad_client_id=?)
- union
+ union all
select ad_client_id, name, statementdate,
ad_column_identifier('C_Bankstatement',to_char(C_bankstatement_id),
TO_CHAR(?)), STATEMENTDIFFERENCE, coalesce(to_char((select printname from
c_doctype_trl where c_doctype_id=(select min(c_doctype_id) from c_doctype where
ad_client_id=? and docbasetype='CMB') and ad_language=to_char(?) and
ad_client_id=?)), 'Bank Statements') as document
from c_bankstatement
where processed = 'Y'
and posted = 'N'
and 'Y'=(select max(isactive) from c_acctschema_table where
ad_table_id='392' and ad_client_id=?)
- union
+ union all
select ad_client_id, documentno, dateacct,
ad_column_identifier('C_Settlement',to_char(C_Settlement_id), TO_CHAR(?)),
generatedamt, coalesce(to_char((select printname from c_doctype_trl where
c_doctype_id=s.c_doctype_id and ad_language=to_char(?) and ad_client_id=?)),
'Manual Settlements') as document
from c_Settlement s
where processed = 'Y'
@@ -77,14 +77,14 @@
from c_debt_payment p
where p.c_settlement_generate_id = s.c_settlement_id
and p.isdirectposting='Y')
- union
+ union all
select ad_client_id, documentno, dateacct,
ad_column_identifier('C_Settlement',to_char(C_Settlement_id), TO_CHAR(?)),
generatedamt, coalesce(to_char((select printname from c_doctype_trl where
c_doctype_id=c_Settlement.c_doctype_id and ad_language=to_char(?) and
ad_client_id=?)), 'Settlements') as document
from c_Settlement
where processed = 'Y'
and posted = 'N'
and settlementtype <> 'I'
and 'Y'=(select max(isactive) from c_acctschema_table where
ad_table_id='800019' and ad_client_id=?)
- union
+ union all
select ad_client_id, documentno, dateacct,
ad_column_identifier('GL_Journal',to_char(GL_Journal_id), TO_CHAR(?)), totaldr,
coalesce(to_char((select printname from c_doctype_trl where
c_doctype_id=GL_Journal.c_doctype_id and ad_language=to_char(?) and
ad_client_id=?)), 'GL Journal') as document
from GL_Journal
where processed = 'Y'
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
