Friday 27 June 2014

How Do I - Series for NAV 2013 R2 Updated...

Hi all,

Microsoft have updated new videos on HOW DO I Series for NAV 2013 R2. Below are the link for new videos available on MSDN.

Thanks Microsoft MVP's for the HDI Series.

IF you are looking for Previously Released HDI Series Videos Please Refer Below Links.

>> From 01 To 26 Videos.     

>> From 27 To  42 Videos.

Below are the Links for New Videos.



Let's go through the videos and learn new things in NAV 2013 R2.
 
Reference:http://saurav-nav.blogspot.in

Regards,
Sathish

How Do I - Series for NAV 2013 R2 Updated

Hi all,

Microsoft have updated new videos on HOW DO I Series for NAV 2013 R2.

Below are the link for new videos available on MSDN.

For Last 26 Videos Link Please refer to the Post here.

Below are the Links for New Videos.

 27. How Do I : SEPA One-off Direct Debit Collections in Microsoft Dynamics NAV 2013 R2

28.How Do I : Manage Users in Windows PowerShell with Microsoft Dynamics NAV 2013 R2

29.How Do I : Deploy the Help Server in Microsoft Dynamics NAV 2013 R2

30.How Do I : Create Windows PowerShell scripts for Microsoft Dynamics NAV 2013 R2

31.How Do I : Get Started with Windows PowerShell for Microsoft Dynamics NAV 2013 R2

32.How Do I : Use the Debugger in Microsoft Dynamics NAV 2013 R2

33.How Do I : SEPA Recurring Direct Debit Collections in Microsoft Dynamics NAV 2013 R2

34.How Do I : Do Full SQL Tracing for Microsoft Dynamics NAV 2013 R2

35.How Do I : Manage Objects in Microsoft Dynamics NAV 2013 R2 Development Environment from the Command Prompt

36.How Do I : Monitor a Microsoft Dynamics NAV 2013 R2 Server Instance using Event Tracing

37.How Do I : Enable and Verify Single Sign-on with Office 365 in Microsoft Dynamics NAV 2013 R2 using Best Practice Analyzer and Windows PowerShell

38.How Do I : Export Payment Data to an Electronic Bank File in Microsoft Dynamics NAV 2013 R2

39.How Do I : Set Up Web Client, Windows Client, NAS, and Web Services on Separate Service Tiers in Microsoft Dynamics NAV 2013 R2

40.How Do I : Import a Variable-Column-Number Text File Using an XMLport in Microsoft Dynamics NAV 2013 R2

41.How Do I : Set Up the Job Queue in Microsoft Dynamics NAV 2013 R2

42.How Do I : Create a Matrix Page in Microsoft Dynamics NAV 2013 R2

Let's go through the videos and learn new things in NAV 2013 R2.

Regards,
Sathish

How Do I - Series for NAV 2013 R2

Hi all,

Microsoft have released so many videos on HOW DO I Series for NAV 2013 R2.

Below are the link for the videos.

1. How Do I: Create a Web Service that is based on Account Schedule KPIs in Microsoft Dynamics NAV 2013 R2

2.How Do I: Import and Reconcile a Bank Statement in Microsoft Dynamics NAV 2013 R2

3.How Do I: Manage Incoming Documents in Microsoft Dynamics NAV 2013 R2

4.How Do I: Work with the Payment Registration for incoming payments in Microsoft Dynamics NAV 2013 R2

5.How Do I: Migrate Data Using RapidStart Services for Microsoft Dynamics NAV 2013 R2

6.How Do I: Create a Simple Hello World Extensibility Control in Microsoft Dynamics NAV 2013 R2

7.How Do I: Create a Bing Maps  Extensibility Control in Microsoft Dynamics NAV 2013 R2

8.How Do I: Create a Media Player Extensibility Control in Microsoft Dynamics NAV 2013 R2

9.How Do I: Use the Resource File to Enhance an Extensibility Control in Microsoft Dynamics NAV 2013 R2

10.How Do I: Embed Microsoft Dynamics NAV 2013 R2 pages in a SharePoint Portal

11. How Do I: Enable Single sign-on with Office 365 in Microsoft Dynamics NAV 2013 R2

12. How Do I: Expose Microsoft Dynamics NAV 2013 R2 lists through Business Connectivity Services (BCS)and OData Web Services in Office 365

13. How Do I: Analyze and Decide the Best Grouping Structure in a Report in Microsoft Dynamics NAV 2013 R2

