Skip to Content

I Need to create FMS to get item cost for BOM

Feb 06 at 08:20 AM


avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers