Skip to Content
0

Query for seeing orders that are in release state in pick & pack manager

Oct 26, 2016 at 07:22 PM

47

avatar image

Hi guys - I have been trying, with no luck whatsoever, to write a query in order for our sales team to see orders that are in the RELEASE state of the pick & pack manager.

Is such a thing possible?

Any help anyone can provide will be greatfull received.

Regards

Roy

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

2 Answers

Johan Hakkesteegt Oct 27, 2016 at 12:42 PM
0

Hi Roy,

I don't use this functionality myself, so I can't really test anything, but as far as I can tell, this should be a good base for you to develop:

SELECT *
FROM OPKL h
     INNER JOIN PKL1 r ON h.AbsEntry = r.AbsEntry
     INNER JOIN ORDR o ON r.OrderEntry = o.DocEntry
WHERE h.Status = 'R'

Regards,

Johan

Share
10 |10000 characters needed characters left characters exceeded
Roy Bright Nov 01, 2016 at 02:58 PM
0

Hi Johan - thanks for the reply, but I managed to sort this out for what I needed with the below query. Works great for us:

SELECT T0.PickStatus, T2.CardCode, T2.CardName, T1.ItemCode, T1.Dscription

FROM PKL1 T0 INNER JOIN RDR1 T1 ON T0.OrderEntry=T1.DocEntry AND T0.OrderLine=T1.LineNum INNER JOIN ORDR T2 ON T1.DocEntry = T2.DocEntry

WHERE T0.[PickStatus] = 'R'

Share
10 |10000 characters needed characters left characters exceeded