Hi Chaitanya, Thanks for your feedback, sorry i wish i can upload PPM video too, but as i am expert in Oracle Finance so sharing knowledge within Finance Module.
Thank You for watching. Please let me know if you have any further query related Oracle. i will be more happy to reply you. Sorry- last couple of months i was not active on youtube because of very busy schedule.
Hi Satish, Thanks for watching my channel, i have started working to record video with all the possible scenario, i believe it will help a lot as i faced challenges in AR to GL reco and sometime its very hard to find out the difference and using backend query i almost can do AR to GL reco quickly. you will get notification when video will uploaded.
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? What needs to be done to reconcile this? Thank you so much
Hi Vatan, unapplied receipt register, if you run for specific period that will show all the unapplied receipt and those receipt in that period ex: Jan-23 in jan-23 period accounting will be transfer those you can see in unapplied receipt register journal entry report. normally you can check 1. if unapplied receipt is not done in future period, some time its happened if user applied receipt in Jan-23 and during closing they found that receipt application user did wrong so user unapplied the transaction and when user does by default system take current sysdate on unapplied screen so by default it will be feb-23 date so it may create differences in the closing. 2. make sure in GL all entries are transfererd and posted to GL. 3. sometime entries status shows posted to GL or transfer to GL but in backed only flag updated so you have to prepare a query to execute on db level using sql query. on XLA table (Xla events/xla_ae_headers/xla_ae_lines) i have some query which can easily tell you the differences, i will check and posted here which will help you to find out the incorrect accounting transaction/receipt. Thank you for watching my channel.
I have interviewed last month.. im junior in oracle. they asked me about AR. I blurred. And they shocked i dont know about AR. Yes.. i dont have that module.. for company i am supporting.. we only have GL..AP..Inventory..and Purchasing.. we dont have AR.. then they asked "how u do revenue". Im clueless. Is it strange thing if we dont have AR?
Hi Nana, It may be, they have other system to record Revenue and from that legacy system they are doing interface into GL directly to have revenue in the Trial balance. I have seen such type of cases in couple of companies, they are not using AR, but using other modules, when i checked the business scenario and the concept they explained me like which i mentioned. Please let me know if you have any further query related Oracle. i will be more happy to reply you. Sorry- last couple of months i was not active on youtube because of very busy schedule.
thank you very use full
Glad it helped, Thank you for watching my channel.
Nice channel Sir...your videos are very helpful...I learned alot....Could you please make some more videos on Projects module (PPM)
Hi Chaitanya,
Thanks for your feedback,
sorry i wish i can upload PPM video too, but as i am expert in Oracle Finance so sharing knowledge within Finance Module.
@@Sohatechworld you are champ of shergarh
Super explanation sir. No vidoe is available in youtube with such a clear explanation. Waiting for AP to GL reconciliation.
Thank You for watching.
Please let me know if you have any further query related Oracle. i will be more happy to reply you.
Sorry- last couple of months i was not active on youtube because of very busy schedule.
hello sir , please upload the session for backend reconciliation
Hi Satish,
Thanks for watching my channel,
i have started working to record video with all the possible scenario, i believe it will help a lot as i faced challenges in AR to GL reco and sometime its very hard to find out the difference and using backend query i almost can do AR to GL reco quickly.
you will get notification when video will uploaded.
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? What needs to be done to reconcile this? Thank you so much
Hi Vatan,
unapplied receipt register, if you run for specific period that will show all the unapplied receipt and those receipt in that period ex: Jan-23 in jan-23 period accounting will be transfer those you can see in unapplied receipt register journal entry report.
normally you can check
1. if unapplied receipt is not done in future period, some time its happened if user applied receipt in Jan-23 and during closing they found that receipt application user did wrong so user unapplied the transaction and when user does by default system take current sysdate on unapplied screen so by default it will be feb-23 date so it may create differences in the closing.
2. make sure in GL all entries are transfererd and posted to GL.
3. sometime entries status shows posted to GL or transfer to GL but in backed only flag updated so you have to prepare a query to execute on db level using sql query. on XLA table (Xla events/xla_ae_headers/xla_ae_lines)
i have some query which can easily tell you the differences, i will check and posted here which will help you to find out the incorrect accounting transaction/receipt.
Thank you for watching my channel.
I have interviewed last month.. im junior in oracle. they asked me about AR. I blurred. And they shocked i dont know about AR. Yes.. i dont have that module.. for company i am supporting.. we only have GL..AP..Inventory..and Purchasing.. we dont have AR.. then they asked "how u do revenue". Im clueless. Is it strange thing if we dont have AR?
Hi Nana,
It may be, they have other system to record Revenue and from that legacy system they are doing interface into GL directly to have revenue in the Trial balance.
I have seen such type of cases in couple of companies, they are not using AR, but using other modules, when i checked the business scenario and the concept they explained me like which i mentioned.
Please let me know if you have any further query related Oracle. i will be more happy to reply you.
Sorry- last couple of months i was not active on youtube because of very busy schedule.
AP to GL reconciliation plz
It will be uploaded soon. Thanks