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?