Edit Report:Item Master List w Prices testing for V8(QITMEXP)
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Item Master List w Prices testing for V8(QITMEXP)
-- QITMEXP
-- No Drill Downs
SELECT
s.stockid as `Item No`,
s.description as `Item Description`,
s.sort2,
s.sort,
s.lineid as VEND1,
s.lineid as MFGCD,
locstock.daterec as `DateRec`,
CAST(Sum(locstock.quantity)AS DECIMAL(10,2)) AS `On Hand`,
s.lastcost as `Last Cost`,
locstock.cost as `Ave Cost`,
CAST(s.materialcost AS DECIMAL(10,2)) as Cost,
t.warranty as `Wrnty Days`,
t.loadindex as Ind,
t.speedrating as S,
s.categoryid as `Catg`,
case when p.typeabbrev = 'A' then p.price else 0 end as `List`,
locstock.minimum as `Min`,
locstock.maximum as `Max`,
locstock.bin as `Bin`
FROM
stockmaster s
INNER JOIN prices p ON s.stockid = p.stockid
LEFT JOIN locstock ON s.stockid = locstock.stockid
LEFT JOIN tireinfo t on s.stockid = t.stockid
Where locstock.loccode = '01'