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...
Forum Discussion
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?
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
