on 07-23-2015 9:07 AM
Hi,
I am using SAP B1 9.00 PL 08.
Can any one provide the query raw material consumption for particular finish goods during the month.
We are using single level Bill of Material.
Regards,
Arpit
Hi Arpit,
Try below Query.
Select T0.ItemCode as Finished_Gooods_ItemCode, T2.ItemName as Finished_Gooods_ItemName,
SUM(T1.IssuedQty) as Total_Raw_Material_Issued_Quantity from OWOR T0
INNER JOIN WOR1 T1 ON T1.DocEntry = T0.DocEntry
INNER JOIN OITM T2 ON T2.ItemCode = T0.ItemCode
INNER JOIN OITM T3 ON T3.ItemCode = T1.ItemCode
Where
T0.PostDate >=[%3] AND T0.PostDate <= [%4]
AND T0.ItemCode = [%0]
GROUP BY T0.ItemCode , T2.ItemName
ORDER BY T0.ItemCode
Hope this helps
Thanks'
--
--
Regards::::
Atul Chakraborty
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arpit,
My Mistake.. Check again
Select T0.ItemCode as Finished_Gooods_ItemCode, T2.ItemName as Finished_Gooods_ItemName,
SUM(T1.IssuedQty) as Total_Raw_Material_Issued_Quantity from OWOR T0
INNER JOIN WOR1 T1 ON T1.DocEntry = T0.DocEntry
INNER JOIN OITM T2 ON T2.ItemCode = T0.ItemCode
INNER JOIN OITM T3 ON T3.ItemCode = T1.ItemCode
Where T0.ItemCode = [%0] AND
T0.PostDate >=[%3] AND T0.PostDate <= [%4]
GROUP BY T0.ItemCode , T2.ItemName
ORDER BY T0.ItemCode
Please also check Query is Returning Result.
Hope this helps
Thanks'
--
--
Regards::::
Atul Chakraborty
User | Count |
---|---|
94 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.