Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Base and transaction amounts from ODBC connection
I'm trying to get the base and transaction amounts from the Netsuite ODBC connection. I followed the suggestion from SuiteAnswers(https://netsuite.custhelp.com/app/answers/detail/a_id/44169/kw/currency%20odbc) to use 'amount' and 'amount_foreign' from the Transactions table but both amounts return USD regardless of currency. Ultimately, I'd like to find the equivalent of the 'Account Balance' object from Reports in ODBC b/c the 'Amount' field will return the transaction amount in the correct currency.