Announcements
Dear Experts,
I have write the SQL query to show the total no. of quantity available in bin content from SQL server. Here I don't want to show these serial or lot no where have not positive values. I want to show data only serial/lot have only positive values. In my query bot are coming, please help me to rectify it.
My Query is below:
select distinct x.[Item No_],[UAT Private Limited$Item].Description,x.[Variant Code], SUM(x.[Qty_ (Base)]) "Quantity",x.[Serial No_],x.[Lot No_],y.No_,y.[Registering Date] from [UAT Private Limited$Warehouse Entry] x
left outer join [UAT Private Limited$Item] on [UAT Private Limited$Item].No_ = x.[Item No_]
left outer join [UAT Private Limited$Registered Whse_ Activity Hdr_] y on x.[Reference No_] = y.No_
where x.[Bin Code]='101-RG1-N001' and x.[Location Code] = '101' and x.[Zone Code] = '101-RG1'
group by x.[Item No_],x.[Variant Code],[UAT Private Limited$Item].Description,x.[Serial No_],x.[Lot No_],y.No_,y.[Registering Date]
having sum([Qty_ (Base)])<>0
I will be thankful if someone can give resolution on these.
*This post is locked for comments
yes sir, I have matched with warehouse entries
Did you look at Quantity or Qty. (Base) in Bin Content ? Quantity is based on the Bin Unit of Measure.
Hi Teddy,
I appreciate your response. Unfortunately, this didn't solve our problem. Report data is not matched with data available in "Bin Content".
select x.[Item No_],[UAT Private Limited$Item].Description,x.[Variant Code], SUM(x.[Qty_ (Base)]) "Quantity",x.[Serial No_],x.[Lot No_],x.[Registering Date] from [UAT Private Limited$Warehouse Entry] x
left outer join [UAT Private Limited$Item] on [UAT Private Limited$Item].No_ = x.[Item No_]
group by x.[Item No_],x.[Variant Code],[UAT Private Limited$Item].Description,x.[Serial No_],x.[Lot No_],x.[Registering Date]
having sum([Qty_ (Base)])<>0
Sir,
I have added this field for get the correct "Posting Date".
Please help on these critical issue.
Your help will be greatly appreciated.
Why looking at Registered Whse Activity Header ?
Just sum the Warehouse Entry quantity.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156