SAP Business One Pick And Pack Query

[Former Member]

Hi all,

Does any one know how to query pick and pack manager and to combine with sales order table.

i want to create a schedule delivery using pick list.

Thanks a lot,

[kothandaraman_nagarajan]

Hi,

Please try this query,

SELECT T0.[AbsEntry], T0.[Name], T0.[PickDate], T3.[DocNum], T3.[DocDate], T2.[ItemCode], T2.[Dscription], T2.[Quantity], T1.[PickQtty], T1.[PickStatus] FROM OPKL T0  INNER JOIN PKL1 T1 ON T0.[AbsEntry] = T1.[AbsEntry] inner join  RDR1 T2  on T2.[PickIdNo]  =  T1.[AbsEntry] INNER JOIN ORDR T3 ON T2.[DocEntry] = T3.[DocEntry] and   T1.[OrderEntry]  =  T3.[DocNum] WHERE T1.[OrderLine]  =  T2.[LineNum]

Thanks