Inventory Status Bin & Location

sunnyk

Hi,
We have 8 locations. 4 of which are Bin Mandatory. So for these 4 locations we can use Bin content Table to get the inventory status per bin for an Item.How to show Item Inventory status for all these 8 location in one report in the format similar to Location Code,Bin Code, Item No., Qty. if there is no Bin(for Non Bin Locations), the Bin Code will be blank. i tried many combinations like Location as main DataItem and Item & Bin Content as indented, but didn't get the desired result. Any hint on this please.

pavithrap0992

You may need to use Item as the first DataItem followed by Location and Bin Content.