Scenario
User would like to know if there's a way to determine which accounts have the 'Revalue Open Balance for Foreign Currency Transactions' checkbox selected. User attempted to create a saved search for this, but this checkbox doesn't appear as an option in either the criteria or results section.
Solution
The ability to show which accounts have been marked for currency revaluation on saved search is currently a system limitation logged under Enhancement #209091 Ability to show the Revalue Open Balance for Foreign Currency Transactions field in the Account Search, Saved Report and ODBC.
You can vote for this enhancement on the SuiteIdeas page.
An alternative solution or workaround you can try is:
1. On the Account Saved Search under the Criteria tab, add System Notes : Field = is Revalue Open Balance
2. Under the Results tab, add the following:
- Name | Group (Summary Type)
- Display Name | Group (Summary Type)
- Account Type | Group (Summary Type)
- Description | Group (Summary Type)
- Balance | Group (Summary Type)
- Formula (Text) | Maximum (Summary Type) | Formula = DECODE({systemnotes.field}, 'Revalue Open Balance', {systemnotes.newvalue}, ' ') | When Ordered By Field = System Notes : Date
3. This is how it would look like:
-----
If you find this information useful, let us know by reacting or commenting on this post!