Has anyone written a search for finding "Buildable" Work Orders? The statusRef field on Work Orders isn't exposed and it doesn't appear you can expose it. The one suiteanswers article reference I could find no longer exists (it claimed to expose the buildable field).

Not sure if this is helpful, but... In SuiteQL, on the Transaction table, there's a "committed" column that maps to the "Buildable" field label in the UI. It might be worth looking at.

I'll check to see if there's any correlation then thanks

np Good luck!

I know when I looked at something similar I used the orderstatus field and mapped out the values. I think released and in process would be classified as buildable. Planned : "A" Released : "B" In Process : "D" Closed : "H" Built : "G"

I thought so as well, but the list of buildable work orders on the "build work orders" native netsuite page are not the same results as work orders w/ those 2 statuses.

you're not making me excited about a workorder related project I'm about to embark on 🙂

The work order itself is easy. This is just a client request im trying to work with and it just may not be possible as written.

It's odd that it isn't exposed, and getting to it via SuiteQL is tricky, too. Here's a query that will return all work orders that are "Pending Build."

SELECT
	ID,
	TranID,
	Status,
	BUILTIN.DF( Status ) AS StatusName,
	Entity,
	BUILTIN.DF( Entity ) AS EntityName
FROM
	Transaction
WHERE
	Type = 'WorkOrd'
	AND ( BUILTIN.DF( Status ) = 'Work Order : Pending Build' )

I believe there's another way to get it. The WIP box on Work Orders drives the rest of it so if that box is NOT checked, it will show up in the Build Work Orders table

I think you're right. The interesting thing about it is that the underlying status value seems to "B" (or specifically "WorkOrd:B") regardless of whether the work order is released or pending build. If you use that BUILTIN.DF function, it seems to take something else into account (maybe "WIP" - the column name for which is "IsWip") to return a sub-status of either "Work Order : Released" or "Work Order : Pending Build."

I'm gonna roll w/ In Process/Planned/Released and no WIP

We rely heavily on the WO process and build thousands at a time in waves using a map/reduce script. I use status = Work Order: Released and formula(numeric) "CASE WHEN {buildable} = {quantity} THEN 1 ELSE 0 END" is not 0.