Palettelabel
Report PalletteLabel
- Filename: PalletteLabel
- Title: Pallet label
- Sample: Unit133
Synopsis
Label to print on a palette.
SQL
SELECT DISTINCT
A.ARTCODE, '*'+A.ARTCODE+'*' AS ArtBareCore, B.NAME2,
'*'+A.INVOICE+'*' AS INVCODE, A.FILLDATE AS DATA, A.INVOICE,
(CASE WHEN ISNULL(LOTNO, '')<>'' THEN 'LOTNO: '+LOTNO ELSE '' END) as lotno1,
(CASE WHEN ISNULL(LOTNO, '')<>'' THEN '*'+LOTNO+'*' ELSE '' END) as lotno2,
(CASE WHEN ISNULL(LOTNO, '')<>'' THEN '*'+A.ARTCODE+'-'+LOTNO+'*' ELSE '*'+A.ARTCODE+'*' END) as ProductLot,
(CASE WHEN ISNULL(LOTNO, '')<>'' THEN '*'+B.EANCODE3+'-'+LOTNO+'*' ELSE '*'+B.EANCODE3+'*' END) as ProductLot1
FROM
INVDETAILS A , 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.