SETPERMISSIONFILTER SQL

icarus1306

Hello,

I have a permission group that has the Item Table with a filter only to show Items with a Product Group Code of say A.

When I logon as this user and select Sales Orders I only want to see Items listed on the order that meet this criteria. Presently I get permission read errors as it tries to show items that I don't have permission to see.

I understand the above feature can be used to limit results. Can you confirm whether this could be used to limit Items shown on Sales Orders and if so where and what code would I need to specify.

Thanks