Upgrade NAV5SP1 to NAV2013

Prerequisites:

The below database objects are required to go upgrade NAV5SP1 to NAV2013.

NAV5SP1 Base Database

NAV5SP1 customer Database

NAV2009R2 Base Database

NAV2013R2 Base Database

To Upgrade from NAV5Sp1 to NAV2009R2 Data Upgrade is not necessary, follow the steps below

·        Merge the customized objects

·        Open/Convert the database in Nav 2009 R2

·        Delete all the objects except tables

·        Cleanup the data which are not required. Like some add-ons might not require to upgrade,etc.

·        Import the latest merged Objects.

·        Transform Forms to page using Transformation Tool, if we find any matrix forms then we need to convert those matrix form to pages manually.

·        Customized Reports needs to be converted to RDLC

·        Compile the objects and resolve the compilation errors

1.   Update the Application Code.

Any customization in the customer’s old database must be implemented in the       new database

2.   Export all the objects in the new customized Microsoft Dynamics NAV 2013 database to an object file: objects.fob.

3.   Prepare for the data conversion.

a.   Make sure that you are the only user connected to the database.

b.   Back up the database and save the backup file in a safe place.

c.    Make a copy of the customer’s database in SQL Server Management Studio. You will upgrade the copy and keep the original.

d.   Verify that both your partner development license file and customer license file have been updated to Microsoft Dynamics NAV 2013.

e.   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.

f.     Verify that you have the dbcreator and securityadmin Server Roles for the Microsoft Dynamics NAV SQL Server instance, using SQL Server Management Studio. To manage companies, objects, and licenses within a Microsoft Dynamics NAV database you must also have the db_owner database permission.

g.   Disable integration properties for the database.

h.   Open the database in the Microsoft Dynamics NAV 2009 Classic with Microsoft SQL Server client.

i.     Run a database test to determine the state of the customer’s database.
Note: The database test can require a significant amount of time, depending on the size of the database.

4.   Import Upgrade Step 1 Objects

Import Upgrade601700.1.fob.

5.      Run the “Adjust Cost-Item Entries” batch job to ensure that the inventory cost data in the customer’s database is up to date.

6.   If your organization posts inventory costs to the Microsoft Dynamics NAV general ledger, run the “Post Inventory Cost to G/L” batch job.

Run the job for each company in the database.

7.      For the SCM feature, make the changes to tables 32, 83, 89, and 5841 described in the Update Guide.

8.   Perform Step 1 data conversion.

a.    In the Classic client, open Object Designer, and then open form 104001, Upgrade - Old Version.

2. Choose Run.
3. Choose Transfer Data.

Repeat the conversion for each company in the database.

9.   On form 104001, choose Delete Objects.

This runs codeunit 104002, Delete Old Objects, which deletes all of the objects that are not tables. It also deletes tables that belong to the features that are discontinued in Microsoft Dynamics NAV 2013.

10.Create the New Microsoft Dynamics NAV Database.

This involves installing Microsoft Dynamics NAV 2013, and then opening your database in the Microsoft Dynamics NAV 2013 development environment.

See the Upgrade Guide for details.

11.Change the compatibility level of the database.

For SQL Server 2008 and SQL Server 2008 R2 editions, verify that the compatibility level of the database is set to 100. For SQL Server 2012, the appropriate compatibility level is 110. To set the compatibility level, run a query like the following in Microsoft SQL Server Management Studio:

USE [master]; ALTER DATABASE [YourDatabaseName] SET COMPATIBILITY_LEVEL = 100

12.   Import all customized Microsoft Dynamics NAV 2013 objects.

13.   Compile all objects.

14.Import Upgrade Step 2 objects.

 Import Upgrade601700.2.fob in the development environment.

15.Set the language

In the development environment, choose Tools, choose Language, and then select the language of the old customer database.

16.Perform Step 2 data conversion.

1. Open page 104002, Upgrade - New Version.
2. Choose Run.
   This opens the Windows client and displays page 104002, Upgrade - New Version.

Choose Transfer Data.
This runs codeunit 104048, Upgrade NAV 2009 Step 2.

17.Update source codes.

Run page 257, Source Codes, in the Windows client. Note any source codes that have been added, and then update the Source Code and Source Code Setup tables for any additional source codes in the new version.

