Hi,
Earlier in April I asked
Does anyone have a solution for re-numbering a large number of items, in excess of 7000. Currently via the manual process its taking approx 8 minutes per item and blocks all users. Therefore not enough downtime to run as a job out of hours. Lots of useful replies but due to our 24/7 business not enough downtime to execute the changes via re-nameing items.
Does any one know if it is possible to first create new items and then later combine with old item number to ensure history is maintained?
Thanks
Kaye
0
Comments
There is no standard functionality that would do this that I can think of. Even when 1 item superseeds another if it is set up as a different item code there is no unified view of the ledgers.
It wasn't clear in your other post why you want to renumber the items.
Maybe there is another way to achive what you want, can you give us more details?
Ian
Ian
Nopes, as far a I remember there is no such functionality by which you can acheive the same. You will never be able to get a unified Item histroy.
For any queries you can also visit my blog site: http://msnavarena.blogspot.com/
Yes you can write some code to do this, its pretty easy. Using delete and rename. BUT it won't solve your issue. Since the merge, is in fact a "delete/rename, and will have the exact same issue that you currently have, i.e. that it will take a long time, and lock up all the other users whilst it is running.
Even if you wrote code to do this, you would still need to force a lock before you start.
Basically this is why Navision recommend against using "intelligent part numbers" in the first place. I am guessing that you have originally set up intelligent part numbers, realized how big a mistake it is, and now want to move to sequential numbers. Unfortunately the locking is not an issue you can resolve in a 24/7 environment.
Regards
Kaye
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Regards
Kaye