0010043: Report Not Posted does not show Good Shipments

Description

This report, does not show good shipment that has not been posted. However, Good Receipts are shown.

Looking at the query (AppsOpenbravo/src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql):

select documentno, dateacct, name as description, GRANDTOTAL as amount, document as doctype
        from
        (select ad_client_id, documentno, dateacct, ad_column_identifier('C_Bpartner',to_char(C_bpartner_id), TO_CHAR(?)) as name, 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=to_number(?))), 'Sales Invoices') as document
        from c_invoice
        where processed = 'Y'
        and posted = 'N'
        and issotrx = 'Y'
        and 'Y'=(select isactive from c_acctschema_table where ad_table_id='318' and ad_client_id=to_number(?))
        union
        select ad_client_id, documentno, dateacct, ad_column_identifier('C_Bpartner',to_char(C_bpartner_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=to_number(?))), 'Goods Receipts') as document
        from m_inout
        where processed = 'Y'
        and posted = 'N'
        and issotrx = 'N'
        and 'Y'=(select isactive from c_acctschema_table where ad_table_id='319' and ad_client_id=to_number(?))
        union
        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=to_number(?))), 'Purchase Invoices') as document
        from c_invoice
        where processed = 'Y'
        and posted = 'N'
        and issotrx = 'N'
        and 'Y'=(select isactive from c_acctschema_table where ad_table_id='318' and ad_client_id=to_number(?))
        union
        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=to_number(?) and docbasetype='CMC') and ad_language=to_char(?) and ad_client_id=to_number(?))), 'Cash Journal') as document
        from C_Cash
        where processed = 'Y'
        and posted = 'N'
        and 'Y'=(select isactive from c_acctschema_table where ad_table_id='407' and ad_client_id=to_number(?))
        union
        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=to_number(?) and docbasetype='CMB') and ad_language=to_char(?) and ad_client_id=to_number(?))), 'Bank Statements') as document
        from c_bankstatement
        where processed = 'Y'
        and posted = 'N'
        and 'Y'=(select isactive from c_acctschema_table where ad_table_id='392' and ad_client_id=to_number(?))
        union
        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=to_number(?))), 'Manual Settlements') as document
        from c_Settlement
        where processed = 'Y'
        and posted = 'N'
        and settlementtype = 'I'
        and 'Y'=(select isactive from c_acctschema_table where ad_table_id='800019' and ad_client_id=to_number(?))
        union
        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=to_number(?))), 'Settlements') as document
        from c_Settlement
        where processed = 'Y'
        and posted = 'N'
        and settlementtype <> 'I'
        and 'Y'=(select isactive from c_acctschema_table where ad_table_id='800019' and ad_client_id=to_number(?))
        union
        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=to_number(?))), 'GL Journal') as document
        from GL_Journal
        where processed = 'Y'
        and posted = 'N'
        and 'Y'=(select isactive from c_acctschema_table where ad_table_id='224' and ad_client_id=to_number(?))) AAA
        where dateacct >= to_date(?)
        and dateacct <= to_date(?)
        and ad_client_id = to_number(?)
        order by document, dateacct, name

M_Inout is filtered only by purchase (issotrx = 'N')

Steps To Reproduce

Activate M_Inout as table to be posted (Financial Management > Accounting > Accounting Schema > Account Schema Tables).
Create a new Good Shipment.
Complete it.
Go to Financial Management > Accounting > Analysis Tools > Report Not Posted.
Filter by date.
Report does not show this document

(Note: notice that period must be open)

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on	backport	0010054		closed	dalsasua	Report Not Posted does not show Good Shipments
depends on	backport	0010055		closed	dalsasua	Report Not Posted does not show Good Shipments

Notes
(0018603) rafaroda (developer) 2009-07-24 12:02	David, Could you please take action on this issue? If it has to be scheduled please notice that it has been reported against 2.35 MP5. Thanks.

(0018611) hgbot (developer) 2009-07-24 18:55	Repository: erp/devel/pi Changeset: 9cb188c00976942b5216177bcb2999ea34823542 Author: David Alsasua <david.alsasua <at> openbravo.com> Date: Fri Jul 24 18:55:37 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/9cb188c00976942b5216177bcb2999ea34823542 [^] Fixes Issue 10043: Report Not Posted does not show Good Shipments --- M src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql ---

(0018967) sureshbabu (reporter) 2009-08-17 12:23	Tested working fine

Issue History
Date Modified	Username	Field	Change
2009-07-24 11:53	networkb	New Issue
2009-07-24 11:53	networkb	Assigned To	=> rafaroda
2009-07-24 12:02	rafaroda	Note Added: 0018603
2009-07-24 12:02	rafaroda	Assigned To	rafaroda => dalsasua
2009-07-24 15:52	dalsasua	Status	new => scheduled
2009-07-24 15:52	dalsasua	fix_in_branch	=> pi
2009-07-24 18:55	hgbot	Checkin
2009-07-24 18:55	hgbot	Note Added: 0018611
2009-07-24 18:55	hgbot	Status	scheduled => resolved
2009-07-24 18:55	hgbot	Resolution	open => fixed
2009-07-24 18:55	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/9cb188c00976942b5216177bcb2999ea34823542 [^]
2009-08-17 12:23	sureshbabu	Status	resolved => closed
2009-08-17 12:23	sureshbabu	Note Added: 0018967
2009-08-17 12:23	sureshbabu	Fixed in Version	=> pi
2009-08-18 00:00	anonymous	sf_bug_id	0 => 2839266