Unloadinglist

Report UnloadingList

• Filename: UnloadingList
• Title: Unloading list
• Sample: Unit16

Synopsis

List of items to unpack, location where to store.

SQL

Main dataset:

SELECT
  A.INVOICE, A.FILLDATE, A.ARTCODE, A.STOCKCODE, A.QTYIN, A.QTY, A.LOCATION,
  A.LOTNO, A.EXPIRYDATE, B.NAME2, '*'+A.INVOICE+'*' AS INVCODE
 FROM
   INVDETAILS A inner join ARTICLE B on (A.ARTCODE=B.NAME)
 WHERE
   (A.SUPPLIER = :Supplier) AND (A.INVOICE = :Invoice)
 ORDER BY A.ARTCODE ASC

Alternative: filter on invoice ID.

Parameters

• Supplier Supplier name.
• Invoice Invoice code.
• ID Invoice ID.

Accessible in forms

• ReceptionForm