how do you calculate a saved search to get the average exchange rate for a month

AI generated answer (using internal Slack threads):

To calculate a saved search to get the average exchange rate for a month, you can use a currency rate search or a consolidated exchange rate search. These searches will provide you with the exchange rates for the specified period. However, please note that the exchange rate applied will depend on the consolidated exchange rate setting. If you select

Per Account

, the rate that gets applied will depend on the GL account associated with the transaction line. For assets and liabilities, the current rate will always get applied, regardless of the transaction dates. If you are creating a transaction saved search and want to use the current exchange rate, you might need to pull it from the transaction itself. Please note that for balance sheet accounts, the saved search will give you the current rate if the exchange rate is per account for all months historical and current. There is no way to pull a balance sheet account from the search with the proper historical period rates without doing some conversion yourself with the exchange rate table. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******