how to hide columns from the stock ledger report based on roles in netsuite

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the best way to hide columns from the stock ledger report based on roles in NetSuite is to use a combination of custom forms and role restrictions. Here are the steps: 1. Create a custom form for the stock ledger report and hide the columns you don't want certain roles to see. This can be done by going to the form customization options and deselecting the columns you want to hide. 2. Assign this custom form to the roles that should not see the hidden columns. This can be done in the role settings, where you can set the custom form as the preferred form for the role. 3. Make sure to check the "Restricted" box in the role settings. This will restrict the role to only viewing the stock ledger report with the custom form, ensuring that they cannot see the hidden columns even if they switch to a different form. Please note that this method may not work for all columns, as some columns may not be available for hiding in the form customization options. In such cases, you may need to use a beforeLoad user event script to hide the columns based on the role. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******