Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
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!
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.
You can use RapidStart for that purpose, as well as Excel Importer: mibuso.com/.../universal-excel-importer-v1.2
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 ?
You need to enter Customer Number in Excel file.
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.
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.
Business Applications communities