Happy New Year 2014

May god bless you with all the success and happiness you deserve.

May Every Day of the New Year Glow with Good Cheer and Happiness for you and your Family.

Happy New Year 2014 

Microsoft Dynamics NAV 2013 administration tool does not work in a side-by-side installation with Microsoft Dynamics NAV 2013 R2.

Platform hotfix for Microsoft Dynamics NAV 2013 (Build 35591) is released.

This hotfix resolves the following problems:

ID	Title
353997	Microsoft Dynamics NAV 2013 administration tool does not work  in a side-by-side installation with Microsoft Dynamics NAV 2013  R2.
353766	When you use RapidStart services to import lots of records from an Excel workbook, it takes longer than expected.
353279	When you export an account schedule to an Excel workbook and select the Update Workbook option, calculated cells are not updated in the Excel workbook.

You can request the hotfix here (Partnersource login required)

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

How to Stop/Prevent Negative Inventory

I have seen these kind of requests a lot from developers/end-users in NAV forums.

In earlier versions we have to customize NAV to achieve this but NAV2013R2 brings this feature as standard.

We can set up that outbound posting that brings inventory below zero is blocked. This can be set up per item or for all items. 

This setup is in the Inventory Setup, we can put a check mark in Prevent Negative Inventory field which specifies if you can post transactions that will bring inventory levels below zero.

The selection that you make in this field indicates the value in the Prevent Negative Inventory field on individual item cards. The values will either be Default (Yes) or Default (No), which you can change.

I know have setup this for all Items i.e., in Inventory Setup and when I try to post an Item which has in sufficient Inventory then I got below error.

Microsoft Dynamics NAV

---------------------------

You have insufficient quantity of Item 1000 on inventory.

---------------------------

OK

---------------------------

NAV MVP's @ NAV TechDays 2013‏

Find the group picture taken at NAV TechDays 2013, from all Dynamics NAV MVP’s that could make it.

From left to right: Mark Brummel, Alain Krikilion, Eric Wauters, Kamil Sacek, Luc Van Dyck, David Singleton (with Aussie hat), Michael Nielsen (Director of Development for Dynamics NAV at Microsoft), Jörg Stryk, Vjekoslav Babic, Luc van Vugt (uppermost), Mohana Krishna Yadav, Andrey Panko, Arend-Jan Kauffmann, Gunnar Gestsson.

About NAV2013R2

Last Edited on: 22-10-2013
-------------------------------------------------------------------------------------------
To Create a New Company:

Go to CRONUS International Ltd./Departments/Administration/IT Administration/General/Companies in RTC

Click New and Enter the Company name.
We can also use Copy function in Action to Copy the Company.

In NAV2013R2 we have to create companies from RTC only and not form Dev Environment.

We can also create form powershell command "New-NAVCompany"
------------------------------------------------------------------------------------------
we need to restore database in NAV2013R2 using Powershell Cmdlets like
New-NAVDatabase -FilePath <DatabaseBAKfile> -DatabaseName <MyNavDatabase> -DatabaseInstance <DatabaseInstance> DatabaseServer <DatabaseServer> ServiceAccount <ServiceAccount>

<DatabaseBAKfile> so we need a SQL Backup file (BAk) for this.

If you have an earlier version, such as Microsoft Dynamics NAV 5.0 or Microsoft Dynamics NAV 4.0, you must first upgrade that version to Microsoft Dynamics NAV 2013.
-----------------------------------------------------------------------------------------
To design report layouts, Microsoft Visual Studio 2012 Professional, Premium, or Ultimate, or Microsoft SQL Server Report Builder for Microsoft SQL Server 2012, Microsoft SQL Server Report Builder for Microsoft SQL Server 2012 SP1, or Microsoft SQL Server 2008 R2 Report Builder 3.0 is required.

If you just want to do some changes and you didnt have VS2012 then you can set Use Report Builder to yes under
Tools-->Options in Development Environment and rdlc layout will be opened in SQL2012 Report Builder 3.0 which is installed by default with NAV2013R2.
-------------------------------------------------------------------------------------------

Backup of Database:
we can take backup of database in NAV2013R2 using Powershell Cmdlets like
Backup-SqlDatabase -Database "Demo Database NAV (7-1)" -ServerInstance VPS16239\NAVDEMO -BackupAction Database

The above command will create backup files in
C:\Program Files\Microsoft SQL Server\MSSQL11.NAVDEMO\MSSQL\Backup
--------------------------------------------------------------------------------------------
If you install NAV 2013 R2 next to existing NAV 2013 RTM build then NAV2013R2 Administrator Console will work.
But, when you want to open the Dynamics NAV Administration Console for NAV 2013 wont work:
Solution: Repair NAV2013 version after installing NAV2013R2.
---------------------------------------------------------------------------------------------

Once you open NAV2013 Database with NAV2013R2 Development Environment for Client Upgrade, We need to manually Compile all objects.
---------------------------------------------------------------------------------------------

Microsoft Dynamics NAV 2013 R2: Download Page

Microsoft Dynamics NAV 2013 is a landmark release, building on a strong product foundation to deliver new levels of customer and partner value through faster, more efficient implementations, compelling new and enhanced application functionality, and unparalleled levels of customer choice on how to deploy and access the solution.

The Microsoft Dynamics NAV 2013 R2 reflects Microsoft’s long-term commitment to the NAV partner community and adds significant new value for our small and midsized customers in the following areas:

• Great interoperability with Office 365 breaks down the walls between business data and how people get work done. Microsoft Dynamics NAV can now be deployed as an application to on-premises and cloud-based SharePoint sites, with single sign on and a consistent look and feel across the Microsoft Dynamics NAV Web client and Office 365. Deeper data integration capabilities will enable customers to extend Microsoft Dynamics NAV business processes with SharePoint workflows and Web parts, and take full advantage of Microsoft Excel and the Excel Web App.
• Enhanced cash management capabilities will help customers better manage risk and drive business growth with features such as automatic and manual payment processing, bank reconciliation tools, and support for SEPA direct debit and credit transfer.
• Powerful usability enhancements across both the Web and Windows clients make Microsoft Dynamics NAV even simpler to use and faster to deploy. A restyled user experience aligned with Office 365 makes it even easier for people to access, view and edit business data and processes.
• Continued commitment to deploying Microsoft Dynamics NAV on Windows Azure Infrastructure Services (available in Microsoft Dynamics NAV 2013 Feature Pack 1 release).

You can find the download page here

Microsoft Dynamics NAV 2013 R2 download links
Download	Microsoft Dynamics NAV 2013 R2
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
IN-India	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
GB-Great Britain	Download
US-United States	Download
W1	Download

MVP Award - 2013

Just now got an email informing that my MVP Status is renewed, so here starts the 3rd year as MVP.

Today, 977 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!

Style Sheet Tool for Microsoft Dynamics NAV2013

The Style Sheet Tool for Microsoft Dynamics NAV2013 is available in Mibuso Downloads Section.
http://mibuso.com/dlinfo.asp?FileID=1543

The Style Sheet Tool for Microsoft Dynamics NAV2013 enhances the Style Sheet feature in Microsoft Dynamics NAV 2013 by allowing you to easily and without programming knowledge create and modify style sheets in Microsoft Office Word.

Changes to Style Sheet tool for NAV 2013.

1.Multi-multiline support is added, so it is now possible to add several multiline records to the style sheet. Note though that records can not be indented, but added sequentially.

2.Setup page is modified to add Open/Save/Send options.

3.In NAV 2009, codeunit 50000 was released for automatic integration of the Style Sheet functionality with pages. Pages were then exported in xml format and modified by running codeunit 50000, to add style sheet actions.

This no longer works for NAV2013, as export /import of objects in xml format is no longer an option. Hence, adding Style Sheet Action (button) to each page must be done manually.

Follow the example below when adding the style sheet action to a page:

i. Add the action to the action designer (under appropriate group) with following properties:

Expanded Type SubType Name Caption
0 Action <Action680> Style Sheets

ii. OnAction trigger should contain following line:

StyleSheetDataMgt.LoadStylesheetDataRTC(GETPOSITION,CURRENTKEY,PAGE::"");

where StyleSheetDataMgt is a variable of type codeunit, 682 (Style Sheet Data Management). 

Fixed No. of Lines in NAV 2013 RTC Reports

The Objectives of this video are:

 1.      Review a typical NAV 2013 reports preview.

 2.      Modify the report to show fixed No. of lines

 3.      Run the report to review the changes.

Please note that I have used Report 205 = Order Confirmation report in this demo.

The functions created in Visual Studio are

public Shared DocumentNo as Object
public Shared FixedLenth as integer
public Shared prevOutputNo as integer

Public Function SetDocLength(NewData as boolean,Group as object,Outputno as integer )
  If (NOT NewData) AND (prevOutputNo = OutputNo) AND (DocumentNo = Group) Then
      FixedLenth = FixedLenth + 1
  ELSE
      FixedLenth = 0
  End If
 DocumentNo = Group
 prevOutputNo = OutputNo
End Function

Public Function GetDocLength( ) As Integer
  Return FixedLenth
End Function

Expression Added in Invisible text box is

=Code.SetDocLength((Iif(Fields!Type_SalesLine.Value = " ", true, false)),Fields!No_SalesHeader.Value,Fields!OutputNo.Value)


You can also watch video at

Post by Mohana - Dynamics NAV.

HTML Tags in Microsoft Dynamics NAV2013 Reports

This video will show you how to use HTML tags in Microsoft Dynamics NAV2013 reports which will reduce lot of time in customizing each report.

The file that you are trying to create cannot be created error in NAV2013

I was trying to create .bat file using C/AL code in NAV2013.

I got below error message when I ran the code in NAV2013 RTC

Microsoft Dynamics NAV
---------------------------

The file that you are trying to create cannot be created. The destination file has an extension that may be blocked. Contact your system administrator.
---------------------------
OK
---------------------------

I was able to create the file using NAV2009R2 Classic client but not able to create in NAV2013 RTC.

I posted my problem in Microsoft Dynamics Community.

Thanks to Roberto Stefanetti who helped me in solving my problem.


There is a parameter in Custom Settings File called ClientServicesProhibitedFileTypes which will not allow you to create files with extensions you mentioned here.

We cannot create files with below extensions using RTC now.

"ade;adp;app;asp;bat;bas;chm;cmd;com;cpl;csh;exe;fxp;gadget;hlp;hta;inf;ins;isp;its;js;jse;ksh;lnk;mad;maf;mag;mam;maq;mar;mas;mat;mau;mav;maw;mda;mdb;mde;mdt;mdw;mdz;msc;msi;msp;mst;ops;pcd;pif;prf;prg;pst;reg;scf;scr;sct;shb;shs;url;vb;vbe;vbs;vsmacros;vss;vst;vsw;ws;wsc;wsf;wsh"

I removed bat value from this property and restarted the service.

Now I am able to Create .bat file using NAV2013 RTC.

How to include Dimensions in Conf. Package Table Fields while using Rapid Start Services in NAV2013

You must have seen my blog video "How to Import and Post Opening Balances along with Dimensions in NAV2013 using Rapid Start Services" here.
http://mohana-dynamicsnav.blogspot.in/2013/04/how-to-import-and-post-opening-balances.html

You can see the Dimensions in Conf. Package tables fields but you cant see Dimensions as fields in Newly created package.

How to add the Dimensions in newly created package table fields?

Microsoft awards top-performing partners at Microsoft Worldwide Partner Conference

GAC Business Solutions named number one provider of Microsoft Dynamics NAV in Netherlands.

At the World Partner Conference, Microsoft voted GAC as number one provider of Microsoft Dynamics NAV in Netherlands. This makes the software club Oirschot to five percent of the world's top suppliers of business software based on Microsoft Dynamics NAV. GAC is also admitted to the 2013 President's Club for Microsoft Dynamics.

This shows once again that the GAC 'Growing Together' strategy works. Part of admission to the President's Club is to achieve growth through new customers to attract and help existing customers grow with the deployment of innovative solutions.

"We are proud that we are also counted in 2013 to the President's Club for Microsoft" says Erik van Driel, Director of GAC Business Solutions. "Our growth-oriented approach works, partners appreciate the focus on industry solutions and Microsoft puts us in the top five percent of top performing suppliers Dynamics NAV in the world. A result of the enthusiastic and dedicated efforts of the GAC staff. "

2013 President's Club
To be admitted to the 2013 President's Club for Microsoft Dynamics is an enterprise software company in possession of a Silver or Gold ERP Competency certification. Microsoft then look at the sales realized in which a breakdown is made between new business and sales to existing customers. These factors, some key business milestones, a consistently high level of customer satisfaction and an active role in the development of new technologies Microsoft is a ranking in partners. On the global top five percent of that ranking is membership of the President's Club awarded.

GAC shows with membership granted to a steady partner, who can boast high customer satisfaction and ensures high quality, technically advanced implementations of industry-specific enterprise software. That gives excellent growth opportunities for partners in the sectors manufacturing, wholesale, business services and healthcare.

Congratulations to our All 2013 Microsoft Dynamics President's Club and Inner Circle Members

a select group of Microsoft Dynamics partners were named to the Microsoft Dynamics Inner Circle and the Microsoft Dynamics President's Club. The Microsoft Dynamics Inner Circle represents an elite group of the most strategic Microsoft Dynamics partners from around the globe, with sales achievements that rank them in the highest echelon of the Microsoft Dynamics global network of partners. These partners are recognized for their exceptional overall company performance in delivering valuable solutions to Microsoft Dynamics customers. Microsoft Dynamics President's Club honors high-performing Microsoft Dynamics partners with a commitment to customers reflected in their business success and growth.

A list of the Microsoft WPC 2013 and Regional Partner award winners and finalists is available online at http://www.microsoft.com/en-us/news/download/presskits/partnernetwork/docs/DynamicsPartnerAwards.pdf

A list of the 2013 Microsoft Dynamics Inner Circle award winners is available online at http://www.microsoft.com/en-us/news/download/presskits/partnernetwork/docs/DynamicsInnerCircle.pdf

A list of the 2013 Microsoft Dynamics President's Club award winners can be found online at http://www.microsoft.com/en-us/news/download/presskits/partnernetwork/docs/DynamicsPresidentsClub.pdf

Service Tax – Reverse Charge for Microsoft Dynamics NAV 2013 - India

According to Notification No 15/2012-ST dated 17.03.2012, the proposed Reverse Charge Mechanism is made applicable from the 1st of July 2012, when Section 66B of the Finance Act, 1994 (Charge of Service Tax on and after Finance Act, 2012 - Exemption to small service providers) came into force.

Depending on the scenario, service tax must be paid by the service provider or the service receiver. As a result, when a reverse charge is made, this impacts the service tax liability of both provider and receiver. 

Please read the white paper that is included in this release to identify which areas of the Microsoft Dynamics NAV application logic those are impacted.

You can download the update here

https://mbs.microsoft.com/partnersource/support/selfsupport/taxupdates/msdnav2013reversecharge.htm

Microsoft Dynamics NAV 2013 Feature Pack 1 on Windows Azure

Microsoft has released Microsoft Dynamics NAV 2013 Feature Pack 1.

The Feature Pack 1 release delivers new provisioning tools that enable deployment of Microsoft Dynamics NAV on the Windows Azure platform. These provisioning tools include Windows PowerShell cmdlets and scripts that automate the deployment of Microsoft Dynamics NAV on Windows Azure virtual machines. The tools can also be adapted for deployment on other Cloud services or on-premise installations.

Get Ready for Microsoft Dynamics NAV 2013 on Windows Azure with

https://mbs.microsoft.com/partnersource/training/news/MSDYNAV2013onWindowsAzure.htm

which contains

How?

• How do I... Get Started with Provisioning Tools for Windows Azure [How-To, Video]
• How do I…Automate Provisioning of Dynamics NAV 2013 on a Windows Azure Virtual Machine [How-To, Video]
• How do I…Automate Provisioning of Microsoft Dynamics NAV 2013 across two Windows Azure Virtual Machines [How-To, Video]
• How do I…Create an ASP.NET Website and Invoke Automated Azure Virtual Machine Provisioning [How-To, Video]
• How to Automate Dynamics NAV Provisioning on Windows Azure Virtual Machines [Implementation Considerations, Slides] 

System returns an error message when you try to Select/Enter Role center ID in New Profile Card page NAV2013

Error Message:

Problem Statement:

System returns an error message when you try to Select/Enter Role center ID in New Profile Card page. The problem happens because in localization databases the Text000 has been translated in Page Profile Card (9170). This occurs only when you are working on Local Language in NAV. 

Solution: Delete the Localization text from ConstValueML Property of TextConstant Text000 in Profile Card Page (9170).

The file that you are trying to use is too large Error message while Importing

I have created a XMLPort to import data from a CSV file(comma-separated values) which is 36MB file.

I got below error message when I try to Import from NAV.

Microsoft Dynamics NAV
---------------------------
The file that you are trying to use is too large.
---------------------------
OK
---------------------------

Solution:
1. Open Microsoft Dynamics NAV Administration from All Programs
2. Select the NAV Service which you are using now
3. Click Edit at bottom
4. Increase Max. Upload Size from 30 to 50.
5. Click Save at bottom
6. Restart the Service.

 

Microsoft Dynamics NAV 2013 now available in Iceland, Norway and Switzerland

On May 1st, 2013, Microsoft has announced the availability of Microsoft Dynamics NAV 2013 in localized versions for Iceland, Norway and Switzerland.

This release extends the list of localized versions to 21 markets: 
Australia, 
Austria, 
Belgium, 
Canada, 
Denmark, 
Finland, 
France, 
Germany, 
Iceland, 
India, 
Italy, 
Mexico, 
Netherlands, 
Norway, 
New Zealand, 
Spain, 
Sweden, 
Switzerland, 
United Kingdom, 
United States and 
International English (W1). 

Access the available product localizations and related resources here and read more on the Launch Portal.

Best Practices Analyzer for Microsoft Dynamics NAV 2013

The Best Practices Analyzer for Microsoft Dynamics NAV 2013 is a tool for identifying issues that can prevent you from successfully deploying a three-tier environment of Microsoft Dynamics NAV 2013. A three-tier deployment is one where the client, Microsoft Dynamics NAV Server, and SQL Server are installed on separate computers. These deployments can be challenging because they often require additional domain administration tasks. The tool is relevant whether the client is a RoleTailored client or a Web services client.
The Best Practices Analyzer for Microsoft Dynamics NAV 2013 performs the following verifications:

• Verifies that an appropriate version of Microsoft Dynamics NAV Server is installed. Only Microsoft Dynamics NAV 2013 is supported.
• Verifies Microsoft Dynamics NAV connection strings.
• Verifies that the Microsoft Dynamics NAV Server service, the Microsoft Dynamics NAV Web services service, and the SQL Server service, which are required for Microsoft Dynamics NAV, are running.
• Checks database permissions to make sure that the required resources can connect to the database.
• Verifies that the necessary service principal names (SPN) have been created and correctly configured on the account that is running the Microsoft Dynamics NAV Server service.

You can find more information about the tool and download it from CustomerSource here or from PartnerSource here.

How to Import and Post Opening Balances along with Dimensions in NAV2013 using Rapid Start Services

Here is the Video for "How to Import and Post Opening Balances along with Dimensions in NAV2013 using Rapid Start Services"

Microsoft Dynamics NAV 2009 R2 and Microsoft Dynamics NAV 2013 are compatible with Microsoft Office 2013

Microsoft has announced that Microsoft Office 2013 is compatible with below versions of Microsoft Dynamics NAV:

• Microsoft Dynamics NAV 2009 R2
• Microsoft Dynamics NAV 2013

Microsoft Office 2013 is available in a 32-bit version and a 64-bit version. The recommended version of Microsoft Office 2013 in combination with Microsoft Dynamics NAV is 32-bit, since some of the Office Integration areas in Microsoft Dynamics NAV is not supported in the 64-bit version.

Please note the following:

1. Sending data from Microsoft Dynamics NAV to both Microsoft Office Word and Microsoft Office Excel using basic export is fully compatible with Microsoft Office Word 2013 and Microsoft Office Excel 2013. The same applies to exporting to Excel from reports and for export of Budgets, Account Schedules, Analysis by Dimensions, and so on.
2. Interactions such as letters initiated from Microsoft Dynamics NAV are compatible with Microsoft Office Word 2013.
1. Remark:You must apply a hotfix to enable the scenario in Microsoft Dynamics NAV 2009 R2. Refer to KB article: 2836732 (This has not been published yet. Until then, contact your Microsoft Support contact.)
3. Sending emails from Microsoft Dynamics NAV is only compatible with Microsoft Office Outlook 2013 32-bit version.
4. Outlook Synchronization is only compatible with Microsoft Office Outlook 2013 32-bit version.
5. Email Logging was rebuilt in Microsoft Dynamics NAV 2013, due to Office removed the support for CDO. For more information, see Collaboration Data Objects (CDO) 1.2.1 is not supported with Outlook 2010.
1. Email logging in NAV 2013 are supported for Microsoft Office 2013 and for Office 2010 SP1.
2. Email logging in Microsoft Dynamics NAV 2009 R2 is supported for Office 2010 SP1. It is not supported for Microsoft Office 2013.
6. OneNote integration available with Microsoft Dynamics NAV 2013 is fully compatible with Microsoft Office 2013.

Microsoft Dynamics NAV 2013 Feature Comparison Tool

One more great tool from Microsoft to Compare previous Versions with NAV2013 and how Microsoft Dynamics NAV 2013 has become even faster to implement, simpler to use and with the power to support your business ambitions.

http://www.microsoft.com/dynamics/upgrade-compare/nav/default.html

How to Kill Session in NAV2013

I tried to delete/kill session from Session List page which is under
CRONUS India Ltd./Departments/Administration/IT Administration/General
as before in Classic Client but it didn't work.

There are many ways to kill a session in NAV and these samples just should show you how you can handle this directly in the session page in the windows client.

Var 1:

1. Open the Dev. Environment and navigate to page 9506
2. Create a new action (configure your own custom "look and feel" settings)
3. Go to the C/AL Code Editor and enter the code in the "OnAction" trigger

        IF CONFIRM ('Kill session?') THEN STOPSESSION("Session ID");

   4. Save, compile and run the page. Finished.

Var2:

Another way would be to change the property "DeleteAllowed" in this page to Yes and type in the "OnDeletePage" trigger

STOPSESSION("Session ID");

Thanks to Rene for this blog
http://www.dynamicsblog.at/index.php/2012/10/18/nav2013-kill-session-in-session-manageme-1

Now Confirmed: NAV is the biggest piece of the Dynamics cake

Please read the complete post at

http://www.partnerpowerinternational.com/blog/now-confirmed-nav-is-the-biggest-piece-of-the-dynamics-cake/

Microsoft Dynamics NAV 2013 Now Available in Austria

On April 1st, 2013, Microsoft was excited to announce the availability of Microsoft Dynamics NAV 2013 in a localized version for Austria.

This release extends the list of localized versions to 18 markets: Australia, Austria, Belgium, Canada, Denmark, Finland, France, Germany, India, Italy, Mexico, Netherlands, New Zealand, Spain, Sweden, United Kingdom, United States and International English (W1).

In addition, Microsoft also reconfirmed that localizations for the Icelandic, Swiss and Norwegian markets are currently planned for availability at the end of April 2013.

Country localizations for the Czech Republic, Greece, Hungary, Poland, Portugal and Russia are being re-planned in the context of our development timeline for "Sicily" - the next Microsoft Dynamics NAV release - which is currently scheduled for the end of calendar year 2013.

You can Download DVD from Microsoft Dynamics NAV2013 Download Page
https://mbs.microsoft.com/partnersource/support/selfsupport/productreleases/MSDYN_NAV2013RTMDownload.htm

NAV 2013 Partner Licenses are now backwards compatible

NAV 2013 partner licenses are now backwards compatible.

Yes, You can now use your Microsoft Dynamics NAV 2013 license with earlier versions of Microsoft Dynamics NAV. 

In order to get a backwards compatible license you need to create a new Microsoft Dynamics NAV 2013 perpetual license in VOICE from Developer Tools, License Key Configuration.

How to Disable Personalization in NAV2013 RTC

We can Customize/Personalize NAV2013 RTC in different ways.
some of them are "Choose Column" and "Customize This Page" etc

We can stop/disable these Custimizations/Personalizations using a setup in NAV2013 RTC

Go to Profiles page

CRONUS Nederland BV/Departments/Administration/Application Setup/RoleTailored Client/Profiles

Select Profile for which you want to disable personalization

Click Edit

Set TRUE in "Disable Personalization Field".

Close RTC and Reopen

Now the above options are not available

Dynamics NAV 2013 Certifications

Microsoft has published only 3 Dynamics NAV Certifications till now

Here is the List

• MB7 - 700 Microsoft Dynamics NAV 2013 Installation & Configuration 
• MB7 - 701 Microsoft Dynamics NAV 2013 Core Setup & Finance
• MB7 - 702 Microsoft Dynamics NAV 2013 C/Side Development

All The Best :)

How to Update/Modify Data in All Companies

We have Table 2000000006 - Company
 This table contains the names of all the companies that have been created in the current database.

And also we have CHANGECOMPANY Function

Redirects references to table data from one company to another.

[Ok :=] Record.CHANGECOMPANY([CompanyName])

We can create a ProcessingOnly report to update the data in all companies using above table and function.

Ex: If I have to Update "Allow Posting From" and "Allow Posting To" field of General Ledger Setup table in all companies then:

1. Create a Processing Only report with Company as dataitem

2. write below code in Company - OnAfterGetRecord() trigger

    
GLSetup.CHANGECOMPANY(Name);

GLSetup.MODIFYALL("Allow Posting From",010213D); 
GLSetup.MODIFYALL("Allow Posting To",280213D);

//You can use variables in Request Form for From Date and To Date

Where GLSetup is global variable of record type variable with General Ledger Setup table.

One or more filters are not valid and will be ignored Message in NAV RTC

Today I tried to run (Preview) a Report with Date Filter and I got below confirmation message


Microsoft Dynamics NAV
---------------------------

One or more filters are not valid and will be ignored. Do you want to continue?
---------------------------
No   Yes
---------------------------

Then I found that this is because of Wrong date format entered in Birth Date filter.
Date format in My system is set to DDMMYY and I entered as MMDDYY.

But this behavior is different in Classic Client (NAV2009R2).

I tried to enter same MMDDYY format in classic client Birth Date filed.

It immediately shown error message

---------------------------
Microsoft Dynamics NAV Classic
---------------------------
'013150' is not a valid date.

---------------------------
OK
---------------------------

Where do I Found Current Sessions in NAV2013

Till NAV2009R2 we can see Current Sessions in Classic Client under
File-->Database-->Information
Under Sessions tab

But if I look at the same path in NAV2013 Development Environment?

The information is not available at above path.
Where can I find Current sessions in NAV2013?

In Order to see current sessions, we need login into the RTC client

Navigate to
CRONUS India Ltd./Departments/Administration/IT Administration/General
Under Tasks, we have sessions

 

How to Save Excel File Automatically

IF NOT CREATE(XlApp) THEN
  ERROR('Excel Not Found.');
xlBook := xlApp.Workbooks.Add(-4167);
xlSheet:= xlApp.ActiveSheet;
xlSheet.Name := 'Mohana'; //Sheet name

xlSheet.Range('A1').Value := 'Mohana';
xlSheet.Range('B1').Value := 'MVP-Microsoft Dynamics NAV';
xlSheet.Columns.AutoFit;
xlApp.Visible := TRUE;
xlBook.SaveAs('C:\Test\Mohana.xlsx'); // To save the excel file
xlBook.Close; //To Close the Excel

C/SIDE and C/AL Full Forms

C/SIDE stands for:

Client/Server Integrated Development Environment

 

 

C/AL Means

        Client Application Language

About Me

My Name is Mohana Krishna Yadav, Mohana in short and simple .

Got MVP award in Oct 2011 and 2012.




Attended Mibuso NAVTechDays2012


Also Blogging at http://mibuso.com/blogs/mohana