The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Interface to automatically update exchange rates

Highlighted
Adam Morse
Acclaimed Contributor

Interface to automatically update exchange rates

Can anyone tell me if they have built or tried to build a interface to any other application to update exchange rates (say monthly) in PPM? If yes, please shed some light on what tables and what they used as the trigger on the PPM side to propigate the calculations with the new FX rate.
1 REPLY
Sascha Mohr
Esteemed Contributor

Re: Interface to automatically update exchange rates

To my knowledge, there is no automatic update. It would surely be possible to create such a thing as e.g. the ECB provides a webservice to get current FX rates and then populate the table kcst_fx_update_service properly.
But there may be a reason for this not being in the product. Often exchange rates are update in companies on a certain schedule like monthly. It's the same functionality in PPM doing this manually, you give a start date for the new fx rate. Nevertheless even in this situation it would be nice to pull the rates monthly from the ERP system.
//Add this to "OnDomLoad" event