Hi everyone just wanted to double check if anyone has managed to stop the financial statement and COA Balance by dimension form from showing dimensions that are supposedly not available for a user I have set RLS on ledtrans, ledgerbalancedim etc and even tried to set on the TmpAccountSum table but it seems there is no way to stop the user from seeing? So before I keep trying further just wondered has anyone had any success in these areas? I guess I could remove access to the standard forms for balance by dimension and make a new form that I can control it but for financial statement report its something I dont think I can easily replace (unless I do some OLAP or external report that can achieve the same matrix style formating as FS). Both of these are far from ideal :( Also anyone come across other places teh RLS will not work for inventory dimension or financial dimension since the plan would be to use it to filter data for a particular site? Thanks James
