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

0
votes

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

1
netsuitesaved-searches

1 Answers

1
votes

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 tab selections

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

Criteria tab (summary selections)

  • 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)

Results tab selections

Example of results: 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.