Hello Everyone, I have created a saved search for item fulfillment transactions. I want to include both item fulfillment transactions with bins and those without bins in the results. The goal is to see items that were used from particular bins. However, I don't want the extra two GL lines in the result. How can I achieve this? Any help will be appreciated.

Looking at your grab, the last one. The search results are showing three lines, there are a number of differences that you could potentially exclude in the criteria. Qty and Account are obvious choices. Also the first line appears to be Mainline - but I'm 99% certain that adding mainline = T (or F) on a fulfilment search does some really odd things. From memory the first LINE of the Fulfilment is considered the mainline, and subsequent lines are not main line. Try the "Account" = null to start with.

Yes, you're correct. However, the issue arises when we have multiple items in the item fulfillment, as setting the main line to true or false doesn't address my specific need. What I'm trying to achieve is to retrieve the first item line (line sequence number 0) and also the second item line (line sequence number 3), as indicated in the image below. I attempted to use the formula (Text) CASE WHEN {account} IS NULL THEN 1 ELSE 0 END in the criteria, but I encountered difficulties in setting it up, and I'm unsure why.

try adding the account = null in the criteria?

Thank you, @Anthony Emberson. The approach of setting account = null works, but NetSuite doesn't permit direct setting. So, I created a formula to implement this logic, and it worked. Now, I'm encountering a new challenge. I've included a column for inventory details: bin quantity. It correctly displays quantities for items with bins, but shows null for items without bins, which is expected. However, if I also want to display the quantity for items without bins, I'll need to add another column. How can I accommodate both scenarios in a single column?

Mmmm, You want the Bin Number and Qty in the same column?

The current scenario is that we have " Inventory Details: Bin Quantity " column that includes quantities for items stored in bins, and a "Quantity" column that includes overall quantities appearing in item fulfillment transactions, regardless of whether the item is stored in a bin or not. So, my question is, whenever there is a null value in the " Inventory Details: Bin Quantity" column, can we simply use the value from the "Quantity" column instead? For example, in the picture above, see IF0019.

NVL({invdet:binqty}, [quantityonhand}) Sorry, I don't have the field IDs to hand. But the NVL function effectively says... Give be bin qty, unless NULL, in which case give me quantity. But be careful with "quantity on hand" vs "location quantity on hand", they are different.