How to get Microsoft Dynamics NAV for tablets to connect using a self-signed certificate

Overview

This blog post helps you connect Microsoft Dynamics NAV for tablets using a self-signed certificate. The targets for the blog post are the following apps:

  • Dynamics NAV for iPad
  • Dynamics NAV for Android
  • Dynamics NAV for modern Windows

The Internet Information Services Manager (IIS) needs a trusted certificate that holds the private key for https. iOS and Android need the https certificate to be trusted by a root certificate.

In this blog post, you will be creating one certificate that is used for both the IIS to enable https and to install on your device. Follow the steps below and replace the following string:<your site name> with the name of the site. You can either use a real name likewww.abc.com, or use your pc name. It must match the first part of the URL that you have specified. Currently the PowerShell script New-SelfSignedCertificateEx supports Windows 8 and Windows Server 2012 and newer.

Steps

For the Microsoft Dynamics NAV Web server, do the following:

  1. Create the certificate:
    1. Open a PowerShell prompt with the option As administrator.
    2. Go to the directory where you saved the New-SelfSignedCertificateEx.ps1 file.
    3. Run the following command: Import-Module .\New-SelfSignedCertificateEx.ps1.
    4. Then run the following command: New-SelfSignedCertificateEx –Subject “CN=<your site name>” –IsCA $true –Exportable –StoreLocation LocalMachine –StoreName My.
    5. Manage the certificate:
      1. Open the mmc.exe.
      2. Go to the File menu, and then choose Add/Remove Snap-in...
      3. Select Certificates.
      4. Choose Add.
      5. Select the computer account.
      6. Choose Finish and then OK.
      7. Locate and copy the certificate you just created in the personal/certificates folder.
      8. Paste the certificate into the Trusted Root Certification Authorities/Certificates folder.
      9. Select the certificate, right-click and export the certificate.
      10. Select the No, do not export the private key option.
      11. Choose Next.
      12. Select DER encoded binary x.509 (.cer).
      13. Specify a location and filename and finish the wizard.
      14. Enable https: In IIS Manager, create a binding for https using the certificate you added.

Next

For iOS, do the following:

  1. Use the iPhone Configuration Utility tool from Applehttp://support.apple.com/downloads/#iphone or mail the certificate you exported.
  2. Run the certificate file and install the certificate.
  3. You are now ready to start the Dynamics NAV app.

For Windows, do the following:

  1. If you run the client on the same box as the web server, then you are all set to go.
  2. Copy the certificate you exported to the tablet, install the certificate and place the certificate in the Trusted root certification authorities folder of the local machine.

For Android, do the following:

  1. Copy or mail the certificate that you exported.
  2. Run the certificate file and install the certificate.
  3. You are now ready to start the Dynamics NAV app.

This should help you get up and running using self-signed certificates. Be aware that Microsoft Dynamics NAV for tablets does not support Always Ask certificates.

Advertisements

Upgrade Toolkit for Upgrading Data from Microsoft Dynamics NAV 2009 R2 and Microsoft Dynamics NAV 2009 SP1 to Microsoft Dynamics NAV 2013 R2

The components needed to upgrade data directly from Microsoft Dynamics NAV 2009 R2 to Microsoft Dynamics NAV 2013 R2 are now available for download.

 

Download the upgrade toolkit from PartnerSource or from CustomerSource.

In order to use the toolkit to upgrade data from Microsoft Dynamics 2009 R2 or Microsoft Dynamics NAV 2009 SP1, you will also need the Microsoft Dynamics NAV 2013 development environment and Microsoft Dynamics NAV 2013 R2.

 

In Microsoft Dynamics NAV 2013 R2, we introduced support for converting a Microsoft Dynamics NAV 2013 database so that you can run an application that was created in Microsoft Dynamics NAV 2013 on the Microsoft Dynamics NAV 2013 R2 platform, also known as a technical upgrade.

 

Note: We strongly recommend that you upgrade the application objects as well so that your solution includes the important application fixes and new functionality that is introduced in Microsoft Dynamics NAV 2013 R2.

 

