21 November 2017
A customer recently approached me asking about putting their Dynamics NAV database into Azure but they were concerned about their connection speeds in their office (a contended broadband line).
Having looked at the available information from Microsoft the only information I could find was on blogs dating back to NAV 2009, which were quite generic. They did however make the useful point that if you’ve got high latency then it does have a major impact on the speed of the system (go figure).
15 June 2017
Microsoft Dynamics NAV has gone through a huge amount of development over the years, bringing new functionality, as well as meeting requirements for hot topics such as data security and cloud hosting, Internet of Things (IoT), etc.
However, it is still the same things that make people really want a new ERP solution. One of the first things that gets mentioned in any conversation with a prospect is “we have a lot of different systems and we want everything to be integrated on one system”. Here is why.
14 June 2017
The Microsoft Dynamics range of business software products are market leading, in terms of both functionality and popularity. Because of my position in the company, I tend to see most of the sales enquiries that come into the business and for the last few years I have seen confusion over which product people are after. Now that Microsoft are leading with their Microsoft Dynamics 365 brand, people are confused over the existing products as well as the new ones! To help out, I thought I would put together this little guide.
05 June 2017
Microsoft Dynamics NAV® maintains an accounting ledger for recording all financial transactions and a separate ledger to record the stock and movements of inventory items, together with their inventory value. This should of course reconcile to the corresponding general ledger accounts but how do you ensure that it does? This blog explains the process you use to do this. The blog assumes you have some knowledge of Microsoft Dynamics NAV. Please click on the images to enlarge them.
03 February 2017
Every accounts package is built around a Chart of Accounts which is used to record and analyse expenditure, income and balances. Microsoft Dynamics NAV® is no exception to this and as standard, it has a Chart of Accounts such as that in the picture.
This allows the accounts to be grouped and totals for individual accounts calculated (highlighted in red in the screenshot). There is also a distinction between Balance Sheet and Income Statement accounts (highlighted in yellow).
That’s OK as far as it goes, but accountants would want more analysis of their Chart of Accounts than that; for instance, identifying Liquid and Fixed Assets or Current and Long-term Liabilities. The individual account codes for these categories may not all be in one group but scattered around the Chart of Accounts so some other way of grouping individual accounts may be required.
Microsoft Dynamics NAV® 2017 has just such a mechanism, known as Account Categories and this article explores what this functionality does.
04 October 2016
With the ever growing world of social media, it is very often difficult for businesses to see the benefit as any more than a billboard for product announcements. Social listening allows you to take the data available on social media platforms and turn them into real business insights, not only to engage with customers, but also to gain trends in the market place. For example, if you knew that there was an increase in popularity of a product, your purchasers would be able to manage stock accordingly.
Microsoft provide this using Social CRM. Microsoft Social Engagement is a powerful CRM service that puts cutting edge tools in the hands of your sales, service and marketing teams. Connect on social media with customers, fans and critics to gain insight regarding how people really feel about your business.
One of the nice features of the later versions of Microsoft Dynamics® NAV is the ability to send any page in NAV to Microsoft Excel, not only as a list of data as you would get with a copy and paste, but a refreshable link using the refresh button on the Dynamics NAV tab in Excel. This demos really well, and prospective customers love it, however there are draw backs, the resulting table in Excel does not allow you to add columns to do your own calculations or to do lookups to other data in the workbook. You can do PivotTables / Charts on the data, and refer to it in other areas of the workbook, but what if you want to manipulate the table as a whole? Luckily there is a solution that allows you to add columns and still retain the refresh capabilities of the workbook.
Let me start off with my golden rule of data sent to excel from Dynamics NAV.
“Never modify the NAV Datasheet.” By NAV datasheet, I mean the sheet that NAV creates when you press the Sent to Microsoft Excel button.
Why is this? Partly because you are restricted from what you can do, but mostly because it saves complications if you let NAV / Excel do their thing!
28 June 2016
The Dynamics Communication Suite is a Certified for Microsoft Dynamics (CfMD) solution for Microsoft Dynamics NAV, Microsoft’s business management software for small and medium businesses. Designed with flexibility in mind, Dynamics NAV allows experienced developers to provide repeatable solutions to improve the user experience.
Our Communication Suite of Add-ons allows for improved automation with computer telephony integration, drag and drop of documents, automatic document filing and archiving and electronic document sending of NAV documents.
28 June 2016
Reports in the Role Tailored Client require the use of RDLC layouts. RDLC is pretty powerful anyway, but there are some features of RDLC reports that are barely used in standard NAV:
The document map allows you to see a summary of the content in the report. It also functions as a list of links, allowing you to navigate to specific sections of the report. This feature is useful for navigating large analysis reports.
23 May 2016
We are pleased to announce that all existing customers that meet the eligibility criteria (below) can take advantage of a special discount when adding 3 to 15 Full Users to their existing deployment of Microsoft Dynamics NAV. existing customers may receive an additional discount of 15% when purchasing an additional 3 to 15 Full User licenses in the same transaction. The offer is only running until June 25th so get your orders in now!
13 May 2016
There are a few organisational things which you can do in Microsoft Dynamics NAV 2016 (and earlier versions) to make your work easier and make your role centre more practical to how you work and these screen re-organisations are all achieved at user level.
These changes include the display of information on your own unique role centre, e.g. you can change how the different panes are displayed on your screen. By clicking on the lines alongside each pane until the double ended arrow is displayed and then dragging the line, it is possible to vary the size of each pane, either making them smaller or larger to suit.
11 May 2016
Firstly, my apologies to any Star Wars fans for the title of this article, being effectively the 4th version (version history), and given the trials that could be had with the previous version, the force really needed to be with you or you would find yourself turning to the dark side (paying for your connector).
For those of you who did not experience the previous connector, or are adept at blocking out nightmares, you may want to refresh yourself by reading one of my previous articles – ‘The Connector for Microsoft Dynamics’, paying particular attention to the second to last paragraph.
10 May 2016
Many of you will be thinking about the upgrade to the latest version of Microsoft’s number one selling ERP solution. With NAV 2016 there are even more features as Microsoft spends millions of dollars on Research & Development to constantly add new features and functionality. But what about those add-on or add-in products that you have already bought to give you specific functionality? The simple answer is that it depends on the provider of the solution as to whether they keep them up to date.
08 April 2016
"Thousands of new small businesses start each year. Many fail, but just as many succeed. Tom Jenkins, director of Dynamics Consultants, who specialises in the implementation of business software solutions, looks at one potential factor that could make all the difference”
Our director Tom Jenkins was featured this week in the Business Magazine, where they discussed the importance of growing businesses to act early when deciding to move to a business management software solution. With a flexible solution, such as Dynamics NAV, the reduction in man power required means that your ERP system can work as part of your team.
Read more in the Business Magazine on pages 14 and 15.
31 March 2016
We have created a new feature in Microsoft Dynamics NAV improves the way that comments are added. The comments tool in NAV allows people to write notes against a record, but each comment field is limited to 80 characters, which can be frustrating when trying to add a large section of notes, either by typing or using copy and paste. This means that people often revert to using the notes fact box, however this does not allow for different types; the Comments functionality includes separate Internal Messages, Resolution Messages, Fault Messages and General Messages. Reporting against Notes is also less easy to report against than comments.
The Comments Add-in works by providing an unlimited text field that allows you to copy and paste or manually type the notes that you require. On submitting the notes the Add-in automatically populates the lines split into the 80 character segments. The add in logs the date, time and username onto the message, allowing users to clearly see who wrote the message and at what time.
We are proud to announce that Andrea Ely, Partner Technology Strategist from Microsoft, will be attending our Business Software Showcase on the 20th November! As the guest speaker, Andrea will be opening the Showcase with a speech about IoT (Internet of Things) and MSFT Social Engagement. Register here now to join us!
06 October 2015
Please note that this offer is now expired! There is however a later offer here.
It's that time of year where deals are in the shops and you need to prepare yourself for Christmas. If, like me, you are finding it all a bit too much, at least you have something to smile about!
Get the Starter Pack licence which includes 3 users, plus a further two users for only
Microsoft Dynamics NAV Promotion: Get 3 More 4 Less!
Get 15% off Full User Licenses when you purchase 3 or more!
Have you seen an increase of growth and productivity within your business? Are you thinking of taking on more staff to cope with the uplift? Then this promotion is perfect for you!
To support the expansion of our existing Dynamics NAV customers, Microsoft have launched a special offer "Get 3 More 4 Less".
From now until the 24th June, when you purchase 3 or more Dynamics NAV Full User Licenses you can get 15% off the Microsoft list price!
For those using the Business Ready License - Business Essentials, you will save £693.00 when you purchase 3 Full User Licenses and for each additional license you buy (to a maximum of 15), you get an extra £231.00 off!
For those using the Business Ready License - Advanced Management, you will save £940.50 when you purchase 3 Full User Licenses and for each
Microsoft have launched their compelling Dynamics NAV "Give Me 5 Starter" offer, this time 5 Users for £3,551!
This equates to a saving of £2,958 off the standard Dynamics NAV list price. Whether you need a business management solution for financial, service management, supply chain, project or customer relationship management, this special offer drastically reduces your ERP start-up costs, in turn decreasing the time to gain a return on your investment. New customers can license the Dynamics NAV Starter Pack, which includes the first three (3) Full Client Access Licenses (CALs), plus two (2) additional Full User CALs for only £3,551.
If you feel that you need more than the rich financial and supply chain management functionality of the Dynamics NAV Starter Pack, then perhaps you would prefer to purchase the deep functionality of the Dynamics NAV Extended Pack with the Dynamics NAV "Give Me 5 + 2 Extended" offer.
This special offer is
If you feel that you need more than the rich financial and supply chain management functionality of the Dynamics NAV Starter Pack, then perhaps you would prefer to purchase the deep functionality of the Dynamics NAV Extended Pack with the Dynamics NAV "Give Me 5 +2 Extended" offer.
This amazing offer equates to a saving of £5,916 off the standard Dynamics NAV list price and drastically reduces your ERP start-up costs, in turn decreasing the time to gain a return on your investment. New customers can license the Dynamics NAV Starter Pack, which includes the first three (3) Full Client Access Licenses (CALs), the Dynamics NAV Extended Pack and four (4) additional Full User CALs for only £10,061.
This special offer is available for new customers from now until 24th June 2015.
Eligibility and offer