Hello,
I am looking to use the Phys. Inventory Journal to upload a physical inventory count. Our items have both bin locations and lot numbers assigned. Using the phys. inventory journal, I have populated our items broken out by bin. I am currently stuck however, because there will be both positive and negative variance within each lot inside each bin, but NAV will only let make adjustments that align with the overall entry type.
For example:
Item A - Bin 1 - Qty (Calculated) 10 - Qty (phys inventory) 11 (positive adj)
New quantity due to changes in lot:
Lot 123 +2
Lot 456 -1
With the current setup, I can only process the increase in lot 123, and I would have to increase our overall inventory by +2, then go back and do a negative adjustment for -1.
Because there is going to be a lot of positive and negative variances with each bin, is there a way to break out each lot when calculating the inventory? That way the qty calculated will be for the item+bin+lot, and I could just enter the Qty (phys inventory) for each lot?
Thanks
T
*This post is locked for comments
Hi,
The above Phy inventory Journal is to record the difference between the Physical and book stock item & bin wise. If you have to do with the Lot number it is better to do by item journal.
Regards
Narayan Seshaddri
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156