suiteql to return invoice ids and get amount remaining in one query

AI generated answer (using internal Slack threads):

To return invoice IDs and get the amount remaining in one SuiteQL query, you can use the

TRANSACTION

table in NetSuite. The

TRANSACTION

table contains all the transactions in NetSuite including invoices. The

INTERNALID

field will give you the invoice ID and the

AMOUNTREMAINING

field will give you the amount remaining on the invoice. Here is a sample SuiteQL query:

sql
SELECT T.INTERNALID, T.AMOUNTREMAINING
FROM TRANSACTION T
WHERE T.TYPE = 'Invoice'

This query will return the internal ID (which is the invoice ID) and the amount remaining for all invoices in your NetSuite account. Please note that you may need to adjust the query based on your specific requirements and the actual structure of your NetSuite account. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******