Related Party Accounts- IC Matching
We have a bunch of related party accounts that need to equal other locations within the company similar to intercompany. It would be nice if this can be added to the IC matching table that is on the workflow. I do not want these to eliminate but have visibility to the locations that these accounts are out of balance. Has anyone dealt with something similar to this and if so how do you go about it?
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. Clarke
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 Flowdimensionality. 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 Matching Reports/Dashboards not showing Parent currency adjustment values
Hello Everyone. We are having some issues with IC Matching Standard Dashboards and unable to find a root cause - not sure if this is a Bug. Intercompany Matching criteria is Set to Parent currency and all other dimensions at Top, However when we post a journals in Parent currency with a partner this matching Dashboard does not consider this Journal line Item for IC matching and none of the Dashboards shows that. Please help with any insight you have or if you had seen any workaround for the same. Thanks in Advance ! SatishA 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
