When opening a database installed in AzureSQL, you may get this error: The database on the server requires a Per Database license to be opened on SQL Azure You must use Powershell to import the Dynamics NAV license. To import a license file to a AzureSQL database I used the following command: Import-NAVServerLicense DynamicsNAV100 -LicenseData ([Byte[]]$(Get-Content -Path […]
Everyone of us has already experienced an unexpected COMMIT in the middle of a posting routine, for example, that prevents the full rollback from happening whenever there’s an error. You can always use the debugger to track the code and step into it, line after line, trying to find where the commit is. This will work but will […]
As you may already have notice, standard commercial layouts (invoice, credit memo, order, etc) don’t show item tracking lines. Everytime our customers need to have this, they ask us to show the item tracking lines below each item line. Here’s how I did it, following the standard way available in the Sales – Shipment report […]
I was preparing a training session about Dynamics NAV 2015 and I was using a Cronus database that was already installed in my computer. I’ve added the Customer Card to Web Services and published it, just to test it. When I was going to connect to the webservice using .NET WS Studio, I got the […]
I was using Dynamics NAV 2013 R2 stock version and i’ve installed the cumulative update 6 for Dynamics NAV 2013 R2. After that, when I try to run an object in the Development Environment, a new Dynamics NAV session is opened instead of running the object in the currently opened session. This happens because in […]
Hi, I was trying to use Code Genius Studio (7.0.2.3018) with Dynamics NAV 2013 R2 Build 36366 (Cumulative Update 6) and I got this error when opening the Classic SQL client. Microsoft Dynamics NAV ——— The program property ‘company’ is unknown. The manual Installation and System Management contains a list of the correct program properties. […]
I was trying to run two services with different builds on the same PC and after I created the new service and configure it accordingly, I couldn’t start it. I looked at the Event Viewer and there was the following error message: Message: The service could not write to the EventLog because of: ‘The source […]
I was upgrading a database from NAV 5.0 SP1 to NAV 2013 R2. I’ve used the Form Transformation Tool to converted forms into pages. When executing a page with a subpage, I got the following error: Error: Server page is already open.. After hitting my head against the wall, I’ve discovered the problem. The […]
Hey, I was creating a new report and applying some filters while testing it. After a while, after changing the dataitems structure, i got the following error: Microsoft Dynamics NAV ——— Filter could not be applied. Could not apply filter “01/01/10..03/06/14” to column no. “20” because the field is missing or unavailable. ——— OK […]
Hi, When trying to import a xml file with 50 mb using a xmlport, i got this error: Microsoft Dynamics NAV ——— The file that you are trying to use is too large. ——— OK ——— This happens because Dynamics NAV limits the size of the files you’re importing. To handle this, you can change […]