Secondly, you can fully automate the data upgrade process using the Windows PowerShell scripts that we included in the Microsoft Dynamics NAV 2013 R2 product media. Historically, this process has been known for its tediousness and high risk of human error when multiple operations had to be executed consecutively in all companies of the database that you were upgrading. The scripts automate this work so that you can test and execute your data upgrades more reliably.

 

Now with this delivery, we introduce an upgrade toolkit for upgrading the data from Microsoft Dynamics NAV 2009 R2 to Microsoft Dynamics NAV 2013 R2. This significantly simplifies the upgrade process for those of you coming from Microsoft Dynamics NAV 2009 R2 – or Microsoft Dynamics NAV 2009 SP1.

 

Included in the new upgrade toolkit are all known data upgrade-related application hotfixes that we are aware of, and we also addressed several platform issues that affected the upgrade scenario.

 

Note: You must download the latest Microsoft Dynamics NAV platform hotfixes before you start using the upgrade toolkit. The required hotfixes for Microsoft Dynamics NAV 2013 are available in the latest hotfix rollup, which you can download from PartnerSource or CustomerSource. For Microsoft Dynamics NAV 2013 R2, you can download the required hotfixes from PartnerSource or CustomerSource.

 

When you download the new upgrade toolkit from the link above, you can use it to simply your upgrade process. Here are the main steps in upgrading from Microsoft Dynamics NAV 2009 R2 (or Microsoft Dynamics NAV 2009 SP1) by using the new upgrade toolkit

 

To upgrade data from a Microsoft Dynamics NAV 2009 R2 or Microsoft Dynamics NAV 2009 SP1 database

In the Microsoft Dynamics NAV 2009 R2 or Microsoft Dynamics NAV 2009 SP1 development environment (Classic client):

Create a copy or a backup of your old Microsoft Dynamics NAV 2009 R2 database, and open it in the Microsoft Dynamics NAV 2009 R2 development environment.

Add your partner license to the database.

You can do this by selecting the Save License in Database field in the Alter Database window. If the field was not already selected, a dialog box opens so you can specify the location of your partner license.

If the field was already selected, upload the partner license from the License Information window.

Open the Object Designer, and then import Upgrade601701.1.fob. If the .fob file contains objects with conflicting versions that are already in the database, the Import Worksheet window opens. Choose Replace All.

For each company in the database, open the company, and make the relevant changes to data and objects. For more information, see Task 3: Data/Object Changes Prior to Step 1 in the MSDN Library.

Then, from the Object Designer, run form 104001, Upgrade – Old Version. Choose the Transfer Data button.

Repeat step 1 for each company in the database. Then, from the Object Designer, run form 104001, Upgrade – Old Version. Choose the Delete Objects button.

This action deletes all objects in the database that are not tables, but also obsolete tables that belong to functionality that is not available in Microsoft Dynamics NAV 2013 R2.

Uninstall Microsoft Dynamics NAV 2009 R2, and then install Microsoft Dynamics NAV 2013.

Change the compatibility level of your database. For SQL Server 2008 and SQL Server 2008 R2, verify that the compatibility level of the database is set to 100. For SQL Server 2012, set the compatibility level to 110.

In the Microsoft Dynamics NAV 2013 development environment, open the Microsoft Dynamics NAV 2009 R2 database and agree to convert the database. The database has now been technically upgraded to Microsoft Dynamics NAV 2013.

Uninstall Microsoft Dynamics NAV 2013, and then install Microsoft Dynamics NAV 2013 R2.

In the Microsoft Dynamics NAV 2013 R2 development environment:

Open the Microsoft Dynamics NAV 2013 database and agree to convert the database.

Compile the system tables. You can find the tables by setting a filter for table ID 2000000004..2000000130.

In the following step, you will be connecting a Microsoft Dynamics NAV Server instance to the database.

Make sure that the service account that the Microsoft Dynamics NAV Server instance uses has the db_owner role for the database. Connect the Microsoft Dynamics NAV Server instance to the database, and then start the service instance.

In the Microsoft Dynamics NAV 2013 R2 development environment:

