Navision Planet

Visual Studio Code setup to enable Business Central AL coding

jubelmundackal@gmail.com (Jubel) — Sun, 23 Sep 2018 22:22:00 +0530

How to Setup Business Central Development Environment?

Hope you have installed the Business Central via Docker. If not then recommended you to read Dynamics 365 Business Central Install using Docker post.

In this post I would like to share the following details related to Visual Studio Code setup to start the development for Business Central with AL coding.

Step 1 : Install Visual Studio Code

Visual Studio Code is the open source coding editor from Microsoft. By the help of this software we can start coding for any language by the help of extensions. This software will work on Operating systems like Windows, Linux and Mac OS. It support features like syntax highlighting, intelligent code completion, snippets, code refactoring and Git hub connection etc.

Visual Studio Code

You can download the Visual studio code from Microsoft Visual Studio Code Free Download

Step 2 : Download Certificate and Install

After installing the Visual studio code and download the Certificate from the path specified on docker run command result like follows.

Certificate Path

Copy the path specified on your docker run command and paste it on a browser to download the same. Check the same file on download folder with extension ".cer".

Congrats now you are having self signed certificate to install

Install Certificate

Now we will see how to install this certificate using following following steps and Images

Step 1 : Locate the file and right click. Click on Install Certificate option
Step 2 : Select Local Machine option and click on Next button
Step 3 : Choose Trusted Certificate and press Next to Import the same.
Step 4 : Well done Certificate Installation completed

Certificate Install Step 1 and Step 2

Certificate Install Step 3 - Trusted Certificate Assign

Step 3 : Install AL Extension

So the next steps is to install the AL Extension on Visual Studio Code interface. For doing the same follows below steps

Open Visual Studio Code
Click on Extensions or press (Ctrl + Shift + X)
After that search for "AL Language"
Press Install button to install the same

AL Extension Installation

Step 4 : Install VSIX Extension

VSIX Installations steps explained as follows

Download the VSIX file from docker run command result

vsix file path

Open Visual Studio Code
Open command Palette (view -> Command Palatte or Ctrl + Shift + P)
Enter command as "Extension:Install from VSIX"
Select the VSIX file downloaded via first step of this activity
Press "Install" to complete the same

Congrats you have now successfully complete VSIX file install. Lets continue with next step

Step 5 : launch.json Settings

Now you have to update the connection settings details on Visual studio code to connect both Business Central and Visual studio code together. For that please follow below steps

Copy the Docker run command result with "Dev. Server : " value
Open Visual Studio Code
Locate "launch.json" file
Update the "Server" parameter settings
replace the existing path with new path and save

launch.json file Setup

Congrats now to you have completed the launch.json file setup. Let us continue with last step in this series

Step 6 : Download Symbols

Download symbols steps required to download the object reference details to compile the objects you are going to develop.

Following are the steps to complete the same

Open Visual Studio Code
Open command Palette (view -> Command Palatte or Ctrl + Shift + P)
Enter "AL:Download Symbols" to download the symbols
When system asked for credentials , Enter the User ID = Admin and Password: (this is the password available on Docker run command result, please copy the same and paste it here"
After successfully verified the authorization system will download the symbols.

After successfully Downloaded Symbols can able to confirm Alpackages

After successfully Downloaded Symbols can able to confirm Alpackages mentioned on the above image.

Congrats now you are ready to start the extension development for Business Central. Cheers !!

D 365 Business Central Install using Docker

jubelmundackal@gmail.com (Jubel) — Sun, 23 Sep 2018 20:24:00 +0530

Microsoft Dynamics 365 - Business Central Installation using Docker FREE

Now we can install the Dynamics Business Central / Dynamics NAV versions FREE for Demo and test interface. Yes you heard is right its absolutely Free. In this post I will explain this exciting feature to you.

Before starting this post hope you have aware of Docker software, if not then request you to visit our Docker and Containers for Microsoft Dynamics

How to Install D 365 - Business Central on Local Machine for Free ?

First up all need to understand that from Business Central on-wards Microsoft not providing downloadable setups directly from partner source like earlier routine followed by Microsoft ERP.

Docker is one of the way to setup the Business Central on Local computer. Advantage over normal installation is that it will allow to install and execute multiple CUs parallel in few minutes.

Following are the steps to Setup the Business Central.

Step 1: Install and Activate Docker Software ( If already exist Docker then skip this step )

First step to prepare the interface for Business Central is to install the Docker software. Before start installing docker please understand like other software's Docker too required some basic setups need to enable on system. Those details are as follows

Pre-requisites for Docker Installation

Make sure on BIOS setup activated the Virtual machine feature.

BIOS Setup to enable Virtualization

Activate Container and Microsoft-Hyper-V options on "Turn Windows Features On or Off"

Windows features page

Windows 10 or higher for Laptops and Desktops and Windows 2016 Server or higher for server machines.

Lets start the Docker Installation steps

You can directly download the docker software from Docker or by the help of following scripts

Docker Direct Download Steps

Download Docker.
Double-click InstallDocker.msi to run the installer.
Follow the Install Wizard: accept the license, authorize the installer, and proceed with the install.
Click Finish to launch Docker.
Docker starts automatically.
Docker loads a “Welcome” window giving you tips and access to the Docker documentation.

For more information visit Docker website for Windows 10 docker software
OR
Install Docker using script
Except BIOS setup we can activate the required setup using following script. All you have to do it run this command in Administrator via ISE or Command Promt

Enable-WindowsOptionalFeature -Online -FeatureName Microsoft-Hyper-V, Containers -All

Set-ExecutionPolicy Bypass -Scope Process -Force; iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))

