Skip to main content
Newcomer
Oct 13, 2022 12:55 PM UTC

Intercompany Report

HI

 

I have been asked by our Finance team to build a report that summarises intercompany variances to speed up the hunt for mismatches. We use the current out of the box interco reports but they want something quicker and easier to use. Just wondered if anyone else has used/built something similar ?

Thanks

Tahir

7 replies

Newcomer
Oct 13, 2022 12:58 PM UTC

I believe there is an intercompany Dashboard as well. 

Tahir2061Author
Newcomer
Oct 13, 2022 1:30 PM UTC

Thanks yes I have seen those reports - they want something more summarised and take away the fun of hunting of mismatches!

Contributor
Oct 13, 2022 1:20 PM UTC

Another option is to create a dashboard/ reporting solution useing the ICMatchingforWorkflowUnit method query.

Tahir2061Author
Newcomer
Oct 13, 2022 1:31 PM UTC

Thanks sounds interesting - Is there anywhere i can find more info on that method query?

Contributor
Oct 13, 2022 1:34 PM UTC

I would start with the Design and Referene Guide.  It does give a lot of info but enough to get you started.  In short, here it was it says.

"ICMatchingforWorkflowUnit This returns a detailed Intercompany Matching Report table for the given Workflow Unit and several other Parameters. The Parameters here override what is already set up in the Workflow Profile. Method Query Example: {Workflow Profile Name}{Scenario Name}{Time Name}{Plug Account Override}{Suppress Matches Override}{Tolerance Override}{Filter} or {Flint}{Actual}{2011M1}{Empty String or A#MyPlugAccount}{Empty String or true/false}{Empty String or 0.0}{Empty String or Filter Expression}."

Tahir2061Author
Newcomer
Oct 13, 2022 1:35 PM UTC

Many thanks  I will take a look at that option!

Mike_Sabourin
Contributor
Oct 19, 2022 2:13 PM UTC

One thing to consider is that however you build this, since the system looks at both sides of the match, you will get duplicate intersections showing in your report