Saturday 20 December 2014

How to Identify Client Type via Code - Dynamics NAV


The following Microsoft Dynamics NAV clients interact with the Microsoft Dynamics NAV database through Microsoft Dynamics NAV Server:
  • Microsoft Dynamics NAV Windows client
  • Microsoft Dynamics NAV Web client 

If we have to differentiate development for Windows Client and Web Client then how to identify the client via code?

We have 2 functions available in Codeunit 419 - File Management called IsWindowsClient and IsWebClient.


Friday 12 December 2014

Pipe Filter with Excel | Alternative 2




I looked at the video by Kerry Rosvold on how to make a pipe filter in excel here and MVP Mark Brummel’s alternative here  . Both are awesome.


I have also an alternative way.


So this is how I do it.

You copy a few lines to excel like this:


And in Excel you paste, and Remove all other columns except No.




Add pipe (|) in B1 cell and =A1 in B2 cell and Enter



Add below formula in B3 cell and Enter
 =B2&B1&A3


Now it looks like



Re Select B3 Cell and select B1 value and Press F4 (which makes Pipe value Constant)



Now formula in B3 looks like
=B2&$B$1&A3

B1 is changed as $B$1


Copy B3 cell and paste in all below cells


The last row has the final filter.


Friday 5 December 2014

Restore fails with error "The media set has 2 media families but only 1 are provided. All members must be provided."

I was trying to restore a SQL backup (.bak) file of NAV2013R2 and got this error message.



The media set has 2 media families but only 1 are provided. All members must be provided.

Msg 3132, Level 16, State 1, Line 1 
The media set has 2 media families but only 1 are provided. All members must be provided. 
Msg 3013, Level 16, State 1, Line 1 
RESTORE DATABASE is terminating abnormally.


I tried many ways but still got same error.

I tried to take backup again to check whether I can find anything strange.
I noticed having 2 Destination files added while taking backup.



This error is due to your backup being divided into more than one part at the time of creating your backup file.

Remove one path from the backup destination so that only one .bak file is created.
Now I was able to restore the backup file successfully.

Monday 10 November 2014

Upgrade Toolkit for Upgrading Data from Microsoft Dynamics NAV 2009 R2 or SP1 to Microsoft Dynamics NAV 2015

The cumulative update 1 of NAV2015 includes an upgrade toolkit for upgrading a Microsoft Dynamics NAV 2009 R2 or Microsoft Dynamics NAV 2009 SP1 database to Microsoft Dynamics NAV 2015. The upgrade toolkit includes several application objects in FOB files that simplify the upgrade process for those of you coming from Microsoft Dynamics NAV 2009 R2 or Microsoft Dynamics NAV 2009 SP1. 

You can download cumulative update 1 here

https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;3013215

see the attached whitepaper about Upgrade Toolkit.

Thursday 2 October 2014

MVP Award - 2014


Just now got an email confirming that my MVP Status is renewed, so here starts the 4th year as MVP.



Today, 1,031 exemplary community leaders around the world were notified that they have received the MVP Award! These individuals were chosen because they have demonstrated their deep commitment to helping others make the most of their technology, voluntarily sharing their passion and real-world knowledge of Microsoft products with the community.
While there are more than 100 million social and technical community members, only a small portion are selected to be recognized as MVPs. Each year, around 4,000 MVPs are honored. They are nominated by Microsoft, other community individuals, or in some cases themselves. Candidates are rigorously evaluated for their technical expertise, community leadership, and voluntary community contributions for the previous year. They come from more than 90 countries, speak over 40 different languages, and are awarded in more than 90 Microsoft technologies. Together, they answer more than 10 million questions a year!
MVPs are recognized each quarter for this annual award, which continues to grow and evolve to reflect the development of Microsoft technologies.
Congratulations to the new MVPs, and welcome back to renewed MVPs. We are very excited to recognize your amazing accomplishments!

Thursday 18 September 2014

Download Microsoft Dynamics NAV 2015

The below page contains downloads of Microsoft Dynamics NAV 2015 and related resources.

https://mbs.microsoft.com/partnersource/northamerica/support/support-news/msdnav2015download

Below Databases are available to download.
AU-Australia Download
AT-Austria Download
BE-Belgium Download
CA-Canada Download
DK-Denmark Download
FI-Finland Download
FR-France Download
DE-Germany Download
IS - Iceland Download
IT-Italy Download
MX-Mexico Download
NL-Netherlands Download
NZ-New Zealand Download
NO-Norway Download
ES-Spain Download
SE-Sweden Download
CH-Switzerland Download
UK- United Kingdom Download
US-United States Download
RU-Russia Download
W1 Download

Ordering

