Report to show Item No., Lot No., Expiration Date, Location Code and Bin Code

vh8000

Hi All

NAV2013R2

I would like to generate a report that shows:-
Item No., Lot No., Expiration Date, Location Code and Bin Code

I tried set the relationship in my report dataitems Item ->> Bin Content ->> Item Ledger Entry, but the result are random (sometime correct but sometime incorrect).

Could anyone show me what is the correct Relationship/Link of tables in order to get the result I need?

Thanks in advance.

Vincent

krasi_varna_77

item link to bin content via "no." from Item.
"bin content" consist only "Item no." and "location". when there is movement from bin to bin no item ledger entry record

vh8000

Thanks for your response krasi

That's the problem I have once the movement between bins occur.

I would like to know how to get the correct bin code, expiration date and lot no. even after movement.

Thanks

kine

Look for Query 7300. it is what you need.