Receptions

Report Receptions

Filename: receptions
Title: Receptions in periode :StartPeriode - :EndPeriode
Sample: Unit42

Synopsis

List of receptions in a periode.

SQL

SELECT
  COUNT(D.ID) AS NRLINII,
  sum(D.QTY) as MyQTY ,
  D.StockCode,
  C.CATEGORY+' '+isnull(B.GROUPE, '') as CATEGORY,
  SUM(D.QTY*WEIGHT) AS TWEIGHT,
  SUM(D.QTY*(CASE WHEN B.UMV='Cbm' THEN B.VOL*1000 ELSE B.VOL END)) AS TVOL,
  SUM(D.QTY*isnull(SubComponentsTQTY, 1)) as SQTY
--  {ExtraItems}
FROM
  INVDETAILS D
  LEFT OUTER JOIN ARTICLE B ON D.ARTCODE=B.NAME
  LEFT OUTER JOIN ARTICLECATEGORY C ON
    (isnull((CASE WHEN B.UMV='Cbm' THEN B.VOL*1000 ELSE B.VOL END), 0)>=C.VOL1)
    AND (isnull((CASE WHEN B.UMV='Cbm' THEN B.VOL*1000 ELSE B.VOL END), 0)<C.VOL2)
    AND (isnull(B.WEIGHT, 0)>=C.WEIGHT1 AND isnull(B.WEIGHT, 0)<C.WEIGHT2)
    and (C.CategoryID=:Category)
WHERE
  (D.RSYSTEMDATE>=:StartDate)
  AND (D.RSYSTEMDATE<:EndDate)
--  {CustomFilter}
GROUP BY
  D.StockCode,
  C.CATEGORY,
  isnull(B.GROUPE, '')
--  {ExtraItems}
order by
  CATEGORY,
  D.StockCode

Parameters

StartDate (TDateTime)
EndDate (TDateTime)
Category (Integer)
CustomFilter (string, macro)
ExtraItems (string, macro)
ShowExtraItems (boolean)

Accessible in forms

InvoiceReports