Data Filtering

yes u can indeed do it. let me explain you the stepwise proc:

1. in user setup table create a new field Branch code
2. in code unit 5700 ie user setup mgmt look at function GetSalesFilter(). u need to create a similar function for you field viz branch code or location.
3. then u need to write the following kind of code on the onopenform trigger of all your forms that need to filter location wise.

IF UserMgt.GetSalesFilter() <> '' THEN BEGIN
  FILTERGROUP(2);
  SETRANGE("Responsibility Center",UserMgt.GetSalesFilter());
  FILTERGROUP(0);
END;

after finishing the above steps all you have to do is define the user id in table 91 ie User Setup and also the branch each id is related to. for any person whom the filter should not apply leave the branch field blank in table91.

Hi uday,
if u want to filter balances and other data branch/division wise, then u have to create a new field in the respective tables. there is no other way the system can differentiate entries unless you tell it which entry belongs to which branch/division. so u create a new field and pass the field while posting of entiries into the tables. for forms you can use the filter group code...and for reprts you have to give a text variable which can lookup your branch/division list and u can pass that as a filter to the dataitem in your reports.
if each user needs to c only his division in the lookup for the division list, GET the branch code of user from user setup table and then use the filter group code in the onlookup trigger of that variable.

hope this helps.


regards

sri