Oracle AR Period Close and Reconciliation

[@ukthakurthakur1691]

Great, simple, crisp and most effective.

[@OracleEbizandFusionVideos]

Thanks for your feedback

[@sajidkhanbangash8129]

@@OracleEbizandFusionVideos kindly Sir share with me excel File. email id [e-mail]

[@aapsebaat5627]

Excellent video as always.....only trusted material on KZbin

[@OracleEbizandFusionVideos]

Thanks for feedback

[@sabrinas.6450]

Excellent video for going through AR Module! Thank you so much for sharing.

[@OracleEbizandFusionVideos]

Glad it was helpful!

[@monikatharumani2520]

Excellent explanation...great sir

[@OracleEbizandFusionVideos]

Thanks

[@kasi36]

very good explanation

[@OracleEbizandFusionVideos]

Thanks

[@VatanDeli]

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

[@OracleEbizandFusionVideos]

See if your issue is related to Oracle Note id:- 2659267.1

[@shenelifernando6199]

Hi Can you also explain why adjustments should be considered at all? Isn't is already included in the transaction balance?

[@moheebmerchant2542]

Thanks very much for sharing the knowledge 👍🏻

[@OracleEbizandFusionVideos]

My pleasure!

[@MohitKumarTomar]

Very much explanatory. Thanks for letting us know all about AR reconciliation. Could please share the Excel sheet you showing us in the video.

[@OracleEbizandFusionVideos]

Ping me with your email id on my facebook page

[@MohitKumarTomar]

@@OracleEbizandFusionVideos I have pinged you at Facebook. Please share the Excel sheet

[@OracleEbizandFusionVideos]

@@MohitKumarTomar I pinged you on facebook

[@JayPrakash-wm9zg]

So nicely explained..

[@OracleEbizandFusionVideos]

Thanks

[@gursikh133]

Very nice video.....Appreciate it. Thanks Charan

[@OracleEbizandFusionVideos]

Thanks for your feedback

[@MohamedFarag-te4kw]

Thank you it is very good

[@OracleEbizandFusionVideos]

You are welcome

[@Crazykids3935]

It's a very great explanation tqqqq sir for sharing your knowledge with us🙏👍

[@OracleEbizandFusionVideos]

Thanks

[@venkateshdasari1982]

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.

[@OracleEbizandFusionVideos]

Will upload soon

[@ghodighosh9050]

As always, great video 😀

[@OracleEbizandFusionVideos]

Thanks

[@PavanVasireddy-tl2qr]

Hi Sir, What is fit GAP analysis? and any examples please...Thanks in advance.

[@OracleEbizandFusionVideos]

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.

[@PavanVasireddy-tl2qr]

@@OracleEbizandFusionVideos Thanks for the reply sir

[@priya2085]

Do we hve an option of this AR sweeping program in Fusion ?

[@OracleEbizandFusionVideos]

Yes, this functionality exists in Oracle Fusion Cloud as well

[@azadsable2527]

Great, Can we have a video on FA SLA setup...

[@OracleEbizandFusionVideos]

Sure. I will try to create a video. Stay tuned to my channel

[@azadsable2527]

Oracle E-Business Suite Functional R12 yes we are :) really appericiate if you could upload the same asap :)

[@OracleEbizandFusionVideos]

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

[@azadsable2527]

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..

[@OracleEbizandFusionVideos]

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

[@abhisekhnayak5780]

U r always best. Could u make a video for GL period close

[@OracleEbizandFusionVideos]

Sure.Stay tuned to my channel

[@OracleEbizandFusionVideos]

GL Period closure video is prepared and uploaded based on your request

[@abhisekhnayak5780]

@@OracleEbizandFusionVideos thanks a lot sir

[@abhisekhnayak5780]

@@OracleEbizandFusionVideos I am looking into GL period close videos

[@OracleEbizandFusionVideos]

kzbin.info/www/bejne/Zl6ZoKOLq9qggpo

[@madhuarepalli2845]

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.

[@OracleEbizandFusionVideos]

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.

[@shenelifernando6199]

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.

[@OracleEbizandFusionVideos]

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]

@@OracleEbizandFusionVideos Hi Anything not relating to any other modules?

[@OracleEbizandFusionVideos]

@@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

[@raghuraghu-hi7qm]

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.

[@OracleEbizandFusionVideos]

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

[@PavanVasireddy-tl2qr]

Hi Sir In AR what is the difference between close and close pending status in period close

[@OracleEbizandFusionVideos]

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

[@PavanVasireddy-tl2qr]

@@OracleEbizandFusionVideos Thanks for the reply sir

[@ravinder8774]

Coluld you please explain AP & AR Issues? For which you raised SR those issues. Explain from starting to till you get solutation.

[@OracleEbizandFusionVideos]

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]

@@OracleEbizandFusionVideos Thanks for replying, Any Auto invoice related issues during importing invoice?

[@ravinder8774]

@@OracleEbizandFusionVideos You mentioned orphan records, what dose it mean?

[@OracleEbizandFusionVideos]

@@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.

[@OracleEbizandFusionVideos]

@@ravinder8774 Most of the Auto invoice issues are related to data or setup. After correcting them, we were able to import the invoices successfully

[@srikarthatha408]

Can you please do video for ar interfaces

[@OracleEbizandFusionVideos]

Sure

[@anelmah]

Love it

[@OracleEbizandFusionVideos]

Thanks

[@PavanVasireddy-tl2qr]

Can we create transactions in close pending period status?

[@OracleEbizandFusionVideos]

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

[@PavanVasireddy-tl2qr]

@@OracleEbizandFusionVideos Thanks for the reply sir

[@sunnyd5143]

Any Cash Management reconciliation step by step videos?

[@OracleEbizandFusionVideos]

Hi Sunny, i will let you know once i create a Video on Cash Management Bank Account reconciliation functionality

[@OracleEbizandFusionVideos]

Hi Sunny, as requested, please find below video on Oracle Cash Management Bank Statement import and Reconciliation process:- kzbin.info/www/bejne/ooCWnWqQiayWrck

[@abhisekhnayak5780]

Do we have any report for finding list of receivable accounts one OU has. Here u have 3 accounts

[@OracleEbizandFusionVideos]

You need to run backend SQL query to get this from XLA tables

[@abhisekhnayak5780]

@@OracleEbizandFusionVideos thanks a lot

[@guhant9249]

can you share the excel it may help

[@OracleEbizandFusionVideos]

Please ping me your email id so that i can share the excel

[@guhant9249]

Thanks so much

[@guhant9249]

Unable to send my email id

[@OracleEbizandFusionVideos]

You can ping me your email id here

[@abrahamtembo]

could you share the excel? very nice explanation

[@OracleEbizandFusionVideos]

Please ping me your email address on my facebook page so that i can send you the excel spreadsheet

[@stayraw2009]

Can you pls share your documents with me.. it's very easy understand. Thanks for the video.

[@OracleEbizandFusionVideos]

Ping me on my facebook page

[@stayraw2009]

@@OracleEbizandFusionVideos done sir

[@stayraw2009]

@@OracleEbizandFusionVideos if possible pls share the link.

[@OracleEbizandFusionVideos]

@@stayraw2009 facebook.com/CAArvindVaraganti

[@oraclefinance4315]

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.

[@OracleEbizandFusionVideos]

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

[@oraclefinance4315]

Thanks for your clarification