Does anyone have any guidance on how to get a page or search with visibility on an assembly item. I am wanting to see (after entering assembly name, location selected) buildable qty, qty on hand, qty available (that considers open transactions) qty on order, qty backordered. Between saving a work order, using assembly build and bill of materials inquiry you can kind of get all of these but they're inconsistent and are pros/cons to each one.

Most of those fields are easy to get in a each. The hard one is "Buildable" For me personally, What I do Is if the item is below is safety stock or forecast needs it, Then Make a work order.. Then at the work order level. I use Supply Allocation. so if something is out of stock, it shows me the expected date. then adjust the WO date to be built after the Supply.

Are you using Advanced BOM or Member Assembly items? An Item Saved Search is going to give you every field you have listed I have a SQL formula that can get the 'Buildable' qty for Assembly items. The catch is it will only work for Assembly Member Item BOM setup though.

@Andrew Altringer Yeah, we're using advanced BOM. Would you mind sharing that formula anyways? Just curious. Thanks!

@Jeremy Dean Item Saved Search Formula (Numeric) | Minimum | GREATEST(FLOOR(NVL({memberitem.locationquantityonhand},0)/{memberquantity}),0)

@Andrew Altringer I really appreciate it, will give this a try!

@Jeremy Dean - Did this work for you?

hi! is there any way you can join to the bom revision in the item search? i'm only seeing the bom, not the revision

@Neeranie Ramdas - Unfortunately no. There is not a way to join the Assembly item to the BOM Revision natively.

thanks so much for confirming