Microsoft Dynamics NAV
||This article appears to be written like an advertisement. (August 2013)|
Microsoft Dynamics NAV 2013 Windows Client - Bookkeeper Role Center
(North American edition)
|Stable release||7.1 (2013 R2)|
|Operating system||Windows Server 2008/2012 (Application server), Windows 7 and later (Clients)|
|Platform||x64 (Application server), x86 (Client)|
|Type||Enterprise resource planning|
|Website||Microsoft Dynamics NAV|
The product is part of the Microsoft Dynamics family, and intended to assist with finance, manufacturing, customer relationship management, supply chains, analytics and electronic commerce for small and medium-sized enterprises. Value-added resellers (VAR)s can have full access to the business logic source code.
For modifications of the system, the proprietary programming language C/AL is used.
The company was founded in 1983 in Denmark as PC&C A/S (Personal Computing and Consulting).
In 1984 they released their first accounting package called PCPlus. It was for its time a very user-friendly single user package with all the basic accounting functionality. In 1987 the first version of Navision was released. This was also their first client/server based package allowing multiple users to access the system simultaneously.
Until 1990 the system was primary sold in Denmark, Iceland and Germany. But with the release of Navision version 3 (of the character-based system) a heavy international expansion was initiated and distributors and localized versions became available in many other countries.
In 1995 their first Microsoft Windows 95 based version was released.
In 2000, Navision Software A/S merged with fellow Danish firm Damgaard A/S (founded 1983) to form NavisionDamgard A/S. Later the name was changed to Navision A/S.
On July 11, 2002 Microsoft bought Navision A/S to go with its previous acquisition of Great Plains. The new division in Microsoft was named Microsoft Business Solutions and also included Microsoft CRM.
In 2003 Microsoft announced their plans to develop an entirely new ERP system (Project Green). But later it was decided to continue development of all ERP systems (Dynamics AX, Dynamics NAV, Dynamics GP and Dynamics SL). All four ERP systems were launched with the same new role based user interface, SQL based reporting and analysis, SharePoint based portal, Pocket PC based mobile clients and integration with Microsoft Office.
The product itself has gone through several name changes over the time. Initially Navigator was used in Denmark, although most Danes knew it as IBM-Navigator, as IBM was the distributor. Internationally it was sold as Navision, except for the US where it was called Avista. The names "Navision Financials", "Navision Solutions", "Navision Attain", "Microsoft Business Solutions - Navision Edition", and the current "Microsoft Dynamics NAV" (pronounced N-A-V, except in the U.S. where most customers simply say, "nav" which is short for Navision) have all been used to refer to this product.
Windows based Navision versions from 1.00 onwards were:
- Navision Financials 1.00: 1.00, 1.00A, 1.00B, 1.10, 1.10A, 1.20, 1.30
- Navision Financials 2.00: 2.00, 2.00A, 2.00B, 2.00C, 2.01, 2.01A, 2.01B
- Navision Financials 2.50: 2.50
- Navision Financials 2.60: 2.60, 2.60A, 2.60B, 2.60C, 2.60D, 2.60E
- Navision Solutions 3.00: 3.00
- Navision Attain 3.01: 3.01, 3.01A, 3.01B
- Navision Attain 3.10: 3.10, 3.10A, 3.10B
- Navision Attain 3.60: 3.60, 3.60A
- Microsoft Business Solutions Navision 3.70: 3.70, 3.70A, 3.70B
- Microsoft Business Solutions NAV 4.00: 4.00, 4.00 SP1, 4.00 SP2, 4.00 SP3
- Dynamics NAV 5.00: 5.00, 5.00 SP1
- Dynamics NAV 2009: ("6.00") 2009, 2009 SP1, 2009 R2
- Dynamics NAV 2013: ("7.00") 2013, ("7.1") 2013 R2
Before NAV 2013, Microsoft Dynamics NAV gave administrators the option of using either a native database server or Microsoft SQL Server, as the DBMS. SQL Server, the industry standard, is now the exclusive database option for NAV. Retiring the old "Native database" has given way to long awaited improvements in reducing/eliminating database locking, which can occur when hundreds or thousands of users are using the same data at once.
Document reporting in NAV 2013 is based on the RDLC 2008 format (RDLC 2010 in NAV 2013 R2). Reports are edited partly in the NAV Development Environment and Visual Studio. NAV 2013 R2 includes a free report editor. Any reports will render in either Screen preview, PDF, Word or Excel formats, depending on the users needs.
NAV 2013 also supports the OData format. With OData support in NAV 2013, Excel pivoting can now be done without knowledge to SQL specifics, with a 5.000 record limit, limited to only those fields available for RTC views.
Running NAV on SQL has made it possible to used MS Excel PowerPivot to access all data in NAV via SQL login. But with OData support in NAV 2013, Excel pivoting can now be done without knowledge to SQL specifics, thus giving 100% access to filter any data in NAV, with no restrictions. Previous default restriction of 5.000 records could be changed via editing a config file.
With NAV 2009, Microsoft introduced a completely new client interface named the RoleTailored Client (abbreviated RTC). The RTC allows tailoring the NAV experience by individual users, based on their job responsibilities. In one-person offices this can be a serious disadvantage as users must re-login, with a different user name/profile in order to access the varying RTCs they would want to use; in multi-person offices it can lead to confusion when attempting to help individuals who may have wildly different screen layouts and settings. RTC can only be set up by individual user, not company roles. Multiple setups per user is not supported, for example, an Excel export view versus an everyday working view. The interface remains cluttered, jumbled and disjointed, with fields commonly updated together separated into different tabs and screens.
The NAV client interface previously available in versions 5 and older was retained in NAV 2009, but renamed the Classic Client, making NAV 2009 the only "hybrid" version, offering both the Classic and the RTC interface.
While the Classic Client supports both Native and SQL databases, the RoleTailored Client requires a SQL database. Additionally, SQL database logins are not supported with the RoleTailored Client.
In October 2012, Microsoft released NAV 2013, which discontinued support for the Classic Client. The RoleTailored Client has been renamed the Windows Client. Additionally, a built-in Web Client and SharePoint Client were added. The Web Client does not require any special add-ins and works on computers and mobile devices alike. The report-building and database access that had been previously available with the Classic Client is still available and used as development tool to modify the system by customers and by a reseller (consultant).
Relative to Microsoft's other 3 ERP products, Dynamics NAV's sector is small distribution and manufacturing companies that want more than "out of the box" functionality. Very few installations are actually made "out of the box" as all sales of the product are through Microsoft-approved resellers who base their entire businesses on how many consulting hours they can apply to any given installation. The solution has a standard feature set, but it can also be thought of as an "ERP System construction set" if, at the end of the installation, you want to end up with every erector piece that was in the box still attached to your system. A better analogy would be to think of the NAV program as a 4'x8' sheet of pegboard, with 4,600 evenly spaced holes. It is used to cover various sized company boxes, ranging in size from shoebox, through pizza box, knockdown furniture box, up to double-doored refrigerator box. No matter the size box the underlying company is, the 4'x8' sheet of pegboard remains the same. It then becomes the reseller's job to link up whichever pegholes are needed to the specific company under the interface. They may not need all of the holes; some company boxes may need less than 1,000 links, but all of the holes remain visible to the end-user after the installation is complete. The Pascal-like development language is easily accessible to appropriate developers and is designed for rapidly customizing the software.
As of July 2013 Dynamics NAV is being used by 92,500 companies globally.
As a native international ERP, Microsoft Dynamics NAV is available with 43 official localizations and several unofficial ones (provided by local partners).
The NAV solution is also compliant with IAS/IFRS.
Microsoft Dynamics NAV delivers integrated functionality to provide support for:
- Financial management
- Supply chain management
- Customer relationship management
- Sales and marketing
- Service management
- Human resource management
- Project & Resource management
The Microsoft Dynamics NAV software is composed of three major components:
- The Database Server, a database that stores the Microsoft Dynamics NAV data (as of NAV 2013 only Microsoft SQL Server)
- The Application Server (starting from NAV 2009 RTC), a service that controls all aspects of Microsoft Dynamics NAV's operation
- The Client(s), the actual user interface into Microsoft Dynamics NAV. NAV 2013 includes three clients:
- Windows client
- SharePoint client
- Web client
Microsoft Dynamics NAV uses a concurrent user licensing model.
In 2006, Microsoft introduced the "Business Ready License" (BRL) model. The customer purchases user sessions, which have access to certain parts of the system included. There are two types of user - Business Essentials (BE) and Advanced Management (AM); AM provides access to more functionality than BE. Under the previous licensing model, "Module Based License" (MBL), users came with no functionality - this all had to be bought separately. Microsoft offers a path for customers to transition from MBL to BRL licensing.
With the arrival of NAV 2013, Microsoft introduced a new licensing model called "Perpetual Licensing", which considerably simplifies the pricing structure. With Perpetual Licensing, customers license the Solution functionality and access to that functionality is secured by licensing users. User licenses are of two types: Full User or a very discounted Limited User. The full user has access to the entire system, where as the Limited user only has read access to the system, except write access key tables such as Time sheets, Warehouse Pick and Commenting plus any three extra tables of choice. The Limited user is "concurrent" and trust based, so currently there are no check on the three table limit.
In addition to the base product, Add-ons are sold by ISV's Independent software vendor. Because the base program has to focus on generic versions of business cases, software products supplementing/modifying NAV functionality are required, sold and distributed as NAV Add-ons, to improve functionality of NAV system or make it applicable in some business spheres.
There are vertical and horizontal add-on solutions. Horizontal add-on solutions supplement one of the NAV functions or add new function (e.g. financial management, human resources management etc.). Vertical (or industry-specific oriented) add-ons expand NAV functionality to support some industry (e.g. health care, brewery, financial services etc.) The majority of add-on solutions are multilingual with most supporting English.
Utilities are another form of add-on for Microsoft Dynamics NAV that make the resellers' jobs simpler. Utilities are small software modules used by Microsoft Dynamics NAV programmers and database administrators, to make their jobs more convenient and effective. Also it makes program development and implementation processes faster and the cost lower for the resellers.
NAV CfMD (Certified for Microsoft Dynamics)
With NAV 2013, producing and maintaining Add-on solutions for NAV has becomes more expensive, since acquiring an exclusive NAV object number range is expensive, unless the solution gets certified. Solutions will have to be certified with every non-minor release of NAV, which happens once a year from NAV 2013 and onwards.
NAV CfMD is an exhausting quality check of the entire software solution. This helps ensures the quality of the NAV Add-on solutions.
The NAV community consists of professionals, typically employees of Dynamics Partners, End-users and MS MVP's (Microsoft Most Valuable Professional).
The two leading internet forums are:
- Dynamics User Group
- Mibuso.com (Acronym of "Micrsoft Business Solutions", the former name of the Dynamics family)
Microsoft Dynamics Convergence
Yearly events held by Microsoft in both Europe and in the US. The events are held a different countries every year and are available for all Dynamics partners.
A yearly event, held in Belgium. Where NAV partners can network, attend sessions by other partners/ISV's or by Microsoft.
- "Customizing Accounting Software". ASA Research. Retrieved March 13, 2013.
- "The history of Dynamics NAV/Navision". DynamicsUser.net. Retrieved March 13, 2013.
- "The history of Dynamics NAV/Navision in Timeline view". TipsdBits.com. Retrieved August 26, 2013.
- "Damgaard and Navision in large merger (Danish)". Computerworld.dk. Retrieved March 13, 2013.
- It’s Official: Microsoft buys Navision
- Microsoft buys Navision ERP for $1.2 billion
- "Microsoft Introduces Microsoft Dynamics Brand". Microsoft. Retrieved March 13, 2013.
- "What's New in Developing for Microsoft Dynamics NAV 2009". MSDN. Retrieved February 16, 2011.
- "Microsoft Dynamics ERP by the numbers". Microsoft. Retrieved March 13, 2013.
- "Product availability". Microsoft. Retrieved March 13, 2013.
- "Microsoft Dynamics NAV regulatory compliance". Microsoft. Retrieved April 29, 2013.
- "License Types". MSDN. Retrieved March 3, 2014.