Packinglistgeneralpurpose

Report PackingListGeneralPurpose

• Filename: PackingListGeneralPurpose
• Title: Packing List General Purpose
• Sample: Unit192 (form192)

Synopsis

Display the details of an order (general purpose)

SQL

With OrderDetail as (
 SELECT
   A.*,
   DClientFirstName + ' ' + DClientLastName AS DNAME,
   IClientFirstName + ' ' + IClientLastName AS INAME,
   IClientFirstName + ' ' + IClientLastName + ',' AS INAME1
 FROM
   SPIR_ORDER A
 WHERE
   OrderNo = :OrderNo
 ),
expDate as (
 Select
   max(ExpiryDate) as ExpiryDate,
   max(LotNo) as LotNo,
   X.ARTCODE
 from
   Invdetails X,
   OUTDETAILS Y
 where
   X.ID = Y.INVOICENO AND
   X.ARTCODE = Y.ARTCODE AND
   Y.AVIZNO = :OrderNo
 Group BY
   X.ARTCODE)
Select
  *
from
  OrderDetail D
  left join ExpDate E on E.ARTCODE = D.ARTCODE
ORDER BY
  ID ASC

Remark

Display must be adapted for 'Iron Gym Maco inventory' customer: * Ship method is DHL * Customer is 'IRON GYM'

Parameters

• OrderNo the order number

Accessible in forms

1. Pick and Pack