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
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?
4 Replies
Since you don't want to eliminate the activity, I would try to solve it with 2 UD's if that's an option for you. One party writes to a location in UD6 lets call it Location1_In, and the other side books to Location1_Out in UD7... both use the same related party account. Then you can see if you are out at the top at the account vs Total_Location_In (UD6) and Total_Location_Out (UD7). If they balance you're good, else you can drill in and compare the Locations to see where the activity was mis-booked.
Hello KWOLF, we had similar requirements and used the Std data adapter method for Ic Matching, which runs on top of all dimensions except UD1 where we say run on U1#All and this gives an overview of plug by UD1`
However this is not working on the same step as you mentioned it should be a separate form member in a Forms WFP.
Hope this helps.
Thanks
Satish
I'm not as experienced with dashboards but what would you put as your method query?
{|WFProfile|}{|WFScenario|}{|WFTime|}{all plug accounts e.g.P100,P200,P300}{}{}{}{All}{}{}{F#TopFlow:O#Top:U1#All:U2#TopUD2:U3#TopUD3:U4#TopUD4:U5#TopUD5:U6#TopUD6:U7#TopUD7:U8#None}{}
Sorry for delayed response