On the Tools menu, open Options, and then, make sure that the Prevent data loss from table changes field is set to Yes.You must also make sure that the Server Name, Server Instance, and Server Port fields are filled in.

This ensures that the Microsoft Dynamics NAV Server instance that is connected to the database will verify that no operation will cause loss of data in the development environment.

Import all customized objects in .fob format into the upgraded database. If the .fob file contains objects with conflicting versions that are already in the database, the Import Worksheet window opens. Choose Replace All.

Make sure all objects are compiled.

Import Upgrade Step 2 objects from the Upgrade601701.2.fob file.If the .fob file contains objects with conflicting versions that are already in the database, the Import Worksheet window opens. Choose Replace All.

Open the Microsoft Dynamics NAV 2013 R2 Windows client, and make sure that you are connected to the Microsoft Dynamics NAV Server instance that is connected to the upgraded database.

Next, you will run Upgrade Step 2 in each company in the upgraded database. You can get a list of all existing companies in the database by running the Get-NAVCompany cmdlet and passing as an argument the Microsoft Dynamics NAV Server instance which is connected to the upgraded database.

You will run objects directly from the development environment, so you must specify the company that the objects must run in in the Options window.

In the Microsoft Dynamics NAV 2013 R2 development environment:

On the Tools menu, open Options, and then, in the Company field, specify the name of the first company.

In the Object Designer, find page 104002 Upgrade – New Version, and then choose Run.

In the Upgrade – New Version window, choose Test Database Connection to make sure that the C/AL code that is triggered by the actions on the page has access to the database.

If your database is on a named SQL Server instance, you must specify the name in the SQL Server Name field.

Choose Transfer Data.

If the process is successful, and you don’t have to revisit the upgrade logs, you can clean the content of the Upgrade Time Log table.

On the Navigate tab, choose Time Log, and then, in the Upgrade Time Log page, delete all records.

Close the Upgrade – New Version window, and then close the Microsoft Dynamics NAV Windows client.

Repeat step 10 for each remaining company in the database.

When you have successfully transferred data in the last company, you must upgrade data that is common to all companies in the database, such as permissions, permission sets, web services, profiles and control add-ins.

Import and run Upgrade601701.2.fob for all companies in the database.

Upgrade data common to all companies such as permissions, permission sets, web services, profiles and control add-ins.

If the customer has changed the Read/Write/Modify/Delete/Execute settings for any of the standard permissions, or customized default permission sets in any way, you must merge these changes into the default permissions sets and permissions that are included in Microsoft Dynamics NAV 2013 R2. You can use XMLport 104001 Import/Export Roles and XMLport 104002 Import/Export Permissions to export the new default roles and permissions from the CRONUS International Ltd. demonstration database in Microsoft Dynamics NAV 2013 R2. You can add control add-ins in the Control Add-ins window in the Microsoft Dynamics NAV Windows client. For more information, see How to: Register a Windows Client Control Add-in.

Delete the upgrade toolkit objects.

In the Upgrade – New Version window, choose Mark/Delete Upgrade Toolkit.

This deletes all upgrade toolkit objects, except tables

In the Microsoft Dynamics NAV development environment, delete the upgrade tables by setting a field filter for objects where the Version List contains Upgrade Toolkit Table – marked for deletion..

The database has now been through a data upgrade to Microsoft Dynamics NAV 2013 R2.

Now, all Microsoft Dynamics NAV partners should be available to download NAV 2015 license from Voice.

Now, all Microsoft Dynamics NAV partners should be available to download NAV 2015 license from Voice.

As earlier, you can choose standard Dev/Demo license or Dev/Demo license with 180 day trial period and select modules you want.

Go to https://businesscenter.mbs.microsoft.com/ to download it.

Thnks for Sharing   http://totovic.com/2014/10/05/nav-2015-license-for-partners/

Upgrade Toolkit for Upgrading Data from Microsoft Dynamics NAV 2009 R2 and Microsoft Dynamics NAV 2009 SP1 to Microsoft Dynamics NAV 2013 R2

