Hi,
Does NAV2015 has any other option to mass update records like, Customer, Vendors and Chart of Account to add dimensions as code mandatory???
Please see screenshot
*This post is locked for comments
You absolutely should make next :
1) Update your current vendor/customers def.dim by using or rapid start or other excel import tool
2) Create a little customization to automatically add needed default dimensions in every new vendor/customer record.
3) forget about this, cos after 1 & 2 it will be work automatically
yes its possible , you can add it to your Customer, Vendors header tab
yes its possible ,
i think its better to add the dimension on your header tab or line tab ,
then you can make it easily and make mandatory field
Hi Ismolboi,
You can download the latest version from Mibuso website, it is just uploaded:
mibuso.com/.../universal-excel-import-export
Excel import will be the easiest and fastest because Rapidstart is in built and you do not have to do any modifications to your existing system.
Besides RapidStart, we have Universal Excel Import Export tool helps you mass update records.
- Prepare Excel as below:
- Open tool, browse Excel file and finish.
We can support you an evaluation to the end of this month. Please feel free to contact us!
4bzsoftware.com/.../universal-excel-import-export.html
Besides RapidStart, another option is to write a simple Processing Report. It's basically a Report with isn't intended to generate an output such as a printout.
If you are familiar with the table schema in NAV and comfortable with some basic C/AL, you can do mass updates to tables with just a couple lines of code. For instance, here, you would create a Processing Report with DataItem = Default Dimension, and use the DataItemTableView property to filter the Table ID field on the table numbers for G/L Account (15), Customer (18), and Vendor (23). The two lines of code would be to update the value of the Value Posting field on the Default Dimension record to Code Mandatory, and to modify the Default Dimension record.
See here for more information on Processing Reports: msdn.microsoft.com/.../hh165871(v=nav.90).aspx
I hope this helps. If my response has answered your question, please take a moment to verify this by clicking Yes next to "Does this answer your question?"
You can do it through RapidStart.
Add Table No. 352 to a RapidStart "Configuration Package" if you don't have it set up in one already. Then within the Package, select that row and from the Tables FastTab menu, select Table, Filters.
Enter a filtering row with:
Filter Field ID = 1 (Field Name and Field Caption columns should both automatically populate as "Table ID") then in Field Filter column put 23 (which is the Vendor table number) so you don't unnecessarily export Default Dimensions for your Customers (table 18), Items (table 27), etc., at the same time.
Export the spreadsheet for what you have entered manually so far and it should be clear how you need to populate the rest.
Import it and Apply it (ideally in a test database first, of course). You can Apply just one or two new rows first to double-check before Applying the whole of the rest of the Import.
PS: Currently I am Manually updating all records, and it takes time since there are hundreds of records in the system.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Saurav.Dhyani 2 Super User 2025 Season 2
RK-25090803-0 1
