Tuesday, December 19, 2017

Error importing NAV License in AzureSQL Database

Hello Friends,

When you try to open Azure SQL Database on NAV Developed Environment and RTC Client.
It will be give multiple error. Following are solution for it.










When opening a database installed in AzureSQL, you may get this error:
The database on the server requires a Per Database license to be opened on SQL Azure
You must use Powershell to import the Dynamics NAV license. To import a license file to a AzureSQL database I used the following command:
Import-NAVServerLicense DynamicsNAV100 -LicenseData ([Byte[]]$(Get-Content -Path “C:\Licenses\NAV_2017_DEV.flf” -Encoding Byte))
But I was having the following error:
Reference to database and/or server name in ‘master.dbo.$ndo$srvproperty’ is not supported in this version of SQL Server
To resolve it, I needed to add an additional parameter to the command: “-Database 2”.
Import-NAVServerLicense DynamicsNAV100 -LicenseData ([Byte[]]$(Get-Content -Path “C:\Licenses\NAV_2017_DEV.flf” -Encoding Byte)) -Database 2

From Microsoft Dynamics NAV 2016 documentation:

-Database<LicenseDatabase>

Specifies the database into which to import the license file. The possible values are described in the following list:
Default = 0
Default; overrides the license file currently in use.
Master = 1
Forces the license file to be global.
NavDatabase = 2
Forces the license file to be local and stored in the Microsoft Dynamics NAV database that is used by the specified Microsoft Dynamics NAV Server instance.
Tenant = 3
Forces the license file to be local and stored in the Microsoft Dynamics NAV database that is used by the tenant that is specified in the Tenant parameter.

====================================================
Tips to run NAV Admin Shell & Developer Shell to  Power Shell ISE

Run the Import Module Command to load function.

NAV 2016
--------
For Development Shell -->

Import-Module 'C:\Program Files (x86)\Microsoft Dynamics NAV\90\RoleTailored Client\NavModelTools.ps1'

For Administratertion shell -->

Import-Module 'C:\Program Files\Microsoft Dynamics NAV\90\Service\NavAdminTool.ps1'


Sunday, December 3, 2017

Enable AL Language Extension on NAV 2018 and Install in VS Code

Hello Friends,

This blog will help to enable Modern Development Environment with Dynamics NAV 2018.

Go into the Dynamics NAV 2018 Administration, select the Development fast tab, check Enable Developer Service Endpoint. 


























Now port 17049 is open, and you have access to use Visual Studio Code.


You should also specify the target of your extensions:

Allow Extension Target Level should be Internal.

To get Visual Studio Code up and running, you need the VS extension; it can be found here in the install image:

\ModernDev\program files\Microsoft Dynamics NAV\110\Modern Development Environment\ALLanguage.vsix











In Visual Studio Code, use Install from VSIX from the extension … menu:






















Install it, and you should get this:













Version 0.12.15355 is the version delivered with NAV2018.

Now you successfully install AL Language extension in VS Code.

Old Archive Version Download Link for all Country Database (Require for Upgrade)

Hello Friends,

Now a Days as most of the work that partners have is upgrade.

It would not be wrong to say that even Microsoft have discontinued Support for Microsoft Dynamics NAV 2009 and Previous version, we still have so many customers who are actually using them.

There are some customer still using version 3.7 or 2.0 but majority of customers are either on 4, 5 and 2009.

Now when we as Microsoft Dynamics Partners plan to upgrade a customer to NAV 2013 / NAV 2013 R2 / NAV 2015 and NAV 2016, first thing that we look for is the Microsoft Database (objects) of the base Version which is currently the Customer Version.


Where we can find the databases for these Old Versions of Microsoft Dynamics NAV? 



To put above statement in simple words -

"To Identify Customization that need to be brought forward to Latest Release, we require the Old Base of Microsoft."

We then compare Microsoft Base Release with Customer Objects to identify the customization, and then we begin to bring it forward as-is or we re-engineer the customization. (Merge Process)

It is always a challenge to get access of Old Microsoft Dynamics NAV Product DVD From Microsoft Partner source. I was also looking for one such old Database backup for an upgrade Project.

Microsoft Have Release a Page which have All Database Backups and Some Upgrade Toolkit Backup for discontinued version.

You can access page using Partner Source Login. Click Here to Open Page.

The Page Contain Database Backup for 45 Navision Releases, you can also use below table to open the localized page directly.

List of Available Countries In Above Link

This should help you when you plan to upgrade a existing Customer on Old Version.

Thank you for reading.
I hope this will help someone.

Saturday, December 2, 2017

Upgrade to NAV 2018

Hello Friends,

As Microsoft Dynamics NAV 2018 released,
I am getting questions how many steps do we need to upgrade (Data migration & Object Merge) to NAV 2018.













This article just lists down No. of steps required to upgrade From Current Version 3.7 onward.

