The quick answer
In a OneWorld account with subsidiaries, open the saved search, choose Edit this Search, open the Results tab and set Consolidated Exchange Rate. The default, Per-Account, translates each line with the rate type of its account so the Amount column is intended to align with consolidated reporting. None applies no consolidated rate and states Amount in the transaction subsidiary's functional currency. In the example, choosing None and selecting Save & Run changed BILL1041's Amount from 6,000.00 to 8,208.00, which is the $6,000.00 transaction amount times the 1.36800000 exchange rate. Amount (Foreign Currency) did not change.
The setting changes the values of base-currency amount fields such as Amount in the search results. It does not change the transaction, its exchange rate or its general ledger impact. The example is a OneWorld account with a Canada subsidiary, and the names, numbers and amounts are fictional example data. Your account shows its own subsidiaries, currencies and rates, and the labels and choices depend on your role and release.
Before you start
You need a OneWorld account with a subsidiary whose functional currency differs from the parent's, transactions in that subsidiary to search, and permission to view and edit the saved search. Also confirm the parent company's currency, each subsidiary's functional currency, your own subsidiary access, the General Rate Type of the accounts involved and the Currency Exchange Rates in your account. The currency of a transaction search result depends on the search's subsidiary context, the lowest-level subsidiary that is a common parent of the subsidiaries in the result set, which your subsidiary access limits. It is not simply the parent's currency. Two users whose accessible subsidiaries differ can see different currencies or rows from the same saved search. If you use Multi-Book Accounting, confirm the accounting book when you compare a search with a report.
The example search, Subsidiary Currency Check, lists three bills for the Canada subsidiary: BILL1041, BILL1042 and BILL1043. Each bill is in US Dollar with an Exchange Rate of 1.36800000 to the subsidiary's functional currency, Canadian dollars. Changing the setting on a search that other people use changes the results they get, so check who uses it first or save a copy.
01. Read the default Amount
Run the saved search and read the columns beside Amount. Under the default Per-Account setting, BILL1041 shows Currency US Dollar, Exchange Rate 1.36800000, Amount (Foreign Currency) $6,000.00 and Amount 6,000.00. Here Amount equals Amount (Foreign Currency). That is a result of the rates in this account and of the search's context, not a rule: Per-Account translates with each account's rate type, and the result can differ in your account.
02. Open the Results tab
Select Edit this Search and open the Results tab. Consolidated Exchange Rate sits under Output Type and reads Per-Account. New searches start with that value, so a search nobody changed behaves as Per-Account. The setting applies to the Amount field in the search results, not to criteria or to Amount (Foreign Currency).
03. Choose None
Open the Consolidated Exchange Rate list. It offers Average, Current, Historical, Per-Account and None. None applies no consolidated exchange rate, so each Amount is stated in the functional currency of the subsidiary the transaction belongs to. Choose None.
Average, Current and Historical apply one rate type to every row instead of each account's own rate type. They override the account setup, so the Amount may differ from consolidated statements that use Per-Account. The example did not run them, so use them only when you mean to and test the result first.
04. Save, run and compare
Select Save & Run. BILL1041's Amount now reads 8,208.00: its $6,000.00 transaction amount times the 1.36800000 exchange rate, stated in the Canada subsidiary's functional currency. BILL1042 and BILL1043 read 3,078.00 and 1,285.92. Amount (Foreign Currency) still reads $6,000.00, $2,250.00 and $940.00, and the Exchange Rate column is unchanged. The Exchange Rate column here is the transaction's rate to the subsidiary's functional currency. It is not the consolidated rate that Per-Account uses.
Treat Per-Account as the figure intended to align with consolidated reporting and None as the subsidiary's own currency, and keep the setting you need on the saved search. With None, rows from subsidiaries with different functional currencies are in different currencies, so a total across them is not a meaningful consolidated figure: filter to one subsidiary or use a consolidated rate option. To reconcile any Amount, show Currency, Exchange Rate and Amount (Foreign Currency) beside it and check the setting on the Results tab.
Common questions
What does Consolidated Exchange Rate do on a saved search?
It controls the values of the base-currency amount fields a search returns, such as Amount, translated for the search's subsidiary context. It does not change the transaction, its exchange rate, its general ledger impact or Amount (Foreign Currency). It is a setting on the Results tab of a transaction saved search in a OneWorld account with subsidiaries, and Per-Account is the default.
What is the difference between Per-Account and None?
Per-Account translates each line using the rate type set on its account (General Rate Type), which is commonly Current for balance sheet accounts, Average for income and expense accounts and Historical for equity accounts, though the setting is configurable. It is intended to align the Amount with consolidated reporting when the subsidiary context, period or date, accounting book and filters match. None applies no consolidated rate and shows the amount in the subsidiary's functional currency using the transaction's own exchange rate. It does not show the original transaction amount, which stays in Amount (Foreign Currency).
Why does my saved search Amount not match the transaction?
The transaction shows its own currency, and the saved search Amount is a value calculated for the search under its Consolidated Exchange Rate and subsidiary context. Check the setting on the Results tab, then show Currency, Exchange Rate and Amount (Foreign Currency) beside Amount. A saved search Amount is not necessarily the posted general ledger amount, which uses the transaction's exchange rate. With line-level rows, lines posted to different accounts can use different rate types under Per-Account, and a main-line row's account can differ from the line accounts.
Should I use Average, Current or Historical?
Usually not for reconciling to consolidated statements. Each applies one rate type to every row instead of each account's own rate type, using the consolidated rate for the transaction's period (Average and Historical) or the current rate (Current), which follows the latest applicable date filter, with a period filter taking precedence, or the rate current when the search runs if there is no filter. They override the account setup, so results can differ from consolidated statements that use Per-Account. Use them deliberately and test the result.
Can two people see different Amounts from the same search?
Yes, if their accessible subsidiaries or effective results differ. The saved definition is shared, but the currency and rows can vary with each user's subsidiary access, permissions and filters. Users who see the same subsidiary context and the same rows should see the same values. Changing the setting on a shared search changes it for everyone who runs it, so check who uses the search or save a copy first.
Does the setting affect summary searches and totals?
A summary search and its totals work on the translated amounts. A total under None across subsidiaries with different functional currencies adds amounts in different currencies, so it is not a meaningful consolidated total. Filter to one subsidiary or use a consolidated rate option.
Will every account show these screens and amounts?
No. The example is a OneWorld account with fictional subsidiaries, rates and bills. Your choices, columns, labels and values depend on your subsidiaries, currencies, account setup, role and release.