Formula Numeric, Max = 0 to be added in summary criteria of the transaction search search
the formula is below
DECODE(MAX(CASE WHEN {shipcomplete}=’T’ then 1 else 0 end),1, DECODE( MAX(case when {item.type} NOT IN (‘Kit/Package’,’Inventory Item’,’Item Group’) AND {item.isfulfillable} =’T’ THEN 1 ELSE 0 END),0,MAX(case when ({item.type} IN (‘Kit/Package’,’Inventory Item’,’Item Group’) AND ({quantity} – nvl({quantityshiprecv}, 0) – nvl({quantitycommitted}, 0))>0 )then 1 else 0 end),1, DECODE(MAX(case when {item.type} IN (‘Kit/Package’,’Inventory Item’,’Item Group’) THEN 1 ELSE 0 END),0,MIN(case when {item.type} NOT IN (‘Kit/Package’,’Inventory Item’,’Item Group’) AND {item.isfulfillable} =’T’ AND ({quantity} – nvl({quantityshiprecv},0)) >0 then 0 else 1 end),1,Decode ( MAX(case when ({item.type} IN (‘Kit/Package’,’Inventory Item’,’Item Group’) AND ({quantity} – nvl({quantityshiprecv}, 0) – nvl({quantitycommitted}, 0))>0 )then 1 else 0 end), 0, DECODE(MAX(case when ({item.type} IN (‘Kit/Package’,’Inventory Item’,’Item Group’) AND ({quantity} != nvl({quantityshiprecv}, 0))) then 1 else 0 end),1,0,0,MIN(case when {item.type} NOT IN (‘Kit/Package’,’Inventory Item’,’Item Group’) AND {item.isfulfillable} =’T’ AND ({quantity} – nvl({quantityshiprecv},0)) >0 then 0 else 1 end)),1,1))),0, MIN(case when ({item.type} IN (‘Kit/Package’,’Inventory Item’,’Item Group’) AND (nvl({quantitycommitted},0)) >0 )then 0 else (case when {item.type} NOT IN (‘Kit/Package’,’Inventory Item’,’Item Group’) AND {item.isfulfillable} =’T’ AND ({quantity} – nvl({quantityshiprecv},0)) >0 then 0 else 1 end) end))