Trying to link Stock item to TraceableBinItem within SQL

Question

Hi, 
 I'm trying to produce an SQL query which will show me all traceable stock in stock containing their bin location - Im probably missing something really simple but I cant for the life of me see how this is achievable. I can get the in stock amount but not link it to which bin its in - can anyone shed some light on it for me please? 
 Thanks

Geoff Turner · Answer

SELECT StockItem.Code, TraceableItem.IdentificationNo, TraceableBinItem.BinName, TraceableBinItem.GoodsInQuantity - TraceableBinItem.GoodsOutQuantity AS QtyInStock
 FROM StockItem INNER JOIN
 TraceableItem ON StockItem.ItemID = TraceableItem.StockItemID INNER JOIN
 TraceableBinItem ON TraceableItem.TraceableItemID = TraceableBinItem.TraceableItemID
 WHERE TraceableBinItem.GoodsInQuantity > TraceableBinItem.GoodsOutQuantity

Sage 200 UKI

Trying to link Stock item to TraceableBinItem within SQL

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING