Combine item history

Hi Kayewain

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

Kayewain wrote:

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

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.

It's not a good idea to combine item history together. For one thing, your costing would go haywire.