Multi-level BOM Open Order Quantity BAQ Logic

[gpayne (Greg Payne)]

@MRomeo If there are jobs made that are using Part C the timephase should show when you go negative and should move to the 2.0s.

If there are jobs all of the data for all demands and supply are in PartDtl. This thread has a query using partition over that should also show you where the running sum goes negative.

Time Phase Inquiry BAQ

Hi Jay and Andrew, Here’s how I recreated a rudimentary timephase: [image] Add criteria to PartDtl Type <> Sub [image] Calculated Fields: OnHand= sum(PartBin.OnhandQty) Quantity = Case when PartDtl.RequirementFlag=0 then PartDtl.Quantity else (-1*PartDtl.Quantity) end RunningSum=Sum(Quantity) over (partition by PartDtl.PartNum order by PartDtl.DueDate)+isnull(OnHand,0) Result: [image]