18.Initialize all companies.

For each company, run codeunit 2, Company-Initialize and open page 531, Setup Checklist.

19.Update data in tables that are not specific to a single company.

This includes tables 2000000003 (Member Of), 2000000004 (User Role), 2000000005 (Permission), 2000000053 (Windows Access Control), and 2000000203 (Database Key Groups).

20.   Upgrade Roles (Permission Sets) and Permissions.

21.Delete obsolete tables

a.    Open Object Designer

b.    Open form 104002.

c.    Run Upgrade - New Version.

d.    Choose Delete, and then choose Mark Unused Old Tables.

e.      Set a filter on the Version List column to select tables marked as “Old Unused Table - marked for deletion.

f.       The Edit menu, choose Delete to delete the tables.

22.Delete Upgrade Toolkit Objects

1. In form 104002, choose Delete, and then choose Mark/Delete Upgrade Toolkit.
2. All Upgrade Toolkit objects, except tables, are removed automatically. The tables are marked for deletion.
3. Set a filter on the Version List column to select tables marked as “Upgrade Toolkit Tables - marked for deletion.”

On the Edit menu, choose Delete to delete the tables.

23.Test the database

a.    Test everything except field relationships between tables. If the test fails, follow the workflow for repairing damaged databases.

b.    Run the remaining part of the database test, which is to test field relationships between tables.

Test the upgraded item ledger entry invoiced quantities to make sure that any date compressed item ledger entries have been upgraded correctly.

                                                     

                                          ***Thank you very much ***

Hooks Pattern in NAV

What is Hooks Pattern?

When doing development over years, by different developers with different mind-sets, the standard code base gets changed a lot, adding multiple lines of code, adding local and global variants, adding or changing keys, changing existing  business logic.  In other terms, the standard text objects are being changed all over the place.

After years, it's not clear why a change was done, and what was the place where the change was intended to be done.  And the latter is quite important in an upgrade process, when code in the base product is being refactored: if the exact place of the posting of the Customer Entry is being redesigned to a separate number, the first thing I need to know, is that I did a certain change at the place: "where the posting of the Customer Entry starts".  The definition of that place, we call a "Hook"

Hooks Pattern follows the below process

First of all, name the places in the already existing code where customization is needed, All objects of the default applications that need to be changed

·        Second, place your business logic completely outside the already existing application code.

  On objects that should not hold any customized business logic (like tables, pages, XMLPorts)

Process:

Step1 - create your Hook code unit. This is always a code unit.  We apply the following rules to it:

• One Hook always hooks into one object.  Which basically means that I will only declare this new code unit in one other object (which is its parent object)
• The naming convention is: The_Original_Object_Name Hook.  Naming conventions are important, just to find your mapped object, and also to be able to group the Hooks.

Step2- you create the hook, which is basically a method (function) in your hook code unit.  The naming is important:

