how can i determine the date an invoice was paid via suiteql

AI generated answer (using internal Slack threads):

To determine the date an invoice was paid in full via SuiteQL, you can use the "Date Closed" field of the invoice record. This field represents the date when the invoice status was changed to "Paid in Full". Here is a sample SuiteQL query that you can use to retrieve the date an invoice was paid:

sql
SELECT T.id, T.tranId, T.dateClosed
FROM Transaction T
WHERE T.type = 'Invoice' AND T.status = 'Paid In Full'

In this query,

T.id

is the internal ID of the invoice,

T.tranId

is the transaction ID of the invoice, and

T.dateClosed

is the date the invoice was paid in full. Please note that the "Date Closed" field is available in the invoice record and can be used in saved searches, Suitelets, and SuiteQL queries. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******