Hello NetSuite Guru,
I created a saved search to get the items which are Kit/Package or Inventory Item or Assembly/Bill of Materials. In the result, I want to display the status (in stock or out of stock) of each item.
For Kit/Package item, I need to check the inventory of each member to pull out the location on hand of each item, if any member is less than 1, that mean the whole kit is out of stock.
For other item type, I only need to check the location on hand of the item and show the status.
I want to show the the status for all items in the same column so I created the formula as below:
CASE WHEN {type} = 'Kit/Package' THEN
CASE WHEN {memberitem.locationquantityonhand} >0 THEN 'in stock' ELSE 'out of stock' END
ELSE
CASE WHEN {locationquantityonhand} > 0 THEN 'in stock' ELSE 'out of stock' END
END
This formula shows correct status for Kit/Package item but not correct for other item types.
Please see the screenshots below for my saved search and help me review the formula to make is show the correct inventory status for other types as well:
Thank you very much.