details: /erp/devel/pi/rev/fee84cd1b187
changeset: 8206:fee84cd1b187
user: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
date: Tue Aug 24 16:04:55 2010 +0530
summary: Fixes Issue 14165: Missing documents in Not Posted Transactions
Report
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql | 25
+++++++++-
1 files changed, 24 insertions(+), 1 deletions(-)
diffs (42 lines):
diff -r 64d6d6da854d -r fee84cd1b187
src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql Tue Aug
24 09:53:37 2010 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql Tue Aug
24 16:04:55 2010 +0530
@@ -89,7 +89,20 @@
from GL_Journal
where processed = 'Y'
and posted = 'N'
- and 'Y'=(select max(isactive) from c_acctschema_table where
ad_table_id='224' and ad_client_id=?)) AAA
+ and 'Y'=(select max(isactive) from c_acctschema_table where
ad_table_id='224' and ad_client_id=?)
+ union all
+ select ad_client_id,name, movementdate ,
ad_column_identifier('M_INVENTORY',to_char(m_inventory_id), TO_CHAR(?)) , 0 as
GRANDTOTAL, 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='MMI') and ad_language=to_char(?) and ad_client_id=?)), 'Physical
Inventory') as document
+ from m_inventory
+ where processed = 'Y'
+ and posted = 'N'
+ and 'Y'=(select max(isactive) from c_acctschema_table where
ad_table_id='321' and ad_client_id=?)
+ union all
+ select ad_client_id,name, movementdate ,
ad_column_identifier('M_MOVEMENT',to_char(m_movement_id), TO_CHAR(?)) , 0 as
GRANDTOTAL,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='MMM') and ad_language=to_char(?) and ad_client_id=?)), 'Goods
Movement') as document
+ from m_movement
+ where processed = 'Y'
+ and posted = 'N'
+ and 'Y'=(select max(isactive) from c_acctschema_table where
ad_table_id='323' and ad_client_id=?)
+ ) AAA
where dateacct >= ?
and dateacct <= ?
and ad_client_id = ?
@@ -133,6 +146,16 @@
<Parameter name="adLanguage"/>
<Parameter name="client"></Parameter>
<Parameter name="client"></Parameter>
+ <Parameter name="adLanguage"/>
+ <Parameter name="client"></Parameter>
+ <Parameter name="adLanguage"/>
+ <Parameter name="client"></Parameter>
+ <Parameter name="client"></Parameter>
+ <Parameter name="adLanguage"/>
+ <Parameter name="client"></Parameter>
+ <Parameter name="adLanguage"/>
+ <Parameter name="client"></Parameter>
+ <Parameter name="client"></Parameter>
<Parameter name="dateFrom"></Parameter>
<Parameter name="dateTo"></Parameter>
<Parameter name="client"></Parameter>
------------------------------------------------------------------------------
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and reach millions of netbook users
worldwide. Take advantage of special opportunities to increase revenue and
speed time-to-market. Join now, and jumpstart your future.
http://p.sf.net/sfu/intel-atom-d2d
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
