Intercompany Matching /reconciliation report

[Former Member]

Hi,

We are in need of designing a report to see the Inter company differences. And the booking of the differences will be done bu the user.

We are not having any work status as sigle user is using the consolidation. in this insatnce can we generate the IC matching in the same consolidation model.

We are thinking of using IC matching model separately, but I am not understanding how to import the data into this model  to check the difference and how to export the same later into the consolidation model.

Also when I checked the report for IC matching a few designs show the below example:

But this example shows only 2 entities with 2 inter company accounts data. What if we have many accounts as such with many IC transacations.

Could any body suggest a way to get the IC report in a  easy way to view.

Regards,

Shilpa

[Former Member]

Hi Shilpa,

I thing if you create separate model for IC Matching then it will better.For creating separate IC Matching model basically two reason using minimum data in consolidation model and don't need to create excess task profile for consolidation profile,it's also help full for performance perspective. Now you want to thinking the data loading and exporting part here is my suggestion first you set up your IC matching model,necessary dimension and there properties,set up business rule and logic script for IC Matching and IC Data.Load the data either through flat file or BW qube at that time of loading data remember all the data loading in LC,scope set to G_None and Inter company set to I_None second step run the currency translation for populated the inter company data to group currency.Eliminated the intercompany transaction GL and book the eliminated value to respective data source and transfer the eliminated value to consolidation model.

Khokan

[Former Member]

Hi Shilpa,

we typically do not use an IC matching model, instead we use a script in the consolidation model to copy IC data between companies (we use specific flows to separate this data from the rest) and then have very simple reports that compare data and show IC differences.

If you do use two models, transferring data between models in the same environment is quite easy using a script with the *DESTINATION APP keyword.

BR,
Arnold

[Former Member]

Hi Shilpa,

We use two model, when two different person working in two different process like one working in consolidation process and another one in reconciliation process.Then it's very difficult to give security access through member access profile another reason is when consolidation model handle to much data volume. It's also very helpful to use separate Business rules,logic and currency translation in separate model.

Khokan