When Multi‑Currency is enabled, the Cashbook Payment screen will include a Currency section.
The local currency is selected by default, and totals are shown only in the local currency.
Users can choose a different currency, and when the selected currency is not the local currency, the Exchange Rate section appears.
The system automatically loads the exchange rate for the transaction date and selected currency, and users may override this rate if needed and this is a mandatory field.
Add the line details as usual in the section below.
All amounts are displayed in the selected currency, and the footer shows the Net amount in both the foreign currency and the local currency.
Please note: Cashbook payments use the Smart Grid functionality check Smart Grid on Transaction views - Article Editor to know more about how smart grid works on transaction views
Why can’t I sort the Cashbook Payments fields when FX is enabled?
Our team is currently developing a feature that will enable sorting on Transaction grids when FX is enabled. Once this enhancement is complete, users will be able to apply sort order to Cashbook Payments and other transaction grids
FX Conversions Not Displaying Correctly
Description
We have identified an issue affecting how exchange rates are displayed when switching between foreign and local views.
When an exchange rate is entered (e.g., 0.59 USD per 1 NZD), the system displays the same value regardless of the selected display mode
Example
- Exchange rate: 0.59 USD per 1 NZD
- Expected Local Display: 1 / 0.59 = 1.67
- Actual Local Display: 0.59
Workaround
- Ensure “Display Currency As” on the currency code is Foreign.
- Enter the exchange rate as the foreign amount that 1 NZD purchases. For example, based on the scenario above, you would enter 0.59, as this is the amount of USD required to obtain 1 NZD.
