Dynamics Community Forum Thread Details

Physical Inventory - NAV 2013R2

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

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.

Quick Links

Leaderboard