Hi Sir, what does it mean when there is a difference between Unapplied Receipts Register and Unapplied Receipts Journal Entries when running AR Reconciliation Report? Thank you so much
Aravind, the site Infosemantics is not working,let me if other instace is available for free to practice. one of the your vidieos you mentioned for practicing. i tried but its not opening.
Yes, a year back, infosemantics company was acquired by another company and since then, they stopped providing free instance.. i have not seen any other company providing free ebs instance
Hi Could you give an instance where a transaction could be incomplete? Would the end date of an accounting rule being in a period that is closed or future be considered as an example? Correct me if I'm wrong.
I had seen some scenarios where goods are shipped from OM module and received by customer and AR invoice is also generated...but business users do not want this invoice to be sent to customer and hence put the invoice in "Incomplete" status..... Couple of reasons for not sending this invoice to customer:- 1. This customer wants to be billed on milestones... As the milestones are not reached, the invoices will be kept on "Incomplete" and once the milestone is reached, the invoices will be kept in "Complete" status.... Note:- In this client, Project accounting is not used and milestones are tracked outside of Oracle 2. There are multiple invoices generated based on different SO lines being shipped at different dates.... All these SO's belong to one customer Purchase order.... One specific customers want all invoices to be sent only once all SO's under the Purchase Order are being shipped.... In this all the invoices will be kept on "Incomplete" status... They are changed back to "Complete" once all required invoices are generated.... Note:- This client do not want to go for changing of AR grouping rules to generate AR invoice once entire Purchase Order is shipped as this change will effect all the customers...
@@shenelifernando6199 Another scenario could be, you have created a manual invoice completed it, but realized that price is wrong and waiting for some confirmation for the actual price from some other user... So, you can keep it in "Incomplete" status until you get the required information from other user.. Note:- Once the invoice is final accounted, system will not allow the invoice to be incompleted and make any updates to the invoice
Couple of differences between AR Close Pending and AR Closed periods:- 1. System will not allow AR period to be closed if there are any transactions which are not accounted/not transferredc to GL in that period. 2. System will not allow user to enter any transactions in closed AR Period/Pending Close period 3. System will allow the user to keep the period in Pending Close even though there are unaccounted/untransferred transactions In general, during month end, if there are any problematic transactions which we are not able to account/transfer to GL, we raise Sev1 SR with Oracle for resolution and keep the period in Pending Close so that no users can enter any fresh transactions in that Pending close period
If you are referring to GAP analysis during Design phase, then its basically what we are saying here is that business requirements are not met by Oracle Out of box functionality and hence we build a custom solution/report to meet the business requirements.
Hi Sir, thank you for such a detailed explanation about the AR period closure and reconciliation with GL. I would like to know from you, if you have made a video on Oracle Fusion Receivables Period closing as well. Kindly let me know.
We have 3 receivable accounts in AR for 3 dept. Each department does the reconciliation individually. Is there any way to run all these reports based on a Natural account such as Adjustment register, applied receipt register, unapplied receipt register.
Unfortunately none of the reports which you mentioned have Natural Account segment as the parameter.. In your case, probably you need to build a custom report to meet your requirements.
We cannot create fresh transactions in Close Pending period status, but we can create accounting/transfer to GL for already existing unaccounted transactions even though period is Pending Close
Let me know your specific requirement? In general, Oracle has standard SLA rules to perform accounting for all FA events. If there is no specific business requirement, no specific FA SLA rule setup is required
Oracle E-Business Suite Functional R12 Actually if you could give us the example of any customiztion example in sla for an perticuler event and journal type..
Couple of issues which we faced during our AR Period closure for which we raised Oracle SR:- 1. Certain transactions were not accounted and we were not able to close the period. Raised Oracle SR and Oracle Support engineer identified that there were orphan records created. Oracle provided datafix resolved the issue 2. We were not able to account certain receipts. Raised Oracle SR and Oracle support engineer provided datafix resolved the issue.
@@ravinder8774 When you run transaction diagnosis, oracle Support engineer can identify the orphan records... in simple layman terms, these are the records which should not exists and should be deleted.
Hi Sunny, as requested, please find below video on Oracle Cash Management Bank Statement import and Reconciliation process:- ua-cam.com/video/lO3l7ZTGcwg/v-deo.html
Great Explanation Sir, Could you please clarify the below doubts if possible 1) As part of AR to GL Reconciliation after transferring to GL if some receivable entries got deleted in GL it may causes to Reconciliation issue, so where and how can we find the deleted entries ? 2) Revaluation performed in GL for receivable account is a normal process in every business obviously change will take place for receivable account so what should be our approach for this ? Thanks in advance.
Hi, 1. Ideally the Journal source "Receivables" should be in Frozen mode so that nobody should be able to delete the sub-ledger entries... but if somebody unfreeze the same and delete the entries, then there is no way to track them... But in any client environment, in general these Journal sources will be frozen so that nobody can delete the entries created with that source 2. Revaluation balance should be appearing under "GL Source Manual" column
Excellent video as always.....only trusted material on UA-cam
Thanks for feedback
Great, simple, crisp and most effective.
Thanks for your feedback
@@OracleEbizandFusionVideos kindly Sir share with me excel File. email id sajidbangash86@gmail.com
Excellent video for going through AR Module! Thank you so much for sharing.
Glad it was helpful!
Excellent explanation...great sir
Thanks
It's a very great explanation tqqqq sir for sharing your knowledge with us🙏👍
Thanks
Hi Sir, what does it mean when there is a difference between Unapplied Receipts Register and Unapplied Receipts Journal Entries when running AR Reconciliation Report? Thank you so much
See if your issue is related to Oracle Note id:- 2659267.1
Hi
Can you also explain why adjustments should be considered at all? Isn't is already included in the transaction balance?
Thanks very much for sharing the knowledge 👍🏻
My pleasure!
Very much explanatory. Thanks for letting us know all about AR reconciliation.
Could please share the Excel sheet you showing us in the video.
Ping me with your email id on my facebook page
@@OracleEbizandFusionVideos I have pinged you at Facebook. Please share the Excel sheet
@@MohitKumarTomar I pinged you on facebook
very good explanation
Thanks
Do we hve an option of this AR sweeping program in Fusion ?
Yes, this functionality exists in Oracle Fusion Cloud as well
So nicely explained..
Thanks
As always, great video 😀
Thanks
Aravind, the site Infosemantics is not working,let me if other instace is available for free to practice. one of the your vidieos you mentioned for practicing. i tried but its not opening.
Yes, a year back, infosemantics company was acquired by another company and since then, they stopped providing free instance.. i have not seen any other company providing free ebs instance
Very nice video.....Appreciate it. Thanks Charan
Thanks for your feedback
Hi
Could you give an instance where a transaction could be incomplete?
Would the end date of an accounting rule being in a period that is closed or future be considered as an example? Correct me if I'm wrong.
I had seen some scenarios where goods are shipped from OM module and received by customer and AR invoice is also generated...but business users do not want this invoice to be sent to customer and hence put the invoice in "Incomplete" status..... Couple of reasons for not sending this invoice to customer:-
1. This customer wants to be billed on milestones... As the milestones are not reached, the invoices will be kept on "Incomplete" and once the milestone is reached, the invoices will be kept in "Complete" status.... Note:- In this client, Project accounting is not used and milestones are tracked outside of Oracle
2. There are multiple invoices generated based on different SO lines being shipped at different dates.... All these SO's belong to one customer Purchase order.... One specific customers want all invoices to be sent only once all SO's under the Purchase Order are being shipped.... In this all the invoices will be kept on "Incomplete" status... They are changed back to "Complete" once all required invoices are generated.... Note:- This client do not want to go for changing of AR grouping rules to generate AR invoice once entire Purchase Order is shipped as this change will effect all the customers...
@@OracleEbizandFusionVideos Hi
Anything not relating to any other modules?
@@shenelifernando6199 Another scenario could be, you have created a manual invoice completed it, but realized that price is wrong and waiting for some confirmation for the actual price from some other user... So, you can keep it in "Incomplete" status until you get the required information from other user.. Note:- Once the invoice is final accounted, system will not allow the invoice to be incompleted and make any updates to the invoice
Hi Sir
In AR what is the difference between close and close pending status in period close
Couple of differences between AR Close Pending and AR Closed periods:-
1. System will not allow AR period to be closed if there are any transactions which are not accounted/not transferredc to GL in that period.
2. System will not allow user to enter any transactions in closed AR Period/Pending Close period
3. System will allow the user to keep the period in Pending Close even though there are unaccounted/untransferred transactions
In general, during month end, if there are any problematic transactions which we are not able to account/transfer to GL, we raise Sev1 SR with Oracle for resolution and keep
the period in Pending Close so that no users can enter any fresh transactions in that Pending close period
@@OracleEbizandFusionVideos Thanks for the reply sir
Hi Sir,
What is fit GAP analysis? and any examples please...Thanks in advance.
If you are referring to GAP analysis during Design phase, then its basically what we are saying here is that business requirements are not met by Oracle Out of box functionality and hence we build a custom solution/report to meet the business requirements.
@@OracleEbizandFusionVideos Thanks for the reply sir
Hi Sir, thank you for such a detailed explanation about the AR period closure and reconciliation with GL. I would like to know from you, if you have made a video on Oracle Fusion Receivables Period closing as well. Kindly let me know.
Will upload soon
We have 3 receivable accounts in AR for 3 dept. Each department does the reconciliation individually. Is there any way to run all these reports based on a Natural account such as Adjustment register, applied receipt register, unapplied receipt register.
Unfortunately none of the reports which you mentioned have Natural Account segment as the parameter.. In your case, probably you need to build a custom report to meet your requirements.
Can we create transactions in close pending period status?
We cannot create fresh transactions in Close Pending period status, but we can create accounting/transfer to GL for already existing unaccounted transactions even though period is Pending Close
@@OracleEbizandFusionVideos Thanks for the reply sir
Great, Can we have a video on FA SLA setup...
Sure. I will try to create a video. Stay tuned to my channel
Oracle E-Business Suite Functional R12 yes we are :) really appericiate if you could upload the same asap :)
Let me know your specific requirement? In general, Oracle has standard SLA rules to perform accounting for all FA events. If there is no specific business requirement, no specific FA SLA rule setup is required
Oracle E-Business Suite Functional R12 Actually if you could give us the example of any customiztion example in sla for an perticuler event and journal type..
azad sable OK, i will try to create a video on FA SLA changes by taking one business scenario which i had encountered in one of my previous project
Do we have any report for finding list of receivable accounts one OU has. Here u have 3 accounts
You need to run backend SQL query to get this from XLA tables
@@OracleEbizandFusionVideos thanks a lot
can you share the excel it may help
Please ping me your email id so that i can share the excel
Thanks so much
Unable to send my email id
You can ping me your email id here
Love it
Thanks
Thank you it is very good
You are welcome
Can you please do video for ar interfaces
Sure
Coluld you please explain AP & AR Issues? For which you raised SR those issues. Explain from starting to till you get solutation.
Couple of issues which we faced during our AR Period closure for which we raised Oracle SR:-
1. Certain transactions were not accounted and we were not able to close the period. Raised Oracle SR and Oracle Support engineer identified that there were orphan records created. Oracle provided datafix resolved the issue
2. We were not able to account certain receipts. Raised Oracle SR and Oracle support engineer provided datafix resolved the issue.
@@OracleEbizandFusionVideos
Thanks for replying,
Any Auto invoice related issues during importing invoice?
@@OracleEbizandFusionVideos
You mentioned orphan records, what dose it mean?
@@ravinder8774 When you run transaction diagnosis, oracle Support engineer can identify the orphan records... in simple layman terms, these are the records which should not exists and should be deleted.
@@ravinder8774 Most of the Auto invoice issues are related to data or setup. After correcting them, we were able to import the invoices successfully
U r always best. Could u make a video for GL period close
Sure.Stay tuned to my channel
GL Period closure video is prepared and uploaded based on your request
@@OracleEbizandFusionVideos thanks a lot sir
@@OracleEbizandFusionVideos I am looking into GL period close videos
ua-cam.com/video/0-6opUvumL8/v-deo.html
Any Cash Management reconciliation step by step videos?
Hi Sunny, i will let you know once i create a Video on Cash Management Bank Account reconciliation functionality
Hi Sunny, as requested, please find below video on Oracle Cash Management Bank Statement import and Reconciliation process:-
ua-cam.com/video/lO3l7ZTGcwg/v-deo.html
Can you pls share your documents with me.. it's very easy understand. Thanks for the video.
Ping me on my facebook page
@@OracleEbizandFusionVideos done sir
@@OracleEbizandFusionVideos if possible pls share the link.
@@stayraw2009 facebook.com/CAArvindVaraganti
could you share the excel? very nice explanation
Please ping me your email address on my facebook page so that i can send you the excel spreadsheet
Great Explanation Sir,
Could you please clarify the below doubts if possible
1) As part of AR to GL Reconciliation after transferring to GL if some receivable entries got deleted in GL it may causes to Reconciliation issue,
so where and how can we find the deleted entries ?
2) Revaluation performed in GL for receivable account is a normal process in every business obviously change will take place for receivable
account so what should be our approach for this ?
Thanks in advance.
Hi, 1. Ideally the Journal source "Receivables" should be in Frozen mode so that nobody should be able to delete the sub-ledger entries... but if somebody unfreeze the same and delete the entries, then there is no way to track them... But in any client environment, in general these Journal sources will be frozen so that nobody can delete the entries created with that source
2. Revaluation balance should be appearing under "GL Source Manual" column
Thanks for your clarification