-
In my current upgrade process I needed to copy the Record Link table from one database to another. I can use a copy-paste method for small number of records but in this case I needed something else. A Dataport or a XML Port was the way I choose to go. There is one problem though. [...]
-
In the Classic Client we had the C/AL command BEEP to sound an alert to the user. This function is not supported in the Role Tailored Client. Here we have a solution in .NET. Where Console is a RunOnClient DotNet variable ‘mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089′...
-
The Page 9082 is not displaying correct information. One of the fact boxes for sales is the Customer Statistics factbox page 9082. The last amount, “Sales YTD (LCY):” is in fact the total sales for the customer. I wanted to change this and use 12 months sales instead of YTD sales. I changed...
-
You can say; “that won’t work”, and you are correct. It will not work. Some years ago I wrote a batch that loops through customer ledger entries and creates a total. Based on that total I wanted to create a claim and send it to the local bank for collection. This batch has been working...
-
In the sales process NAV check for both credit limits and overdue balance on the customer. This is a needed process to inform the salesperson before posting the order or the invoice. However, the problem is that the warning is … Continue reading →
-
If you have worked on a Role Tailored Layout and wanted to show a report without decimals you have most likely seen that the AutoFormatType option that we have in the Dynamics NAV 2009 R2 Classic Client does not work … Continue reading →
-
I have now completed my first all-dotnet codeunit. The codeunit uses a dll file that I created from the web service WDSL. This makes the programming a lot easier. This solution has a BLOB fields that stores both incoming and … Continue reading →
Posted to
Gunnar's Blog
by
thegunzo
on
2012-11-26
Filed under:
Filed under: Dynamics NAV, Solutions, Role Tailored Client, Web Services, NAV 2009 R2, XML, Soap Services, C/Side Code, Dotnet interoperability, BLOB, Add-in, NAV 2013
-
In an earlier post I showed how to kill idle sessions from C/AL code. I have been asked to provide a batch that works with Job Queue. To set this up please add a field to table 91. Field name … Continue reading →
-
I have been working with the dotnet interop and consuming soap web services. I wrote about a dotnet interop based way to communicate with soap web services in a previous blog but now I want to demonstrate another way that … Continue reading →
-
I am currently working on a solution that requires a Dynamics NAV client to communicate with Dynamics NAV web service. This I have done before with the classic client and have used automation objects for the job. Now I wanted … Continue reading →
-
On of the bigger tasks when upgrading to the Role Tailored Client is the report transformation. In big database there are houndreds of reports. Some of them might just be idle reports that are never used. This blog from ArcherPoint … Continue reading →
-
Sometimes a little more flexibility is needed than a single XML Port in a web service function. Then it is possible to send multiple files to a single web service. I am working on an enhancement for the inter-company posting … Continue reading →
-
XE.COM claims to be the world’s favorite currency site. They have XML data feed options that can be used to download the latest currency exchange rates into Dynamics NAV. I wrote a batch to import the current currency exchange rate from their data feed. … Continue reading →
-
If you are like me, located in a non-English speaking country and would like users to be able to use other tools then the Dynamics NAV clients to access the company data you will find that all the meta data … Continue reading →
-
Today I posted a new feedback to Microsoft. My experience is that companies that use inventory should execute Inventory Adjustment with the Job Queue every night. To be able to do this a change is required to the OpenWindow trigger in codeunit … Continue reading →