case when formula to show the item fulfillment quantity in item fulfillment search

AI generated answer (using internal Slack threads):

To show the item fulfillment quantity in an item fulfillment search using a case when formula, you can use a formula similar to the following:

sql
CASE WHEN {location} = {item.inventorylocation} THEN {item.locationquantityonhand} else 0 END

This formula checks if the location of the item matches the inventory location. If it does, it returns the quantity on hand at that location. If it doesn't, it returns 0. In the criteria of the search, you can set: - Item: Type = Is Any Of - Inventory Item, Assembly/Bill of Materials, Kit/Package - Location = Is Not - unassigned - - Item: Inactive = Is False You can use 'Item Fields' as the Filter for Item. Please note that the field names and formula syntax may vary depending on your specific NetSuite setup and field naming conventions. Adjust the formula accordingly based on the actual field names in your saved search. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******