You’re offline. This is a read only version of the page.
Hi experts, is there a quick way to update currency code from blank to USD in both Customer and Vendor tables instead of going one by one? Thanks in advance.
*This post is locked for comments
for a developer, processing only report is quicker
I managed to use XMLports to do it. I think that's the easiest method? Thanks for the suggestion.
On the Customer DataItem Properties on the DataItemTableView you can apply the filter to filter the customers or other filter criteria, to see the OnAfterGetRecord or code you need press F9 while you are on the designer or View -> Code.
Hi I only get as far as displaying the Customer properties in report designer. I can't find the OnAfterGetRecord and is it to filter only the blank record. Some currency code fields have value and shouldn't be overwritten.
Below link is an example of creating a process report which you can use to update Currency Code
https://msdn.microsoft.com/en-us/library/hh165871(v=nav.90).aspx
In your case you need to use Customer/Vendor as DataItem and in the OnAfterGetRecord you update the field and MODIFY.
You need to have proper development license to create reports, if you don't have the license please contact your partner.
You have several options.
1. Export customer and vendor master using RapidStart or using XML ports and then do the modification in the excel and upload it back.
2. Create a process only report or a codeunit and then modify the masters.
To carryout both the options you required to have a developer license. Talk to Dynamics NAV partner if you do not have the development license.
Are you a customer or partner?
Please contact the partner.
I have no idea on how to do that? Can you give me some guidance on doing that?
you can create a processing only report or codeunit.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (