Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020050Openbravo ERP04. Warehouse managementpublic2012-03-16 12:322012-04-02 06:11
Reportermaite 
Assigned Tojecharri 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP10Fixed 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
Summary0020050: Warehouse trigger is not filtering by Client when inserting warehouse accounting information
DescriptionWarehouse trigger is not filtering by Client when inserting warehouse accounting information
Steps To ReproduceComparing m_warehouse_trg() with m_product_category_trg() you will see that client filtering is missing
Proposed Solutionadd clause
AND AD_Org_AcctSchema.AD_Client_ID=new.AD_Client_ID in query
in Cur_Defaults in m_warehouse_trg()

Cur_Defaults should remain as follows:
SELECT *
      FROM C_AcctSchema_Default d
      WHERE EXISTS
        (
      SELECT 1
      FROM AD_Org_AcctSchema
      WHERE (AD_IsOrgIncluded(AD_Org_ID, new.AD_ORG_ID, new.AD_Client_ID)<>-1
          OR AD_IsOrgIncluded(new.AD_Org_ID, AD_ORG_ID, new.AD_Client_ID)<>-1)
      AND IsActive = 'Y'
      AND AD_Org_AcctSchema.C_AcctSchema_ID = d.C_AcctSchema_ID
      AND AD_Org_AcctSchema.AD_Client_ID=new.AD_Client_ID
        )
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-03-16 12:32maiteNew Issue
2012-03-16 12:32maiteAssigned To => vmromanos
2012-03-16 12:32maiteModules => Core
2012-03-16 12:34maiteAssigned Tovmromanos => jonalegriaesarte
2012-03-16 12:34maiteTarget Version => 3.0MP10
2012-03-16 12:34maiteIssue Monitored: networkb
2012-03-20 10:34jonalegriaesarteAssigned Tojonalegriaesarte => jecharri
2012-03-22 11:21hgbotCheckin
2012-03-22 11:21hgbotNote Added: 0046647
2012-03-22 11:21hgbotStatusnew => resolved
2012-03-22 11:21hgbotResolutionopen => fixed
2012-03-22 11:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5dd0f3afbe2a0c6d208312f6fefccd5dfdae543c [^]
2012-03-26 17:45maiteNote Added: 0046739
2012-03-26 17:45maiteStatusresolved => closed
2012-04-02 06:11hudsonbotCheckin
2012-04-02 06:11hudsonbotNote Added: 0047201

Notes
(0046647)
hgbot   
2012-03-22 11:21   
Repository: erp/devel/pi
Changeset: 5dd0f3afbe2a0c6d208312f6fefccd5dfdae543c
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Thu Mar 22 11:20:46 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/5dd0f3afbe2a0c6d208312f6fefccd5dfdae543c [^]

Fixes issue 20050: Warehouse trigger is not filtering by Client
when inserting warehouse accounting information

---
M src-db/database/model/triggers/M_WAREHOUSE_TRG.xml
---
(0046739)
maite   
2012-03-26 17:45   
verified
(0047201)
hudsonbot   
2012-04-02 06:11   
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/7814864461ac [^]

Maturity status: Test