Tuesday, August 20, 2019

Weird Internal Server Error on Publishing Extension

I am working on a AL project which is on NAV 2018, and I have run into the below error several times now 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 Internal Error occured….. 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 1.  If you have a web client/Win client open or even powershell...
Share:

Friday, August 9, 2019

How to handle changes in NAV/BC when event does not exist ?

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 on premise 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. In those scenarios, should we modify the base objects like the old way ? Sometimes events even get trickier. Such as I want to exit from a calling function without executing the next...
Share:

Thursday, August 8, 2019

Cannot import the data because the table with the ID ….

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 Export to Data File option which creates a .navdata file and if the both databases have the same schema you can import that file into another database. You can read more about How to Export/Import Data from the below link https://docs.microsoft.com/en-us/dynamics-nav/exporting-and-importing-companies-and-other-data In my case, both databases have the same schema, but when I try to use the Import...
Share:

Released Cumulative Updates for NAV and D365BC

List of released cumulative updates for supported DynNAV and D365BC versionsReleased Cumulative Updates for Microsoft Dynamics NAV 2015 support.microsoft.com/.../released-cumulative-updates-for-microsoft-dynamics-nav-2015Released Cumulative Updates for Microsoft Dynamics NAV 2016 support.microsoft.com/.../released-cumulative-updates-for-microsoft-dynamics-nav-2016Released Cumulative Updates for Microsoft Dynamics NAV 2017 support.microsoft.com/.../released-cumulative-updates-for-microsoft-dynamics-nav-2017Released Cumulative Updates for Microsoft Dynamics NAV 2018 support.microsoft.com/.../released-cumulative-updates-for-microsoft-dynamics-nav-2018Released...
Share:

Friday, March 22, 2019

You have not been granted permission to perform the current activity

Today, when I try to launch the debugger, I got the below error 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. 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...
Share:

Friday, January 4, 2019

Print Send To Excel do not export all columns

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.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.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...
Share:

Thursday, October 4, 2018

Business Central Web Client Search Improvements

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.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...
Share:

Wednesday, October 3, 2018

Business Central OnPremise DEV License Error (Update)

Update: This issue is resolved now. You need to regenerate your license and it should work.I have installed Business Central On Premise and uploaded over DEV license. Unfortunately the license did not work and I keep getting the below errorI 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. But the question is how do I access the client now, so I tried to upload...
Share:

Tuesday, October 2, 2018

Good Bye to C/AL and RTC Client

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.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...
Share:

Dynamics 365 Business Central On Premise

On October 1st, during DirectionsNA it is officially announced that Dynamics 365 Business Central On Premise will be available to download.You can download the software if you have Partner Source Access ,from here DownloadOne of the big difference/change in this version is the Web Client and its features. You can also use docker to build Business Central On Premise  please check the following link for more informationhttps://hub.docker.com/r/microsoft/bconpre...
Share:

Wednesday, September 19, 2018

Connection Error while launching debugger in NAV

Recently I was working on a project where we have switched the authentication from Windows to NAVUserPassword. 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 DnsIdentityThe key is when  you launch the debugger it uses the config file (ClientUserSettings.config.) located at C:\Users\YourUserName\AppData\Roaming\Microsoft\Microsoft Dynamics...
Share:

Tuesday, April 3, 2018

Dynamics 365 Business Central Trial and How to Reset SandBox Environment

If you want to try the new Dynamics 365 Business Central please login into https://trials.dynamics.com/, and you just need to provide your work email address and Phone No.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 stepsOnce you login, Go to your Apps and Select the Financials App for the production instance, Choose the icon, enter Sandbox Environment, and then choose the related link. In the above screen...
Share:

Monday, April 2, 2018

Dynamics 365 Business Central is now live!

A modern solution for modern businessesWith 160,000+ customers, more than 2.7 million users, and 3500 partners worldwide, Dynamics NAV has sold in 195 countries – that’s pretty much every country in the world. Today we are proud to announce that we are furthering this success story with Dynamics 365 Business Central by making it generally available as a cloud service starting today.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...
Share:

Wednesday, January 31, 2018

New PowerShell Cmdlets in NAV 2018

Following are the new PowerShell cmdlets introduced in NAV 2018CmdletDescriptionRestart-NAVServerInstanceRestarts a Dynamics NAV Server instance.Start-NAVServerInstanceStarts a Dynamics NAV Server instance.Stop-NAVServerInstanceStops a Dynamics NAV Server instance.Set-NAVApplicationSets the application version or application family fields in the application database connected to the specified Dynamics NAV Server instance.Set-NAVTenantSpecifies settings for a tenant that is mounted on a Dynamics NAV Server instance.Start-NAVAppDataUpgradeUpgrades...
Share:

