Hi Bro, could you please post a video on Period end accruals, since many days I have got lot of confusions on this.
@monikatharumani25205 жыл бұрын
thank you sir for awesome crystal clear explanation ..
@mallimalli2156
5 жыл бұрын
Hii mounica
@OracleEbizandFusionVideos
5 жыл бұрын
Thanks
@govardhanreddythambireddy1634 Жыл бұрын
Super explanation, can we have same video for fusion also ?
@OracleEbizandFusionVideos
Жыл бұрын
Sure.. I will try to create similar video on Fusion as well
@ramamohan99575 жыл бұрын
Thank you for this video. Can you do AR auto log box setup video.
@OracleEbizandFusionVideos
5 жыл бұрын
This is bit difficult in public test environment where i do not have access to place Auto lock box files in the server and show you the process
@Raj-xw1lv5 жыл бұрын
Wonderful tutorial..hates off to ur work..😀
@OracleEbizandFusionVideos
5 жыл бұрын
Thanks
@Neeru3695 жыл бұрын
Thanks for sharing this video. Kindly impart your knowledge on AP module in EBS R12 as to Invoice hold issue, Invoice match issue,Invoice cancellation issue,Invoice processing issue. looking forward for these videos .Thanks in advance.
@OracleEbizandFusionVideos
5 жыл бұрын
Sure
@kasi365 жыл бұрын
Thanks and nice explanation, but when the payable liability is not matching with GL liability, what are the reports run to drill down the issue, as you have explained in points those are correct. but there are some reports needs to be run for comparing and identifying. Please correct if I'm wrong on this.
@OracleEbizandFusionVideos
5 жыл бұрын
If AP Accounts Payable Trial Balance and GL Account Inquiry do not match, then there could be various reasons for the same. I do not think there is any standard report which provides the reasons for such variance between AP and GL
@kasi36
5 жыл бұрын
Thanks for the reply.
@mdkamran20035 жыл бұрын
Hi, Very awesome and precise videos, hats off bro. Can you share the excel and also tell me what video to watch after this for purchasing period close /Period end accrual process ?
@OracleEbizandFusionVideos
5 жыл бұрын
Sure. I will add this to my long list of topics to be covered :-).. stay tuned to my channel.
@sajidkhanbangash8129
3 жыл бұрын
@@OracleEbizandFusionVideos Dear Upload Inventory Period closing Process and PO
@alibrahim995 жыл бұрын
Grt efforts... Thnx .... I think AP Accrual write off is kind of external reconciliation ?
@OracleEbizandFusionVideos
5 жыл бұрын
AP Accrual write off is kind of period end process rather than reconciliation...
@ghodighosh90505 жыл бұрын
Nice video Arvind. Can you do a video on AR , FA and GL period closure
@OracleEbizandFusionVideos
5 жыл бұрын
Yes. Thats what i am planning for my next vidoes
@OracleEbizandFusionVideos
5 жыл бұрын
As per your request, created a video on AR Period closure. Please see below:- kzread.info/dash/bejne/gIKuy7ihlc6deKg.html
@kasi365 жыл бұрын
could you please post for the AR aswell.
@OracleEbizandFusionVideos
5 жыл бұрын
There is also video on AR Period Close and reconciliation. You can check my youtube channel
@akshayjoshi41063 жыл бұрын
Hi sir, thanks for sharing this video...can you make a video on invoice line getting reserved in some other period other than when it was created, and then how accounting entries are getting impacted due to this and how to do reconsilation for such scenerios in gl and ap.
@OracleEbizandFusionVideos
3 жыл бұрын
Hi Akshay, Accounting always happen at Invoice line level... So, an invoice can have say 2 lines which are accounted in say Dec-2020 period and then you can reverse one of the existing line in Jan-2021.. So, you will have one reversal line and another positive line to offset the reversal line in Jan-2021 and these two lines will get accounted in Jan-2021 and pushed to GL and hence there will not be any issues in GL and AP reconciliations... Hope this clarifies your question
@akshayjoshi4106
3 жыл бұрын
Oracle Ebiz and Fusion Videos thanks a lot sir...for this explanation....
@user-rn5ex2je5c3 ай бұрын
When we run the AP TO GL reconciliation in oracle fusion finance after AP period close or before period close process??
@OracleEbizandFusionVideos
3 ай бұрын
After period closure
@jasmin9311 Жыл бұрын
Hi Thanks for such a detailed video. Can you please tell me if we have one standard - AP to GL Reconciliation Report on R12? Because under request group I can see one standard report- AR to GL Reconciliation but not AP to GL Reconciliation Report. To check reason for variance, accounted, unaccounted invoice etc.
@OracleEbizandFusionVideos
Жыл бұрын
Unfortunately, there is no such AP to GL Reconciliation report in EBS R12...
@jasmin9311
Жыл бұрын
Thanks for your response. Is there any report which can show list of reasons for causing variance between AP TB and GL Account Analysis report? Like where I can see unpaid, unaccounted, unposted Invoices etc which are causing difference?
@VISHNUREDDYYAPARLA5 жыл бұрын
Hi sir...can u share the links of videos u were made sequentially
@OracleEbizandFusionVideos
5 жыл бұрын
You can login to my channel and play all the videos and copy the links on your own
@KumR5 жыл бұрын
Hi. Can you add something on Manual Accrual and Reversal entries ?
@OracleEbizandFusionVideos
5 жыл бұрын
Sure
@OracleEbizandFusionVideos
5 жыл бұрын
Hi Shivkumar, based on your request, i had created video on GL Reversal functionality. This video has some explanation about Manual and accrual entries as well. kzread.info/dash/bejne/pXxhqrypicnJlag.html
@shaikansaree66574 жыл бұрын
How to prepare bills payable invoice and transportation invoice in r12 payables
@OracleEbizandFusionVideos
4 жыл бұрын
I will let you know once i create a video on this topic
@HarishKumar-tj2sq5 жыл бұрын
How to reconcile prepayment account balances b/w AP and GL
@OracleEbizandFusionVideos
5 жыл бұрын
You can run Account Analysis (Registered with Subledger application) and compare the same with GL Account inquiry
@srikarthatha4085 жыл бұрын
Your reports are automatically downloaded in word format. If run the report, im getting html format. Please advise, how to generate a report in word
@OracleEbizandFusionVideos
5 жыл бұрын
Can you let me know the exact name of the report which you are referring to?
@muzaffardon77375 жыл бұрын
How we will gather the customer requirements in Oracle ebs
@OracleEbizandFusionVideos
5 жыл бұрын
Hi Muzaffar, there is no straight forward answer for this. It all depends upon the project/client and whether you are upgrading system from 11i to R12 or fresh implementation of the project etc...
@chandraiyer1710
5 жыл бұрын
By talking to customer and understanding their current 'as is' process. Then you map their 'as is' into what Oracle can do and how future state will be. This is the future 'to be' process which you will offer to customer as seeded solution.
@barinismile40875 жыл бұрын
Can you share that spread sheet ? That would be more beneficial for us.
@OracleEbizandFusionVideos
5 жыл бұрын
I can share the same in youtube. You can ping me on my facebook page and provide your email id and then i can share:- facebook.com/CAArvindVaraganti/
@mdkamran2003
5 жыл бұрын
Oracle E-Business Suite Functional R12 Hi can you also share the excel with me and also make a video for purchasing close or period end Accural run ??
@OracleEbizandFusionVideos
5 жыл бұрын
@@mdkamran2003 Sure. Ping me your email id
@Raj-xw1lv5 жыл бұрын
How to delete and update AP related journal Entries in GL as i have seen that it get frozen in GL and doesnt change anything..can we delete Subledger journal where source as payables..?
@OracleEbizandFusionVideos
5 жыл бұрын
You can unfreeze the journal source and then you can try deleting and updating journals. Ofcourse, in most of the clients, there are some controls on who has access to these screens. But from system perspective, yes its possible to unfreeze the journal source and then you can try deleting or updating these subledger journals
@Raj-xw1lv
5 жыл бұрын
@@OracleEbizandFusionVideos I have already unfreeze the payable source but journals are still frozen as i have studied that journals come from subledger are not deleted and updated..
@OracleEbizandFusionVideos
5 жыл бұрын
Anurag Aggarwal , i had already tested this and i can confirm that for the subledger journals, after unfreezing the source, system allows the journals to be updated or deleted
@OracleEbizandFusionVideos
5 жыл бұрын
Anurag Aggarwal , did you check if the journals are in unposted status?
@Raj-xw1lv
5 жыл бұрын
@@OracleEbizandFusionVideos yes i have checked I have transfered transactions from AP to GL with source payables and also unfreeze the source in GL but all the journals are get frozen in unposted status..only Financial india entries are get deleted or updated but its not getting possible to update or delete subledger journals..
@jyrho21533 жыл бұрын
can you have this for Oracle Cloud?
@OracleEbizandFusionVideos
3 жыл бұрын
I will create such video for fusion in near future... Stay tuned to my channel
@jyrho2153
3 жыл бұрын
@@OracleEbizandFusionVideos hopefully it covers not just AP but all transactions to close in the month end just high level
@OracleEbizandFusionVideos
3 жыл бұрын
yes
@sravaniyekkala40664 жыл бұрын
Hi can you please share the that excel sheet
@OracleEbizandFusionVideos
4 жыл бұрын
Ping me on my facebook page and provide your email id there... I can share the excel sheet
@mohsinahmed4566
3 жыл бұрын
@@OracleEbizandFusionVideos what face book name i need this excell sheet, can send me on my email mohsinahmed897@gmail.com
Пікірлер: 78
Very impressive. Solid knowledge of accounting.
@OracleEbizandFusionVideos
5 жыл бұрын
Thanks for your feedback
Great work man... very nicely explained..
@OracleEbizandFusionVideos
4 жыл бұрын
Thanks for your feedback
Hi Bro, could you please post a video on Period end accruals, since many days I have got lot of confusions on this.
thank you sir for awesome crystal clear explanation ..
@mallimalli2156
5 жыл бұрын
Hii mounica
@OracleEbizandFusionVideos
5 жыл бұрын
Thanks
Super explanation, can we have same video for fusion also ?
@OracleEbizandFusionVideos
Жыл бұрын
Sure.. I will try to create similar video on Fusion as well
Thank you for this video. Can you do AR auto log box setup video.
@OracleEbizandFusionVideos
5 жыл бұрын
This is bit difficult in public test environment where i do not have access to place Auto lock box files in the server and show you the process
Wonderful tutorial..hates off to ur work..😀
@OracleEbizandFusionVideos
5 жыл бұрын
Thanks
Thanks for sharing this video. Kindly impart your knowledge on AP module in EBS R12 as to Invoice hold issue, Invoice match issue,Invoice cancellation issue,Invoice processing issue. looking forward for these videos .Thanks in advance.
@OracleEbizandFusionVideos
5 жыл бұрын
Sure
Thanks and nice explanation, but when the payable liability is not matching with GL liability, what are the reports run to drill down the issue, as you have explained in points those are correct. but there are some reports needs to be run for comparing and identifying. Please correct if I'm wrong on this.
@OracleEbizandFusionVideos
5 жыл бұрын
If AP Accounts Payable Trial Balance and GL Account Inquiry do not match, then there could be various reasons for the same. I do not think there is any standard report which provides the reasons for such variance between AP and GL
@kasi36
5 жыл бұрын
Thanks for the reply.
Hi, Very awesome and precise videos, hats off bro. Can you share the excel and also tell me what video to watch after this for purchasing period close /Period end accrual process ?
@OracleEbizandFusionVideos
5 жыл бұрын
Sure. I will add this to my long list of topics to be covered :-).. stay tuned to my channel.
@sajidkhanbangash8129
3 жыл бұрын
@@OracleEbizandFusionVideos Dear Upload Inventory Period closing Process and PO
Grt efforts... Thnx .... I think AP Accrual write off is kind of external reconciliation ?
@OracleEbizandFusionVideos
5 жыл бұрын
AP Accrual write off is kind of period end process rather than reconciliation...
Nice video Arvind. Can you do a video on AR , FA and GL period closure
@OracleEbizandFusionVideos
5 жыл бұрын
Yes. Thats what i am planning for my next vidoes
@OracleEbizandFusionVideos
5 жыл бұрын
As per your request, created a video on AR Period closure. Please see below:- kzread.info/dash/bejne/gIKuy7ihlc6deKg.html
could you please post for the AR aswell.
@OracleEbizandFusionVideos
5 жыл бұрын
There is also video on AR Period Close and reconciliation. You can check my youtube channel
Hi sir, thanks for sharing this video...can you make a video on invoice line getting reserved in some other period other than when it was created, and then how accounting entries are getting impacted due to this and how to do reconsilation for such scenerios in gl and ap.
@OracleEbizandFusionVideos
3 жыл бұрын
Hi Akshay, Accounting always happen at Invoice line level... So, an invoice can have say 2 lines which are accounted in say Dec-2020 period and then you can reverse one of the existing line in Jan-2021.. So, you will have one reversal line and another positive line to offset the reversal line in Jan-2021 and these two lines will get accounted in Jan-2021 and pushed to GL and hence there will not be any issues in GL and AP reconciliations... Hope this clarifies your question
@akshayjoshi4106
3 жыл бұрын
Oracle Ebiz and Fusion Videos thanks a lot sir...for this explanation....
When we run the AP TO GL reconciliation in oracle fusion finance after AP period close or before period close process??
@OracleEbizandFusionVideos
3 ай бұрын
After period closure
Hi Thanks for such a detailed video. Can you please tell me if we have one standard - AP to GL Reconciliation Report on R12? Because under request group I can see one standard report- AR to GL Reconciliation but not AP to GL Reconciliation Report. To check reason for variance, accounted, unaccounted invoice etc.
@OracleEbizandFusionVideos
Жыл бұрын
Unfortunately, there is no such AP to GL Reconciliation report in EBS R12...
@jasmin9311
Жыл бұрын
Thanks for your response. Is there any report which can show list of reasons for causing variance between AP TB and GL Account Analysis report? Like where I can see unpaid, unaccounted, unposted Invoices etc which are causing difference?
Hi sir...can u share the links of videos u were made sequentially
@OracleEbizandFusionVideos
5 жыл бұрын
You can login to my channel and play all the videos and copy the links on your own
Hi. Can you add something on Manual Accrual and Reversal entries ?
@OracleEbizandFusionVideos
5 жыл бұрын
Sure
@OracleEbizandFusionVideos
5 жыл бұрын
Hi Shivkumar, based on your request, i had created video on GL Reversal functionality. This video has some explanation about Manual and accrual entries as well. kzread.info/dash/bejne/pXxhqrypicnJlag.html
How to prepare bills payable invoice and transportation invoice in r12 payables
@OracleEbizandFusionVideos
4 жыл бұрын
I will let you know once i create a video on this topic
How to reconcile prepayment account balances b/w AP and GL
@OracleEbizandFusionVideos
5 жыл бұрын
You can run Account Analysis (Registered with Subledger application) and compare the same with GL Account inquiry
Your reports are automatically downloaded in word format. If run the report, im getting html format. Please advise, how to generate a report in word
@OracleEbizandFusionVideos
5 жыл бұрын
Can you let me know the exact name of the report which you are referring to?
How we will gather the customer requirements in Oracle ebs
@OracleEbizandFusionVideos
5 жыл бұрын
Hi Muzaffar, there is no straight forward answer for this. It all depends upon the project/client and whether you are upgrading system from 11i to R12 or fresh implementation of the project etc...
@chandraiyer1710
5 жыл бұрын
By talking to customer and understanding their current 'as is' process. Then you map their 'as is' into what Oracle can do and how future state will be. This is the future 'to be' process which you will offer to customer as seeded solution.
Can you share that spread sheet ? That would be more beneficial for us.
@OracleEbizandFusionVideos
5 жыл бұрын
I can share the same in youtube. You can ping me on my facebook page and provide your email id and then i can share:- facebook.com/CAArvindVaraganti/
@mdkamran2003
5 жыл бұрын
Oracle E-Business Suite Functional R12 Hi can you also share the excel with me and also make a video for purchasing close or period end Accural run ??
@OracleEbizandFusionVideos
5 жыл бұрын
@@mdkamran2003 Sure. Ping me your email id
How to delete and update AP related journal Entries in GL as i have seen that it get frozen in GL and doesnt change anything..can we delete Subledger journal where source as payables..?
@OracleEbizandFusionVideos
5 жыл бұрын
You can unfreeze the journal source and then you can try deleting and updating journals. Ofcourse, in most of the clients, there are some controls on who has access to these screens. But from system perspective, yes its possible to unfreeze the journal source and then you can try deleting or updating these subledger journals
@Raj-xw1lv
5 жыл бұрын
@@OracleEbizandFusionVideos I have already unfreeze the payable source but journals are still frozen as i have studied that journals come from subledger are not deleted and updated..
@OracleEbizandFusionVideos
5 жыл бұрын
Anurag Aggarwal , i had already tested this and i can confirm that for the subledger journals, after unfreezing the source, system allows the journals to be updated or deleted
@OracleEbizandFusionVideos
5 жыл бұрын
Anurag Aggarwal , did you check if the journals are in unposted status?
@Raj-xw1lv
5 жыл бұрын
@@OracleEbizandFusionVideos yes i have checked I have transfered transactions from AP to GL with source payables and also unfreeze the source in GL but all the journals are get frozen in unposted status..only Financial india entries are get deleted or updated but its not getting possible to update or delete subledger journals..
can you have this for Oracle Cloud?
@OracleEbizandFusionVideos
3 жыл бұрын
I will create such video for fusion in near future... Stay tuned to my channel
@jyrho2153
3 жыл бұрын
@@OracleEbizandFusionVideos hopefully it covers not just AP but all transactions to close in the month end just high level
@OracleEbizandFusionVideos
3 жыл бұрын
yes
Hi can you please share the that excel sheet
@OracleEbizandFusionVideos
4 жыл бұрын
Ping me on my facebook page and provide your email id there... I can share the excel sheet
@mohsinahmed4566
3 жыл бұрын
@@OracleEbizandFusionVideos what face book name i need this excell sheet, can send me on my email mohsinahmed897@gmail.com