Monday 30 December 2013

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 

Wednesday 27 November 2013

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)

Thursday 14 November 2013

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
---------------------------




Sunday 10 November 2013

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.





Wednesday 9 October 2013

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.
---------------------------------------------------------------------------------------------

Monday 7 October 2013

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).
Microsoft Dynamics NAV 2013 R2 download links
DownloadMicrosoft Dynamics NAV 2013 R2
AU-Australia
AT-Austria
BE-Belgium
CA-Canada
DK-Denmark
FI-Finland
FR-France
DE-Germany
IS - Iceland
IN-India
IT-Italy
MX-Mexico
NL-Netherlands
NZ-New Zealand
NO-Norway
ES-Spain
SE-Sweden
CH-Switzerland
GB-Great Britain
US-United States
W1

Tuesday 1 October 2013

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!

Tuesday 24 September 2013

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). 

Monday 23 September 2013

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

Tuesday 27 August 2013

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.




Monday 12 August 2013

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.


Saturday 27 July 2013

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?



Thursday 11 July 2013

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


Wednesday 3 July 2013

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




Friday 7 June 2013

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

which contains
How?

Tuesday 21 May 2013

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).

Thursday 9 May 2013

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.



 

Friday 3 May 2013

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.

Tuesday 30 April 2013

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.



Saturday 27 April 2013

Wednesday 24 April 2013

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.



Thursday 18 April 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



Tuesday 16 April 2013

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



Tuesday 2 April 2013

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


Tuesday 26 March 2013

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.

Thursday 21 March 2013

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









Wednesday 27 February 2013

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.

Saturday 23 February 2013

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
---------------------------




Friday 22 February 2013

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

Thursday 21 February 2013

About Me

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

Got MVP award in Oct 2011 and 2012.

mvp.png


Attended Mibuso NAVTechDays2012
navtechdays2012_attendee.jpg

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