Cumulative Update 46 for Microsoft Dynamics NAV 2013 (Build 47667)

Cumulative Update 46 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013.

The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see http://support.microsoft.com/contactus/.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

• AU – Australia
• AT – Austria
• BE – Belgium
• CH – Switzerland
• DE – Germany
• DK – Denmark
• ES – Spain
• FI – Finland
• FR – France
• IS – Iceland
• IT – Italy
• NA – North America
• NL – Netherlands
• NO – Norway
• NZ – New Zealand
• SE – Sweden
• UK – United Kingdom

Where to find Cumulative Update 46

You can download the cumulative update from KB 3216196  – Cumulative Update 46 for Microsoft Dynamics NAV 2013 (Build 47667).

Warning

Before you install a cumulative update in a production environment, take the following precautions:

1. Test the cumulative update in a non-production environment.
2. Make a backup of the system or computer where the cumulative update is to be installed.

Additional Information

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2013.

For a list of all hotfixes included in cumulative updates for this version, see the following CustomerSource and PartnerSource pages:

CustomerSource:

• Overview of Released Application Hotfixes for Microsoft Dynamics NAV 2013
• Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2013

PartnerSource:

• Overview of Released Application Hotfixes for Microsoft Dynamics NAV 2013
• Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2013

Share:

Read more..

Cumulative Update 40 for Microsoft Dynamics NAV 2013 (Build 46292)

Cumulative Update 40 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013.

The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see http://support.microsoft.com/contactus/.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

• AU – Australia
• AT – Austria
• BE – Belgium
• CH – Switzerland
• DE – Germany
• DK – Denmark
• ES – Spain
• FI – Finland
• FR – France
• IS – Iceland
• IT – Italy
• NA – North America
• NL – Netherlands
• NO – Norway
• NZ – New Zealand
• SE – Sweden
• UK – United Kingdom

Where to find Cumulative Update 40

You can download the cumulative update from KB 3172331 – Cumulative Update 40 for Microsoft Dynamics NAV 2013 (Build 46292).

Warning

Before you install a cumulative update in a production environment, take the following precautions:

1. Test the cumulative update in a non-production environment.
2. Make a backup of the system or computer where the cumulative update is to be installed.

Additional Information

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2013.

For a list of all hotfixes included in cumulative updates for this version, see the following CustomerSource and PartnerSource pages:

CustomerSource:

• Overview of Released Application Hotfixes for Microsoft Dynamics NAV 2013
• Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2013

PartnerSource:

• Overview of Released Application Hotfixes for Microsoft Dynamics NAV 2013
• Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2013

Share:

Read more..

Cumulative Update 37 for Microsoft Dynamics NAV 2013 (Build 45477)

Cumulative Update 37 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013.

The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see http://support.microsoft.com/contactus/.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

• AU – Australia
• AT – Austria
• BE – Belgium
• CH – Switzerland
• DE – Germany
• DK – Denmark
• ES – Spain
• FI – Finland
• FR – France
• IS – Iceland
• IT – Italy
• NA – North America
• NL – Netherlands
• NO – Norway
• NZ – New Zealand
• SE – Sweden
• UK – United Kingdom
• 
  

Where to find Cumulative Update 37

You can download the cumulative update from KB 3151023 – Cumulative Update 37 for Microsoft Dynamics NAV 2013 (Build 45477).

Warning

Before you install a cumulative update in a production environment, take the following precautions:

1. Test the cumulative update in a non-production environment.
2. Make a backup of the system or computer where the cumulative update is to be installed.

Additional Information

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2013.

For a list of all hotfixes included in cumulative updates for this version, see the following CustomerSource and PartnerSource pages:

CustomerSource:

• Overview of Released Application Hotfixes for Microsoft Dynamics NAV 2013
• Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2013

PartnerSource:

• Overview of Released Application Hotfixes for Microsoft Dynamics NAV 2013
• Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2013

Share:

Read more..

Cumulative Update 32 for Microsoft Dynamics NAV 2013 has been released (Build 43390)

This Cumulative Update 32 includes hotfixes and regulatory features released for Microsoft Dynamics NAV 2013, including hotfixes and regulatory features released in previous Cumulative Updates.

Share:

Read more..

Naming Conventions in Navision

One of the best programming skills every programmer needs to have is to follow the proper naming conventions of the application and also do proper documentation of the changes they are making.  Microsoft provided some naming conventions to follow for Dynamics NAV and please check the below link for more information

https://msdn.microsoft.com/en-us/library/ee414213(v=nav.90).aspx

Share:

Read more..

Simple Tool to clear the data from the field in Navision

It is quite often during the implementation or re-implementation projects that there is a need to change a field data type or delete the field after it was added. The issue is if that field has the data, then in order to change the data type or to delete the field we have to clear the field value otherwise you will get the error. Below is an example of such error

If you have multiple companies in the database then you to have to clear the data in all the companies before you make the change, normally I create a process report to clear the data and run that in each company but it is a tedious task if you have many companies. I have come across this situation many times, so I have created a simple tool called Clear Fields, this is a process report with option to filter on the table and the field you want to clear, it also has the option to clear the data in all the companies, so you don’t have to change company and run this in each company.

As of now this is only designed to clear one field at a time and it handles any field type, in the future I plan to extend this and add more options to it. I have uploaded the .fob and .txt objects in the below location, it also has a word document which will explain the above the request page options

Download Objects: http://1drv.ms/1Mwrzum

Please leave your comments, feedback or any suggestions you have for me to improve me my blog and also if you have any questions, feel free to post..

Share:

Read more..

Cumulative Update 31 for Microsoft Dynamics NAV 2013 has been released (Build 42948)

This Cumulative Update 31 includes hotfixes and regulatory features released for Microsoft Dynamics NAV 2013, including hotfixes and regulatory features released in previous Cumulative Updates.

Share:

Read more..

How to find out who created/modified sales order/purchase order in Navision

In standard Navision if you want to find out who created/modified a document i.e. sales order, purchase order, transfer order… you cannot unless you do have a customization or you have to enable a change log setup

 

In this blog I will discuss how to make the customization to achieve this, but if you want to know how to achieve this using change log setup please refer to the following links

http://www.archerpoint.com/blog/Posts/setting-change-logs-microsoft-dynamics-nav-2013

https://msdn.microsoft.com/en-us/library/hh169208%28v=nav.71%29.aspx?f=255&MSPPError=-2147217396

 

Please note if you are using change log to trace for insertion and modification, then don’t include all the fields in your change log setup include only some fields.

How to achieve with customization: You need to have development license to make the below modifications

This example is for Sales order but you can do the same for other documents.

Open development environment and from the Object Designer select table tab on the left hand side and choose table 36 – Sales Header

Select Design and add the following four fields,

1. Created By (Code 50)

2. Created On ( DateTime)

3. Last Modified By (Code 50)

4. Last Modified On (DateTime) 

The field number’s can be different. Save the change by choosing File –> Save and Then File –> Exit.

Open the table 36 again in design mode, then from Menu choose View –> View C/AL Code or Press F9

As show in the below Figure 1, you need add the custom code in the OnInsert Trigger and OnModifiy Trigger of the object

Figure 1: Showing Table 36 Sales Header in Design Mode C/AL Code – OnInsert and OnModify Triggers

OnInsert()
// SK0001 >>
"Created By" := USERID;
"Created On":= CURRENTDATETIME;
// SK0001 <<

OnModify()
// SK0001 >>
"Modified By" := USERID;
"Modified On" := CURRENTDATETIME;
// SK0001 <<

Save the changes by choosing File –> Save and Then File –> Exit.

Now you can go to the Sales Order Page (42) or  Sales List Page and add those fields, if you want to track this in purchase or transfer then you can repeat the same steps as above but for the purchase use  38 – Purchase Header  table and for Transfer Order – 5740 Transfer Header Table.

