Metaphorically Speaking – Edition 64 – The Latest Version of Dynamics NAV – NAV 2013

In this edition we would like to let you know about the latest release of Dynamics NAV. Later in the year Microsoft will be releasing NAV 2013 which will include many new exciting changes.

Metaphorix will be rolling out a series of seminars that will offer you the chance to see the differences in NAV 2013 first hand. To read this edition of Metaphorically Speaking and to find out how to book yourself a place on one of these seminars, please click on the following link.

Dynamics NAV 2013


Metaphorically Speaking – Edition 63 – FREE Inventory Education Seminars

 In this edition we would like to let you know about the next ‘Back-to-Basics’ educational seminars we will be holding at our Coleshill offices, Inventory Costing and Inventory Planning

The Inventory Costing seminar will be held on Tuesday 19th June and the Inventory Planning seminar on Tuesday 17th July and they will run for 2 ½ hours, minimising the time taken from your busy day and allowing you to get back to your office later in the day, if required.

The seminars are open to all customers and are primarily aimed at Dynamics NAV users within your organisation.  We anticipate that these free education session will prove to be really popular and so we will need to restrict attendance to 2 people per customer.

To find out more about the seminars, please click on the following links.

Back to Basics Inventory Costing Agenda

Back to Basics Inventory Planning Agenda

As places are limited we would encourage you to register now by emailing or support

We look forward to seeing you.

Metaphorically Speaking – Edition 62 – Important Change to the Pricing for Microsoft Dynamics NAV User Licences and Granules

In this edition we want to let you know about an important and imminent change to the pricing for Microsoft Dynamics NAV user licences and granules. 

From 1 July, the cost of buying NAV will rise by around 20%.  Microsoft will publish prices in due course and we will provide these to you, but for now we would like to give you more about the ‘why’ rather than the ‘what’.

Essentially Microsoft has identified a major risk in its trading model – the fluctuation in exchange rates across the Euro-zone.  Most global software companies have one master price list in their home currency and reset price lists in other currencies every year or even every quarter using then-current exchange rates.

Microsoft has always taken a different approach, having set €, £ and other prices in 2001 they have continued to use the same exchange rate ever since.

From 1 July, Microsoft will reset Swiss Franc and Pounds Sterling prices to align with € prices, based on exchange rates at the time.  Microsoft will keep the prices aligned in the future by adjusting for subsequent exchange rate movements.

The immediate effect is that £ prices will rise by about 20%, Swiss Franc prices will fall by the same amount (subject of course to what happens in the currency markets between now and then).

In the short term what this means is that if you are planning to buy users then time is of the essence – after June you will pay a one-off higher fee for the licence and a perpetually higher fee for annual support.  For a balanced view of the changes and their effects please see the blog entry below – an article we feel fairly describes the position.

So, if you are thinking about buying users or granules in the near future, please contact your account manager so that we can give you a view of the likely price differential.  We can help you get the best value from your next Dynamics NAV purchase.

Metaphorically Speaking – Edition 61 – RTI Payroll Seminars

The providers of the Dynamics NAV Payroll solution miraclePAY, will be running a series of chargeable seminars on RTI (Real Time Information) during the next few months.

RTI is without doubt the biggest change to the PAYE scheme since its inception and it will affect every Company in the UK. This could prove very important to you as the Government changes the way payroll is processed in the next year.

Please click on the link below to find out more about the seminars and how to register.

 Miracle RTI Seminar

How to find the version of SQL Server you are running

You can go to the SQL Server manager and go help –> about

You can also run the SQL query below

SELECT @@VERSION ‘Version’, serverproperty(‘edition’) ‘Server Edition’ , SERVERPROPERTY(‘ProductLevel’) ‘ProductLevel’

which gives information like this


Microsoft SQL Server 2008 R2 (RTM) – 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)


Enterprise Edition (64-bit)



Whilst searching for a list of build numbers I found this excellent article from Microsoft which contains information about how to find version numbers of different products and lists some of the version numbers of the different releases

How to determine the version and edition of SQL Server and its components

if you want a comprehensive list of SQL Server number then the blog below is excellent

Introduction to OData in Microsoft Dynamics CRM 2011

Odata is a useful way to retrieve data in CRM and works very well when using javascript.

If you are wondering what oData is this article is a good introduction

OData Protocol by example

if you want to know how to connect to the CRM Odata service then this value easily at hand, you just need to know where to find it

Settings–> Customizations –> Developer Resources

When you click on here you will then get to see your discovery service, organisation service and oData Service.

The oData service should look something like this

http://<server name:port>/Metaphorix/XRMServices/2011/OrganizationData.svc

Now you have the oData url you are at the beginning of your quest.  The first thing you should do is download the oData query tool created by MVP Rhett Clinton

This article explains some of the filters you can add to oData queries

Using OData Retrieve in Microsoft Dynamics CRM 2011

This technet article is fantastic and has a lot of explanation and examples

OData System Query Options Using the REST Endpoint

another blog post, if you are still hungry for more information

CRM 2011 OData, JSON and CRM Forms

The great thing about oData is you can test the query in the internet browser, although when I did it in IE it didn’t show the full result but when I ran it in Chrome, after logging in it returned the XML data returned in the query.