• The naming of the hook should NOT describe what it is going to do (So, examples like CheckMandatoryFields, FillCustomFields should not be used as a hook)
• The naming of the hook should describe WHERE the hook is placed, not what the hook will be doing (as nobody is able to look into the future 
• To help with the naming, it is a good convention to use the "On"-prefix for these triggers.  This way, it's very clear what are hooks, and what aren't.

Step 3- it's time to hook it to its corresponding object and right place in the business logic of that object.  You do this by declaring your code unit as a global in your object, and using the created hook function on its place in the business logic.  This way, these one-liners apply:

• A Hook code unit is only used once in one object only (its corresponding object)
• A Hook (function) is used only once in that object.  As a consequence, changing the parameters has no consequence: you only need to change one function-call
• The code unit is declared as a global.  That exact global is the only custom declarations in the existing object. Everything else is pushed to the hook-code unit.

Step 4- implements your business logic in the hook.  Do this in the most atomic way, as there is a good chance that this same hook is going to be used for other business logic as well.  Best is to use a one-line-function-call to business logic, so that the Hook Function itself stays readable.

Example

Suppose, we want to add business logic just before posting a sales document.  In that case, we have to look for the most relevant place, which is somewhere in the "Sales-Post" codeunit.  So:

Step 1: create code unit Sales-Post Hook:

 

 Step 2: create the hook function OnBeforePostDocument:

Step 3: declare a global in the "Sales-Post"-codeunit, called "SalesPostHook".  Then, call the Hook Function that you created in Step 2 in the right place.

 

Step 4: implement the business logic, by calling out to a new function.  And implement the test-code unit. 

Pros:

·        It will make the upgrade process much easier.

·        It will be very readable what is being customized on a certain place in an existing part of the application.

·        It is specially help full in handling large customization.

·        It easy, elegant, and very manageable.

·        Some time we can re-use the code.

Cons:

·        We have to keep Standard function and hook functions in sync always.

·        It is mostly not useable, when most changes happen in the more places in one object.

·        Making tricks and putting code in different places is making code hard to read and un-necessary complex.

·        It may increase the add-on cost because of extra objects and extra time(Assumption)

·        We can’t use in-built functions in Hook code units like currPage.xxx,

·        Test the whole functionality.

·        More investment and less benefit, because Microsoft already released merge tool from NAV2015, it saves our merging time.

Risks: 

·        Time factor, only the add-on is already developed without hook

·        Cost, it needs to more time for refactoring the whole logic.

·        Hook code unit naming conventions might collide when the application is using more than one add-on from different partners. Suppose three different partners are using the same hook name like sales post-hook with three different ID, system doesn’t allow while importing the objects.

·        Hook functions naming conventions is always as challenge. It must be easily understandable when we have multiple hooks in the same trigger.

·        It is always complex while merging\upgrading objects when the source version doesn’t have the hook pattern and destination version has, in case of customer has more add-ons from different partners.

·        Current record fields return variable and global variable handling is very complex.

How to Sync NAV tenant in NAV2015

Open Power shell  with Run as administrator as shown below

             

then run  import-Module 'C:\Program Files\Microsoft Dynamics NAV\80\Service\NavAdminTool.ps1'.

then Run Sync-NAVTenant,it ask the user confirmation as shown below 

Click on yes,then it will ask the service name and enter the service name and  press enter.

***Thank you for visiting my Blog***

How to get first day and last day of current and previous month

To get the first day of the current month,

  CALCDATE ('<CM-1M+1D>', Today);

To get the Last day of the current month,

    CALCDATE ('<CM>', Today).

To get the first day of the previous month,

     CALCDATE ('<CM-2M+1D>', Today);

To get the Last day of the Previous month,

       CALCDATE('<CM>',CALCDATE('<-CM-1D>',TODAY)). 

Exporting and Importing Data in the Microsoft Dynamics NAV Windows Client

Exporting and Importing Data in the Microsoft Dynamics NAV Windows Client

To export or import data, in the Search box, enter Data File, and then choose the related link.

To export data, you specify the type of data that you want to export, and when you choose the OK button, you specify where you want to save the file.

To import data, you specify the .navdata file to import data from, but you can't import an application if the .navdata file contains an application. This is because you can't overwrite the application that is currently open in the Microsoft Dynamics NAV Windows client. So the window has one less type of data that you can choose to import:

Please Check your Management Port in Microsoft Dynamics NAV 2013 R2

As you know, since Microsoft Dynamics NAV 2013 R2, schema changes are now handled in a different way.  All schema changes are now synchronized to the SQL Server database through the Microsoft Dynamics NAV service tier.

We sometimes hear of partners receiving the following error when they try to import a .fob file:

"The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state."

This can cause huge problems, especially if it is a newly upgraded database, and you need to Import the fobs from the older version, or if you want to import in a live environment some objects that you just developed in your test environment.

There are several reasons why you can get the ServiceChannel error, one of which was fixed in build 36310 (TFS#358256 Channel errors when trying to default to SPN). So if you are still using an older build number, please be sure you are on a higher build number.

But still, it happens quite often, that even on higher build numbers, you still get the error. In this case you should do the following:.

1. Verify that you are selecting the correct Microsoft Dynamics NAV Server instance in the development environment by choosing File, Database, Information, and then verifying the value of Server Instance.
2. Verify that the firewall is opened for the Server Port (usually 7046) and the Management Port (usually 7045) on the corresponding box where the service is running.

It sounds too easy, and in most of the cases the people do not believe us! But after a while they come back to say…yes It was really the management port.

So whenever you want to import any objects into Microsoft Dynamics NAV 2013 R2, if you get any related errors, please check the management port and the firewall settings.