We do nothing but USD transactions so currency conversion is not an issue. Why would the balancesearch field in the Customer table in ODBC not match the UI?

AI generated answer (using internal Slack threads):

The discrepancy between the balancesearch field in the Customer table in ODBC and the UI could be due to several reasons: 1. Data Synchronization: The data in the ODBC might not be up-to-date with the UI. NetSuite's ODBC is a read-only tool that pulls data from NetSuite into a SQL database. If there's a delay or issue with the data synchronization, the balances might not match. 2. Data Representation: The way data is represented in the ODBC might be different from the UI. For example, the UI might be showing the balance in the primary currency of the customer, while the ODBC might be showing it in the base currency of the company. 3. Data Access: Not all data available from one source is available in another. Some fields might not be accessible or visible in the ODBC but are in the UI. 4. Currency Conversion: Even though you mentioned that you only deal with USD transactions, it's worth noting that NetSuite handles foreign currency transactions by converting them to the base currency of the company for reporting purposes. This could potentially cause discrepancies if there are any foreign currency transactions. To resolve this issue, you might need to check the data synchronization process, the data representation in the ODBC, and the accessibility of the fields in the ODBC. You might also need to use SuiteScript or SuiteQL to fetch the balance in the primary currency of the customer. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******