How to show a report of bank balances on the home dashboard without it translating to the base currency and allowing drilldown into the register

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 show a report of bank balances on the home dashboard without it translating to the base currency and allowing drilldown into the register, you can use the SuiteAnalytics Workbooks feature in NetSuite. This feature allows you to consolidate and convert currencies to one, which can be useful if you want to see subsidiary level reports in a specific currency when the base currency of that subsidiary is different. Here are the steps you can follow: 1. Navigate to SuiteAnalytics Workbooks. 2. Create a new Workbook. 3. In the data selection step, choose the appropriate record type (e.g., Transaction, Account, etc.). 4. In the design step, add the necessary fields to your report. You might want to include fields like 'Amount (Foreign Currency)', 'Currency', 'Subsidiary', etc. 5. Apply any necessary filters, such as a Subsidiary filter if you want to run the report for a specific subsidiary. 6. Save and run your Workbook. This will give you a report with bank balances in their actual currency. The 'Amount (Foreign Currency)' field will show the balance in the foreign currency, and the 'Currency' field will show the currency symbol or name. Please note that this solution might not be perfect for all use cases. For example, fluctuations in currency exchange rates can have a significant impact when the transaction volume is in millions. Therefore, depending on your specific needs, you might also want to consider other features like currency revaluation. As for allowing drilldown into the register, this might not be directly possible from the Workbook. However, you can create a hyperlink in your Workbook that links to the register for each account. This would allow you to quickly navigate to the register from your report.