Hello! I am trying to create a GI that shows Non-Stock Kit Availability based on the availability of the component items.
Where if at least on component item is not available, then when you filter by the kit item, either nothing shows up in the GI or there is a field that display a zero availability of the kit item.
This is the formula I am working with: = IIF (Floor((IsNull( [INSiteStatus.QtyAvail], 0 ) / IIF ([INKitSpecStkDet.DfltCompQty] > 0,[INKitSpecStkDet.DfltCompQty] ,1 ))) < 0 , 0, (Floor((IsNull( [INSiteStatus1.QtyAvail], 0 ) / IIF ([INKitSpecStkDet.DfltCompQty] > 0,[INKitSpecStkDet.DfltCompQty] ,1 )))))
Picture below, because the component items shows zero in the available column, nothing should show up for this kit inventory item.
Does anyone know if this is possible? My formula currently returns zero for all items, any idea on what it should look like? Any suggestions are appreciated!
Thank you!
