Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0010054
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajoralways2009-07-24 11:532009-08-07 09:57
ReporternetworkbView Statuspublic 
Assigned Todalsasua 
PriorityimmediateResolutionfixedFixed in Version2.40MP8
StatusclosedFix in branch2.40Fixed in SCM revision55cfe82f12ae
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.35MP5SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010054: 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)
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0010043 closeddalsasua Report Not Posted does not show Good Shipments 

-  Notes
(0018619)
hgbot (developer)
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 (reporter)
2009-07-31 08:40

 Tested working fine
(0018749)
sureshbabu (reporter)
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 (reporter)
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 (reporter)
2009-07-31 13:51

 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.40
2009-07-26 18:30 hgbot Checkin
2009-07-26 18:30 hgbot Note Added: 0018619
2009-07-26 18:30 hgbot Status scheduled => resolved
2009-07-26 18:30 hgbot Resolution open => fixed
2009-07-26 18:30 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/55cfe82f12ae1658e55b0c6189915e37b92c9ece [^]
2009-07-31 08:40 sureshbabu Status resolved => closed
2009-07-31 08:40 sureshbabu Note Added: 0018743
2009-07-31 08:40 sureshbabu Fixed in Version => 2.40MP8
2009-07-31 09:40 sureshbabu Status closed => new
2009-07-31 09:40 sureshbabu Resolution fixed => open
2009-07-31 09:40 sureshbabu Note Added: 0018749
2009-07-31 09:40 sureshbabu Fixed in Version 2.40MP8 =>
2009-07-31 12:28 dalsasua Status new => scheduled
2009-07-31 12:28 dalsasua Note Added: 0018759
2009-07-31 12:28 dalsasua fix_in_branch 2.40 => pi
2009-07-31 12:29 dalsasua fix_in_branch pi => 2.40
2009-07-31 12:29 dalsasua Status scheduled => resolved
2009-07-31 12:29 dalsasua Fixed in Version => 2.40
2009-07-31 12:29 dalsasua Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/55cfe82f12ae1658e55b0c6189915e37b92c9ece [^] => 55cfe82f12ae1658e55b0c6189915e37b92c9ece
2009-07-31 12:29 dalsasua Resolution open => fixed
2009-07-31 13:51 sureshbabu Status resolved => closed
2009-07-31 13:51 sureshbabu Note Added: 0018768
2009-08-07 09:57 sureshbabu Fixed in Version 2.40 => 2.40MP8

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker