I am trying to create a saved search that shows the which assemblies are below the Build Point or Preferred Stock Level taking into account whatever is on a Work Order.

I have a saved search for Items that show items that have reached a reorder point so we know to create a PO. The formula I use takes items on a PO into account so they will not show on that report. I need something similar for Assemblies and Work Orders.

Thank you