Howdy ya'll - does the Transaction_Lines table really not have any column that indicates close status at the line-level??

Depends on what you mean by closed. Closing a line is a very specific term in NS. If you no longer can fulfill a line, there is a checkbox on the line called close. If you mean close as in the line has been billed, you can use a simple formula to calculated quantity billed - quantity fulfilled.

Yeah, you're right. There is a checkbox in the UI that is Closed and that's exactly what I am trying to pull into this ODBC report. This Closed checkbox does not look like it exists in the Transaction_lines table...

I pulled it into a saved search. It was called Closed.

Haha yeah, ODBC doesn't use the Saved Search interface at all and the names are all wonky/different from the UI... It's super easy to pull it in the Search, it's just the ODBC report that I'm trying to get to

I'm going through the same process with ODBC, rebuilding some legacy reports from an ERP a customer was using before using the NetSuite database instead. Not everything is as clear as it could be. Check out OA_TABLES or OA_COLUMNS ... might be a good start to find fields. Sometimes what i've done is to select * from transaction_lines, for a given transaction and searched for the value that was on screen to find the relevant field. Sometimes it works, sometimes it doesnt.

Yep, the OA_TABLES was def super helpful - but in this case, it seems like it doesn't work with what we want.. Appreciate the response though!

No problem, might help someone else!