Exchange Rates

- Exchange Rates

If your Own Organisation trades in more than one currency, you can create Transaction Documents in any foreign currencies you use and can control the Exchange Rate that's applied to those transactions. The Exchange Rate is used to convert the foreign currencies into your Home Currency, enabling you to create reports in your Home Currency.

Exchange Rates can be changed at any time; you may update them daily, weekly or monthly or on an ad hoc basis.

Exchange Rates are applied by looking at the document date and using the Exchange Rate that you've set for the corresponding time period. For example, if you've set Exchange Rate 'A' for 1-15 December and Exchange Rate 'B' for 16-31 December, a Transaction Document dated 10 December will use Exchange Rate A, whereas a Transaction Document dated 16 December will use Exchange Rate B.  

Exchange Rates and Transaction Documents in a Draft state are linked, therefore Home Currency values will change to reflect any rate changes. Thus, in the example quoted above, if the date on the second Transaction Document is changed (whilst the document is still in a Draft state) from 16 December to 10 December, the Exchange Rate will change from rate B to rate A.

When a Transaction Document is changed from a Draft state to Posted, the Exchange Rate in place at the time (based on the document date) will be applied. This Exchange Rate will not change unless a user with the necessary capability to edit a posted transaction changes the document date.

Where Line Items are added to Transaction Documents whose price in the product book is in a third currency (ie, neither the Home nor the Document currency), Workbooks will display these in the Transaction Document in the Document currency, based on the exchange rates prevailing at the time.  These figures will not be re-calculated, even when the document is Posted.  This should be taken into consideration before Posting (completing) the document.