Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0017969
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupmajoralways2011-07-12 14:412012-02-15 15:48
ReporterdalsasuaView Statuspublic 
Assigned Tojecharri 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision1c281d64b1dc
ProjectionnoneETAnoneTarget Version3.0MP3
OSLinux 32 bitDatabaseOracleJava version1.6.0_21
OS VersionUbuntu 10.10Database version11.2.0 SEAnt version1.8.0
Product Version3.0MP1SCM revision 
Review Assigned To
Web browserGoogle Chrome, Internet Explorer, Mozilla Firefox
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0017969: 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
           ]]>
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 00179702.50MP31 closedjonalegriaesarte Enterprise Module Management is not working fine with * organization. 
related to defect 0019769pi closededuardo_Argal You cannot select a dataset through Enterprise module management with client/organization access level 

-  Notes
(0040432)
hgbot (developer)
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 (developer)
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 (reporter)
2011-09-01 09:24

 Verified

- Issue History
Date Modified Username Field Change
2011-07-12 14:41 dalsasua New Issue
2011-07-12 14:41 dalsasua Assigned To => dalsasua
2011-07-12 14:41 dalsasua Web browser => Google Chrome, Internet Explorer, Mozilla Firefox
2011-07-12 14:41 dalsasua Modules => Core
2011-07-12 14:41 dalsasua Resolution time => 1312581600
2011-07-12 14:48 dalsasua Status new => scheduled
2011-07-12 14:48 dalsasua fix_in_branch => pi
2011-07-14 12:15 dalsasua Web browser Google Chrome, Internet Explorer, Mozilla Firefox => Google Chrome, Internet Explorer, Mozilla Firefox
2011-07-14 12:15 dalsasua fix_in_branch pi =>
2011-07-14 12:15 dalsasua Description Updated View Revisions
2011-07-14 12:15 dalsasua Proposed Solution updated
2011-07-14 12:15 dalsasua Issue Monitored: networkb
2011-07-20 18:08 dalsasua Assigned To dalsasua => jonalegriaesarte
2011-08-22 09:47 jonalegriaesarte Web browser Google Chrome, Internet Explorer, Mozilla Firefox => Google Chrome, Internet Explorer, Mozilla Firefox
2011-08-22 09:47 jonalegriaesarte version 2.50MP31 => 3.0MP1
2011-08-22 09:47 jonalegriaesarte Target Version 2.50MP31 => 3.0MP3
2011-08-23 08:03 hgbot Checkin
2011-08-23 08:03 hgbot Note Added: 0040432
2011-08-23 08:03 hgbot Status scheduled => resolved
2011-08-23 08:03 hgbot Resolution open => fixed
2011-08-23 08:03 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1c281d64b1dc367eb4922c7e43361ebad814d91b [^]
2011-08-24 01:08 hudsonbot Checkin
2011-08-24 01:08 hudsonbot Note Added: 0040465
2011-09-01 09:24 jonalegriaesarte Assigned To jonalegriaesarte => jecharri
2011-09-01 09:24 jonalegriaesarte Note Added: 0040647
2011-09-01 09:24 jonalegriaesarte Status resolved => closed
2011-09-01 09:24 jonalegriaesarte Fixed in Version => 3.0MP3
2012-02-14 18:59 psarobe Status closed => new
2012-02-14 18:59 psarobe Resolution fixed => open
2012-02-14 18:59 psarobe Fixed in Version 3.0MP3 =>
2012-02-15 15:47 psarobe Status new => scheduled
2012-02-15 15:47 psarobe fix_in_branch => pi
2012-02-15 15:48 psarobe Status scheduled => resolved
2012-02-15 15:48 psarobe Resolution open => fixed
2012-02-15 15:48 psarobe Status resolved => closed
2012-02-15 15:49 psarobe Relationship added related to 0019769

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker