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!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
Account Currency - ODBC
**I've edited the question***
If an account has a certain currency (for example, a bank account) - is it possible that there is a transaction with a different currency?
If so - how to calculate the balance of an account in the ACCOUNT's currency (not transaction currency, not base currency, not accounting book currency, but the currency which is defined for that account)
A little context: I am trying to calculate the balance in the bank accounts' currency via ODBC queries.
So I wonder if I sum the foreignamount field - will it return the value I need.
As I understand, the foreignamount is in the TRANSACTION CURRENCY, not in ACCOUNT CURRENCY so if there are any transactions in a currency which is different from the bank account's currency, the result will be wrong.