Why manually renaming a record takes little time?

In Dynamics NAV, if you try to modify the primary key field values it will take little time to change the value and also shows the window processing different tables.

When you try to change the primary key field value, internally it will check for the fields in all the tables which has the table relation to the primary key. That means system will check for the foreign keys related to the primary key and change the field value to the new value.

Let’s say you have tables like sales header & sales line and if you want to reflect the primary key changes in the sales header to sales line, provide the table relations in the sales line.

TEMPORARYPATH and APPLICATIONPATH Functions

TEMPORARYPATH: This function returns the path to the directory where the temporary file for Microsoft Dynamics NAV is stored.

This function returns the following path in the classic client:

This function returns the following path In the RT client:

APPLICATIONPATH:  This function returns the path to the directory where the executable file for Microsoft Dynamics NAV is installed.

This function return the following path in the classic client:

This function return the following path in the RT client:

CurrFieldNo

We all know that CurrFieldNo contains the field number of the current field in the current form.

Today I noticed that even though it contains the field number, by the time of executing table trigger (like OnModify or OnDelete), it contains zero (not the last modified field number).

Book Review - Microsoft Dynamics NAV 2009 Application Design

First of all, congrats and thanks to Mark Brummel for writing a fantastic book and sharing his knowledge in very straight forward manner. When I got a copy of this book, I was very eager to read this and after started reading, my interest also increased from chapter to chapter. I learned new points and recalled my knowledge while reading this book. Instead of explaining basics of NAV, he explained the core points which are important for every NAV professional.

Especially I liked the following points in his book:

• ‘Look, Learn and Love’ principle is good.
• He not only explained the functionality and also the history of the functionality. For Example: Manufacturing.
• How different functionalities are used in various vertical industries.
• Application Life cycle chapter is useful.

In my opinion, it would be good if the book also covers the following points:

• Section for keys and indexes.
• Application Test Toolset.
• More details about the MRP and MPS.

Mistakes:

• In the Page 33, it is given as “Flow filters can have seven types” but it is flow fields.

Overall this book is suggestible for every NAV professional.
You can order this book from packtpub.

IndentationColumnName and IndentationControls properties

IndentationColumnName and IndentationControls are the page properties in the NAV 2009. These properties are used to indent the controls or columns.

Transformation Tool will automatically convert the following type of code in the form and adjust the above two properties in the page to show the data as indented.

For Example: Form 18, CurrForm.Name.UPDATEINDENT := Indentation * 220;

Now the major problem in the pages is, you cannot use these properties for the fields that are editable and has a table relation.

For example, you cannot indent Item No. or Location Code in the Item Journal page because these fields are editable and has a relation with another table. If you try to indent these fields, while entering the data into these fields, field value is automatically updated with the first value.

If you press “1” in the Item No. field, it will be automatically filled with the first value starting with 1 like “1000”.

Microsoft Dynamics® Regional Partner Awards - 2010

Microsoft announced the Microsoft Dynamics® Regional Partner Awards – 2010.

Here is the link to the press release.

Microsoft Dynamics Inner Circle and President Club Members

Microsoft announced the  Microsoft Dynamics Inner Circle and President Club Members for the FY10.

Here is the link to the list of winners and Congrats to them.