SuiteQL query to show invoice with summary lines

AI generated answer (using internal Slack threads):

To show invoices with summary lines using SuiteQL, you can use a query similar to the one below:

sql
SELECT T.id, T.tranId, T.type, T.date, T.memo, T.total, T.status, T.entity, T.currency, T.exchangeRate, T.subsidiary
FROM Transaction T
WHERE T.type = 'CustInvc'

This query will return the ID, transaction ID, type, date, memo, total, status, entity, currency, exchange rate, and subsidiary for each customer invoice in the system. To get the summary lines, you would need to join the

Transaction

table with the

TransactionLine

table. However, please note that the

TransactionLine

table might not be directly accessible via SuiteQL. You might need to create a saved search to get the line details and then use SuiteQL to query the saved search. Please note that the actual table and field names might vary based on your NetSuite setup. Always refer to the NetSuite Records Browser for the most accurate and up-to-date information. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******