The components needed to upgrade data directly from Microsoft Dynamics NAV 2009 R2 to Microsoft Dynamics NAV 2013 R2 are now available for download.

Download the upgrade toolkit from PartnerSource or from CustomerSource

In order to use the toolkit to upgrade data from Microsoft Dynamics 2009 R2 or Microsoft Dynamics NAV 2009 SP1, you will also need the Microsoft Dynamics NAV 2013 development environment and Microsoft Dynamics NAV 2013 R2.

At the Directions EMEA conference in Vienna and the Directions US conference in Nashville, we said that we have a team that is focusing on the Microsoft Dynamics NAV upgrade story. Going through the big transformation from the classic stack to the new product architecture in Microsoft Dynamics NAV 2009 was not easy and is challenging many customers and partners. So for our team, it is essential that the final outcome of our work is that each upgrade is easier, requires significantly less effort, and that it does not disrupt the daily business for our customers.

In Microsoft Dynamics NAV 2013 R2, we introduced support for converting a Microsoft Dynamics NAV 2013 database so that you can run an application that was created in Microsoft Dynamics NAV 2013 on the Microsoft Dynamics NAV 2013 R2 platform, also known as a technical upgrade.

Note: We strongly recommend that you upgrade the application objects as well so that your solution includes the important application fixes and new functionality that is introduced in Microsoft Dynamics NAV 2013 R2.

Secondly, you can fully automate the data upgrade process using the Windows PowerShell scripts that we included in the Microsoft Dynamics NAV 2013 R2 product media. Historically, this process has been known for its tediousness and high risk of human error when multiple operations had to be executed consecutively in all companies of the database that you were upgrading. The scripts automate this work so that you can test and execute your data upgrades more reliably.

Now with this delivery, we introduce an upgrade toolkit for upgrading the data from Microsoft Dynamics NAV 2009 R2 to Microsoft Dynamics NAV 2013 R2. This significantly simplifies the upgrade process for those of you coming from Microsoft Dynamics NAV 2009 R2 – or Microsoft Dynamics NAV 2009 SP1.

Included in the new upgrade toolkit are all known data upgrade-related application hotfixes that we are aware of, and we also addressed several platform issues that affected the upgrade scenario.

Note: You must download the latest Microsoft Dynamics NAV platform hotfixes before you start using the upgrade toolkit. The required hotfixes for Microsoft Dynamics NAV 2013 are available in the latest hotfix rollup, which you can download from PartnerSource or CustomerSource. For Microsoft Dynamics NAV 2013 R2, you can download the required hotfixes from PartnerSource or CustomerSource.

When you download the new upgrade toolkit from the link above, you can use it to simply your upgrade process. Here are the main steps in upgrading from Microsoft Dynamics NAV 2009 R2 (or Microsoft Dynamics NAV 2009 SP1) by using the new upgrade toolkit.

Note

Before you start, make sure that you use the latest platform binaries for all versions of Microsoft Dynamics NAV in this process. For more information, see the following pages for the latest updates to the versions of Microsoft Dynamics NAV:

Microsoft Dynamics NAV 2009 R2: Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2009 SP1 and Microsoft Dynamics NAV 2009 R2.

Microsoft Dynamics NAV 2013: Released Cumulative Updates for Microsoft Dynamics NAV 2013.

Microsoft Dynamics NAV 2013 R2: Released Cumulative Updates for Microsoft Dynamics NAV 2013 R2.

