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

Item No. Update on a Mass Scale

(0) Share

Report

Posted on by eebeats

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?

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
eebeats 20 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
eebeats 20 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,681 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No