FMS on quantity to exclude Sales BOM

[Former Member]

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

[KennedyT21 · Accepted solution]

Hi Marli,

Try this.

Select sum(t0.Quantity)  from RDR1 t0

inner Join ORDR t1 on t0.DocEntry=t1.DocEntry

where t1.DocNum=$[ORDR.DocNum] and t0.ItemCode not in (

select Code  from OITT where TreeType='S' )

Regards

Kennedy