Skip to Content
avatar image
Former Member

I Need to create FMS to get item cost for BOM

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers