I've come to believe that internally this is what netsuite does to get the inventory.

@Alan Fitch Hello Alan, have you made any more progress on this query? It seems to be slightly different than running an Inventory Balance search in my environment.

What threw me off was the item fulfillments for transfer orders. They had

tranctionline.isinventoryaffecting="F"

even though it should have been

"T"

. It's possible for your implementation you have other transactions like this. Run the query for an individual item, take off the

isinventoryaffecting

filter and look through the lines to see what the query might have missed.

Wow, I just figured out the same thing a few minutes before you responded. Yeah it looks like none of the Item Fulfillments are inventory affecting. I added (transactionline.isinventoryaffecting = 'T' or transaction.type = 'ItemShip') to the where clause and it's working great. Thanks!