Below is the list of No. of Steps required if you plan to Upgrade to Microsoft Dynamics NAV 2018.


From Version
To Version
No. of Steps
NAV 3.7
NAV 2018
3
NAV 4.3
NAV 2018
3
NAV 5.0 / 5.1
NAV 2018
2
NAV 6.0 / 6.1 / 6.2
NAV 2018
2
NAV 2013 / 2013 R2 / 2015 / 2016 / 2017
NAV 2018
1

Wondering why these steps, below are the details of the no. of steps -

From Version
To Version
Step
NAV 3.7 /4.3
NAV 6.0 / 6.1 / 6.2
1
NAV 5.0 / 5.1
NAV 6.0 / 6.1 / 6.2 (No Upgrade Step)
0
NAV 6.0 / 6.1 / 6.2
NAV 2013 / 2013 R2 / 2015 / 2016 / 2017
2
NAV 2013 / 2013 R2 / 2015 / 2016 / 2017
NAV 2018
3

** If you are coming from 3.7 / 4.3 there may be so many functionalities that are either discontinued or re-engineered. So be ready for changes in system processes.

Following are the Upgrade Toolkit object provided in setup NAV 2018















Hope you find the post useful. Let me know the feedback.

Stay tuned for more.

What’s New in Microsoft Dynamics NAV 2018?

Hello Friends,

The 1st of December is the launch day of Microsoft Dynamics NAV 2018. There were lots of rumors about new Dynamics NAV version, as we remember, but finally, the new Dynamics NAV 2018 is here and let‘s shortly review it and get some insights from Simplanova team about NAV 2018.






















You can find more information and download Dynamics NAV 2018 here.

Dynamics NAV 2018 is deeper integrated with Microsoft’s Products

In Microsoft Dynamics NAV 2018 we will see deeper integration of Dynamics NAV and Microsoft products by connecting them with each other in the same business environment, such as Dynamics 365 applications, PowerApps, Flow, Office 365, Power BI and third-party applications. From the vision of Microsoft, we can see that the goal of integration is to offer full software package to a small and mid-size business.

Updated integration with Dynamics 365 for Sales
Connect to your Dynamics 365 for Sales solution in a few easy steps. The assisted setup helps you synchronize your data across the two apps, including sales orders, item availability, units of measure, and currencies. The existing integration with the app formerly known as Dynamics CRM has been rebranded and simplified to work better out of the box.









Extensibility with Extensions

Dynamics NAV 2018 has a new, modern, state-of-the-art extensibility model which will enable to extend and customise clients’ current Dynamics NAV solution to further fulfill their business needs.
The Setup and Extensions button provides a single place for settings. This new set of options has been added for the Business Manager and Accountant Role Centers. From the list of actions, you can open setup pages, either assisted or manual, and you can open setup pages for service connections and extensions. Third-party extension providers can add their actions to the list.
In the Manual Setup action group, each action refers to an area, such as General, Finance, and System. The row for each setup page has keywords allowing you to both search across setup pages and to filter the list to only see setup pages within a given area.













Advanced algorithms amalgamate AI

Totally new features in Dynamics NAV 2018 include Microsoft’s Cognitive services. These services use advanced algorithms which allow users to amalgamate artificial intelligence into the applications. Automatic facial, speech and language recognition can be employed in HR contexts and automate procedures. Product recognition places items in the correct categories by providing much more automatization in product management.
The Image Analyzer extension uses powerful image analytics provided by the Computer Vision API for Microsoft Cognitive Services to detect attributes in the images that you add to items and contact persons, so you can easily review and assign them.
  • Contact persons Recognize a person’s gender, or age.
  • Items Identify attributes like type and color. For example, whether it’s a table or a car, or red or blue. Image Analyzer suggests attributes based tags that the Computer Vision API finds with a confidence level.















“Extensions will bring a whole new level to Dynamics NAV solution, this is one of the long waited functionality by both customers and partners. While we believe that it is currently still very limited, it holds a bright future for further developments in NAV. Having this in mind, we see NAV 2018 as a bigger leap and thus worthwhile upgrading now comparing to the NAV 2017 solution, so we expect to see more customers converting after December 1st. – My View

Let‘s review technical enhancements and features of Microsoft Dynamics NAV 2018

1.Quickbooks File Import
You can now import payroll transaction files in the QuickBooks IIF format by installing the QuickBooks Payroll File Import extension. Aggregated payroll data, including date, payroll account, description, and amount, will be imported to your G/L accounts according to mappings that you perform once per payroll account. The extension also contains a sample payroll file that you can use to try out the functionality, for example, in a demo company.
2. Integration API
To empower developers and service providers to easily integrate with Microsoft Dynamics NAV, Microsoft is adding a REST API based on web services with easy-to-use authentication.
The entities in the API can be used on their own or in combination with extensions when there is a need to add user interface elements or business logic Dynamics NAV. The first iteration of the API publishes common record types, including company information, customer, vendor, employee, item (product), sales order, sales invoice, account, and journal.
3. Synchronize Vendors with Lexmark ICS
Take advantage of vendor synchronization when using Lexmark ICS. This will improve the vendor recognition rate in the Lexmark ICS and allow manual selection of vendors when performing visual training of new invoice layouts.
Vendor information including number, name, address, VAT registration, phone, and bank account data is transferred to Lexmark ICS when synchronizing.












