ADempiere ERP Business Suite

hi, i have business case: user has one role and has access to one-own organisation, but need to see other warehouse on hand quantities, transactions not. looking form solution with two assigned roles. 1 for standard acess "salesman" second as see all warehouses. looks my direction is wrong. any experience ? nbe222

Can you not just define read only access to the additional Org/warehouses? i.e. in the Role window Org Access tab colin

If you set this Role's access in the Role window Org Access tab means all data access with this Role. We add virtual field show other Org/Warehouse's on hand for this Role. for Big site enterprise, we need more flexibility. we Have serveral case customization for function like this.

Not sure if it is exactly what you want but in Compiere, I used the following workaround: Create a Window thats a view. In SQL change the Org to match the security role for the warehouses that the user does have access to. In our case, we have two orgs. We force the user to log in and log out for data entry and preventing errors. However, they do need to be able to look up product information and inventory. So a simple view in the database that changes the Org provides read only view in a window. ex: user has access to AD_ORG_ID=1 needs read only visibility in our window for AD_ORG_ID=2 in oracle Select CASE when ad_org_id= 2 THEN AD_ORG_ID=1 ELSE AD_ORG_ID END AS AD_ORG_ID, (ADD ALL YOUR OTHER FIELDS) FROM M_STORAGE s Not sure if it would work in Adempiere but if security is still similar to Compiere, this work around should work.