GLCRVL: What Is The Formula Used By Revaluation Process? (DOC ID 119697.1)

摘自：https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=235614964467156&parent=DOCUMENT&sourceId=187404.1&id=119697.1&_afrWindowMode=0&_adf.ctrl-state=10p99hwpb5_570

 

GLCRVL: What Is The Formula Used By Revaluation Process? (文档 ID 119697.1)转到底部

---

APPLIES TO:

Oracle General Ledger - Version 11.5 and later Information in this document applies to any platform. GLCRVL - Revaluation  

GOAL

What is the formula used by Revaluation process? How can I know if the revaluation result is correct?

SOLUTION

 Profile Option GL: Income Statement Revaluation Rule may be set to YTD (Year To Date) or PTD (Period To Date). Revaluation process uses the following formulas, depending on the value of this profile option:YTD ACCOUNT AMOUNT = ((begin_balance_dr  +  period_net_dr - begin_balance_cr - period_net_cr) * revaluation_rate) LESS (begin_balance_dr_beq + period_net_dr_beq - begin_balance_cr_beq - period_net_cr_beq)  PTD ACCOUNT AMOUNT = ((period_net_dr - period_net_cr) * revaluation_rate)) LESS (period_net_dr_beq - period_net_cr_beq)   The following query may be used to extract data necessary to verify revaluation using these formulas:YTD script Using Help > Diagnostic > examine on the journal entry screen with the cursor on the line with the code combination you want to investigate, change the Field to code_combination_id to identify the code_combination_id to use in this script. You can use the same to identify the set_of_books_id then pass this sql to your DBA indicating what code_combination_id, set_of_books_id and period_name to use.

For R11i SELECT code_combination_id,        translated_flag,        currency_code,        period_net_dr,        period_net_cr,        begin_balance_dr,        begin_balance_cr,        period_net_dr_beq,        period_net_cr_beq,        begin_balance_dr_beq,        begin_balance_cr_beq FROM   gl_balances WHERE  code_combination_id = &CCID AND    actual_flag = 'A' AND    set_of_books_id     = &SOBID AND    period_name         = '&PERIOD' For R12: SELECT code_combination_id,        translated_flag,        currency_code,        period_net_dr,        period_net_cr,        begin_balance_dr,        begin_balance_cr,        period_net_dr_beq,        period_net_cr_beq,        begin_balance_dr_beq,        begin_balance_cr_beq FROM   gl_balances WHERE  code_combination_id = &CCID AND    actual_flag = 'A' AND    ledger_id     = &LEDGERID AND    period_name   = '&PERIOD'

 

Note_1: Liability and asset accounts always are revaluated using YTD formula. Note_2: If the revaluation journal has been posted, it will already be included above, in which case the effect of it needs to be taken into account.

 

 

REFERENCES

NOTE:2641526.1 - REVALUATION in EBS General Ledger R12 - WhitepaperNOTE:2109132.1 - Revaluation Calculator: How to Confirm Revaluation Journal Amounts were Calculated Correctly?