x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 15 subscribers
  • Views 684 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
4
replies
General Discussion
1k
topics
2k
replies
shabbaranks

Trying to link Stock item to TraceableBinItem within SQL

SUGGESTED
Posted By

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

Parents
  • 0
    SUGGESTED

    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 

Reply
  • 0
    SUGGESTED

    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 

Children

*Community Hub is the new name for Sage City