Orderdetaillist

Report OrderDetailList

Filename: OrderDetailList
Title: Order :OrderNo Detail List
Sample: Unit122

Synopsis

Details from an order (higher level)

SQL

Select
  A.AVIZ,
  A.COUNTRY,
  B.ARTCODE,
  B.QTY,
  C.LOCATION,
  D.QTYIN - ISNULL(D.QTYOUT, 0) + B.QTY AS SQTY
FROM
  OUT A
  INNER JOIN OUTDETAILS B ON (A.AVIZ = B.AVIZNO)
  INNER JOIN INVDETAILS C ON (B.INVOICENO = C.ID)
  INNER JOIN STOCTOTAL D ON ((C.ARTCODE = D.ARTCODE) AND (C.ID = D.ID))
  INNER JOIN LOCATION E ON  (C.LOCATION = E.LOCATION)
WHERE
  -- {CustomFilter}
  AND (RIGHT (C.LOCATION, 1) <> 'A')
ORDER BY
  E.SQ,
  E.LOCATION

Parameters

CustomFilter The order(s) to be printed. This is one of

(A.AVIZ = :OrderNo)

Or

(A.Data = :OrderDate) AND (B.TRANSACTIONTYPE = 'ORD')

Accessible in forms

PickAndPack