Sep 13, 2016

Add New Users Dynamics NAV 2013,2013 R2, 2015, 2016


This Powershell Script can insert multiple users to Dynamics NAV DB at once. 


  • Start "Windows PowerShell ISE" with Administrator permissions.
  • Copy following script from start to end & past in "Script Pane".
  • If "Script Pane" is not visible go to View -> "Show Script Pane"




  • Add User Name(s) & NAV Service Instance.
  • Separate User Names with Commas. 
    • $WindowsUser = "<Domain>\<User>","<Domain>\<User>"
    • $ServerInstance = "<Instencs Name>"
  • Set the path to NavAdminTool.
    • import-module "C:\Program Files\Microsoft Dynamics NAV\90\Service\NavAdminTool.ps1"
  • Run the script.


Sep 12, 2016

Name format when exporting Objects from Dynamics NAV


This tool makes it easy to get object names when exporting objects from development environment.

Download and extract the file.
Rename - CopyPast.nav to - CopyPast.exe
 Download Seuup


Convert Numeric Amount to Text in Dunamics NAV

This is done using stranded code taken  from Report-1401-Check.
Modification done mainly to get the Cents value from text. And includes some other formatting options.

Call the function "FormatNoText" with following  parameters
"NoText"               Text(80) array length of 3 which returns the text.
"No"                      Amount or the number needs to be converted.
"CurrencyCode"  Currency Code if any, if not keep it blank.
"IsUpperCase"     if "TRUE" text will return in UPPERCASE, if "FALSE" first letter of                                                                 each word in UPPERCASE.
"StartStar"           if "TRUE", "***" will print at the begin.
"EndStar"             if "TRUE", "***" will print at the end.

This funtion use "AddToNoText" & "GetAmtDecimalPosition" local functions.
Complete Code is given bellow