choco feature enable -n allowGlobalConfirmation

choco install visualstudiocode

choco install docker-for-windows

Restart-Computer -Force

Once the Docker is installed it will show like following icon.

Docker Running

Step 2 : Pull Dynamics Business Central Image

This is the first step after Docker installation and activated. By the help of this step we will download the Image for the Dynamics 365 Business Central Image.

For downloading the Docker image you have to copy the following script code and placed on ISE or Command Prompt with Administrator.

docker pull microsoft/bcsandbox:us

Where "docker pull" is the pull command and Image Name to be downloaded is "microsoft/bcsandbox:us". Keyword "us" stands for country. If you remove this system will download w1 version default. Similarly if you have mention "uk" instead of "us" then considered as United Kingdom Business Central Image.

Once the "Pull" command executed it will take sometime to complete the same.

For the Business Central installation it will take download file size as 12 GB approx and after extraction around 16 GB as on August 2018.

Approx time for this activity first time where none of the Dynamics NAV Images available machine is around 3hrs to 6 hrs depend upon network speed. Total file downloading size is 12 GB+

Step 3 : Run Dynamics Business Central Image

You can run and execute the Dynamics Central image as container just have process the command

docker run -e accept_eula=Y -m 3G microsoft/bcsandbox:us

Once it will run then will show the Business Central login credential details like follows

Docker Run Result - for Microsoft D365 Business Central Installation

Approx time for this activity is 2 to 10 minutes

Step 4 : Opening First Dynamics 365 Business Central Application

For opening Business Central using browser. Open any web browser like chrome and enter the URL mentioned on the Web Client mentioned on the above screen. After entering the same system will ask for User ID and Password.

Default User ID for Log in is "admin" and Password you have to check on your command result.

Sample screen after log in to Business Central is as follows

D 365 - Business Central First Page (Sample)

In the upcoming post will explain how to use further.

Enjoy using new Business Central application demo for Free!!.

If you are having further doubts feel free to raise a comment on this page.

Docker and Containers in Microsoft Dynamics

jubelmundackal@gmail.com (Jubel) — Tue, 3 Jul 2018 15:43:00 +0530

Do you know how to install multiple Dynamics NAV / Business Control updates (CU’s) on your system and run simultaneously without using any Virtual Machines?

If not then don’t worry I am here to help you all. You are at the right place to learn now.

You can achieve this by installing new supporting software called Docker. I will explain in these post detailed steps to installing the same and setup.

You will get master on this area by following 2 different posts

Understanding Concepts of Docker and Containers
Installing Docker Software & Dynamics NAV / Business Central using Docker

What is Docker?

I know at this time most of them having question that what is docker and why its required. Keep on reading I will clear your doubts.

Docker is the company driving the container movement and the only container platform provider to address every application across the hybrid cloud. It is also the name of a software handling Containers on Linux and the name of the software which handles containers on Windows.

Before Checking installation of Docker let us understand Containers first.

Docker is the vessel by which container images are packaged and delivered. This automated process produces images (effectively templates) which may then be run anywhere on premises, in the cloud, or on a personal machine as a container.

What are Containers

Containers are a way to wrap up an application into its own isolated box. For the application in its container, it has no knowledge of any other applications or processes that exist outside of its box. Everything the application depends on to run successfully also lives inside this container. Wherever the box may move, the application will always be satisfied because it is bundled up with everything it needs to run.

Please find the following simple explanation provided by Microsoft itself.

Imagine a kitchen. We package up all the appliances and furniture, the pots and pans, the dish soap and hand towels. This is our container. We can now take this container and drop it into whatever host apartment we want, and it will be the same kitchen. All we must do is connecting electricity and water to it, and then we’re clear to start cooking (because we have all the appliances we need!)

Container Example in real life

In much the same way, containers are like this kitchen. There can be different kinds of rooms as well as many of the same kinds of rooms. What matters is that the containers come packaged up with everything they need.

Let us understand Some of the key terms before proceed further

Container Host: Physical or Virtual computer system configured with the Windows Container feature. The container host will run one or more Windows Containers.

Container Image: As modifications are made to a containers file system or registry—such as with software installation—they are captured in a sandbox.

Sandbox: Once a container has been started, all write actions such as file system modifications, registry modifications or software installations are captured in this ‘sandbox’ layer.

