Intercompany Report for Non-consolidating entities
I am running into an issue with putting together intercompany reports. Basically, if an entity has an intercompany partner that is not a consolidating entity, no elimination would occur at the parent (as expected). However, this pair would still show up on my IC matching report. Has anyone dealt with this type of issue with the IC reporting and has any tips to put me in the right direction?
Elimination Extract
Hi, I am trying to run an elimination export where I am trying to pull data for elimination under a hierarchy. If I am leaving the parent pov blank- I get the below error. Error processing Data Management Step 'Test'. Error processing data. The item was not found. Entity, Parent, -1. What should I do to dynamically pull elimination for a hierarchy.Show Partner Status in a Dashboard
Hi - Is there a way to override security to show the IC Partners' Workflow Statuses in a Dashboard so each workflow can view altogether the status of all Partners? I created a data adapter using a WorkflowAndEntityStatus Method Query but they can only see the Workflows they are in the Access Group of. Can I replicate what is happening behind the scenes in the IC Matching > Show Partner Workflow Status? Thanks in advance to anyone that can help!
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 and at what common parent we need to eliminate it. These manual eliminations are ultimately loaded in OneStream via upload files. One thought is to setup custom input form in the workflows that would collect ins-&-outs of profit in the inventory and utilize Flow dimensionality. But I'm not sure if there is a better approach to this problem.
FX translation for Reporting Currency
Hi All, Need assistance in posting a journal to eliminate the difference. I tried posting a journal using reporting currency (ZAR) to eliminate the difference, but it's not going through. The translation should be periodic. Anyone have any idea what I'm missing?IC Setup - Time Constrained or Not
We just went live with our IC setup (ie providing the plug account - We had already required a valid partner prior to adding the plug). Works GREAT! The issue/question we have now found ourselves in is that these feature is not time constrained like formula’s or other features. We decided that we needed to split a statistical volume value into two groups and wanted to go back in to a prior year to get year over year comparisons. At this point we realized that once we make any change to an Entity, when we re-consolidate, IC kicks in and hoses up our Financials. Outside of removing all plug accounts, making change, consolidating and adding the plug accounts back, we can’t update our prior period Statistical accounts. Anybody know of a work around or is this going to be fixed in the future similar to how formalus are handled. ClarkeA intercompany code from our GL is not being validated during our manual ledger load.
Originally posted by Charlotte Mikes We see it in the data import but it goes to none when it get validated. The IC code has been set up in the IC dimension. I don't know where to go look to find out why the IC code load but during transformation/validation it go to none
