how do I update the consolidated exchange rate table

AI generated answer (using internal Slack threads):

To update the consolidated exchange rate table in NetSuite, you can follow these steps: 1. Navigate to Lists > Accounting > Consolidated Exchange Rates. 2. Here, you can see the existing consolidated exchange rates. Each rate is associated with an internal ID, which is unique to each record. 3. To update a rate, you need to know the internal ID of the rate you want to update. You can find this by doing a Saved Search for Consolidated Exchange Rates and including the internal ID in the search fields. Alternatively, you can have 'Show Internal IDs' checked in your preferences. 4. Once you have the internal ID, you can update the rate associated with it. Note that you cannot change the subsidiary relationship on the record, which is why you can't map those fields to your update. By updating the record via internal ID, you correctly update the rates for that subsidiary relationship. Please note that you can only update base currency rates, other rates are derived rates and are not updatable. Also, you cannot revalue equity accounts. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******