When creating a Saved Search in OneWorld, the amount column from non-parent is automatically converted to the base currency of the Parent Subsidiary. Did you know that you can view these amounts in the base currency of their respective subsidiary and view the original amounts in transactions (for example: Foreign Amounts entered in an Invoice) Here how:
1.) Navigate to List > Search > Saved Searches > New
2.) Select Transaction
3.) Add a Criteria
Type (Optional) – For your Transaction Type
Subsidiary (Optional) – Select Subsidiary
Period (Optional) – Select an Accounting Period
Account (Optional) – If you wish to view balances of a particular account
4.) Under Results tab set the Consolidated Exchange Rate = None
When this is set to None, the Consolidated Exchange Rate is not applied to the Amount, this will make the amount column results to per Subsidiary.
5.) In the Results tab column, make sure that you add these important fields:
Amount – This will be the amount posted in the G/L of the transaction subsidiary. You can rename this to Subsidiary Base Currency Amount
Currency – Thisthe Transaction Currency
Amount (Foreign Currency) – This is the transaction currency, please take note that even if the transaction is posted in the same currency of the subsidiary, this will still column will still have values. You can rename this to Transaction Currency Amount
6.) Rename Saved Search
7.) Save and Run the Report
In this example, Invoice # 266 is recorded using Philippine Peso, but it is posted in a German subsidiary with a base currency of Euro. Here is the original transaction:
Subsidiary Base Currency Amount is equal to Exchange Rate X Transaction Currency Amount, in this scenario PHP 25,000 X 0.0171 or €427.50 in the G/L Impact