Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034962Openbravo ERP07. Sales managementpublic2017-01-16 11:432017-02-03 13:45
Reportermalsasua 
Assigned ToAtulOpenbravo 
PrioritynoneSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034962: Sales Invoice Dimensional Report: distinct cost calculated depending of dimension selected
DescriptionThe value of cost calculated is distinct, depending if dimension "doncumentNo" is selected or not
Steps To Reproduce. run the report:
 . date from 01/11/2016
 . date to 22/11/2016
 . organization: org1
 . dimensions: organization
cost returned = X

. run the report:
 . date from 01/11/2016
 . date to 22/11/2016
 . organization: org1
 . dimensions: organization + documentNo
cost returned = Y
ERROR: X is not equal to Y

The queries executed in the two cases are attached to the ticket
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0023971 new psanjuan It is necessary further explanation on how it works the Sales Invoice Dimensional Report regarding cost information 
Attached Filestxt selectAgrupandoPorDocNo.txt (8,541) 2017-01-16 12:43
https://issues.openbravo.com/file_download.php?file_id=10306&type=bug
? selectSinAgruparPorDocNo (8,129) 2017-01-16 12:43
https://issues.openbravo.com/file_download.php?file_id=10307&type=bug
Issue History
Date ModifiedUsernameFieldChange
2017-01-16 11:43malsasuaNew Issue
2017-01-16 11:43malsasuaAssigned To => Triage Finance
2017-01-16 11:43malsasuaModules => Core
2017-01-16 11:43malsasuaResolution time => 1485730800
2017-01-16 11:43malsasuaTriggers an Emergency Pack => No
2017-01-16 12:43malsasuaFile Added: selectAgrupandoPorDocNo.txt
2017-01-16 12:43malsasuaFile Added: selectSinAgruparPorDocNo
2017-01-16 12:44malsasuaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=14283#r14283
2017-01-16 20:26markmm82Assigned ToTriage Finance => collazoandy4
2017-01-16 20:53collazoandy4Statusnew => scheduled
2017-01-17 18:05collazoandy4Note Added: 0093653
2017-01-17 18:05collazoandy4Statusscheduled => feedback
2017-01-18 16:09egoitzStatusfeedback => new
2017-01-24 16:38markmm82Assigned Tocollazoandy4 => Sanjota
2017-01-26 15:54markmm82Assigned ToSanjota => AtulOpenbravo
2017-02-03 13:40dmiguelezRelationship addedrelated to 0023971
2017-02-03 13:41dmiguelezNote Added: 0094040
2017-02-03 13:41dmiguelezStatusnew => scheduled
2017-02-03 13:45dmiguelezReview Assigned To => dmiguelez
2017-02-03 13:45dmiguelezStatusscheduled => closed
2017-02-03 13:45dmiguelezResolutionopen => no change required

Notes
(0093653)
collazoandy4   
2017-01-17 18:05   
Could you please clarify me how can i reproduce this issue on pi?
(0094040)
dmiguelez   
2017-02-03 13:41   
The Report is behaving as expected.

The Documentation has been updated to further explain this calculations:
http://wiki.openbravo.com/wiki/Sales_Invoice_Dimensional_Report [^]