Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
How to select account from TransactionLine
Hello NetSuite Gurus,
I'm trying to get the account of the TransactionLine using SuiteQL, but I got "Search error occurred: Field 'Account' for record 'transactionLine' was not found. Reason: NOT_EXPOSED - Field is marked as internal for channel SEARCH" using this SuiteQL query:
SELECT
TransactionLine.Transaction AS TransactionID,
Transaction.TranDate,
Transaction.Type,
Transaction.TranID,
TransactionLine.Rate,
TransactionLine.NetAmount,
TransactionLine.Quantity,
TransactionLine.Account
FROM
TransactionLine
INNER JOIN Transaction ON
( Transaction.ID = TransactionLine.Transaction )
WHERE
( Transaction.Id = 41892 )
ORDER BY
Transaction.TranDate,
Transaction.TranID
What is the way to get the account of TransactionLine?
Thanks!