Skip to Content
Former Member
Feb 22, 2008 at 08:36 AM

Currency Transaltion from USD to INR basing on Bill docdate.


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.