Physical Inventory Journal can't only filter bin #

kiyac

I wonder it is a bug or std logic that physical inventory journal can't just filter by bin # only.

Example :
Locaiton A - bin # 123 with item ABC 5 pcs
Locaiton B - bin # 123 with item ABC 6 pcs

I would like to use physical inventory journal for stock take bin # 123 regardless location.

Run physical inventory journal (function > calculate inventory...)
Item tab > bin filter = 123

Expect result after physical inventory journal (function > calculate inventory...)
2 rows
Location A, Bin # 123, item ABC, Qty = 5 pcs
Location B, Bin # 123, item ABC, Qty = 6 pcs

However, my testing result in NAV 5.0 SP1 is
Aparting from these 2 rows, other rows with bin# = null also show out.

ramone.hamilton

Have you tried doing this in a report instead so that you can manipulate your filters to return and display the information the way you want. When you say that it is returning bins that have null values, are these the same numbered bins from your query?