on 02-06-2018 8:20 AM
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
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.