New customers:
  • Microsoft Dynamics NAV 2015 can be ordered online using Order Central from October, 1st 2014.

  • Customers will be able to deploy Microsoft Dynamics NAV 2013 R2, if desired, by using the Microsoft Dynamics NAV 2013 R2 license key that will be issued through downgrade rights.

Existing customers:
  • The licenses of Microsoft Dynamics 2013 R2 customers with an active enhancement plan will be automatically upgraded to Microsoft Dynamics NAV 2015 starting October 6th, 2014.

  • Existing Microsoft Dynamics NAV 2009 customers with an active enhancement plan are entitled to request a transition upgrade of their license to Microsoft Dynamics NAV 2015 through Order Central from October 1st, 2014.

 

License Information

In order to run Microsoft Dynamics NAV 2015, you must have a valid Microsoft Dynamics NAV 2015 license file.

License Versioning

Microsoft Dynamics NAV 2015 introduces license key versioning. Please note the following specifications:
  • Microsoft Dynamics NAV 2015 license keys are not compatible with Microsoft Dynamics NAV 2013 R2 or Microsoft Dynamics NAV 2013.

  • Microsoft Dynamics NAV 2013 R2 and Microsoft Dynamics NAV 2013 license keys are not compatible with Microsoft Dynamics NAV 2015.


Microsoft Dynamics NAV 2009 R2 and Microsoft Dynamics NAV 2009 SP1 Upgrade Toolkits for Microsoft Dynamics NAV 2015

The country/region-specific Upgrade Toolkit will be available soon from the download list above.  The toolkit combines the procedures required to upgrade from Microsoft Dynamics NAV 2009 R2 and Microsoft Dynamics NAV 2009 SP1 to Microsoft Dynamics NAV 2015.

System Requirements for Microsoft Dynamics NAV 2015




Wednesday 17 September 2014

What's New in Microsoft Dynamics NAV 2015 - Part 5

Word Report Layouts


In previous versions of Microsoft Dynamics NAV, you could only design the layout of reports by using Visual Studio Report Designer or Microsoft SQL Server Report Builder. With Microsoft Dynamics NAV 2015, you can design report layouts by using Microsoft Word 2013. Word report layouts are built on Word custom XML parts that dynamically map a report dataset into a report at runtime.

Customizing and Managing Report Layouts from the Microsoft Dynamics NAV Clients

You can customize Word and RDLC report layouts from the Microsoft Dynamics NAV Windows client and Microsoft Dynamics NAV Web client by using Word 2013 and SQL Server Report Builder, respectively. This enables users can make variations of layouts, and then use the variations when viewing and printing reports as needed.

New Report Functions

The following functions have been added in Microsoft Dynamics NAV 2015 to support new report layout implementation.

SAVEASXML
 Saves a report as an .xml file on the computer that is running Microsoft Dynamics NAV Server.
WORDXMLPART
 Returns the report data structure as structured XML that is compatible with Word Custom XML parts.
WORDLAYOUT
 Gets the Word report layout that is used on a report and returns it as a data stream.
RDLCLAYOUT
 Gets the RDLC layout that is used on a report and returns it as a data stream.
HASCUSTOMLAYOUT
 A function in codeunit 1 that determines whether a report has an active custom Word layout or RDLC layout at run time.
MERGEDOCUMENT
 A function in codeunit 1 that loads the custom Word layout that is active on report and renders it in the targeted format, such as Word or PDF.
REPORTGETCUSTOMRDLC
 A function in codeunit 1 that loads the proper custom RDLC layout for a report at run time and uses the layout to render the report.



Layout can be designed in Word



Output will be




Tuesday 16 September 2014

Send Documents as Email in NAV2015

You can send attachments by email from Microsoft Dynamics NAV. 
An option for sending attachments as email is available from, for example, sales invoices, sales credit memos, sales orders, sales quotes, reminders, and finance charge memos, as well as some posted documents. 
The option is available in the ribbon and called Email or Post and email depending on the context. 
It displays a dialog that lets you attach the document together with a short message and send this as email directly from Microsoft Dynamics NAV. 
In Microsoft Dynamics NAV Windows client you can decide to modify the email more in your default mail program. 
The default email sender address is based on the settings in the SMTP Mail Setup window. 
If SMTP is not configured or Outlook is not available, the .pdf file will open instead.


What's New in Microsoft Dynamics NAV 2015 - Part 4

ShowMandatory Property


With Microsoft Dynamics NAV a new property called ShowMandatory has been introduced on page fields. The ShowMandatory property is set on page fields and marks the field with a red asterisk on the UI.



NOTE:The ShowMandatory property can be used to mark all page fields, but does not enforce any validation of the field. This means that the user will be able to close a page without entering data.

Monday 15 September 2014

What's New in Microsoft Dynamics NAV 2015 - Part 3

Enhanced Cues


