Intercompany matching report-help

Eugen Melnic
Eugen Melnic Customer
First Anniversary
edited February 2023 in Platform

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!

Answers

  • Previous Member
    Previous Member
    5 Up Votes First Comment 5 Likes First Anniversary

    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

Categories