Skip to Content
0
Former Member
Dec 07, 2016 at 04:15 PM

IC matching report

263 Views

Hi all,

We have an IC matching report that shows in rows ENTITY, INTCO, ACCOUNT and in columns amounts, first the amount reported by the entity and then the amount reported by the partner. So an example could be

ENTITY A - PARTNER B - IC payables : entity : 1000 - partner : 1005

ENTITY A - PARTNER C - IC receivables: entity : 2000 - partner : 2000

...

This works fine when I let the user select an individual entity. The report will show, for the selected entity, all partner data.

However, when I run this from a group point of view by selecting all base members of my group node in the entity structure, I get every amount twice. In the above example I would get the row shown:

ENTITY A - PARTNER B - IC payables : entity : 1000 - partner : 1005

and further down in the report I would get

ENTITY B - PARTNER A - IC receivables : entity : 1005 - partner : 1000

Is there a way to create a report that shows

for the first entity all partner companies
for the second entity all partner companies apart from the first
...

Let's say I have 3 companies, A, B and C I would like to see

A vs B
A vs C
B vs C

what I currently get is

A vs B
A vs C
B vs A
B vs C
C vs A
C vs B

Ideally I would like this to be a dynamic report, so if I add a company the report automatically updates.

Thanks,
Arnold