Can I Build It Report
This is a fantastic report that lists how many particular FG's you can produce based on the lower level of raw materials and or sub-assemblies. This report only goes 1 level deep, but for most companies, this is perfect as they make to stock at the sub-assembly level.
What makes this report really nice is it also displays any alternate items for the BOM components.
SELECT T0."Code" "Parent Item",
T2."ItemName" "Parent Desc",
T2."OnHand" "In Stock",
T2."IsCommited" "Allocated",
T2."OnOrder" "In Production",
T1."Code" "Component",
T3."ItemName" "Component Desc",
T1."Quantity" AS "Qty Req",
T3."OnHand" "Qty In Stock",
T3."IsCommited" "Allocated",
CASE
WHEN T3."OnHand" <= 0 THEN 0
ELSE
(T3."OnHand" / T1."Quantity")
END "Buildable",
T3."OnOrder" "In Purchasing",
T3."LeadTime" "Lead Time",
T4."AltItem" "Alternate Item",
T4."Remarks" "Alternate Notes",
T5."OnHand" FROM OITT T0 INNER JOIN ITT1 T1 ON T0."Code" = T1."Father"
INNER JOIN OITM T2 ON T0."Code" = T2."ItemCode"
INNER JOIN OITM T3 ON T1."Code" = T3."ItemCode" AND T3."InvntItem" = 'Y'
LEFT JOIN OALI T4 ON T3."ItemCode" = T4."OrigItem"
LEFT JOIN OITM T5 ON T4."AltItem" = T5."ItemCode" WHERE T0."Code" = [%0]
ORDER BY (T3."OnHand" / T1."Quantity")