14. How Do I: Use the Document Outline Tool in Microsoft Dynamics NAV 2013 R2

15. How Do I: Use the Row and Column Group Tool in Microsoft Dynamics NAV 2013 R2

16. How Do I: View My Report Dataset in Microsoft Dynamics NAV 2013 R2

17. How Do I: Align Controls in a Report in Microsoft Dynamics NAV 2013 R2

18. How Do I: Ensure My Report Fits Page Size in Microsoft Dynamics NAV 2013 R2

19. How Do I: Group Data in Microsoft Dynamics NAV 2013 R2

20. How Do I: Manage Companies in Microsoft Dynamics NAV 2013 R2

21. How Do I: Migrate from Multiple Companies to a Multi-tenant Architecture in Microsoft Dynamics NAV 2013 R2

22. How Do I: Migrate from a single-tenant NAV 2013 database to NAV 2013 R2 with a multi-tenancy architecture

23. How Do I: Backup and Restore in a Multitenant Environment in Microsoft Dynamics NAV 2013 R2

24. How Do I: Set Up and Monitor Database Synchronization in Microsoft Dynamics NAV 2013 R2

25. How Do I: Manage Tenants in Microsoft Dynamics NAV 2013 R2

26. How Do I: Run an Automated Data Upgrade in Microsoft Dynamics NAV 2013 R2

Felling excited, Lets see whats new in these videos.

Regards,
Sathish

Tuesday 24 June 2014

How to become a great Microsoft Dynamics NAV developer? Getting started

I have seen quite a lot of questions from confused and frustrated new developers who simply don’t understand Navision. “Why isn’t NAV and C/AL like the development languages they know, why isn’t it more like Pascal, Basic, C++ or even C#?”. Today nobody asks about Pascal or Basic anymore, but 18 years ago they were both quite common. 

Navision always had its own IDE (integrated development environment) called C/SIDE (originally short for client/server integrated development environment) and didn’t use Visual Studio as the development platform. This environment was tightly integrated into the (classic) client and specially optimized for ERP development. With the release of NAV 2013 the classic client is “dead”, only the development part of the classic client remains – now called “Microsoft Dynamics NAV Development Environment”. And this is still where all NAV development is done, with the exception of reports, where the report layouts is developed in Visual Studio using RDL.

Do you want to become a NAV developer or a NAV programmer?

I know many people would say that a developer and a programmer is the same. But I don’t think so. You can rather easily turn a “classic” C programmer into a NAV programmer by learning them C/AL. But becoming a NAV developer takes more time. It requires that you besides knowing the actual programming (C/AL) also have a much broader understanding of NAV. That you know both how it works from the users point of view and more important why it works the way it does. A Dynamics NAV developer should also have a good knowledge of ERP/accounting and business management in general. All NAV developers needs to understand the concepts of debit/credit.

Without this knowledge, then you’re often not able to fully understand the requirements you receive from the customers and/or consultants and come up with the best way to solve this requirement. You not only have to fulfill their requirements in a good technically way, but also in a way so that it is easy to use and doesn’t conflict with existing functionality.  

The NAV developer needs to be able to say “No” to the client/consultant, if they come up with a requirement. They need to be able to come up with alternative solutions or work-a-rounds. Why spend 10 hours creating a new functionality, if you can simplify the requirement and use existing functionality? 

So if a NAV programmer is someone who is able to write NAV code based on a detailed design specification, then the developer someone who is also able write the design specification. Which one do you want to become?

How to start with NAV development?

I therefor always suggest a new NAV developer that they start by learning how to use Dynamics NAV. Install the demo database, and then start using it. If you’re a new NAV developer working for a partner and you have never worked with NAV before, then you should really follow one of the implementation consultants when he/she helps the customer setup a new database. Be a part of the test-group. Create g/l accounts, customers, orders, post invoices, register payments etc. And always ask your self “What if I did this?”.  

A good way is also to follow the basic NAV training like “Dynamics NAV Introduction” and “Dynamics NAV Financial Management” or similar. Taking the “Dynamics NAV Developer” training is of course also a good idea, especially if your plan is to get the NAV developer certification. I know many partners would say that your focus is to get the NAV developer certification. But in my opinion then the certification in it self doesn’t really say anything about the knowledge of the developer, except that he/she might have been able to remember the answer to some standard questions. Personally I would prefer a developer with 1-2 years actual experience, then someone with a certification and less experience.

The debugger

