Skip to main content
T
Tahir2061
Newcomer
October 13, 2022

Intercompany Report

  • October 13, 2022
  • 3 replies
  • 0 views

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

3 replies

B
BeauReynolds
Newcomer
October 13, 2022

I believe there is an intercompany Dashboard as well. 

T
Tahir2061Author
Newcomer
October 13, 2022

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

S
Sweez
Contributor
October 13, 2022

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

T
Tahir2061Author
Newcomer
October 13, 2022

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

S
Sweez
Contributor
October 13, 2022

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}."

T
Tahir2061Author
Newcomer
October 13, 2022

Many thanks  I will take a look at that option!

Mike_Sabourin
Mike_Sabourin
Contributor
October 19, 2022

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

Terms & ConditionsAccessibility statement