ACTION PLAN
===========
As this issue is related to two modulesie, general ledger and Payables, it taking sometime.
From the General ledger side , I would explain how the revaluation works or gets calculated.
When ever the revaluation is run in the general ledger, then the revaluation calculates the
revaluation amountas per the follwing formula for each account that needs to be r
evalued.
The calculation would depend on the Profile Option GL: Income Statement Revaluation Rule
If the above profile is YTD, then when ever the revaluation is run,
the revaluation would use the following formula
YTD=== ACCOUNT AMOUNT = ((begin_balance_dr + period_net_dr - begin_balance_cr - period_ne
t_cr) * revaluation_rate)
LESS(begin_balance_dr_beq + period_net_dr_beq - begin_balance_cr_beq - period_net_cr_beq)
If the above profile is PTD, then when ever the revaluation is run, the revaluation would use the following formul
a.
ACCOUNT AMOUNT =((period_net_dr - period_net_cr) * revaluation_rate)) LESS(period_net_dr_beq - period_net_cr_beq)
Liability and asset accounts always are revaluated using YTD formula. Note 160461.: How Does the Revaluation Pr
ocess Work?
Please also refer the above note to review the revaluation process in general ledger After reviewing the above,
please kindly get in touch with the payables team and review how the amounts are calculated in the open items
revaluation report.
The general ledger would not be able to know how the open item revaluation reports works as thisreport belongs to receivables team.
I kindly request you, to get this information from the payablesteam.
After getting the clarification, if you find if the formula for revaluation in general led
ger and for open itemsreport is same, then please update this SR.
After your update, we can take a sample account and comparethe revaluation in general ledger and the open items report.
Note:
SR Number | 7415104.992 | Open Date | 10-FEB-09 08:30:02 |
Product | Oracle Payables | Product Version | 11.5.10 |
Abstract

AP Module(Open Items Revaluation Report) doesn't tally with GL Module
The 'Total Open Functional Amount' in the 'Open Items Revaluation Report'
and the 'Total for Report' in the 'Accounts Payable Trial Balance' display the same (i.e.,Unpaid, Open Invoices.)