Skip to Content
0
Former Member
Mar 16, 2007 at 03:01 AM

Currency Conversion for historical Amount

47 Views

Hello Experts,

Can some one help me to find a solution for my reporting requirement.

As part of GL reporting, I have a report which shows accumulated balance for given fiscal year/period. If the currency is in USD,I have no issues. When the currency is in non USD(Ex: EUR) I need to convert it into USD at BW side.

Here is the example:

User Enters: Fiscal Year/Period : 2007003

Accumulated Balance for particular GL account might be 300 EUR.

But actual posting might be happened in 2006012.

While converting it to USD it should take the 2006012 exchage rate from TCURR and convert it.

I have created a RRC1 object and used it in Query but it is using 2007003 exchange rate.

Please help me to solve this problem.

Thanks,

Bobby