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
arsengaz
2 years agoNew Contributor
How OneStream eliminates intercompany profit in the inventory?
Hello, I'm trying to figure out a way to have OneStream perform profit in inventory eliminations. Currently we manually compile data in excel to calculate how much profit sitting in the inventory an...
Henning
OneStream Employee
2 years agoHi, as always there are different approaches possible. Some collect the data in the cube and calculate the eliminations in there. The approach I like the most is the Register-based approach. You can set up your custom table or use a marketplace solution where you collect the data, calculate the eliminations based on that and post or load the eliminations into the cube. I like this approach as you can also store the calculated data in a table as well to provide full transparency of your inventory to drill back to or to analyze before posting the eliminations. This is typically used for long term assets, but I guess you can just as well configure this for your inventory as well.
This all very much depends on the exact requirements, so the value of my comment may be limited.
Related Content
- 2 years ago
- 3 years ago
- 2 years ago