Been tasked with changing a bunch of Item No. In NAV 2013 for a new Wine Company. Any way to do this via config package or anything else? I can't be the first one who has wanted to do this? Do I have to crack open the sql database? It seems like there should be a feature to change a bunch of Item No. in NAV with out having to go one by one in each Item Card?
Hi, If you want to change the primary key, you cannot use the Configuration Package, because new items will be added.
think you need to develop a small tool that uses Excel buffer or xmplport to import the updated Item list. Remember to run the Rename trigger because there are a lot of historical data that need to be updated automatically.
Hope this will help.
Thanks.
ZHU
Hello,
If you are trying to change the actual Item No. (rename it), in mass, I would work with your Partner to create a one-time utility to read an Excel File of Item No. Current and Item No. New (2 columns) and then you can run this utility to rename them in mass.
Thanks,
Steve
If you want to update the Item no. that is the primary key for the Item table i recommend you do that from CAL code if you are on version 2013.
I would create a new table consisting of the new and old item no. Import that into NAV and then use that table to update my Item No. using a processing only report or a codeunit.
I understand configuration packages, but Item No. is what I want to change, the actual ID or number itself, not data on the item config package.
Everyone answers this way. I'm not changing information on the item card. I want to change the Item Numbers themselves on a mass scale.
It depends a little on what information you want to change. But usually you should be able to do it using a configuration package.
But in some cases you will need a more customized import / update routine.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156