Articlevolumeweights
Report ArticleVolumeWeights
- Filename: ArticleVolumeWeights
- Title: Articles, volumes, weights for StockCode 75 [and supplier :Supplier]
- Sample: Unit193
Synopsis
List of articles with volume and weight for StockCode 75 (of a certain supplier)
SQL
SELECT
ARTCODE, WEIGHT, UMW, VOL, UMV, ALength, AWidth, AHeight
sum(QTYIN-isnull(QTYOUT,0)) as QTY,
from
STOCTOTAL A inner join ARTICLE B ON ARTCODE=NAME
where
(A.StockCode='75')
-- {CustomFilter}
GROUP BY
ARTCODE, WEIGHT,UMW, VOL, UMV, ALength, AWidth, AHeight
ORDER BY
ARTCODE
Parameters
- CustomFilter macro which can contain a filter on supplier.
- Supplier Supplier, if any.