lastmodifieddate lastmodifiedby

AI generated answer (using internal Slack threads):

Based on the conversations, the

lastmodifieddate

and

lastmodifiedby

fields in NetSuite are automatically updated whenever a record is modified. This includes both manual changes by a user and automated changes by a script or workflow. However, when a scheduled script modifies a record, the

lastmodifiedby

field does not change to reflect the script or the script owner, but remains as the user who last manually modified the record. This behavior is by design and cannot be changed. If you need more control over these fields for auditing purposes, you could create your own custom fields to track the last modification date and user. You could then use a workflow or script to update these fields whenever a record is saved. This would allow you to differentiate between changes made by users and changes made by scripts. For capturing the 'Last Modified By' in a saved search, you can sort a transaction search with the criteria MAX on date and find the newest SET BY. However, this might not work for all transactions. An alternative approach would be to create a workflow that triggers on create/edit before record save and sets a custom 'Last modified by' field to the current user. Please note that the 'last modified date' can change even if a record is opened in edit mode and saved without making any changes. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******