Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016774Openbravo ERP03. Procurement managementpublic2011-03-02 10:482011-05-02 12:01
Reporterxabiermerino 
Assigned ToAinhoaPagola 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP26 
Target Version2.50MP29Fixed in Version 
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
Summary0016774: 'Vendor Invoice Report' and 'Invoice Detail' don't show financial invoice
Description'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
Steps To Reproduce- 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
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 
Attached Filesdiff repFinancial.diff (10,897) 2011-04-28 10:32
https://issues.openbravo.com/file_download.php?file_id=3901&type=bug
Issue History
Date ModifiedUsernameFieldChange
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