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.

Add Comment
3 Answers

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;

Beginner Answered on September 14, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.