on 06-16-2017 2:28 AM
Hi Guys,
How can I show all bin location per item in my pick list query. any idea with this bec. my client wants me to generate with its bin location so they can easily get the items they want to deliver.
This is my Query
SELECT SUM(T1.PickQtty) AS 'QTY.',T2.unitMsr as 'OuM',T2.Dscription As 'SKU' FROM OPKL T0 INNER JOIN PKL1 T1 ON T0.AbsEntry = T1.AbsEntry INNER JOIN RDR1 T2 on T2.PickIdNo = T0.AbsEntry and T1.OrderLine = T2.LineNum AND T1.OrderEntry = T2.DocEntry INNER JOIN ORDR T3 ON T2.DocEntry = T3.DocEntry and T3.ObjType = T1.BaseObject INNER JOIN OITM T4 ON T2.ItemCode = T4.ItemCode WHERE T0.AbsEntry = '[%0]' and T0.U_uPickListNo = '[%1]' and T0.U_uDriver = '[%2]' and T0.U_uLocation = '[%3]' and T0.U_uPlateNumber = '[%4]' GROUP BY T2.Dscription,T2.unitMsr ORDER BY T2.Dscription
Thanks in Advance Totally no idea at all.
🙂
Hi ,
Try this
SELECT SUM(T1.PickQtty) AS 'QTY.',T2.unitMsr as 'OuM',T2.Dscription As 'SKU', T6.[BinCode] FROM OPKL T0 INNER JOIN PKL1 T1 ON T0.AbsEntry = T1.AbsEntry INNER JOIN RDR1 T2 on T2.PickIdNo = T0.AbsEntry and T1.OrderLine = T2.LineNum AND T1.OrderEntry = T2.DocEntry INNER JOIN ORDR T3 ON T2.DocEntry = T3.DocEntry and T3.ObjType = T1.BaseObject INNER JOIN OITM T4 ON T2.ItemCode = T4.ItemCode INNER JOIN PKL2 T5 ON T0.[AbsEntry] = T5.[AbsEntry] and T1.[PickEntry] = T5.[PickEntry] INNER JOIN OBIN T6 ON T5.[BinAbs] = T6.[AbsEntry] WHERE T0.AbsEntry = '[%0]' and T0.U_uPickListNo = '[%1]' and T0.U_uDriver = '[%2]' and T0.U_uLocation = '[%3]' and T0.U_uPlateNumber = '[%4]' GROUP BY T2.Dscription,T2.unitMsr,T6.[BinCode] ORDER BY T2.Dscription
Regards:
Balaji.S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SELECT SUM(T1.PickQtty) AS 'QTY.',SUM(T5.PickQtty) AS 'Actual QTY.',T2.unitMsr as 'OuM',T2.Dscription As 'SKU', T6.[BinCode] FROM OPKL T0 INNER JOIN PKL1 T1 ON T0.AbsEntry = T1.AbsEntry INNER JOIN RDR1 T2 on T2.PickIdNo = T0.AbsEntry and T1.OrderLine = T2.LineNum AND T1.OrderEntry = T2.DocEntry INNER JOIN ORDR T3 ON T2.DocEntry = T3.DocEntry and T3.ObjType = T1.BaseObject INNER JOIN OITM T4 ON T2.ItemCode = T4.ItemCode INNER JOIN PKL2 T5 ON T0.[AbsEntry] = T5.[AbsEntry] and T1.[PickEntry] = T5.[PickEntry] INNER JOIN OBIN T6 ON T5.[BinAbs] = T6.[AbsEntry] WHERE T0.AbsEntry = '[%0]' and T0.U_uPickListNo = '[%1]' and T0.U_uDriver = '[%2]' and T0.U_uLocation = '[%3]' and T0.U_uPlateNumber = '[%4]' GROUP BY T2.Dscription,T2.unitMsr,T6.[BinCode] ORDER BY T2.Dscription
Hi,
Try this query,
SELECT SUM(T1.PickQtty) AS 'QTY.',T2.unitMsr as 'OuM',T2.Dscription As 'SKU', T5.[BinCode]
FROM OPKL T0 INNER JOIN PKL1 T1 ON T0.AbsEntry = T1.AbsEntry INNER JOIN RDR1 T2 on T2.PickIdNo = T0.AbsEntry and T1.OrderLine = T2.LineNum AND T1.OrderEntry = T2.DocEntry INNER JOIN ORDR T3 ON T2.DocEntry = T3.DocEntry and T3.ObjType = T1.BaseObject INNER JOIN OITM T4 ON T2.ItemCode = T4.ItemCode INNER JOIN PKL2 T4 ON T0.[AbsEntry] = T4.[AbsEntry] INNER JOIN OBIN T5 ON T4.[BinAbs] = T5.[AbsEntry]
WHERE T0.AbsEntry = '[%0]' and T0.U_uPickListNo = '[%1]' and T0.U_uDriver = '[%2]' and T0.U_uLocation = '[%3]' and T0.U_uPlateNumber = '[%4]'
GROUP BY T2.Dscription,T2.unitMsr ORDER BY T2.Dscription,T5.[BinCode]
Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try this,
SELECT SUM(T1.PickQtty) AS 'QTY.',T2.unitMsr as 'OuM',T2.Dscription As 'SKU', T6.[BinCode]
FROM OPKL T0 INNER JOIN PKL1 T1 ON T0.AbsEntry = T1.AbsEntry INNER JOIN RDR1 T2 on T2.PickIdNo = T0.AbsEntry and T1.OrderLine = T2.LineNum AND T1.OrderEntry = T2.DocEntry INNER JOIN ORDR T3 ON T2.DocEntry = T3.DocEntry and T3.ObjType = T1.BaseObject INNER JOIN OITM T4 ON T2.ItemCode = T4.ItemCode INNER JOIN PKL2 T5 ON T0.[AbsEntry] = T5.[AbsEntry] INNER JOIN OBIN T6 ON T5.[BinAbs] = T6.[AbsEntry]
WHERE T0.AbsEntry = '[%0]' and T0.U_uPickListNo = '[%1]' and T0.U_uDriver = '[%2]' and T0.U_uLocation = '[%3]' and T0.U_uPlateNumber = '[%4]'
GROUP BY T2.Dscription,T2.unitMsr,T6.[BinCode] ORDER BY T2.Dscription
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.