Hi all,
I have been asked to create this. What the user wants is a report that shows all Bins in the warehouse and then the total quantity of items in each bin. Does anyone have any ideas how to do this. My findings so far -
- I cant do this as a Bin saved search as there is not inventory detail detail from the bin record
- If I do this as an Item search and look at the bins in the Inventory detail I don't get any of the empty bins.
- Using the above solution (point 2) I also don't want to show any inventory items that have no transactions at all.
If anyone has done anything similar in the past I would appreciate any help on this.
Thanks
Chris