When a record reaches a certain status (e.g., "App...
# ask-stanley-ai
m
When a record reaches a certain status (e.g., "Approved"), we want the entire record to become read-only, except for a few specific fields (e.g., “Comments” or “Memo”). Is there a native way in NetSuite to lock a record entirely except for certain fields? Or would this have to be handled via scripting (e.g., Client Script or User Event) by manually blocking edits on all other fields?
c
AI generated answer (using internal Slack threads):
Based on the conversations, there isn't a native way in NetSuite to lock a record entirely except for certain fields when it reaches a certain status like "Approved". This would have to be handled via scripting (e.g., Client Script or User Event) by manually blocking edits on all other fields. One approach could be to use a workflow and an additional custom form. The form would have most fields set to Inline or disabled and the workflow could set the form before record load based on the user or user role and the approval status. However, this approach might have limitations depending on the number of fields you want to lock down, the type of field, and if the periods are closed. Another approach could be to create a custom record with internal IDs of the fields that you want to disable and then fetch the IDs through Script and disable them. This way if you want to disable any new field in future, you can just add it in the custom record. However, these methods have their limitations and might not work for all fields, especially line level fields. For line level fields, you might need to use a script to lock the record and create a custom record type that sits on top of the bill and use SuiteScript to modify the underlying record. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.842088282
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.83681941
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.833280206
Please provide your feedback on this answer.