Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016100Openbravo ERP03. Procurement managementpublic2011-03-02 10:482011-05-12 13:27
Reporterxabiermerino 
Assigned ToAinhoaPagola 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP26 
Target Version2.50MP29Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0016100: '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
depends on backport 00167742.50MP29 closed AinhoaPagola 'Vendor Invoice Report' and 'Invoice Detail' don't show financial invoice 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-03-02 10:48xabiermerinoNew Issue
2011-03-02 10:48xabiermerinoAssigned To => adrianromero
2011-03-02 10:48xabiermerinoModules => Core
2011-03-02 10:48xabiermerinoOBNetwork customer => Yes
2011-03-02 11:19xabiermerinoIssue Monitored: networkb
2011-03-09 17:15jonalegriaesarteTarget Version2.50MP28 => 2.50MP29
2011-04-11 13:54AinhoaPagolaAssigned Toadrianromero => AinhoaPagola
2011-04-12 16:50AinhoaPagolaStatusnew => scheduled
2011-04-12 16:50AinhoaPagolafix_in_branch => pi
2011-04-28 11:33hgbotCheckin
2011-04-28 11:33hgbotNote Added: 0036153
2011-04-28 11:33hgbotStatusscheduled => resolved
2011-04-28 11:33hgbotResolutionopen => fixed
2011-04-28 11:33hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/585692ac614281c4b1c74f8c9a094a41dbb37fda [^]
2011-05-02 12:02xabiermerinoNote Added: 0036250
2011-05-02 12:02xabiermerinoStatusresolved => closed
2011-05-03 00:02anonymoussf_bug_id0 => 3296512
2011-05-12 13:27hudsonbotCheckin
2011-05-12 13:27hudsonbotNote Added: 0036780

Notes
(0036153)
hgbot   
2011-04-28 11:33   
Repository: erp/devel/pi
Changeset: 585692ac614281c4b1c74f8c9a094a41dbb37fda
Author: Ainhoa Pagola <ainhoa.pagola <at> openbravo.com>
Date: Wed Apr 27 17:24:50 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/585692ac614281c4b1c74f8c9a094a41dbb37fda [^]

Fixes issue 16100. Financial invoices showed 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/ReportInvoiceVendorJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoicesEditJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoices_data.xsql
---
(0036250)
xabiermerino   
2011-05-02 12:02   
verified
(0036780)
hudsonbot   
2011-05-12 13:27   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c40e579fcd38 [^]

Maturity status: Test