How do i pull a list of permissions and their ID. For example the permission name for Permission id ADMI_ACCTPERIODS.1

AI generated answer (using internal Slack threads):

To pull a list of permissions and their IDs, you can create a Role Search in NetSuite. Here's how you can do it: 1. Go to

Reports > New Search

. 2. Select

Role

from the list. 3. In the

Criteria

tab, you can add specific criteria to limit the roles you want to see. For example, you can add criteria for

Login Access = T

and

Inactive= F

to get a list of every active user with login access. 4. In the

Results

tab, add the fields you want to see in the results. For example, you can add

Role

,

Permission

, and

Level

. 5. You can also add a filter for the

Permissions

to see which roles have which level at each permission. To get the type of each permission, you can add a formula field in the

Results

tab with the following formula:

sql
CASE 
  WHEN {permission.id} LIKE '%CUSTRECORDENTRY%' THEN 'Custom Record' 
  WHEN {permission.id} LIKE 'ADMI%' THEN 'Setup' 
  WHEN {permission.id} LIKE 'LIST%' THEN 'List' 
  WHEN {permission.id} LIKE 'REGT%' THEN 'List' 
  WHEN {permission.id} LIKE 'REPO%' THEN 'Reports' 
  WHEN {permission.id} LIKE 'TRAN%' THEN 'Transaction' 
  WHEN {permission.id} LIKE 'GRAP%' THEN 'Reports' 
  ELSE 'Custom Record' 
END

This formula will categorize each permission into 'Custom Record', 'Setup', 'List', 'Reports', or 'Transaction' based on the prefix of the permission ID. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******