Container OS Image: Containers are deployed from images. The container OS image is the first layer in potentially many image layers that make up a container.

Container Repository: Each time a container image is created, the container image and its dependencies are stored in a local repository. These images can be reused many times on the container host. The container images can also be stored in a public or private registry, such as DockerHub, so that they can be used across many different container hosts.

Benefits of Docker / Container

From a developer’s desktop, to a testing machine, to a set of production machines, a Docker image can be created that will deploy identically across any environment in seconds.
Can accommodate n number of product versions & CU’s (Only Dependency is availability of resource on local system).
Low storage space required when we compared with Virtual Machines.

Keep on visit this blog for upcoming post related to this

Dynamics NAV PowerShell

jubelmundackal@gmail.com (Jubel) — Tue, 3 Jul 2018 12:03:00 +0530

Dynamics NAV PowerShell

What is Power Shell?

Built on the .NET Framework, PowerShell is a task-based command-line shell and scripting language; it is designed specifically for system administrators and power-users, to rapidly automate the administration of multiple operating systems (Linux, macOS, Unix, and Windows) and the processes related to the applications that run on those operating systems.

PowerShell is open source

PowerShell base source code is now available in GitHub and open to community contributions.

Examples,

Get-Process - Display all process running on the system

Clear-Host - Clear Display

Microsoft Dynamics NAV Power Shell

Microsoft Dynamics NAV 2016 includes Windows PowerShell cmdlets for administration and for development and file management of application object files and extension packages.

The cmdlets are available in two Windows PowerShell modules:

Microsoft Dynamics NAV 2016 Administration Shell
Microsoft Dynamics NAV 2016 Development Shell

Microsoft Dynamics NAV 2016 Administration Shell

The Microsoft Dynamics NAV 2016 Administration Shell includes cmdlets for administering the Microsoft Dynamics NAV deployment, such as adding and configuring Microsoft Dynamics NAV server instances, databases, and users. Also included are cmdlets for administering extension packages. The Microsoft Dynamics NAV 2016 Administration Shell is installed with the Microsoft Dynamics NAV Server.

Dynamics NAV Powershell

Microsoft Dynamics NAV 2016 Development Shell

The Microsoft Dynamics NAV 2016 Development Shell includes cmdlets for merging and modifying application object files. Also included are cmdlets for creating extension packages. The Microsoft Dynamics NAV 2016 Development Shell is installed with the Microsoft Dynamics NAV Development Environment.

Following are the Dynamics NAV modules paths needs to include while execution on Powershell tools

Microsoft.Dynamics.NAV.Management
Microsoft.Dynamics.NAV.Apps.Management
Microsoft.Dynamics.NAV.Apps.Tools
Microsoft.Dynamics.NAV.Model.Tools

Powershell Tools

By the help of Powersheell tools we are able to create / modify the powershell scripts. This can be done with various tools existing like Windows PowerShell ISE, NAV Administartor, NAV Developmentshell, Visual Studio Code etc.

The cmdlets are implemented in Windows PowerShell 3.0, which is included with Windows Server 2012 and Windows 8 and later.

Windows PowerShell ISE

Integrated Scripting environment
Multiline Editing
Selective Execution
Context-Sensitive Help
Debug
Commands Explorer
Snippets
Don’t accept shortcut parameters

VS Code

Multiline Editing
Selective Execution
Context-Sensitive Help
Debug
Commands Explorer
Snippets
Git Integration

Powershell Tools

Powersheel scripts are stored in ps1 extension.

You can write Your own modules or use modules that already online

Powershell Scripts

To see the cmdlets that are available for Microsoft Dynamics NAV

Get-Command *NAV*

To get Help about syntax and options for a specific cmdlet

Get-Help

Example, Get-Help Get-NAVServerInstance

To get online Help in the MSDN Library for a specific

Cmdlet

Get-Help -online

The sample Windows PowerShell scripts are available in WindowsPowerShellScripts folder on the Microsoft Dynamics NAV product media.
Power Shell Can be found in the NAV Service Folder with “NavAdminTool.ps1”
Copy as Path copying from folder
Press- Shift + Right Click and then select “Copy as Path”

Windows copy as path option

How to use Windows PowerShell ISE ?

Open Windows PowerShell ISE

To open the Windows PowerShell ISE , you have to type ISE or Windows PowerShell ISE search

Once you do then will get following screen (left)

Windows PowerShell ISE

Make sure that you have opening the Windows Power Shell in "Run as Administrator" option to get better result.

Once you open the Windows power shell need make sure right side like windows selected on Windows Power Shell on View menu (This is to make sure all the necessary windows are enabled for view and better understanding only)

Once you complete this first step is over.

2) Import the Module to activate Dynamics NAV commands

Now our step is to Import the NAV cmdlet command via Windows Power Shell

Windows Power Shell ISE screen after NAV Module Import

Set-ExecutionPolicy unrestricted -Force

Import-Module 'C:\Program Files\Microsoft Dynamics NAV\100\Service\NavAdminTool.ps1'