When you have started using the system and feel comfortable with it, then start turning on the debugger. This way you can see exactly what happens when you use the system. You can see which objects are accessed, which code it executes and in which order. 

You should see the debugger as your best friend and tutor into NAV development. And it doesn’t matter if you’re a new developer or an experienced developer. Don’t see it just as a tool to debug errors!

If you are developing to Dynamics NAV 2009 to the Role Tailored Client (RTC) then the debugger will not work here! With NAV 2009 you need to debug using the classic client. With Dynamics NAV 2013 Microsoft released a new debugger that works now with the RTC (now just called the Windows client).

The standard system

So the debugger helps you to get familiar the standard system. Because when you know which code is executed, then it’s also much easier to be able to customize the system. 

So if you’re asked to add a new field to the sales order and make sure that this field is transferred to the posted sales invoice, then you can use the debugger to see how the existing fields are transferred. And you will know exactly which objects to modify.

And the standard system is full of examples. When you are familiar with the standard functionality, then it’s easy to identify similar functionality to what your development task’s requirement. Debug this functionality and then browse the objects, check the code and properties of the standard functionality and then eventually copy whatever code you need. Like if you need a new a new field which is almost similar to a standard field, then it’s easier to copy an existing field and the code related to this field and modify it, than to create it from scratch.

How to optimize your use of the NAV developer forums & Blogs?

As a developer you can get a lot of help from the Forums and Blogs. Often seeing new NAV developers start using forums and blogs as soon as they get their first development assignment. And sometimes doing a full copy-paste from their development assignment, before they have taken the time to understand the assignment themselves. Whereas most of our members love to help you with your specific problems, then nobody really wants to do your job for you. So that’s not the way to use the forums. Often such question will not even be answered, at least not as fast as you want. 

Always understand your own question before asking it. 

When posting a question or searching in a google you should try to make the post or question as short as possible, but at the same time detailed and easy to read. And always mention the product version, as there might be big difference in how to solve a problem in Navision 3.70 or Dynamics NAV 2013. Don’t simply ask “How do I do this?” but write something like “I consider doing it this or that way. But I’m having a problem understanding how to do this (be specific). Is this a good way to do it, or is there a different way it could be done”. This is of course only an example. But the idea is for you to ask your questions so that they can be answered without taking too much time from your fellow member. In general then posts which requires too much time to answer are less likely to get a quick answer. 

This blog post is the first in a series of posts with the purpose of helping especially Dynamics NAV developer newbies with some of the most frequently asked questions. If you have a suggestion to topics I should write about, then please write it in the comments below. If it’s a general question then I will put it on the list to be included in a future post.

Mibuso.com is another great resource, with an online forum that is available to you just for signing up as a member, as well as downloadable code.  You can learn a lot just by searching the forums.  I’d encourage you, as a new NAV developer, to sign up and review the site often.  It’s rich with expert advice – and it’s free!

With a membership to the NAVUG user group, you have several training options, and events you can attend.  They also have a free forum onsite, with excellent community participation. Likewise Dynamics User Group, which covers the entire Microsoft Dynamics family, has many online resources, including a forum, and blogs.

CustomerSource is another resource filled with NAV application and development training and documentation.  Talk to your CustomerSource administrator or VAR to get a login to the site and gain access to the information there.

See Also : 




Regards,
Sathish

Get in the NAV Development Game!

Preparation for your NAV development career is like setting the plays for the championship, and choosing your starting lineup.

The three-pointer

Why three? Because we NEVER ever develop in production!  (If you do that now, take a chair. You’ve fouled out!)  NAV is a very integrated system, and all changes need to be fully tested before they are implemented.  If you put your changes directly into production, you have no way of testing.  Removing your changes can be costly and time consuming, at the very least.  Therefore, you will need a test database that mirrors your production environment’s data and objects.  This database will allow users to test your code before you place it into production.  And if something goes wrong and your code adversely affects your test database, you’re still in the game!  You just build a new test database.

The third database is your practice court.  This is the database where you do the development and your own testing.  Let’s face it.  None of us are perfect.  There are things that we don’t anticipate in development tasks and things we overlook as we code.  Why air your dirty laundry to your users by putting it in the test database before you get a shot at cleaning up your code?  A development database allows you to complete your task and test it before you have to let a user have a crack at it.  It also allows you to set up test scripts (a series of situations that you find possible in the production environment) that can be reviewed in the test phase to see if the user can identify missing test scenarios.

