Scenario
User needs a way to track when an Item (Component) was added to a Work Order after it was already released.
Solution
There isn't a standard report for this one, but here's a Transaction Saved Search you can try:
Formula used: NS_CONCAT(CASE WHEN TO_CHAR({linesystemnotes.date}, 'MM/DD/YYYY HH24:MI') <> TO_CHAR({datecreated}, 'MM/DD/YYYY HH24:MI') THEN 1 ELSE 0 END)
Formula for Line System Notes Date: TO_CHAR({linesystemnotes.date}, 'MM/DD/YYYY HH24:MI')
Formula for Date Created: TO_CHAR({datecreated}, 'MM/DD/YYYY HH24:MI')
Alternatively, you can also use the Line System Notes: Date and Date Created fields in the Results tab.
Using this search, we are able to get those item lines that do not have the same line system notes date as the date created. However, this will also include those that have components added in late (even by just a minute) or if the line was not saved at the exact same time as the creation date/time.
An example is if you have some integrations or if saving the transaction was just slow resulting to the line system notes date and the date created to not be the same.
Another formula you can use in the Criteria > Summary is:
NS_CONCAT(CASE WHEN TO_CHAR({linesystemnotes.date}, 'MM/DD/YYYY') <> TO_CHAR({datecreated}, 'MM/DD/YYYY') THEN 1 ELSE 0 END)
This formula just compares the Line System Notes Date and the Date Created and no longer considers the time.
Disclaimer: The NS_CONCAT function is not officially supported by NetSuite. Furthermore, result values for formula fields containing the NS_CONCAT function are limited to 4000 characters. Use this function at your own discretion.
-----
If you find this information useful, let us know by reacting or commenting on this post!