Cues appear as tiles in the Microsoft Dynamics NAV client that display business data and key performance indicators (KPIs) on RoleCenters. Microsoft Dynamics NAV 2015 includes the following new features that expand the data that can be displayed in a Cue, and enhance Cue set up and appearance.

Colored Indicators

You can configure the Cue to display a bar along its upper border that changes color based on the data in the cue.


New Images

You can change the image that displays on the Cue or set up the Cue without an image. There are several images to choose from.


Normal Fields

In previous Microsoft Dynamics NAV versions, you could only set up Cues based on FlowFields for data. In Microsoft Dynamics NAV 2015, you can also use normal fields, which expands your possibilities for the Cue data source, such as using Query objects or source expressions.


Decimal and Text Data Types

In previous Microsoft Dynamics NAV versions, you could only set up Cues to display on integer data types. In Microsoft Dynamics NAV 2015, you can also use decimal and text data types. This provides you with additional data aggregation possibilities instead of just COUNT, such as SUM, MAX, MIN, and AVG.


Custom Formatting of Data

By using the AutoFormat property, you customize the format of the value that appears in a Cue. For example, you can set the number of decimal places, or place a symbol such as a +, -, or %, before or after a value.


Microsoft Dynamics NAV 2015 Readiness Library


If you want to find out more about this release, Please have a look at below link

PartnerSource Login Required.

https://mbs.microsoft.com/partnersource/northamerica/readiness-training/readiness-training-news/NAV2015ReadinessLibrary

What's New in Microsoft Dynamics NAV 2015 - Part 2

Commenting and uncommenting multiple lines of C/AL Code:


We can add and remove comment marks manually for each line till now.

But from now the Comment Selection and Uncomment Selection options available in the Edit menu.
The Comment Selection and Uncomment Selection options enable you to comment or uncomment multiple lines of code all at once.

  • To comment lines of code, select the lines, and then, in the Edit menu, choose Comment Selection (Shift+Ctrl+K).
  • To uncomment lines of code, select the lines, and then choose Uncomment Selection (Shift+Ctrl+O).



What's New in Microsoft Dynamics NAV 2015 - Part 1

Microsoft Dynamics NAV Tablet Client:


In Microsoft Dynamics NAV 2015 Microsoft introduced a new interface called Microsoft Dynamics NAV for Tablet. The Microsoft Dynamics NAV for Tablet allows users in small and medium sized businesses to access data from a tablet.

Developing for Microsoft Dynamics NAV for Tablet is very similar to developing for the Microsoft Dynamics NAV Web client using the Microsoft Dynamics NAV Development Environment.

To open Microsoft Dynamics NAV for Tablet in browser mode
The Role Center for the default company
http://MyNAVWeb:8080/DynamicsNAV80/WebClient/tablet.aspx
The Role Center for a specific company
http://MyNAVWeb:8080/DynamicsNAV80/WebClient/tablet.aspx?company=CRONUS%20International%20Ltd.
A specific page
http://MyNAVWeb:8080/DynamicsNAV80/WebClient/tablet.aspx?page=22


How it looks:



Microsoft Dynamics NAV 2015 Announced

Microsoft Dynamics NAV 2015 is Announced at Directions US.

Microsoft announces availability of Dynamics NAV 2015 on October 1st, 2014.

Here is the first look of NAV2015 Role Center Page.


Tuesday 12 August 2014

Compatibility of SQL Server 2014 with NAV2013 and NAV2013R2

Here we go:
SQL Server 2014 released earlier this year with many new and interesting capabilities. For further information, please take a look at the product information at this location:http://www.microsoft.com/en-us/server-cloud/products/sql-server/default.aspx.
Over the last few months, the Microsoft Dynamics NAV team has been testing compatibility with this new version of SQL Server, and now announced that Microsoft Dynamics NAV 2013 and Microsoft Dynamics NAV 2013 R2 are compatible with SQL Server 2014!
Microsoft is still testing Microsoft Dynamics NAV 2009 R2
Please note that this applies to the following editions of Microsoft SQL Server:
  • Standard Edition
  • Enterprise Edition


Thursday 7 August 2014

Top 25 Dynamics NAV Sites

Today I received a message from Dynamics101, a recently launched training site for Microsoft Dynamics products, mentioning that “after careful consideration we have decided to include your blog in our first annual list of Top 25 Dynamics NAV Sites.”  



Thank you all

Top 25 Dynamics NAV Blogs

Tuesday 5 August 2014

How to find which objects are in our License Range.


If you want to check whether object is in your license range or not then generally we click Design button and then if we can see design window then it means that object is in our license range or if we get below error then it means that object is not in our license range.





·        Some objects like Menusuite 1010 or 1030 can be designed but we get error message while saving.


So if we want to know for all objects in database then it is difficult to go through each object and design.
We have a new feature called object Lock in NAV2009 and above versions.
We can use this feature know which objects are in our license range by one click.
Select All Objects in Development Environment and Click FileàLock


