Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0016774Openbravo ERP03. Procurement managementpublic2011-03-02 10:482011-05-02 12:01
xabiermerino 
AinhoaPagola 
highminoralways
closedfixed 
5
2.50MP26 
2.50MP29 
Core
No
0016774: 'Vendor Invoice Report' and 'Invoice Detail' don't show financial invoice
'Vendor Invoice Report' and 'Invoice Detail' don't show financial invoices.

The problem is that the query makes an union with m_product by 'm_product_id' and Financial invoices have no m_product_id
- As openbravo Admin create a new invoice with hammer as product (date: 03-03-2011)
- Complete it
- Go to 'Vendor Invoice Report' and 'Invoice Detail' and realize that the invoice appears.
- Go back to the invoice.
- Reactivate it
- Go to lines
- Delete the product
- Check 'Financial Invoice Line'
- Select a G/L item
- save, complete
- Go to 'Vendor Invoice Report' and 'Invoice Detail' and realize that the invoice does not appear.
No tags attached.
related to design defect 0016823 scheduled dmiguelez Reports don't show financial invoices 
blocks defect 00161002.50MP29 closed AinhoaPagola 'Vendor Invoice Report' and 'Invoice Detail' don't show financial invoice 
diff repFinancial.diff (10,897) 2011-04-28 10:32
https://issues.openbravo.com/file_download.php?file_id=3901&type=bug
Issue History
2011-04-12 16:50AinhoaPagolaTypedefect => backport
2011-04-12 16:50AinhoaPagolafix_in_branch => 2.50
2011-04-15 12:17AinhoaPagolaRelationship addedrelated to 0016823
2011-04-26 16:18dalsasuaIssue Monitored: networkb
2011-04-28 10:32AinhoaPagolaFile Added: repFinancial.diff
2011-04-28 10:34AinhoaPagolaNote Added: 0036145
2011-04-28 10:34AinhoaPagolaStatusscheduled => resolved
2011-04-28 10:34AinhoaPagolaFixed in SCM revision => attached diff
2011-04-28 10:34AinhoaPagolaResolutionopen => fixed
2011-04-29 13:33hgbotCheckin
2011-04-29 13:33hgbotNote Added: 0036215
2011-04-29 13:33hgbotFixed in SCM revisionattached diff => http://code.openbravo.com/erp/stable/2.50/rev/0148e17e8647f7062345d3953a8e6553e4f37fe5 [^]
2011-04-29 13:33hgbotCheckin
2011-04-29 13:33hgbotNote Added: 0036216
2011-05-02 12:01xabiermerinoNote Added: 0036249
2011-05-02 12:01xabiermerinoStatusresolved => closed

Notes
(0036145)
AinhoaPagola   
2011-04-28 10:34   
Patch attached as the repository is frozen.
(0036215)
hgbot   
2011-04-29 13:33   
Repository: erp/stable/2.50
Changeset: 0148e17e8647f7062345d3953a8e6553e4f37fe5
Author: Ainhoa Pagola <ainhoa.pagola <at> openbravo.com>
Date: Wed Apr 27 13:11:06 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/0148e17e8647f7062345d3953a8e6553e4f37fe5 [^]

Fixes issue 16774. Financial Invoices in Reports

---
M src-db/database/model/views/C_INVOICELINE_V2.xml
M src/org/openbravo/erpCommon/ad_reports/InvoiceEdition_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportInvoices_data.xsql
---
(0036216)
hgbot   
2011-04-29 13:33   
Repository: erp/stable/2.50
Changeset: c4fa210d0728795a9a142f821828260021a14705
Author: Ainhoa Pagola <ainhoa.pagola <at> openbravo.com>
Date: Wed Apr 27 13:11:46 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/c4fa210d0728795a9a142f821828260021a14705 [^]

Issue 16774. Label changed to include financial invoices

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoicesEditJR.jrxml
---
(0036249)
xabiermerino   
2011-05-02 12:01   
verified