Microsoft Dynamics NAV By Binesh & Shilpa: Tips & Tricks

*Create Services in NAV 2009 R2**

Link : https://msdn.microsoft.com/en-in/library/dd301437.aspx

-----------Create Services in NAV 2009 R2-------------

SC CREATE "MicrosoftDynamicsNAV$Svr2" binpath= "C:\Program Files (x86)\Microsoft Dynamics NAV\60\Service2\Microsoft.Dynamics.Nav.Server.exe" DisplayName= "MSD Shipping Service"

-----------Create Web Services in NAV 2009 R2-------------

SC CREATE "MicrosoftDynamicsNAVWS$Svr2" binpath= "C:\Program Files (x86)\Microsoft Dynamics NAV\60\Service2\Microsoft.Dynamics.Nav.Server.exe $Svr2" DisplayName= "MSD Shipping Web Service" type= share

-----------Delete Services in NAV 2009 R2-------------

SC DELETE "MicrosoftDynamicsNAV$Svr2"

-----------Delete Web Services in NAV 2009 R2-------------

SC DELETE MicrosoftDynamicsNAVWS$Svr2

-----------------For Demo/BCW--------------

-----------Create Services in NAV 2009 R2-------------

SC CREATE "MicrosoftDynamicsNAV$Svr2" binpath= "C:\Program Files (x86)\Microsoft Dynamics NAV\60\Service2\Microsoft.Dynamics.Nav.Server.exe" DisplayName= "BCW"

-----------Create Web Services in NAV 2009 R2-------------

SC CREATE "MicrosoftDynamicsNAVWS$Svr2" binpath= "C:\Program Files (x86)\Microsoft Dynamics NAV\60\Service2\Microsoft.Dynamics.Nav.Server.exe $Svr2" DisplayName= "BCW Web" type= share

--------------Custome.Config---- file changing---

Change Your Database

Change serverInstance : BCW

Change Port No.

------------------------------END--------------------------------------

----------------DECSTR----------------------

Hi all,

Today i came across with different type of requirement.

Already we familiar with INCSTR standard function in NAV.

INCSTR -> Increases a positive number or decrease a negative number inside a string by one (1).

Now we want to Decreases a positive number inside a string by one (1).

To achieve this requirement I wrote a function DECSTR.

See the bellow screenshot for full function.

--------------END---------------

NAV 2016 Keyboard Shortcuts

--------------END---------------

-----Merge Excel Cells Using DotNet Variables------

Using Automation variable we easily merged excel cells, but automation has some limitations, To overcome this i used dotnet variables and merged cells in excel.

See the bellow screenshot for solution.

--------------END---------------

How to Install Windows 8.1 – Instructions with Screenshots

· Step 1: Place your windows 8.1 DVD in the DVD ROM or plug in your Windows 8.1 boot-able USB flash drive and restart your PC . We have used a boot-able USB flash drive to install windows 8.1 in this guide .

· Step 2: When your PC reboots , Enter your PC’s Bios settings and set your installation media as the first boot priority . Now save your bios settings and restart your PC . Alternatively press F11 to bring up the boot media selector and select the boot-able USB flash drive .

· Step 3: When your PC restarts you will be prompted to press any key to boot from your installation media . Press any key to continue .

· Step 4: You will see the following loading screen with a rotating progress bar . Wait for a few seconds till the necessary files are loaded.

· Step 5: Next you will see the following screen , where you will have to select the language , time and currency format and keyboard layout . choose your required settings and click on next .

· Step 6: On the next screen click on “install now” after which you need to wait for a few minutes for the setup process to start.

· Step 7: Now you will be prompted to enter your Windows 8.1 product key , you can either use your windows 8 activation key or the product key that came with windows 8.1 . Enter your product key correctly and click on next.

Note: Some OS/Crack DVD the product key is patched that time it won't ask.

· Step 8: Read the license terms thoroughly before you continue to install windows 8.1 on your PC . When its done click on next to proceed with the windows 8.1 installation.

· Step 9: On the next screen choose the type of your installation , since we are doing a clean install select the second option , which is custom : install windows only ( Advanced ).

· Step 10: Next you will be required to select a drive to install windows 8.1 , you can either format a drive and install windows 8.1 on it , or directly install windows 8.1 within the existing space in a drive . If you are going to use windows 8.1 as your primary OS then format your existing windows 7 drive , select it and click next to start installing windows 8.1 on it.

· Step 11: Now wait for the installation process to complete , this might take more than 10 minutes in most cases . in case you are using a SSD this process will be much faster.

· Step 12: When the installation process complete, your PC will be reboot automatically and boot into windows 8.1 and you will see various progress bars. After a few minutes your PC will reboot again.

· Step 13: Now windows 8.1 is almost installed on your PC, the last thing you need to do is personalize a few settings and you will be able to use windows 8.1 . Also you need to sign in into your Microsoft account to be able to take advantage of the windows app store.

· Step 14: After you are done with all the settings, you will see the ” getting ready screen ” . just a few minutes more and you will see the familiar windows 8.1 start screen and your PC is all ready for the windows 8.1 experience .