Detailedarticlestock
Report DetailedArticleStock
- Filename: DetailedArticleStock
- Title: Detailed stock for article :ArticleCode
- Sample: Unit47 (form47)
Synopsis
Form to report stock changes on articles.
SQL
SELECT
A.INVOICE AS FACT,
SUPPL AS FIRMA,
DATA,
B.ARTCODE AS ARTICOL,
QTY,
LOCATION AS LOCATIE,
COMENTS,
'INDELIVERIES' AS OPERATIE ,
'' as invout,
QTY AS QTYX,
B.ID,
B.STOCKCODE
FROM
INV A
INNER JOIN INVDETAILS B ON (A.INVOICE = B.INVOICE)
WHERE
(A.DATA BETWEEN :MinReportDate and :MaxReporDate)
AND (B.ARTCODE=:ArticleCode)
UNION
SELECT A.AVIZ AS FACT,
CLIENT AS FIRMA,
A.DATA,
B.ARTCODE AS ARTICOL,
B.QTY,
C.LOCATION AS LOCATIE ,
B.COMMENTS AS COMENTS,
'DELIVERIES' AS OPERATIE ,
'Delivered from '+C.INVOICE as invout,
B.QTY*(-1) as qtyX,
B.ID,
C.STOCKCODE
FROM
OUT A
INNER JOIN OUTDETAILS B ON A.AVIZ = B.AVIZNO
LEFT OUTER JOIN INVDETAILS C ON B.INVOICENO=C.ID
WHERE
(A.DATA BETWEEN :MinReportDate and :MaxReporDate)
AND (B.ARTCODE=:AtricleCode)
ORDER BY
B.ARTCODE, OPERATIE, A.DATA
Parameters
- MinReportDate (Date) max date of article movements.
- MaxReportDate (Date) min date of article movements.
- ArticleCode (String) article code.