Skip to main content
Newcomer
July 22, 2022

Report to show prior periods opened?

  • July 22, 2022
  • 1 reply
  • 0 views

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?  

    1 reply

    OneStream Employee
    July 26, 2022

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

    Delaney21Author
    Newcomer
    July 26, 2022

    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.  

    OneStream Employee
    July 26, 2022

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

    EricOsmanski_0-1658849494803.png