Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017969Openbravo ERP01. General setuppublic2011-07-12 14:412012-02-15 15:48
Reporterdalsasua 
Assigned Tojecharri 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 10.10
Product Version3.0MP1 
Target Version3.0MP3Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browserGoogle Chrome, Internet Explorer, Mozilla Firefox
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017969: Enterprise Module Management is not working fine with * organization.
Description- Enterprise Module Management provides modules that shouldn't, as are already applied in * organization.
- Furthermore: accounting module shouldn't appear to be applied.
Steps To Reproduce- As System Admin:
- go to Initial Client Setup
- choose as name 'Cliente'
- do NOT choose any reference data item (datasets). Specially, do NOT activate Initial Setup dataset from core module.
- change role to the new client
- run initial organization setup, and create a new legal entity withOUT acconting, with name Org
- set Org organization as ready
- go to enterprise module management
- apply core dataset to * organization
- go to Module window
- change version for module Core to a higher version number (activating in development flag)
- go to enterprise module management
- choose Org organization
- realize that the core module is provided to be applied
** This is wrong: core dataset has been already applied to * organization, so shouldn't be allowed to apply it to any other organization of the client, as all of them are bellow * organization in the organizational tree.
Proposed Solutiondiff --git a/src/org/openbravo/erpCommon/modules/ModuleReferenceDataOrgTree_data.xsql b/src/org/openbravo/erpCommon/modules/ModuleReferenceDataOrgTree_data.xsql
--- a/src/org/openbravo/erpCommon/modules/ModuleReferenceDataOrgTree_data.xsql
+++ b/src/org/openbravo/erpCommon/modules/ModuleReferenceDataOrgTree_data.xsql
@@ -53,12 +53,12 @@
             WHERE M.TYPE = 'M'
             AND M.ISACTIVE = 'Y'
             AND 1=1
- AND ((EXISTS (SELECT 1 FROM ad_dataset
+ AND (EXISTS (SELECT 1 FROM ad_dataset
                             WHERE M.ad_module_id = AD_DATASET.ad_module_id
                             AND AD_DATASET.ACCESSLEVEL IN ('3','1')
                             AND AD_DATASET.EXPORTALLOWED = 'Y')
- AND M.HASREFERENCEDATA = 'Y')
- OR M.haschartofaccounts = 'Y')
+ AND M.HASREFERENCEDATA = 'Y'
+ AND M.HASCHARTOFACCOUNTS = 'N')
             AND NOT EXISTS (SELECT 1 FROM AD_CLIENTMODULE CM
                     WHERE CM.ad_module_id = M.ad_module_id
                     AND AD_CLIENT_ID = ?)
@@ -87,6 +87,7 @@
             AND 1=1
             AND M.HASREFERENCEDATA = 'Y'
             AND EXPORTALLOWED = 'Y'
+ AND M.HASCHARTOFACCOUNTS = 'N'
             AND NOT EXISTS (SELECT 1 FROM AD_CLIENTMODULE CM
                             WHERE CM.ad_module_id = M.ad_module_id
                             AND CM.AD_CLIENT_ID = ?
@@ -97,7 +98,7 @@
                             AND (AD_IsOrgIncluded(?, OM.AD_Org_ID, OM.AD_Client_ID)<>-1
                             OR AD_IsOrgIncluded(OM.AD_Org_ID, ?, OM.AD_Client_ID)<>-1)
                             AND OM.VERSION = M.VERSION)
- AND (((? <> '0') AND AD_DATASET.ACCESSLEVEL IN ('1', '3'))
+ AND (((? <> '0') AND AD_DATASET.ACCESSLEVEL IN ('1'))
                 OR ((? = '0') AND AD_DATASET.ACCESSLEVEL IN ('3', '6')))) A
           ORDER BY A.SeqNo
           ]]>
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00179702.50MP31 closed jonalegriaesarte Enterprise Module Management is not working fine with * organization. 
related to defect 0019769pi closed eduardo_Argal You cannot select a dataset through Enterprise module management with client/organization access level 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-07-12 14:41dalsasuaNew Issue
2011-07-12 14:41dalsasuaAssigned To => dalsasua
2011-07-12 14:41dalsasuaWeb browser => Google Chrome, Internet Explorer, Mozilla Firefox
2011-07-12 14:41dalsasuaModules => Core
2011-07-12 14:41dalsasuaResolution time => 1312581600
2011-07-12 14:48dalsasuaStatusnew => scheduled
2011-07-12 14:48dalsasuafix_in_branch => pi
2011-07-14 12:15dalsasuaWeb browserGoogle Chrome, Internet Explorer, Mozilla Firefox => Google Chrome, Internet Explorer, Mozilla Firefox
2011-07-14 12:15dalsasuafix_in_branchpi =>
2011-07-14 12:15dalsasuaDescription Updatedbug_revision_view_page.php?rev_id=2414#r2414
2011-07-14 12:15dalsasuaProposed Solution updated
2011-07-14 12:15dalsasuaIssue Monitored: networkb
2011-07-20 18:08dalsasuaAssigned Todalsasua => jonalegriaesarte
2011-08-22 09:47jonalegriaesarteWeb browserGoogle Chrome, Internet Explorer, Mozilla Firefox => Google Chrome, Internet Explorer, Mozilla Firefox
2011-08-22 09:47jonalegriaesarteversion2.50MP31 => 3.0MP1
2011-08-22 09:47jonalegriaesarteTarget Version2.50MP31 => 3.0MP3
2011-08-23 08:03hgbotCheckin
2011-08-23 08:03hgbotNote Added: 0040432
2011-08-23 08:03hgbotStatusscheduled => resolved
2011-08-23 08:03hgbotResolutionopen => fixed
2011-08-23 08:03hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1c281d64b1dc367eb4922c7e43361ebad814d91b [^]
2011-08-24 01:08hudsonbotCheckin
2011-08-24 01:08hudsonbotNote Added: 0040465
2011-09-01 09:24jonalegriaesarteAssigned Tojonalegriaesarte => jecharri
2011-09-01 09:24jonalegriaesarteNote Added: 0040647
2011-09-01 09:24jonalegriaesarteStatusresolved => closed
2011-09-01 09:24jonalegriaesarteFixed in Version => 3.0MP3
2012-02-14 18:59psarobeStatusclosed => new
2012-02-14 18:59psarobeResolutionfixed => open
2012-02-14 18:59psarobeFixed in Version3.0MP3 =>
2012-02-15 15:47psarobeStatusnew => scheduled
2012-02-15 15:47psarobefix_in_branch => pi
2012-02-15 15:48psarobeStatusscheduled => resolved
2012-02-15 15:48psarobeResolutionopen => fixed
2012-02-15 15:48psarobeStatusresolved => closed
2012-02-15 15:49psarobeRelationship addedrelated to 0019769

Notes
(0040432)
hgbot   
2011-08-23 08:03   
Repository: erp/devel/pi
Changeset: 1c281d64b1dc367eb4922c7e43361ebad814d91b
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Mon Aug 22 09:51:20 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1c281d64b1dc367eb4922c7e43361ebad814d91b [^]

Fixes issue 17969: Ent.Mod.Management is not working ok

---
M src/org/openbravo/erpCommon/modules/ModuleReferenceDataOrgTree_data.xsql
---
(0040465)
hudsonbot   
2011-08-24 01:08   
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/ae0285ee1597 [^]

Maturity status: Test
(0040647)
jonalegriaesarte   
2011-09-01 09:24   
Verified