Customizing OpenAir User Access Using the NetSuite Connector

When using the NetSuite Connector to create new users in OpenAir, it’s possible to customize the Primary Filter Set assigned for a user.  This eliminates the need for manual updates to the user’s filter set.

This feature is dependent on having an identifier in NetSuite.  Then a user’s access in OpenAir can be mapped to the field value in NetSuite.

For instance, if a user is identified as Time and Expense in NetSuite in a field and that maps to T&E user Primary Filter Set in OpenAir, then an IF/THEN advanced mapping can populate the filter in OpenAir.

The Advanced Mapping in OpenAir looks as follows:

 

Example of an IF/THEN statement:

 

#  All IF Definitions

 

NS_FIELDS custentity_user_access

NS_CUSTOM_FIELDS custentity_user_access

OA_FIELDS primary_filter_set

IF <<END

IF (custentity_user_access = ‘1’) THEN primary_filter_set ‘2′

END