Skip to main content
N
nara_2757
June 6, 2024

Account Lock - Allow Input false

  • June 6, 2024
  • 4 replies
  • 0 views

HI

Am looking to lock the accounts (Rev first and then COGS ), such that if the Rev load is done i should be locking the Rev account for a particular scenario, then lock COGS account based on the Input deadlines. Can anyone help me on this

Regards

Narayana (BOYD Corporation)

4 replies

H
Henning
June 6, 2024

Hi, you will need to use Workflow Channels for that. You set up separate channels, one for Rev, and one for COGS, and assign those to the corresponding accounts as well as WF steps. When the workflow is locked or certified, the accounts that have the same channel assigned as the workflow step will be locked accordingly.

You may also think about using channels on a UD (e.g. Audit) in case you like to split the lock by data collection member in another dimension other than account.

There is a webinar available on OneCommunity as well (Note that the webinar focuses on using WF channels in a UD, but the general concepts are well explained):

Using Workflow Channels & Data Type Dimension - October 2023 - OneStream Community (onestreamsoftware.com)

The documentation should help you with more background information, if needed (what you are looking for is "Account Phasing"):

Workflow Channels (onestream.com)

If you search for Workflow Channels in this community you will also find related questions other people were asking on this, in case you need more inspiration on top of the above information and resources.

N
nara_2757Author
June 6, 2024

Thank you Henning, let me try to use the WF channels to lock the accounts. 

 

N
nara_2757Author
June 6, 2024

A quick question Henning, here the WF wont be locked or certified until the the inputs are done for all the accounts (P&L and BS), will the WF channel set up work to lock an account in this case?

H
Henning
June 6, 2024

Yes, you (/ the users) will have to lock or certify the individual Import (or Forms) steps in order to lock your accounts. Otherwise the system would not know when to lock what.

When you then lock the overall workflow step, that is when the system locks the entire data unit (i.e. the entity that is assigned to the workflow).

N
nara_2757Author
June 6, 2024

Thank you, users will only lock or certify once all their inputs are completed, is there any other option available to lock the accounts for a specific scenario..

 

H
Henning
June 6, 2024

I think there may be a misunderstanding going on. How would you like to lock accounts without locking accounts? Using workflow channels is the way.

E.g. if we use Golfstream.


Henning_0-1717689551245.png

Let us assume the "Import" step is used to import your Rev accounts. After the import, the Import step can be locked.


Henning_1-1717689618398.png

If that has been set up using workflow channels as described, locking only this single import step will lock only the Rev accounts in the WF period and WF scenario the user loaded and locked the Rev data to.

Then, the users can load the COGS data using the - in this not well-chosen example - "Sales Detail" import step. Once done, this single import step can be locked, which will then lock only the COGS accounts.


Henning_3-1717689863477.png

The users can then still load data to accounts that do not share any of the WF channels used for Rev or COGS accounts. Only when the overall step is locked, all data of that scenario / time / entity (simplified) is locked. Such as the step for Feb:


Henning_2-1717689850484.png

 

 

N
nara_2757Author
June 6, 2024

If my understanding is correct i should be creating one Import step for Rev accounts, and one for COGS account. But i assume the users will load every accounts in a single import step, they will not separate their load by Rev or COGS. i was thinking if any Business rule or SQL query could make the Allow Input property of account to False based on a Scenario

Terms & ConditionsAccessibility statement