AnsweredAssumed Answered

Intercompany matching report-help

Question asked by eugen.melnic on Jun 21, 2019
Latest reply on Jun 27, 2019 by raym

Hi All,

 

I want to build Intercompany matching report that shows differences between counterparts.

What we currently have:

- Legal entity UK reported IC payable to DE of £100 (DE payable is reported via nominal account);

- Legal entity DE reported IC receivable from UK of £90 (UK receivable is reported via a nominal account);

- there is no relationship between the 2 dimensions Legal Entity and Nominal

 

What I want to achieve is a report that will match both of the above and for the pair UK-DE / DE-UK show the variance which in this case is £10.

 

How can I achieve it?

 

Thank you!

Outcomes