Following the move to netsuite2.com we are struggling to get the right amount in some of our ODBC queries. We need to bull all transactions for a balance sheet account in base currency and support have told us the only way to do that is to use the following. SELECT command: ROUND(SUM(TRAN_LN.netamount * TRAN.EXCHANGERATE), 2) Amount_Raw This doesn't return the right amount on transactions like intercompany journals. It seems crazy to me that its not possible to pull out the base currency of a transaction. Does anyone have a better solution?

You should be able to get amount in base currency from TransactionAccountingLine table