Intercompany matching report-help

Eugen Melnic

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!

Previous Member

Hi Eugen Melnic,

something you could do:

1. entity "from"
2. entity "to"
3. cube "payables" on the two entities
4. cube "receivables" on the two entities
5. layout with "from" on rows and "to" on columns
6. 2 blocks with the cubes "payables" and "receivables", both hidden
7. 1 algorithm block as a sum of the first two.

Now you should have a matrix of the sums

 

If up until now, you have the data only with single entities "from-to", then I suggest, you adapt your datareader with some ETL in order to transform the single entity to two entities.

BR, Ray