Performing mass updates of Item/Vendor/Customer Cards

(0) Share

Report

Posted on by Community Member

Is there a method to perform updates to thousands of Customer/Vendor/Item cards all on a large scale? I know rapid start allows for importing new records, but I can’t find any documentation that indicates it can be used to change only a few fields of cards that already exist, like would it have problems validating in import?

I want to to be able change things like the Production BOM No., Production Routing No., lead time, reorder point, max inventory, reorder qty, weights, scrap %, etc, on the item cards, and fields such as Credit Limit, Payment Terms Code, Collection Method, Payment Method, in Customer Table. If I can’t use RapidStart, is there another tool I can use to update these fields in a mass/batch mode?

Thanks for any help that can be rendered!

*This post is locked for comments

All responses (7)

Answers (2)

Suggested answer

Community Member on at

Like (0)

Report

RE: Performing mass updates of Item/Vendor/Customer Cards

Hello, you can do this through data migration in the Administration section of 2009 R2. Choose table 27 to update items. Open the table and add a check mark next to the columns you want to update. Then you can export to excel, make your changes and then re-import into Navision apply the data.

It is good to always keep a copy of your export in case you make an error when importing your data. Also, it is good to note that whatever you import will override what is currently in Navision. So only change the columns that need changed.

Reply
Community Member on at

Like (0)

Report

RE: Performing mass updates of Item/Vendor/Customer Cards

Hello,

I am very new to NAV and have been tasked to update all item cards with the vendor number in the vendor no section. As of now, all item cards do not have anything populated for this field. What I don't want to do is manually enter in a number for thousands of item card :/....... How can I mass/auto update? I don't see Rapid Start. I entered it in the search function and nothing comes up. Im using Microsoft Dynamics NAV 2009 R2. Any help would be greatly appreciated.
burgesst on at

Like (0)

Report

RE: Performing mass updates of Item/Vendor/Customer Cards

It is!
Suggested answer

Amol Salvi 18,696 on at

Like (0)

Report

RE: Performing mass updates of Item/Vendor/Customer Cards

You need to enter Customer Number in Excel file.
burgesst on at

Like (0)

Report

RE: Performing mass updates of Item/Vendor/Customer Cards

I tried this, but ran in to problems where the primary key (eg customer no.) was associated with a number series. I got an error saying 'you may not enter numbers manually, please activate manual nos. in no. series CUST.'

The only way round this seemed to be allowing manual entries in the number series temporarily.

Is there any way to tell Rapidstart to use the primary key just as that, and only update the field you are interested in ?
Verified answer

Alexander Ermakov 28,094 on at

Like (0)

Report

RE: Performing mass updates of Item/Vendor/Customer Cards

You can use RapidStart for that purpose, as well as Excel Importer: mibuso.com/.../universal-excel-importer-v1.2
Verified answer

Mohana Yadav 60,226 Super User 2025 Season 1 on at

Like (0)

Report

RE: Performing mass updates of Item/Vendor/Customer Cards

yes, you can use modification of records also using rapidstart.

it will validate the fields which you are importing ans shows error if data is not valid.