Can any one of you help me in creating MIS intercompany reconciliation reports in BOFC.
I have created reconciliation definition and created a reported as per the rule, but i couldn't see any results When i run the schedule.
I strongly feel there is something wrong in the schedule.
can any one help me with how to create MIS intercompany reconciliation or if possible can you share sample reports on MIS intercompany reconciliation reports?
Thanks in advance!
The creation of intercompany reports in BOFC can be tricky.
Please find below two screenshots of a basic P&L reconciliation report.
Please note that for the selection tab you need to move the data source selection in columns (Action, Data Source, Column).
Second, you need to select intercompany reconciliation amounts items in "Other data sources" and not the regular "Amount data sources" that are package, preconsolidation or consolidation data.
Usually the report is initialized with "Conversion Difference" item in Schedule axis, and with "Buyer amount in local currency", "Seller amount in local currency", "Converted buyer amount", "Converted seller amount" in column axis. At the very end of the report the "Conversion difference" is selected to display the expected I/C differences.
In row axis you have to select the specific I/C reconciliation dimensions in the dimension palette that are located under "Intercompany réconciliations" entry. Dimensions "Reconciliation rule", "Buyer" and "Seller" are mandatory as all are generated by reconciliation rules. Additionnaly the regular partner dimension is also mandataory has all amounts are stored with partner detail.
The layout can be time consuming too until you reach the final version. Once you get correct amounts in your report it is all about trial and error regarding subtotals and formatting until you get familiar with these particular reports.
Hope this helps.