In case of USD ledger to consolidation ledger consolidation ,If we have run the consolidated process and posted consolidated journals but later we realized that incorrect conversion rates, period-end and period-average rates where used for translation. Can we still reverse the consolidated journal and re-run the translation with correct rates and then rerun consolidation process to generate correct consolidation journal?
Hi, We have different currencies for both parent and subsidiary ledger, but we have defined reporting currency for subsidiary same as the currency of parent. Is there any way we can transfer data directly from the reporting currency to the parent ledger?
@@OracleEbizandFusionVideos Do we need a secondary ledger for transferring or we can transfer from the subsidiary primary ledger having reporting currency the same as the currency of the parent primary ledger.
Hello Sir, thank you for the simplified explanation. When I am trying to do the same using my Ireland responsibility, the consolidation form is getting opened in US ledger. Whereas it should open in EUR ledger. Any suggestions sir??
In my example, i tried to consolidation process using General Ledger Super user, Reliance Consol Responsibility where GL: Data Access set assigned to this responsibility is "Reliance Consolidated Ledger".... You should check similar setup under your scenario
If Source has more segments than target, then in COA mapping you will be able to see only the number of segments as that of Target... If Target has more segments than that of Source, then the additional/extra segments needs to be mapped to default value of "000"
Is there a way to eliminate inter co profits. What I mean is that in case of IR/ISO there will be a markup. This has to be eliminated during consolidation
Yes, thats possible. Ideally that needs to be eliminated in consolidated ledger. You need to appropriately set those accounts under elimination set and then generate elimination entries
All Primary ledgers which are consolidated into Parent ledger... In this example, the primary ledgers which are being consolidated into Parent ledger are called Subsidiary ledgers...Secondary ledgers are associated with Primary ledger.... You can refer the below video to get more insights about Secondary ledgers ua-cam.com/video/nArL2QkM0kc/v-deo.html
A very good explanation for the consolidation, I have one question here. if we have a sub consolidation should we create another Ledger for the sub consolidation or it is only one for all , Thanks in Advance
@@OracleEbizandFusionVideos Hi, for example i have a company A that fully own company B and company A is owned by Group C that owned A, D & E. at that time we have a sub consolidation between A & B. Also we have the main consolidation for All companies A, D & E under the Group C. Thanks in Advance
This video is amazing, thanks for guiding people like us :) There is one question though is it possible that the COA structure may differ when you setup the coa mapping for consol ledger?
Hi Kris, This is a video concentrating only on Consolidation process. In general, Intercompany eliminations are done in Consolidated ledger. Soon, i will post a separate video on Intercompany eliminations process
Hi sir M going to transfer CAD ledger data in to INR ledger but after running consolidation concurrent then journal import goes in to wu01error that show that journal is unbalanced but if we run for YTD then journal import complete successfully what i observed is that after run translation of CAD balance in to INR debit and credit are not equal as due to different exchange rates..so please you bring light on my issue and guide me.. Many Thanks Anurag Aggarwal
When you run your translation process under CAD ledger for converting your CAD balances into INR, system will take the net balancing figure (due to difference in exchange rates being used for P&L and B/S accounts) to Cumulative translation adjustment account (CTA). So, in your case, whether this diff is not going to CTA account?
Sir, Big fan of your content. But 1 question - Is it mandatory to create A Ledger for Consolidation, should we also need to create a Unique Legal Entity also? Further, can we also consolidate books when there are multiple ledger with multiple Legal entity. What will change in the steps in that case?
1. Its not mandatory to create a separate Consolidated ledger... If you have Ledger A and Ledger B... option 1 would be create Consolidated ledger and consolidate the data from A and B into consolidated ledger... Option 2 would be push the data from say Ledger A into Ledger B... So that Ledger B will have the data which is entered in it and also the data from Ledger A.... It all depends upon business requirement...
Thanks for the videos. Very informative. Had couple of questions 1) Can we run consolidation for a Ledger Set. ie consolidate balances from a Ledger set to a Consol Ledger? 2) Is there any report that can be executed to see the results post consolidation process. This would be helpful if there are lot of journal entries post consolidation
Answer to Question 1:- Consolidation is always from one ledger to another.... You cannot run Consolidation from a Ledger Set... Answer to Question 2:- Try running "Consolidation - Journals" report
I need to put detail JV description in GL for the transactions from sub modules. What all steps required to do in SLA. I tried ,but failed. Kindly help
Hi Samuel, Can you try to provide more details on what are the details which you want under Journal line description and also for which sub ledger journals you are expecting to see these detailed Journal line description?
Hi, When transactions from sub modules to GL, in GL description column shows 'Journal import created' . Now what I need is when I post transactions from AP,AR and FA in GL the description should show details of the transactions like invoice num,trx type, supplier name, asset num etc. please help
You cannot expect Journal line description to have Invoice num, trx type etc.. when you are summarizing the data by GL Period. In order for Journal line description to have invoice num, trx type etc.. details, you need to either go for GL Summarization of "In Detail" or "Group by GL date"
If the Consolidation Method is "Transactions", then In "Transfer Consolidation Data" screen, click on "Consolidation" button and you should be able to see unconsolidated journals. If the consolidation Method is "Balances", then this scenario of some balances consolidated and some balances did not do not arise
your all videos on ebs and fusion are really helpful. I am learning lot of things looking at it.your way of teaching is excellent.
Glad to hear that
Consolidation concept get clear with this video. Thanks you so much...keep going
Thanks Sumit...
Can we transfer the balances from reporting ledger to the consolidated ledger thru the balance transfer process in Oracle fusion?
In case of USD ledger to consolidation ledger consolidation ,If we have run the consolidated process and posted consolidated journals but later we realized that incorrect conversion rates, period-end and period-average rates where used for translation. Can we still reverse the consolidated journal and re-run the translation with correct rates and then rerun consolidation process to generate correct consolidation journal?
Yes, you can do that. I have personally seen that happened in couple of clients i worked with...
Hi,
We have different currencies for both parent and subsidiary ledger, but we have defined reporting currency for subsidiary same as the currency of parent. Is there any way we can transfer data directly from the reporting currency to the parent ledger?
I think yes... You should be able to transfer data from reporting ledger of subsidiary to parent ledger
@@OracleEbizandFusionVideos Do we need a secondary ledger for transferring or we can transfer from the subsidiary primary ledger having reporting currency the same as the currency of the parent primary ledger.
Hi Sir,
In consolidation process secondary ledger is mandatory? and why
Secondary ledger is not mandatory in Consolidation process.. You can always consolidate the data of only Primary ledgers
Today I watched this video and its very very good stuff .Please post more on SLA and IRSO transaction and setup Process if possible.
Sure
Hello Sir, thank you for the simplified explanation.
When I am trying to do the same using my Ireland responsibility, the consolidation form is getting opened in US ledger. Whereas it should open in EUR ledger. Any suggestions sir??
In my example, i tried to consolidation process using General Ledger Super user, Reliance Consol Responsibility where GL: Data Access set assigned to this responsibility is "Reliance Consolidated Ledger".... You should check similar setup under your scenario
Hi,
In the transfer Consolidation form, under the Parent standard period it showing no List of values, can you help?
Check if the Period is in Open Status or not
Are these two ledgers primary ledger and secondary ledger under same enterprise ?
All the ledgers which i had shown in this example are under same Business group. Btw, both the ledgers shows in this example are Primary ledgers
Aravind what is that accounting rule, could you please tell me. you only telling segment rule. but didnt tell what is the use of accounting rule.
In the case of accounting rule, you specify the source account code combination mapping to target account code combination...
Greate Effort🙂
Thank you! Cheers!
Thanks for explaining in detail.
You're welcome
Good and Nice information...
Thanks
Why is the currency showing INR only?
Because in my example, Functional currency of Consolidated ledger is INR
Could you please confirm the process of COA mapping If the source and Target ledger COA is different...
If Source has more segments than target, then in COA mapping you will be able to see only the number of segments as that of Target... If Target has more segments than that of Source, then the additional/extra segments needs to be mapped to default value of "000"
Great . I am beginner's for ebs . U make concept clear .. pls posting new video.
Thanks.. Sure.. Please subscribe to my channel... I will post one new video every Friday
U my
Nice Video about consolidation
You are a Champ
Thanks for your feedback
Thanks for your contribution!!!
Thanks
Is there a way to eliminate inter co profits. What I mean is that in case of IR/ISO there will be a markup. This has to be eliminated during consolidation
Yes, thats possible. Ideally that needs to be eliminated in consolidated ledger. You need to appropriately set those accounts under elimination set and then generate elimination entries
Your videos are really good. I need a small input as in what is the difference between Subsidiary Ledger and Secondary Ledger
All Primary ledgers which are consolidated into Parent ledger... In this example, the primary ledgers which are being consolidated into Parent ledger are called Subsidiary ledgers...Secondary ledgers are associated with Primary ledger.... You can refer the below video to get more insights about Secondary ledgers
ua-cam.com/video/nArL2QkM0kc/v-deo.html
Very precise and nice!
Thanks
Great job...can u post auto invoice task video...
Sure
A very good explanation for the consolidation, I have one question here. if we have a sub consolidation should we create another Ledger for the sub consolidation or it is only one for all , Thanks in Advance
Hi, Can you be more specific with example on sub consolidation... i did not get your question...
@@OracleEbizandFusionVideos Hi, for example i have a company A that fully own company B and company A is owned by Group C that owned A, D & E. at that time we have a sub consolidation between A & B. Also we have the main consolidation for All companies A, D & E under the Group C.
Thanks in Advance
Any Ideas?
@@afrash2003 it's not required to create another separate ledger foreign consolidation of A and B.... B data gets into A and A, D, E dara gets into C
This video is amazing, thanks for guiding people like us :) There is one question though is it possible that the COA structure may differ when you setup the coa mapping for consol ledger?
Its possible to consolidate data from different ledgers which have different COA into a consolidated ledger which can have different COA
how about inter company eliminations ??
Hi Kris, This is a video concentrating only on Consolidation process. In general, Intercompany eliminations are done in Consolidated ledger. Soon, i will post a separate video on Intercompany eliminations process
Kindly let me know if a video is available on Intercompany eliminations process
Hi Kris, based on your request, i had created video on intercompany elimination process.. Please refer
ua-cam.com/video/tNuKKgIj6EM/v-deo.html
Hi sir
M going to transfer CAD ledger data in to INR ledger but after running consolidation concurrent then journal import goes in to wu01error that show that journal is unbalanced but if we run for YTD then journal import complete successfully what i observed is that after run translation of CAD balance in to INR debit and credit are not equal as due to different exchange rates..so please you bring light on my issue and guide me..
Many Thanks
Anurag Aggarwal
When you run your translation process under CAD ledger for converting your CAD balances into INR, system will take the net balancing figure (due to difference in exchange rates being used for P&L and B/S accounts) to Cumulative translation adjustment account (CTA). So, in your case, whether this diff is not going to CTA account?
Nice !!!!
Thanks
Sir, Big fan of your content. But 1 question - Is it mandatory to create A Ledger for Consolidation, should we also need to create a Unique Legal Entity also? Further, can we also consolidate books when there are multiple ledger with multiple Legal entity. What will change in the steps in that case?
1. Its not mandatory to create a separate Consolidated ledger... If you have Ledger A and Ledger B... option 1 would be create Consolidated ledger and consolidate the data from A and B into consolidated ledger... Option 2 would be push the data from say Ledger A into Ledger B... So that Ledger B will have the data which is entered in it and also the data from Ledger A.... It all depends upon business requirement...
Thanks for the videos. Very informative.
Had couple of questions
1) Can we run consolidation for a Ledger Set. ie consolidate balances from a Ledger set to a Consol Ledger?
2) Is there any report that can be executed to see the results post consolidation process. This would be helpful if there are lot of journal entries post consolidation
Answer to Question 1:- Consolidation is always from one ledger to another.... You cannot run Consolidation from a Ledger Set...
Answer to Question 2:- Try running "Consolidation - Journals" report
I need to put detail JV description in GL for the transactions from sub modules. What all steps required to do in SLA. I tried ,but failed. Kindly help
Hi Samuel, Can you try to provide more details on what are the details which you want under Journal line description and also for which sub ledger journals you are expecting to see these detailed Journal line description?
Hi,
When transactions from sub modules to GL, in GL description column shows 'Journal import created' . Now what I need is when I post transactions from AP,AR and FA in GL the description should show details of the transactions like invoice num,trx type, supplier name, asset num etc. please help
Can you let me know what kind of GL Summarization options are you using for your subledgers... this information will be found under your ledger setup
Currently the the general ledger journal entry summarization : Summarize by GL period.
You cannot expect Journal line description to have Invoice num, trx type etc.. when you are summarizing the data by GL Period. In order for Journal line description to have invoice num, trx type etc.. details, you need to either go for GL Summarization of "In Detail" or "Group by GL date"
If anything not consolidated where we can find out
If the Consolidation Method is "Transactions", then In "Transfer Consolidation Data" screen, click on "Consolidation" button and you should be able to see unconsolidated journals.
If the consolidation Method is "Balances", then this scenario of some balances consolidated and some balances did not do not arise