RE: Transaction {isclosed} field name in the Connect Browser
Does anybody know what the closed line field is called in SuiteAnalytics Connect? I can’t seem to find it anywhere on the transaction lines table.
Hello bstevens1214,
If you look at the Connect Browser you will notice that there’s no “isclosed” column exposed like in SuiteScripts.
Connect Browser: https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2019_2/odbc/record/transaction_lines.html
You should use the column “date_closed” instead.
Example:
SELECT TRANSACTION_ID FROM TRANSACTION_LINES WHERE TRANSACTION_LINES.DATE_CLOSED IS NULL;