Ga naar inhoud

Articlestobecleared

Report ArticlesToBeCleared

  • Filename: ArticlesToBeCleared
  • Title: Articles To Be Cleared for today
  • Sample: Unit136

Synopsis

A list of articles which must be customs cleared for today's orders.

SQL

Select
  ARTCODE,
  sum(QTY) as TQTY,
  STOCKCODE,
  ORIGINALSTOCKCODE,
  SUPPLIER,
  FILLDATE,
  COMMENTS
FROM
  OUTDETAILSCC
WHERE
  CONVERT (CHAR (10), FILLDATE, 120) = CONVERT (CHAR (10), getdate(), 120)
  AND (TransactionType = 'ORD')
  AND (ORIGINALSTOCKCODE = '99')
  AND (STOCKCODE = '25')
GROUP BY
  ARTCODE,
  STOCKCODE,
  ORIGINALSTOCKCODE,
  SUPPLIER,
  FILLDATE,
  COMMENTS
ORDER BY
  ARTCODE

Parameters

Accessible in forms