Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016823Openbravo ERP07. Sales managementpublic2011-04-15 12:162012-09-13 10:43
ReporterAinhoaPagola 
Assigned Todmiguelez 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed 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
Summary0016823: Reports don't show financial invoices
DescriptionSome reports do not show Financial Invoices.
At least:
- Sales Invoice Dimensional Report
- Customer Invoice Report
- Discount Invoice Report

This happens because the query linkes tables though products and financial invoices do not have products but g/l items set.
Steps To Reproduce- As Openbravo Admin create a new invoice with hammer as product. Complete it.
- Go to the report and make sure the invoice is there.
- Unpost and reactivate the invoice.
- Go to lines and remove the product.
- Chech 'Financial Invoice Line'
- Select a G/L item.
- Complete the invoice
- Go back to the same reports, with the same filters and check that the product is not there anymore.
Proposed SolutionThe querys should be modified to include invoices with no product but with g/l items.
The "product" or "article" label in the reports should be changed to include g/l items.
Additional Information
TagsNo tags attached.
Relationships
related to backport 00167742.50MP29 closed AinhoaPagola 'Vendor Invoice Report' and 'Invoice Detail' don't show financial invoice 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-04-15 12:16AinhoaPagolaNew Issue
2011-04-15 12:16AinhoaPagolaAssigned To => adrianromero
2011-04-15 12:16AinhoaPagolaModules => Core
2011-04-15 12:17AinhoaPagolaRelationship addedrelated to 0016774
2011-06-03 10:58dalsasuaAssigned Toadrianromero => dalsasua
2011-07-20 18:16dalsasuaAssigned Todalsasua => jonalegriaesarte
2011-09-26 18:27psarobeStatusnew => scheduled
2011-09-26 18:27psarobeNote Added: 0041290
2011-09-26 18:27psarobefix_in_branch => pi
2011-10-29 19:12psarobePrioritynormal => urgent
2011-10-29 19:12psarobeSeverityminor => major
2011-10-29 19:12psarobeTypedefect => design defect
2011-10-29 19:12psarobeTarget Version => 3.0MP7
2011-10-29 19:12psarobefix_in_branchpi =>
2011-12-30 19:40jonalegriaesarteTarget Version3.0MP7 =>
2012-09-13 10:43jonalegriaesarteAssigned Tojonalegriaesarte => dmiguelez

Notes
(0041290)
psarobe   
2011-09-26 18:27   
It shows the invoices for Sales invoice dimensional report but shows the "product" with **

For the other two report doesn't even show the invoice