All three databases can reside on the same SQL server, but you will want to do a little housecleaning after you’ve created the databases. If your database has sensitive data, such as credit card numbers, social security numbers, personal information, etc…, you will want to remove this information or assure that it’s not accessible in your testing.  At the very least, lock down permissions on the database via NAV security.

If your database has external links, such as the ability to send emails or process credit cards, you will want to disable these functions, and possibly remove relevant data as well.  Sending your customer’s emails from your test documents or charging their credit cards from them will result in a personal foul.  Your best bet is to remove the data, and disable the processes.  This can usually be done through the application setup.

The uniform

Just like you can’t get on the court without a uniform, you can’t develop NAV without a developer license (which is just a set of granules in your current license).  But don’t let that keep you out of the game!  You can obtain these granules from your VAR, who can discuss their abilities with you, to help you determine which you need, and give you the cost for obtaining them.  Regardless of which granules you obtain, you are allowed to only change the objects within your licensed applications.

You’d be surprised at how easy it is to add a field to a form or page, or add a piece of data to a report.  Even if you stop at this point, you’ll not only gain the ability to do these things, but learn more about how NAV is designed, and what developing in NAV is like.  If you’re not sure if you really want to develop in NAV, try this first.  You can always obtain a higher privileged license later on.

A house divided


Likewise, NAV has two flavors as well with the Classic Client and the Role Tailored Client (RTC).  Knowing which you are using is imperative to creating the right development environment.

The Classic Client environment requires only the NAV application with the Classic Client and the SQL database.  All code, regardless of which flavor you have, is written within the Classic Client.  This is the “default” environment for NAV.

If you’re developing in an RTC environment, you’ll also need an install of Visual Studio 2008 for development of RTC reports, as well as a three-tier environment for your NAV install.  Talk to your VAR if you’re unsure which of these you have, and they can assist you in creating a strong development environment.

Talk to the coach

Even if you have all the tools for development, the environment is created, your license is installed, and you’re already passing the ball and going for the hoop, you need to talk to your VAR.  If you have ongoing development with your VAR’s developers, the last thing you want to do is modify your objects without checking with them first.

NAV’s object set is very integrated.  A change to a single object could result in necessary changes to other objects.  Likewise, your VAR’s developers may have copies of your same objects involved in other development endeavors.  The last thing you want to pay them for is reworking their code to include your modifications.

Have a quick conversation with your VAR and discuss how you will keep your code and their code synchronized.Work with in-house developers and have developed a version control system whereby we incorporate our client’s code into our code and prevent rework.

Get in the game!

You will have obstacles and you will have days when you just feel defeated.  But don’t walk away. Team up with the NAV community.  We are here for you when those bad days come.  Just as any profession, we grow strongest when we grow together.

Regards,
Sathish

Friday 20 June 2014

NAV 2013 R2 - Introduction to PowerShell.

Hi All,

With Release of NAV 2013 R2 Microsoft have introduced one more component of NAV Administrators.

Yes that is Microsoft Dynamics NAV 2013 R2 Administration Shell.

With Release of NAV 2013 R2 one more pr-requisite before installing Navision is Powershell which comes up with a windows Update.

Powershell can used to access all Cmdlets available for windows. we can also use same for running Cmdlets for NAV 2013.

What is Cmdlets?

A cmdlet is a lightweight command that is used in the Windows PowerShell environment. The Windows PowerShell runtime invokes these cmdlets within the context of automation scripts that are provided at the command line. The Windows PowerShell runtime also invokes them programmatically through Windows PowerShell APIs.

What is Microsoft Dynamics NAV Windows PowerShell Cmdlets?

Windows PowerShell cmdlets for Server Administration are available with Microsoft Dynamics NAV 2013 R2. The cmdlets are implemented in Windows PowerShell 3.0. Windows PowerShell 3.0 is included with Windows Server 2012 and Windows 8. For other versions of Windows supported for Microsoft Dynamics NAV 2013 R2, you can install it as part of the Windows Management Framework 3.0 on the Microsoft Download Center.

To start a Windows PowerShell session that includes the Server Administration cmdlets, on the Start menu, choose All Programs, and then choose Microsoft Dynamics NAV 2013 R2 Administration Shell. This opens a Windows PowerShell prompt.

To see the cmdlets that are available for administering Microsoft Dynamics NAV, type the following at the Windows PowerShell prompt.

Get-Command *NAVServer*



For details of Cmdlets for Navision use the link.

