Combine item history

KayewainKayewain Member Posts: 6
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

Comments

  • Ian_Piddington10199Ian_Piddington10199 Member Posts: 167
    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
    Regards

    Ian
  • diptish.naskardiptish.naskar Member Posts: 360
    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.
    Diptish Naskar
    For any queries you can also visit my blog site: http://msnavarena.blogspot.com/
  • David_SingletonDavid_Singleton Member Posts: 5,479
    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.
    David Singleton
  • KayewainKayewain Member Posts: 6
    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_ChowAlex_Chow Member Posts: 5,063
    It's not a good idea to combine item history together. For one thing, your costing would go haywire. :(
  • kinekine Member Posts: 12,562
    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...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • KayewainKayewain Member Posts: 6
    Thanks Kamil, thats definately a viable option.

    Regards
    Kaye
Sign In or Register to comment.