I have a strange case here. I have a transaction saved search with the following criteria: Type is Sales Orders Item Type is any of Inventory Item or Kit/Package Status is not Closed I have a partially fulfilled SO. The saved search does not show the unfulfilled item (only the fulfilled items) whenever I add Applying Transaction under the Results (not Criteria) subtab. The unfulfilled item is Inventory and is not Closed. If I remove the Applying Transaction, it shows the missing item. Why is that so? Other totally unfulfilled SOs are showing.

I think I've run into that before and for whatever reason, it seems that lines WITHOUT applied transactions get filtered out when you add Applying Transaction as a result field. You may need to revamp your search. What is the end goal of your search? To show Order lines that haven't been shipped?

I usually use the SO's "Quantity Fulfilled/Received" to show the number already fulfilled. The I add a Formula (Numeric) field of

{quantity} - NVL({quantityshiprecv},0)

to give me a Backorder figure. If that's what you are seeking.

Unfortunately, that's not what we're seeking. Anw, we've figured it out already. Thanks!

can you share what you figured out?

Per NetSuite support, it is the standard behavior when using the Applying Transaction joins. If some of the lines have applying transactions while other lines do not have, the latter will not be shown. Example: Type is SO. Lines 1 to 4 are invoiced. Lines 1 to 3 are fulfilled but not line 4. Line 4 will be shown only once - for applying transaction invoice. Others will be shown twice - one for applying transaction invoice and another for IF.

like an inner join