How to Use PowerShell?

In Start Menu search for Windows PowerShell ISE and Run it as administrtor.



Now for using NAV Commands you need to import the modules in Powershell, that can be done by execution below command.
-------------------------------------------------------------------------------------
#Prepare PowerShell
Import-Module 'C:\Program Files\Microsoft Dynamics NAV\71\Service\NavAdminTool.ps1'
-------------------------------------------------------------------------------------

Where C:\Program Files\Microsoft Dynamics NAV\71\Service\NavAdminTool.ps1 is the default path of Navision cmdlets.

Once imported, it will behave similar to Microsoft Dynamics Administration tool.



We will be using PowerShell in future post, so i would suggest pin the Powershell ISE Shortcut to the TaskBar.

Regards,
Sathish

Thursday 19 June 2014

Interactive Sorting in Dynamics NAV 2013 Reports

Visual studio report designer enables reports to be interactive with its end users. We can let the end users sort data on the report and print it as per their choice.

In this post, I would like to explain how to add interactive sorting capability to your reports in Dynamics NAV.

I created a simple and plain customer list report with dataset as shown below in the Dynamics NAV report designer:

Capture1


In the layout designer, I used a table control to display the data in the body section and I used a text box control to show the title of the report in the header:

Capture2

Now, if we save and run this report, we would get a preview as shown in the following image:

Capture3

Here, the report is sorted on Customer No. by default (as it is the primary key of Customer table). Of course we can change the key in customer DataItem or use Tablix properties to sort on different fields/columns.

However, it can be made more user friendly by letting the end users choose, how the report data is sorted.

1. Open the report layout designer, right click on Name column and open Text box properties.

2. Click on Interactive sorting on the left side and enable interactive sorting. You can specify weather you want to sort on detail rows or groups. You also need to specify the Sort by column.

Follow the above 2 steps on other columns to enable interactive sorting on multiple columns.

Capture4

After enabling interactive sorting, the report preview looks as shown below:

Capture5


Regards,
Sathish

Friday 13 June 2014

Cumulative Update 15 for Microsoft Dynamics NAV 2013 has been released


Cumulative update 15 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013. 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 15

You can download cumulative update 15 from KB 2964546 – Cumulative Update 15 for Microsoft Dynamics NAV 2013 (Build 36919).

For a full list of all hotfixes included in the cumulative update, see the following CustomerSource and PartnerSource pages:

CustomerSource:
PartnerSource:

More Information

For more information about cumulative updates for Microsoft Dynamics NAV 2013, see Announcement of update rollups for Microsoft Dynamics NAV 2013.


Regards,
Sathish


Cumulative Update 8 for Microsoft Dynamics NAV 2013 R2 has been released


Cumulative update 8 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2. 

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
    • RU – Russia
    • SE - Sweden
    • UK - United Kingdom
Cumulative update 8 also introduces new functionality for exporting and importing companies and other data. You can export a company from a Microsoft Dynamics NAV database and import it into another database, and you can export and import other types of data such as global data, application data, and application objects.

In earlier versions of Microsoft Dynamics NAV, you exported and imported this type of data as part of backing up and restoring databases. In Microsoft Dynamics NAV 2013 R2 CU8, you can do this by using the Export-NAVData and Import-NAVData Windows PowerShell cmdlets. You can also import and export data in the Microsoft Dynamics NAV Windows client.

For more information, see the following documents on the W1 version of the Microsoft Dynamics NAV 2013 R2 CU8 download media:
  • MicrosoftDynamicsNAV2013R2CU8_ExportImportDataUsingNavDataFiles.pptx
  • MicrosoftDynamicsNAV2013R2CU8_ImportExportData.pdf
Please note that there is very limited support for exporting and importing data in the Microsoft Dynamics NAV Web client. Use the Microsoft Dynamics NAV Windows client or the Windows PowerShell cmdlets instead.

Where to find cumulative update 8

You can download cumulative update 8 from KB 2971746 – Cumulative Update 8 for Microsoft Dynamics NAV 2013 R2 (Build 36897).

For a full list of all hotfixes included in cumulative updates for Microsoft Dynamics NAV 2013 R2, see the following CustomerSource and PartnerSource pages: 

CustomerSource:
PartnerSource

More Information

For more information about cumulative updates for Microsoft Dynamics NAV 2013 R2, see Announcement of update rollups for Microsoft Dynamics NAV 2013 R2


Regards,
Sathish