I have a following scenario regarding the exchange rates.
I have following currencies maintained in my system
Company Code Currency-As per the country(for example AED for UAE)
I have maintained following exchange rates
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
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
Please suggest as soon as possible.