how to show custom currency exchange rate types on financial reports

AI generated answer (using internal Slack threads):

To show custom currency exchange rate types on financial reports, you can create a custom transaction line field with a formula like

exchange rate x amount

. This will allow you to display the local currency amount on each transaction line item. For a more complex report like a custom Trial Balance showing the GL Account, Total Transaction Currency Amount, Transaction Currency, Consolidated Exchange Rate based on the as of period selected (dynamic), and Base Currency Amount, you would need to use the 'Foreign Currency Amount' (or maybe 'Amount (Foreign Currency)') and 'Exchange Rate' fields. However, keep in mind that when dealing with consolidations between multiple subsidiaries, there's a separate consolidated exchange rate that governs those currency conversions distinct from the spot/transaction rate within the subsidiary. If you need to see a report of exchange rates between two currencies for a specific period, you can create a Currency Exchange Rate search and export the rate by day. To do this, go to Currency Exchange Rate > New > Search in the top right. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******