01-12-2023
10:02 AM
- last edited on
05-03-2023
09:10 AM
by
JackLacava
Hi,
After the reporting units have reported and certified their workflows. We need to post a group journal that affects almost all reporting units (this cannot be done earlier in the process). How is this possible without having to un-certify all companies and unlock descendants etc.
There must be a simple way to post a group journal without touching the certified status of a reporting unit.
Please advice.
Thanks!
01-12-2023 11:14 AM - edited 01-12-2023 11:20 AM
Technically what gets locked is the Workflow Unit, not the actual data. The data is still editable from business rules, so if you want to bypass the workflow status, you'll have to head in the direction of custom code - like an Extensibility Rule triggered by a Data Management job.
In there, you could try using brapi.data.ImportAndProcessJournals; there is a snippet showing how to do it, called "Load Journal Details".
There are probably other ways to address this (in OneStream, there are at least 2 different ways to do anything...), with some clever metadata handling (like copying consolidated data to a base entity somewhere else, and amend that), but if the snippet works I'd just go with that.
09-18-2023 02:30 PM
Can you confirm this still works? I was able to get the ImportAndProcessJournals to load and post from a data management sequence when the workflow was not certified. I keep getting an error if the workflow parent has been certified. "Parent workflow profile is certified"
01-12-2023 12:24 PM
Currently, the only workaround we found was to not certify on the workflow itself, but just the import/forms steps. Or to create a special certification step, which does not impact the adjustment layer. The entity workflows should be closed centrally after doing the group adjustments.
Also, the OwnerPostAdj/OwnerPreAdj should not be impacted by certifying local data. But that is a change request.
01-16-2023 03:30 AM
You can create different members in Custom dimensions for markets and for group and assign the workflow channels for each member and the work flow's.