Deliveredarticles

Report DeliveredArticles

• Filename: DeliveredArticles
• Title: Deliveries for period :StartDate - :EndDate
• Sample: Unit196 (form196)

Synopsis

Summary of deliveries during a period.

SQL

SELECT
  D.ARTCODE,
  F.NAME2,
  sum(QTYIN-isnull(QTYOUT,0)) as Stock,
  isnull((Select sum(QTY) from OUTDETAILS G WHERE G.FILLDATE>=:StartDate
  AND G.FILLDATE<:EndDate) AND G.ARTCODE=D.ARTCODE ), 0) AS PQTY
FROM
  STOCTOTAL D
  LEFT OUTER JOIN Article F ON (D.ARTCODE=F.NAME)
WHERE
  QTYIN-isnull(QTYOUT,0)>0
--  {CustomFilter}
GROUP BY
  D.ARTCODE, F.NAME2
order by
  D.ARTCODE

Parameters

• StartDate (TDateTime)
• EndDate (TDateTime)
• CustomFilter (string, macro)

Accessible in forms

1. InvoiceReports