[Roy Greenwood]

We have not used the Physical Inventory portion of NAV but want to begin a Physical Inventory process; working towards a cycle count method.  To calculate the inventory, we were in test mode , set up a request to review 300 and prepare our list for current inventory of about 300 parts.  NAV took a while to complete the preparation these 300 or so part; if that speed is indicative of the request; NAV will take over 24 hours to prepare the list.   Our part number list is under 60,000; with less than 10% in actual inventory; is this process that slow?

Once the list is calculated, do future updates run quicker?

Does Pending Approval, Approved and Obsolete part categories speed it up?

Who shortcuts are available or used to reduce the sort time?

——————————
Roy Greenwood
Operations Director
Brown Deer WI
——————————

[Matt Traxinger]

Not sure which version you are running (or if it has been sped up in more recent versions to be honest), but this process did used to be slow. I believe the times you posted were about the same as what I helped a previous customer with.

We ended up creating a SQL stored procedure that could be run (or scheduled) to mimic the process. Then when the user would calculate inventory it would look at the data compiled by SQL instead of the compiling the data itself. If I remember right we took the process down from 24+ hours to < 10 minutes.

One of the reasons it takes so long is because it also looks at variants and dimensions. So it has to calculate the physical inventory for every combination of something like Item/Variant/Lot/Serial/All dimension combinations. The number of combinations grows very quickly as you might imagine.

——————————
Matt Traxinger
NAV Developer
ArcherPoint Inc.
San Antonio TX
————————————————————————-

[Eduardo Diaz]

Hi Roy,

We have over 75,000 items and the process is not that painful. We use multiple journals per locations and we don’t select “Items Not in Inventory” when calculating the physical inventory. Any inventory not included in the Physical Inventory journal is loaded using an Item Journal. Hope this helps.

——————————
Eduardo Diaz
IT Director
Minequip Corp.
Miami FL
————————————————————————-

[Krupesh Daiya]

Hi 

What Eduardo mentioned seems to be a much better solution and available out of the box. It is logical even for you would do physical inventory by location 

——————————
Krupesh Daiya
Dynamics NAV Freelancer
————————————————————————-