Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027459Openbravo ERP03. Procurement managementpublic2014-08-25 12:312014-12-30 08:27
Reportermaite 
Assigned Toreinaldoguerra 
PriorityurgentSeveritymajorReproducibilityalways
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket30538
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027459: Data from non-accessible organizations is obtained in Multidimensional reports
DescriptionData from non-accessible organizations is obtained in Multidimensional reports
Steps To Reproduce1. Access Role window and edit "F&B España, S.A - Procurement" role to set it as "User level= Organization"
2. Go to "Org Access" tab and delete records for "España" and "España sur" so role only has access to "España Norte" organization
3. Log out and log in again with "F&B España, S.A - Procurement" role
4. Go to "Purchase Dimensional Report" and realize that in Organization combo you are able to see more organizations than "España Norte".
5. Set * organization and run report. Realize that data from other organizations is considered
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0027953 closed jorge-garcia AccessibleOrgTree wrongly used in some reports may create security issues 
related to defect 00307973.0PR15Q4 closed alostale Validation rule automatically adds wrong organization list to the where clause 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-08-25 12:31maiteNew Issue
2014-08-25 12:31maiteAssigned To => dmiguelez
2014-08-25 12:31maiteOBNetwork customer => Yes
2014-08-25 12:31maiteModules => Core
2014-08-25 12:31maiteSupport ticket => 30538
2014-08-25 12:31maiteResolution time => 1411509600
2014-08-25 12:31maiteTriggers an Emergency Pack => No
2014-08-25 12:32maiteIssue Monitored: networkb
2014-09-29 16:12jonalegriaesarteTarget Version3.0PR14Q4 => 3.0PR15Q1
2014-10-21 05:01reinaldoguerraStatusnew => scheduled
2014-10-21 05:02reinaldoguerraAssigned Todmiguelez => reinaldoguerra
2014-10-22 04:56reinaldoguerraNote Added: 0071107
2014-10-22 18:52vmromanosRelationship addedrelated to 0027953
2014-11-04 10:50SandrahuguetTypedefect => design defect
2014-11-11 11:03ngarciaSummaryDate from non-accessible organizations is obtained in Multidimensional reports => Data from non-accessible organizations is obtained in Multidimensional reports
2014-11-11 11:03ngarciaDescription Updatedbug_revision_view_page.php?rev_id=7013#r7013
2014-12-30 08:27SandrahuguetTarget Version3.0PR15Q1 =>
2015-09-10 09:11alostaleRelationship addedrelated to 0030797

Notes
(0071107)
reinaldoguerra   
2014-10-22 04:56   
Test plan used:
1- Login into Openbravo ERP as F&B International Group Admin
2- Go to Role window and edit "F&B España, S.A - Procurement" role. Set user level as "Organization",
3- Go to "Org Access" tab and delete records for "España" and "España sur" so role only has access to "España Norte" organization.
4- Log out and log in again with "F&B España, S.A - Procurement" role
5- Go to "Purchase Dimensional Report" and realize that in Organization combo you are able to see only organizations accessed by logged role, in this case: "España Norte".
6- Select From Date and To Date fields, also "España Norte" organization and fill dimensions filter with Business Partner and Product options.
7- Launch report and realize that records are filtered by Business partner and Products defined for "España Norte" organization.
8- Check Comparative Report option and insert reference dates.
9- Select product in dimesions filter.
9- Launch report and realize that fields and their references are filtered for selected organization.