Cumulative Update 05 for Microsoft Dynamics NAV 2017 (Build 16177) April 2017

Hi,

Microsoft have been released CU 05 for Microsoft Dynamics NAV 2017 which includes all the updates about new features.

Remember this cumulative update includes all previous versions so get the latest update as soon.

Note Implementing this cumulative update will require a database upgrade.

According to MSDN,

It may be necessary to update your license after implementing this hotfix to gain access to new objects included in this or a previous cumulative update (this only applies to customer licenses).

For All CU 2017 , released cumulative updates for Microsoft Dynamics NAV 2017.

Download your CU 2017 Update 05

Click Here

How to apply current page filters on Report in NAV 2016

Hi All,

Today I want to share a code which will setup the report to run on the current filters which are applicable on our current page.

For Example :-

I want to run a report which shows me all the vendor ledgers on behalf of the current filters on Journal Template and Journal Batch Name.

To apply the filters I had written the below code on the OnAction trigger of Field :-

PrnGenJournal.RESET;
PrnGenJournal.SETRANGE("Journal Template Name","Journal Template Name");
PrnGenJournal.SETRANGE("Journal Batch Name","Journal Batch Name");
PrnGenJournal.SETRANGE("Document No.","Document No.");
PrnGenJournal.SETRANGE("Posting Date","Posting Date");
REPORT.RUNMODAL(50121, TRUE, TRUE, PrnGenJournal);

You can check the screen Shot as well.

This is just an example to get work faster . I hope you like the post.

Thanks.

Seven Questions To Ask At Functions Used In Nav.

Hi All,

This post is all about functions which are available in MS Dynamics NAV for Technical customisations.

So the First we have present is :-

1. STRSUBSTNO

Syntax :-

NewString := STRSUBSTNO(String [, Value1] ,...) 

It replaces all the %1 , %2 used in message.

Example:- 

STRSUBSTNO('Your balance is %1',Customer.Balance);

2.STRPOS

Syntax:-

Position := STRPOS(String, SubString)

It provides you the position of the string.

Example:-

Position := STRPOS('Navision','v');

3.STRLEN

Syntax-

Length := STRLEN(String);

It provides the length of the string .

Example :

Length := STRLEN('MSDYNAMICSNAV');

4.INCSTR

Syntax:-

NewString := INCSTR(String)

It increases the integer part in a string.

Example :

NewString := INCSTR('APU12');

Result will be APU13

5. COPYSTR

NewString := COPYSTR(String, Position[, Length])

It copies a part of string into new string.

Example :

Str := COPYSTR('Apurwa', 1, 3);    

6. MAXSTRLEN

MaxLen := MAXSTRLEN(String);

It returns the maximum String Length of the Variable.

Similarly, we have STRLEN to return the Actual String Length of a variable.

7. PADSTR

Str := PADSTR('MS DYNAMICS NAV', 50, 'd'); 

It can be used to select a part of a string on behalf of length and add a string if we want in a part.

8. DELCHR

NewString := DELCHR(String [, Where] [, Which])

To delete a particular character from a string.

You can use where as =,>,<,<>,AND,NOT

9.CONVERTSTR

Str := CONVERTSTR('MS DYnamics Nav', 'D', 'L');

It converts some string to another if present in the orignal string.

10. UPPERCASE & LOWERCASE

It converts a string in Lower and uppercase of orignal string.

11. SELECTSTR 

It retrieves the part of comma separated in a string.

Str := SELECTSTR(2, 'MS ,DYNAMICS ,NAV');

12. DELSTR & INSSTR

It deletes and inserts a part of string in orignal String.

Str := DELSTR('MS DYNAMICS NAV', 3, 8);

Str := INSSTR('MS DYNAMICS NAV', 'Anand', 8);

Thanks for giving your time to read this blog. Please do comment if you want more such post.

these are the system functions provided in MS Dynamics NAV.