Report to show prior periods opened?

[Delaney21]

We had an issue this month where an admin opened a prior period and allowed an import to be loaded, without proper approval.  We discovered this during our quarter end procedures because our quarterly results didn't round properly; however, we would like to be able to run a report that would show us the last time periods were opened or closed to ensure we remain SOX compliant.  Is there a report available that would give us this information?  

[EricOsmanski]

When you say open ... do you mean unlocked? uncertified? or do you actually close and open Workflows?

[Delaney21]

I'll take anything I can get, so either a report to show when all historical periods were last unlocked or uncertified.  We had everything certified and locked, and it was unlocked, uncertified, and then data was loaded, certified, and locked.  This was all done without us knowing and we just happened to stumble on it during the following month end. 

We can get the dates it happened by using the "audit workflow" option, but that's only an option if we know a period has been unlocked/uncertified.  We need a report to detect that something has happened after we have certified and locked.  

[EricOsmanski]

The Workflow Status report should give you what you are after:

[Delaney21]

Thanks for the response! It looks like this would work, but can it only be run one period at a time or can it be run for all prior periods at once? 

[EricOsmanski]

This report is a single period at a time so that the report is manageable - if it is all periods at once then the report would become rather large given all the WF's, time periods (12 x number of years), statuses, etc.

It could be modified to include multiple time periods but would need to take into consideration the performance and the report size.