Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 27, 2016 at 12:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 01, 2016 at 02:58 PM

    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'

    Add comment
    10|10000 characters needed characters exceeded