Dynamics Community Forum Thread Details

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

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

Quick Links

Leaderboard