Skip to main content


Showing posts with the label NAV2013-NAV2013R2

All good things (must) come to an end - NAV 2013 and NAV 2013 R2.

Hi Readers, Yes, it's true and I feel what the title says "all good things (must) come to an end". I still remember the good days when NAV 2013 & R2 was released and how happy we were. These two versions played a major role in the Product Future and also the existence of Product. If you were there with NAV at that time, market rumors were that its time to end NAV as it way behind in terms of technology. Everyone was worried and not ready to change when these versions were released. Last week Microsoft announced End MainStream Support for NAV 2013 and NAV 2013 R2. Read here on Microsoft Blog. Today when I look back, I still remember all challenges and learnings that these two releases had. We loved them, learned them and grew with them. Let's try to remember which bring major changes in product and released with these versions -

Microsoft Dynamics NAV 2013 R2 & Later - Report Page Number Format x/y

Hi All, We have already discussed this in NAV 2009 Reports about how to Set the Page Number in Format X/Y. But with Microsoft Dynamics NAV 2013 R2 and Later its very simple to configure it. Till 2013 we used to have setGroupPageNo and other functions to reset the Page No.

NAV 2013 R2 - Export To Excel With Font & Color Version 2.

Hi All, This post is re-written on the already published article due to some features were not present in the first article. Thanks to  +Valerie Metcalf  , Nuno Silva   &  Bruno Guedes  for identifying the missing features. Thank you all. Let's List Down what all was missing -  - If you are using AddColumnWithFonts insted of AddColumn the Bold, Italics and Underline property were not working.  - You Cannot actually use both AddColumnWithFonts & AddColumn in same Report.

Microsoft - New Links Worth To Look

Hi All, As there are so many products updated Version are being released for so many Microsoft products. Below are some Links which are worth to have a look with respect to NAV Ecosystem. These links are part of the ecosystem that we use for Microsoft Dynamics NAV like Visual Studio, Azure... With Every New Microsoft Dynamics NAV release we are getting strongly tied up with other technologies like discussed below.

NAV 2013 & Later - How to Run a Batch File From NAV.

Hi All, In Back Old Days we used to Run a Batch File From Navision Using Shell Command. The Shell Command is now discontinued with Release of Role Tailored Client. Today we will discuss the possibility of same using Dotnet Command. For the Demo i have create a .bat file named as autonav.bat. The bat file used in demo just rename a text file placed in C:\NAVDemo\ . The File Placed at above location is named as "agic ile". On Right Hand Side you can see  image shows the code in bat file and the files.

NAV 2013 R2 - Conditional Colouring in Matrix Page

Hi all, In the following post we will try to conditional colour the values appearing on the matrix Page. For the Demo Purpose we will use the Page "Items by Location Matrix". The Article is based on request of Mr.  Thiyagarajan M . All thanks to him if you find the article useful. A standard Item By location Matrix Page Look Like as shown in Right. For Conditional colouring a Non Matrix Page,please Refer the Article Conditional Colouring in NAV 2013 Pages

NAV 2013 R2 - Export To Excel With Font & Color

Hi All, This post is based on Requirement/ Query of one of my Blog Reader  +shital bawage  . All Thanks to Shital for the article. In this article we will discuss how to achieve Export To Excel with Font, Color and Back Ground Color. Please go through the article and let me know your views and queries as comment to the article. If you are looking for same solution in Navision Classic Version  refer the article . There are some issues which are resolved in a Separate Article, Please Refer Here For Updated Article for NAV 2013 R2 . Let's Begin.

NAV 2013 R2 - Multiple Sheets in Excel Using Excel Buffer.

Hi all, In this article we will see the possibility of having Multiple Excel Sheets Using Excel Buffer Export. The Article is based on request of Mr. Anand gupta , so all thanks to him for the query. Most of us know how to export data using excel buffer, but it only contain a single sheet. Now let's consider a scenario where i want to export my customers, vendors and Items from Navision in excel. So its pretty obvious that i want then in different sheets.

key Impact on Database Size.

Hi All, I am not sure about the article that I am writing that I Should Write it or not. The area that i am about to discuss is something where I am a newbie and would like to explore the area. The Reason behind article was something asking a query about database size based on keys. In this article we will see by a small demo how much the database size get increased based on No. of Keys that we have in one table.

NAV 2013 R2 - Import Excel File Using Excel Buffer.

Hi All, This article is based on a friend request. The Requirement was to import the data in a table From an Excel File. Most of us know this feature is there in standard objects of Microsoft Dynamics NAV from a long time. If you are one of those who don't know about it please go through the article.

NAV 2013 & Later - Grouping In Export To Excel Report Without Layout.

