We have a situation that a client has two branches and two warehouses. The users of Branch 1 enter Sales Order but want to ship it out Warehouse 2 which is assigned to Branch 2. Because of Role Security, Branch 1 users cannot see warehouse 2 during Order entry. Branch 2 users cannot ship the product either. So if we keep the Order with Branch 1 and Warehouse 1, then how do transfer the product from Warehouse 2 to Warehouse 1 ? Row Level security does not work when there is Branch Role security. We do not want Branch 2 users to see all of the other orders for Branch 1.