To upgrade data from a Microsoft Dynamics NAV 2009 R2 or Microsoft Dynamics NAV 2009 SP1 database

  1. In the Microsoft Dynamics NAV  2009 R2 or Microsoft Dynamics NAV  2009 SP1 development environment (Classic client):
    1. Make sure that all table objects have compiled successfully. During compilation, Microsoft Dynamics NAV generates or regenerates the BLOB content in the Object Metadata table that is used in the later steps.  In the Tools menu, choose Build Server Application Objects.
      Note: You must also do this if you upgrade from Microsoft Dynamics NAV 2013 to Microsoft Dynamics NAV 2013 R2 . All tables must be compiled Microsoft Dynamics in NAV 2013 before you start upgrading to Microsoft Dynamics NAV 2013 R2.
    2. Create a copy or a backup of your old Microsoft Dynamics NAV 2009 R2 database, and open it in the Microsoft Dynamics NAV 2009 R2 development environment.
    3. Add your partner license to the database.
      You can do this by selecting the Save License in Database field in the Alter Database window. If the field was not already selected, a dialog box opens so you can specify the location of your partner license.
      If the field was already selected, upload the partner license from the License Information window.
    4. Open the Object Designer, and then import Upgrade601701.1.fob. If the .fob file contains objects with conflicting versions that are already in the database, the Import Worksheet window opens. Choose Replace All.
    5. For each company in the database, open the company, and make the relevant changes to data. For more information, see Task 3: Data/Object Changes Prior to Step 1 in the MSDN Library.
  2. Then, from the Object Designer, run form 104001, Upgrade – Old Version. Choose the Transfer Data button. Repeat this action for each company in the database. 
    Note
    We strongly recommend that you back up the database using SQL Server management tools after this step. 
  3. When you have transferred all data for all companies, in the Upgrade – Old Version window, choose the Delete Objects button. 
    This action deletes all objects in the database that are not tables, but also obsolete tables that belong to functionality that is not available in Microsoft Dynamics NAV 2013 R2.
  4. Uninstall Microsoft Dynamics NAV 2009 R2, and then install Microsoft Dynamics NAV 2013.
    Note
    You do not have to install the full Microsoft Dynamics NAV 2013 product to perform the following database conversion. Instead, you can create a folder with the following files from the Microsoft Dynamics NAV 2013 product media:
  • Finsql.exe
  • Fin.stx
  • Fin.etx
  • CRONUS.FLF
  • Ndbcs.dll

