Great Sir one question on this. Sometimes Reval Journals are reversed by the company at end of the month. Can you explain why a reversal gets done? When we should ideally be having the Reval Journal to fill the currency gap ?
Hi , Suhas Great video, Could you help somehow to raise information for zero dollar amount journal lines in GL?
Short description: Suppress zero amount journal lines Description: IPI tax amount of invoice 72687 is BRL 0.00, so there is no need to generate a GL entry. There is a way to supress postings which shows balance zero: DR and CR in the same amount and same code combinations?
Thanks Suhas Vaze for the video, I have one question. How do you do revaluation for foreign trades FX Spots in Treasury to get the loss/gains and post them to GL?
Dear Samson, Revaluation in GL is done only for recording OUTSTANDING BALANCES and not the profit/loss arising in transactions. The Currency Loss/Gain on transactions are recorded when transactions are settled. Not sure about treasury module, but in a similar context of AP and AR, such loss/gains will be recorded at the time of Payment or Receipt.
What happens if the Revaluation amount is negative? WRT to the example shown in the video, if daily rates of 31-MAR is less than 5-Mar, is same process followed? Does revaluation happens in this case.
Hi Suhas, Thanks for sharing free videos. It was really helpful in getting the concept clear. Following are few queries: 1. Should the revaluation process be performed for all the foreign currency transactions or is it for all the unpaid payable invoices and receivables invoices for which we are yet to receive the money? 2. Do we need to reverse the Journal entries created in the subsequent month? Is the process for the same or system takes care of it automatically? 3. Difference between Realized Gain/Loss Account and Unrealized Gain/ Loss Account. Thanks & Regards Saleem Javed
Dear Saleem, you need to revalue only outstanding asset/liability balances in foreign currencies. Unrealised gain loss is when balance is yet outstanding. Realised gain loss occurs when the foreign currency balance is paid out.
Thanks Suhas for your quick response. Do we need to reverse the entries created by the revaluation process in the subsequent month? Thanks & Regards Saleem Javed
Dear Saleem, There is no need to reverse the entries. Next time you do the revaluation, Oracle remembers the last updated revaluation rate and gives effect accordingly. E.g. If you ran revaluation on 28-Feb-15 (and posted the revaluation Journal). Then ran revaluation on 31-Mar-15, then it will see the forex rate change from 28-Feb-15 to 31-Mar-15 for the revaluation dated 31-Mar-15)
Suppose the Outstanding receivable entry that you have shown in the video for the month of Mar-16 is settled/paid in the subsequent month (i.e. 10-Apr-16), then system would generate entries for Realised Gain/Loss Account in the AR module. At this point, we will have the entry for Unrealised Gain/Loss Account dated 31-Mar-16(i.e. generated through revaluation process) and entry for Realised Gain/Loss Account dated 10-Apr-16(i.e. generated through Customer Receipt Accounting process). Is this not a kind of duplicacy that we have? Shouldn't the revalued entry be reversed at the start of Apr-16? Thanks & Regards Saleem Javed
Dear Saleem, The GL Revaluation is done on a month to month basic. When you do Revaluation after the "Receipt" of money, the Unrealized Gain/Loss (relating to earlier outstanding amount) is automatically reversed by Oracle. Hence there is no duplication. Mighty Oracle !!!
Hi Suhas, great video on this feature. One question - Is there any standard report available which tells how this revaluation calculation is done in Oracle. You showed an example with 1 invoice but when we have thousands of invoices, how to make sure that the system is creating accounting correctly?
Download Brochure for Books on Oracle Fusion and Oracle eBusiness Suite R12 Financials -- For Oracle Fusion -- drive.google.com/file/d/0B7SodV78txUASXFoOHptZUxMY00/view?usp=sharing For Oracle EBS R12 - drive.google.com/file/d/0B7SodV78txUAU2NWOUlQdXJOTDg/view?usp=sharing
Very nice explanation. In detailed an example with clear sequence of steps. Thanks!!
-Dayakar Reddy
Hong Kong
Thank you Dayakar!
Great Sir one question on this. Sometimes Reval Journals are reversed by the company at end of the month. Can you explain why a reversal gets done? When we should ideally be having the Reval Journal to fill the currency gap ?
is there any way to upload the revaluation ranges?
Script, interface or API
Hi , Suhas
Great video, Could you help somehow to raise information for zero dollar amount journal lines in GL?
Short description: Suppress zero amount journal lines
Description: IPI tax amount of invoice 72687 is BRL 0.00, so there is no need to generate a GL entry.
There is a way to supress postings which shows balance zero: DR and CR in the same amount and same code combinations?
Thank you
Hi sir u know the revaluation formula
Excellent Video, it is very useful for new enters, could you please provide Translation video same as.
thanks for your videos.
Hello sir, very nicely explained. thank you for your video's .
Thank you for your appreciation! Good luck.
Thanks Suhas Vaze for the video, I have one question. How do you do revaluation for foreign trades FX Spots in Treasury to get the loss/gains and post them to GL?
Dear Samson, Revaluation in GL is done only for recording OUTSTANDING BALANCES and not the profit/loss arising in transactions. The Currency Loss/Gain on transactions are recorded when transactions are settled. Not sure about treasury module, but in a similar context of AP and AR, such loss/gains will be recorded at the time of Payment or Receipt.
What happens if the Revaluation amount is negative? WRT to the example shown in the video, if daily rates of 31-MAR is less than 5-Mar, is same process followed? Does revaluation happens in this case.
Dear Mahesh, Yes. Same process is followed if daily rate is less on target date.
Thank you. All most all videos are helpful in understanding EBS.
Thanks Mahesh...
Hi Suhas, Thanks for sharing free videos. It was really helpful in getting the concept clear. Following are few queries:
1. Should the revaluation process be performed for all the foreign currency transactions or is it for all the unpaid payable invoices and receivables invoices for which we are yet to receive the money?
2. Do we need to reverse the Journal entries created in the subsequent month? Is the process for the same or system takes care of it automatically?
3. Difference between Realized Gain/Loss Account and Unrealized Gain/ Loss Account.
Thanks & Regards
Saleem Javed
Dear Saleem, you need to revalue only outstanding asset/liability balances in foreign currencies. Unrealised gain loss is when balance is yet outstanding. Realised gain loss occurs when the foreign currency balance is paid out.
Thanks Suhas for your quick response.
Do we need to reverse the entries created by the revaluation process in the subsequent month?
Thanks & Regards
Saleem Javed
Dear Saleem, There is no need to reverse the entries. Next time you do the revaluation, Oracle remembers the last updated revaluation rate and gives effect accordingly. E.g. If you ran revaluation on 28-Feb-15 (and posted the revaluation Journal). Then ran revaluation on 31-Mar-15, then it will see the forex rate change from 28-Feb-15 to 31-Mar-15 for the revaluation dated 31-Mar-15)
Suppose the Outstanding receivable entry that you have shown in the video for the month of Mar-16 is settled/paid in the subsequent month (i.e. 10-Apr-16), then system would generate entries for Realised Gain/Loss Account in the AR module.
At this point, we will have the entry for Unrealised Gain/Loss Account dated 31-Mar-16(i.e. generated through revaluation process) and entry for Realised Gain/Loss Account dated 10-Apr-16(i.e. generated through Customer Receipt Accounting process).
Is this not a kind of duplicacy that we have? Shouldn't the revalued entry be reversed at the start of Apr-16?
Thanks & Regards
Saleem Javed
Dear Saleem, The GL Revaluation is done on a month to month basic. When you do Revaluation after the "Receipt" of money, the Unrealized Gain/Loss (relating to earlier outstanding amount) is automatically reversed by Oracle. Hence there is no duplication. Mighty Oracle !!!
See more Free Videos and Purchase Books on Oracle Fusion and eBusiness Suite R12
facebook.com/R12FinancialsBookSet
Hi Suhas, great video on this feature. One question - Is there any standard report available which tells how this revaluation calculation is done in Oracle. You showed an example with 1 invoice but when we have thousands of invoices, how to make sure that the system is creating accounting correctly?
Very Clear and pleasant. Great!
Thank you Miyuru!
Download Brochure for Books on Oracle Fusion and Oracle eBusiness Suite R12 Financials --
For Oracle Fusion -- drive.google.com/file/d/0B7SodV78txUASXFoOHptZUxMY00/view?usp=sharing
For Oracle EBS R12 - drive.google.com/file/d/0B7SodV78txUAU2NWOUlQdXJOTDg/view?usp=sharing