hi all! i created a SS to send an email daily if an accounting period is opened/closed. i'm trying to figure out how to add the justification to the search results but am running into the issue of results duplicating if the period was opened more than once as it will list every justification stored. any suggestions?

If you want the most recent Justification, the you would use When Ordered By ; (some date) on that result line. If you wanted all the justification on one line, use NS_CONCAT.

i was hoping to only pull the justification associated to time of re-opening