Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010054Openbravo ERP09. Financial managementpublic2009-07-24 11:532009-08-07 09:57
Reporternetworkb 
Assigned Todalsasua 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.35MP5 
Target VersionFixed in Version2.40MP8 
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
Summary0010054: 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.40
2009-07-26 18:30hgbotCheckin
2009-07-26 18:30hgbotNote Added: 0018619
2009-07-26 18:30hgbotStatusscheduled => resolved
2009-07-26 18:30hgbotResolutionopen => fixed
2009-07-26 18:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/55cfe82f12ae1658e55b0c6189915e37b92c9ece [^]
2009-07-31 08:40sureshbabuStatusresolved => closed
2009-07-31 08:40sureshbabuNote Added: 0018743
2009-07-31 08:40sureshbabuFixed in Version => 2.40MP8
2009-07-31 09:40sureshbabuStatusclosed => new
2009-07-31 09:40sureshbabuResolutionfixed => open
2009-07-31 09:40sureshbabuNote Added: 0018749
2009-07-31 09:40sureshbabuFixed in Version2.40MP8 =>
2009-07-31 12:28dalsasuaStatusnew => scheduled
2009-07-31 12:28dalsasuaNote Added: 0018759
2009-07-31 12:28dalsasuafix_in_branch2.40 => pi
2009-07-31 12:29dalsasuafix_in_branchpi => 2.40
2009-07-31 12:29dalsasuaStatusscheduled => resolved
2009-07-31 12:29dalsasuaFixed in Version => 2.40
2009-07-31 12:29dalsasuaFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/55cfe82f12ae1658e55b0c6189915e37b92c9ece [^] => 55cfe82f12ae1658e55b0c6189915e37b92c9ece
2009-07-31 12:29dalsasuaResolutionopen => fixed
2009-07-31 13:51sureshbabuStatusresolved => closed
2009-07-31 13:51sureshbabuNote Added: 0018768
2009-08-07 09:57sureshbabuFixed in Version2.40 => 2.40MP8

Notes
(0018619)
hgbot   
2009-07-26 18:30   
Repository: erp/stable/2.40
Changeset: 55cfe82f12ae1658e55b0c6189915e37b92c9ece
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Sun Jul 26 18:30:43 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/55cfe82f12ae1658e55b0c6189915e37b92c9ece [^]

Fixes issue 10054: Report Not Posted does not show Good Shipments

---
M src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql
---
(0018743)
sureshbabu   
2009-07-31 08:40   
Tested working fine
(0018749)
sureshbabu   
2009-07-31 09:40   
Hi,

when i run the report Financial Management || Accounting || Analysis Tools || Report Not Posted || Report Not Posted , the report shows Quantity as Zero(0,00) for Goods Shipment
(0018759)
dalsasua   
2009-07-31 12:28   
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.
(0018768)
sureshbabu   
2009-07-31 13:51   
Its working fine (checked with Pablo also for confirmation)