MS Dynamics NAV (using c/front)
MS Dynamics NAV can be accessed in different ways depending on which version you are using. You can use C/Front to access MS Dynamics NAV on the database level (with support for Flow Fields etc.) or you can use our NAS Connector or finally you can use our MS Dynamics NAV Web Services.
If you have MS Dynamics NAV 2013 or later, please use our MS Dynamics NAV SQL connector.
For MS Dynamics 365 Business Central and MS Dynamics NAV 2016 or later, please use our MS Dynamics NAV ODATA connector.
The following versions of Navision are supported
- MS Dynamics NAV 2009 (also R2)
- MS Dynamics NAV 5.0 and 5.0 SP1
- MBS-Navision 3.70 and 4.0, 4.0 SP1 and 4.0 SP2
- Navision Attain 3.0, 3.10 and 3.60
- Navision Financials 1.30, 2.00, 2.01, 2.50, 2.60d
- C/Front - you need the C/Front module in your license (fin.flf)
- Rapidi will take up 1 session (user) in MS Dynamics NAV when running transfers.
- You might need additional Web Access or External access licenses from Microsoft - please check your license conditions for this.
- In order for Rapidi to connect to your local database server, you need to download and install a small service, that we call the
MS Dynamics NAV Client Installation & Configuration
- You need to have an MS Dynamics NAV client installed on the computer/server where the RapidiConnector is installed.
- Additionally, copy the following files to the MS Dynamics NAV client directory:
- fin.flf (NAV license file - must have c/front access)
- cfrontsql.dll - if you are running NAV on SQL server
- cfront.dll - if you are running NAV on native server
The fields of the MS Dynamics NAV Connection are described as follows:
- Description: Enter a text describing the Data Source.
- Driver: Select if your MS Dynamics NAV is on an MS-SQL Server or a Native C/Side Server.
- Network Protocol: Specify if the network protocol is TCP/IP (apply "tcp") or NetBIOS (apply "netb"). If the database is on an MS-SQL Server, this parameter is specified as "TCP/IP Sockets" or "default".
- Server Connect: Specify the name of the server hosting the database. In some cases, it also works to specify the TCP/IP address. If the database is on an MS-SQL, this is the MS-SQL Server name.
- Database Path: If the database is a local database you leave the fields "Server Connect" and "Network Protocol" blank and specify the exact location of the local database here (path and name). If the database is situated on an MS-SQL Server or NAV server, then specify just the name of the database here.
- Account: Enter the Account Name (Company name) here.
PLEASE NOTE: Account is CASE SENSITIVE.
- Use Windows Authentication: If you use the same UserID and Password to access the database as for when logging on to your Windows, you can mark this field. Please note that it is the windows user that you installed and run the RapidiConnector under, that will be used. If you do this then the fields UserID and Password are ignored.
PLEASE NOTE: "Use Windows Authentication" is only valid from version 2.50 of Navision Financials.
- User ID: If access to the database requires a UserID you have to specify the UserID here.
- Password: If you enter a UserID the corresponding Password is applied here.
- Use Codeunits Permissions: Here you can specify the number of a codeunit in NAV that has been set up with extra permissions to write to some tables. On the codeunits properties, you have to check the "C/Front May Use Permissions" box. Use this to give Rapidi access to write to for example Sales Invoice Lines and Sales Cr.Memo Lines.
- Installation Path: Specify the path to the directory of your MS Dynamics NAV Client (for example: "c:\program files\Navision"). Note that this is on the computer where the RapidiConnector is installed.
Test and Read Design
- You can Test that the access to a Connection works using the Test button on the Connection.
- Login to MyRapidi. Click the
- Read Design is the way to read the layout - the information about tables and fields - from a Connection. Reading the design is