In one of my projects I use Excel a lot for reporting. I create the Excel documents with OpenXML and with the help of the Excel Buffer table. With the click of a button the user creates a beautiful Excel Workbook but when I open the workbook it is displayed in the back of Dynamics NAV client window....
In NAV 2009 I used a custom control add-in to enable timers in the Role Tailored Client. NAV 2013 ships with a control add-in that is called PingPong. In upgrading one of my solution to NAV 2013 I wanted to remove the custom control and introduce the PingPong instead. The control requires a name and...
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=220.127.116.11, 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...
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 →
Gunnar Þór Gestsson
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
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 →
In one of my solutions I create a lot of Excel and PDF documents. All these documents are stored in BLOB fields and then downloaded to the client computer temporary folder and opened for the user. Every time I use … Continue reading →
I have been using the automation ‘Microsoft XML, v6.0′.XMLHTTP to communicate with web services and web sites. I have been experiencing a problem with this automation when running in Role Tailored Client. The solution has been to use the automation ‘Microsoft XML, … Continue reading...
I have been working on a solution for file download. I am now able to download both binary and text files both via http and ftp and both with Classic Client and Role Tailored Client. Attached is a codeunit that … Continue reading →
For some time have been looking for a solution on how to upload a file into BLOB with RTC Client. The built in functions, UPLOAD and UPLOADINTOSTREAM both force an Open Dialog. I already had the file name and wanted … Continue reading →
In the process of importing data from MSSQL into NAV I needed to import a comment text. I wanted to import the text into the Note BLOB field in the Record Link table. It was not obvious how to do … Continue reading →