How can i see the items serials (Item Tracking) that are on a specific bin ?

barakkorIL

Hello,
I am looking for a view / report that will show me the the items and serials (Item Tracking) that are on a specific bin ?
the closest view i found was the bin content but the serial does not show there (only Lot in a sperate factbox)

Thanks

davmac1

bin content quantities fields are based on flowfields derived from warehouse entry. If you want to see a specific lot or serial no., you can use a flowfilter.
If you want to see all lots and serial numbers, then you can do a sum of warehouse entries by item no., bin no., lot no., and serial no.
If you are using NAV2013 or above, you can use a NAV query.

I have added the open lots to the bin content page using code to find the open warehouse entries.
If you do not have a developer license then the NAV Query is a simple way to do it/

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

sorenhinrup

If you have set the specific Lot/Serial tracking to true on the Item Tracking setup, then you will have the Lot-number or Serial number on the warehouse entries.
Then you can create a page with the sum of entries in a Bin for a specific serial number.