Stockreport1

Report StockReport1

• Filename: StockReport1
• Title: Stock Report - :Date
• Sample: unit124 (Form124)

Synopsis

SQL

SELECT
  A.ARTCODE , B.NAME2, A.STOCKCODE, A.LOCATION, min(A.FILLDATE) as FILLDATE, A.EXPIRYDATE,
  isnull(A.LOTNO, '') as LotNo, isnull(A.PALNO, '') as PALNO,
  sum(QTYIN) as QTYIN,
  sum(QTYOUT) as QTYOUT,
  sum(isnull(QTYSTOCK, 0)) as QTYSTOCK,
  sum(QTYSTOCK*isnull(Weight,0)) as Weight,
  sum(QTYSTOCK*isnull(Vol,0)) as Vol
FROM
  PrintStock, ARTICLE B ON (ARTCODE=NAME)
WHERE
  (PrintJob=:PrintJob)
GROUP BY
  A.ARTCODE , B.NAME2, A.STOCKCODE, A.LOCATION, isnull(A.PALNO, ''), A.EXPIRYDATE, isnull(A.LOTNO, '')  
ORDER BY
  ARTCODE, LOCATION

Parameters

• PrintJob id van job.
• StockDate Date when articles are placed in stock.
• NextDate StockDate+1

Accessible in forms