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.

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.

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.

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.

http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-components-postattachments/00-10-56-97-14/Upgrading-NAV-2009-R2-or-NAV-2009-SP1-Database-to-NAV-2015.pdf

BUILD - 38457

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!

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

http://msdn.microsoft.com/en-us/library/dd301054(v=nav.80).aspx

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