1 17000077826 2016-12-07T09:25:06-07:00 17000122157 false Installation 5 2016-12-13T10:39:18-07:00 1 1 2016-12-06T13:56:30-07:00 0 0 For Classic Client versions of NAV.  NAV 2016 and Later we recommend using the copy company function. NOTE: The attached document contains screenshots for the below instructions. Creating a Test Company in a Navision Database These instructions are meant to be a step-by-step guide to creating a test company within the Navision Database.  Test companies are useful as a training resource and for testing Navision functionality without affecting live data.  Test companies are created using current data from the main company within a database.  It is recommended to update Test Company data periodically as transactions are not duplicated across companies. Creating a Test Company Before starting: . Ensure user creating the test company is a SUPERUSER . Ensure all other users are logged out of Navision during this procedure Only a SUPERUSER has the permission to complete all steps.  All other users must be logged out to guarantee no data is lost during test company creation. Step 1: Make backup of entire database and all companies NOTE: Make sure again all users are logged out of Navision . Tools > Backup . Select: Entire Database Selected Companies Check ALL companies listed Data Common to All Companies Application Objects Description: .fbk File Name: Save to backup location with same name as above . OK . After the backup runs successfully a confirmation message will appear . OK Step 2: Rename Main Company to TEST Company Rename the Main Company (or company with data to copy into Test Company) . File > Company > Open . Select the Main Company (or company with data to copy into Test Company) . OK Double-check that the Company name in the top left Header is the correct company . File > Company > Rename . Type in "TEST Company" in New Company Name in Rename Company table . OK Double-check that the Company name in the top left Header is the new TEST company name Step 3: Restore Main Company Restoring the main company from the database backup will automatically create "another" company.  This will have the same information as the Test Company.  Navision wouldn't allow 2 companies to have the same name in a database.  If the main company hasn't been renamed to Test Company (Or another name) then an error will prevent this next step. . Tools > Restore . Locate database just backed up . OK . Select Custom Backup Selected Companies  Check only the main company just renamed into Test Company . OK There should now be a Test Company, Main Company, and any other companies setup up in Navision.  The Test Company will have most current date and ready to use. <div dir="ltr"> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">For Classic Client versions of NAV.  NAV 2016 and Later we recommend using the copy company function.</p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">NOTE: The attached document contains screenshots for the below instructions.</p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><u style="box-sizing: border-box;"><strong style="box-sizing: border-box;">Creating a Test Company in a Navision Database</strong></u></p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">These instructions are meant to be a step-by-step guide to creating a test company within the Navision Database.  Test companies are useful as a training resource and for testing Navision functionality without affecting live data.  Test companies are created using current data from the main company within a database.  It is recommended to update Test Company data periodically as transactions are not duplicated across companies.</p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">Creating a Test Company</strong></p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">Before starting:</p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">. Ensure user creating the test company is a SUPERUSER<br style="box-sizing: border-box;">. Ensure all other users are logged out of Navision during this procedure</p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">Only a SUPERUSER has the permission to complete all steps.  All other users must be logged out to guarantee no data is lost during test company creation.</p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><u style="box-sizing: border-box;">Step 1: Make backup of entire database and all companies</u></p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">NOTE: Make sure again all users are logged out of Navision</p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">. Tools &gt; Backup<br style="box-sizing: border-box;">. Select:</p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">Entire Database</p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">Selected Companies<br style="box-sizing: border-box;">Check ALL companies listed<br style="box-sizing: border-box;">Data Common to All Companies<br style="box-sizing: border-box;">Application Objects</p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">Description: .fbk<br style="box-sizing: border-box;">File Name: Save to backup location with same name as above</p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">. OK<br style="box-sizing: border-box;">. After the backup runs successfully a confirmation message will appear<br style="box-sizing: border-box;">. OK</p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><u style="box-sizing: border-box;">Step 2: Rename Main Company to TEST Company</u></p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">Rename the Main Company (or company with data to copy into Test Company)</p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">. File &gt; Company &gt; Open<br style="box-sizing: border-box;">. Select the Main Company (or company with data to copy into Test Company)<br style="box-sizing: border-box;">. OK<br style="box-sizing: border-box;">Double-check that the Company name in the top left Header is the correct company</p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">. File &gt; Company &gt; Rename<br style="box-sizing: border-box;">. Type in "TEST Company" in New Company Name in Rename Company table<br style="box-sizing: border-box;">. OK</p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">Double-check that the Company name in the top left Header is the new TEST company name</p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><u style="box-sizing: border-box;">Step 3: Restore Main Company</u></p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">Restoring the main company from the database backup will automatically create "another" company.  This will have the same information as the Test Company.  Navision wouldn't allow 2 companies to have the same name in a database.  If the main company hasn't been renamed to Test Company (Or another name) then an error will prevent this next step.</p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">. Tools &gt; Restore<br style="box-sizing: border-box;">. Locate database just backed up<br style="box-sizing: border-box;">. OK<br style="box-sizing: border-box;">. Select</p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">Custom Backup<br style="box-sizing: border-box;">Selected Companies<br style="box-sizing: border-box;"> Check only the main company just renamed into Test Company<br style="box-sizing: border-box;">. OK</p> <p><br style="box-sizing: border-box; color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">There should now be a Test Company, Main Company, and any other companies setup up in Navision.  The Test Company will have most current date and ready to use.</p> </div> 17000122157 121 17000037125 2017-09-08T15:59:57-06:00 17000265439 1 Creating a Test Company Creating a Test Company Microsoft,Dynamics,NAV,ODT,Edsuite,System,Wide,Test,company,create,creating 2 0 0 Creating a Test Company 2016-12-13T10:17:52-07:00 17002649915 1 2016-12-07T11:36:17-07:00 0 0 Issue NetType settings for Database Server and Application Server or Jet Reports must match Solution When starting the Navision Application Server or when trying to connect to the Navision Database Server using Jet Reports, a warning in the event viewer may indicate that: 'The network is not functioning correctly.  A 'packet' has been corrupted (a checksum error). This error indicates that the network is not completely reliable.  Please not how often this type of error occurs in the network.' This usually means that the communication protocols do not match or in the case of Jet Reports, this could mean that the Navision Database Server nettype option is configured to use TCPS. Jet Reports only works over TCP. For the Navision Application Server: Setting both the Navision Database Server and the Navision Application Server NetType to TCP or NetBios (TCP for MS SQL databases) and restating the servers will likely solve this problem. For Jet Reports: Setting the Navision Database Server NetType to TCP oand restating the server will likely solve this problem. <div dir="ltr"> <table border="1" cellpadding="0" cellspacing="0" id="table60064" style="border-width: 1px; border-style: solid; border-color: rgb(175, 175, 175); width: 100%;"><tbody> <tr class="current"> <td><strong>Issue</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;">NetType settings for Database Server and Application Server or Jet Reports must match</p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <table cellpadding="0" cellspacing="0" style="box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(80, 99, 135); font-family: Verdana, Arial, sans-serif;" width="100%"><tbody style="box-sizing: border-box;"></tbody></table> </td> </tr> <tr class="current"> <td><strong>Solution</strong></td> <td><p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;">When starting the Navision Application Server or when trying to connect to the Navision Database Server using Jet Reports, a warning in the event viewer may indicate that:<br>'The network is not functioning correctly.  A 'packet' has been corrupted (a checksum error).<br><br>This error indicates that the network is not completely reliable.  Please not how often this type of error occurs in the network.'<br><br>This usually means that the communication protocols do not match o<span lang="EN-CA">r in the case of Jet Reports, this could mean that the Navision Database Server nettype option is configured to use TCPS. Jet Reports only works over TCP.<br style="box-sizing: border-box;"></span><br>For the Navision Application Server:<br>Setting both the Navision Database Server and the Navision Application Server NetType to TCP or NetBios (TCP for MS SQL databases) and restating the servers will likely solve this problem.<br><br>For Jet Reports:<br>Setting the Navision Database Server NetType to TCP oand restating the server will likely solve this problem.<br></p></td> </tr> </tbody></table> <br><br><p><br></p> <div dir="ltr"> <p style="box-sizing: border-box; margin: 0in 0in 12pt; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br></p> <p><br></p> <p><br></p> <div dir="ltr"> <p><br></p> <p><br></p> <p><br></p> </div> </div> </div> 17000122157 119 17000037301 2016-12-12T14:52:54-07:00 17002649915 1 NetType settings NetType settings for Database Server and Application Server or Jet Reports must match Microsoft,Dynamics,NAV,ODT,Edsuite,Installation,Jet-reports,nettype,settings,database,application server,match 2 0 0 NetType settings for Database Server and Application Server or Jet Reports must match 2016-12-07T11:36:17-07:00 17002649915 1 2016-12-07T11:45:00-07:00 0 0 Issue The Options and Locations of the Navision license file - Native Database Server Solution The Options and Locations of the Navision license file   MORE INFORMATION Navision Native database edition: A single-user installation comes with a demonstration license file, cronus.flf, that allows you to see all the application areas in the demonstration company that is part of the accompanying standard database, database.fdb. To start working with Navision, you will need a license file that contains permissions for the desired application areas and functions. You obtain the license file from your Microsoft Certified Business Solutions Partner.  You can use your license file to work in the demonstration company as well as your own companies, but your permissions will be limited (even in the demonstration company) to those provided by the license file. On the other hand, your license file does not contain the restrictions of the demonstration license file.  Your license file is always named fin.flf, and you receive it on a diskette by itself. In a single-user installation, copy the license from the diskette to your computer. In a multi-user installation, the license will be copied to the server during the installation process and does not need to be copied to the individual clients. The clients automatically work with the same license file as the server to which they are connected.  After you have copied your license file to your computer or the server, store the diskette in a safe place until you need to use it again.  Importing a License File In the License Information window, click Import, to use a different license file. The Import License File dialog box appears. Locate and select the license file that you want and then click Open. The program will then import the license file into the Navision folder on your computer and it will be called fin.flf. The license file will automatically replace any other file called fin.flf without asking you to confirm that you want it to do so. This new license file will be the active license file the next time you open Navision. When you connect to a server, the license stored there will become the active license.  Exporting a License File Click Export to export a copy of your license file, such as to a disk. The Export License File appears. This is a standard windows dialog box.  Temporarily Changing the License File If, for example, you are a Microsoft Certified Business Solutions Partner representative visiting a customer, you may want to change the license file temporarily. To do so, insert the disk containing the license file and then click Change. The Change License File dialog box appears. Select the license file to be read into the system. The information contained in it will be transferred to the client when you click Open. When you access any servers, this temporary license information will continue to be used instead of the license information stored on the servers. The server license will be reinstated when Navision is closed and opened again.  Navision will warn you before your license expires. If you fail to notice the warning and the license on the server expires, you will not be able to access the server. However, you can use the Change facility to gain access to the server by using an alternative license file. <div dir="ltr"> <table border="1" cellpadding="0" cellspacing="0" id="table60064" style="border-width: 1px; border-style: solid; border-color: rgb(175, 175, 175); width: 100%;"><tbody> <tr class="current"> <td><strong>Issue</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><span rel="tempredactor">The Options and Locations of the Navision license file - Native Database Server</span><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <table cellpadding="0" cellspacing="0" style="box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(80, 99, 135); font-family: Verdana, Arial, sans-serif;" width="100%"><tbody style="box-sizing: border-box;"></tbody></table> </td> </tr> <tr class="current"> <td><strong>Solution</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><strong><span class="current">The Options and Locations of the Navision license file<br style="box-sizing: border-box;"></span> </strong><br><strong><span>MORE INFORMATION</span><br></strong></p> <p class="current" style="box-sizing: border-box; line-height: 14px;"><span><strong><br style="box-sizing: border-box;">Navision Native database edition:</strong></span></p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; line-height: 14px;"><span style="box-sizing: border-box;">A single-user installation comes with a demonstration license file, cronus.flf, that allows you to see all the application areas in the demonstration company that is part of the accompanying standard database, database.fdb. To start working with Navision, you will need a license file that contains permissions for the desired application areas and functions. You obtain the license file from your Microsoft Certified Business Solutions Partner.</span><span style="box-sizing: border-box;"> </span></p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; line-height: 14px;"><span style="box-sizing: border-box;">You can use your license file to work in the demonstration company as well as your own companies, but your permissions will be limited (even in the demonstration company) to those provided by the license file. On the other hand, your license file does not contain the restrictions of the demonstration license file.</span><span style="box-sizing: border-box;"> </span></p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; line-height: 14px;"><span style="box-sizing: border-box;">Your license file is always named fin.flf, and you receive it on a diskette by itself. In a single-user installation, copy the license from the diskette to your computer. In a multi-user installation, the license will be copied to the server during the installation process and does not need to be copied to the individual clients. The clients automatically work with the same license file as the server to which they are connected.</span><span style="box-sizing: border-box;"> </span></p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br><br></p> <p style="box-sizing: border-box; line-height: 14px;"><span style="box-sizing: border-box;">After you have copied your license file to your computer or the server, store the diskette in a safe place until you need to use it again.</span><span style="box-sizing: border-box;"> </span></p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br><span><strong>Importing a License File</strong></span><br></p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br><span>In the License Information window, click Import, to use a different license file. The Import License File dialog box appears. Locate and select the license file that you want and then click Open. The program will then import the license file into the Navision folder on your computer and it will be called fin.flf. The license file will automatically replace any other file called fin.flf without asking you to confirm that you want it to do so. This new license file will be the active license file the next time you open Navision. When you connect to a server, the license stored there will become the active license.</span><span> </span><br></p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; line-height: 14px;"><span><strong>Exporting a License File</strong></span></p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; line-height: 14px;"><span style="box-sizing: border-box;">Click Export to export a copy of your license file, such as to a disk. The Export License File appears. This is a standard windows dialog box.</span><span style="box-sizing: border-box;"> </span></p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p class="current" style="box-sizing: border-box; line-height: 14px;"><span><strong>Temporarily Changing the License File</strong></span></p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; line-height: 14px;"><span style="box-sizing: border-box;">If, for example, you are a Microsoft Certified Business Solutions Partner representative visiting a customer, you may want to change the license file temporarily. To do so, insert the disk containing the license file and then click Change. The Change License File dialog box appears. Select the license file to be read into the system. The information contained in it will be transferred to the client when you click Open. When you access any servers, this temporary license information will continue to be used instead of the license information stored on the servers. The server license will be reinstated when Navision is closed and opened again.</span><span style="box-sizing: border-box;"> </span></p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br><br></p> <p class="current" style="box-sizing: border-box; line-height: 14px;"><span>Navision will warn you before your license expires. If you fail to notice the warning and the license on the server expires, you will not be able to access the server. However, you can use the Change facility to gain access to the server by using an alternative license file.</span></p> <p style="box-sizing: border-box; line-height: 14px;"><br></p> </td> </tr> </tbody></table> <br><br><p><br></p> <div dir="ltr"> <p style="box-sizing: border-box; margin: 0in 0in 12pt; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br></p> <p><br></p> <p><br></p> <div dir="ltr"> <p><br></p> <p><br></p> <p><br></p> </div> </div> </div> 17000122157 299 17000037306 2016-12-12T15:06:15-07:00 17002649915 1 The Options and Locations of the Navision license file - Native Database Server The Options and Locations of the Navision license file - Native Database Server Microsoft,Dynamics,NAV,ODT,Edsuite,Installation,license,option,location,navision,native,database,server 2 0 0 The Options and Locations of the Navision license file - Native Database Server 2016-12-13T10:16:54-07:00 17002649915 1 2016-12-07T11:56:54-07:00 0 0 Issue How to Expand a single Navision Standard Database file Solution Expanding the Database You use the expand database function to increase the size of a single file database. You do not need to expand your database until you are about to run out of available space. You can check this by clicking File, Database, Information and looking in the Database Used (KB) field in the Database Information window. The value in this field should not exceed 80% (rule of thumb). As soon as it reaches this level, it is a good idea to expand the database. *Warning  Navision does not give you any warning that you are about to run out of space in the database. You must keep track of the status of the database, including how much space is left and how much database space you have purchased permission for.  However, Navision displays an error message if there is not sufficient free space to perform the current task. It also displays an error message if you are performing a time-consuming task and all the available space in the database that contains your Snapshot has been used by other concurrent activities. Performance The performance of the program depends only slightly on the size of the database.  Unsatisfactory performance may be caused by problems with your equipment, by storing the database in an impractical location, or by setting the Cache and Commit Cache program properties without giving due consideration to your needs. Requirements To expand your database, you must have adequate space available on your hard disk(s), and you must have purchased permission for (at least) a database of the size you want to expand to. The Licensed Size (KB) field in the Database Information window shows the size database you have purchased permission for. If you don't have permission to expand the database further, an error message will appear when you try to do so. Remember that it is not always a good idea to simply expand your database to the maximum size possible; once space has been allocated to the database it cannot be used for anything else on your computer. Note:  Before you expand your database, it is a good idea to have all other users close Navision and back up your database. To Expand the Database Click File, Database, Expand. The Expand Database window appears. To expand the database, enter the number of kilobytes you want to add in the Add (KB)field, or enter the new total number of kilobytes in the New Size (KB) field. Click OK to expand the database. <div dir="ltr"> <table border="1" cellpadding="0" cellspacing="0" id="table60064" style="border-width: 1px; border-style: solid; border-color: rgb(175, 175, 175); width: 100%;"><tbody> <tr class="current"> <td><strong>Issue</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><span rel="tempredactor">How to Expand a single Navision Standard Database file</span><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <table cellpadding="0" cellspacing="0" style="box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(80, 99, 135); font-family: Verdana, Arial, sans-serif;" width="100%"><tbody style="box-sizing: border-box;"></tbody></table> </td> </tr> <tr class="current"> <td><strong>Solution</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><span class="current"><strong>Expanding the Database</strong><br style="box-sizing: border-box;"></span><br>You use the expand database function to increase the size of a single file database.<br><br>You do not need to expand your database until you are about to run out of available space. You can check this by clicking File, Database, Information and looking in the <span>Database Used (KB)</span> field in the <span>Database Information</span> <span>window. The value in this field should not exceed 80% (rule of thumb). As soon as it reaches this level, it is a good idea to expand the database.</span><br><span><br style="box-sizing: border-box;">*</span><span>Warning  </span>Navision does not give you any warning that you are about to run out of space in the database. You must keep track of the status of the database, including how much space is left and how much database space you have purchased permission for.<span>  </span>However, Navision displays an error message if there is not sufficient free space to perform the current task. It also displays an error message if you are performing a time-consuming task and all the available space in the database that contains your Snapshot has been used by other concurrent activities.<br><span><br style="box-sizing: border-box;"><strong>Performance</strong><br style="box-sizing: border-box;"></span><br>The performance of the program depends only slightly on the size of the database.<span>  </span>Unsatisfactory performance may be caused by problems with your equipment, by storing the database in an impractical location, or by setting the Cache and Commit Cache program properties without giving due consideration to your needs.<br><span><br style="box-sizing: border-box;"><strong>Requirements</strong><br style="box-sizing: border-box;"></span><br>To expand your database, you must have adequate space available on your hard disk(s), and you must have purchased permission for (at least) a database of the size you want to expand to. The <span>Licensed Size (KB) </span>field in the <span>Database Information </span><span>window shows the size database you have purchased permission for. If you don't have permission to expand the database further, an error message will appear when you try to do so.<br style="box-sizing: border-box;"></span><span class="current"><br style="box-sizing: border-box;">Remember that it is not always a good idea to simply expand your database to the maximum size possible; once space has been allocated to the database it cannot be used for anything else on your computer.<br style="box-sizing: border-box;"></span><span><br style="box-sizing: border-box;">Note:  </span><span>Before you expand your database, it is a good idea to have all other users close Navision and back up your database.<br style="box-sizing: border-box;"></span><span><br style="box-sizing: border-box;">To Expand the Database<br style="box-sizing: border-box;"></span><span>Click File, Database, Expand. The <span class="current">Expand Database</span> <span>window appears.</span><br style="box-sizing: border-box;"></span><br><span rel="tempredactor">To expand the database, enter the number of kilobytes you want to add in the Add (KB)field, or enter the new total number of kilobytes in the New Size (KB) field. Click OK to expand the database.</span><br></p> <p style="box-sizing: border-box; line-height: 14px;"><br></p> </td> </tr> </tbody></table> <br><br><p><br></p> <div dir="ltr"> <p style="box-sizing: border-box; margin: 0in 0in 12pt; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br></p> <p><br></p> <p><br></p> <div dir="ltr"> <p><br></p> <p><br></p> <p><br></p> </div> </div> </div> 17000122157 265 17000037309 2016-12-12T15:09:58-07:00 17002649915 1 How to Expand a single Navision Standard Database file How to Expand a single Navision Standard Database file Microsoft,Dynamics,NAV,ODT,Edsuite,Installation,navision,expand,single,database,standard,file 2 0 0 How to Expand a single Navision Standard Database file 2016-12-13T10:17:07-07:00 17002649915 1 2016-12-07T12:21:50-07:00 0 0 Issue Details of how to import Navision FOB/Text files Solution What is an FOB Object Set? FOB object sets contain software development updates provided by Open Door Technology.  These object sets may contain custom development targeted specifically for your company, and/or improvements that have been developed by Navision North America which should be applied to all North American clients. How to Import FOB Objects 1.      It is recommended to perform a full Navision backup before importing major object updates. 2.      You should have received a filename with an .FOB file extension.  Save this into a known directory on your file system. 3.      From Navision, select Tools->Object Designer. 4.      Select File->Import, then browse to and Open the FOB file to be imported. 5.      You will be given a dialogue box saying choose OK to open the Import Worksheet.  Press the OK button. 6.      You should now see an Import Worksheet.  Always press the Replace All button before pressing OK. 7.      You will see a final informational screen saying how many objects were imported (replaced, created, merged, etc.).  Again, just press OK. <div dir="ltr"> <table border="1" cellpadding="0" cellspacing="0" id="table60064" style="border-width: 1px; border-style: solid; border-color: rgb(175, 175, 175); width: 100%;"><tbody> <tr class="current"> <td><strong>Issue</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><span rel="tempredactor">Details of how to import Navision FOB/Text files</span><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <table cellpadding="0" cellspacing="0" style="box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(80, 99, 135); font-family: Verdana, Arial, sans-serif;" width="100%"><tbody style="box-sizing: border-box;"></tbody></table> </td> </tr> <tr class="current"> <td><strong>Solution</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;">What is an FOB Object Set?</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;">FOB object sets contain software development updates provided by Open Door Technology.  These object sets may contain custom development targeted specifically for your company, and/or improvements that have been developed by Navision North America which should be applied to all North American clients.</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;">How to Import FOB Objects</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;">1.      It is recommended to perform a full Navision backup before importing major object updates.</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;">2.      You should have received a filename with an .FOB file extension.  Save this into a known directory on your file system.</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;">3.      From Navision, select Tools-&gt;Object Designer.</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;">4.      Select File-&gt;Import, then browse to and Open the FOB file to be imported.</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;">5.      You will be given a dialogue box saying choose OK to open the Import Worksheet.  Press the OK button.</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;">6.      You should now see an Import Worksheet.  Always press the Replace All button before pressing OK.</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;">7.      You will see a final informational screen saying how many objects were imported (replaced, created, merged, etc.).  Again, just press OK.</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; line-height: 14px;"><br></p> </td> </tr> </tbody></table> <br><br><p><br></p> <div dir="ltr"> <p style="box-sizing: border-box; margin: 0in 0in 12pt; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br></p> <p><br></p> <p><br></p> <div dir="ltr"> <p><br></p> <p><br></p> <p><br></p> </div> </div> </div> 17000122157 229 17000037316 2016-12-12T15:09:59-07:00 17002649915 1 Details of how to import Navision FOB/Text files Details of how to import Navision FOB/Text files Microsoft,Dynamics,NAV,ODT,Edsuite,Installation,navision,objects,import,FOB,text-files 2 0 0 Details of how to import Navision FOB/Text files 2016-12-13T10:17:07-07:00 17002649915 1 2016-12-07T12:24:41-07:00 0 0 Issue Update 1 for Microsoft Navision 4.0 Service Pack 1 is available Solution INTRODUCTION Update 1 for Microsoft Business Solutions - Navision 4.0 Service Pack 1 is available. MORE INFORMATION Update 1 for Microsoft Navision 4.0 Service Pack 1 is a kernel update rollup that contains fixes for the problems that are described in the following Knowledge Base articles: 907804 You cannot use Navision Application Server to run the Adjust Cost process in Microsoft Navision 3.70 908526 The Export function of a dataport may take longer to run than expected when the 'Microsoft SQL Server' option is selected in Microsoft Navision 4.0 908799 A shortcut does not open a form or a report in Microsoft Navision 4.0 908854 The Microsoft Navision client may become unstable and crash 909929 When you print a report and then open a Salesperson card in Microsoft Navision 4.0, the Salesperson card does not receive the focus 911573 Error message when you move a data item in a report that you design in Microsoft Navision: 'Microsoft Navision has encountered a problem and needs to close' 911574 Error message when you try to open an FDF file by using a hyperlink command in Microsoft Navision: 'C/SIDE hyperlinking failed' 911575 Error message when you try to open a database in Microsoft Navision 4.0 Service Pack 1 if the database was created in Microsoft Navision 3.70 Service Pack B Update 1: 'The following SQL Server error(s) occurred: 207,'42S22' 911653 Error message when you paste selected records from a form to a table that has the property 'PasteIsValid=No' in Microsoft Navision: 'You are not allowed to paste in this table' 911654 You are prompted to convert the database every time that you open a database in a client installation of Microsoft Navision 4.0 Service Pack 1 911655 You receive a runtime error if you set the first parameter in the FINDSET function to TRUE and if there is no record in the filter in Microsoft Navision 4.0 Service Pack 1 911747 You cannot use the Microsoft Navision ODBC driver together with linked servers in Microsoft SQL Server 2005 911748 When you create a new SQL Server database on a Microsoft Navision 4.0 client, a message is written to the transaction log file that says that the database has a restricted maximum size of a negative number 911751 Error message when you specify a criterion in a query in Microsoft Access and then run the query to look for data in a Microsoft Navision 4.0 table: 'ODBC-call failed' 911752 After you restore the Terminal Server window, the navigation pane of Microsoft Navision 4.0 may be maximized, and you may not be able to resize the pane 911753 A memory leak may occur when you work in the debugging environment in Microsoft Navision 4.0 911819 When you run the dataport object for the Integer table by using the Microsoft SQL Server database, a dataport object for the Integer table counts the records, and a window appears in Microsoft Navision 4.0 that shows the records that have been counted 911823 Microsoft Navision does not display the list of available tables when you perform a mail merge by using an ODBC connection to a non-English version of a Microsoft Navision 4.0 database 911824 Microsoft Navision 4.0 Service Pack 1 prompts you to convert a Microsoft Navision 4.0 database, even though you already converted it 911825 An extra 'd' character may be displayed at the end of a date in a message or in a report in Microsoft Navision 911826 Slow performance may occur when you read data from a table in Microsoft Navision 4.0 911818 Some printers print only the A4 paper size in Microsoft Navision 4.0 Password for extracting the update:  Z6@Iou1n9Q <div dir="ltr"> <table border="1" cellpadding="0" cellspacing="0" id="table60064" style="border-width: 1px; border-style: solid; border-color: rgb(175, 175, 175); width: 100%;"><tbody> <tr class="current"> <td><strong>Issue</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><span rel="tempredactor">Update 1 for Microsoft Navision 4.0 Service Pack 1 is available</span><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <table cellpadding="0" cellspacing="0" style="box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(80, 99, 135); font-family: Verdana, Arial, sans-serif;" width="100%"><tbody style="box-sizing: border-box;"></tbody></table> </td> </tr> <tr class="current"> <td><strong>Solution</strong></td> <td class="current"> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">INTRODUCTION</strong><br style="box-sizing: border-box;">Update 1 for Microsoft Business Solutions - Navision 4.0 Service Pack 1 is available.</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">MORE INFORMATION</strong><br style="box-sizing: border-box;">Update 1 for Microsoft Navision 4.0 Service Pack 1 is a kernel update rollup that contains fixes for the problems that are described in the following Knowledge Base articles:</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong>907804 </strong>You cannot use Navision Application Server to run the Adjust Cost process in Microsoft Navision 3.70</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">908526</strong> The Export function of a dataport may take longer to run than expected when the 'Microsoft SQL Server' option is selected in Microsoft Navision 4.0</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">908799</strong> A shortcut does not open a form or a report in Microsoft Navision 4.0</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">908854</strong> The Microsoft Navision client may become unstable and crash</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">909929</strong> When you print a report and then open a Salesperson card in Microsoft Navision 4.0, the Salesperson card does not receive the focus</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">911573</strong> Error message when you move a data item in a report that you design in Microsoft Navision: 'Microsoft Navision has encountered a problem and needs to close'</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">911574</strong> Error message when you try to open an FDF file by using a hyperlink command in Microsoft Navision: 'C/SIDE hyperlinking failed'</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">911575</strong> Error message when you try to open a database in Microsoft Navision 4.0 Service Pack 1 if the database was created in Microsoft Navision 3.70 Service Pack B Update 1: 'The following SQL Server error(s) occurred: 207,'42S22'</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">911653</strong> Error message when you paste selected records from a form to a table that has the property 'PasteIsValid=No' in Microsoft Navision: 'You are not allowed to paste in this table'</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">911654</strong> You are prompted to convert the database every time that you open a database in a client installation of Microsoft Navision 4.0 Service Pack 1</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">911655</strong> You receive a runtime error if you set the first parameter in the FINDSET function to TRUE and if there is no record in the filter in Microsoft Navision 4.0 Service Pack 1</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">911747</strong> You cannot use the Microsoft Navision ODBC driver together with linked servers in Microsoft SQL Server 2005</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">911748</strong> When you create a new SQL Server database on a Microsoft Navision 4.0 client, a message is written to the transaction log file that says that the database has a restricted maximum size of a negative number</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">911751</strong> Error message when you specify a criterion in a query in Microsoft Access and then run the query to look for data in a Microsoft Navision 4.0 table: 'ODBC-call failed'</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">911752</strong> After you restore the Terminal Server window, the navigation pane of Microsoft Navision 4.0 may be maximized, and you may not be able to resize the pane</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">911753</strong> A memory leak may occur when you work in the debugging environment in <br style="box-sizing: border-box;">Microsoft Navision 4.0</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">911819</strong> When you run the dataport object for the Integer table by using the Microsoft SQL Server database, a dataport object for the Integer table counts the records, and a window appears in Microsoft Navision 4.0 that shows the records that have been counted <br style="box-sizing: border-box;">911823 Microsoft Navision does not display the list of available tables when you perform a mail merge by using an ODBC connection to a non-English version of a Microsoft Navision 4.0 database</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">911824</strong> Microsoft Navision 4.0 Service Pack 1 prompts you to convert a Microsoft Navision 4.0 database, even though you already converted it</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">911825</strong> An extra 'd' character may be displayed at the end of a date in a message or in a report in Microsoft Navision</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">911826</strong> Slow performance may occur when you read data from a table in Microsoft Navision 4.0</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><strong style="box-sizing: border-box;">911818</strong> Some printers print only the A4 paper size in Microsoft Navision 4.0</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br style="box-sizing: border-box;">Password for extracting the update:  <a href="mailto:Z6@Iou1n9Q" style="color: rgb(0, 0, 153); line-height: normal;">Z6@Iou1n9Q</a></p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; line-height: 14px;"><br></p> </td> </tr> </tbody></table> <br><br><p><br></p> <div dir="ltr"> <p style="box-sizing: border-box; margin: 0in 0in 12pt; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br></p> <p><br></p> <p><br></p> <div dir="ltr"> <p><br></p> <p><br></p> <p><br></p> </div> </div> </div> 17000122157 94 17000037317 2016-12-12T15:10:06-07:00 17002649915 1 Update 1 for Microsoft Navision 4.0 Service Pack 1 is available Update 1 for Microsoft Navision 4.0 Service Pack 1 is available Microsoft,Dynamics,NAV,ODT,Edsuite,Installation,service,pack,update, 2 0 0 Update 1 for Microsoft Navision 4.0 Service Pack 1 is available 2016-12-13T10:17:22-07:00 17002649915 1 2016-12-07T12:28:11-07:00 0 0 Issue  Navision SQL Server Option Installation Checklist Solution Before installing Microsoft SQL Server, you must make a number of decisions: 1. Choose an Operating System. 2. Check your Hardware for Compliance. 3. Disable any Write Caching Controllers. 4. Choose Installation and Storage Locations. 5. Choose Character Set and Sort Order. 6. Choose a Network Support. 7. Create a Logon Account (NT installation) - remember to accept the defaults. - Then do the installation. 8. Install the Microsoft SQL Server. - Then test the installation. 9. Test your SQL Server Database Engine. 10. Test your SQL Server Tools. 11. Change the Supervisor Account (sa) Password, if blank. 1. Choose an Operating System What operating system should you install SQL Server on to run the Navision SQL Server Option? You will be installing SQL Server on either Windows NT/2000 Server or Windows NT/2000 Enterprise Editions. The installation on a Windows NT/2000 operating system provides you with features and functionality that are not available on other platforms. For example, a SQL install on a Windows NT/2000 platform provides you with Performance Monitor integration, Event Viewer integration and the ability to run as a service, to name just a few. Windows NT/2000 Enterprise is typically used in large data center environments to take advantage of advanced features, such as Extended memory and clustering. 2. Check your Hardware for Compliance It is important to make sure that your hardware will meet with the demands of your environment. The minimum hardware requirements listed earlier in the chapter are minimums and should not be regarded as sufficient for your environment. Remember: faster, bigger and more is usually better in an application server environment. 3. Disable any Write Caching Controllers Be sure to disable any write caching controllers used in your disk subsystem. Write caching disk controllers can corrupt data in a transaction-logging environment. SQL Server uses a transaction-logging architecture. By disabling the write caching disk controller, you are ensuring that any data that has been written to the log, but has not yet been check-pointed into the database will be written to the database during the auto recovery process at startup. 4. Choose Installation and Storage Locations Before installing SQL Server, you should determine and document your installation paths. The default installation path for both Program files and Data Files is C:\Program Files\Microsoft SQL Server\MSSQL. Many of the files related to the SQL Server installation are placed in folders located below this directory structure. Some files are placed on the system drive. The subdirectories that store the program files are as follows: Location Description \Program Files\Microsoft SQL Server\80\Com Dynamic-link libraries (DLLs) for Component Object Model (COM) objects. \Program Files\Microsoft SQL Server\80\Com\Binn\Resources\1033 Resource files (RLLs) used by the DLLs in this COM directory. Note - 1033 is for U.S. English; localized versions use different directory numbers. \Program Files\Microsoft SQL Server\80\Tools\Binn Microsoft Windows NT? client executable files. \Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033 Resource files used by the DLLs in the Tools\Binn directory. \Program Files\Microsoft SQL Server\80\Tools\Books SQL Server Books Online files, including online Help files. \Program Files\Microsoft SQL Server\80\Tools\DevTools Header files, library files, and sample programs for use by developers. \Program Files\Microsoft SQL Server\80\Tools\Html Microsoft Management Console (MMC) and SQL Server HTML files. \Program Files\Microsoft SQL Server\80\Tools\Templates Boilerplate files with SQL scripts to help you create objects in the database. Program and Data Files for the Default Instance of SQL Server 2000 Below are the locations of the program and data files for the default instance of SQL Server 2000. These are the default file locations, which can be changed during installation. Location Description \Program Files\Microsoft SQL Server\Mssql\Backup Default location for backup files. \Program Files\Microsoft SQL Server\Mssql\Binn Microsoft Windows NT server executable files and DLL files for extended stored procedures. \Program Files\Microsoft SQL Server\Mssql\Binn\Resources\1033 Resource files used by the DLLs in this Binn directory. \Program Files\Microsoft SQL Server\Mssql\Data System and sample database files. \Program Files\Microsoft SQL Server\Mssql\Ftdata Full-text catalog files. \Program Files\Microsoft SQL Server\Mssql\Install Scripts run during Setup and resulting output files. \Program Files\Microsoft SQL Server\Mssql\Jobs Storage location for temporary job output files. \Program Files\Microsoft SQL Server\Mssql\Log Error log files. \Program Files\Microsoft SQL Server\Mssql\Repldata Working directory for replication tasks. \Program Files\Microsoft SQL Server\Mssql\Upgrade Files used for version upgrade from SQL Server Version 6.5 to SQL Server 2000. It is not necessary to use the default directories to store your data and log files, nor is it necessary to use the default directory for your backup files. In fact, it is suggested that the data and log files be placed on separate physical drives, which enhances recoverability and performance. We will discuss the actual location of database and log files for the Navision SQL Server Option later. It is also recommended that you place your backup devices on a separate physical drive from the data and log files, again for recoverability reasons. The backup and data folders are simply there for your convenience. 5. Choose Character Set and Sort Order Remember to accept the default options. - Character set code is set to page 1252 (ISO Character set). - Sort Order is set to Dictionary Sort Order, Case-Insensitive. - The Sort Orders affects: Result sets Performance Development Choose the appropriate character set and sort order before you install SQL Server.  Once installed, these selections cannot be modified. <div dir="ltr"> <table border="1" cellpadding="0" cellspacing="0" id="table60064" style="border-width: 1px; border-style: solid; border-color: rgb(175, 175, 175); width: 100%;"><tbody> <tr class="current"> <td> <strong>Issue</strong> </td> <td> <span>Navision SQL Server Option Installation Checklist</span><table width="100%" cellspacing="0" cellpadding="0" style="box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(80, 99, 135); font-family: Verdana, Arial, sans-serif;"></table> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <table cellpadding="0" cellspacing="0" style="box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(80, 99, 135); font-family: Verdana, Arial, sans-serif;" width="100%"><tbody style="box-sizing: border-box;"></tbody></table> </td> </tr> <tr class="current"> <td><strong>Solution</strong></td> <td class="current"> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">Before installing Microsoft SQL Server, you must make a number of decisions:</p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br style="color: rgb(80, 99, 135); font-family: Verdana; font-size: 13px;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">1. Choose an Operating System.<br style="box-sizing: border-box;">2. Check your Hardware for Compliance.<br style="box-sizing: border-box;">3. Disable any Write Caching Controllers.<br style="box-sizing: border-box;">4. Choose Installation and Storage Locations.<br style="box-sizing: border-box;">5. Choose Character Set and Sort Order.<br style="box-sizing: border-box;">6. Choose a Network Support.<br style="box-sizing: border-box;">7. Create a Logon Account (NT installation) - remember to accept the defaults.<br style="box-sizing: border-box;">- Then do the installation.<br style="box-sizing: border-box;">8. Install the Microsoft SQL Server.<br style="box-sizing: border-box;">- Then test the installation.<br style="box-sizing: border-box;">9. Test your SQL Server Database Engine.<br style="box-sizing: border-box;">10. Test your SQL Server Tools.<br style="box-sizing: border-box;">11. Change the Supervisor Account (sa) Password, if blank.</p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br style="color: rgb(80, 99, 135); font-family: Verdana; font-size: 13px;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">1. Choose an Operating System<br style="box-sizing: border-box;">What operating system should you install SQL Server on to run the Navision SQL Server Option? You will be installing SQL Server on either Windows NT/2000 Server or Windows NT/2000 Enterprise Editions. The installation on a Windows NT/2000 operating system provides you with features and functionality that are not available on other platforms. For example, a SQL install on a Windows NT/2000 platform provides you with Performance Monitor integration, Event Viewer integration and the ability to run as a service, to name just a few.</p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br style="color: rgb(80, 99, 135); font-family: Verdana; font-size: 13px;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">Windows NT/2000 Enterprise is typically used in large data center environments to take advantage of advanced features, such as Extended memory and clustering.</p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br style="color: rgb(80, 99, 135); font-family: Verdana; font-size: 13px;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">2. Check your Hardware for Compliance<br style="box-sizing: border-box;">It is important to make sure that your hardware will meet with the demands of your environment. The minimum hardware requirements listed earlier in the chapter are minimums and should not be regarded as sufficient for your environment. Remember: faster, bigger and more is usually better in an application server environment.</p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br style="color: rgb(80, 99, 135); font-family: Verdana; font-size: 13px;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">3. Disable any Write Caching Controllers<br style="box-sizing: border-box;">Be sure to disable any write caching controllers used in your disk subsystem. Write caching disk controllers can corrupt data in a transaction-logging environment. SQL Server uses a transaction-logging architecture. By disabling the write caching disk controller, you are ensuring that any data that has been written to the log, but has not yet been check-pointed into the database will be written to the database during the auto recovery process at startup.</p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br style="color: rgb(80, 99, 135); font-family: Verdana; font-size: 13px;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">4. Choose Installation and Storage Locations<br style="box-sizing: border-box;">Before installing SQL Server, you should determine and document your installation paths. The default installation path for both Program files and Data Files is C:\Program Files\Microsoft SQL Server\MSSQL. Many of the files related to the SQL Server installation are placed in folders located below this directory structure. Some files are placed on the system drive.</p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br style="color: rgb(80, 99, 135); font-family: Verdana; font-size: 13px;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br style="box-sizing: border-box;">The subdirectories that store the program files are as follows:<br style="box-sizing: border-box;">Location<br style="box-sizing: border-box;">Description<br style="box-sizing: border-box;">\Program Files\Microsoft SQL Server\80\Com<br style="box-sizing: border-box;">Dynamic-link libraries (DLLs) for Component Object Model (COM) objects.<br style="box-sizing: border-box;">\Program Files\Microsoft SQL Server\80\Com\Binn\Resources\1033<br style="box-sizing: border-box;">Resource files (RLLs) used by the DLLs in this COM directory.<br style="box-sizing: border-box;">Note - 1033 is for U.S. English; localized versions use different directory numbers.<br style="box-sizing: border-box;">\Program Files\Microsoft SQL Server\80\Tools\Binn<br style="box-sizing: border-box;">Microsoft Windows NT? client executable files.<br style="box-sizing: border-box;">\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033<br style="box-sizing: border-box;">Resource files used by the DLLs in the Tools\Binn directory.<br style="box-sizing: border-box;">\Program Files\Microsoft SQL Server\80\Tools\Books<br style="box-sizing: border-box;">SQL Server Books Online files, including online Help files.<br style="box-sizing: border-box;">\Program Files\Microsoft SQL Server\80\Tools\DevTools<br style="box-sizing: border-box;">Header files, library files, and sample programs for use by developers.<br style="box-sizing: border-box;">\Program Files\Microsoft SQL Server\80\Tools\Html<br style="box-sizing: border-box;">Microsoft Management Console (MMC) and SQL Server HTML files.<br style="box-sizing: border-box;">\Program Files\Microsoft SQL Server\80\Tools\Templates<br style="box-sizing: border-box;">Boilerplate files with SQL scripts to help you create objects in the database.<br style="box-sizing: border-box;">Program and Data Files for the Default Instance of SQL Server 2000</p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br style="color: rgb(80, 99, 135); font-family: Verdana; font-size: 13px;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">Below are the locations of the program and data files for the default instance of SQL Server 2000. These are the default file locations, which can be changed during installation. Location<br style="box-sizing: border-box;">Description<br style="box-sizing: border-box;">\Program Files\Microsoft SQL Server\Mssql\Backup<br style="box-sizing: border-box;">Default location for backup files.<br style="box-sizing: border-box;">\Program Files\Microsoft SQL Server\Mssql\Binn<br style="box-sizing: border-box;">Microsoft Windows NT server executable files and DLL files for extended stored procedures.<br style="box-sizing: border-box;">\Program Files\Microsoft SQL Server\Mssql\Binn\Resources\1033<br style="box-sizing: border-box;">Resource files used by the DLLs in this Binn directory.<br style="box-sizing: border-box;">\Program Files\Microsoft SQL Server\Mssql\Data<br style="box-sizing: border-box;">System and sample database files.<br style="box-sizing: border-box;">\Program Files\Microsoft SQL Server\Mssql\Ftdata<br style="box-sizing: border-box;">Full-text catalog files.<br style="box-sizing: border-box;">\Program Files\Microsoft SQL Server\Mssql\Install<br style="box-sizing: border-box;">Scripts run during Setup and resulting output files.<br style="box-sizing: border-box;">\Program Files\Microsoft SQL Server\Mssql\Jobs<br style="box-sizing: border-box;">Storage location for temporary job output files.<br style="box-sizing: border-box;">\Program Files\Microsoft SQL Server\Mssql\Log<br style="box-sizing: border-box;">Error log files.<br style="box-sizing: border-box;">\Program Files\Microsoft SQL Server\Mssql\Repldata<br style="box-sizing: border-box;">Working directory for replication tasks.<br style="box-sizing: border-box;">\Program Files\Microsoft SQL Server\Mssql\Upgrade<br style="box-sizing: border-box;">Files used for version upgrade from SQL Server Version 6.5 to SQL Server 2000.</p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br style="color: rgb(80, 99, 135); font-family: Verdana; font-size: 13px;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">It is not necessary to use the default directories to store your data and log files, nor is it necessary to use the default directory for your backup files. In fact, it is suggested that the data and log files be placed on separate physical drives, which enhances recoverability and performance. We will discuss the actual location of database and log files for the Navision SQL Server Option later. It is also recommended that you place your backup devices on a separate physical drive from the data and log files, again for recoverability reasons. The backup and data folders are simply there for your convenience.</p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br style="color: rgb(80, 99, 135); font-family: Verdana; font-size: 13px;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">5. Choose Character Set and Sort Order<br style="box-sizing: border-box;">Remember to accept the default options.<br style="box-sizing: border-box;">- Character set code is set to page 1252 (ISO Character set).<br style="box-sizing: border-box;">- Sort Order is set to Dictionary Sort Order, Case-Insensitive.<br style="box-sizing: border-box;">- The Sort Orders affects:<br style="box-sizing: border-box;">Result sets<br style="box-sizing: border-box;">Performance<br style="box-sizing: border-box;">Development</p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br style="color: rgb(80, 99, 135); font-family: Verdana; font-size: 13px;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">Choose the appropriate character set and sort order before you install SQL Server.  Once installed, these selections cannot be modified.</p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; line-height: 14px;"><br></p> </td> </tr> </tbody></table> <br><br><p><br></p> <div dir="ltr"> <p style="box-sizing: border-box; margin: 0in 0in 12pt; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br></p> <p><br></p> <p><br></p> <div dir="ltr"> <p><br></p> <p><br></p> <p><br></p> </div> </div> </div> 17000122157 125 17000037318 2016-12-12T15:10:10-07:00 17002649915 1 Navision SQL Server Option Installation Checklist Navision SQL Server Option Installation Checklist Microsoft,Dynamics,NAV,ODT,Edsuite,installation,SQL,server,option,installation,checklist 2 0 0 Navision SQL Server Option Installation Checklist 2016-12-13T10:17:38-07:00 17002649915 1 2016-12-06T14:00:17-07:00 0 0 NOTE:  See attachment for instructions with screenshots Updating a Test Company in a Navision Database These instructions are meant to be a step-by-step guide to updating a test company within the Navision Database.  Test companies are useful for a training resource and testing Navision functionality without fear of editing real data.  Test companies are created using current data from the main company within a database.  It is recommended to update Test Company data periodically because transactions are not duplicated across companies. Updating a Test Company Before starting: - Ensure user creating the test company is a SUPERUSER - Ensure all other users are logged out of Navision during this procedure - Ensure the database used amount is below 65% and has excess room Only a SUPERUSER has the permission to complete all steps.  All other users must be logged out to guarantee no data is lost during test company creation. Step 1: Make backup of entire database and all companies NOTE: Make sure again all users are logged out of Navision . Tools > Backup . Select: Entire Database Selected Companies Check ALL companies listed Data Common to All Companies Application Objects Description: .fbk File Name: Save to backup location with same name as above . OK . After the backup runs successfully a confirmation message will appear \ . OK Step 2: Open and Delete Old Test Company Because Navision won't allow two companies to have the same name, the old Test Company needs to be deleted before renaming Main Company to Test Company. . Make note of EXACT Test Company name.  If the name changes in any way, some users, including the SUPERUSER, may be locked of this company.  User permissions aren't automatically updated for changes in company names. . File > Company > Open . Select old Test Company Double-check that the Company name in the top left Header is the correct company . File > Company > Delete . Two confirmation messages will appear for deleting Test Company . Yes . Yes Step 3: Rename Main Company to TEST Company Rename the Main Company (or company with data to copy into Test Company) . File > Company > Open . Select the Main Company (or company with data to copy into Test Company) . OK Double-check that the Company name in the top left Header is the correct company . File > Company > Rename . Type in "TEST Company" in New Company Name in Rename Company table . Make sure the Test Company name is EXACTLY the same as it was previously . OK Double-check that the Company name in the top left Header is the new TEST company name Step 4: Restore Main Company Restoring the main company from the database backup will automatically create "another" company.  This will have the same information as the Test Company.  Navision wouldn't allow 2 companies to have the same name in a database.  If the main company has not been renamed to Test Company (Or another name) then an error will prevent this next step. . Tools > Restore . Locate database just backed up - OK . Select Custom Backup Selected Companies Check only the main company just renamed into Test Company . OK There should now be a Test Company, Main Company, and any other companies setup up in Navision.  The Test Company will have most current date   Clients with Web Portal After the Main Company has been restored, you must restart the Navision Application Server <div dir="ltr"> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">NOTE:  See attachment for instructions with screenshots<br style="box-sizing: border-box;"><strong style="box-sizing: border-box;"><br style="box-sizing: border-box;">Updating a Test Company in a Navision Database<br style="box-sizing: border-box;"></strong><br style="box-sizing: border-box;">These instructions are meant to be a step-by-step guide to updating a test company within the Navision Database.  Test companies are useful for a training resource and testing Navision functionality without fear of editing real data.  Test companies are created using current data from the main company within a database.  It is recommended to update Test Company data periodically because transactions are not duplicated across companies.<br style="box-sizing: border-box;"><strong style="box-sizing: border-box;"><br style="box-sizing: border-box;">Updating a Test Company<br style="box-sizing: border-box;"></strong><br style="box-sizing: border-box;">Before starting:<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">- Ensure user creating the test company is a SUPERUSER<br style="box-sizing: border-box;">- Ensure all other users are logged out of Navision during this procedure<br style="box-sizing: border-box;">- Ensure the database used amount is below 65% and has excess room<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">Only a SUPERUSER has the permission to complete all steps.  All other users must be logged out to guarantee no data is lost during test company creation.<br style="box-sizing: border-box;"><u style="box-sizing: border-box;"><br style="box-sizing: border-box;">Step 1: Make backup of entire database and all companies<br style="box-sizing: border-box;"></u><br style="box-sizing: border-box;">NOTE: Make sure again all users are logged out of Navision<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">. Tools &gt; Backup<br style="box-sizing: border-box;">. Select:<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">Entire Database<br style="box-sizing: border-box;">Selected Companies<br style="box-sizing: border-box;">Check ALL companies listed<br style="box-sizing: border-box;">Data Common to All Companies<br style="box-sizing: border-box;">Application Objects<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">Description: .fbk<br style="box-sizing: border-box;">File Name: Save to backup location with same name as above<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">. OK<br style="box-sizing: border-box;">. After the backup runs successfully a confirmation message will appear \<br style="box-sizing: border-box;">. OK<br style="box-sizing: border-box;"><u style="box-sizing: border-box;"><br style="box-sizing: border-box;">Step 2: Open and Delete Old Test Company<br style="box-sizing: border-box;"></u><br style="box-sizing: border-box;">Because Navision won't allow two companies to have the same name, the old Test Company needs to be deleted before renaming Main Company to Test Company.<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">. Make note of EXACT Test Company name.  If the name changes in any way, some users, including the SUPERUSER, may be locked of this company.  User permissions aren't automatically updated for changes in company names.<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">. File &gt; Company &gt; Open<br style="box-sizing: border-box;">. Select old Test Company<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">Double-check that the Company name in the top left Header is the correct company<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">. File &gt; Company &gt; Delete<br style="box-sizing: border-box;">. Two confirmation messages will appear for deleting Test Company<br style="box-sizing: border-box;">. Yes<br style="box-sizing: border-box;">. Yes<br style="box-sizing: border-box;"><u style="box-sizing: border-box;"><br style="box-sizing: border-box;">Step 3: Rename Main Company to TEST Company<br style="box-sizing: border-box;"></u><br style="box-sizing: border-box;">Rename the Main Company (or company with data to copy into Test Company)<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">. File &gt; Company &gt; Open<br style="box-sizing: border-box;">. Select the Main Company (or company with data to copy into Test Company)<br style="box-sizing: border-box;">. OK<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">Double-check that the Company name in the top left Header is the correct company<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">. File &gt; Company &gt; Rename<br style="box-sizing: border-box;">. Type in "TEST Company" in New Company Name in Rename Company table<br style="box-sizing: border-box;">. Make sure the Test Company name is EXACTLY the same as it was previously<br style="box-sizing: border-box;">. OK<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">Double-check that the Company name in the top left Header is the new TEST company name<br style="box-sizing: border-box;"><u style="box-sizing: border-box;"><br style="box-sizing: border-box;">Step 4: Restore Main Company<br style="box-sizing: border-box;"></u><br style="box-sizing: border-box;">Restoring the main company from the database backup will automatically create "another" company.  This will have the same information as the Test Company.  Navision wouldn't allow 2 companies to have the same name in a database.  If the main company has not been renamed to Test Company (Or another name) then an error will prevent this next step.<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">. Tools &gt; Restore<br style="box-sizing: border-box;">. Locate database just backed up - OK<br style="box-sizing: border-box;">. Select<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">Custom Backup<br style="box-sizing: border-box;">Selected Companies<br style="box-sizing: border-box;">Check only the main company just renamed into Test Company<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">. OK<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">There should now be a Test Company, Main Company, and any other companies setup up in Navision.  The Test Company will have most current date<br style="box-sizing: border-box;"><br style="box-sizing: border-box;"></p> <p> </p> <p style="box-sizing: border-box; margin: 0in 0in 6pt; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><b style="box-sizing: border-box;"><span lang="EN-US" style="box-sizing: border-box; font-size: 12pt;"><em style="box-sizing: border-box;">Clients with Web Portal</em></span></b></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><span lang="EN-US" style='font-family: "Times New Roman"; font-size: 12pt;'>After the Main Company has been restored, you must restart the Navision Application Server</span></p> </div> 17000122157 80 17000037126 2016-12-12T15:04:42-07:00 17002649915 2 Updating the Test Company Updating the Test Company Microsoft,Dynamics,NAV,ODT,Edsuite,System,Wide,Test,company,update,updating 2 0 0 Updating the Test Company 2016-12-13T10:17:52-07:00 17002649915 1 2016-12-07T11:38:30-07:00 0 0 Issue Installing Jet Reports with Standard Options and Connections Solution Automatic Installation with Custom Installation Options If you want to create an automatic installation with custom options, first install Jet Reports on a typical computer and configure all of the options as described above. If you are using Database Logins, delete your User Name and Password so they will not be installed on other computers. Next export your options to a file named DefaultOptions.JOP and replace the DefualtOptions.JOP file in the installation directory you just created. If you unzipped the Jet Installation to R:\Installer, you will find the DefaultOptions file in the 'R:\Installer\Program Files\JetReports' folder. When you install Jet Reports from this location, it will copy the DefaultOptions.JOP folder to the local computer. The first time a user activates Jet Reports, it will use the options stored in DefaultOptions.JOP. If the DefualtOptions.JOP file specifies Auto Import Options, options will be read from the specified file as explained above. Regardless of how you decide to configure Jet Reports, the Excel options and Jet Reports options are stored on a Per-User basis. This means that each user will have to run 'Activate' from the Start Menu to get access to Jet and enter their username and password. It also means that your database security will be maintained since each user's credentials are stored separately. <div dir="ltr"> <table border="1" cellpadding="0" cellspacing="0" id="table60064" style="border-width: 1px; border-style: solid; border-color: rgb(175, 175, 175); width: 100%;"><tbody> <tr class="current"> <td class=""><strong>Issue</strong></td> <td class=""> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><span rel="tempredactor">Installing Jet Reports with Standard Options and Connections</span><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <table cellpadding="0" cellspacing="0" style="box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(80, 99, 135); font-family: Verdana, Arial, sans-serif;" width="100%"><tbody style="box-sizing: border-box;"></tbody></table> </td> </tr> <tr class="current"> <td class=""><strong>Solution</strong></td> <td class=""><p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><span><strong>Automatic Installation with Custom Installation Options</strong></span><br><br>If you want to create an automatic installation with custom options, first install Jet Reports on a typical computer and configure all of the options as described above. If you are using Database Logins, delete your User Name and Password so they will not be installed on other computers. Next export your options to a file named DefaultOptions.JOP and replace the DefualtOptions.JOP file in the installation directory you just created. If you unzipped the Jet Installation to R:\Installer, you will find the DefaultOptions file in the 'R:\Installer\Program Files\JetReports' folder. When you install Jet Reports from this location, it will copy the DefaultOptions.JOP folder to the local computer. The first time a user activates Jet Reports, it will use the options stored in DefaultOptions.JOP. If the DefualtOptions.JOP file specifies Auto Import Options, options will be read from the specified file as explained above.<br><br>Regardless of how you decide to configure Jet Reports, the Excel options and Jet Reports options are stored on a Per-User basis. This means that each user will have to run 'Activate' from the Start Menu to get access to Jet and enter their username and password. It also means that your database security will be maintained since each user's credentials are stored separately.<br></p></td> </tr> </tbody></table> <br><br><p><br></p> <div dir="ltr"> <p style="box-sizing: border-box; margin: 0in 0in 12pt; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br></p> <p><br></p> <p><br></p> <div dir="ltr"> <p><br></p> <p><br></p> <p><br></p> </div> </div> </div> 17000122157 103 17000037303 2016-12-12T14:54:17-07:00 17002649915 2 Installing Jet Reports with Standard Options and Connections Installing Jet Reports with Standard Options and Connections Microsoft,Dynamics,NAV,ODT,Edsuite,Installation,Jet-reports,standard,option,connection 2 0 0 Installing Jet Reports with Standard Options and Connections 2016-12-07T11:38:30-07:00 17002649915 1 2016-12-07T11:47:02-07:00 0 2 Issue The Options and Locations of the Navision license file - Native Database Server Solution Navision SQL server edition: In order to work with the SQL Server Option for Navision, you must upload the license file you want to use to all the SQL Servers you wish to access, instead of copying it to the individual clients. The clients automatically work under the same license file as the server they are connected to. By default, the demonstration license file CRONUS.flf is uploaded to a SQL Server when the server is used for the first time. SQL Server 2000 allows you to run multiple server instances on the same computer. The Navision license information must be uploaded to each server instance you wish to access. The SQL Server Option for Navision allows you to specify that every database that is stored on an instance of SQL Server must use the same license file or that the individual databases can have their own license file. You specify that a database must use its own license file by clicking the Save license in database field when you create or alter the database. This license file must contain the per-database granule or it cannot be stored in the database. The database will use the granules (including the sessions) specified in the per-database license file. In addition to the license files stored in the individual databases on the server, a common license file must also be stored on the server. The common license file can be identical to one of the license files stored in the databases or it can be a different license file. Any databases that you create on this server that do not contain a per-database license file will use this license file. These databases will use the granules (including the sessions) specified in the server's license file. Uploading a License File To upload a license file to SQL Server, in the License Information window, click Upload. In the Upload License File window that appears, you can browse to the license file provided by your Microsoft Certified Business Solutions Partner. Select the license file and then click Open to upload it to the server. This license information will be used by all the clients connecting to this server, unless they change their license information temporarily with the Change function described on page 30, or unless a database license file is being used. After you have uploaded the license file to the server, store a copy of the license file in a safe place until you need to use it again. If you receive a new license file that you want all your Navision clients to use, you must upload it to SQL Server. Click Upload in the License Information window. The Upload License File window appears. Locate and select the license file and then click Open to upload it. The license file is uploaded to the server or to the database depending on the license option that you chose when you created the database. Importing a License File On the License Information window, click Import to use a different license file. The Import License File dialog box appears. Locate and select the license file that you want and then click Open. The program will then import the license file into the Navision folder on your computer and it will be called fin.flf. The license file will automatically replace any other file called fin.flf without asking you to confirm that you want it to do so. This new license file will be the active license file the next time you open Navision. When you connect to a SQL Server, the license stored there will become the active license. Exporting a License File Click Export to export a copy of your license file, such as to a disk. A standard Windows dialog box appears. Locate and select the license file and then click Saveto export it. Changing the License File If, for example, you are an Microsoft Certified Business Solutions Partner representative visiting a customer, you may want to change the license file temporarily. To do so, insert the disk containing the license file and then click Change. The Change License File dialog box appears. Select the license file to be read into the system. The information contained in it will be transferred to the client when you click Open. When you access any servers, this temporary license information will continue to be used instead of the license information stored on the servers or in the databases. The original licenses will be reinstated when Navision is closed and opened again. Navision warns you before your license expires. If you fail to notice the warning and the license on the server expires, you will not be able to access the server. However, you can use the Change facility to gain access to the server by using an alternative license file. When you receive your new license file, you should use the Change facility to temporarily change to the new license. You can then connect to the server and use the Upload function to upload your new license to the server. This article was TechKnowledge Document ID: 35152 <div dir="ltr"> <table border="1" cellpadding="0" cellspacing="0" id="table60064" style="border-width: 1px; border-style: solid; border-color: rgb(175, 175, 175); width: 100%;"><tbody> <tr class="current"> <td><strong>Issue</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><span rel="tempredactor">The Options and Locations of the Navision license file - Native Database Server</span><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <table cellpadding="0" cellspacing="0" style="box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(80, 99, 135); font-family: Verdana, Arial, sans-serif;" width="100%"><tbody style="box-sizing: border-box;"></tbody></table> </td> </tr> <tr class="current"> <td><strong>Solution</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><strong>Navision SQL server edition:<br></strong><br>In order to work with the SQL Server Option for Navision, you must upload the license file you want to use to all the SQL Servers you wish to access, instead of copying it to the individual clients. The clients automatically work under the same license file as the server they are connected to. By default, the demonstration license file CRONUS.flf is uploaded to a SQL Server when the server is used for the first time. SQL Server 2000 allows you to run multiple server instances on the same computer. The Navision license information must be uploaded to each server instance you wish to access. <br><br>The SQL Server Option for Navision allows you to specify that every database that is stored on an instance of SQL Server must use the same license file or that the individual databases can have their own license file. You specify that a database must use its own license file by clicking the Save license in database field when you create or alter the database. This license file must contain the per-database granule or it cannot be stored in the database. The database will use the granules (including the sessions) specified in the per-database license file. <br><br>In addition to the license files stored in the individual databases on the server, a common license file must also be stored on the server. The common license file can be identical to one of the license files stored in the databases or it can be a different license file. Any databases that you create on this server that do not contain a per-database license file will use this license file. These databases will use the granules (including the sessions) specified in the server's license file. <br><br><strong>Uploading a License File</strong><br><br>To upload a license file to SQL Server, in the License Information window, click Upload. In the Upload License File window that appears, you can browse to the license file provided by your Microsoft Certified Business Solutions Partner. Select the license file and then click Open to upload it to the server. This license information will be used by all the clients connecting to this server, unless they change their license information temporarily with the Change function described on page 30, or unless a database license file is being used. <br><br>After you have uploaded the license file to the server, store a copy of the license file in a safe place until you need to use it again. <br><br>If you receive a new license file that you want all your Navision clients to use, you must upload it to SQL Server. Click Upload in the License Information window. The Upload License File window appears. Locate and select the license file and then click Open to upload it. The license file is uploaded to the server or to the database depending on the license option that you chose when you created the database. <br><br><strong>Importing a License File</strong><br><br>On the License Information window, click Import to use a different license file. The Import License File dialog box appears. Locate and select the license file that you want and then click Open. The program will then import the license file into the Navision folder on your computer and it will be called fin.flf. The license file will automatically replace any other file called fin.flf without asking you to confirm that you want it to do so. <br><br>This new license file will be the active license file the next time you open Navision. When you connect to a SQL Server, the license stored there will become the active license. <br><br><strong>Exporting a License File</strong><br><br>Click Export to export a copy of your license file, such as to a disk. A standard Windows dialog box appears. Locate and select the license file and then click Saveto export it. <br><br><strong>Changing the License File</strong><br><br>If, for example, you are an Microsoft Certified Business Solutions Partner representative visiting a customer, you may want to change the license file temporarily. To do so, insert the disk containing the license file and then click Change. The Change License File dialog box appears. Select the license file to be read into the system. The information contained in it will be transferred to the client when you click Open. When you access any servers, this temporary license information will continue to be used instead of the license information stored on the servers or in the databases. The original licenses will be reinstated when Navision is closed and opened again. <br><br>Navision warns you before your license expires. If you fail to notice the warning and the license on the server expires, you will not be able to access the server. However, you can use the Change facility to gain access to the server by using an alternative license file. When you receive your new license file, you should use the Change facility to temporarily change to the new license. You can then connect to the server and use the Upload function to upload your new license to the server.<br><br>This article was TechKnowledge Document ID: 35152<br></p> <p style="box-sizing: border-box; line-height: 14px;"><br></p> </td> </tr> </tbody></table> <br><br><p><br></p> <div dir="ltr"> <p style="box-sizing: border-box; margin: 0in 0in 12pt; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br></p> <p><br></p> <p><br></p> <div dir="ltr"> <p><br></p> <p><br></p> <p><br></p> </div> </div> </div> 17000122157 1846 17000037307 2016-12-12T15:06:16-07:00 17002649915 2 The Options and Locations of the Navision license file - Navision SQL Server The Options and Locations of the Navision license file - Navision SQL Server Microsoft,Dynamics,NAV,ODT,Edsuite,Installation,license,option,location,navision,SQL,server 2 0 2 The Options and Locations of the Navision license file - Navision SQL Server 2016-12-13T10:16:54-07:00 17002649915 1 2016-12-07T11:59:22-07:00 0 0 Issue Installing and Configuring Second Database Server on Single Machine Solution 1. Copy the folder for the first Navision Database Server (usually C:\Program Files\Microsoft Business Solutions-Navision\Database Server) and paste to a new location and rename. 2. From a command prompt, change directory to the newly created directory 3. Enter the following command: server installasservice 4. Once the command has completed, there will be a new service registered.   5. Open the Navision Application Server Manager Snap-in (NASMSnapIn) (Start > All Programs > Microsoft Business Solutions-Navision > Microsoft Business Solutions-Navision Application Server Manager) 6. Add the Database Server Manager (if not already present). File > Add Remove Snap-in. which will open the "Add/Remove Snap-in" dialog. Then select "Add" and select "Navision Database Server Manager" from the "Add Standalone Snap-in" dialog Then Close the "Add Standalone Snap-in" dialog Select "OK" from the "Add/Remove Snap-in" dialog Now the "Navision Database Server Manager" should be visible in the left pane of the NASMSnapIn window 7. Select the Database Server Manager and select Action > New > Navision Database Server Manager from the menu bar. A "New Navision Database Server Manager" input dialog will appear. 8. Enter either localhost or in the Host Name text field and the service name in the Service Name text field and click OK. 9. The new database server should appear under the Navision Database Server Manager in the left pane (you may need to drill down on the Navision Database Server Manager to see it). 10. Select the new database server 11. The right pane should display the current settings of the selected database server. 12. For production environments: Cache (Kb) = 1000000 Commit Cache = Checked Server Name = Server Name Net Type = TCP/IP Sessions = 0 Database = Full path to database i. Note: the database server can only connect to a database that is not currently occupied by another server or client 13. Then select "Apply these settings" 14. Next open services: Start > Administrative Tools > Services 15. Find the new service in the list and right click and select Properties 16. Select the Log On tab and set Log on as: to Local System account and press OK. 17. Now you should be able to start the new Navision Database Service. 18. Once the service is started test the service by opening a client and connect to the database server by entering the new database service in the "Open Database" dialog - Database Server field. Make sure to clear the database field. 19. Log on as normal. 20. You should be able to interact with the database and others can also connect to the same database server at the same time. <div dir="ltr"> <table border="1" cellpadding="0" cellspacing="0" id="table60064" style="border-width: 1px; border-style: solid; border-color: rgb(175, 175, 175); width: 100%;"><tbody> <tr class="current"> <td><strong>Issue</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><span rel="tempredactor">Installing and Configuring Second Database Server on Single Machine</span><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <table cellpadding="0" cellspacing="0" style="box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(80, 99, 135); font-family: Verdana, Arial, sans-serif;" width="100%"><tbody style="box-sizing: border-box;"></tbody></table> </td> </tr> <tr class="current"> <td><strong>Solution</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;">1. Copy the folder for the first Navision Database Server (usually C:\Program Files\Microsoft Business Solutions-Navision\Database Server) and paste to a new location and rename. <br><br>2. From a command prompt, change directory to the newly created directory<br><br>3. Enter the following command: server installasservice <br><br>4. Once the command has completed, there will be a new service registered.<br> <br>5. Open the Navision Application Server Manager Snap-in (NASMSnapIn) (Start &gt; All Programs &gt; Microsoft Business Solutions-Navision &gt; Microsoft Business Solutions-Navision Application Server Manager) <br><br>6. Add the Database Server Manager (if not already present). <br><br style="color: rgb(80, 99, 135); font-family: Verdana;">File &gt; Add Remove Snap-in. which will open the "Add/Remove Snap-in" dialog. <br>Then select "Add" and select "Navision Database Server Manager" from the "Add Standalone Snap-in" dialog <br style="color: rgb(80, 99, 135); font-family: Verdana;">Then Close the "Add Standalone Snap-in" dialog <br>Select "OK" from the "Add/Remove Snap-in" dialog <br style="color: rgb(80, 99, 135); font-family: Verdana;">Now the "Navision Database Server Manager" should be visible in the left pane of the NASMSnapIn window <br><br style="color: rgb(80, 99, 135); font-family: Verdana;">7. Select the Database Server Manager and select Action &gt; New &gt; Navision Database Server Manager from the menu bar. A "New Navision Database Server Manager" input dialog will appear. <br><br style="color: rgb(80, 99, 135); font-family: Verdana;">8. Enter either localhost or in the Host Name text field and the service name in the Service Name text field and click OK. <br><br style="color: rgb(80, 99, 135); font-family: Verdana;">9. The new database server should appear under the Navision Database Server Manager in the left pane (you may need to drill down on the Navision Database Server Manager to see it). <br><br style="color: rgb(80, 99, 135); font-family: Verdana;">10. Select the new database server <br><br style="color: rgb(80, 99, 135); font-family: Verdana;">11. The right pane should display the current settings of the selected database server. <br><br style="color: rgb(80, 99, 135); font-family: Verdana;">12. For production environments: <br><br>Cache (Kb) = 1000000 <br>Commit Cache = Checked <br>Server Name = Server Name <br>Net Type = TCP/IP <br>Sessions = 0 <br>Database = Full path to database <br style="color: rgb(80, 99, 135); font-family: Verdana;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"><br style="color: rgb(80, 99, 135); font-family: Verdana;"></p> <p style="box-sizing: border-box; margin-bottom: 10px; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;">i. Note: the database server can only connect to a database that is not currently occupied by another server or client<br style="box-sizing: border-box;"><br style="box-sizing: border-box;">13. Then select "Apply these settings" <br style="box-sizing: border-box;"><br style="box-sizing: border-box;">14. Next open services: Start &gt; Administrative Tools &gt; Services <br style="box-sizing: border-box;"><br style="box-sizing: border-box;">15. Find the new service in the list and right click and select Properties <br style="box-sizing: border-box;"><br style="box-sizing: border-box;">16. Select the Log On tab and set Log on as: to Local System account and press OK. <br style="box-sizing: border-box;"><br style="box-sizing: border-box;">17. Now you should be able to start the new Navision Database Service. <br style="box-sizing: border-box;"><br style="box-sizing: border-box;">18. Once the service is started test the service by opening a client and connect to the database server by entering the new database service in the "Open Database" dialog - Database Server field. Make sure to clear the database field. <br style="box-sizing: border-box;"><br style="box-sizing: border-box;">19. Log on as normal. <br style="box-sizing: border-box;"><br style="box-sizing: border-box;">20. You should be able to interact with the database and others can also connect to the same database server at the same time.</p> <p style="box-sizing: border-box; line-height: 14px;"><br></p> </td> </tr> </tbody></table> <br><br><p><br></p> <div dir="ltr"> <p style="box-sizing: border-box; margin: 0in 0in 12pt; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br></p> <p><br></p> <p><br></p> <div dir="ltr"> <p><br></p> <p><br></p> <p><br></p> </div> </div> </div> 17000122157 93 17000037310 2016-12-12T15:10:01-07:00 17002649915 2 Installing and Configuring Second Database Server on Single Machine Installing and Configuring Second Database Server on Single Machine Microsoft,Dynamics,NAV,ODT,Edsuite,Installation,navision,install,configure,second,database,server,single,machine 2 0 0 Installing and Configuring Second Database Server on Single Machine 2016-12-13T10:17:07-07:00 17002649915 1 2016-12-07T12:31:09-07:00 0 0 Issue  There is a login problem that occurs when using pre-Nav 4.0.SP1 client with SQL 2005 Solution There is a SQL error after attempting to re-open a Navision Database in a version prior to version 4.0.SP1. If you create and restore a Navision database of a version prior you can use the database until closed the first time. Attached is a sql fix for this situation that in theory should allow prior versions of Navision to work with SQL2005.  If attempting to use a version of Navision prior to 4.0.sp1 with SQL 2005 please ensure the database is adequately tested! <div dir="ltr"> <table border="1" cellpadding="0" cellspacing="0" id="table60064" style="border-width: 1px; border-style: solid; border-color: rgb(175, 175, 175); width: 100%;"><tbody> <tr class="current"> <td> <strong>Issue</strong> </td> <td>There is a login problem that occurs when using pre-Nav 4.0.SP1 client with SQL 2005<br><table width="100%" cellspacing="0" cellpadding="0" style="box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(80, 99, 135); font-family: Verdana, Arial, sans-serif;"></table> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <table cellpadding="0" cellspacing="0" style="box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(80, 99, 135); font-family: Verdana, Arial, sans-serif;" width="100%"><tbody style="box-sizing: border-box;"></tbody></table> </td> </tr> <tr class="current"> <td><strong>Solution</strong></td> <td> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><span rel="tempredactor">There is a SQL error after attempting to re-open a Navision Database in a version prior to version 4.0.SP1.</span><br></p> <br><br><span rel="tempredactor" style='font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 13px;'>If you create and restore a Navision database of a version prior you can use the database until closed the first time.</span><br><br><span rel="tempredactor" style='font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 13px;'>Attached is a sql fix for this situation that in theory should allow prior versions of Navision to work with SQL2005.  If attempting to use a version of Navision prior to 4.0.sp1 with SQL 2005 please ensure the database is adequately tested!</span><br><p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <p style="box-sizing: border-box; line-height: 14px;"><br></p> </td> </tr> </tbody></table> <br><br><p><br></p> <div dir="ltr"> <p style="box-sizing: border-box; margin: 0in 0in 12pt; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br></p> <p><br></p> <p><br></p> <div dir="ltr"> <p><br></p> <p><br></p> <p><br></p> </div> </div> </div> 17000122157 32 17000037319 2016-12-12T15:10:08-07:00 17002649915 2 login problem using pre-Nav 4.0.SP1 client with SQL 2005 There is a login problem that occurs when using pre-Nav 4.0.SP1 client with SQL 2005 Microsoft,Dynamics,NAV,ODT,Edsuite,installation,SQL,login,pre-Nav,4.0.SP1,client,SQL-2005 2 0 0 There is a login problem that occurs when using pre-Nav 4.0.SP1 client with SQL 2005 2016-12-13T10:17:38-07:00 17002649915 1 2016-12-07T11:40:24-07:00 0 0 Issue Using Jet Reports with Citrix Server Solution If you want to use Jet Reports with Citrix, you will need to publish your entire desktop to have full use of drilldown and the Designer window. You will need to have Jet Reports, Excel and your data source all installed on the Citrix desktop. If you are using Jet Reports with Navision, Navision Client and C/Front have to be installed on the Citrix desktop as well. If you are using an OLE connector, you will need to have the OLE driver installed for your particular database. If you are using ODBC, you need to have a data source configured in your ODBC Data Source Administrator, as well as the connection to that data source configured in Jet Reports. You may want to change the DefaultOptions.JOP file as described in 'Changing the Default Installation Options' so your users will be automatically configured except for their User Name and Password. If you are using Window Logins for database security and want more control over future changes to the Jet Reports Configuration, you can set your default configuration to use a common Jet Reports options file. This procedure is described in the 'Auto Import Options' section. Regardless of how you decide to configure Jet Reports, the Excel options and Jet Reports options are stored on a Per-User basis. This means that each user will have to run 'Activate' from the Start Menu to get access to Jet and enter their username and password. It also means that your database security will be maintained since each user's credentials are stored separately. <div dir="ltr"> <table border="1" cellpadding="0" cellspacing="0" id="table60064" style="border-width: 1px; border-style: solid; border-color: rgb(175, 175, 175); width: 100%;"><tbody> <tr class="current"> <td><strong>Issue</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><span rel="tempredactor">Using Jet Reports with Citrix Server</span><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <table cellpadding="0" cellspacing="0" style="box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(80, 99, 135); font-family: Verdana, Arial, sans-serif;" width="100%"><tbody style="box-sizing: border-box;"></tbody></table> </td> </tr> <tr class="current"> <td><strong>Solution</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;">If you want to use Jet Reports with Citrix, you will need to publish your entire desktop to have full use of drilldown and the Designer window. You will need to have Jet Reports, Excel and your data source all installed on the Citrix desktop. If you are using Jet Reports with Navision, Navision Client and C/Front have to be installed on the Citrix desktop as well. If you are using an OLE connector, you will need to have the OLE driver installed for your particular database. If you are using ODBC, you need to have a data source configured in your ODBC Data Source Administrator, as well as the connection to that data source configured in Jet Reports. You may want to change the DefaultOptions.JOP file as described in 'Changing the Default Installation Options' so your users will be automatically configured except for their User Name and Password. If you are using Window Logins for database security and want more control over future changes to the Jet Reports Configuration, you can set your default configuration to use a common Jet Reports options file. This procedure is described in the 'Auto Import Options' section.</p> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br><span>Regardless of how you decide to configure Jet Reports, the Excel options and Jet Reports options are stored on a Per-User basis. This means that each user will have to run 'Activate' from the Start Menu to get access to Jet and enter their username and password. It also means that your database security will be maintained since each user's credentials are stored separately.</span><br></p> </td> </tr> </tbody></table> <br><br><p><br></p> <div dir="ltr"> <p style="box-sizing: border-box; margin: 0in 0in 12pt; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br></p> <p><br></p> <p><br></p> <div dir="ltr"> <p><br></p> <p><br></p> <p><br></p> </div> </div> </div> 17000122157 264 17000037305 2016-12-12T14:52:45-07:00 17002649915 3 Using Jet Reports with Citrix Server Using Jet Reports with Citrix Server Microsoft,Dynamics,NAV,ODT,Edsuite,Installation,Jet-reports,use,Citrix,server 2 0 0 Using Jet Reports with Citrix Server 2016-12-07T11:40:24-07:00 17002649915 1 2016-12-07T11:54:08-07:00 0 0 Issue Installing New License on Navision Server and a Client Solution A. Server License change 1. Select Start\Program Files\Administrative Tools\Services and stopped the Microsoft Business Server-Navision Database Server <'name of Service'> 2. Replace the fin.flf file with the latest copy in the folder C:\Program Files\Microsoft Business Solutions-Navision\Database Server. Restart the server service. Logged off and have the user open Navision and confirm that the new granule can be opened for a new active license. B. Client License Update go to tools->Import and select the folder where the new license is stored See attached pdf file for more detailed instructions. <div dir="ltr"> <table border="1" cellpadding="0" cellspacing="0" id="table60064" style="border-width: 1px; border-style: solid; border-color: rgb(175, 175, 175); width: 100%;"><tbody> <tr class="current"> <td><strong>Issue</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;">Installing New License on Navision Server and a Client</p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <table cellpadding="0" cellspacing="0" style="box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(80, 99, 135); font-family: Verdana, Arial, sans-serif;" width="100%"><tbody style="box-sizing: border-box;"></tbody></table> </td> </tr> <tr class="current"> <td class="current"><strong>Solution</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><span rel="tempredactor">A. Server License change</span><br></p> <br><br><span rel="tempredactor" style='font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 13px;'>1. Select Start\Program Files\Administrative Tools\Services and stopped the Microsoft Business Server-Navision Database Server &lt;'name of Service'&gt;</span><br><br><span rel="tempredactor" style='font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 13px;'>2. Replace the fin.flf file with the latest copy in the folder C:\Program Files\Microsoft Business Solutions-Navision\Database Server.</span><br><br><span rel="tempredactor" style='font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 13px;'>Restart the server service.</span><br><br><span rel="tempredactor" style='font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 13px;'>Logged off and have the user open Navision and confirm that the new granule can be opened for a new active license.</span><br><br><span rel="tempredactor" style='font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 13px;'>B. Client License Update</span><br><br><span rel="tempredactor" style='font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 13px;'>go to tools-&gt;Import and select the folder where the new license is stored</span><br><br><span rel="tempredactor" style='font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 13px;'>See attached pdf file for more detailed instructions.</span><br><p style="box-sizing: border-box; line-height: 14px;"><br></p> </td> </tr> </tbody></table> <br><br><p><br></p> <div dir="ltr"> <p style="box-sizing: border-box; margin: 0in 0in 12pt; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br></p> <p><br></p> <p><br></p> <div dir="ltr"> <p><br></p> <p><br></p> <p><br></p> </div> </div> </div> 17000122157 54 17000037308 2016-12-12T15:06:14-07:00 17002649915 3 Installing New License on Navision Server and a Client Installing New License on Navision Server and a Client Microsoft,Dynamics,NAV,ODT,Edsuite,Installation,license,install,new,client 2 0 0 Installing New License on Navision Server and a Client 2016-12-13T10:16:54-07:00 17002649915 1 2016-12-07T12:01:49-07:00 0 0 Issue Client gets attached error (Or similar error) when using Navision email integration.  Error happens when you browse to a customer > communications tab > select the button to send an email.  The screen freezes and no email goes through.  Have to close Navision to get past it. Also happens if client tries sending email from contact card. Client is running Navision version 4.0 sp1 and Office Service Pack 2. Solution A fix from Microsoft is required to correct this.  Please contact Open Door and they can arrange this. This fix is for users that are running Navision 4.0 SP1 with Outlook SP2. Before updating your files with those from the hotfix, please make sure the computer system is running on Navision 4.0 SP1 with Outlook SP2 and that you backup the existing files. The hotfix contains the following files: fin.exe, finsql.exe, nas.exe, nassql.exe and OLHandler.dll To apply the Navision hotfix: Copy the files: fin.exe, finsql.exe, OLHandler.dll to the Navision Client folder. Default path: C:\Program Files\Microsoft Business Solutions-Navision\Client\ If using a Navision Application Server: Copy the files: nas.exe, nassql.exe to the Navision Application Server folder. Default path: C:\Program Files\Microsoft Business Solutions-Navision\ Application Server <div dir="ltr"> <table border="1" cellpadding="0" cellspacing="0" id="table60064" style="border-width: 1px; border-style: solid; border-color: rgb(175, 175, 175); width: 100%;"><tbody> <tr class="current"> <td><strong>Issue</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><span rel="tempredactor">Client gets attached error (Or similar error) when using Navision email integration.  Error happens when you browse to a customer &gt; communications tab &gt; select the button to send an email.  The screen freezes and no email goes through.  Have to close Navision to get past it.</span><br></p> <br><br><span rel="tempredactor" style='font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 13px;'>Also happens if client tries sending email from contact card.</span><br><br><span rel="tempredactor" style='font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 13px;'>Client is running Navision version 4.0 sp1 and Office Service Pack 2.</span><br><p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <table cellpadding="0" cellspacing="0" style="box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(80, 99, 135); font-family: Verdana, Arial, sans-serif;" width="100%"><tbody style="box-sizing: border-box;"></tbody></table> </td> </tr> <tr class="current"> <td><strong>Solution</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;">A fix from Microsoft is required to correct this.  Please contact Open Door and they can arrange this.<br><br>This fix is for users that are running Navision 4.0 SP1 with Outlook SP2. Before updating your files with those from the hotfix, please make sure the computer system is running on Navision 4.0 SP1 with Outlook SP2 and that you backup the existing files.<br><br>The hotfix contains the following files: fin.exe, finsql.exe, nas.exe, nassql.exe and OLHandler.dll<br><br>To apply the Navision hotfix:<br><br>Copy the files: fin.exe, finsql.exe, OLHandler.dll to the Navision Client folder.<br>Default path: C:\Program Files\Microsoft Business Solutions-Navision\Client\<br><br>If using a Navision Application Server:<br>Copy the files: nas.exe, nassql.exe to the Navision Application Server folder.<br>Default path: C:\Program Files\Microsoft Business Solutions-Navision\ Application Server<br></p> <p style="box-sizing: border-box; line-height: 14px;"><br></p> </td> </tr> </tbody></table> <br><br><p><br></p> <div dir="ltr"> <p style="box-sizing: border-box; margin: 0in 0in 12pt; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br></p> <p><br></p> <p><br></p> <div dir="ltr"> <p><br></p> <p><br></p> <p><br></p> </div> </div> </div> 17000122157 368 17000037311 2016-12-12T15:10:03-07:00 17002649915 3 Outlook error with Navision email integration Outlook error with Navision email integration Microsoft,Dynamics,NAV,ODT,Edsuite,Installation,navision,outlook,error,email,integration 2 0 0 Outlook error with Navision email integration 2016-12-13T10:17:07-07:00 17002649915 1 2016-12-07T12:03:53-07:00 0 1 Issue How to configure and use Hotcopy Backup program for Navision Solution Microsoft Dynamics NAV also has a server based backup program, called HotCopy. This program is installed with C/SIDE Database Server and is stored in the same directory the C/SIDE Database Server is installed to. HotCopy can only be run from the server location and can only create backups on hard disks. You cannot make incremental or differential backups. The backups are file copies of the database and are not compressed.  You can make a backup of a database while clients are using it. However, if these clients are entering large amounts of data, an error can occur in the database backup. We therefore recommend that you make your database backups when there are few or no clients are using the system.  Furthermore, if HotCopy is the first 'user' to connect to the server it will place an exclusive lock on the database and no other users will be allowed to login while HotCopy is running.  This is done for performance reasons. If other users are already logged on the server, HotCopy runs as an ordinary session.  HotCopy will then apply the version principle and copy its own version of the database.  Running HotCopy as a session places a greater burden on the server. You can only create a backup from the command prompt. You must specify a number of parameters: hotcopy source=databasefile1 (databasefile2.databasefile16) destination="backup directory1" ("backup directory2"."backup directory16") [description="This is the backup for Monday"] [email=username@microsoft.com] [servername=myserver] [user=myname password=mypassword | osauthentication=yes] [dbtest=normal] [cc=yes] [nettype=tcps|tcp|netb] The parameters are case sensitive and those that are enclosed in [ ] are optional.  Every entry that contains a space must be placed inside quotation marks. The following example only uses the mandatory parameters. The database is stored in the same directory as the server based backup program and the backup is stored on another computer: hotcopy source=database.fdb destination=\\backupcomputer\backup\Monday Alternatively, you can refer to a backup description file that contains all the relevant parameters. We recommend that you use the backup description file. hotcopy source=backupdescription.txt You can give the backup description file any name that you like. For additional information please see the Navision Document w1w1bkup.pdf file distributed on the product cd or download. <div dir="ltr"> <table border="1" cellpadding="0" cellspacing="0" id="table60064" style="border-width: 1px; border-style: solid; border-color: rgb(175, 175, 175); width: 100%;"><tbody> <tr class="current"> <td><strong>Issue</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><span rel="tempredactor">How to configure and use Hotcopy Backup program for Navision</span><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <table cellpadding="0" cellspacing="0" style="box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(80, 99, 135); font-family: Verdana, Arial, sans-serif;" width="100%"><tbody style="box-sizing: border-box;"></tbody></table> </td> </tr> <tr class="current"> <td><strong>Solution</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;">Microsoft Dynamics NAV also has a server based backup program, called HotCopy. This program is installed with C/SIDE Database Server and is stored in the same directory the C/SIDE Database Server is installed to.<br><br>HotCopy can only be run from the server location and can only create backups on hard disks. You cannot make incremental or differential backups. The backups are file copies of the database and are not compressed.  You can make a backup of a database while clients are using it. However, if these clients are entering large amounts of data, an error can occur in the database backup.<br><br>We therefore recommend that you make your database backups when there are few or no clients are using the system.  Furthermore, if HotCopy is the first 'user' to connect to the server it will place an exclusive lock on the database and no other users will be allowed to login while HotCopy is running.  This is done for performance reasons.<br><br>If other users are already logged on the server, HotCopy runs as an ordinary session.  HotCopy will then apply the version principle and copy its own version of the database.  Running HotCopy as a session places a greater burden on the server.<br><br>You can only create a backup from the command prompt. You must specify a number of parameters:<br>hotcopy<br>source=databasefile1 (databasefile2.databasefile16)<br>destination="backup directory1" ("backup directory2"."backup directory16")<br>[description="This is the backup for Monday"]<br>[email=username@microsoft.com]<br>[servername=myserver]<br>[user=myname password=mypassword | osauthentication=yes]<br>[dbtest=normal]<br>[cc=yes]<br>[nettype=tcps|tcp|netb]<br><br>The parameters are case sensitive and those that are enclosed in [ ] are optional.  Every entry that contains a space must be placed inside quotation marks.<br><br>The following example only uses the mandatory parameters. The database is stored in the same directory as the server based backup program and the backup is stored on another computer:<br>hotcopy source=database.fdb<br>destination=\\backupcomputer\backup\Monday<br><br>Alternatively, you can refer to a backup description file that contains all the relevant parameters. We recommend that you use the backup description file.<br>hotcopy source=backupdescription.txt<br><br>You can give the backup description file any name that you like.</p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;">For additional information please see the Navision Document w1w1bkup.pdf file distributed on the product cd or download.</p> <p style="box-sizing: border-box; line-height: 14px;"><br></p> </td> </tr> </tbody></table> <br><br><p><br></p> <div dir="ltr"> <p style="box-sizing: border-box; margin: 0in 0in 12pt; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br></p> <p><br></p> <p><br></p> <div dir="ltr"> <p><br></p> <p><br></p> <p><br></p> </div> </div> </div> 17000122157 654 17000037312 2016-12-12T15:10:03-07:00 17002649915 4 How to configure and use Hotcopy Backup program for Navision How to configure and use Hotcopy Backup program for Navision Microsoft,Dynamics,NAV,ODT,Edsuite,Installation,navision,configure,use,hotcopy,backup,program 2 0 1 How to configure and use Hotcopy Backup program for Navision 2016-12-13T10:17:07-07:00 17002649915 1 2016-12-07T12:05:43-07:00 0 0 Issue Navision 5.0 and Office 2003 Integration Solution Please note that NAV 5.0 will work with Office 2003 as long as you go into the Office 2003 installion CD, click on "customize" and add the "Collaboration Data Object". NAV 5.0 will not work with Office 2003 without running this routine. Here is the PartnerSource link where you can download the NAV Style Sheet Tool and reading material: https://mbs.microsoft.com/partnersource/downloads/supplements/NAV5.0StyleSheetTool1.0.htm <div dir="ltr"> <table border="1" cellpadding="0" cellspacing="0" id="table60064" style="border-width: 1px; border-style: solid; border-color: rgb(175, 175, 175); width: 100%;"><tbody> <tr class="current"> <td><strong>Issue</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><span rel="tempredactor">Navision 5.0 and Office 2003 Integration</span><br></p> <p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <table cellpadding="0" cellspacing="0" style="box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(80, 99, 135); font-family: Verdana, Arial, sans-serif;" width="100%"><tbody style="box-sizing: border-box;"></tbody></table> </td> </tr> <tr class="current"> <td><strong>Solution</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><span class="current">Please note that NAV 5.0 will work with Office 2003 as long as you go into the Office 2003 installion CD, click on "customize" and add the "Collaboration Data Object".</span><br><br>NAV 5.0 will not work with Office 2003 without running this routine.<br><br><br><span lang="EN-US">Here is the PartnerSource link where you can download the NAV Style Sheet Tool and reading material:<br style="box-sizing: border-box;"><br style="box-sizing: border-box;"><span lang="EN-US" style="box-sizing: border-box;"><a href="https://mbs.microsoft.com/partnersource/downloads/supplements/NAV5.0StyleSheetTool1.0.htm" style="box-sizing: border-box; font-stretch: normal; line-height: normal;">https://mbs.microsoft.com/partnersource/downloads/supplements/NAV5.0StyleSheetTool1.0.htm</a></span></span></p> <p style="box-sizing: border-box; line-height: 14px;"><br></p> </td> </tr> </tbody></table> <br><br><p><br></p> <div dir="ltr"> <p style="box-sizing: border-box; margin: 0in 0in 12pt; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br></p> <p><br></p> <p><br></p> <div dir="ltr"> <p><br></p> <p><br></p> <p><br></p> </div> </div> </div> 17000122157 41 17000037313 2016-12-12T15:10:05-07:00 17002649915 5 Navision 5.0 and Office 2003 Integration Navision 5.0 and Office 2003 Integration Microsoft,Dynamics,NAV,ODT,Edsuite,Installation,navision,5.0,office-2003,integration 2 0 0 Navision 5.0 and Office 2003 Integration 2016-12-13T10:17:07-07:00 17002649915 1 2016-12-07T12:19:28-07:00 0 0 Issue Error Message: The snap in could not be created. The snap-in might have been installed incorrectly. Name: C/SIDE Database Server for Microsoft Dynamics NAV Manager  CLSID: {8DF9BE89-78AC-44A4A5A0-E6CC081E7BC4}  Solution Cause: This problem occurs because some files that are required for the snap-in console are missing. Solution: To resolve this problem, reinstall the missing files. To do this, install the Microsoft Visual C++ 2005 Redistributable Package. To obtain this package, visit the following Microsoft Web site: http://www.microsoft.com/downloads/details.aspx?familyid=32BC1BEE-A3F9-4C13-9C99-220B62A191EE <div dir="ltr"> <table border="1" cellpadding="0" cellspacing="0" id="table60064" style="border-width: 1px; border-style: solid; border-color: rgb(175, 175, 175); width: 100%;"><tbody> <tr class="current"> <td><strong>Issue</strong></td> <td> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><span rel="tempredactor">Error Message:</span><br></p> <br><br><span rel="tempredactor" style='font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 13px;'>The snap in could not be created.</span><br><br><span rel="tempredactor" style='font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 13px;'>The snap-in might have been installed incorrectly.</span><br><br><span rel="tempredactor" style='font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 13px;'>Name: C/SIDE Database Server for Microsoft Dynamics NAV Manager </span><br><br><span rel="tempredactor" style='font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 13px;'>CLSID: {8DF9BE89-78AC-44A4A5A0-E6CC081E7BC4} </span><br><p style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><br></p> <table cellpadding="0" cellspacing="0" style="box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(80, 99, 135); font-family: Verdana, Arial, sans-serif;" width="100%"><tbody style="box-sizing: border-box;"></tbody></table> </td> </tr> <tr class="current"> <td><strong>Solution</strong></td> <td class="current"> <p class="current" style="box-sizing: border-box; margin-bottom: 10px; line-height: 14px;"><strong>Cause:<br style="box-sizing: border-box;"><br style="box-sizing: border-box;"></strong>This problem occurs because some files that are required for the snap-in console are missing.<br><br><strong>Solution:<br style="box-sizing: border-box;"><br style="box-sizing: border-box;"></strong>To resolve this problem, reinstall the missing files. To do this, install the Microsoft Visual C++ 2005 Redistributable Package. To obtain this package, visit the following Microsoft Web site: <br><a href="http://www.microsoft.com/downloads/details.aspx?familyid=32BC1BEE-A3F9-4C13-9C99-220B62A191EE" style="background-color: rgb(255, 255, 255); color: rgb(0, 0, 153); font-size: 12px; line-height: normal; font-family: Verdana, Arial, sans-serif;">http://www.microsoft.com/downloads/details.aspx?familyid=32BC1BEE-A3F9-4C13-9C99-220B62A191EE</a><br></p> <p style="box-sizing: border-box; line-height: 14px;"><br></p> </td> </tr> </tbody></table> <br><br><p><br></p> <div dir="ltr"> <p style="box-sizing: border-box; margin: 0in 0in 12pt; color: rgb(0, 0, 0); font-size: 12px; line-height: 14px; font-family: Verdana, Arial, sans-serif;"><br></p> <p><br></p> <p><br></p> <div dir="ltr"> <p><br></p> <p><br></p> <p><br></p> </div> </div> </div> 17000122157 57 17000037315 2016-12-12T15:09:57-07:00 17002649915 6 rror Message When Creating Snap-In Console for NAV C/SIDE Database Server rror Message When Creating Snap-In Console for NAV C/SIDE Database Server Microsoft,Dynamics,NAV,ODT,Edsuite,Installation,navision,create,error,snap-in,console,C-SIDE 2 0 0 Error Message When Creating Snap-In Console for NAV C/SIDE Database Server 2016-12-13T10:17:07-07:00 17002649915 1 2017-07-20T15:30:13-06:00 0 0 Remember if you are implementing Zetadocs that your Dynamics NAV license must be updated to include the granule 9.009.970 https://attendee.gotowebinar.com/register/8253119379209757697 Are you doing this on your own and looking for assistance?  ODT can help.  Feel free to reach out to us today. <p>Remember if you are implementing Zetadocs that your Dynamics NAV license must be updated to include the granule 9.009.970</p><p><br></p><a href="https://attendee.gotowebinar.com/register/8253119379209757697">https://attendee.gotowebinar.com/register/8253119379209757697</a><p><br></p><p>Are you doing this on your own and looking for assistance?  ODT can help.  Feel free to reach out to us today.</p> 17000122157 48 17000055761 2017-07-20T15:30:13-06:00 17000265439 7 Zetadocs 9 Implementation Installation Webinar Zetadocs 9 Implementation Installation Webinar Dynamics,NAV,Addon,Zetadocs,Installation,Implementation,Webinar,Video 2 0 0 Zetadocs 9 Implementation Webinar 2017-07-20T15:30:13-06:00 17000265439 1 2017-07-21T12:27:34-06:00 0 0 This article describes how you can find the version and build number for your Microsoft Dynamics NAV solution. Overview This article describes how you can find the build number for the Microsoft Dynamics NAV executables in Microsoft Dynamics NAV 2015+, 2013, 2009 and in Microsoft Dynamics NAV 5.0 (or prior). Also, the article describes how you can find the build number from the properties of the Microsoft Dynamics NAV executables files for the Microsoft Dynamics NAV Classic client, RoleTailored client, NAV server, and Application server. Microsoft Dynamics NAV 2015 and later Windows Client Click the Dynamics Menu button (blue with a white arrow) at the top left corner of  the Role Center and select Help and then About Microsoft Dynamics NAV. The About Microsoft Dynamics NAV window shows the version of the Microsoft Dynamics NAV database and the client executables similar to the following: Microsoft Dynamics NAV 2017 Version US Dynamics NAV 10.0 10.0.13682.0 Where US Dynamics NAV 10.0 is the country and product version of the Microsoft Dynamics NAV database  13682 is the build number of the client executables Microsoft Dynamics NAV 2013 Windows Client Click the Dynamics Menu button (blue with a white arrow) at the top left corner of  the Role Center and select Help and then About Microsoft Dynamics NAV. The About Microsoft Dynamics NAV window shows the version of the Microsoft Dynamics NAV database and the client executables similar to the following: Microsoft Dynamics NAV 2013 Version US Dynamics NAV 7.0 7.0.39671.0 Where US Dynamics NAV 7.0 is the country and product version of the Microsoft Dynamics NAV database  39671 is the build number of the client executables Microsoft Dynamics NAV 2009 RoleTailored Client Click the Help button (Question Mark) at the top right corner of  the Role Center and select About Microsoft Dynamics NAV. The About Microsoft Dynamics NAV window shows the version of the Microsoft Dynamics NAV database and the client executables similar to the following: Microsoft Dynamics NAV 2009 R2 Version US 6.0 R2 6.0.32012.0 Where US 6.0 R2 is the country and product version of the Microsoft Dynamics NAV database  6.0.32012.0 is the build number of the client executables Classic Client Click Help on the Menu Bar and select About Microsoft Dynamics NAV.  The About Microsoft Dynamics NAV window shows the version of the Microsoft Dynamics NAV database and the client executables similar to the following: Microsoft Dynamics NAV 2009 R2 Version US 6.0 R2 (6.00.32012) Where US 6.0 R2 is the country and product version of the Microsoft Dynamics NAV database  6.00.32012 is the build number of the client executables Microsoft Dynamics NAV 5.0 (and prior) Classic Client Click Help on the Menu Bar and select About Microsoft Dynamics NAV. The About Microsoft Dynamics NAV window shows the version of the Microsoft Dynamics NAV database and the client executables similar to the following: Version US Dynamics NAV 5.0 SP1 (5.0 SP1) Where US 5.0 SP1 is the country and product version of the Microsoft Dynamics NAV database  (5.0 SP1) is the version of the client executables. To find the build number of the Microsoft Dynamics NAV 5.0 executables, double-click the version line (Version US Dynamics NAV 5.0 SP1 (5.0 SP1)). A dialog box opens, which displays the build number of the executables. How to find the build number from the properties of the executables files You can also find the build number for the Microsoft Dynamics NAV executables from the properties of the executables files. Locate the executables file Right-click the file Select the Details tab File version shows the build number of the executables file The following lists the executables files for Microsoft Dynamics NAV and the default location of these files: Microsoft Dynamics NAV Classic client Fin.exe (native client) Finsql.exe (SQL Server client) Default location Microsoft Dynamics NAV 2009 R2  C:\Program Files (x86)\Microsoft Dynamics NAV\61\Classic Microsoft Dynamics NAV 2009 C:\Program Files (x86)\Microsoft Dynamics NAV\60\Classic Microsoft Dynamics NAV 5.0  C:\Program Files\Microsoft Dynamics NAV\CSIDE Client Microsoft Dynamics NAV RoleTailored client (version 2009 and later) Microsoft.dynamics.nav.client.exe Default location Microsoft Dynamics NAV 2017 C:\Program Files (x86)\Microsoft Dynamics NAV\90\RoleTailored Client Microsoft Dynamics NAV 2017 C:\Program Files (x86)\Microsoft Dynamics NAV\80\RoleTailored Client Microsoft Dynamics NAV 2016 C:\Program Files (x86)\Microsoft Dynamics NAV\80\RoleTailored Client Microsoft Dynamics NAV 2015 C:\Program Files (x86)\Microsoft Dynamics NAV\70\RoleTailored Client Microsoft Dynamics NAV 2009 R2  C:\Program Files (x86)\Microsoft Dynamics NAV\61\RoleTailored Client Microsoft Dynamics NAV 2009 C:\Program Files (x86)\Microsoft Dynamics NAV\60\RoleTailored Client Microsoft Dynamics NAV Server (version 2009 and later) Microsoft.dynamics.nav.server.exe Default location C:\Program Files\Microsoft Dynamics NAV\XXX\Service Microsoft Dynamics NAV Application Server Nas.exe Nassql.exe Default location Microsoft Dynamics NAV 2009 C:\Program Files\Microsoft Dynamics NAV\XX\Application Server Microsoft Dynamics NAV 5.0 C:\Program Files\Microsoft Dynamics NAV\Application Server <p>This article describes how you can find the version and build number for your Microsoft Dynamics NAV solution.</p><p><br></p><table border="1" cellpadding="4" cellspacing="0" width="800"><tbody> <tr><td><h2>Overview</h2></td></tr> <tr><td>This article describes how you can find the build number for the Microsoft Dynamics NAV executables in Microsoft Dynamics NAV 2015+, 2013, 2009 and in Microsoft Dynamics NAV 5.0 (or prior).<br><br>Also, the article describes how you can find the build number from the properties of the Microsoft Dynamics NAV executables files for the Microsoft Dynamics NAV Classic client, RoleTailored client, NAV server, and Application server.<br> </td></tr> </tbody></table><p><br></p><table border="1" cellpadding="4" cellspacing="0" width="800"><tbody> <tr><td><h2>Microsoft Dynamics NAV 2015 and later</h2></td></tr> <tr><td> <strong><u>Windows Client</u></strong><br><strong><u><img class="fr-dib fr-draggable" src="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/17013072176/original/X0vckkAnJGIc_Izb9JnyGdNQZy3XDkoBqA?1500660395" style="width: 258px; height: 166.941px;" data-filelink="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/17013072176/original/X0vckkAnJGIc_Izb9JnyGdNQZy3XDkoBqA?1500660395" data-fileid="17013072176" data-uniquekey="1500658722105"></u></strong><br><ol> <li>Click the Dynamics Menu button (blue with a white arrow) at the top left corner of  the Role Center and select Help and then About Microsoft Dynamics NAV.</li> <li>The About Microsoft Dynamics NAV window shows the version of the Microsoft Dynamics NAV database and the client executables similar to the following:</li> </ol> <blockquote dir="ltr"> <p><em>Microsoft Dynamics NAV 2017<br></em><em>Version US Dynamics NAV 10.0<br>10.0.13682.0</em></p> <p dir="ltr">Where</p> <ul dir="ltr"> <li> <em>US Dynamics NAV 10.0</em> is the country and product version of the Microsoft Dynamics NAV database </li> <li> <em>13682</em> is the build number of the client executables</li> </ul> </blockquote> </td></tr> </tbody></table><table border="1" cellpadding="4" cellspacing="0" width="800"><tbody> <tr><td><h2>Microsoft Dynamics NAV 2013</h2></td></tr> <tr><td> <strong><u>Windows Client</u></strong><br><strong><u><img class="fr-dib fr-draggable" src="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/17013072371/original/U-E0b-6aHAeV53Q_JG-cs_PkmU-A5WWpyQ?1500660762" style="width: 254px; height: 201.375px;" data-filelink="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/17013072371/original/U-E0b-6aHAeV53Q_JG-cs_PkmU-A5WWpyQ?1500660762" data-fileid="17013072371" data-uniquekey="1500658722105"></u></strong><br><br><ol> <li>Click the Dynamics Menu button (blue with a white arrow) at the top left corner of  the Role Center and select Help and then About Microsoft Dynamics NAV.</li> <li>The About Microsoft Dynamics NAV window shows the version of the Microsoft Dynamics NAV database and the client executables similar to the following:<p><em>Microsoft Dynamics NAV 2013<br></em><em>Version US Dynamics NAV 7.0<br>7.0.39671.0</em></p> <p dir="ltr">Where</p> <ul dir="ltr"> <li> <em>US Dynamics NAV 7.0</em> is the country and product version of the Microsoft Dynamics NAV database </li> <li> <em>39671</em> is the build number of the client executables</li> </ul> </li> </ol> </td></tr> </tbody></table><p><br></p><table border="1" cellpadding="4" cellspacing="0" width="800"><tbody> <tr><td><h2>Microsoft Dynamics NAV 2009</h2></td></tr> <tr><td> <strong><u>RoleTailored Client</u></strong><br><strong><u><img class="fr-dib fr-draggable" src="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/17013073429/original/8nyB-YsOWby712NEMJtwEglJmKcDP0LBlg?1500662655" style="width: 248px; height: 177.733px;" data-filelink="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/17013073429/original/8nyB-YsOWby712NEMJtwEglJmKcDP0LBlg?1500662655" data-fileid="17013073429" data-uniquekey="1500661669151"></u></strong><br><ol> <li>Click the Help button (Question Mark) at the top right corner of  the Role Center and select About Microsoft Dynamics NAV.</li> <li>The About Microsoft Dynamics NAV window shows the version of the Microsoft Dynamics NAV database and the client executables similar to the following:</li> </ol> <blockquote dir="ltr"> <p><em>Microsoft Dynamics NAV 2009 R2<br></em><em>Version US 6.0 R2<br>6.0.32012.0</em></p> <p dir="ltr">Where</p> <ul dir="ltr"> <li> <em>US 6.0 R2</em> is the country and product version of the Microsoft Dynamics NAV database </li> <li> <em>6.0.32012.0</em> is the build number of the client executables</li> </ul> </blockquote> <p dir="ltr"><br></p> <p dir="ltr"><strong><u>Classic Client</u></strong></p> <p dir="ltr"><strong><u><img class="fr-dib fr-draggable" src="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/17013073399/original/gV60b4RaAFQsb3fgZdXawIY3Z0vhLBsyVQ?1500662606" style="width: 243px; height: 232.732px;" data-filelink="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/17013073399/original/gV60b4RaAFQsb3fgZdXawIY3Z0vhLBsyVQ?1500662606" data-fileid="17013073399" data-uniquekey="1500661669151"></u></strong><br></p> <ol dir="ltr"> <li>Click Help on the Menu Bar and select About Microsoft Dynamics NAV. </li> <li>The About Microsoft Dynamics NAV window shows the version of the Microsoft Dynamics NAV database and the client executables similar to the following:</li> </ol> <blockquote dir="ltr"> <p><em>Microsoft Dynamics NAV 2009 R2<br>Version US 6.0 R2 (6.00.32012)</em></p> <p>Where</p> <ul> <li> <em>US 6.0 R2</em> is the country and product version of the Microsoft Dynamics NAV database </li> <li> <em>6.00.32012</em> is the build number of the client executables</li> </ul> </blockquote> </td></tr> </tbody></table><p><br></p><table border="1" cellpadding="4" cellspacing="0" width="800"><tbody> <tr><td><h2>Microsoft Dynamics NAV 5.0 (and prior)</h2></td></tr> <tr><td> <strong><u>Classic Client</u></strong><br><strong><u><img class="fr-dib fr-draggable" src="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/17013073399/original/gV60b4RaAFQsb3fgZdXawIY3Z0vhLBsyVQ?1500662606" style="width: 243px; height: 232.732px;" data-filelink="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/17013073399/original/gV60b4RaAFQsb3fgZdXawIY3Z0vhLBsyVQ?1500662606" data-fileid="17013073399" data-uniquekey="1500661669151"></u></strong><br><ol> <li>Click Help on the Menu Bar and select About Microsoft Dynamics NAV.</li> <li>The About Microsoft Dynamics NAV window shows the version of the Microsoft Dynamics NAV database and the client executables similar to the following:</li> </ol> <blockquote dir="ltr"> <p><em>Version US Dynamics NAV 5.0 SP1 (5.0 SP1)</em></p> <p>Where</p> <ul> <li> <em>US 5.0 SP1</em> is the country and product version of the Microsoft Dynamics NAV database </li> <li> <em>(5.0 SP1)</em> is the version of the client executables.<ul><li>To find the build number of the Microsoft Dynamics NAV 5.0 executables, double-click the version line (Version US Dynamics NAV 5.0 SP1 (5.0 SP1)). A dialog box opens, which displays the build number of the executables.</li></ul> </li> </ul> </blockquote> </td></tr> </tbody></table><p><br></p><table border="1" cellpadding="4" cellspacing="0" width="800"><tbody> <tr><td><h2>How to find the build number from the properties of the executables files</h2></td></tr> <tr><td>You can also find the build number for the Microsoft Dynamics NAV executables from the properties of the executables files.<br><br><ol> <li>Locate the executables file</li> <li>Right-click the file</li> <li>Select the Details tab</li> <li>File version shows the build number of the executables file</li> </ol> <br>The following lists the executables files for Microsoft Dynamics NAV and the default location of these files:<br><ul><li> <strong>Microsoft Dynamics NAV Classic client</strong><ul> <li>Fin.exe (native client)</li> <li>Finsql.exe (SQL Server client)</li> </ul> </li></ul> <blockquote dir="ltr"> <p>Default location</p> <ul> <li> <strong>Microsoft Dynamics NAV 2009 R2</strong> <br>C:\Program Files (x86)\Microsoft Dynamics NAV\61\Classic</li> <li> <strong>Microsoft Dynamics NAV 2009<br></strong>C:\Program Files (x86)\Microsoft Dynamics NAV\60\Classic</li> <li> <strong>Microsoft Dynamics NAV 5.0</strong> <br>C:\Program Files\Microsoft Dynamics NAV\CSIDE Client</li> </ul> </blockquote> <ul><li> <strong>Microsoft Dynamics NAV RoleTailored client (version 2009 and later)</strong><ul><li>Microsoft.dynamics.nav.client.exe</li></ul> </li></ul> <blockquote dir="ltr"> <p>Default location</p> <ul> <li> <strong>Microsoft Dynamics NAV 2017<br></strong>C:\Program Files (x86)\Microsoft Dynamics NAV\90\RoleTailored Client</li> <li> <strong>Microsoft Dynamics NAV 2017<br></strong>C:\Program Files (x86)\Microsoft Dynamics NAV\80\RoleTailored Client</li> <li> <strong>Microsoft Dynamics NAV 2016</strong><br>C:\Program Files (x86)\Microsoft Dynamics NAV\80\RoleTailored Client</li> <li> <strong>Microsoft Dynamics NAV 2015<br></strong>C:\Program Files (x86)\Microsoft Dynamics NAV\70\RoleTailored Client</li> <li> <strong>Microsoft Dynamics NAV 2009 R2</strong> <br>C:\Program Files (x86)\Microsoft Dynamics NAV\61\RoleTailored Client</li> <li> <strong>Microsoft Dynamics NAV 2009<br></strong>C:\Program Files (x86)\Microsoft Dynamics NAV\60\RoleTailored Client</li> </ul> </blockquote> <ul><li> <strong>Microsoft Dynamics NAV Server (version 2009 and later)</strong><ul><li>Microsoft.dynamics.nav.server.exe</li></ul> </li></ul> <blockquote dir="ltr"> <p>Default location</p> <ul><li>C:\Program Files\Microsoft Dynamics NAV\XXX\Service</li></ul> </blockquote> <ul><li> <strong>Microsoft Dynamics NAV Application Server</strong><ul> <li>Nas.exe</li> <li>Nassql.exe</li> </ul> </li></ul> <blockquote dir="ltr"> <p>Default location</p> <ul> <li> <strong>Microsoft Dynamics NAV 2009<br></strong>C:\Program Files\Microsoft Dynamics NAV\XX\Application Server</li> <li> <strong>Microsoft Dynamics NAV 5.0<br></strong>C:\Program Files\Microsoft Dynamics NAV\Application Server</li> </ul> </blockquote> </td></tr> </tbody></table><p><br></p> 17000122157 1927 17000055841 2017-07-21T12:54:59-06:00 17000265439 8 How to find the Version and Build Number in Dynamics NAV How to find the Version and Build Number in Microsoft Dynamics NAV Microsoft,Dynamics,NAV,How to,Find,Version,Build,Information,Help 2 0 0 How to find the Version and Build Number in Microsoft Dynamics NAV 2017-07-21T12:27:34-06:00 17000265439 1 2017-11-16T17:37:21-07:00 0 0 Obtain a Computer Vision API key from https://azure.microsoft.com/en-us/try/cognitive-services/ using the Get API Key button. Note the Endpoint URL and Key 1 + 2 Example End Point URL to use is https://westcentralus.api.cognitive.microsoft.com/vision/v1.0/Analyze In Dynamics NAV go to the service connections and complete the setup of the "Image Analysis Setup" Important! : Ensure you ad "/Analyze" to the end of the API URL you add from the endpoint during your registration process. Create article to assist with this is found here:  https://community.dynamics.com/nav/b/katsonsnavblog/archive/2017/08/27/how-to-setup-image-analyzer-for-dynamics365-and-nav <p>Obtain a Computer Vision API key from <a href="https://azure.microsoft.com/en-us/try/cognitive-services/" rel="noreferrer noopener">https://azure.microsoft.com/en-us/try/cognitive-services/</a> using the Get API Key button.</p><p><br></p><p>Note the Endpoint URL and Key 1 + 2</p><p><br></p><p><img class="fr-dib fr-draggable" src="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/17018460122/original/KbdsNs8jZTzAtydY7PQUrVq2JW2CCXlQVA?1510878757" data-filelink="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/17018460122/original/KbdsNs8jZTzAtydY7PQUrVq2JW2CCXlQVA?1510878757" data-fileid="17018460122" data-uniquekey="1510878398041"></p><p><br></p><p>Example End Point URL to use is <a href="https://westcentralus.api.cognitive.microsoft.com/vision/v1.0/Analyze" rel="noreferrer">https://westcentralus.api.cognitive.microsoft.com/vision/v1.0/Analyze</a></p><p><br></p><p>In Dynamics NAV go to the service connections and complete the setup of the "Image Analysis Setup"</p><p><img class="fr-dib fr-draggable" src="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/17018460097/original/6yjBA2dYBL3Tq3ydesktIdHt-8ms7cu4Yw?1510878604" data-filelink="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/17018460097/original/6yjBA2dYBL3Tq3ydesktIdHt-8ms7cu4Yw?1510878604" data-fileid="17018460097" data-uniquekey="1510878398041"></p><p><br></p><p><img class="fr-dib fr-draggable" src="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/17018460106/original/t8PN_VGfE-HDe_kxvlLtxPP2EBKeGLrCsA?1510878641" data-filelink="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/17018460106/original/t8PN_VGfE-HDe_kxvlLtxPP2EBKeGLrCsA?1510878641" data-fileid="17018460106" data-uniquekey="1510878398041"></p><p>Important! : Ensure you ad "/Analyze" to the end of the API URL you add from the endpoint during your registration process.</p><p><br></p><p>Create article to assist with this is found here:  <a href="https://community.dynamics.com/nav/b/katsonsnavblog/archive/2017/08/27/how-to-setup-image-analyzer-for-dynamics365-and-nav" target="_blank" rel="noreferrer noopener">https://community.dynamics.com/nav/b/katsonsnavblog/archive/2017/08/27/how-to-setup-image-analyzer-for-dynamics365-and-nav</a></p><p><br></p> 17000122157 117 17000062883 2017-11-16T17:37:21-07:00 17000265439 9 Adding Image Analyzer to Dynamics NAV and 365 Financials How to setup and configur Image Analyzer to Dynamics NAV and 365 Financials Dynamics NAV,Service Connection,Image,Analyzer,API,Setup,Configuration 2 0 0 Adding Image Analyzer to Dynamics NAV and 365 Financials 2017-11-16T17:37:21-07:00 17000265439