NetSuite saved search formula to determine if all the components are in stock

Question

Sorry a novice at Stack Overflow, so hope I'm doing this correctly.

I'm trying to make a saved search to find out which assemblies can be built by determining if all the components are in stock. I found a similar question by Garrett Penfield at NetSuite saved search formula to find the difference of two custom columns and was hoping that Garrett or others may be able to assist.

Thanks

Stephen

Answer 1

To show the Buildable Quantity of all Assembly/Bill Of Materials items:

Create a Item Saved Search as follows:

• Criteria (Standard) Tab
  • Type ANY OF Assembly/Bill Of Materials
  • Inventory Location ANY OF - None - and <Your Location>
  • Member Item Fields > Inventory Location ANY OF - None - and <Your Location>
  • Member Item Fields > Type ANY OF Assembly/Bill Of Materials and Inventory Item

• Criteria (Summary) Tab
  • Type: Minimum
  • Field: Formula (Numeric)
  • Formula: GREATEST(FLOOR(NVL({memberitem.locationquantityonhand},0)/{memberquantity}),0)
  • Greater than 0

• Results Tab
  • Internal ID (Summary type Group)
  • Name (Summary type Group)
  • Description (Summary type Group)
  • Formula (Numeric) (Summary type Minimum): GREATEST(FLOOR(NVL({memberitem.locationquantityonhand},0)/{memberquantity}),0)

Example of results:

Notes

• You may want to change locationquantityonhand to locationquantityavailable in the formulas used in both the Criteria (Summary) and Results tabs.
  • Doing so will change the result to only show how many assemblies can be built without using items that are already committed to other customer orders.