cancel
Showing results for 
Search instead for 
Did you mean: 

I Need to create FMS to get item cost for BOM

0 Kudos

Dear SAP B1 Expert,

I created query to get item cost of BOM as below but not working please advice

select Sum(Z.Value) / Sum(Z.Quantity) As TotalCost from

( Select Sum(T1.Quantity* T2.AvgPrice) Value , 0 As Quantity , T0.Code from OITT T0 INNER JOIN ITT1 T1 ON T0.[Code] = T1.[Father]

INNER JOIN OITM T2 ON T1.[Code] = T2.[ItemCode]

Group by T0.Code

Union all

Select 0,Sum(T0.Qauntity )as Quantity ,T0.Code from OITT T0

Group by T0.Code ) Z

group by Z.Code

Accepted Solutions (0)

Answers (0)