Combine item history

Kayewain

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

Ian_Piddington10199

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

diptish.naskar

Hi Kayewain,

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.

David_Singleton

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.

Kayewain

Thanks to you all for your comments and advice. Seems a non runner then. I inherited some mal-numbering which exceeds the 8 characters that one of our other systems can cope with on interface, maybe its time to persuade my other software supply to extend the character field length.

Regards
Kaye

Alex_Chow

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

kine

And why don't use No. 2 field on the item card, fill it with sequential numbers and use them in the external application as PK for items? You just needs to "translate" No. to No.2 in interface between systems...

Kayewain

Thanks Kamil, thats definately a viable option.

Regards
Kaye