Revenue recognition using historical exchange rate
We have a request from users to have all non-USD Revenue Recognition be posted using the exchange rate used in the original invoice. For example, we have a Service contract with a customer for which we bill them in Dec 2006. The currency is EUR and in Dec 2006, the invoice was posted in USD with the Dec exchange rate. At this time, the posting is made to the Customer (AR) and to Deferred Revenue. We then run the Revenue Recognition program (VF44) monthly to recognize the revenue (debit Deferred revenue and credit Revenue). However, the Revenue Recognition posted in January, will use the Jan exchange rate, Revenue Recognition run in February, will use the Feb exchange rate, and so on. In this example, users would like to have all the revenue recognition be posted using Dec 2006 rate.
The only way we could think of is to create a user exit that will look at the original billing doc during the processing of VF44.
If any of you have had similar request and know a better way to resolve this, we would truly appreciate the input.