Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Physical Inventory - NAV 2013R2

Posted on by Microsoft Employee

We are a manufacturing company with a large inventory, over 14K items.  Many of our items are located in multiple locations with multiple bins.  In order to prepare for our inventory in the past, we were able to create a tag file from the system previously used and download in to an excel spreadsheet which was sent off-site to create tags.  The system had the ability to use this tag file to record the tag #, qty counted, items with more than one tag, location of the items and create a report indicating differences of actual vs system on-hand.  We were then able to upload the adjusted inventory count directly in to the system.  Has there been a similiar situation with other NAV users and is there a way to update the inventory journal without manually keying the quantity?

Thanks,

SueW

*This post is locked for comments

  • Suggested answer
    Alex A Profile Picture
    Alex A 2,348 on at
    RE: Physical Inventory - NAV 2013R2

    Hi Sue,

    You can use the Warehouse Physical inventory List (count sheets) to provide you with the Item No., Description, Location, Zone, and Bin Code of the items needing to be counted. When you go to print the Count Sheets you have the option to include or not include the actual count (if not included the printout will have a column named Quantity with blank lines for the counter to write the physical count on).

    Also, the Whse Phys. Inv Journal becomes the validation report indicating the differences of the actual vs system on-hand. The Quantity field defaults to the difference between the Qty (Calculated) column [this is the beginning on-hand values] and the Qty (Phys Inventory) column [this is the amount that has been data entered after the physical count]. As soon as the physical counts are entered the Quantity column shows the difference, which allows you to see where re-counts may need to take place before Registering the data entry.

    Not sure how you could update the inventory journal without manually keying the quantity since the Qty (Phys. Inventory) field defaults to all zeros. If you post without entering it will zero out your inventory. What we did was created batches for each data entry person, and broke up our 12,000 items giving each person a manageable amount of data entry to do.

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,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans