Call Stack
string Access denied for user 'allbrand_allbran'@'localhost' (using password: YES)
string SELECT * FROM (SELECT JimStock.StockNo, JimStock.StockCode, JimStock.StockDesc, JimStock.Alive, JimStock.GLGroupNo, JimStock.ManufPartCode ,(SELECT IFNULL(SUM(JimStockTran.QtyB), 0) FROM JimStockTran WHERE (JimStockTran.Type = 'P') AND (JimStockTran.QtyB > 0) AND (JimStockTran.StockNo = JimStock.StockNo)) AS OnHand,(SELECT IFNULL(SUM(JimJobPart.Quantity), 0) FROM JimJobPart INNER JOIN JimJob ON JimJobPart.JobNo = JimJob.JobNo WHERE (JimJob.InvNo = - 1) AND (JimJobPart.StockNo = JimStock.StockNo)) AS Committed,(SELECT IFNULL(SUM(JimPODet.Qty), 0) FROM JimPODet, JimPO WHERE JimPODet.PONo = JimPO.PONo AND JimPO.POType = 0 AND JimPO.Status like '%Ordered%' AND JimPODet.StockNo = JimStock.StockNo) AS OnOrder,(SELECT COUNT(JimStockGroups.StockGroupNo) FROM JimStockGroups INNER JOIN JimStockGroup ON JimStockGroups.StockGroupNo = JimStockGroup.StockGroupNo WHERE (JimStockGroup.StockNo = JimStock.StockNo) AND JimStockGroups.RLevel > 0) AS Categories,(SELECT COUNT(JimStockGroups.StockGroupNo) FROM JimStockGroups INNER JOIN JimStockGroup ON JimStockGroups.StockGroupNo = JimStockGroup.StockGroupNo WHERE (JimStockGroup.StockNo = JimStock.StockNo) AND (JimStockGroups.StockGroupNo = 373) ) AS ForwardOrder ,(SELECT COUNT(JimStockGroups.StockGroupNo) FROM JimStockGroups INNER JOIN JimStockGroup ON JimStockGroups.StockGroupNo = JimStockGroup.StockGroupNo WHERE (JimStockGroup.StockNo = JimStock.StockNo) AND (JimStockGroups.StockGroup='AVAIL_PREORD') AND ( JimStockGroups.StockGroup LIKE '%AVAIL_%_%') ) AS PreOrder FROM JimStock WHERE (JimStock.StockNo = ?) AND JimStock.StockNo > 0) DATA WHERE (((OnHand > 0) OR (OnOrder > 0 AND GLGroupNo=2)) OR (ForwardOrder > 0) OR (PreOrder > 0)) AND Categories > 0 ORDER BY StockDesc
All Brands Catalogue ::
All Brands Toys Pty Ltd
25 Gassman Drive, Yatala, QLD 4207
Australia, ABN 84138039586
Call Kirsty
(07) 3287 1000

Login

Categories

    Stock Code
    Pack Size
    Price Login to view prices.
    Categories

    People who ordered this also ordered: