Danjo's two cents NAV, Powershell, Android, C#, Lync, Win8, …

13Feb/130

NAV – Some basic functions #1

When working with Data in Microsoft Dynamics NAV, there are some functions you do not need often, but if you need them, you will probably need to run them on many tables at once.

One example is truncating all the data in some tables. Yes, there is a function for that: DELETEALL.

But it is a lot of work to define a bunch of variables for the tables, name them in a speaking maner and use DELETEALL on the variable

Here is what you could do instead:

Use a new or existing Codeunit "Basic Functions" and include this function:

Now you just need to run this function.

It could look like this:

Basics.TruncateTable(50000);

Basics.TruncateTable(50001);

Basics.TruncateTable(50002);

Basics.TruncateTable(50003);

Basics.TruncateTable(50004);

...

Tagged as: No Comments
14Sep/120

NAV2009: Creating new ServiceTier

There is just one question when you want to create a new ServiceTier for NAV 2009:

How exactly was the command again?

This is what you have into Command line to create a new service:

After adding the service, you can change the login-account using the local services window.

The Service can be removed again using this command:

 

Tagged as: No Comments
19Jun/120

Did you know: Go to Defintion

Lately I got some really surprised developers, when I showed them or told them to us "Go to Definition".

It seems like this not so new feature is still not known to the nav development group.

If you know have a puzzled look, you may allow me to show you what there is.

Don't Know

Go to the customer table (18) and look into the contact-on validate trigger.

Here you find a line UpdateContFromCust.InserNewContactPerson(...

When you do a left-click onto the function name InsertNewContactPerson the context-menu shows Go to Definition.

When clicking on this Codeunit CustCont-Update (5056) is opened and shows the selected function.

 

Have fun trying it.

Cheeze

Tagged as: , No Comments
10Jun/121

Clausl is back: And he knows how to design reports with Visual Web Developer Express

Those of you who know the name clausl may also know that he has recently left Microsoft and the dynamics-blog.

But it took him not long to start a new blog: Clausl and Dynamics NAV

The first thing he blogged about is something I personaly already thought will not come back before NAV "8".

To make it short - he describes how to use Web Developer Express for Report-Design with NAV 2013.

http://mibuso.com/blogs/clausl/2012/05/31/free-visual-studio-designer-for-editing-reports-in-dynamics-nav-2013-and-other-options/

Great Idea

Tagged as: , , , 1 Comment
%d bloggers like this: