NSC | Saved Search to track when an Item was added to a Work Order after it was already Released

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:

• Criteria > Standard

• Criteria > Summary

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)

• Results tab

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.