tag:blogger.com,1999:blog-30093713174036462122024-03-17T05:14:47.019-04:00 Kulla's NAV BlogThe best source of knowledge is experienceSuresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.comBlogger147125tag:blogger.com,1999:blog-3009371317403646212.post-41622914917998652862019-08-20T11:36:00.001-04:002019-08-20T11:36:24.368-04:00Weird Internal Server Error on Publishing Extension<p>I am working on a AL project which is on NAV 2018, and I have run into the below error several times now</p> <p><a href="https://drive.google.com/uc?id=1KCDrD8nZ9T7nJKt58hym-4aVEvFZwOB1"><img title="image" style="display: inline; background-image: none;" border="0" alt="image" src="https://drive.google.com/uc?id=1JSRklDFwlXkT7Fuxn-S_QwgyZ4ozyyTE" width="829" height="62" /></a></p> <p>This happens when I publish my extension from VS Code using F5, the packing is created successfully but it fails to publish with the above error message, sometimes the error message is very vague like <strong><font color="#ff0000">Internal Error occured…..</font></strong> </p> <p>I am not sure if it has to do with this specific version of cumulative update or NAV 2018, but below are the steps I took to resolve the issue</p> <ul> <li>1.  If you have a web client/Win client open or even powershell command prompt from the container then close all of those and try again.  This trick did work sometimes but not always.</li> <li>2.  Restart the docker container using VS Code Docker Extension or using command prompt </li> <li>     docker restart <containerid></li> </ul> <p>I believe running Sync-NAVTenant may resolve it but I could not launch the powershell, it just closes abruptly and nothing in the docker logs about the error message</p> <p> </p> <p> </p> <ul> <ul> <li></li> </ul> </ul>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com3tag:blogger.com,1999:blog-3009371317403646212.post-69237308566778529862019-08-09T21:05:00.001-04:002019-08-09T21:05:17.521-04:00How to handle changes in NAV/BC when event does not exist ?<p align="justify"><a href="https://drive.google.com/uc?id=1b9-le8IxW-6GlYOAKBnP8wJXDs9XDlSI"><img title="questions-4304981_1920" style="display: inline; background-image: none;" border="0" alt="questions-4304981_1920" src="https://drive.google.com/uc?id=1wRRAc8g862WyEQcKJ0nb6o8Les72adrF" width="244" height="150" /></a></p> <p align="justify">In the NAV2018/BC we are using AL for development and build extensions for our customizations using table/page extensions and events.  But in NAV 2018  and also in BC <strong>on premise</strong> versions there are certain cases where we don’t find the event to subscribe, in that case how should we handle the modification ? and avoid any conflicts in the next upgrade. </p> <p align="justify">In those scenarios, should we modify the base objects like the old way ?</p> <p align="justify">Sometimes events even get trickier. Such as I want to exit from a calling function without executing the next line of code, after the event is executed ? This is not possible unless you design the event in that way. In this case, the event should have a variable as parameter, which we set in the subscriber function based on our condition, and if that is true, in the calling function there is already a code added to check that value and exit. Everyone has a unique requirement, so designing events this way is little harder. I think in the future the events may evolve where we will have a way to define that. Anyhow, I ran into this kind of situations only couple of times. </p> <p align="justify">The real question is how we handle the modification when there is no event available to subscribe. This is the procedure I am following and sure there are better ways to handle it. I usually check if the same object in the newest cumulative update or in the new version, if there is any event added, then I try to copy that and update the object in our version, that way it will not create any conflict during the upgrade.</p> <p align="justify">For example, I have a created a new field on the Ship-to Address and Sales Header table called “Locality”, so when a ship-to code is selected, I want to transfer the Locality value from the respective Ship-to Address table to Sales Header. In NAV 2018 version CU 14, I don’t have any events available to subscribe to transfer the value, but in the newest version I found this event <strong>“OnAfterCopyShipToCustomerAddressFieldsFromShipToAddr”</strong></p> <p align="justify"> </p> <p align="justify"><a href="https://drive.google.com/uc?id=12FjL1_-KLNhMQYH1owwcIljR7PiHmp_K"><img title="image" style="display: inline; background-image: none;" border="0" alt="image" src="https://drive.google.com/uc?id=15AOPNE_EWcZxDrj1zTlW-txDoK0FUrXf" width="859" height="173" /></a></p> <p align="justify">I have just copied over that event from the new version to my version. Then in my extension, I have created a subscriber Codeunit and subscribed to the function.  </p> <p align="justify">If I don’t find a event, then I will create my own event, and try to name it properly, following the standards MS is using that way in future version if they add anything it may reflect. Also suggest/ask the product team in the below link</p> <p align="justify"><a href="https://experience.dynamics.com"><font color="#0000ff"><u>https://experience.dynamics.com</u></font></a></p> <ul> <li><a href="https://experience.dynamics.com/ideas/categories/?forum=e288ef32-82ed-e611-8101-5065f38b21f1&forumName=Dynamics%20365%20Business%20Central"><font color="#0000ff"><u>https://experience.dynamics.com/ideas/categories/?forum=e288ef32-82ed-e611-8101-5065f38b21f1&forumName=Dynamics%20365%20Business%20Central</u></font></a></li> </ul>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com4tag:blogger.com,1999:blog-3009371317403646212.post-80123913566323972922019-08-08T12:33:00.001-04:002019-08-08T12:38:59.627-04:00Cannot import the data because the table with the ID ….<div style="text-align: left;" dir="ltr" trbidi="on">
Few weeks ago, I was trying to import a company from a Test database to Development database. I have exported the data from the test database using the <em>Export to Data File</em> option which creates a .navdata file and if the both databases have the same schema you can import that file into another database. </div><div style="text-align: left;" dir="ltr" trbidi="on"><br>
You can read more about How to Export/Import Data from the below link<br>
<a href="https://docs.microsoft.com/en-us/dynamics-nav/exporting-and-importing-companies-and-other-data"><u><span style="color: blue;">https://docs.microsoft.com/en-us/dynamics-nav/exporting-and-importing-companies-and-other-data</span></u></a></div><div style="text-align: left;" dir="ltr" trbidi="on"><br>
In my case, both databases have the same schema, but when I try to use the Import Data, I got the below error<br>
<span style="color: red;">Cannot import the data because the table with the ID 27 in the specified file has different fields or key definitions than the application database. Make sure that you are importing data into the same application as it was exported from</span></div><div style="text-align: left;" dir="ltr" trbidi="on"><span style="color: red;"></span><br>
<span style="color: black;">I have check the Table 27 in both databases and they have the same schema, but I still get the same error. I have compiled the objects, and restarted the NAV Service just to confirm the schema is in sync but that did not resolve the issue. </span><br>
<span style="color: black;"><br></span>
</div><div class="separator" style="text-align: center; clear: both;" dir="ltr" trbidi="on">
<a style="margin-right: 1em; margin-left: 1em;" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOOmBcq1WBnBbtzPE2T79EHJqXiafNO-kKDJLEw9iBKACLmFzETVays6a8BxcM023-I3s7Mpf3f6JKLGMQ_Sv_RBnyTAKVuM522IpOXIoamj0dC59_DXKqhmRwmOIMjwL1O_7QEkAkXb45/s1600/InstalledExtension.png" imageanchor="1"><img width="320" height="169" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOOmBcq1WBnBbtzPE2T79EHJqXiafNO-kKDJLEw9iBKACLmFzETVays6a8BxcM023-I3s7Mpf3f6JKLGMQ_Sv_RBnyTAKVuM522IpOXIoamj0dC59_DXKqhmRwmOIMjwL1O_7QEkAkXb45/s320/InstalledExtension.png" border="0" data-original-width="596" data-original-height="316"></a></div><div style="text-align: left;" dir="ltr" trbidi="on">
<span style="color: black;"><br></span>
<span style="color: black;"><br></span>
The issue was I have a extension <strong>(“Sales and Inventory Forecast”)</strong> installed in Test Database but not in the other database, so I have uninstalled the extension from the Test database and re-exported the data. This time the import ran without any error.</div><div style="text-align: left;" dir="ltr" trbidi="on"><br>
So, when you use Export/Import Data option, make sure you check the same extensions are installed in both the databases. </div>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com4tag:blogger.com,1999:blog-3009371317403646212.post-76236611017258728942019-08-08T11:54:00.001-04:002019-08-08T11:54:00.822-04:00Released Cumulative Updates for NAV and D365BC<p>List of released cumulative updates for supported DynNAV and D365BC versions<p>Released Cumulative Updates for Microsoft Dynamics NAV 2015 <p><a href="https://support.microsoft.com/en-us/help/3014609/released-cumulative-updates-for-microsoft-dynamics-nav-2015"><font color="#0000ff">support.microsoft.com/.../released-cumulative-updates-for-microsoft-dynamics-nav-2015</font></a><p>Released Cumulative Updates for Microsoft Dynamics NAV 2016 <p><a href="https://support.microsoft.com/en-us/help/3108728/released-cumulative-updates-for-microsoft-dynamics-nav-2016"><font color="#0000ff">support.microsoft.com/.../released-cumulative-updates-for-microsoft-dynamics-nav-2016</font></a><p>Released Cumulative Updates for Microsoft Dynamics NAV 2017 <p><a href="https://support.microsoft.com/en-us/help/3210255/released-cumulative-updates-for-microsoft-dynamics-nav-2017"><font color="#0000ff">support.microsoft.com/.../released-cumulative-updates-for-microsoft-dynamics-nav-2017</font></a><p>Released Cumulative Updates for Microsoft Dynamics NAV 2018 <p><a href="https://support.microsoft.com/en-us/help/4072483/released-cumulative-updates-for-microsoft-dynamics-nav-2018"><font color="#0000ff"><u>support.microsoft.com/.../released-cumulative-updates-for-microsoft-dynamics-nav-2018</u></font></a><p>Released Cumulative Updates for Microsoft Dynamics 365 Business Central Spring 2019 release (v14) <p><a href="https://support.microsoft.com/en-us/help/4501292/released-cumulative-updates-for-microsoft-dynamics-365-business"><u><font color="#0000ff">support.microsoft.com/.../released-cumulative-updates-for-microsoft-dynamics-365-business</font></u></a><p>Released Cumulative Updates for Microsoft Dynamics 365 Business Central Fall 2018 release (v13) <p><a href="https://support.microsoft.com/en-us/help/4470116/released-cumulative-updates-for-microsoft-dynamics-365-business"><u><font color="#0000ff">support.microsoft.com/.../released-cumulative-updates-for-microsoft-dynamics-365-business</font></u></a></p>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com1tag:blogger.com,1999:blog-3009371317403646212.post-19411849540248715442019-03-22T07:55:00.001-04:002019-03-22T07:55:17.725-04:00You have not been granted permission to perform the current activity<div dir="ltr" style="text-align: left;" trbidi="on">
Today, when I try to launch the debugger, I got the below error <br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZzjkCVKmq9Moi6h5P6u69rhvzgNzGTGEfq4Brquu6Yx0Zeh2OX9Z5USmV5pDieuhNFLElCE-1L0JiFJ2W4d37mAwciIdwa8n2Gip0AXOocuxOiKcCkHSS5E0EhzNoj-P5vvIJKAeUxvKI/s1600/Error.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="134" data-original-width="430" height="196" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZzjkCVKmq9Moi6h5P6u69rhvzgNzGTGEfq4Brquu6Yx0Zeh2OX9Z5USmV5pDieuhNFLElCE-1L0JiFJ2W4d37mAwciIdwa8n2Gip0AXOocuxOiKcCkHSS5E0EhzNoj-P5vvIJKAeUxvKI/s640/Error.jpg" width="640" /></a></div>
<br />
<br />
I have checked my permissions in the Navision, and I have SUPER, and there is no company specified for the permission set. So I have compared my permissions with other users, and I haven’t noticed anything different on the NAV side.<br />
<br />
Then I opened the SQL Server and checked the Access Control table; then I spotted one difference with my permission set SUPER and with another user who has the same permission set. The [App ID] column has value for my permission set, but it is to 00000000-0000-0000-0000-000000000000 for the other user.<br />
<br />
I ran a simple UPDATE query for my [User Security ID] to set the [App ID] to 00000000-0000-0000-0000-000000000000, and that resolved my issue<br />
<br />
If you have any other tips or suggestions, please do share them in the comments below.</div>
Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com4tag:blogger.com,1999:blog-3009371317403646212.post-49576768609821311682019-01-04T16:29:00.001-05:002019-01-04T16:29:07.172-05:00Print Send To Excel do not export all columns<p align="justify">Few weeks ago, I ran into a strange issue and in this blog I will discuss the issue and the solution which worked for me.</p><p align="justify">I got a requirement to add the salesperson code and sell-to customer name to the salesline page, since those fields are not part of the salesline table, I have added the code on the salesline list page to retrieve the salesheader record and display those values on the page.</p><p align="justify">Everything worked well, but when we try to use the Print –> Send to Excel option those custom fields are not available on the excel. Couple of users were able to get those fields on the excel but not all the users. </p><p align="justify">Initially I thought it could be a permission issue on the sales header table but that was not the case, even user with SUPER permission has the same issue. We have checked if the excel version is different between those users but that’s not the case, everybody is running the same version. I have searched the Cumulative updates if there is bug or fix for that kind of error but unfortunately I have not found anything related.</p><p align="justify">I have found a standard page which uses the similar kind of logic, the page is “Customer Order Lines Status” with ID 10010 which uses the same kind logic which it displays the status from the salesheader table and I have ran into same issue with that page, all fields were exported except the salesheader fields.</p><p align="justify">Finally, I saw one difference between the users who are able to export all the fields and other, and that is the DynamicsNAV menu on the Excel, The users who have the DynamicsNAV menu are not able to export all the fields, so I went ahead and disabled the DynamicsNAV Add-on. </p><p align="justify">Voila, that resolved the issue. I have not uninstalled<strong> just disabled</strong> it, if you uninstall nothing will export. I am not sure what is the reason but that resolved my issue. </p><p align="justify">Here are the steps to disable the add-on</p><p align="justify">1. Open Excel, Go To File –> Options</p><p align="justify">2. Select Add-Ins and in the bottom select the Go beside Mange Add-ons</p><p align="justify">3. Uncheck the box for the Dynamics NAV and Click Ok</p><p align="justify"><a href="https://lh3.googleusercontent.com/-g_EG_qK6nmg/XC_QHWxHHPI/AAAAAAAAkOA/Dijj4DSZgVM6jaXSgxiQC1XbtqO7nyjxACHMYCw/s1600-h/DisableNAVAddIn%255B3%255D"><img width="759" height="410" title="DisableNAVAddIn" style="display: inline;" alt="DisableNAVAddIn" src="https://lh3.googleusercontent.com/-sdbU_JJ1fSA/XC_QIRTnEvI/AAAAAAAAkOE/Tus4YvU5pU4bUX4vPKXZg6SZfed9e8X4QCHMYCw/DisableNAVAddIn_thumb%255B1%255D?imgmax=800"></a></p><p align="justify">I hope this will help others who run into the same issue. </p><p align="justify">Please leave your comments/suggestions.</p><p align="justify"><br></p><p align="justify"><br></p><p align="justify"></p>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com9tag:blogger.com,1999:blog-3009371317403646212.post-61434449816507350232018-10-04T20:00:00.001-04:002018-10-04T20:06:48.789-04:00Business Central Web Client Search Improvements<p>With the release of Business Central OnPremise one major change they introduced is the UI of the web client. It is same UI which was released earlier for Business Central Cloud Version. It has rich interface and the look and feel is way different then earlier versions.</p><p><a href="https://lh3.googleusercontent.com/-QkcARV0ATus/W7apdf2K_mI/AAAAAAAAkJM/qzpt2NNkBH4BdsZhUjD4EBXjy-WTgBDbwCHMYCw/s1600-h/image%255B12%255D"><img width="407" height="300" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-lWTDL2EhtDI/W7apjDHdnVI/AAAAAAAAkJQ/PGg8y-0ti1MUt9L7g4oP75lLFXsijCBGwCHMYCw/image_thumb%255B8%255D?imgmax=800" border="0"></a><a href="https://lh3.googleusercontent.com/-NGXx0s6zSCU/W7apj2XN13I/AAAAAAAAkJU/KfFKwKe-z6o28j8mv4ypAxSdCdU3tEIswCHMYCw/s1600-h/image%255B11%255D"><img width="443" height="273" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-XwjCrqvLmRU/W7apkT8ptgI/AAAAAAAAkJY/4OK0llYA5gUWMUG7ECR5ceDGjfazLEN0gCHMYCw/image_thumb%255B7%255D?imgmax=800" border="0"></a></p><p><br></p><p>We always used to use the search for finding pages/reports but with new search they have broadened the scope and now can search can be used to find the actions available on that page. As shown below on the Sales Order Page, when I search for post it displayed the actions with that name and also other pages. You can directly launch those actions from this page or open other pages.</p><p>The new search is called “Tell Me” and you can access Tell Me from anywhere from the application and the keyboard shortcut is <strong>Alt+Q</strong> </p><p><br></p><p><a href="https://lh3.googleusercontent.com/-hgWFw9BSGcE/W7apk8YSrlI/AAAAAAAAkJc/IboQZRdOsOEDte5PkOZyntobCaG0QC16QCHMYCw/s1600-h/image%255B16%255D"><img width="370" height="372" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-yfQMvJcp4Uw/W7apldNmzTI/AAAAAAAAkJg/sgBojRgTE-gKYV6SpsnwzPQXcGOpVvJuACHMYCw/image_thumb%255B10%255D?imgmax=800" border="0"></a></p><p>This is a great improvement and very useful when you have lot of actions on a page.</p>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com5tag:blogger.com,1999:blog-3009371317403646212.post-14854709113116886412018-10-03T21:11:00.001-04:002018-10-08T06:43:16.917-04:00Business Central OnPremise DEV License Error (Update)<p><strong><font size="3">Update: This issue is resolved now. You need to regenerate your license and it should work.</font></strong></p><p>I have installed Business Central On Premise and uploaded over DEV license. Unfortunately the license did not work and I keep getting the below error</p><p><a href="https://lh3.googleusercontent.com/-SuhTmyEgwA8/W7VosnnnimI/AAAAAAAAkIQ/Nl9DT8zVYHQcgb2-ZK5yPMB0YBceHUlswCHMYCw/s1600-h/image%255B3%255D"><img width="410" height="177" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/--RvgzhzvNlU/W7VotQAcksI/AAAAAAAAkIU/KXfXY3m_VM8VXn4d5kJUsAkcqBtxLimZgCHMYCw/image_thumb%255B1%255D?imgmax=800" border="0"></a></p><p>I am getting the same error on the Web Client. Initially, I thought it may be an issue with the license or how it was generated but a quick search found the below twitter post which mentions it is a known issue and they are working on it. </p><p><a href="https://lh3.googleusercontent.com/-DNCGfNIphzg/W7Votwr6T0I/AAAAAAAAkIY/yGHTlcy95jAPhIRuBLfnGBUhoxm7C-JOACHMYCw/s1600-h/image%255B7%255D"><img width="691" height="147" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-1_78vWaHoPc/W7Vout32geI/AAAAAAAAkIc/c3kfWjtaRA8fJXA067Um7BMtPluwFm8IgCHMYCw/image_thumb%255B3%255D?imgmax=800" border="0"></a></p><p><br></p><p><a href="https://lh3.googleusercontent.com/-CSA3H3Aw5n8/W7VouwK1aSI/AAAAAAAAkIg/JwqzxMZkIIokvBH1hzry_d32C77JlknwwCHMYCw/s1600-h/image%255B12%255D"><img width="596" height="320" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-V12VPUC363M/W7VovbZluXI/AAAAAAAAkIk/bO6gr6tZFKwFM2uP4g7BMBUV5_GN_70KwCHMYCw/image_thumb%255B6%255D?imgmax=800" border="0"></a></p><p>But the question is how do I access the client now, so I tried to upload the license which I found on the DVD in the below path and the same license file (Cronus.flf) is also located in few other folders on the DVD, but none of them worked.</p><p>RoleTailoredClient\program files\Microsoft Dynamics NAV\130\RoleTailored Client</p><p>The license we need in this case is not Cronus.flf but <strong>Master.flf</strong> which is located in the SQLDemoDatabase folder. This let me login into Business Central Web Client and RTC.</p><p>I hope the DEV license error will be resolved soon. </p>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com24tag:blogger.com,1999:blog-3009371317403646212.post-56804165810176608612018-10-02T21:19:00.001-04:002018-10-02T21:19:51.595-04:00Good Bye to C/AL and RTC Client<p>There are several new things and lot of information is being shared during Directions NA. Unfortunately I was not there but the community was so active sharing the news through twitter posts /blogs which really helps people who did not attend. Thank you everyone for sharing the information.</p><p>One thing they announced was Dynamics 365 Business Central Road Map. As you can see it clearly shows by 2020 the only client available would be Web Client and the Programming language is AL. Although, I am not sure how this will end up by 2020 but based upon the progress we have made in last couple of years it is quite possible.</p><p><a href="https://lh3.googleusercontent.com/-cRizV2-2z08/W7QZNEL2bqI/AAAAAAAAkH4/qNEjGUlUV0k5GIgIM1TqUWvd0oJmCmf3ACHMYCw/s1600-h/image%255B3%255D"><img width="747" height="459" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-6VXHbutYMf0/W7QZNumBWhI/AAAAAAAAkH8/rhAD65CGJKs3AbueiJ7-HS8pwDpYeC_nACHMYCw/image_thumb%255B1%255D?imgmax=800" border="0"></a></p><p>Although we still be using CAL / RTC client on older versions this will fade away as people upgrade or try to take the advantage of SAAS version of Business Central. </p><p>There are lot of improvement being made every month with AL, whether it is adding more events to subscribe or new functionality to make it available. </p><p>You can also become a contributor to the AL on GitHub for more information please check the following link</p><p><a title="https://blogs.msdn.microsoft.com/nav/2018/08/28/become-a-contributor-to-business-central/" href="https://blogs.msdn.microsoft.com/nav/2018/08/28/become-a-contributor-to-business-central/"><font color="#0000ff"><u>https://blogs.msdn.microsoft.com/nav/2018/08/28/become-a-contributor-to-business-central/</u></font></a></p>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com1tag:blogger.com,1999:blog-3009371317403646212.post-27435626450637087622018-10-02T20:56:00.001-04:002018-10-02T20:56:29.604-04:00Dynamics 365 Business Central On Premise<p><a href="https://lh3.googleusercontent.com/-bd42R4cnFeM/W7QTs31R1BI/AAAAAAAAkHY/1ga6m5OMMK80H2GsX9m_bCXq2fr0x_DrwCHMYCw/s1600-h/image%255B3%255D"><img width="564" height="151" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-C1jGb_5wSjo/W7QTtq5W8-I/AAAAAAAAkHc/LdztSFNJEp8b3B1MsCa3_VOJRhsYKPI1gCHMYCw/image_thumb%255B1%255D?imgmax=800" border="0"></a></p><p>On October 1st, during DirectionsNA it is officially announced that Dynamics 365 Business Central On Premise will be available to download.</p><p>You can download the software if you have Partner Source Access ,from here <a href="http://bit.ly/2IxcNFX" target="_blank"><strong><font color="#0000ff">Download</font></strong></a></p><p>One of the big difference/change in this version is the Web Client and its features. </p><p><a href="https://lh3.googleusercontent.com/-uEmvOyBZSFo/W7QTuXBhRMI/AAAAAAAAkHg/Y8tVG6vpMBElBAalPKJhPm1LANnGHrARACHMYCw/s1600-h/image%255B7%255D"><img width="628" height="311" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-Im85_oReDI0/W7QTvFHxgdI/AAAAAAAAkHk/9nripFF7oQkrNPVsoakU1DaoPw7QJ4ypACHMYCw/image_thumb%255B3%255D?imgmax=800" border="0"></a></p><p>You can also use docker to build Business Central On Premise please check the following link for more information</p><p><a title="https://hub.docker.com/r/microsoft/bconprem/" href="https://hub.docker.com/r/microsoft/bconprem/">https://hub.docker.com/r/microsoft/bconprem/</a></p>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com3tag:blogger.com,1999:blog-3009371317403646212.post-276400851743139562018-09-19T11:48:00.001-04:002018-09-19T11:48:34.773-04:00Connection Error while launching debugger in NAV<p align="justify">Recently I was working on a project where we have switched the authentication from Windows to NAVUserPassword. </p><p align="justify">To access different databases and instances we have created different config files and have used them in our shortcut to launch them, everything was working fine but when I try to debug an issue, I was getting the following error, which complains about the DnsIdentity</p><p align="justify"><a href="https://lh3.googleusercontent.com/-_NBCEBA3jOg/W6Jvz5o-6LI/AAAAAAAAkGI/U2uA717_i28mYHFwAT8GPrMp98xVvY-nwCHMYCw/s1600-h/SNAGHTMLd9b5b4%255B4%255D"><img width="458" height="284" title="SNAGHTMLd9b5b4" style="display: inline; background-image: none;" alt="SNAGHTMLd9b5b4" src="https://lh3.googleusercontent.com/-gHd4LaELRQs/W6Jv0SMjCuI/AAAAAAAAkGM/-3Hv29ms5rwS7xlghIwS_CZ_s7X7H76pACHMYCw/SNAGHTMLd9b5b4_thumb%255B1%255D?imgmax=800" border="0"></a></p><p align="justify">The key is when you launch the debugger it uses the config file (ClientUserSettings.config.) located at C:\Users\YourUserName\AppData\Roaming\Microsoft\Microsoft Dynamics NAV\70 and depending on the version you are on it would be 80 or 90 folder. It does not use your custom config files you have created to launch the application. </p><p align="justify">So, you need to make sure this file is also updated with proper authentication using the ClientServicesCredential which should be NAVUserPassword if you are using UserName/Password. In my case everything was set properly except the <strong>DnsIdentity</strong> Property value which is blank.</p><p align="justify">Once I updated the DnsIdentity Value with proper subject name which is the CN name , the debugger started without any issues.</p><p align="justify">For more information about DnsIdentity and Certificates please check the following link</p><p align="justify"><a title="https://docs.microsoft.com/en-us/dynamics-nav/how-to--configure-authentication-of-microsoft-dynamics-nav-web-client-users" href="https://docs.microsoft.com/en-us/dynamics-nav/how-to--configure-authentication-of-microsoft-dynamics-nav-web-client-users">https://docs.microsoft.com/en-us/dynamics-nav/how-to--configure-authentication-of-microsoft-dynamics-nav-web-client-users</a></p><p align="justify"></p>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com0tag:blogger.com,1999:blog-3009371317403646212.post-79143373829040099472018-04-03T21:34:00.001-04:002018-04-03T21:35:53.968-04:00Dynamics 365 Business Central Trial and How to Reset SandBox Environment<p>If you want to try the new Dynamics 365 Business Central please login into <a href="https://trials.dynamics.com/">https://trials.dynamics.com/</a>, and you just need to provide your work email address and Phone No.</p><p>If you already have signed up previously then, on login it will redirect you to the Finance and Operations Business Edition and to reset to Business Central you need to follow the below steps</p><p>Once you login, Go to your Apps and Select the Financials App for the production instance, <img alt="Sandbox Environment Setup" src="https://docs.microsoft.com/en-us/dynamics365/financials/media/across-sandbox/sandbox-environment-setup.png"></p><p><br></p><p>Choose the <img title="Search for Page or Report icon" alt="Search for Page or Report" src="https://docs.microsoft.com/en-us/dynamics365/financials/media/ui-search/search_small.png"> icon, enter <strong>Sandbox Environment</strong>, and then choose the related link. </p><p>In the above screen you need to Reset the Sandbox Environment.</p><p>It will take a minute or two to complete the process and might show up an error screen at the end but don’t worry, you just need to logout and re-login which will reset your environment to the new Business Central Edition as shown below</p><p><a href="https://lh3.googleusercontent.com/-DPSbAG_oaTo/WsQrmIutgNI/AAAAAAAAjsc/Qo7j5hoH4Q0APDBXSDSDQMNSUhtVhxMNACHMYCw/s1600-h/image%255B3%255D"><img width="872" height="496" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-zqa-6ihzTY8/WsQrml9J6RI/AAAAAAAAjsg/5tgY9k_ZXnI1DnLqI0Emc08bXNfnBWH1ACHMYCw/image_thumb%255B1%255D?imgmax=800" border="0"></a></p><p>If you have any other tips or suggestions, please do share them in the comments below.</p>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com17tag:blogger.com,1999:blog-3009371317403646212.post-17409841153824055072018-04-02T22:19:00.001-04:002018-04-02T22:19:12.038-04:00Dynamics 365 Business Central is now live!<h5>A modern solution for modern businesses</h5><p>With<b> 160,000+ customers</b>, more than <b>2.7 million users</b>, and <b>3500 partners worldwide</b>, Dynamics NAV has <b>sold in 195 countries</b> – that’s pretty much every country in the world. Today we are proud to announce that we are furthering this success story with <b>Dynamics 365 Business Central</b> by making it generally available as a cloud service starting today.<p><a href="https://msdnshared.blob.core.windows.net/media/2018/04/3630.Desktop-Tall.png"><img width="1960" height="1894" alt="" src="https://msdnshared.blob.core.windows.net/media/2018/04/3630.Desktop-Tall.png"></a><p>Dynamics 365 Business Central brings the full power of Dynamics NAV to the cloud. As such, Business Central has at its foundation a set of trusted, proven technologies in a single, end-to-end application. As such, Business Central offers:<ul><li><b>Business without silos</b>. Unify your business, and boost efficiency with automated tasks and workflows—all integrated within familiar Office tools like Outlook, Word, and Excel.
<li><b>Actionable insights</b>. Achieve greater outcomes and gain a complete view of your business with connected data, business analytics, and guidance delivered by Microsoft’s leading intelligent technologies.
<li><b>Solutions built to evolve</b>. Start quickly, grow at your own pace and adapt in real time with a flexible platform that makes it easy to extend Business Central based on your changing business needs.</li></ul><p>For an intro to Dynamics 365 Business Central, view the announcement made by Alysa Taylor here:<p><a href="https://www.youtube.com/watch?v=3RCKRJRBFLw:640:480">Announcing Dynamics 365 Business Central</a><p>If you would like to go deeper, enjoy this video:<p><a href="https://www.youtube.com/watch?v=R7bp2MdAc5o:640:480">Dynamics 365 Business Central Deep Dive</a><p>Finally, Business Central would not be possible without the amazing team that is behind this great product. I cannot express enough how proud I am of them and what they have accomplished. To hear from some of the team members about what their favorite features are, see this:<p><a href="https://youtu.be/ReaXQ2Nwsk8:640:480">Our favourite capabilities in Dynamics 365 Business Central</a><p>Because Dynamics 365 Business Central and Dynamics NAV run the same application code base, this empowers us to smoothly transition all our Dynamics NAV partners and customers into Dynamics 365 Business Central. Dynamics 365 Business Central is a cloud first solution, designed for the age of digital transformation powered by the cloud. But it will not be a cloud only solution. In the fall it will be available for self-deployment on premise and in the intelligent edge for customers that prefer that option. For the existing partners and customers, this will be just another upgrade, like they would do for Dynamics NAV, with a name change. For customers interested in the cloud, starting today, Dynamics 365 Business Central offers unprecedented opportunities to drive transformation of the customers’ businesses, increasing their business performance through the power of Microsoft cloud technologies and services.<p><a href="https://msdnshared.blob.core.windows.net/media/2018/04/RoadMap.png"><img width="2728" height="1480" alt="" src="https://msdnshared.blob.core.windows.net/media/2018/04/RoadMap.png"></a><p>For more information on coming updates, please keep an eye on the <a href="https://roadmap.dynamics.com/#application=a56e2c12-2a92-e611-80dc-c4346bac0910">roadmap site</a>.<p>Dynamics 365 Business Central will be generally available on April 2, 2018 in 14 countries – United States, Canada, United Kingdom, Denmark, Netherlands, Germany, Spain, Italy, France, Austria, Switzerland, Belgium, Sweden, and Finland, and will be sold through our Cloud Solution Provider (CSP) partners. Australia and New Zealand will be generally available beginning July 1, 2018. Our network of global partners has the expertise to help you create and deploy a solution that meets your industry-specific needs. Do even more with Dynamics 365 Business Central using pre-built applications, available through the AppSource marketplace, to easily and cost effectively extend your solution.<p><br><p><b>You can try Dynamics 365 Business Central today by browsing to our <a href="https://dynamics.microsoft.com/en-us/business-central/overview/">homepage</a> and starting the free trial. Looking forward to hear your questions, feedback, and thoughts on our <a href="https://community.dynamics.com/business/f/758/">community forum</a>, <a href="https://experience.dynamics.com/ideas/list/?forum=e288ef32-82ed-e611-8101-5065f38b21f1">ideas site</a>. You can also follow news and discussions on Twitter, using the #MSDyn365BC hashtag.</b><p><strong><br></strong><p><strong>source: <a title="https://blogs.msdn.microsoft.com/nav/2018/04/02/dynamics-365-business-central-is-now-live/" href="https://blogs.msdn.microsoft.com/nav/2018/04/02/dynamics-365-business-central-is-now-live/">https://blogs.msdn.microsoft.com/nav/2018/04/02/dynamics-365-business-central-is-now-live/</a></strong>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com19tag:blogger.com,1999:blog-3009371317403646212.post-23328416948478916592018-01-31T23:32:00.001-05:002018-01-31T23:32:02.058-05:00New PowerShell Cmdlets in NAV 2018<p><a href="https://lh3.googleusercontent.com/-JLLIPiz3xjg/WnKYPrQvXtI/AAAAAAAAjXk/eKlc8B230l8GPLPZRUyY9_mpf2BdSuo4QCHMYCw/s1600-h/bash-148836%255B6%255D"><img width="240" height="191" title="bash-148836" style="border: 0px currentcolor; border-image: none; display: inline; background-image: none;" alt="bash-148836" src="https://lh3.googleusercontent.com/-hUvjnSpuUUk/WnKYQWtV-VI/AAAAAAAAjXo/KOXhX9R_gLYyvCu8NpKJkT__B9_5RDW6gCHMYCw/bash-148836_thumb%255B2%255D?imgmax=800" border="0"></a></p><p>Following are the new PowerShell cmdlets introduced in NAV 2018</p><p><br></p><table border="1" cellspacing="0" cellpadding="0"><tbody><tr><td width="246" valign="top"><p><strong>Cmdlet</strong></p></td><td width="456" valign="top"><p><strong>Description</strong></p></td></tr><tr><td width="246" valign="top"><p><a href="https://docs.microsoft.com/en-us/powershell/module/Microsoft.Dynamics.Nav.Management/Restart-NAVServerInstance"><u><font color="#0000ff">Restart-NAVServerInstance</font></u></a></p></td><td width="456" valign="top"><p>Restarts a Dynamics NAV Server instance.</p></td></tr><tr><td width="246" valign="top"><p><a href="https://docs.microsoft.com/en-us/powershell/module/Microsoft.Dynamics.Nav.Management/Start-NAVServerInstance"><u><font color="#0000ff">Start-NAVServerInstance</font></u></a></p></td><td width="456" valign="top"><p>Starts a Dynamics NAV Server instance.</p></td></tr><tr><td width="246" valign="top"><p><a href="https://docs.microsoft.com/en-us/powershell/module/Microsoft.Dynamics.Nav.Management/Stop-NAVServerInstance"><u><font color="#0000ff">Stop-NAVServerInstance</font></u></a></p></td><td width="456" valign="top"><p>Stops a Dynamics NAV Server instance.</p></td></tr><tr><td width="246" valign="top"><p><a href="https://docs.microsoft.com/en-us/powershell/module/Microsoft.Dynamics.Nav.Management/Set-NAVApplication"><u><font color="#0000ff">Set-NAVApplication</font></u></a></p></td><td width="456" valign="top"><p>Sets the application version or application family fields in the application database connected to the specified Dynamics NAV Server instance.</p></td></tr><tr><td width="246" valign="top"><p><a href="https://docs.microsoft.com/en-us/powershell/module/Microsoft.Dynamics.Nav.Management/Set-NAVTenant"><font color="#0000ff"><u>Set-NAVTenant</u></font></a></p></td><td width="456" valign="top"><p>Specifies settings for a tenant that is mounted on a Dynamics NAV Server instance.</p></td></tr><tr><td valign="top"><p><a href="https://docs.microsoft.com/en-us/powershell/module/Microsoft.Dynamics.Nav.Apps.Management/Start-NAVAppDataUpgrade"><u><font color="#0000ff">Start-NAVAppDataUpgrade</font></u></a></p></td><td valign="top"><p>Upgrades a NAV App to a specified tenant.</p></td></tr><tr><td valign="top"><p><a href="https://docs.microsoft.com/en-us/powershell/module/Microsoft.Dynamics.Nav.Apps.Management/Sync-NAVApp"><font color="#0000ff"><u>Sync-NAVApp</u></font></a></p></td><td valign="top"><p>Synchronizes an app to the specified tenant's database.</p></td></tr></tbody></table>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com0tag:blogger.com,1999:blog-3009371317403646212.post-7255631545786434642018-01-31T18:24:00.001-05:002018-01-31T18:24:12.419-05:00Job Queue Entry is Missing/Deleted<p><a href="https://lh3.googleusercontent.com/-iqiypH_Kgrk/WnJQFcj5EJI/AAAAAAAAjXQ/Sy1NrWmibbMS43eMchUOmotkmTuMaNuTACHMYCw/s1600-h/computer-644457%255B3%255D"><img width="482" height="416" title="computer-644457" style="display: inline; background-image: none;" alt="computer-644457" src="https://lh3.googleusercontent.com/-LmdCJkb4Qf0/WnJQF3JizOI/AAAAAAAAjXU/-YwsdG21cck6nBQJsFM0xwd3k3AU3u_agCHMYCw/computer-644457_thumb%255B1%255D?imgmax=800" border="0"></a></p><p>Last week one of the issues i have received is the Job Queue entry which was scheduled is missing or getting deleted after it is run, if you are one of those who is having this issue then below is the reason for the issue.</p><p>T he Job Queue Entry gets deleted is because of the way we setup the job queue to run, when we setup the Job Queue it has options to setup as Recurrence which we basically telling the system to run this Job on a specific day at a specific time</p><p><br></p><p><a href="https://lh3.googleusercontent.com/-kaDZLS07jQQ/WnJQGZ4g9WI/AAAAAAAAjXY/umfkMTvg6-ounNJZLY0276hvZa0M5lsxgCHMYCw/s1600-h/image3"><img width="872" height="315" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-ngKthUGmG60/WnJQG8yzU_I/AAAAAAAAjXc/zHz0ddWgO487YriudobR_4fZSf6coVr3QCHMYCw/image_thumb1?imgmax=800" border="0"></a></p><p><br></p><p>If we don’t setup this tab and then it is more like one time job you want to run and in that case once the Job is ran it will delete the entry.</p><p>If you have any other tips or suggestions, please do share them in the comments below.</p>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com3tag:blogger.com,1999:blog-3009371317403646212.post-34201328408898012782018-01-16T09:31:00.001-05:002018-01-16T09:31:00.622-05:00Cumulative Update 01 for Microsoft Dynamics NAV 2018 has been released<p>Cumulative Update 01 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2018.<p>The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see <a href="https://support.microsoft.com/en-us/contactus/">http://support.microsoft.com/contactus/</a>.<p>The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:<ul><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20AT.zip">AT – Austria</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20AU.zip">AU – Australia</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20BE.zip">BE – Belgium</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20CH.zip">CH – Switzerland</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20CZ.zip">CZ – Czech Republic</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20DE.zip">DE – Germany</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20DK.zip">DK – Denmark</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20ES.zip">ES – Spain</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20FI.zip">FI – Finland</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20FR.zip">FR – France</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20IS.zip">IS – Iceland</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20IT.zip">IT – Italy</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20NA.zip">NA – North America</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20NL.zip">NL – Netherlands</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20NO.zip">NO – Norway</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20NZ.zip">NZ – New Zealand</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20RU.zip">RU – Russia</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20SE.zip">SE – Sweden</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20GB.zip">UK – United Kingdom</a><li><a href="http://download.microsoft.com/download/3/5/3/353B5669-042D-4EE2-B76A-13D9A1A0621D/CU%2001%20NAV%202018%20W1.zip">W1 – International</a></li></ul><p><strong>Where to find Cumulative Update 01</strong><p>You can download the cumulative update from <a href="http://support.microsoft.com/help/4058601">KB4058601</a> – Cumulative Update 01 for Microsoft Dynamics NAV 2018.<p>You can press one of the countries in list above for a direct download or you can download the cumulative update from the <a href="https://www.microsoft.com/en-us/download/details.aspx?id=56419">Microsoft Download Center</a>.<p>Microsoft Dynamics NAV 2018 is also available from containers. Containers are a way to wrap up an application into its own isolated box, you can pull the cumulative update container from the <a href="https://hub.docker.com/r/microsoft/dynamics-nav/">Docker Hub</a>.<p>To learn more about other Cumulative Updates already released for Microsoft Dynamics NAV 2018 please see <a href="https://support.microsoft.com/en-us/help/4072483">KB 4072483</a>.<p><strong>Warning</strong><p>Before you install a cumulative update in a production environment, take the following precautions:<ol><li>Test the cumulative update in a non-production environment.
<li>Make a backup of the system or computer where the cumulative update is to be installed.
<li>This Cumulative Update can require a database upgrade.</li></ol><p><strong>Additional Information</strong><p>For information about how to install the cumulative update, see <a href="https://support.microsoft.com/en-us/help/4072484">How to Install a Microsoft Dynamics NAV 2018 Cumulative Update</a>.<p>Source: <a title="https://blogs.msdn.microsoft.com/nav/2018/01/08/cumulative-update-01-for-microsoft-dynamics-nav-2018-has-been-released/" href="https://blogs.msdn.microsoft.com/nav/2018/01/08/cumulative-update-01-for-microsoft-dynamics-nav-2018-has-been-released/">https://blogs.msdn.microsoft.com/nav/2018/01/08/cumulative-update-01-for-microsoft-dynamics-nav-2018-has-been-released/</a>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com2tag:blogger.com,1999:blog-3009371317403646212.post-1851839766971086472018-01-14T20:02:00.001-05:002018-01-14T20:53:53.211-05:00Print the document to a specific printer<p><a href="https://lh3.googleusercontent.com/-ll1iD0_WbzI/Wlv-HSXKbJI/AAAAAAAAjVE/cT2pE9MDK2greoIRSS16Q1xsS1kDq82LQCHMYCw/s1600-h/printer-2178754_1920%255B5%255D"><img width="426" height="303" title="printer-2178754_1920" style="display: inline; background-image: none;" alt="printer-2178754_1920" src="https://lh3.googleusercontent.com/-TVeCkoykYyQ/Wlv-HyHmvwI/AAAAAAAAjVI/vMQP15K7uPYN4loRD5QAIw1bUq6c2qHQACHMYCw/printer-2178754_1920_thumb%255B3%255D?imgmax=800" border="0"></a><p>In one of my previous posts, I have discussed how to download and print a remote file. Here is the blog link<p><u><a href="http://www.navisionworld.com/2017/09/how-to-print-remote-file-from-nav.html"><u><font color="#0000ff">http://www.navisionworld.com/2017/09/how-to-print-remote-file-from-nav.html</font></u></a></u><p>The solution in the above post will print the file to the default printer and recently I was working on a modification where I have to print the file to a specific printer instead of the default printer and couple of readers of my blog post also asked how to do this, so I would like to share today the solution for it.<p>I was checking online to modify my old solution to print to a specific printer and few suggested to me to use the arguments property of the ProcessStartInfo and also the below MSDN example suggests the same, but unfortunately, I was not successful using that property. <p><a href="https://msdn.microsoft.com/en-us/library/system.diagnostics.processstartinfo.verbs(v=vs.110).aspx"><font color="#0000ff"><u>https://msdn.microsoft.com/en-us/library/system.diagnostics.processstartinfo.verbs(v=vs.110).aspx</u></font></a><p><a href="https://lh3.googleusercontent.com/-PgV_MiOcGuU/Wlv9h1pSVoI/AAAAAAAAjU4/U4B-vJOgauowILdUcceIglGSaP2_tiqKwCHMYCw/s1600-h/image%255B3%255D"><img width="872" height="243" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-mfRKtbgcTSk/Wlv9iR_7OTI/AAAAAAAAjU8/hpNtQbqhzIIf4O879NZILl9HKNiaaoC4QCHMYCw/image_thumb%255B1%255D?imgmax=800" border="0"></a><p>To solve this issue I have found another solution which is to use the Print Document and in fact, I think this is an easy solution when compared to the other solution in my previous post.<p>Below is the function for it.<p><!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #008800; font-weight: bold">PROCEDURE</span> PrintFile<span style="color: #333333">@</span><span style="color: #0000DD; font-weight: bold">1000000018</span>(FilePath<span style="color: #333333">@</span><span style="color: #0000DD; font-weight: bold">1000000002</span> : <span style="color: #007020">Text</span>[<span style="color: #0000DD; font-weight: bold">250</span>]);
VAR
PrinterName<span style="color: #333333">@</span><span style="color: #0000DD; font-weight: bold">1240060002</span> : <span style="color: #007020">Text</span>;
PrintDocument<span style="color: #333333">@</span><span style="color: #0000DD; font-weight: bold">1240060003</span> : DotNet <span style="color: #AA6600">"'System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'.System.Drawing.Printing.PrintDocument"</span>;
PrinterSettings<span style="color: #333333">@</span><span style="color: #0000DD; font-weight: bold">1240060004</span> : DotNet <span style="color: #AA6600">"'System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'.System.Drawing.Printing.PrinterSettings"</span>;
<span style="color: #008800; font-weight: bold">BEGIN</span>
PrinterName :<span style="color: #333333">=</span> <span style="background-color: #fff0f0">'MF8200C Series'</span>;
PrintDocument :<span style="color: #333333">=</span> PrintDocument.PrintDocument;
PrintDocument.DocumentName :<span style="color: #333333">=</span> FilePath;
PrinterSettings :<span style="color: #333333">=</span> PrinterSettings.PrinterSettings;
PrinterSettings.PrinterName :<span style="color: #333333">=</span> PrinterName;
PrintDocument.PrinterSettings :<span style="color: #333333">=</span> PrinterSettings;
PrintDocument.Print;
MESSAGE(<span style="background-color: #fff0f0">'Complete'</span>);
<span style="color: #008800; font-weight: bold">END</span>;
</pre></div>
<strong><br></strong></p>If you have any other tips or suggestions, please do share them in the comments below.Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com24tag:blogger.com,1999:blog-3009371317403646212.post-50225427247787800312018-01-05T12:27:00.001-05:002018-01-05T12:27:09.647-05:00January 2018 Cumulative Updates for NAV 2013, 2013 R2, 2015, 2016 and 2017<p>Here are links to the release notes and download link for the CU's released.</p><p><strong><u>NAV 2013 – Cumulative Update 58</u></strong></p><p>You can download the cumulative update from<font color="#0000ff"> <a href="https://support.microsoft.com/help/4058596"><u><font color="#0000ff">KB4058596</font></u></a></font></p><p><strong><u>NAV 2013 R2 – Cumulative Update 51</u></strong></p><p>You can download the cumulative update from <a href="https://support.microsoft.com/help/4058597"><font color="#0000ff">KB4058597</font></a></p><p><strong><u>NAV 2015 – Cumulative Update 39</u></strong></p><p>You can download the cumulative update from<font color="#0000ff"> <a href="https://support.microsoft.com/help/4058598"><font color="#0000ff">KB4058598</font></a></font></p><p><strong><u>NAV 2016 – Cumulative Update 27</u></strong></p><p>You can download the cumulative update from <a href="https://support.microsoft.com/help/4055891"><font color="#0000ff"><a href="https://support.microsoft.com/help/4058599"><u>KB4058599</u></a></font></a></p><p><strong><u>NAV 2017 – Cumulative Update 14</u></strong></p><p>You can download the cumulative update from <a href="http://support.microsoft.com/help/4058600"><u><font color="#0000ff">KB4058600</font></u></a><font color="#0000ff"></font></p>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com0tag:blogger.com,1999:blog-3009371317403646212.post-12720223100926357762018-01-04T15:46:00.001-05:002018-01-04T15:46:54.475-05:00Could not Load file or Assembly error after applying Cumulative Update<p><a href="https://lh3.googleusercontent.com/-4z57cTEBQcg/Wk6SreuU7dI/AAAAAAAAigI/LWHZSlSnrm0fKWxCHU7mX6pWT4R3wNKrgCHMYCw/s1600-h/road-sign-1274312_1920%255B3%255D"><img width="585" height="413" title="road-sign-1274312_1920" style="display: inline; background-image: none;" alt="road-sign-1274312_1920" src="https://lh3.googleusercontent.com/-hj79XYPTug4/Wk6SrzdDr2I/AAAAAAAAigM/_dB5xNyAS5QQqwnFMnj1A4piKvClg_GAQCHMYCw/road-sign-1274312_1920_thumb%255B1%255D?imgmax=800" border="0"></a></p><p>Last week I have applied the Cumulative Update 50 for NAV 2013 R2 on my local machine. After I have applied the Cumulative Update I have tried to open NAV Administration Tool to restart the NAV Services but I have encountered the below error </p><p><a href="https://lh3.googleusercontent.com/-T1QAu0U80-Y/Wk6SsSAfxvI/AAAAAAAAigQ/AkfOEzF70voFge-7WsV2gyrnN487wcuFgCHMYCw/s1600-h/image%255B14%255D"><img width="780" height="298" title="image" style="margin: 0px; display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-JcHiN3Z9w0Y/Wk6Ss1plDWI/AAAAAAAAigU/odC-q1YTd-AzdhdhhM37n7eAl-ja69XYgCHMYCw/image_thumb%255B5%255D?imgmax=800" border="0"></a></p><p>The tool was not able to open the management dll , so I have browse to the service folder and reviewed the properties of Microsoft.Dynamics.Nav.Management.dll and found that it was blocked. </p><p>To unblock the dll I have clicked the Unblock check mark as shown in the below fig. and then tried to open the NAV Administration tool which then opened without any issues</p><p>If you get could not load file or assembly, be sure to check the properties of the file.</p><p><a href="https://lh3.googleusercontent.com/-bulPVzp0ad0/Wk6StvknMII/AAAAAAAAigY/DVD54cPdIPQLrdDl5YNoOOcdDFNLNp0NgCHMYCw/s1600-h/image%255B9%255D"><br></a></p><p><a href="https://lh3.googleusercontent.com/-RIE-eav4wQo/Wk6SuLqVh1I/AAAAAAAAigc/kSyBuxIgixAMMuRDUIoqulk0b6mB4g30wCHMYCw/s1600-h/image%255B10%255D"><img width="623" height="750" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-fxl193scJEI/Wk6SvV1SofI/AAAAAAAAigg/EamEtbheSG0038H3OKKJwKAqSDz3qLXXACHMYCw/image_thumb%255B4%255D?imgmax=800" border="0"></a></p><p>If you have any other tips or suggestions, please do share them in the comments below.</p>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com4tag:blogger.com,1999:blog-3009371317403646212.post-318190532502092972017-12-13T15:11:00.001-05:002017-12-13T15:12:11.402-05:00Batch Name disappears after you customize the Journal Page<p><a href="https://lh3.googleusercontent.com/-ypjhM8si0ak/WjGJfStrq_I/AAAAAAAAicI/px_vgsa4DFseCxS2p7j22J58HKdGk1SJACHMYCw/s1600-h/clip_image001%255B4%255D"><img width="433" height="292" title="clip_image001" style="display: inline; background-image: none;" alt="clip_image001" src="https://lh3.googleusercontent.com/-Th93qC1SRmM/WjGJfwYfVRI/AAAAAAAAicM/8XL5TaUvh7IeS3TJg7x5csMQH2glOsvoQCHMYCw/clip_image001_thumb%255B1%255D?imgmax=800" border="0"></a></p><p>Batch name drop-down disappearing on the journal pages in NAV 2013 and NAV 2013 R2 is an old issue but this issue resurfaced again this week couple of times for a client, so I have decided to write a blog on it.<p>This is a known bug in NAV 2013 & NAV 2013 R2 and can be fixed easily by applying the latest platform hotfix but if you are not planning to apply the hotfix then below solution will fix the issue for you<p>In this example, let’s look at the whse. physical inventory journal page<p>After I have customized the page, the page will look like in the below fig, and there is no way to add the batch name back to the page and this issue is user specific. <p><a href="https://lh3.googleusercontent.com/-2TiQC3WyOi4/WjGJgW1iWmI/AAAAAAAAicQ/MZgv2PCsIt8n-3MQr8AZjOCz6_SH5qTvgCHMYCw/s1600-h/clip_image002%255B4%255D"><img width="535" height="239" title="clip_image002" style="display: inline; background-image: none;" alt="clip_image002" src="https://lh3.googleusercontent.com/-RYTwt_xzzjg/WjGJg3lT7II/AAAAAAAAicU/76HtUYvi9qo40pztpTXRkku_Fj-W6_SGwCHMYCw/clip_image002_thumb%255B1%255D?imgmax=800" border="0"></a><p>In order to resolve this issue, you need to open the development environment and find the table 2000000075 (User Metadata) and 2000000080 (Page Data Personalization), and run those tables and filter for the page no. . In this case I have filtered the Page ID column (Whse. Phys. Inventory Journal Page is) to 7326 and the User ID column to my user ID.<p>Once you find that record, please delete that record from the table and perform the same steps in Page Data Personalization table and use the Object ID column instead of Page ID.<p><a href="https://lh3.googleusercontent.com/-EVkPLEHcGqc/WjGJhP7diII/AAAAAAAAicY/AtMDfbEsB7AvajeL7ZiUjcRxk2WzJQwDACHMYCw/s1600-h/clip_image003%255B4%255D"><img width="872" height="94" title="clip_image003" style="display: inline; background-image: none;" alt="clip_image003" src="https://lh3.googleusercontent.com/-yp9rWdk4EN8/WjGJhtLa2GI/AAAAAAAAicc/xoFp37MoXoUr_hwFk6HlxDdlkW75gLdcgCHMYCw/clip_image003_thumb%255B1%255D?imgmax=800" border="0"></a><p>Compile the page and the batch name should appear on the journal page. <p>If you have any other tips or suggestions, please do share them in the comments below.Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com0tag:blogger.com,1999:blog-3009371317403646212.post-32003348440336184002017-12-12T13:24:00.001-05:002017-12-12T13:24:07.495-05:00New COMPANYPROPERTY function in NAV 2018<p><a href="https://lh3.googleusercontent.com/-3T__emH5ico/WjAeuFyKdDI/AAAAAAAAiZw/8bqzrp73j7Ayodpk_xMGxa9jCcHYJ2_pwCHMYCw/s1600-h/notebook-2173630_1920%255B3%255D"><img width="412" height="412" title="notebook-2173630_1920" style="display: inline; background-image: none;" alt="notebook-2173630_1920" src="https://lh3.googleusercontent.com/-h9UkeGJB_Zg/WjAeuhy11II/AAAAAAAAiZ0/59VCoJzGQiU19DsVKfbp4NcpHAZ2A7qQQCHMYCw/notebook-2173630_1920_thumb%255B1%255D?imgmax=800" border="0"></a><p>One of the new functions which were introduced in NAV2018 is COMPANYPROPERTY which has two properties<p><b>DISPLAYNAME</b>: Which will return the display name from the company record<p><b>URLNAME</b>: Which will return the name in the URL Format.<p>You can setup the Display Name on the company page as shown in the below figure:<p><a href="https://lh3.googleusercontent.com/-1Mgib1KAkT8/WjAeu2spaDI/AAAAAAAAiZ4/PDjJm20BhMIXlzfAGV5rc2PGDAsg53MLgCHMYCw/s1600-h/clip_image002%255B4%255D"><img width="488" height="208" title="clip_image002" style="display: inline; background-image: none;" alt="clip_image002" src="https://lh3.googleusercontent.com/--wpmM_YkaC4/WjAevYSLZvI/AAAAAAAAiZ8/hQXU7KnOL-8CqYOVx2KufqpyfXJ0SP49ACHMYCw/clip_image002_thumb%255B1%255D?imgmax=800" border="0"></a><p>As per Microsoft documentation, the change of display name now has immediate effect on reports as well as displaying the company name in the UI of the client <p>I have tried to the change the Display Name for testing but the change is not reflected on the RTC client, it did reflect in reports and in the web client. It would be nice if the same change is reflected in the RTC client when the System Indicator Company is used.<p><a href="https://lh3.googleusercontent.com/-k1y40-TvdQg/WjAevr3woaI/AAAAAAAAiaA/cm9Ginow2ocerXrZ4IV3fTGYm1U64qsYQCHMYCw/s1600-h/clip_image004%255B4%255D"><img width="604" height="262" title="clip_image004" style="display: inline; background-image: none;" alt="clip_image004" src="https://lh3.googleusercontent.com/-QeGSjSa2vKw/WjAewdJRyxI/AAAAAAAAiaE/l4F9E_kF5do3HS-vI9O8XO8Uz-_241ZBACHMYCw/clip_image004_thumb%255B1%255D?imgmax=800" border="0"></a><p><a href="https://lh3.googleusercontent.com/-dAIhKuuPAQs/WjAewmBxr_I/AAAAAAAAiaI/84jwJU2o2fIqt49iMIXNnKayuVRSbyPXgCHMYCw/s1600-h/clip_image006%255B4%255D"><img width="508" height="384" title="clip_image006" style="display: inline; background-image: none;" alt="clip_image006" src="https://lh3.googleusercontent.com/-RJSatmrHFvg/WjAew-B6PFI/AAAAAAAAiaM/b54VvKXN75c2IxF3C4XG9Ade5xLowH4vwCHMYCw/clip_image006_thumb%255B1%255D?imgmax=800" border="0"></a><p>The URLNAME function returns the following output <p><a href="https://lh3.googleusercontent.com/-9AhmVxWTGB0/WjAexRM0xCI/AAAAAAAAiaQ/YYFMKRAtMu41TS-McC6eDlgne_E8sv-sACHMYCw/s1600-h/clip_image008%255B3%255D"><img width="244" height="106" title="clip_image008" style="display: inline; background-image: none;" alt="clip_image008" src="https://lh3.googleusercontent.com/-1MQNW_6w0pg/WjAexpAZkvI/AAAAAAAAiaU/TUd4iba3l8QRSIfr9_YmQPcTs5OB1SfDgCHMYCw/clip_image008_thumb?imgmax=800" border="0"></a><p><b>One issue I have noticed is if we go to the company information card and make any change to the system indicator the display name is reverted to the original company name.</b><p>If you have any other tips or suggestions, please do share them in the comments below.Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com2tag:blogger.com,1999:blog-3009371317403646212.post-35442359915977463362017-12-10T19:24:00.001-05:002017-12-10T19:24:12.668-05:00Using Placeholders in NAV Reports<p><a href="https://lh3.googleusercontent.com/-nWvwYQyBBak/Wi3QHFlxRpI/AAAAAAAAiWs/ZNl8Z2uuyYcdvDvTMbUuo3OKlQqbsbbHwCHMYCw/s1600-h/financial-2860753_1920%255B3%255D"><img width="373" height="248" title="financial-2860753_1920" style="display: inline; background-image: none;" alt="financial-2860753_1920" src="https://lh3.googleusercontent.com/-3CnwZUkdCuY/Wi3QHg_o6sI/AAAAAAAAiWw/sfr-I5M_k1Q0WC_VZGaYbqPLmzOPPC8KACHMYCw/financial-2860753_1920_thumb%255B1%255D?imgmax=800" border="0"></a><p>Placeholders provide a method to customize the formatting and insert as an expression inside the textbox.<p>To add a placeholder, click inside the textbox, then right-click and select Create Placeholder as shown in the figure.<p><a href="https://lh3.googleusercontent.com/-cH46JtQTSrY/Wi3QHyZBEQI/AAAAAAAAiW0/wh1nYcmewlE-VrPShM4CV_NyZo9Uvg0tQCHMYCw/s1600-h/image%255B3%255D"><img width="327" height="139" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-LPGLhSB4rzc/Wi3QIFmldXI/AAAAAAAAiW4/KhWobSbDc1s4WoEmIBSVIydYoWnfoWhJgCHMYCw/image_thumb%255B1%255D?imgmax=800" border="0"></a><p><a href="https://lh3.googleusercontent.com/-27BFrtzTzU4/Wi3QIdhYLFI/AAAAAAAAiW8/7v9TvSir2egUW7rcXIYtSEtGsoGPwl8zwCHMYCw/s1600-h/image%255B25%255D"><img width="553" height="522" title="image" style="margin: 0px; display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-04es8BEOanQ/Wi3QIs8pdPI/AAAAAAAAiXA/rQrISgVp7jQnRydmDeD9jaHkzZFt-_7gQCHMYCw/image_thumb%255B12%255D?imgmax=800" border="0"></a><p><p>Modifying or removing a field in a standard report like Sales Order (10075) is a pain because all the textboxes show their expressions as <<Expr>>, as shown below. Trying to identify which textbox contains the field that you want to modify or remove could be tiring.<p><a href="https://lh3.googleusercontent.com/-GRfzq1m8JzQ/Wi3QJJ1P1DI/AAAAAAAAiXE/zkHr5v6ngpklLbN9UQv7uM3g9ceELgIZwCHMYCw/s1600-h/image%255B8%255D"><img width="570" height="397" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-F6J0S6oSphQ/Wi3QJol_gaI/AAAAAAAAiXI/O7E3VPc8xuQOrk7jyTwzYkGu54duY6kRwCHMYCw/image_thumb%255B4%255D?imgmax=800" border="0"></a><p><br><p><p>If we have used Placeholders inside the textbox then it will be much easier to identify them as Placeholders not only allows you to add expressions but also gives you the option to add Labels to it. The labels will appear on the report layout as shown below.<p><a href="https://lh3.googleusercontent.com/-tUM9dIEkjaM/Wi3QKPyg4tI/AAAAAAAAiXM/J2or3lnZ30AjE9QRpBIQ-RIUFkkyoCklACHMYCw/s1600-h/image%255B12%255D"><img width="404" height="112" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-4UnucYJPFXg/Wi3QKWhpzII/AAAAAAAAiXQ/xa-12fcIG-ci1iXYHQtFq0je-Sy_YJwMQCHMYCw/image_thumb%255B6%255D?imgmax=800" border="0"></a><p><p>Microsoft does a good job in naming the textboxes so it is easy to identify them using the name, for example if I look at the same report in Document Outline you can see how they named<p>The advantage with placeholder labels is you can view that in design mode.<p><a href="https://lh3.googleusercontent.com/-G7AM23D_PXI/Wi3QKiR8GeI/AAAAAAAAiXU/kMy0RGW_BBkwZ5M3Uo68NwbHKHC61vNkACHMYCw/s1600-h/image%255B17%255D"><img width="280" height="629" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-THNbLp5vEEc/Wi3QLO2tEXI/AAAAAAAAiXY/UN9dBxICjS0HZAmJ2MKY7ZkDzS6Jd7d7QCHMYCw/image_thumb%255B9%255D?imgmax=800" border="0"></a><p>Placeholders also have the ability to format the text differently. You can add more than one Placeholder in a textbox. Similar to Textboxes, Placeholders also have many tabs as shown in the figure below, which will allow you to format and customize text accordingly.<p>You can add more than one placeholder in a single text box and format each placeholder differently. <p><br><p><p>One other advantage of Placeholder is, it has the option to Interpret HTML tags. You can add configure your expression to render using HTML formatting. This allows us to add HTML tags directly into the expression, such as line break, font, bolding, underline…. <p>For example, we can use the following expression in the Value field, and select the HTML option for Markup type in the above figure.<p><strong><u><font face="Arial"><b>T </b></font> ' + “Phone No." + '<br>'</u></strong><p>If you have any other tips or suggestions, please do share them in the comments below.Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com4tag:blogger.com,1999:blog-3009371317403646212.post-89785745370501209912017-12-05T20:01:00.001-05:002017-12-05T20:01:30.652-05:00December 2017 Cumulative Updates for NAV 2013, 2013 R2, 2015, 2016 and 2017<p>Here are links to the release notes and download link for the CU's released.</p><p><strong><u>NAV 2013 – Cumulative Update 57</u></strong></p><p>You can download the cumulative update from<font color="#0000ff"> </font><a href="https://support.microsoft.com/help/4055888"><font color="#0000ff">KB 4055888</font></a></p><p><strong><u>NAV 2013 R2 – Cumulative Update 50</u></strong></p><p>You can download the cumulative update from <a href="https://support.microsoft.com/help/4055889"><font color="#0000ff">KB 4055889</font></a></p><p><strong><u>NAV 2015 – Cumulative Update 38</u></strong></p><p>You can download the cumulative update from<font color="#0000ff"> </font><a href="https://support.microsoft.com/help/4055890"><font color="#0000ff">KB 4055890</font></a></p><p><strong><u>NAV 2016 – Cumulative Update 26</u></strong></p><p>You can download the cumulative update from <a href="https://support.microsoft.com/help/4055891"><font color="#0000ff">KB4055891</font></a></p><p><strong><u>NAV 2017 – Cumulative Update 11</u></strong></p><p>You can download the cumulative update from <a href="http://support.microsoft.com/help/4055892"><font color="#0000ff">KB4055892</font></a></p>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com4tag:blogger.com,1999:blog-3009371317403646212.post-33649534956572040172017-12-05T10:41:00.001-05:002017-12-05T10:41:32.438-05:00Connection refused error on NAV when connecting to web services<p><a href="https://lh3.googleusercontent.com/-GBFcE40Lffc/Wia-Jrh63OI/AAAAAAAAhL0/STqsMSA1DCMG5DTS5fXSBVMWGE-buiZRACHMYCw/s1600-h/stamp-1726352_1920%255B3%255D"><img width="374" height="374" title="stamp-1726352_1920" style="display: inline; background-image: none;" alt="stamp-1726352_1920" src="https://lh3.googleusercontent.com/-FbGez9vq1B8/Wia-KK1Aa3I/AAAAAAAAhL4/kMeUm9PDO2U4hyw9UutIJKnNuTg_qKw2gCHMYCw/stamp-1726352_1920_thumb%255B1%255D?imgmax=800" border="0"></a></p><p>When you try to access Navision Web services you may encounter the following error<p><b>“</b><b>This Site can’t be reached, xxxx refused to connect”</b><p>The most common reason for this error is the NAV Service is not enabled for SOAP/OData.<p>To enable these services, open the Microsoft Dynamics NAV Server Administration tool and select the SOAP Services Tab/ OData Services Tab and make sure the property is set to true<p>Enable SOAP Services and Enable OData Services to true, if you are using SOAP you just need to enable SOAP and vice versa.<p><a href="https://lh3.googleusercontent.com/-4tvmD8YMS5E/Wia-KnhpOBI/AAAAAAAAhL8/YcyNDQ77RxQcar9kz-wgRzZo4hJivwLUACHMYCw/s1600-h/clip_image001%255B4%255D"><img width="416" height="177" title="clip_image001" style="display: inline; background-image: none;" alt="clip_image001" src="https://lh3.googleusercontent.com/-XnITp_SpNsc/Wia-K2H3j2I/AAAAAAAAhMA/nR6efTCQaDw4cOLOohqbj-EcCh6YQcJfQCHMYCw/clip_image001_thumb%255B1%255D?imgmax=800" border="0"></a><p>You can also use the Powershell Cmdlet<p>Set-NAVServerConfiugration to enable the services for example to enable OData you use the following cmdlet<p>Set-NAVServerConfiguration -ServerInstance <ServerInstance> -keyname ODataServicesEnabled -keyvalue true<p>Replace <ServerInstance> with the name of the Microsoft Dynamics NAV Server instance on which to set up OData services. <p>Check the following link for more examples<p><a href="https://msdn.microsoft.com/en-us/library/dn135246(v=nav.70).aspx">https://msdn.microsoft.com/en-us/library/dn135246(v=nav.70).aspx</a><p>One other reason for this error is because the port is blocked and you need to create an inbound rule to allow it. <p>Please check this below the article you need to do the same for the web services port<p><a href="https://docs.microsoft.com/en-us/dynamics-nav/how-to--create-an-inbound-rule-in-windows-firewall-for-the-port-of-microsoft-dynamics-nav-web-client">https://docs.microsoft.com/en-us/dynamics-nav/how-to--create-an-inbound-rule-in-windows-firewall-for-the-port-of-microsoft-dynamics-nav-web-client</a><p>If you have any other tips or suggestions, please do share them in the comments below.Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com3tag:blogger.com,1999:blog-3009371317403646212.post-60408611868987999282017-12-05T10:15:00.001-05:002017-12-05T10:15:43.316-05:00New System and Hidden Tables in NAV 2018<p><a href="https://lh3.googleusercontent.com/-pdFYEnMgNHc/Wia4DobRiVI/AAAAAAAAhLI/dADsPbKtolcM6pEWUWDY01YiH0ta6W9mgCHMYCw/s1600-h/window-1231894_1920%255B3%255D"><img width="383" height="263" title="window-1231894_1920" style="display: inline; background-image: none;" alt="window-1231894_1920" src="https://lh3.googleusercontent.com/-Zep08xdtpUo/Wia4ERQ78NI/AAAAAAAAhLM/0_g_3y9b544BxFIDvicYToZ8tvqNesXKACHMYCw/window-1231894_1920_thumb%255B1%255D?imgmax=800" border="0"></a></p><p>The following new system tables are added in NAV 2018</p><p><a href="https://lh3.googleusercontent.com/-afdGRtv-FaI/Wia4FJ7t49I/AAAAAAAAhLQ/Tb4RmTME518qEWqaZM4QiyO6pWPAISNyACHMYCw/s1600-h/image%255B3%255D"><img width="507" height="337" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-RUhM8FoT2gs/Wia4F3G04oI/AAAAAAAAhLU/i4d5lGYHiYUr29IQA5-guxw0oAZddkGZQCHMYCw/image_thumb%255B1%255D?imgmax=800" border="0"></a><table border="0" cellspacing="0" cellpadding="2">
<tbody>
<tr>
<td valign="top"></td>
<td valign="top"></td>
</tr>
<tr>
<td valign="top"></td>
<td valign="top"><p>Two new hidden tables are added in NAV 2018</p><p><a href="https://lh3.googleusercontent.com/-ClipCJJ2TLk/Wia4GPaeDQI/AAAAAAAAhLY/jZkgngtfResRsacCN3FWNIrcED5sfGeHQCHMYCw/s1600-h/image%255B11%255D"><img width="521" height="105" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-QVM1-MpeQvo/Wia4GhYJdbI/AAAAAAAAhLc/QrZbbUw3W10Zq0dmemtdJqIN8f4b3c2lgCHMYCw/image_thumb%255B5%255D?imgmax=800" border="0"></a></p><p>The new hidden table and new feature in NAV 2018 is API’s and when i run this table it listed the following API, in my next post I will see how can we can enable API on NAV 2018 and access one of those using the endpoint</p><p><br></p><p><br></p><p><a href="https://lh3.googleusercontent.com/-jLamGgx3vrA/Wia4G7t1tdI/AAAAAAAAhLg/JgIdamPODVIBLOcAODodD9U1Wun7h7rWwCHMYCw/s1600-h/image%255B15%255D"><img width="350" height="605" title="image" style="display: inline; background-image: none;" alt="image" src="https://lh3.googleusercontent.com/-L3t_NcNFkcw/Wia4HuN893I/AAAAAAAAhLk/E3Xudh66dxUCzXCKEJI1K7HH98he_0SvQCHMYCw/image_thumb%255B7%255D?imgmax=800" border="0"></a></p><p><code>If you have </code><code>any</code> <code>other tips </code><code>or</code> <code>suggestions , please do share them </code><code>in</code> <code>the comments below.</code></p></td>
</tr>
</tbody>
</table>Suresh Kullahttp://www.blogger.com/profile/12152474600671845052noreply@blogger.com5