cancel
Showing results for 
Search instead for 
Did you mean: 

How to get actual stock quantity and it's actual warehouse BIN location ?

mucipilbuga
Participant
0 Kudos

Hi,

I want to get warehouse report with SDK or Service or maybe SQL?

I want to see actual bin locations and it contained item card and quantity.

I found some SQL samples here but it shows DefauldbinLocaiton of item card. But I may put the items other bin locations from their default.

Shortly, How many items consist in the warehoue bin locations address?

Regards,

Mucip:) 

View Entire Topic
LoHa
Active Contributor

Hi,
have a look here:

https://www.1dash1.co.uk/2015/05/sap-business-one-sql-batch-or-serial-number-quantities-in-a-bin-loc... 

The stock can be found in OITW Table in combination with ItemCode

regards Lothar

 

mucipilbuga
Participant
0 Kudos

Hi,

In the sample you sent SQL asking for warehouse, stock and bin location.

But I want to define only warehouse. Report should give me all the bin locations and containing part and quantity in it?

I want to check all the binlocations of the warehouse. Are part and container bin and also quantity correct?

Regards,

Mucip:)