This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Has anyone else had issues hooking up SuiteAnalytics via an ODBC connector and there is no amount or amount remaining fields in the transaction table? Am I just missing something

According to the Records Catalog, <https://acctid.app.netsuite.com/app/recordscatalog/rcbrowser.nl?whence=#/record_ss/transaction>, `foreigntotal` should give you the transaction's Total Amount (in the transaction currency)

There are also the fields `foreignamountpaid` and `foreignamountunpaid` the latter of which presumably can give you the amount remaining, though I have not verified this