Out of the box, synchronization is not enabled. It must be enabled in the OCR Service Setup window as shown in the following picture:














4. Personalize your workspace
Personalize your workspace directly in the browser! Personalization is now enabled by default for all. To get started, find the Personalize menu item under your sign-in avatar in the upper right corner. As you make changes, they are immediately saved and only seen by you, even if you sign into the browser or app from another device.
Added the top requested features, including:
  • Move, hide, or show a field on the page.
  • Move, hide, or show a column on the page.
  • Freeze columns to keep them visible while you scroll, just like in Microsoft Excel!
  • Move or hide Cues.
  • Move or hide parts, such as Factboxes or Role Center parts.
  • Clear personalization from a page and start fresh.
  • For IT administrators, we’ve also added the ability to deny personalization to groups of users from the Profile page, or clear personalization from all pages or a specific page for a user.
5. Preview and Print Reports
Until now, previewing a report in the Dynamics NAV Web client was only possible in Internet Explorer, but is now possible on all supported browsers.
You can preview a report directly in the client by choosing the Preview button on report request pages. This displays the report by using the new PDF Viewer control, which enables you to use your keyboard and mouse to navigate the report and download it to your computer.
The report preview in the Web client has been refurbished with a new design and additional features. It works with all supported browsers. You preview a report by choosing Preview on the report options page. A toolbar provides several features for working with the report, such as zooming in and out, downloading to file, and more.







Two new features include selecting text and panning:
  • Select text – This feature lets you select one or more words, paragraphs, or rows in the report, and then copy and paste it somewhere else, like a page in Financials or a Microsoft Word document.
  • Pan the document –  This feature lets you move the visible area of the report in any direction, so you can view other areas. This is helpful when you have zoomed in to see details.
6. Preconfigured Excel reports
The Business Manager and Accountant Role Centers have a new option in the ribbon for Excel Templates. From the Excel Templates list, users can choose a preconfigured report that is ready to print from Excel.














7. User Tasks
The new User Tasks allow you to create tasks to remind you of work to be done. You can create tasks for yourself and assign tasks to others or be assigned a task by someone else in your organization.














If you want to bulk delete all or some user tasks, you can use the Delete User Tasks report. In the request page, you can set filters to determine which tasks must be deleted.
8. Employee ledger entries
In general journal lines, there is a new account type and new balancing account type, Employee. Posting a general journal line with Employee as account type or balancing account type will generate an employee ledger entry. When posting a general journal line for an employee, the Document type field must be either blank or set to Payment.











ou can also post payments against employees from payment journals. On payment journal lines, there is a new account type, Employee. You can use this account type to post a payment to an employee. You can apply payments to an employee ledger entry either via the Applies-to Doc. No. field on the payment journal line or by choosing the Apply Entries action on the employee ledger entry. You can un-apply payments from employee ledger entries. Do this by choosing the action Un-apply Entries on the employee ledger entry.
9. Submission of EC Sales List with more than 9999 lines
You can now submit EC Sales List Report with more than 9999 lines. All you need is to set a threshold on a number of lines in VAT Report Configuration for EC Sales List report in Maximum number of lines field to 9999 and we’ve got you covered. When you submit such large EC Sales List report a number of messages will be generated and sent them to Government Gateway. You can see results of submission in Log Entries.

What‘s the most important for Developers?

With every new Dynamics NAV version, NAV Developers have to learn new things and adapt to new rules. With Dynamics NAV 2018 developers should:
  • Start using/learning Visual Studio code as Dynamics NAV development will migrate to it from old C/SIDE.
  • Start using events & subscription & Events.

Nilesh Gajjar - experienced and certified Dynamics NAV project manager at Intech-Systems shares his thoughts about the changes, which will be relevant for developers after the release of Dynamics NAV 2018: “Extensions 2.0 should be part of  Dynamics NAV 2018 release (at least I expect so). It means that there will be no more development sandboxes dedicated only to extensions. Finally, we will be able to start doing AL development in real development environments. Together with Extensions Dynamics NAV Developers will be forced to use Events for code customizations, that will be quite challenging for some NAV Developers as the approach to development will have to change. Meanwhile, Intech’s developers are looking forward to this challenge, as there will be plenty of space to innovate.”

By analyzing all the given material from Microsoft and their presentation during key conferences, the future of Dynamics NAV is the cloud, VS Code, customization with events & web client. Now it‘s time to touch in reality the Dynamics NAV 2018 and share with You our insights in upcoming blog posts.