Page 1 of 1
mrc in GL 11i
Posted: Sun Dec 20, 2009 9:46 am
by nrao1981
Version R12/11i? =
Instance PROD/TEST/VIS? =
Module? =
OS? =
hi everyone
this is about mrc in GL 11i
I have 2 sobs. One is in uk and another one is in us.In both sobs the chart of accounts different. Now i want to do mrc. Is it possible if the chart of ac is different or not. If Yes How?
thanks.
Posted: Tue Dec 22, 2009 1:01 pm
by tgs100
I have 2 sobs. One is in uk and another one is in us.In both sobs the chart of accounts different. Now i want to do mrc. Is it possible if the chart of ac is different or not. If Yes How?
I think you are looking for consolidation..not MRC...
Cheers,
Saravanan
Posted: Tue Dec 22, 2009 3:00 pm
by nrao1981
I have 2 sobs. One is in uk and another one is in us.In both sobs the chart of accounts different. Now i want to do mrc. Is it possible if the chart of ac is different or not. If Yes How?
I think you are looking for consolidation..not MRC...
Cheers,
Saravanan
<i><div align="right">Originally posted by tgs100
Posted: Tue Dec 22, 2009 4:31 pm
by tgs100
By the way, what is MRC, what is translation and what is consolidation?
I found the basic concept is missing.
Cheers,
Saravanan
Posted: Wed Dec 23, 2009 2:13 pm
by nrao1981
[quote]By the way, what is MRC, what is translation and what is consolidation?
I found the basic concept is missing.
Cheers,
Saravanan
<i><div align="right">Originally posted by tgs100
Posted: Thu Dec 24, 2009 4:47 am
by karthikeyanp1981
You have 2 SOB's.
SOB 1 is in GBP and SOB 2 is in USD
Now what are the options you have ....
Option no 1: Performing MRC and Consolidation
You will create a Reporting Set of book for either SOB 1 (to convert it to USD) or SOB 2 (To convert it to GBP)
After that you need to perform consolidation,
if you want all balances to be in GBP, then Consolidate SOB 1 with Reporting SOB of SOB 2 and vice versa for USD balances.
Option no 2: Perform Translation and Consolidation
No reporting set of books required.
Perform Translation of your primary set of books
Consolidate the translated balances to your parent set of books..
Under both the options you are required to perform the consolidation, and you can consolidation for different chart of account structures. One time setup of mapping is required.
You said you want to do MRC, which means you wanted to have Reporting Set of books... yeah you can have, what is preventing from doing so ? We will be more interested in knowing the error message you are receiving if you have tried it in the instance.
Regards,
Karthikeyan
Posted: Fri Dec 25, 2009 1:44 pm
by tgs100
Rao: The definitions you have given for MRC, translation and consolidations are correct.
What is the MRC currency? If MRC currency is different from GBP and USD, then you should have two MRC SOBs. Then you need to do consolidation for reporting.
Still not clear? Explain with specific issues.
Cheers,
Saravanan
Posted: Sun Dec 27, 2009 11:03 pm
by nrao1981
[quote]Rao: The definitions you have given for MRC, translation and consolidations are correct.
What is the MRC currency? If MRC currency is different from GBP and USD, then you should have two MRC SOBs. Then you need to do consolidation for reporting.
Still not clear? Explain with specific issues.
Cheers,
Saravanan
<i><div align="right">Originally posted by tgs100
Posted: Mon Dec 28, 2009 9:40 am
by karthikeyanp1981
I Assume now this is what you have did,
Primary Set of Books is defined as below:
SOB 1( COA 1, Calendar, USD)
SOB 2 (COA 2, Calendar, GBP)
You defined Reporting Set of Books as below:
For SOB1 = RSOB 1 (COA2, Calendar, GBP)
For SOB 2 = RSOB 2 (COA 1, Calendar, USD)
Now you are trying to assign the primary set of books with the reporting set of books ...
SOB 1 with RSOB 1
SOB 2 with RSOB 2
You are facing an error (no values in LOV field) at the assignment stage ....
The reason being :
The Primary and Reporting SOBs should have the same calendar and chart of accounts.
Suggestion:
Create Reporting set of books with same Chart of Accounts and then perform consolidation.
Regards,
Karthikeyan