Orderpickinglist

Report OrderPickingList

Filename: OrderPickingList
Title: Order :OrderNo Picking list
Sample: Unit207 (Form207)

Synopsis

Picking list for a single order.

SQL

SELECT
  C.LOCATION,
  B.ARTCODE,
  D.NAME2,
  E.SQWPK,
  sum(B.QTY) AS QTY,
  count(distinct B.ARTCODE) as Articles,
  sum(isnull(D.Weight, 0) * B.QTY) AS Weight,
  '*'  + A.AVIZ + '*' AS OrderNo,
  C.ExpiryDate,
  C.LotNo,
  B.SugestedLocation
FROM
  OUT A
  left outer join XML_OUT G on (A.AVIZ = G.OrderNo)
  INNER JOIN OUTDETAILS B ON (A.AVIZ = B.AVIZNO)
  INNER JOIN INVDETAILS C ON (B.INVOICENO = C.ID)
  INNER JOIN ARTICLE D ON (B.ARTCODE = D.NAME)
  INNER JOIN LOCATION E ON (C.LOCATION = E.LOCATION)

WHERE
  (A.AVIZ = :OrderNo)
GROUP BY
  C.LOCATION,
  B.ARTCODE,
  D.NAME2,
  E.SQWPK,
  A.AVIZ,
  C.ExpiryDate,
  C.LotNo,
  B.SugestedLocation
ORDER BY
  E.SQWPK,
  B.ARTCODE

Parameters

OrderNo The order to be picked.

Accessible in forms

PickAndPack