Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Item No. Update on a Mass Scale

Posted on by 20

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? 

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,698 Super User 2024 Season 2 on at
    RE: Item No. Update on a Mass Scale

    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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item No. Update on a Mass Scale

    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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Item No. Update on a Mass Scale

    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.

  • eebeats Profile Picture
    eebeats 20 on at
    RE: Item No. Update on a Mass Scale

    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.

  • eebeats Profile Picture
    eebeats 20 on at
    RE: Item No. Update on a Mass Scale

    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.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Item No. Update 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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans