there shall be a nice tutorial somewhere where they talk about consolidated exchange rates, types etc. do you know which I am looking for?

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you are looking for a tutorial or explanation about consolidated exchange rates in NetSuite. Here's a summary of the key points discussed in the threads: 1. There are two types of currency conversions in NetSuite: Transactional and Consolidated. Transactional conversion happens when a transaction is booked in a subsidiary with a different currency. The conversion is done using the exchange rate shown on the transaction, which is a day-specific rate. 2. Consolidated conversion occurs when you translate an entire General Ledger from a subsidiary's currency to a parent subsidiary's currency. This is done using a "Consolidated Exchange Rate" table in NetSuite. There are three types of rates in this table: Current, Historical, and Average. Each account from the General Ledger uses one of these types of conversions. These rates are set per period, not per day. 3. When running a Saved Search, NetSuite converts your results to the highest-level subsidiary you have access to. This is a consolidated conversion, not a transactional one. The figures all get converted using the Consolidated Exchange Rates that are in effect as of "right now" (current period). 4. You can edit your saved search and set a field to "None", so that no conversion occurs: the figures from the search would remain in the original currency and not be converted. 5. When generating a Trial Balance to Parent Topco (consolidated), the exchange rates might differ for transactions posted on the same date and in the same posting period. This could be due to the different types of consolidated exchange rates (current, average, historical) assigned to each account. For more detailed information, you might find these resources helpful: - SaltoLeap course on Mastering NetSuite Financial Data: https://hub.salto.io/courses/Mastering-NetSuite-Financial-Data - Article on NetSuite Currency Translation: https://meir.prolecto.com/2022/11/21/netsuite-currency-translation-ii/ ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******