The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

prash4030's avatar
prash4030
New Contributor III
2 years ago

No data Zero view property

hello experts, we are using Actuals scenario with default view as YTD. Since it is YTD in nature, P&L accounts show reversal for next period (periodic view). we tried updating the property (see at...
Consolidation
prash4030's avatar
prash4030
New Contributor III
2 years ago

Thanks for your reply. 

In our implementation, we bring GL Actuals every day from Oracle. and then we have few acquisitions integration where we load TBs once in a month, directly in OneStream. we send the entire consolidated data to a downstream system on a daily basis. (from OneStream to Incorta). this has been our main issue where periodic P&L is reversed for acquired company's financials for downstream application until we get TB for next month. in order to avoid this, we end up loading prior period's TB into current month until we get the latest TB.

Any suggestion if this can be avoided? 

 

  • Krishna's avatar
    Krishna
    Valued Contributor
    2 years ago

    prash4030  -  Refer the Below screenshot differences between YTD & Periodic for No Data Zero View for Non-Adjustments. If you are already Live, I would not suggest changing the settings.

    1. You can create a rule formula for the Acquistion entities to reverse it using the flow member so it will be zero until you get the latest TB so you can avoid loading the data into OS.

    2. It can be done in a separate scenario if this is only for the Downstream application changing the settings to periodic.

    Hope this helps. Message me directly if you still want to discuss further. 

     

     

    No Data Zero View for NonAdjustments - Periodic

     

     

     

     

    OutPut

     

     

     

    No Data Zero View for NonAdjustments – YTD