Why does the balancesearch field in the Customer table not match the UI?

AI generated answer (using internal Slack threads):

The discrepancy between the balancesearch field in the Customer table and the UI could be due to the currency settings. In NetSuite, the balancesearch field typically returns the balance in the base currency of the account, which is USD by default. If a customer's primary currency is set to a different currency (like GBP in the example), the balance returned by the balancesearch field will still be in USD. This is because the balancesearch field does not take into account the currency exchange rate. It simply returns the balance as stored in the database, which is in the base currency of the account. The UI, on the other hand, displays the balance in the customer's primary currency, taking into account the current exchange rate. To get the balance in the customer's primary currency, you might need to use a different field or method. For example, you could try using the fxbalance field, which should return the balance in the customer's primary currency. However, as mentioned in the thread, this might not work in all environments. Please note that this is a common issue in multi-currency environments and it's important to always consider the currency settings when working with financial data in NetSuite. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******