You can then use the Finsql.exe file to perform the conversion.  

  • Change the compatibility level of your database. For SQL Server 2008 and SQL Server 2008 R2, verify that the compatibility level of the database is set to 100. For SQL Server 2012, set the compatibility level to 110.
  • In the Microsoft Dynamics NAV 2013 development environment, open the Microsoft Dynamics NAV 2009 R2 database and agree to convert the database. The database has now been technically upgraded to Microsoft Dynamics NAV 2013.

    Note 
    During this step, Microsoft Dynamics NAV converts all text and code fields to Unicode format by changing their SQL Server data type. This conversion requires more disk space than usual, since both the database and the log file will grow in size considerably. It can also be a lengthy process.

    If your Microsoft Dynamics NAV 2009 R2 database is using SQL Server Collation, within the same step the collation will be changed to a suitable Windows collation. This is because Microsoft Dynamics NAV 2013 and higher versions only support Windows Collation. If you converted your database using the RTM version of Microsoft Dynamics NAV 2013, you may be experiencing collation-related issues after this conversion. Therefore it is strongly recommended to use the latest available version of Microsoft Dynamics NAV 2013 development environment to perform this step.

    Note
    We strongly recommend that you take a full SQL Server backup at this stage when the database conversion has completed.

  • Uninstall Microsoft Dynamics NAV 2013, and then install Microsoft Dynamics NAV 2013 R2.
  • In the Microsoft Dynamics NAV 2013 R2 development environment:
  1. Open the Microsoft Dynamics NAV 2013 database and agree to convert the database.
  2. Compile the system tables. You can find the tables by setting a filter for table ID 2000000004..2000000130.
    In the following step, you will be connecting a Microsoft Dynamics NAV Server instance to the database. 
  1. Make sure that the service account that the Microsoft Dynamics NAV Server instance uses has the db_owner role for the database. 

    Note 
    If you are upgrading a large database, such as a database size of more than 20-25 GB, make sure that you increase the timeout value in the Microsoft Dynamics NAV Server configuration file. In the CustomSettings.config file, the value is defined in the SQL Command Timeout node. The default value is 10 minutes, which is sufficient in the normal day-to-day work. However, during an upgrade that can take several hours depending on the size of the tables, you must increase the timeout period.

  2. Connect the Microsoft Dynamics NAV Server instance to the database, and then start the service instance.
  3. In the Microsoft Dynamics NAV 2013 R2 development environment:
    1. On the Tools menu, open Options, and then, make sure that the Prevent data loss from table changes field is set to Yes.You must also make sure that the Server NameServer Instance, and Server Port fields are filled in.
      This ensures that the Microsoft Dynamics NAV Server instance that is connected to the database will verify that no operation will cause loss of data in the development environment.
    2. Import all customized objects in .fob format into the upgraded database. If the .fob file contains objects with conflicting versions that are already in the database, the Import Worksheet window opens. Choose Replace All.
    3. Make sure all objects are compiled.

      Important
      It is very important that at least all table objects have successfully compiled before you proceed.

    4. Import Upgrade Step 2 objects from the Upgrade601701.2.fob file.If the .fob file contains objects with conflicting versions that are already in the database, the Import Worksheet window opens. Choose Replace All.
  4. Perform the database schema synchronization by running the Sync-NAVTenant Windows PowerShell cmdlet in the Microsoft Dynamics NAV 2013 R2 Administration Shell (run as administrator).

    Note
    When you upgrade from one version to another, this typically involves numerous changes in the structure of the Microsoft Dynamics NAV tables (the object metadata). Database synchronization ensures that these changes in the metadata are applied to the corresponding tables in SQL Server. For example, it changes columns dimensions and data types, drops and create indices, drops and creates indexed views (V-SIFT), creates new tables, columns, and so on.

    When the number of changes is high, such as comparing Microsoft Dynamics NAV 2009 R2 to Microsoft Dynamics NAV 2013 R2, this synchronization can become a lengthy and resource consuming task.

    Database synchronization is triggered upon any request to Microsoft Dynamics NAV Server, such as when you start a client or run a windows Powershell cmdlet. Microsoft Dynamics NAV Server checks if metadata has changed since the last synchronization by comparing the content of the Object Metadata and Object Metadata Snapshot system tables. If a change is found, the synchronization procedure is initiated.  

    When the synchronization process has started, it is essential that you wait for it to complete or rollback (in case of an error or time-out). If you’re running a client, do not confirm or click anything client side. If you’re running the Sync-NAVTenant cmdlet, wait for it to complete and return control to the Windows PowerShell command prompt.

    Do NOT stop the Microsoft Dynamics NAV Server service at this point since there are high chances that the database synchronization transaction is still running.

    1. Run Microsoft Dynamics NAV 2013 R2 Administration Shell as Administrator. This opens a PowerShell prompt where the Microsoft Dynamics NAV cmdlets are available.
    2. Run the synchronization command against your upgrade database as follows: 

      Sync-NAVTenant –ServerInstance <MyNAVServerInstance> 

    3. Wait until the cmdlet returns control to the Windows PowerShell window.
  5. Open the Microsoft Dynamics NAV 2013 R2 Windows client to verify that you are connected to the Microsoft Dynamics NAV Server instance that is connected to the database being upgraded. 
    Next, you will run Upgrade Step 2 in each company in the upgraded database. You can get a list of all existing companies in the database by running the Get-NAVCompany cmdlet and passing as an argument the Microsoft Dynamics NAV Server instance which is connected to the upgraded database. 
    You will run objects directly from the development environment, so you must specify the company that the objects must run in in the Options window.
  6. In the Microsoft Dynamics NAV 2013 R2 development environment:
    1. On the Tools menu, open Options, and then, in the Company field, specify the name of the first company.
    2. In the Object Designer, find page 104002 Upgrade – New Version, and then choose Run.
    3. In the Upgrade – New Version window, choose Test Database Connection to make sure that the C/AL code that is triggered by the actions on the page has access to the database.
      If your database is on a named SQL Server instance, you must specify the full name in the SQL Server Name field.  
    4. Choose Transfer Data.
      If the process is successful, and you don’t have to revisit the upgrade logs, you can clean the content of the Upgrade Time Log  table. 
    5. On the Navigate tab, choose Time Log, and then, in the Upgrade Time Log page, delete all records.
    6. Close the Upgrade – New Version window, and then close the Microsoft Dynamics NAV Windows client.
  7. Repeat step 14 for each remaining company in the database.
  8. When you have successfully transferred data in the last company, you must upgrade data that is common to all companies in the database, such as permissions, permission sets, web services, profiles and control add-ins.
  9. Upgrade data common to all companies such as permissions, permission sets, web services, profiles and control add-ins.
    If the customer has changed the Read/Write/Modify/Delete/Execute settings for any of the standard permissions, or customized default permission sets in any way, you must merge these changes into the default permissions sets and permissions that are included in Microsoft Dynamics NAV 2013 R2. You can use XMLport 104001 Import/Export Roles and XMLport 104002 Import/Export Permissions to export the new default roles and permissions from the CRONUS International Ltd. demonstration database in Microsoft Dynamics NAV 2013 R2. You can add control add-ins in the Control Add-ins window in the Microsoft Dynamics NAV Windows client. For more information, see How to: Register a Windows Client Control Add-in. For example, the following client control add-ins are available from the Microsoft Dynamics NAV 2013 R2 product media:
  • Microsoft.Dynamics.Nav.Client.BusinessChart
  • Microsoft.Dynamics.Nav.Client.PageReady
  • Microsoft.Dynamics.Nav.Client.PingPong
  • Microsoft.Dynamics.Nav.Client.VideoPlayer
  • Delete the upgrade toolkit objects.
  1. In the Upgrade – New Version window, choose Mark/Delete Upgrade Toolkit
    This deletes all upgrade toolkit objects, except tables
  2. In the Microsoft Dynamics NAV development environment, delete the upgrade tables by setting a field filter for objects where the Version List contains Upgrade Toolkit Table – marked for deletion.

