Unable to Account for Exchange Rate Variances for Revenue and Invoices
Last updated on DECEMBER 09, 2016
Applies to:Oracle Project Billing - Version 184.108.40.206 and later
Information in this document applies to any platform.
EXECUTABLE:PARGDR - PRC: Generate Draft Revenue for a Range of Projects
Why is revenue generated for foreign currency expenditure items using an exchange rate based on the Accrue Through Date parameter rather than the dates of the expenditure items?
This is causing problems when revenue and invoices are generated on different dates, because the exchange rates used are therefore different and the revenue amounts do not match the billing amounts.
These conversion differences are not posted to any gain/loss or variance account, but rather to unearned revenue, or unbilled receivables, leaving a balance in these accounts even after all transactions have been fully processed.
Multi Currency Billing: Enabled
Agreement and all funding in functional currency (USD = US Dollars).
Corporate exchange rates
01->31 DEC 2010 .5 USD/CAD
01->30 NOV 2010 .75 USD/CAD
Enter expenditure items in CAD (Canadian Dollars):
EI Date: 19-NOV-2010
Amount: 100 CAD
Functional Exchange Rate Date: 19-NOV-2010
Exchange Rate type: Corporate
Functional Amount: 75 USD
Generate draft revenue for project (with bill rate same as cost rate)
Accrue through date: 29-NOV-2010
Exchange rate: .75
Revenue generated for US $75
DR to Unbilled Receivable = US $75
Generate draft invoices for project through 30-DEC-2010
Bill through date: 30-DEC-2010
Invoice Date: 30-DEC-2010
Exchange Rate: .5
Invoice generated for US $50
CR to Unbilled Receivable US $50
As a result, though the expenditure item has been fully processed the unbilled receivable account (UBR) has a net remaining DR balance of US $25. This amount will not be cleared even when all transactions on the project have been fully processed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms