Related Party Match Off

[nora_m]

Hi,

I am trying to convert the interco data to USD so i can create the match off and netting process. i am having issues with the conversion. can you please help me?

also, can you please help me with how to create the match off process?

[Ar13f]

Dear @nora_m 

what do you mean by the result as below?

if yes, I use the data from you, I just changed a little from the formula you made. I deleted the formula that was colored yellow

please see the attachment I provided. hope this helps you

[RolandSchubert]

Hi @nora_m ,

if I got you right, you want to convert all InterCo data to USD and perform the intercompany matching process by group currency.

Thus, you only need conversion to USD, you can use a Filter tool to select only these rows (TO = USD).

Join can be Entity Currency = From (as To is always USD).

For the matching, I created an additional column  for the expected account name to match (e.g. Income Interest , match with Interest Expense) 

Using a Join tool to match by Entity/Partner Entity and Account/expected Partner Account should give the data you need.

Let me know if it works for you.

Best,

Roland