Populararticles
Report PopularArticles
- Filename: : PopularArticles
- Title: : Kind articles in the last Period days.
- Sample: Unit164
Synopsis
List of popular/ddead articles
SQL
SELECT
A.ARTCODE,
A.QTYSTOCK as QTY,
A.QTYIN as MQTY,
A.DateStock as LastDate,
B.Name2
FROM
Printstock A
INNER JOIN Article B ON (A.ARTCODE=B.NAME)
WHERE
(A.JOBID = :PrintJob)
ORDER BY
recordid
Parameters
- PrintJob Job ID
- Kind een van Dead/Popular
- Period Periode (getal).