Items with more than 1 entry in Bin Content

beckindenmark

Hi NAV guru´s

I need a simple report that shows me a list of items with more than 1 "Bin Code"
But I can´t make it work, I´ve tryed to set filter on Bin Content if Count > 1, it only works for one item at the time? I´ve even tryed to set filter and copy to a temp table, but still only works for one item(maybe temp is being overwritten at loops??)

Please guide me to the best way to get started

I think it is pretty easy, but I can´t see the way :oops:

matttrax

So a report that lists all items that are located in multiple bins...

Start with Item. Link to Bin Content. Do a CALCFIELDS to calculate the actual content of the bin. Keep track of how many of those bins have items in them. If that total is more than one, display it.