Monday, October 6, 2014

Browse folder for Classic and RTC

Hi,

Browse folder in classic version using automation


  • It is look like as below





















  • On Assist edit of trigger write the following code




ExpMgt_lCdu.SelectFolderClassic_gFnc("Export Directory");

  • SelectFolderClassic_gFnc - Function code












IF ISCLEAR(WindowsShell_lAut) THEN
  IF NOT CREATE(WindowsShell_lAut) THEN
    EXIT;

SelectedFolder_lAut := WindowsShell_lAut.BrowseForFolder(0,FolderName_vTxt,1,'');

IF NOT ISCLEAR(SelectedFolder_lAut) THEN BEGIN
  FolderItem_lAut := SelectedFolder_lAut.Self;
  IF FolderItem_lAut.Path <> '' THEN
    FolderName_vTxt := FolderItem_lAut.Path;
END;

  • Pass the parameter by pass by reference 




  • Following variable is created for automation object






Name
DataType
Subtype
Length
WindowsShell_lAut
Automation
'Microsoft Shell Controls And Automation'.Shell

SelectedFolder_lAut
Automation
'Microsoft Shell Controls And Automation'.Folder2

FolderItem_lAut
Automation
'Microsoft Shell Controls And Automation'.FolderItem


Done !!


Browse folder in RTC version using DotNet Variable:


  • It is look like


























  • Call the browse folder function from assite edit trigger on field in page




  • Write the following function
















FolderBrowser_lDnt := FolderBrowser_lDnt.FolderBrowserDialog();
FolderBrowser_lDnt.ShowNewFolderButton := TRUE;
FolderBrowser_lDnt.Description := Text000_gCtx;
FolderBrowser_lDnt.ShowDialog();
IF FolderBrowser_lDnt.SelectedPath <> '' THEN
  FolderName_vTxt := FolderBrowser_lDnt.SelectedPath;


  • Pass the folder path by reference





  • Create the following variable
















Name
DataType
Subtype
FolderBrowser_lDnt
DotNet
'System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Windows.Forms.FolderBrowserDialog

  • Create one Text Constant use in above code







Name
ConstValue
Text000_gCtx
Select a Folder...

Done !!

Thursday, October 2, 2014

Indian Localization Manual - RTC Client

Hi,

NAV Manual for following Indian Localization:

• STRUCTURE
• EXCISE
• SERVICE TAX
• VALUE ADDED TAX/SALES TAX
• TAX DEDUCTION AT SOURCE
• TAX COLLECTION AT SOURCE
• TDS CERTIFICATE RECEIVABLE FROM CUSTOMER
• FIXED ASSETS
• PRICE INCLUSIVE OF TAX
• MULTI LOCATION NO. SERIES
• VOUCHER INTERFACE
• GATE ENTRY
• STALE CHEQUE
• SUBCONTRACTING
• LETTER OF CREDIT (LC)


Please download the manual zip file (42 MB) from Microsoft website (go to India SP1):
https://mbs.microsoft.com/partnersource/northamerica/readiness-training/student-training-materials/course80041

Create RTC Service using Powershell and cmd

Hi,

Steps to create RTC service for NAV 2013/ NAV 2013 R2/ NAV 2015
It is very helpful to create different Navision instances for different Build versions:

  • Open power shell by run as administrator and run following command
New-Service -Name 'MicrosoftDynamicsNAVServer$DynamicsNAV71B37221' -BinaryPathName '"C:\Program Files\Microsoft Dynamics NAV\71\ServiceB37221\Microsoft.Dynamics.Nav.Server.exe" $DynamicsNAV71B37221 /config "C:\Program Files\Microsoft Dynamics NAV\71\ServiceB37221\Microsoft.Dynamics.NAV.Server.exe.config"' -DependsOn 'NetTcpPortSharing' -Description 'Service handling DynamicsNAV71B37221' -DisplayName 'Microsoft Dynamics NAV 71 Server[Rollup 9]' -StartupType Manual


























  • Start the following standard portsharing service to use port sharing (if it is not started)
Net.Tcp Port Sharing Service









  • Enable port sharing for new service by using following command in cmd (run as administrator)
sc.exe config MicrosoftDynamicsNAVServer$DynamicsNAV71B37221 depend= HTTP/NetTcpPortSharing


















  • Change the login user in service and set the proper service user



















  • Check the custom setting file and check the database name, server name,service instance name,etc than after start the service
  • Check the event log if any problem in service starting

Tips: to identify the client and server exe by name

1) Client exe always exists in: “Program Files (x86)” folder with name
    C:\Program Files (x86)\Microsoft Dynamics NAV\70\RoleTailored Client\Microsoft.Dynamics.Nav.Client.exe

2) Server exe always exists in: “Program Files” folder with name
    C:\Program Files\Microsoft Dynamics NAV\70\Service\Microsoft.Dynamics.Nav.Server.exe

Client folder is use for – open development environment and RTC Client
Service folder is use for – create the service for that version with build


Tips: Start the port sharing of any service using following command

Start the cmd by run as administrator  
sc.exe config MicrosoftDynamicsNavServer$DynamicsNAV71_B37534 depend= HTTP/NetTcpPortSharing


Tips: Delete the service using command prompt

Start the cmd by run as administrator
Run the following command
sc delete "NILESHGAJJAR-CLASSIC"


--------------------------------------------------------------------------------------------------------------------------


Steps to create RTC service for NAV 2009 / NAV 2009 SP1 / NAV 2009 R2

  • Run cmd by administrator and run the following command
SC CREATE "MicrosoftDynamicsNavServer$Svr3" binpath= "C:\Program Files (x86)\Microsoft Dynamics NAV\60\ServiceNAV2009R2\Microsoft.Dynamics.Nav.Server.exe" start= auto obj= "NT Authority\NetworkService" DisplayName= "Microsoft Dynamics NAV NAV 2009 R2"




















Default Start up RTC Service path in NAV 2009 R2 is like
localhost:7046/DynamicsNAV