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

barakkorIL
barakkorIL Member Posts: 2
edited 2016-02-14 in NAV Three Tier
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

Answers

  • davmac1
    davmac1 Member Posts: 1,283
    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/
    David Machanick
    http://mibuso.com/blogs/davidmachanick/
  • kriki
    kriki Member, Moderator Posts: 9,133
    [Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • sorenhinrup
    sorenhinrup Member Posts: 136
    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.

Categories