How to filter accounts based on sales account type field using access group or custom predicates

Summary:

How to filter accounts based on sales account type field using access group or custom predicates

Content (required):

Hi All,

We have requirement to have different types of HZ_Party records . Customer, Prospect and supplier. We have to ensure that user with Supplier role can only see account with Salesprofiletype = Supplier and they should not see any other types of accounts like customer or prospect.

TO achieve this we tried custom predicate as below

Name : CUSTOM_SDH_01_SUPPLIER

Display Name : Custom SDH Access the sales party for table HZ_PARTIES for all Supplier

Description : created custom predicate for SDH supplier only records