NAV 2009
-
Handling Sales Orders from Page based Web Services – in NAV 2009SP1 (and RTM)
First of all, there isn’t going to be a new post on every single record type on how to handle them from Web Services – but Sales Orders are special and the reason for the “(and SP1)” in the titel refers to the fact, that there are changes between RTM and SP1 or maybe a better way to state it is, that the way you could do it in RTM (that might lead to errors) is no longer possible –...
-
Web Services changes in NAV 2009 SP1
NAV 2009 SP1 is being released later this year, so why write about it now? The main reason is, that NAV 2009 SP1 comes out with a couple of changes, you might want to take into consideration when writing towards NAV 2009 Web Services. Except for some performance enhancements, the major changes are: New standard encoding of the Company name I think one of the questions that has been asked the most is, how does my company name look in...
-
Installing NAV 2009 without A/D
The majority of installations of NAV 2009 will be in a network environment, you will have a domain server and an Active Directory with your users and your biggest worries will be how to setup a 3T environment on 3 different boxes, getting the delegation setup correctly all of that stuff. But in a few cases we might run into situations, where there is only a LAN between a number of machines and no server. In this post I will...
-
Using LINQ with NAV Web Services
In .NET 3.5 Microsoft released LINQ (Language INtegrated Query) – which is a way of writing select statements strongly typed inside your C# code. Wouldn’t it be nice if we could leverage this technology when connecting to NAV Web Services? I thought YES – so I set out to find out what it took… The goal was to be able to replace code like this: CustomerRef.Customer_Service cservice = new CustomerRef.Customer_Service(); cservice.UseDefaultCredentials = true; CustomerRef.Customer_Filter filter = new CustomerRef.Customer_Filter(); filter.Field =...
-
Edit In Excel R2 – Part 1 (out of 2)
This post assumes that you have read the 4 step walkthrough of how to build the Edit In Excel demo from November 2008. You can find the parts here: Part 1, Part 2, Part 3, Part 4 and the Bug Fix. In this post I will talk about what is needed in order to be able to save an Excel spreadsheet on a local disc, edit it offline and then submit your changes later. My first assumption was that this...
-
Edit In Excel – bug fix and R2
If you haven’t read the 4 step walkthrough of how to Edit In Excel from Microsoft Dynamics NAV, you should do so here this post is a follow up to the original posts. I have received a number of suggestions to what you could do with the Edit In Excel and a single bug. In this post I will fix the bug and I will explain what R2 is all about. The Bug The bug description is, that if you...
-
Integration to Virtual Earth – Part 3 (out of 4)
If you haven’t read Part 1 and Part 2, you should do so before continuing here. In Part 1 we saw how to add geographical information to your customer table and how to connect to the Virtual Earth geocode web service, and in part 2 we created a simple web site showing a map and adding pushpins. Now we want to add an action to the customer card, showing us the location of the customer and other customers in the...
-
Integration to Virtual Earth – Part 2 (out of 4)
If you haven’t read Part 1, you should do so before continuing here. In Part 1 we saw how to add geographical information to your customer table and how to connect to the Virtual Earth geocode web service. Now we want to put this information to play. First of all, we all know Virtual Earth (if not – try it at http://maps.live.com). Less commonly known is it, that the map control used in maps.live.com actually is available for public usage...
-
More SSD testing
If you haven’t read my post about Running Microsoft Dynamics NAV on SSD’s – you should do so first. After having posted the initial results, I was contacted by other vendors of SSD’s wanting to see whether we could do some additional testing on other hardware. In the interest of the end user, I accepted and once more allocated a slot in the performance lab in Copenhagen. The new drives to test were: STEC 3½” Zeus IOPS SSD 146GB STEC...
-
Microsoft Windows Vista Gadget – My “Stuff”
This is my second gadget. My first gadget was the Search gadget, which you can find here. I won’t repeat any explanation as to what a gadget is, nor will I talk about Javascript – instead I will focus upon the things, which are new in this post: Returning an XMLPort from Web Services to Javascript Running a Web Service method asynchronous Use the same gadget for invoking three different methods Poor mans error handling in Javascript What I want...
-
PageUp and PageDown in the Role Tailored Client
If you have been working with the Role Tailored Client you are probably aware, that it doesn’t support PageUp and PageDown in Task Pages. The reason for removing this support was, that the new User Experience is centered around starting from the List, and this way you have a better overview and can find the records you are searching for right away easier and then open the Task Page. This is all good, but users have told us, that they...
-
Search in NAV 2009 – Part 3 (out of 3)
If you haven’t read part 2 and part 1 of the Search in NAV 2009 posts, you should do so before continuing. This is the 3rd and final part of the Search in NAV 2009 post. In this section I will show how to create a Windows Vista Gadget and have this gadget connect to NAV through Web Services and search in NAV (like the System Tray version in part 2). We will create an installable Gadget like: and when...
-
Search in NAV 2009 – Part 2 (out of 3)
If you haven’t read part 1 of the Search in NAV 2009, you should do so before continuing. In this section we will create a small Winforms application, which uses the Web Service we just created in part 1. Our application will be visible as a System Tray Icon, it will have a global Windows Hotkey with which we can activate search and when you activate the Search application it will popup and look like this In part 3 we...
-
Search in NAV 2009 – Part 1 (out of 3)
During the partner keynote and during a couple of the other presentations, we showed a small application, which was able to search in NAV 2009 through multiple tables, display a result set and allow people to drill into task pages in NAV 2009 from the search result window. During the next 3 posts, I will explain how this demo is done and make it available for download. The sample comes with absolutely no warranty, but you can download it and...
-
Microsoft Dynamics NAV 2009 launched!
Wednesday this week we officially launched Microsoft Dynamics NAV 2009 at Convergence EMEA – what a relief. We have been working hard on this release for a long time and although you always know what you would have made better when you launch a product, I think that NAV 2009 is a great release and expect a lot of this product. Kirill Tatarinov opened Convergence EMEA with his Keynote on Wednesday and talked a lot about the current situation for...
-
NAV 2009 and Unicode!
The title might be a bit misleading, but I am writing this post as a response to a problem, which a partner ran into with NAV 2009 – and the problem is caused by Unicode. I am not a Unicode expert, so bare with me if I am naming some things wrong. As you know, NAV 2009 is a 3T architecture and the Service Tier is 95% managed code (only the lower pieces of the data stack is still unmanaged...
-
Edit In Excel – Part 4 (out of 4)
If you haven’t read part 3, part 2 (and part 1), you should do so before continuing here. We have seen how to put code inside Excel, using VSTO and connect to NAV 2009 Web Services. We have seen how to add this to a table inside Excel and how to write data back to NAV through Web Services. We can delete, add and modify records in Excel and we can even do so with both Customers, Vendors and Items....
-
Edit In Excel – Part 3 (out of 4)
If you haven’t read part 2 (and part 1), you should do so before continuing here. In Part 1 and 2, we have seen how easy it is to add a Web Service Reference inside Excel, and use it to get Data. In Part 2 we even had the ability to modify data and send this back to NAV. The original intend was that part 3 would be all about integrating this to NAV on the Client side and part...
-
Edit In Excel – Part 2 (out of 4)
If you haven’t read Part 1, you should do so before continuing here. In Part 1 we saw how easy it is to white .net code inside Excel, and get it executed based on an event in Excel, and how easy it is to fill values into cells. But in order to make this really useful we need to go a different way around. First of all, we need to know more about the record we are working with. We...
-
Edit In Excel – Part 1 (out of 4)
For the last 6-9 months, Microsoft have been showing a demo of how a user could create a filter on a list place and invoke an action called Edit In Excel. This would open Microsoft Excel with the same records, the user selected in the List Place and allow the user to edit values and post modifications back to Microsoft Dynamics NAV, showing how the user would get a runtime error if he was trying to violate validation logic from...
-
Transferring binary data to/from WebServices (and to/from COM (Automation) objects)
A number of people have asked for guidance on how to transfer data to/from COM and WebServices in NAV 2009. In the following I will go through how to get and set a picture on an item in NAV through a Web Service Connection. During this scenario we will run into a number of obstacles – and I will describe how to get around these. First of all – we want to create a Codeunit, which needs to be exposed...
-
Running Microsoft Dynamics NAV on SSD’s (Solid State Drives)
Solid State Drives are here. Laptops are sold with SSD’s (a bit expensive) and also the server market is seeing SSD’s coming out promising incredible performance from your storage. But what does this mean for NAV? I contacted FusionIO (www.fusionio.com), one of the major players in the high end SSD market and borrowed a drive for my server. The purpose of this was to test the performance of the drive in our NAV performance lab in Copenhagen. I also wanted...
-
4 BAT files for the Client Tier
If you haven’t done so, please read the post about Multiple Service Tiers before reading this:-) In my previous post (Multiple Service Tier) I promised to talk about what to do on the Client Tier if you have installed a number of services on a Service Tier computer that all are set to start manually. Do you really have to go to the Service Tier machine in order to start the services or is there a simpler way? As you...
-
The Service Tier
My first technical blog post is going to describe some details about the service tier, that some people might find interesting (and some people might think that this is common knowledge:-)) What is the Service Tier? Very briefly – the Service Tier is the middle tier in a Microsoft Dynamics NAV 2009 installation. This is where all database access is performed and all business logic is executed, meaning also that this is where the application is running. The Database Tier...
-
Multiple Service Tiers
NOTE – there is an updated post reg. Multiple Service Tiers in NAV 2009 SP1 here. If you haven’t done so, please read the post about the Service Tier before reading this:-) A very typical scenario with both partners and customers is to have more than one database. This can be because you have a development database and a production database – or it could be the partner having a copy of all customer databases locally for troubleshooting. You could...
