How to open a desired Page in NAV and get the selected VALUE?

This is small code snippet but very power Code to provide user functionality.

This code will open a desire page and developers can get a user input in a variable and use it to run

the functionalty.


DimensionValue.RESET;
DimensionValue.SETRANGE("Dimension Code",'INSTITUTE');
IF PAGE.RUNMODAL(0,DimensionValue) = ACTION::LookupOK THEN BEGIN
  InstituteCode := DimensionValue.Code;
END;


I hope this will help developers community for fast review.

What is the difference between ODATA URL and ODATAV4 URL in NAV?

Hi ,

Today while working on API I got this new ODATA V4 url in NAV 2018. Best part is it will help Nav developers to provide JSON data.

Yes this is correct whenever you will give ODATA V4 Login you will receive a json format data from NAV 2018.

ODATA V4 URL :

Result 1 : ODATA URL

Result 2 : ODATA V4 URL

Result 3 : SOAP Result.

How to call stored procedure from MS Dynamics NAV 2018 using Automation Variable?

Automation Variable in NAV 2018

Frankly this is my first interaction with automation variable in my project. So I want to share with NAV community how can we connect our SQL Database and interact with stored procedures to process NAV database.

Step 1. Take the below variables.

Name                  DataType                          Subtype

lADOConnection Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Connection

lADOCommand Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Command

lADOParameter Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Parameter

lvarActiveConnection Variant

Step 2. Write the below code :-

IF ISCLEAR(lADOConnection) THEN

CREATE(lADOConnection,FALSE,TRUE);

//lADOConnection.ConnectionString := 'Driver={SQL Server};Server=Server Address;Database=Database NAme;Uid=sa;Pwd=Password;

Check with other users also but provide some admin rights on SQL.

  lADOConnection.Open;

  IF ISCLEAR(lADOCommand) THEN
  CREATE(lADOCommand,FALSE,TRUE);
           
  lvarActiveConnection := lADOConnection;
  lADOCommand.ActiveConnection := lvarActiveConnection; 

  lADOCommand.CommandText := 'Stored Procedure Name';

  lADOCommand.CommandType := 4;
  lADOCommand.CommandTimeout := 0; 


  lADOCommand.Execute;

  lADOConnection.Close;
  CLEAR(lADOConnection);
  CLEAR(lADOParameter);
  CLEAR(lADOCommand);

 MESSAGE('Done Successfully');

So NAV Readers just try this code if you face any issue , comment below. Also for some usage bookmark this page.

Nav Purchase Transaction Impact on Chart of Account

Purchase Cycle :

When a Item is purchased in MS Dynamics NAV using purchase order and purchase invoice some accounts are credited and other accounts are debited. So for functional side we must know what is the major impact. Let's see the impact in detail.

Step 1. Create an Item.

Choose any of the default Item Template to complete the Item Setup.

Step 2. Create Purchase Quote and click on Create Order.

Once this is done your quote will be converted to Order and we are receiving the order and now we will check what is the impact of receiving on accounting level.

+ in NAV means Debit and - means Credit for accounting purpose only.

For Inventory concept of sign is same.

Step 3 : When we receive a PO there is no impact on Accounting Side.

Step 4 : Lets post the Receipt using purchase Invoice Page.

When we post the invoice we get this final result.

In this final result we will check the COA in GL Entry which Account is debited and which account is credited.

1.G/L Entry :

Vendor Account Credited by 750

and

Purch. Payable Account is debited by 600 and VAT 150

What is the impact of payment for vendor invoice on G/L Account?

Now, vendor account is debited 

5410 is debited by 750

&

5310 Liability Account is credited by 750.

The Miracle Of Hook In Ms Dynamics Navision 2016 and 2017?

Why to use Hooks in NAVISION ?

Hooks are the another ways to implement customisation in NAV 2016 and above.

Hooks Advantage :-

1. It increases Transparency.

      2. It increases Testability.

      3. It creates easy Upgradation of NAV versions.

      4. Separate Codunit for each objects. and there will be only a reference in base objects.

      5. Impact of Customisation will be minimum.

How to implement Hooks?

Step1.

Create a new codeunit which will be a parent codeunit and will be used for all customisation in NAV.

Step2.

Naming Conventions of HOOK

Microsoft Suggests Codeunit Process Name_HOOK for Eg. SIH_HOOK For Sales Invoice Header customisations.

Step3.

Create the hook and take an example to update a field and validate it before customisations.

for Example

Step4.

Reference it in Sales Post Codeunit.

Step5.

Implement all business logic in Hook Codeunit.

Summarize:-

Basically , it is another method suggested by MIcrosoft to write all code in one place so that implementation becomes easy to undertand and working smoothly.

To deploy Apps on Microsoft Partner Source you need to follow these guidelines provided by microsoft.

Thanks.

I hope this will surely hlp all my juniors to work and learn fastly, Please share my blog and comment below if you want another post or querry from my side.

How to change instance in WebClient URL of NAVISION ?

Hi ,

This post is about a Web Client Configuration in MS Dynamics NAV. If somehow we had implemented Web Client with different Instance of NAV then how can we reconfigure it.

In my case we have configured with DynamicsNAV90 but now we want our url to get change by the new instance. May be there present various options to others I request my readers to please do comment

and share all those methods if you have other ideas with you to share.

Solution Steps :-

1. Open the server with administrator login else it will not allow you to change the Config. File. If you are working on Local system then you may continue.
2. Open the inetpup Folder in C Drive.
3. Now goto this path C:\inetpub\wwwroot\DynamicsNAV90 and open Web.Config File present there in Notepad.
4. Replace your old instance name with new in 2 Places where old instance name has been used.
5. Now Goto this link also C:\inetpub\wwwroot\DynamicsNAV90\WebClient
6. And Open InstanceWeb File and here also change the instance name. It will appear in 2 positions so do change both of them.
7. Now Restart your system and open the new web Client. It will now point to new instance.

I hope this post is useful in installation and configuration of web Client to new developers. Please do like my post and subscribe via Email to get updates about new post.

Thanks for giving your time.

How to configure a Role Center in Role Tailored Client of MS Dynamics NAV 2017?

Requiremnt :-

To configure a Role Center Page in Nav 2017 for a User which is defined in User Personalisation .

Reference Screen :-

I am Going to configure ACCOUNTANT User Personalization.

Solution :-

Step 1. Open CMD from Start Menu.
And type the following on cmd.

cd C:\Program Files (x86)\Microsoft Dynamics NAV\70\RoleTailored Client

Step 2.
Now type the following command to open and configure the Role Center profile.
Microsoft.Dynamics.Nav.Client.exe -configure -profile:"ACCOUNTANT"

To Open the profile.

Step 3. Now Configure the profile. Means now you can remove the Department and other profiles.

Step 4. Remove the Department and other Menus whatsoever you want to remove.
Now see the final Result. It will automatically restart your NAV Profile and your desired Departmen will be removed.

You can also hide a Module from Menusuite but it will hide it from all the profiles of  NAV users so this above method is far better to accept.

You can check other Links from here :-

Goto this link.

What are the new Features in MS Dynamics NAV 2017?

As you know MS has released its latest version of Beta 2017 MS Dynamic NAV, Let's have a look over the new features included in it.

1. First new feature I observed in NAV 2017 web client is notification which we can use for different purpose in our development like overdue balance of customer,Routine posting and other things.

For this purpose we have been provided with new notication data types.

which works in 2 scopes local and global both according to function and our client requirement.

2. We can now further categorise our G/L Account in different categories of our requirement.

For example,

till yet we can only categorise a COA on the basis of Income/Balance sheet till yet now we can have other categories also. We can define a COA acoount on our requirement also.

I will post further new features also as i will go futher development and my learning.

Please share new features which you also see in comment box.

Get your copy of Beta version of MS Dynamics NAV 2017 here in below link.

MS DYNAMICS NAV 2017 Beta version