0010055: 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 ]

blocks

defect

0010043

closed

dalsasua

Report Not Posted does not show Good Shipments

Notes
(0018629) hgbot (developer) 2009-07-27 13:43	Repository: erp/stable/2.3x Changeset: c0fa66cad482e9a8673feab1d13c0b206bb5e2ec Author: David Alsasua <david.alsasua <at> openbravo.com> Date: Mon Jul 27 13:42:34 2009 +0200 URL: http://code.openbravo.com/erp/stable/2.3x/rev/c0fa66cad482e9a8673feab1d13c0b206bb5e2ec [^] Fixes issue 10055: Report Not Posted does not show Good Shipments --- M src/org/openbravo/erpCommon/ad_reports/ReportNotPosted.java M src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql ---

(0018750) sureshbabu (reporter) 2009-07-31 09:41	when i run the report, Financial Management \|\| Accounting \|\| Analysis Tools \|\| Report Not Posted \|\| Report Not Posted the report shows Zero quantity for Good shipment

(0018760) dalsasua (reporter) 2009-07-31 12:30	Hi Suresh, The receipts/shipments are documents that just tell the amount of products that arrived or where sent. I entered a 0 in the amount field, because I think this is not a valorative document, but a quantitative one. Regards.

(0018767) sureshbabu (reporter) 2009-07-31 13:50	Its working fine(checked with Pablo also for confirmation)

Issue History
Date Modified	Username	Field	Change
2009-07-24 15:52	dalsasua	Type	defect => backport
2009-07-24 15:52	dalsasua	fix_in_branch	=> 2.3x
2009-07-27 13:43	hgbot	Checkin
2009-07-27 13:43	hgbot	Note Added: 0018629
2009-07-27 13:43	hgbot	Status	scheduled => resolved
2009-07-27 13:43	hgbot	Resolution	open => fixed
2009-07-27 13:43	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.3x/rev/c0fa66cad482e9a8673feab1d13c0b206bb5e2ec [^]
2009-07-31 09:41	sureshbabu	Status	resolved => new
2009-07-31 09:41	sureshbabu	Resolution	fixed => open
2009-07-31 09:41	sureshbabu	Note Added: 0018750
2009-07-31 12:30	dalsasua	Status	new => scheduled
2009-07-31 12:30	dalsasua	fix_in_branch	2.3x => pi
2009-07-31 12:30	dalsasua	fix_in_branch	pi => 2.3x
2009-07-31 12:30	dalsasua	Status	scheduled => resolved
2009-07-31 12:30	dalsasua	Fixed in Version	=> 2.35
2009-07-31 12:30	dalsasua	Fixed in SCM revision	http://code.openbravo.com/erp/stable/2.3x/rev/c0fa66cad482e9a8673feab1d13c0b206bb5e2ec [^] => c0fa66cad482e9a8673feab1d13c0b206bb5e2ec
2009-07-31 12:30	dalsasua	Resolution	open => fixed
2009-07-31 12:30	dalsasua	Note Added: 0018760
2009-07-31 13:50	sureshbabu	Status	resolved => closed
2009-07-31 13:50	sureshbabu	Note Added: 0018767