This fixed exchange rate is for report purposes only & is applied when revaluating financial reports such as 'Trial Balance'.
Consider the following Journal Entry (JE) created in a UK localisation where the exchange rate for the foreign currency (FC) EUR is set to 5.00:
The GL accounts involved must be defined to be relevant for revaluation:
When running a financial report such as the Trial Balance, the user may choose to display the result according to a currency revaluation, choosing to use the 'Fixed Rate' from the journal entry (above):
The resulting report will now show the revaluated amounts according to the 'Fixed Rate' in the JE:
The report uses the rate of 4.00, as specified in the JE for revaluation, regardless of the exchange rate defined for the day.
If there is a requirement to create a JE where the exchange rate differs from the one defined under Administration ð Exchange Rates & Indexes, follow the steps below:
- Financials -> Journal Entry.
- Tick the box 'Display in FC'.
- Call up the form settings by clicking on the 'Form Settings' icon in the icon bar.
- On the 'Table' tab, ensure that the box 'From FC Field' is unticked.
- Enter the appropriate amount in local currency (LC) & manually calculate what this amount should be in foreign currency (FC)
- Then, enter this amount in the FC column. The setting above on the 'Table' tab prevents an update of the value in LC. Hence any amount may be entered here, regardless of the exchange rate defined for the posting date.