A nice video with proper details, thanks for sharing , not used this features in R12 , didn't know that it requires these multiple steps. In fusion it's quite straightforward we just have to set multiperiod start date, end date and accrual account details in invoice line/distribution under multiperiod section along with normal expense acct in the invoice line and set proration formula; rest all is taken care by Oracle and multiperiod accounting starts getting generated after Create Multiperiod Accounting process is executed during period close process.
True... Unfortunately in ebs, out of the box, Oracle do not provide option to enter Accrual account and proration details in AP Invoice workbench and hence we need to follow this long process
Really worthy to watch, and Arvind clearly explained with example..., One functional question prepared with this video - Use/ Benefit of SLA in R12? Apart from other uses.
If you have a business requirement to derive account based on different business needs and if the standard accounting engine is not meeting those requirements, then you use SLA... All the SLA videos which i have uploaded in my channel are based on real business use cases which i have encountered during my professional career... Please find below the URL for my SLA videos:- ua-cam.com/play/PLbKu5Q6CEldrl4Z7WL2hZZ3eJebFJoT51.html
Awesome video and explanation of MPA. !!! Could you please add one more video on MPA to explain the " GL Dates" option in MPA - First Day, Last Day and Originating Day. Explanation of 'Proration Type' was commendable. One more suggestion - you can create similar video on REVENU RECOGNITION on AR side(if not already done) :)
Thanks for this awesome explanation. I have a doubt though... What if the prepaid expense account passed in invoice distribution has sub account with it whereas the Rent account passed at invoice line dff doesn't have similar sub account... How to tackle this? Plz guide. Regards.
If your requirement is to use same Sub account which is passed in Invoice Distribution, then you need to slightly modify SLA rules to meet the requirement
Can you please throw some light on how to credit the Mukti period accounting invoices…do we need to create sla rules for credit memo as well…appreciate your help
Hi, why was Accounting class selected as PREPAID EXPENSE for ACCRUAL JLT ?Any specific reason ? What if it is left as "Item Expense"? One of the Oracle whitepapers left it as "Item Expense". Appreciate, if you can debunk this. Many Thanks.
Whether can we change SLAM in between any time during the journals are already posted, any impact if we change slam during or in between running the system
Yes, system allows and you can change SLAM at any time after some transactions are accounted and posted.... Updated SLAM will effect only all the future transactions which are not yet accounted
A nice video with proper details, thanks for sharing , not used this features in R12 , didn't know that it requires these multiple steps. In fusion it's quite straightforward we just have to set multiperiod start date, end date and accrual account details in invoice line/distribution under multiperiod section along with normal expense acct in the invoice line and set proration formula; rest all is taken care by Oracle and multiperiod accounting starts getting generated after Create Multiperiod Accounting process is executed during period close process.
True... Unfortunately in ebs, out of the box, Oracle do not provide option to enter Accrual account and proration details in AP Invoice workbench and hence we need to follow this long process
Really worthy to watch, and Arvind clearly explained with example..., One functional question prepared with this video - Use/ Benefit of SLA in R12? Apart from other uses.
Is your question what is the use of SLA in EBS?
@@OracleEbizandFusionVideos yes Arvind, can we have few lines for this?
If you have a business requirement to derive account based on different business needs and if the standard accounting engine is not meeting those requirements, then you use SLA... All the SLA videos which i have uploaded in my channel are based on real business use cases which i have encountered during my professional career...
Please find below the URL for my SLA videos:-
ua-cam.com/play/PLbKu5Q6CEldrl4Z7WL2hZZ3eJebFJoT51.html
Excellent videos Arvind 👍👍👏👏👏
Thanks a ton
Nice and educational video. Thank you for sharing the knowledge.🤙
Glad it was helpful!
It's excellent demo
Thanks
Amazing video Arvind. Thanks a lot for sharing the knowledge.
Thanks for your feedback
Awesome video and explanation of MPA. !!! Could you please add one more video on MPA to explain the " GL Dates" option in MPA - First Day, Last Day and Originating Day.
Explanation of 'Proration Type' was commendable.
One more suggestion - you can create similar video on REVENU RECOGNITION on AR side(if not already done) :)
You can refer the below video on Revenue recognition
ua-cam.com/video/ODkWIE6cRMI/v-deo.html
Thanks please upload more videos sir.
Sure I will... Keep following my channel
Thanks for this awesome explanation. I have a doubt though...
What if the prepaid expense account passed in invoice distribution has sub account with it whereas the Rent account passed at invoice line dff doesn't have similar sub account...
How to tackle this? Plz guide.
Regards.
If your requirement is to use same Sub account which is passed in Invoice Distribution, then you need to slightly modify SLA rules to meet the requirement
Can you please throw some light on how to credit the Mukti period accounting invoices…do we need to create sla rules for credit memo as well…appreciate your help
Whats your exact business requirement? why do you need to credit MPA invoices?
Hi, why was Accounting class selected as PREPAID EXPENSE for ACCRUAL JLT ?Any specific reason ? What if it is left as "Item Expense"? One of the Oracle whitepapers left it as "Item Expense". Appreciate, if you can debunk this. Many Thanks.
Hello Arvind very very good video. Can you please make a video on oracle cloud integration.?
Sure... I will try
Whether can we change SLAM in between any time during the journals are already posted, any impact if we change slam during or in between running the system
Yes, system allows and you can change SLAM at any time after some transactions are accounted and posted.... Updated SLAM will effect only all the future transactions which are not yet accounted
how to setup Travel & expense report "Report and Line level" (detail info like Vendor, location, notes )
Is this question from Oracle I Expenses perspective?
yes for I-Expenses perspective
Hi Aravind
Do we have this MPA funshnality in fusion?
Yes... Conceptually it's same even in fusion
Please refer the below video showing MPA functionality in fusion...
ua-cam.com/video/VMTA4idy6ko/v-deo.html
May we apply receipts matching invoice for Multiperiod accounting?
Do you mean to say if you generate Multi Period Accounting entries for a PO Matched (3 Way matched) Invoice?
@@OracleEbizandFusionVideosyes. Can we do this for PO matched invoice?
@@nazishumair7852 , Please refer Oracle Doc id:- 2405757.1 for further information on this
Sir how we can cancel the multiperiod accounting
Disable the custom SLA rules and that should take care of not generating any future Multi period accounting lines