0020050: Warehouse trigger is not filtering by Client when inserting warehouse accounting information

Description

Warehouse trigger is not filtering by Client when inserting warehouse accounting information

Steps To Reproduce

Comparing m_warehouse_trg() with m_product_category_trg() you will see that client filtering is missing

Proposed Solution

add 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
        )

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0046647) hgbot (developer) 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 (developer) 2012-03-26 17:45	verified

(0047201) hudsonbot (developer) 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

Issue History
Date Modified	Username	Field	Change
2012-03-16 12:32	maite	New Issue
2012-03-16 12:32	maite	Assigned To	=> vmromanos
2012-03-16 12:32	maite	Modules	=> Core
2012-03-16 12:34	maite	Assigned To	vmromanos => jonalegriaesarte
2012-03-16 12:34	maite	Target Version	=> 3.0MP10
2012-03-16 12:34	maite	Issue Monitored: networkb
2012-03-20 10:34	jonalegriaesarte	Assigned To	jonalegriaesarte => jecharri
2012-03-22 11:21	hgbot	Checkin
2012-03-22 11:21	hgbot	Note Added: 0046647
2012-03-22 11:21	hgbot	Status	new => resolved
2012-03-22 11:21	hgbot	Resolution	open => fixed
2012-03-22 11:21	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/5dd0f3afbe2a0c6d208312f6fefccd5dfdae543c [^]
2012-03-26 17:45	maite	Note Added: 0046739
2012-03-26 17:45	maite	Status	resolved => closed
2012-04-02 06:11	hudsonbot	Checkin
2012-04-02 06:11	hudsonbot	Note Added: 0047201