Skip to Content
0
Former Member
Jul 04, 2012 at 09:07 AM

FMS on quantity to exclude Sales BOM

13 Views

Experts,

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

where t1.DocNum=$[ORDR.DocNum]

Thanks,

Marli