The objects which are locked are in our license range and the objects which are not locked are not in our license range.

Try it yourself and you will find it.

Tuesday 29 July 2014

The Microsoft Dynamics NAV server is currently not ready to serve requests. Try again later or contact your system administrator.

Error Message:

The Microsoft Dynamics NAV server is currently not ready to serve requests. Try again later or contact your system administrator.

Problem Statement:

System returns above error message when you try to Connect to NAV Database and Stops the Running service.

Solution: 

Open SQL Management

Go to Security -> Logins -> find the login used by the NAV Server (e.g. Network Service) -> Properties -> User Mapping -> find the database and select db_owner in the "Database role membership".

Tuesday 8 July 2014

NAV TechDays 2014

what?

NAV TechDays is the name of a conference, organized by mibuso.com. This conference offers 2 days full of – technical only and highly relevant – sessions, related to Microsoft Dynamics™ NAV.
NAV TechDays is the place where some of the best developers and leading business owners cross paths, exchange ideas, find partners and conceive projects. It is where community ties are strengthened and where boundaries will be broken. It is where you want to be to make things happen. If you are passionate about Microsoft Dynamics NAV, then you need to be at NAV TechDays!

When?

20 & 21 November 2014
Antwerp, Belgium

For Who?

The conference is targeted towards:
  • ALL Microsoft Dynamics NAV developers (working for Microsoft partners or customers, freelancers, trainers, ...)
  • Technical decision makers, Project managers, IT managers
Although this event takes place in Europe, we welcome all attendees from other continents and regions.

Pre-conference?

This year, we added a pre-conference day packed with 10 full-day workshops. Each workshop is limited to max. 15 participants.
Take your laptop with you and dive into:
  • Microsoft .NET Interoperability
  • RDLC Reporting
  • Installing, configuring and troubleshooting SQL Server
  • Powershell
  • NAV ALM using Team Foundation Server
  • ...

Any Questions?



What are you waiting for?
Go and talk to your boss or management and convince them.




Thursday 10 April 2014

Webclient Issue - Error Message: Value cannot be null


We installed our NAV2013R2 NLD Trade+ database – build 35915 and facing issue with the web client.

Error message: Value cannot be null.

Event Viewer says:
Error accessing Website Microsoft Dynamics NAV 2013 R2 Web Client
URL: http://localhost:8080/DynamicsNAV71/WebClient/default.aspx
The ClientExceptionState indicated that the session should be abandoned but the exception handler had no UISession assigned.

Error accessing Website Microsoft Dynamics NAV 2013 R2 Web Client
URL: http://localhost:8080/DynamicsNAV71/WebClient/default.aspx
Type: System.ArgumentNullException
Message: Value cannot be null.
Parameter name: bindingManager

Generally the issue occurs if we have the Links system part added to the Role Center. Links system part is not supported by Web Client. 
If any or one of Role Center’s has the links part added then we can get this error on Web Client.

We deleted the Link part and it started working fine.

Friday 21 March 2014

Reset Autoincrement field in NAV

In SQL Server we have command called DBCC CHECKIDENT 

Checks the current identity value for the specified table and, if needed, corrects the identity value.
You can also use DBCC CHECKIDENT to manually set a new current identity value for the identity column.

The syntax of the DBCC CHECKIDENT command is as follows:

DBCC CHECKIDENT ( <table_name> [ , { NORESEED | { RESEED [, <new_reseed_value> ] } } ] )
[ WITH NO_INFOMSGS ]

The <table_name> parameter is the name of the table for which to check the current identity value and it must contain an identity column.  The NORESEED clause specifies that the current identity value should not be changed.  The RESEED clause specifies that the current identity value should be changed.  The <new_reseed_value> is the new value to be used as the current value of the identity column.  Lastly, the WITH NO_INFOMSGS clause suppresses all informational messages.


If the table has no rows and execute below statement

Use [Demo Database NAV (7-1)]
GO
DBCC CHECKIDENT ([CRONUS Nederland BV$Test Increment], NORESEED);
GO

Result:
Checking identity information: current identity value 'Null', current column value 'Null'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

If it has one row then result of above statement is:

Checking identity information: current identity value '1', current column value '1'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.


To set the IDENTITY column of a table to start from 1, the following statement can be issued:
The following example forces the current identity value in the table to a value of 0. The next row inserted will use 1 as the value, that is, the new current increment value defined for the column value plus 1.

Use [Demo Database NAV (7-1)]
GO
DBCC CHECKIDENT ([CRONUS Nederland BV$Test Increment], RESEED,0);
GO

Permissions:
Caller must own the table, or be a member of the sysadmin fixed server role, the db_owner fixed database role, or the db_ddladmin fixed database role.