Currency Transaltion from USD to INR basing on Bill docdate.

[Former Member]

Dear Experts

1.In our Query one structure is there in rows in that we restrictecd distrubution channel as Domestic=50 and Export != 50.

2.In keyfigures Actual value week ,Actual quantity week , Actual qty YTD ,Actual qty MTD etc like values also .

3.My report is running on the base of Calweek .i am running the report for feb 2nd week.

4. When report executing it will give me as Domestic under that some product names, and Export again the same product names.

5.Domestic sales we are showing in INR and export sales we r showing in USD.

6.Right now my problem is in Domestic one sales is happend i.e belongs to SEZ which will follow the norms of USD .

7.When i am trying to do currncy transslation its converting the USD to INR but taking the current day exchange rate , I want the exchange rate on the BILL DOC DATE.when its happend .

8.For example suppose today USD rate is 50 means in currency conversion its multiplying with 50 to all records , i want correspondence exchange rates to be considered i.e if 20/02/08 USD rate is 45 means all billing documents belonging to 20 th should multiply with 45 while currency conversion.

9. I think i have explained the problem properly , if any where i went wrong iapplolize for that.

Please give suggestion how to move forward , Give me the step by step procedure , if we want to create our own currency translation type.thanks.

Regards

Satish

[Former Member]

Hi Satish,

You need to create a new currency translation type in transaction RSCUR.

Use the exchnange rate type you want to Use and keep the course and target currency to default selections.

In the time reference choose 'To the exact Day'

and in Standard Infoobject use Billing Doc date. You can now use this in queries for currency translation. Ensure that Billing Doc date is in the Infoprovider on which the query is built.

regards

Gaurav

Edited by: Gaurav Vohra on Mar 20, 2008 9:11 PM