Hi guys.
I have a question on synchronizing currency rates between SAP R/3 and SAP BW.
The following details might help you to understand my situation:
<b>[SAP R/3]</b>
Document Date: 09.02.2006
Report Date : 06.07.2006
Amount : 100.00 USD
Amount in LC : 380.00 MYR
<b>[SAP BW]</b>
Document Date: 09.02.2006
Report Date : 06.07.2006
Amount : 100.00 USD
Amount in LC : 350.00 MYR
As you can see today's (Report Date : 06.07.2006) report in SAP R/3 would produce 380.00 MYR where as it is 350 MYR in SAP BW.
So how do I synchorize the currency rate and amount in SAP BW with SAP R/3?
P/S: I am using <b>Currency Translation > Currency Conversion Key > Average Rate for Current Date</b> in my SAP BW's Amount properties.