I have a FMS that populates the total quantity on a Sales Order. This works fine, except that it also add the quantity of the Parent in a Sales BOM.
How can I exclude the Parent Sales BOM quantity on a Sales Order?
Here is what I have:
Select SUM(t0.Quantity) from RDR1 t0 inner Join ORDR t1 on t0.DocEntry=t1.DocEntry