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 Answer(s)

Might want to try “date_closed” because from what’s documented on the Connect Browser /help/helpcenter/en_US/srbrowser/Browser2019_2/odbc/record/transaction_lines.html there’s no “isClosed” available.

Beginner Answered on September 13, 2019.
Add Comment
Advanced Answered on September 13, 2019.
Add Comment

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.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor