How to create New Nav Company using powershell?

Hi All,

Today I got one situation where we need to create a new NAV database from database itself and add the FOB and when we try to open it.

NAV will give us the ERROR 'No Company is found' or something like that.

So I interacted with powershell and sharing the basic steps to create Company in powershell if my nav developers get stuck in between.

SO lets start with powershell.

Step 1.

Open MS DYNAMICS NAV 2018 Administration Shell with Administrator Mode (Very important)

Import the Module using this command.

Import-Module "${env:ProgramFiles}\Microsoft Dynamics NAV\80\Service\NavAdminTool.ps1"

Step 2 .

Once it is imported Follow below screenshot :

It will take a while , if instance is running and everything works fine you can proceed with running your new company in RTC.

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.

Why we should use BEGIN END in our conditional Looping

This post is related to my one mistake so I just want to share it with all. This post will help my 

readers to understand how the conditional statement works in Navision and what is the impact of 

BEGIN END on all the Conditions.

For this I am using two scenarios of Code as shown in screenshot.

Image 1

Image 2

Image 3

Now in all the screen if you run the debugger it will show you the real facts.

Screen 1 and 3 are same in both the scenarios and working.

it will check all the three conditions.

Screen 2 is showing difference that whenever the IF condition before Begin is checked then either the

 whole code will be run else whole code will not be run by AL.

I hope it will be helpful to all developers of NAVISION. If you like my post then please share and 

comment.

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.

All You Need To Know About How Nav Is 3 Tier.

How Dynamics NAV uses a three-tier architecture?

Three tiers are DATABASE , CLIENT and APPLICATION :- 

1. SQL Server is the data tier and is used to store the data into a database.

2. Microsoft Dynamics NAV Server is the middle or server tier, managing all
business logics and communication. It also provides an additional layer of
security between clients and the database, and an additional layer for user
authentication.

3.On the client tier we find the RoleTailored clients, such as the Windows
clients and the Web client. 

Dynamics NAV 2013 also supports other kind of
clients, including Web Services (both SOAP and OData), a SharePoint client
through Microsoft Dynamics NAV Portal Framework, and a NAS service.

How to carry value from a field in purchase order to item ledger entry in NAV 2017 at blogs.anandnavconsultant.com

Requirement :-

Today I had a requirement to update Item ledger entry from Purchase header. To complete this requirement we need to understand the flow of header to ILE.

For Reference :-

So the above screen shows a basic architecture of flow from Purchase Header To ILE in NAV 2017.

Step 1.

(a.)

Add a field in Table 38 Purchase Header with a unique ID that must be used in whole process.

(b.)

Then Add a Field in Item Jnl Line. Accordingly Add it in Purchase Header Page also.

(c.)

Add the same field in ILE also.

For Reference see the screen,

In all I had added Field Narration Test on Id 50000 to all the tables required.

Step 2. Now add code to Table 83 thats all you dont need to code in Codeunit 90 for data flow.

Step 3. Now add the code in codeunit 22 for posting in ILE.

Step4. Now just run the Purchase invoice or Purchase Order Process,you will get your desired result in ILE.

Thanks.

I hope this blog will help you to upgrade your skills in NAV if you like it then please share and subscribe our blog to get our latest post notification .

You can also check these websites.

Goto this Blog

NAV 2017 GL SETUP of MS Dynamics NAV :- General Fast Tab Explained

NAV 2017 General Ledger Setup 

NAV 2017 GL SETUP General TAB

NAV 2017 has already been launched with new functionalities both for developers and Client.
Few important fields for developers in General Tab are as follows:-

1. LCY CODE and its SYMBOL Field.
2. Allow Posting Date.
3. BILL TO Sell TO VAT Calc.
4. Invoice Rounding Precision and its method.
5. Use Legacy G/L Entry Locking.

All Setups are placed at one place as in Screen 1 above. We should follow the same in below versions.