October 2014 archive

Fields that will be mapped in “Match Automatically” function of Bank Account Reconciliations

Following is the priority and the logic of how the “Match Automatically” function works in Bank Account Reconciliations in Dynamics NAV 2013 Priority Bank Statement Bank Account Ledger Comment 1 Statement Amount Remaining Amount Will match if the amounts are identical 2 Description Description,External Document No, Document No Will match if the description text is identical or almost …

Continue reading

How to clean Dynamics NAV 2013 debugger breakpoints

If you have so many debugger breakpoints where you can’t go to each and disable then use this following TSQL code.  USE [NAVDatabase]; delete from dbo.[Debugger Breakpoint]; delete from dbo.[Session Event]; Thank you and Regards, Tharanga Chandrasekara 

Control Add-in – Part 01

Have you ever wondered how to extend Dynamics NAV RTC to a different level and how to add extra functionality to Dynamics NAV within its own framework ?? Take a look at below images. (Taken from MSDN) You can do this with the use of Control Add-in. Control Add-in allow you to extend RoleTailored client with custom functionality. …

Continue reading

Event : What’s new on Microsoft Dynamics 2013 R2

On 24th September 2014 at Cinnamon Lakeside, ZILLIONe Business Solution Sri Lanka hosted a gathering for Microsoft Dynamics NAV users. During the discussion we introduces Dynamics NAV 2013 R2 and new features comparing with Dynamics NAV 2009. Existing clients were really excited about the new look of the NAV 2013 R2 and new features. They were really excited about the assembly management and new dashboards of Dynamics NAV 2013 …

Continue reading

Event : A cocktail evening of Microsoft Dynamics NAV 2013 R2

On 25th September 2014 at 8 Degrees North, Cinnamon Lakeside, ZILLIONe Business Solution Sri Lanka hosted a cocktail evening for new prospects. During the gathering we introduces Dynamics NAV 2013 R2 to invitees and had a wonderful Q&A session with them. It was a great evening with lot of new chit chat about the product and everyone of them were …

Continue reading

1st ever Sri Lankan Microsoft Silver competency partner for ERP – ZILLIONe Business Solution Sri Lanka

ZILLIONe Business Solution Sri Lanka achieves another milestone by becoming the 1st ever Sri Lankan Microsoft Silver competency partner for ERP Proud to be a part of the journey! Thank you and Regards,Tharanga Chandrasekara

Manage and control number of active user loggins

Even though client license says it is for 10 users there are some chances more than 10 users can access the system at the same time. I have faced this situation many times and we didn’t had a option to control No. of user loggins. To achieve and control the number of user loggins I have written a small …

Continue reading

Length of G/L Account name in Microsoft Dynamics NAV

I was reading Vjeko.com and I found this article about Length of the G/L account. May be you already know this and may be not. Therefore I thought to share it with you all again. In earlier versions of Dynamics NAV (before NAV 2013) default length of the G/L Account Name in the G/L Account table was …

Continue reading

How to kill a session in Microsoft Dynamics NAV 2013 using session page in the windows client.

If you want to kill a session by force then use following method. There are few other methods available to achieve the same output, but this is one of the easiest methods. 1. First open the Microsoft Dynamics NAV Development environment. 2. Open Object designer (Shift + F12)3. Go to Page 9506 (Session List)4. Create a new action and name …

Continue reading

How to Shutdown SQL Server without interrupting existing users.

Is there a way to shutdown SQL server without interrupting to existing users? Yes you can. I am sure you have opened Window Services or SQL Server configuration manager many times before. Have you ever notice that when you right click on the SQL Server it gives you 5 options. One of this options does the trick for …

Continue reading