Skip to main content

Notifications

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,565 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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans