Discussions

Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Update your Profile with your Support type to get your Support Type badge.
Community Poll: What sort of content would you like to see more of?

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

Community Whiz

Quarter 2 ((Apr-Jun 2024) )

This Week's Leaders

This Month's Leaders

All Time Leaders