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