HI All, In This Article we will see how we can use Grouping (Group Header, Group Footer) Via Code in NAV 2013 R2 Reports. This situation is faced during upgrade of a Report where we had put code for Some Task Say Export to Excel in Sections Like Group Header and Footer in 2009 or Previous Version. In the Demo we will see a case of Export to Excel Report on Item Ledger Entry Table Having Grouped by Location Code and  Item Category Code . 1. As i Need Grouping on Location Code and Item Category Code in Item Ledger Entry Table i need to have a Key on Table 32 Item Ledger Entry as shown below.

Technical Article on - Inventory Costing functionality.

Hi all, Microsoft have published a technical article of the Inventory Costing functionality. The Article provides guidance on how the Adjust Cost - Item Entries batch job identifies and assigns a posting date to the value entries that the batch job is about to create. The Article should answer questions that we have about the functionality.

NAV Report - How To Use Excel SUMIF Function?

Hi all, I think most of us know SUMIF Function IN Excel , Those who don't know below is a sample. Suppose i Export my Item Ledger Entries Data in Excel. Now i want to see the Total Quantity Sum where Entry Type Is Sales or Purchase. There are two ways to achieve same - 1. I Filter the Data based on Entry Type and Sum up Quantity. 2. Or I Can Use SumIF Excel Function where i can put a condition.

NAV 2013 R2 - Role & Permission Wizard

Hi All, In Back old days we have tools for creating Roles and Permission Using Code Coverage. There were so many. One such tool for classic Client is still available at Mibuso . Recently During a Implementation i was struggling with Roles and Permission and thought to Upgrade the Tool For Role Tailored Client. Disclaimer -  ** This Tool does not provide you complete Roles and Permission Set to be Created. It will help you in creating a basic Structure. As the Tool is based on Code Coverage, it will only consider objects which are called during operations via Code Only. ** This tool automatically assign Read, Insert & Modify Permissions on all Table Data called during Operation. User need to modify the Permission as per requirement. Below are the Details of the same.

NAV - RTC Report Reset Row No. / Serial No. on Group Change.

Hi all, This post is based on query of one of my reader Peter Huba . During Report Development we face queries like resetting the Row  No. when there is a change in Group. What we exactly Try To Do ? We tried to write C/AL code based on our group and try to set/reset a variable. But in some cases that doesn't help too as we have visibility condition in RDLC Rows which create issues. What we Don't Do ?

NAV 2013 R2 - Generic Attachment Management.

Hi all, As this was asked by most of my Blog Readers that how we can save attachments / files with respect to Navision Documents like Sales order or Purchase orders, Here is a post which list the steps for achieving the goal. This post is based on request of  +Jasmine Jennifer   &  +somasree kar . I had Certain question when people ask for such customization as we have options to store Documents under Standard Product using links as Shown Below. Or by Using a Addon Like Zetadoc which is specially developed for same. But Customer have issues with method 1 when there is a change is server all the links need to mapped again. So let's discuss how we can achieve to store our attachments within Navision 2013 R2.

NAV 2013 R2 & Later - Table Information.

Hi all, In Good Old time till NAV 2013 we were able to see Record Count, Record Size and Size (KB) from Classic Client. But i received a query from a Friend about the same view in NAV 2013 R2 & NAV 2015. In this article we will see how we can achieve it.

NAV2013 & Later - How to Change Service Parameters Using Powershell.

Hi All, I received a query from a friend about setting properties of the service instance using powershell for NAV 2013 R2. Let's see how we can set those properties using powershell. Open and Load NAV Cmdlets in Powershell window. ** How to open and Load NAV Cmdlets in powershell. For Changing any property in the service instance there is a cmdlet called as Set-NAVServerConfiguration, as shown below.

NAV 2013 R2 - Navision Client Crash for a Set of Users after Upgrade.

Hi all, After Upgrade from NAV 2009 to NAV 2013 R2, one of my customer Reported that some of its users are unable to access the Windows Client. This post list down the discussion what we had and how we were able to resolve the issue. Issue - Some of the users when trying to Connect to Database were getting Below error Message and Navision Windows Client was getting crashed.

NAV 2013 & Later - Differences between Binaries in your installation or your database.

Hi all, Sometime while working on a Upgraded Database to NAV 2013 & Later we face a run time error with pages. One of the issue & its resolution is listed below. After upgrade from NAV 2009 / NAV 2009 SP1 & NAV 2009 R2 you might have faced an error message as shown below - ERROR - Compilation of assembly 'c:\ProgramData\Microsoft\Microsoft Dynamics\NAV\71\Serve\MicorosoftDynamicsNAVServer$..\assembly\Page.dll' failed. This can be caused by differences between Binaries in your installation or your database. Ensure that all installation components are consistent and up to date. Error................................