How can I get a report or saved search that can show me the ending balance of all bank accounts at the end of a period in their currency?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To get a report or saved search that can show you the ending balance of all bank accounts at the end of a period in their currency, you can follow these steps: 1. Create a new saved search from the 'Account' record type. 2. In the 'Criteria' tab, add a filter for 'Type' and set it to 'Bank'. 3. In the 'Results' tab, add the following fields: - Name (this will display the name of the bank account) - Currency (this will display the currency of the bank account) - Amount (Foreign Currency) (this will display the balance in the account's currency) 4. To get the ending balance at the end of a period, you can add a filter in the 'Criteria' tab for 'Date' and set it to the end of the period you are interested in. Please note that the 'Amount (Foreign Currency)' field will display the balance in the account's currency. If you want to display the currency symbol, you can use a Formula (Text) field with a formula like

'$'||{amount}

. If there are multiple possible currencies, you can use a CASE WHEN statement in your formula to pick the right one. Also, if you want to restrict the search based on the 'Restrict by Location' field in the account setup, you can add a filter for 'Location' in the 'Criteria' tab and set it to the location you are interested in. Please note that this approach might not work if there are significant fluctuations in currency exchange rates, as these can have a high impact on the reported balances. In such cases, you might want to consider using the Currency Revaluation feature in NetSuite. Finally, if you want to display the total balance of multiple bank accounts in their respective currencies, you might need to create separate saved searches for each bank account and then combine the results manually, as NetSuite's saved searches do not support this functionality directly.