30
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
Hi Ismolboi,
You can download the latest version from Mibuso website, it is just uploaded:
Hi Ismolboi,
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!
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (