Q: Is there a way to get to the

foreignaccts

machine list in the Currency Revaluation (Unrealized Gain/Loss) via query? It’s not the

TransactionLine

join.

Unfortunately, there are many tables and fields that are in inaccessible via SuiteQL.

fxreval

is one of them. You can see the list here a list of all the records/fields in NetSuite in Excel format, and whether they are available in SuiteQL: https://nlcorp.app.netsuite.com/core/media/media.nl?id=127972055&c=NLCORP&h=34f6d25f34ab89fef9af&_xt=.xls

Thanks! Not sure about that listing, though. I’m able to query the basic data, and can even access these lines via

Transaction

,

TransactionLine

and

TransactionAccountingLine

joins. However, I cannot get the

currency

on the line through any which way. Thoughts?