Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Add Separate Item Tracking Lines (Lot #s) to Phys Inventory Journal

Posted on by Microsoft Employee

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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Add Separate Item Tracking Lines (Lot #s) to Phys Inventory Journal

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans