Skip to Content
0
Former Member
Jan 05, 2008 at 11:57 AM

exchange rate maintainance-Suggestion please

50 Views

Hi,

I have a following scenario regarding the exchange rates.

I have following currencies maintained in my system

Global Currency-USD

Group Currency-SAR

Company Code Currency-As per the country(for example AED for UAE)

I have maintained following exchange rates

AED-->SAR

AED-->USD and vice versa

We have maintained similarly for all the participant countries currencies with SAR & USD

We have also maintained all the other currencies,(like vendor currencies) with the respective company code currencies currencies .

For example if a vendor currency is JPY and I am making payment in country UAE with it's currency as AED then we have maintained JPY--> AED & vice versa.

However, system asks us to maintained rates for

JPY-->USD

JPY-->SAR

This becomes too much of a work as everytime when new currency comes in to system for any new vendor then we have to maintaine this currency not only with the company code currency but also with USD & SAR.

If the rates are to be maintained everyday then it will become a very hugh & complex task.

I am not sure whether this is the way it has to be maintained or is there any other way that can help us.

Like if we want to maintain CHF(vendor currency) in UAE I will simply maintain that but I should not be propted for maintaining CHF with SAR & USD.

Can system automatically pick up from AED(or for that matter any company code currency) >USD or AED >SAR ?

Please suggest as soon as possible.

Best Regards,

BM