Skip to main content
Contributor
December 1, 2023
Solved

Workflow Status for the whole year

  • December 1, 2023
  • 1 reply
  • 0 views

We have a client that does a lot of prior period adjustments so they go through the workflow for the whole year a few times. We have automation set up to assist, however they would like a report that shows the workflow status for the whole year and not just one period. I know the application reports are out of the bos that shows a particular month throught method queries. That works great but has anyone ever created one that would pull the whole year? I was looking for a sub variable that does that but cant seem to find one or has anyone done anything different. 

Much Appreciated!

Best answer by JackLacava

Have you tried WorkflowStatusTwelvePeriod?

JackLacava_1-1701772169671.png

The output contains columns with the state for each period:

JackLacava_2-1701772219182.png

Would that be ok?

 

1 reply

OneStream Employee
December 5, 2023

Have you tried WorkflowStatusTwelvePeriod?

JackLacava_1-1701772169671.png

The output contains columns with the state for each period:

JackLacava_2-1701772219182.png

Would that be ok?

 

Contributor
December 6, 2023

Hey Jack, didnt even know that was an option. Must be for newer versions. I can build off this, this is great. Thanks!