Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010055Openbravo ERP09. Financial managementpublic2009-07-24 11:532009-07-31 13:50
Reporternetworkb 
Assigned Todalsasua 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.35MP5 
Target VersionFixed in Version2.35 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010055: Report Not Posted does not show Good Shipments
DescriptionThis 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 ReproduceActivate 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)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0010043 closed dalsasua Report Not Posted does not show Good Shipments 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-24 15:52dalsasuaTypedefect => backport
2009-07-24 15:52dalsasuafix_in_branch => 2.3x
2009-07-27 13:43hgbotCheckin
2009-07-27 13:43hgbotNote Added: 0018629
2009-07-27 13:43hgbotStatusscheduled => resolved
2009-07-27 13:43hgbotResolutionopen => fixed
2009-07-27 13:43hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.3x/rev/c0fa66cad482e9a8673feab1d13c0b206bb5e2ec [^]
2009-07-31 09:41sureshbabuStatusresolved => new
2009-07-31 09:41sureshbabuResolutionfixed => open
2009-07-31 09:41sureshbabuNote Added: 0018750
2009-07-31 12:30dalsasuaStatusnew => scheduled
2009-07-31 12:30dalsasuafix_in_branch2.3x => pi
2009-07-31 12:30dalsasuafix_in_branchpi => 2.3x
2009-07-31 12:30dalsasuaStatusscheduled => resolved
2009-07-31 12:30dalsasuaFixed in Version => 2.35
2009-07-31 12:30dalsasuaFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.3x/rev/c0fa66cad482e9a8673feab1d13c0b206bb5e2ec [^] => c0fa66cad482e9a8673feab1d13c0b206bb5e2ec
2009-07-31 12:30dalsasuaResolutionopen => fixed
2009-07-31 12:30dalsasuaNote Added: 0018760
2009-07-31 13:50sureshbabuStatusresolved => closed
2009-07-31 13:50sureshbabuNote Added: 0018767

Notes
(0018629)
hgbot   
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   
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   
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   
2009-07-31 13:50   
Its working fine(checked with Pablo also for confirmation)