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
RonnieKarpinsk
2 years agoNew Contributor III
OneStream Final Balances
Hello,
I am looking to connect with any OneStream customers who are using OneStream as the source for their final trial balances. Currently we book a few top-sided entries in OneStream and then pus...
TimVierhout
2 years agoNew Contributor III
Hi,
We are actually doing this for all of our customers. First note: The figures you pull from the ERP system should always be balanced!
How this could be configured in OneStream: We generally configure this in a UD dimension; in our default setup, this is UD1. In this UD, we are distinct by where the data is coming from. There is a member for Local input (usually a combination of import from the ERP + some entries done using cube views). On top of that, there are more UDs, which, in general, are journals that are posted for top-sided adjustments. This way, you can distinguish what was done in Onestream from what is coming from the local ERP.
When implementing this, I always propose a few best practices or rules:
- No entries in parents in the entity dimension.
- Try to keep the bookings to a minimum. Your current approach (everything is posted in the ERP) is, for me, the best practice.
With kind regards,
Tim
Related Content
- 4 months ago