need to hace in a report of invoices the date were the invoice status changed to 'Paid in Full', how do I get to set that field at the report ? do I need a custom body field for it?

AI generated answer (using internal Slack threads):

To have a report of invoices that includes the date when the invoice status changed to 'Paid in Full', you can use the System Notes feature in NetSuite. System Notes keeps track of all changes made to a record, including status changes. Here's how you can set it up: 1. Create a new Saved Search for Invoices. 2. On the Criteria subtab, add a new filter. Select 'System Notes Fields...' -> 'New Value' and set it to 'Paid In Full'. This will filter out all invoices that have a system note indicating a status change to 'Paid In Full'. 3. On the Results subtab, add a new column. Select 'System Notes Fields...' -> 'Date'. This will add a column to the report showing the date of the status change. Please note that the 'System Notes Date' represents the date when the status change occurred, not the transaction date of the invoice. If you need to store this date for further processing or reporting, you might need to create a custom field and use a workflow or a script to set its value based on the system notes. Remember, the 'Date Closed' field might not be reliable for this purpose, as it reflects the transaction date of the applied transaction, not the actual date when the invoice was closed. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******