Forum Discussion

Tahir2061's avatar
Tahir2061
New Contributor III
3 years ago

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

    • Tahir2061's avatar
      Tahir2061
      New Contributor III

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

  • Sweez's avatar
    Sweez
    New Contributor III

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

    • Tahir2061's avatar
      Tahir2061
      New Contributor III

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

  • Sweez's avatar
    Sweez
    New Contributor III

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

    • Tahir2061's avatar
      Tahir2061
      New Contributor III

      Many thanks  I will take a look at that option!

      • Mike_Sabourin's avatar
        Mike_Sabourin
        Contributor II

        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