Job Queue Entry is Missing/Deleted

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.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 timeIf we don’t setup this tab and then it is more like one time job you want to run and...
Share:

Tuesday, January 16, 2018

Cumulative Update 01 for Microsoft Dynamics NAV 2018 has been released

Cumulative Update 01 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2018.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...
Share:

Sunday, January 14, 2018

Print the document to a specific printer

In one of my previous posts, I have discussed how to download and print a remote file. Here is the blog linkhttp://www.navisionworld.com/2017/09/how-to-print-remote-file-from-nav.htmlThe 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.I was checking online to modify my old solution...
Share:

Friday, January 5, 2018

January 2018 Cumulative Updates for NAV 2013, 2013 R2, 2015, 2016 and 2017

Here are links to the release notes and download link for the CU's released.NAV 2013 – Cumulative Update 58You can download the cumulative update from KB4058596NAV 2013 R2 – Cumulative Update 51You can download the cumulative update from KB4058597NAV 2015 – Cumulative Update 39You can download the cumulative update from KB4058598NAV 2016 – Cumulative Update 27You can download the cumulative update from KB4058599NAV 2017 – Cumulative Update 14You can download the cumulative update from KB40586...
Share:

Thursday, January 4, 2018

Could not Load file or Assembly error after applying Cumulative Update

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 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. To unblock the dll I have clicked the Unblock check mark as shown in the below fig. and then tried to open the...
Share:

Wednesday, December 13, 2017

Batch Name disappears after you customize the Journal Page

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.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 youIn this example, let’s look at the whse. physical inventory journal pageAfter I have customized the page, the page will look...
Share:

Tuesday, December 12, 2017

New COMPANYPROPERTY function in NAV 2018

One of the new functions which were introduced in NAV2018 is COMPANYPROPERTY which has two propertiesDISPLAYNAME: Which will return the display name from the company recordURLNAME: Which will return the name in the URL Format.You can setup the Display Name on the company page as shown in the below figure: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 I have tried to the change the Display Name for testing but the change is not reflected...
Share:

Sunday, December 10, 2017

Using Placeholders in NAV Reports

Placeholders provide a method to customize the formatting and insert as an expression inside the textbox.To add a placeholder, click inside the textbox, then right-click and select Create Placeholder as shown in the figure.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.If we have used Placeholders inside the textbox...
Share:

Tuesday, December 5, 2017

December 2017 Cumulative Updates for NAV 2013, 2013 R2, 2015, 2016 and 2017

Here are links to the release notes and download link for the CU's released.NAV 2013 – Cumulative Update 57You can download the cumulative update from KB 4055888NAV 2013 R2 – Cumulative Update 50You can download the cumulative update from KB 4055889NAV 2015 – Cumulative Update 38You can download the cumulative update from KB 4055890NAV 2016 – Cumulative Update 26You can download the cumulative update from KB4055891NAV 2017 – Cumulative Update 11You can download the cumulative update from KB40558...
Share:

Connection refused error on NAV when connecting to web services

When you try to access Navision Web services you may encounter the following error“This Site can’t be reached, xxxx refused to connect”The most common reason for this error is the NAV Service is not enabled for SOAP/OData.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 trueEnable SOAP Services and Enable OData Services to true, if you are using SOAP you just need to enable SOAP and vice versa.You can also use the...
Share:

New System and Hidden Tables in NAV 2018

The following new system tables are added in NAV 2018 Two new hidden tables are added in NAV 2018The 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 endpointIf you have any other tips or suggestions , please do share them in the comments below. ...
Share:

Friday, December 1, 2017

Dynamics NAV 2018 is available to download

The much waited NAV version is now available to download, with lot of new features. Please download the software from the below linkhttps://mbs.microsoft.com/partnersource/global/deployment/downloads/product-releases/msdnav2018downloadYou can check what is new in NAV 2018 in this documenthttps://mbs.microsoft.com/Files/partner/NAV/Readiness_Training/ReadinessTrainingNews/WhatsNewDynamicsNAV2018.pdfSome of the new features in this release areImage AnalyzerPower BI reporting ControlBetter OCR IntegrationPreconfigured Excel ReportsBulk Posting of orders, invoices and credit memos.You can also change...
Share: