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