The database has now been through a data upgrade to Microsoft Dynamics NAV 2013 R2.

Steps to Upgrade Microsoft Dynamics nav 2013 R2 to Dynamics Nav 2015

Upgrade the application code.

Exporting all objects from the new customized Microsoft Dynamics NAV 2015 database to an objects.fob file.

Convert the database by opening it in the Microsoft Dynamics NAV 2015 development environment.

Prepare the data for the upgrade.

  1. Make sure that you are the only user connected to the database.
  2. Back up the database and save the backup file in a safe location.
  3. Make a copy of the customer’s database in SQL Server Management Studio. You will upgrade the copy and keep the original.
  4. Identify a User ID and password for a superuser in the system or create a new superuser that you can use for the upgrade process. Log in as the superuser when you perform the upgrade. 
  5. Verify that you have the dbcreator and securityadmin Server Roles for the Microsoft Dynamics NAV SQL Server instance by using SQL Server Management Studio. To manage companies, objects, and licenses in a Microsoft Dynamics NAV database you must also have the db_owner database permission.
  6. Disable integration properties for the database.
  7. Open the database in the Microsoft Dynamics NAV 2015 development environment.
  8. Run a database test to determine the state of the customer’s database.
  9. Run the Adjust Cost – Item Entries batch job to make sure that the inventory cost data in the customer’s database is up to date.
  10. For each company in the database that posts inventory costs to the Microsoft Dynamics NAV general ledger, run the Post Inventory Cost to G/L batch job.

Import the Upgrade Step 1 objects, and then perform Step 1 data conversion.

Export permission sets and permissions.

Delete all objects except tables.

Import the customized objects from the objects.fob file.

Import the objects for upgrade step 2, and then perform Step 2 data conversion.

Import upgraded permission sets and permissions.

Initialize all companies.

Delete obsolete tables.

Delete the upgrade toolkit objects.

Test the database.


 

Tablet related Issues in Navision 2015 and their resolutions

Tablet: Cannot cancel unresponsive tasks

Description: During some operations Microsoft Dynamics NAV Tablet client may appear unresponsive and there is no way to cancel the operation. This may occur in any user interaction which results in a long-running task on the server, or one where connectivity is lost. Symptoms include the “running dots” which repeat endlessly.

Workaround: If the operation cannot be canceled, close the browser and re-open tablet.aspx.