With these simple modifications now you can track who created/modified or when they created/modified.

Please leave your comments and suggestions.

Share:

Read more..

Cumulative Update 29 for Microsoft Dynamics NAV 2013 has been released (Build 42219)

This Cumulative Update 29 includes hotfixes and regulatory features released for Microsoft Dynamics NAV 2013, including hotfixes and regulatory features released in previous Cumulative Updates.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

• AU - Australia
• AT - Austria
• BE - Belgium
• CH - Switzerland
• DE - Germany
• DK - Denmark
• ES - Spain
• FI - Finland
• FR - France
• IS - Iceland
• IT - Italy
• NA - North America
• NL - Netherlands
• NO - Norway
• NZ - New Zealand
• SE - Sweden
• UK - United Kingdom

Where to download this Cumulative Update

You can download the cumulative update from KB 3086433 - Cumulative Update 29 for Microsoft Dynamics NAV 2013 (Build 42219).

Problems that are resolved in this cumulative update

 

Platform hotfixes

Note You may have to compile the objects in your database after you apply this hotfix.

ID	Title
375110	"Server page is not open" error message when closing a page.
375137	Suppress .NET warning when running the NAV server and the client on the same machine.
375309	The Windows client disconnects when renaming a record.
375351	"The company <name> does not exist" error message when you try to change a language if the company name has a leading space character.

Application hotfixes

ID	Title	KB Functional Area	Changed Objects
375108	The expiration date on a recurring journal should not be based on the work date.	Finance	COD 13
375287	If you use the Insert G/L Accounts function on the Account Schedule page, the lines are inserted in the top if you place the cursor on a new line at the end.	Finance	PAG 104
375218	The Adjust Cost Item Entries batch job recognizes wrong costs on adjustment value entries when an inbound item ledger entry is reversed on a later date with a fixed cost application.	Inventory	TAB 339 TAB 5802
375305	Wrong average cost of the in-transit location after upgrading from a previous version to version 2013 with a new design.	Inventory	N/A
375142	The VAT Amount field is wrongly calculated if the Pmt. Disc. Excl. VAT and the VAT Tolerance % fields are enabled in the setup.	VAT/Sales Tax/Intrastat	COD 90

 

How to install a Microsoft Dynamics NAV 2013 cumulative update

See how to install a Microsoft Dynamics NAV 2013 cumulative update (https://support.microsoft.com/kb/2834770/ ) .

Share:

Read more..

Application Profiler/CODE COVERAGE in Navision 2013 R2

In the previous versions of Navision we use to have code coverage which is used to trace C/AL Code and the developers used to have the ability to scan the piece of code which is executed during an action,process. This tool was very helpful in debugging. Even in Navision 2013 Microsoft shipped Application tool set which includes code coverage tool but in later version we don’t have this option.

In this blog I try to explain the options we have for Navision 2013 R2.  The tool which is available for Navision 2013 R2 is Application profiler and which can be downloaded from the following link

http://navappprofiler.codeplex.com/

The downloaded file has DLLs and few objects in .txt format. It also has readme file which will guide you through the easy install process.  Rename the objects numbers if you already used them.

In order to run the code coverage run the Page 50000/ Performance Profiler

In order to trace the C/AL code for an action, please select the session you want to execute the trace for from the Target Session ID and click Start.

After executing the actions click stop. In the below example I executed the post action for the sales order.

The data it collects is combination of SQL Statements and C/AL code as shown in the below figure.

In order to view only the C/AL code try to set the filter for the object ID <> 0 and you will see all the C/AL statements it executed for the action. You can view all the code and analyze it from the result set.

I have not tested this on 2015 but I believe it will work on it. When I get sometime I will test it on NAV2015 and post the results.

Please leave your questions and suggestions in the comment section.

Share:

Read more..