For entering the command you have paste the given the command on white space available on the above screen.

Once you enter the command just press F5 to execute or as mentioned in the image click on to the green symbol with right arrow.

Note above Query is for the Dynamics NAV 2017 version. If you want to perform the same for other versions the please copy corresponding version queries.

Dynamics NAV 2013

Set-ExecutionPolicy unrestricted -Force

Import-Module 'C:\Program Files\Microsoft Dynamics NAV\70\Service\NavAdminTool.ps1'

Dynamics NAV 2013 R2

Set-ExecutionPolicy unrestricted -Force

Import-Module 'C:\Program Files\Microsoft Dynamics NAV\71\Service\NavAdminTool.ps1'

Dynamics NAV 2015

Set-ExecutionPolicy unrestricted -Force

Import-Module 'C:\Program Files\Microsoft Dynamics NAV\80\Service\NavAdminTool.ps1'

Dynamics NAV 2016

Set-ExecutionPolicy unrestricted -Force

Import-Module 'C:\Program Files\Microsoft Dynamics NAV\90\Service\NavAdminTool.ps1'

Dynamics NAV 2017

Set-ExecutionPolicy unrestricted -Force

Import-Module 'C:\Program Files\Microsoft Dynamics NAV\100\Service\NavAdminTool.ps1'

Dynamics NAV 2018

Set-ExecutionPolicy unrestricted -Force

Import-Module 'C:\Program Files\Microsoft Dynamics NAV\110\Service\NavAdminTool.ps1'

Note: given path may different depending upon the NAV installation location

Once you execute the command system will automatically import all the necessary commands details for corresponding NAV version. So its important to import the same version module to achieve the desired the results.

3) Refresh Commands

Refresh commands is the 3rd step. For doing this you have to press Refresh on right side Commands column available on the Windows Power Shell screen.

Once you refreshed system will populate the Dynamics NAV commands for the imported version.

FYI specifying the important commands available with the Windows Power Shell option

Get-NavServerUser - Returns information about all users created in the current Microsoft Dynamics NAV database.

Get-NAVServerUserPermissionSet - Returns permission set information for Microsoft Dynamics NAV users.

New-NAVServerUser - Creates a new Microsoft Dynamics NAV user.

New-NAVServerUserPermissionSet - Assigns a permission set to a Microsoft Dynamics NAV user.

Remove-NAVServerUser - Deletes a Microsoft Dynamics NAV user.

Remove-NAVServerUserPermissionSet - Removes a permission set from the list of permission sets that are assigned to a Microsoft Dynamics NAV user.

Set-NAVServerUser - Changes the configuration settings of an existing Microsoft Dynamics NAV user.

Dynamics NAV User ID Creation and Permission Assign via Power shell

Yes. You can able to create the NAV user id as well as assign permission without log in to the SQL and Dynamics NAV Application.

All you have to do is that have to import the module as described above and enter the power shell command like below.

PS C:\Windows\system32> New-NAVServerUser -ServerInstance navdemo -WindowsAccount navisionplanet\jubel -Confirm -LicenseType Full -State Enabled

PS C:\Windows\system32> New-NAVServerUserPermissionSet -PermissionSetId SUPER -ServerInstance navdemo -WindowsAccount navisionplanet\jubel -CompanyName "Navision Planet" -Force

Replace the following keywords exists on the above script

navdemo : Replace this will NAV Administration module defined NAV Instance Name
navisionplanet\jubel : Replace this with your "Domain Name\ User ID"
SUPER :- Replace this field with Permission ID you would like to add the user.
Navision Planet : Replace this value with NAV Company name would like to add to the user.

SQL Database Restoration via Powershell

Dynamics NAV Powershell Script to Restore one SQL Database is as follows

New-NAVDatabase -DatabaseName DBName -FilePath "SQL db back path to be mentioned here" -DatabaseServer SERVER-INSTANCE -DataFilesDestinationPath "DB Storage Path" -LogFilesDestinationPath "DB Log Path"

Copy the above power shell script and enter on Powershell editor and replace following parameters

DBName: Name of the SQL DB required

SQL db back path to be mentioned here: Specify the fbk file full path

DB Storage Path : Replace this with your new SQL DB path

DB Log Path: Replace this with your new SQL DB Log file path

Sample Powershell restore path is as follows

New-NAVDatabase -DatabaseName testDB -FilePath "D:\NAV Sotware\NAV 2016 W1\CU 24 NAV 2016 W1\NAV.9.0.49326.W1.DVD\SQLDemoDatabase\CommonAppData\Microsoft\Microsoft Dynamics NAV\90\Database\Demo Database NAV (9-0).bak" -DatabaseServer 3ALT15B0053\NAVDEMO -DataFilesDestinationPath "D:\NAV Sotware\test" -LogFilesDestinationPath "D:\NAV Sotware\test\Log"

SQL DB Restore Powershell

GST Setup in Dynamics NAV

jubelmundackal@gmail.com (Jubel) — Fri, 30 Jun 2017 01:43:00 +0530

GST ( Goods and Service Tax - India) Setup in Microsoft Dynamics Dynamics NAV

I know everyone is searching for a good GST material that can help easy GST implementation which required to be done on all the Microsoft Dynamics NAV users across all India. According to Government of India this will be effective from July 01 2017. Hope you already read introduction of GST if not then advised you to please read GST : Goods and Service Tax India

GST Functional User Process Changes in NAV

In this post I am going to explain you GST implementation setups required to be done as per practical experience. According to me GST setups will be very easy if you understand the process and setups in meaningful manner. So let us start one by one.

Summary of setups required to be performed to activate the GST are as follows

GST Accounting Period
GST Sub Accounting Period
G/L Account Creation
States
GST Registration number
GST Component
GST Claim Set off
GST Group
GST Posting Setup
GST Configuration
GST Setup
Vendor
Customer
Item / Fixed Asset
G/L Account Card/Resource/Item Charges
Company Information and Locations Master
Service cost
General Ledger Setup for GST
Structure

GST Accounting Period

GST Accounting Period creation is the very first setups need to done for GST.

GST Accounting Period Setup Page

GST Accounting period setup page looks like above and it can be created via pressing 'New' button available on the top menu list of Home tab.

While clicking this New button system will create new line for you and need to enter starting date of GST Period. It should be between April 01 and March 31 format.

Starting Date : April 01 , 2017 (This is due to your Accounting Period starting date is April 01 -2017)

Ending Date : March 31 , 2018

Please close the GST period for April , May and June for current year (2017) to avoid un-necessary posting.

Year Closed : don't do anything for this

Credit Memo Locking Date: 30-09-2018

Credit memo locking is entered 30-09-2018 due to as per government rule there is a time limitation after GST to create the credit memo when financial year closing happend.

Annual Return Fixed Date: 30-09-2018

Annual return fixed date is the date that which government declared as last date of submitting the returns.

GST Sub Accounting Period

GST Sub Accounting period page is used to define the Month wise definition against the GST Accounting period created on the previous step.

GST Sub Accounting Period

For creating the new "GST Sub Accounting Period" open the GST Accounting Period and go to Action Tab. Then click on to 'Create Sub Period". Enter the details to create the Sub Period values.

Starting Date: July 01 - 2017 (Rest of the years it should be April 01 of corresponding Year)

No of Periods: 9 (Rest of the years it should be 12)

Period Length: 1M

G/L Account Creation

Required to create some GL Account numbers for the tracking of GL Account wise transaction on system for GST transactions.

Under Receivable required following set of account numbers need to create

IGST Rcvble Acc

SGST Rcvble Acc

CGST Rcvble Acc

IGST Rcvble Acc(Interim)

SGST Rcvble Acc(Interim)

CGST Rcvble Acc(Interim)

GST Refund Acc

SGST Rcvbl Acc. Interim(Dist)

CGST Rcvbl Acc. Interim(Dist)

IGST Rcvbl Acc. Interim(Dist)

CGST Rcvbl Acc. (Dist)

SGST Rcvbl Acc. (Dist)

IGST Rcvbl Acc. (Dist)

Under Expense / Payable required following set of account numbers need to create

IGST Payable Acc

SGST Payable Acc

CGST Payable Acc

IGST Payable Acc(Interim)

SGST Payable Acc(Interim)

CGST Payable Acc(Interim)

GST Expense Acc

GL Account Creation process please refer our Account Number creation post.

Purpose each account will explain during next setups and upcoming process training post.

States

For setting up State Code ( GST Reg. No) need to open State page and then enter the 2 digits unique State code for GST creation purpose. GST Registration Process explained as next step.

State Page : State Code ( GST Reg. No)

GST Registration number

Registration Number under GST is called Goods and Service Tax Payer Identification Number (GSTIN).

GST Registration Number

First 2 Digits should be State Code

3 to 12 digit Should mention PAN number of the company. That means if one company having 3 location registered under different PAN number then need to maintain different GST number.

13th Digit should mention Entity Code

14th digit should enter the Check Digit Code

15th digit should enter the Blank

GST Component

GST Component is used to define the components of GST like CGST, IGST and SGST etc.

GST Component : Setup

Create the setup one by one by clicking the New button. Enter the details in following manner

CGST
IGST
SGST

You should enter the setup just like mentioned on above image.

GST Claim Set off

For doing the GST Claim set off setup required to open the GST Component Page first and then click on to 'Get Claim Set off' button.

GST Claim Setoff

For creating the GST Claim setoff page should follow below setup format

CGST Component

GST Component Code: CGST

Set Off Component Code: IGST

Priority: 1

IGST Component

In this required 2 line setup

GST Component Code: IGST

Set Off Component Code: CGST

Priority: 1

GST Component Code: IGST

Set Off Component Code: SGST

Priority: 2

SGST Component

GST Component Code: SGST

Set Off Component Code: IGST

Priority: 1

GST Group

GST group is the place where Goods and Services of similar nature are grouped. Each group is assigned a group code. Remember by the help of this code only creating the actual GST setup. This page will look like following.

GST Group Setup

For any GST Group, if the Place of Supply is different from what is defined in GST Dependency Type, then the same can be defined in GST Group Setup. If for a GST group, Place of Supply is defined in GST Group Setup, then the same flows to GST Place of Supply field in Sales lines. If it is not defined, then GST Dependency Type shall flow to GST Place of Supply field in Sales lines. This GST Place of Supply field in Sales lines is a user editable field.

System validates shipping location state code and place of supply state code with GST configuration setup for any matching line and triggers the tax accordingly.
Example: For Advertising Services, if Place of Supply is Ship to Address and the same is defined in GST Group, then GST Place of Supply field in Sales lines is auto-populated with Ship to Address. If the ship to address is, Karnataka and the shipping location is Tamilnadu, and then system checks for matching line in the GST configuration set-up and triggers the tax rate accordingly.
Place of Supply can also be defined for each GST Group. Place of Supply is critical in determining whether it is an interstate sale or intrastate sale. Place of Supply can be Bill to Address, Ship to Address or Location address.
If Place of Supply is not defined in the GST Group, then system considers GST Dependency type defined in Sales and Receivable Set-up as Place of Supply.

GST Posting Setup

General Ledger Account for each component is defined state-wise here. Sample image of GST Posting Setup is as follows.

GST Posting Setup

Following setups needs to setup on GST Posting Setup of Dynamics NAV.

State Code
GST Component Code
Receivable Account
Payable Account
Receivable Account (Interim)
Payables Account (Interim)
Expense Account
Refund Account
Receivable Acc. Interim (Dist)
Receivable Acc. (Dist)

GST Configuration

This setup aids the system in determining the taxable state based upon

Dispatching state code and customer state code for Sales
Receiving state code and vendor state code for Purchases
Determining the taxable jurisdiction enables the system to pick up the tax percentage applicable.
For an export transaction, customer is located outside the country hence customer state code is blank. For an import transaction, vendor state code shall be blank, as vendor is located outside the country.

GST Configuration

GST Setup

The percentage and effective date for each GST component is defined state-wise here.

If GST State Code is blank, then percentage and effective date defined for a GST Component is applicable for all states where there is no specific entry for such GST Group. For example, if Advertising Service has a uniform CGST rate in all states except Delhi, then instead of defining it for each state, it can be defined only once keeping state code as blank. A separate line can be created for Delhi state with Delhi specific percentage.

GST Setup

Vendor

Vendor Page with Tax Information having option to define the GST setups

Vendor Setup - GST

GST Registration No : under this field select the GST Registration number of Vendor

GST Vendor Type:

Registered
Composite
Unregistered
Import
Exempted

Registered

A Registered Vendor is a person registered with GST authorities.

Composite

A Composite Vendor is a vendor whose aggregate turnover in a financial year does not exceed fifty lakh rupees and has opted for Composition scheme. A composite vendor neither collects tax from the recipient of supplies nor passes on any credit of Input Tax. Hence, no GST is computed if the purchases are made from a composite vendor.
A composite vendor has to register himself with the GST authorities and hence Registration No. is mandatory in Vendor Card, if the Vendor Type is selected as Composite. State Code is also mandatory.
A composite vendor cannot be engaged in supply of services and cannot make inter-state supplies of goods. However, system allows interstate purchases from a composite vendor and service purchase

Unregistered

Persons whose aggregate turnover in a financial year does not exceed twenty lakh rupees are not required to be registered with the GST authorities. Such persons are called Unregistered Vendors. Any purchases from unregistered vendors attract Reverse Charge i.e. the purchasers themselves has to pay tax to the government.
Interstate purchases from an unregistered vendor shall not arise, as any person irrespective of his turnover has to register with the authorities, if he is making an interstate sale.
GST Vendor Type shall be unregistered in Vendor Card to handle this scenario. State code and GST Registration numbers are not mandatory fields for an unregistered Vendor.
The purchasing user has to issue self-invoices under GST, if the purchases are made from an unregistered vendor. The user can issue a self-invoice in the system by selecting self-invoice from the dropdown of Invoice type in Tax Information tab of purchase documents.

Import

Bringing goods to India from a place outside India is import of goods. For Services, if the supplier is located outside India, the recipient is located in India and the place of supply is in India, then it is called Import of services.
Purchase of goods and/or services from a foreign vendor is subject to Reverse Charge i.e. the person importing goods or services has to remit tax to the government. Import of goods are subject to both customs duty and IGST whereas import of services are subject to IGST. There is another scenario of importing services from associated enterprises. Accounting Entries differ in each scenario.
GST Vendor Type shall be Import in Vendor Card for a foreign vendor. Registration Number and State Code are not mandatory fields in Vendor Card.

Exempted

A vendor who is exempted from payment of GST either by Central or State GST authorities is known as Exempted Vendor. An exempted vendor neither collects tax from customers nor pays any tax to the government. No GST Entries are generated in the system, if GST Vendor Type is exempted.
This vendor type can also be used to handle a scenario where purchase of only certain goods and services from an Unregistered Vendor is subject to reverse charge and the remaining are exempted. (Law is not clear as of now). State Code and Registration No. are not mandatory for the exempted vendor in Vendor Card.

Customer

Customer master page with Tax Information having option to define the GST setups

Customer GST Setup

GST Customer Type : Customer type can be Registered, Unregistered, Export, Deemed Export or Exempted. User has to select the appropriate Customer type from the dropdown.

GST Registration Type : Registration type can be GSTIN (Goods and Services Tax Payer Identification Number), UID (Unique Identification Number), and GID (Government Identification Number). Appropriate type shall be selected from the dropdown.

GST Registration No. : The 15-digit GST Registration Number shall be entered here. Registration number is mandatory if GST Customer Type is Registered or Deemed Export.

E-Commerce Operator : This field is activated

Item Master/Fixed Asset Master

GST Group Code : GST Group code relevant for the item/Fixed asset shall be selected here. GST Group codes created in GST Group Setup appears as dropdown here.

GST Credit : GST Credit can be Availment or Non-Availment. This field by default displays Availment. If credit cannot be availed on any item/fixed asset, then Non-Availment shall be selected manually from the drop down.

HSN/SAC Code: All HSN Codes for GST Group code selected above shall be displayed as a dropdown for this field. User has to select appropriate HSN code.

Exempted: This field is checked if the item is exempted from payment of tax.

G/L Account Card/Resource/Item Charges

GST Group Code : GST Group code relevant for Service/Resource/Item charge shall be selected here. GST Group codes created in GST Group Setup appears as a dropdown here.

GST Credit: GST Credit can be Availment or Non-Availment. This field by default displays Availment. If credit cannot be availed on any service, then NonAvailment shall be selected manually from the drop down.

HSN/SAC Code: All SAC Codes for GST Group code selected above shall be displayed as a dropdown for this field. User has to select appropriate SAC code.

Exempted: This field is activated if the Service/Resource/Item charge is exempted from payment of tax.

Company Information and Locations Master

GST Registration No. : The 15-digit GST Registration Number shall be entered here.

GST Input Service Distributor : This field is an automatically activated Field, if Input Service Distributor is activated in GST Registration Nos

Service cost

GST Group Code : GST Group code relevant for the service shall be selected here. GST Group codes created in GST Group Setup appears as dropdown here.

HSN/SAC Code: All SAC Codes for GST Group code selected above shall be display as dropdown for this field. User has to select appropriate SAC code.

Exempted: This field is activated if the Service is exempted from payment of tax.

General Ledger Setup for GST

GL Setup also required some setup to work the GST functionality properly. GL Setup will look like following section added after GST in India.

General Ledger Setup for GST

Following are the new fields and its definition

GST Rounding Precision: This is used to define the GST rounding precision for the trasactions.

GST Rounding Type: Here you can define the type of rounding precision working. You are having options of Nearest , Up and Down. That means if you have specified rounding precision as 0.5 and Nearest as Rounding type then system always try to bring the value to the nearest possible digit.

IGST Payable A/C [Import]: Here you have to specify the IGST Payable Import account number.

GST Recon. Tolerance: Max tolerance allows in GST.

GST Distribution Nos and Distribution Invoice Nos are number series to handle the same.

Structure

GST Calculation required all new Structure setup as well. Following image showing sample Structure for the GST structure.

GST TAX Structure

Structure Details

Structure details line having following setups required to calculate GST

Type: GST

Tax / Charge Code: GST

Also required following field with select True

Include Base , Include Line Discount , Include Invoice Discount

Keep on visit Navision Planet for latest updates and training documents for GST and latest changes in Microsoft Dynamics NAV.

GST Process Changes in NAV

jubelmundackal@gmail.com (Jubel) — Fri, 23 Jun 2017 01:10:00 +0530

How to process various documents after GST ?

This is major question arrived on various Customers and consultants. During this post our aim is to simply the GST user process to all our viewers.

Suggested you to read following 2 Chapters before start reading current page for easy understanding.

How to check whether the GST functionality available on any Dynamics NAV / Navision?

For checking whether your system having GST or not just enter "GST" in search box. Once you entered the details will show you following set of result

GST Pages , Reports etc showing when entered 'GST'

If you are not able to view anything here then please coordinate with your partner and resolve the issue. If the GST patch not yet uploaded then, required to download latest Indian Localisation objects and merge.

Number of documents affected the GST Tax Changes are as follows

Purchase Order
Purchase Invoice
Purchase Credit Memo
Transfer Documents
Sub-Contracting Orders
Sales Orders
Sales Invoices
Sales Credit Memo

Purchase Order : GST

If you are a purchase order creating person then you may say that there is not much change found after GST. Just changed the tax structure for GST and calculated the tax.

GST Impact - Purchase Order Page

But in practical if we do analysis of this document then, you will see several additional fields added on the Purchase Line, Purchase Statistics Page and Structure with GST selected. These new fields are came from Item Master and Vendor Masters. As I told all earlier Purchase Order having several type of transactions like Registered, Un registered, Composite , Import and Exempted.

All the following fields are automatically coming or calculated during the Calculate Structure (Alt + U + U) available on Purchase Order.
GST % : This field will show the actual GST calculated based upon the setup
Total GST Amount: This will show total GST amount calculated on Line.
GST Group Code: This is place where you can mention type of Goods you are purchasing like Goods, Service etc. You can divide your goods into different naming methodology to accomodate different type of tax structure exist for your goods.
GST Jurisdiction: Will show Interstate or Intrastate based on the Purchase happening
GST Credit: This will show whether the credit available for this purchase or not.
Purchase Order Statics Page Changes Highlighted in following image

GST Impact : Purchase Order Statics Page

Purchase Order Statics page opening via F7 are shown above where added new field GST Amount. This field will show GST Amount calculated based upon the setups.

Following purchase scenarios exist on GST.

GST Purchase Scenarios

Registered Vendor
Composite Vendor
Unregistered Vendor
Exempted Vendor
Foreign Vendor

General Imports
Imports From Associated Enterprises

Intrastate Registered Vendor Purchase Scenario

For creating the Purchase Order there is no difference but careful thing you have to notice is Microsoft Dynamics NAV - Vendor Card you have to mention following GST setups mandatory

Vendor Page with Tax Information having option to define the GST setups

Vendor Setup - GST

GST Registration No : under this field select the GST Registration number of Vendor

GST Vendor Type: Registered

Also need to verify whether the Vendor having state code same as that of Location Code.

After creating the purchase order will look like following

GST Registered Vendor PO Screen

You have press "Calculate Structure Values" to reflect the proper tax rate.

Note: Structure value, GST related values like GST % reflecting in the line etc.

Once you press Statistics Page will look like following

Purchase Statistics Page GST

Next purchase processes not having any differences before payment posting.

Purchase Invoice and Purchase Credit Memo you can follow similar process. Always check GST amount before posting.
If are still can't able to calculate the tax then do comment on this post we will help you.

To be continued... Please visit this page further process changes related to GST.

You do not have access to Microsoft Dynamics NAV Error

jubelmundackal@gmail.com (Jubel) — Fri, 23 Jun 2017 00:00:00 +0530

Add User to Microsoft Dynamics NAV 2017 Database or Lower

NAV Error Message

Are you getting following error on Dynamics NAV

"You do not have access to Microsoft Dynamics NAV. Verify that you have been setup as a Valid user in Dynamics NAV"

Dynamics NAV RTC Open Error Message

[error title="Error message" icon="exclamation-circle"] You do not have access to Microsoft Dynamics NAV. Verify that you have been setup as a Valid user in Dynamics NAV [/error]

This error may arrived on any of the following NAV versions

Microsoft Dynamics NAV 2013 (7.0)
Microsoft Dynamics NAV 2013 R2 (7.1)
Microsoft Dynamics NAV 2015 (8.0)
Microsoft Dynamics NAV 2016 (9.0)
Microsoft Dynamics NAV 2017 (10.0)

Route Cause

You have restored database on a server where the actual list available on the Dynamics NAV not exist.

For example, You have taken the DB backup from a Live Server where following User IDs exist

User ID 1 or Domain / User ID 1
User ID 2 or Domain / User ID 2

But the on the restoring server domain login not equal to both.

On Test Server / Restored server exist only User ID 3 or Domain / User ID 3

Resolution

Most of the times when you have tried to add the user in the SQL then also issue not resolved. This is due to failure of one of the following required security requirement.

SQL Server not user to DB restored
Dynamics NAV not having windows login of login-ed system.

For resetting the User Related tables data use the following method to delete the same via SQL (Easiest Method)

For opening the SQL Server - Type "ssms" in run command and open SQL server management studio.
SQL Query

USE [Your New Database Name]
GO
delete from [dbo].[User]
delete from [dbo].[Access Control]
delete from [dbo].[User Property]
delete from [dbo].[Page Data Personalization]
delete from [dbo].[User Default Style Sheet]
delete from [dbo].[User Metadata]
delete from [dbo].[User Personalization]

Where Your New Database Name should replace with your database name. If your database name is "Demo Database NAV (7-1)" then use following code on first line

USE [Demo Database NAV (7-1)]
Then press Ctrl + N open the SQL Query page and paste the above code and Execute.

Caution: Once you execute this all user related records will delete. You have recreate the same
Once you have done this please process following steps as well.

Please try to reopen the Dynamics NAV.

Some times still issue will not resolve then please follow below steps as well.

Solution Summary as follows.

You will get the permanent solution in following 4 Steps

Open Windows PowerShell ISE
Import the Module to activate Dynamics NAV commands
Refresh Commands
Create New User ID via Power shell
Assign new Permissions to newly created User ID

1) Open Windows PowerShell ISE