Collipacklist

Report ColliPackList

Filename: ColliPackList
Title: Colli pack list
Sample: Unit185

Synopsis

Packing list for a single colli in an order that contains multiple collis.

SQL

SELECT
  A.AVIZNO, '' AS PK,
  ARTCODE,
  count(distinct A.ID) as QTY_01,
  count(distinct A.ID) AS QTY,
  C.NAME2
  B.IDDClient, B.DClient, B.DClientTown, B.DClientTownCode, B.DClientAddress,   B.DClientCountry,
  B.IDIClient, B.IClient, B.IClientTown, B.IClientTownCode, B.IClientAddress,   B.IClientCountry, B.CLIENTREFERENCE, b.filldate,
  A.UnitPrice, A.UnitListPrice, A.ContactPerson,
  A.PHONE, A.FAX, A.LANGUAGE, A.CURRENCY,
  C.NOTES1, C.NOTES2, C.NOTES3, C.NOTES4
FROM
  Out B
  INNER JOIN OutDetailsPacking A on (B.AVIZ=A.AVIZNO)
  LEFT OUTER join ARTICLE C on (A.ARTCODE=C.NAME)
WHERE
  (B.AVIZ=:OrderNo)
  AND (A.COLNO=:ColliID)
GROUP BY
  A.AVIZNO, Artcode,
  B.IDDClient, B.DClient, B.DClientTown, B.DClientTownCode, B.DClientAddress, B.DClientCountry,
  B.IDIClient, B.IClient, B.IClientTown,
  B.IClientTownCode, B.IClientAddress, B.IClientCountry,
  B.CLIENTREFERENCE, b.filldate,* [ArticlesGrid](../Forms/ArticlesGrid.md)
  A.UnitPrice, A.UnitListPrice, A.ContactPerson, A.PHONE, A.FAX, A.LANGUAGE, A.CURRENCY,
  C.NOTES1, C.NOTES2, C.NOTES3, C.NOTES4
ORDER BY
  A.AVIZNO, PackType, ArtcodeSep

Parameters

OrderID the order ID.
ColliID the colli ID.

Accessible in forms

PackingForm