I want to show you how I was able to print invoices and credit memos (or other reports) on a roll paper printer from Dynamics NAV. I was using Dynamics NAV Universal App in a tablet with Android and I wanted to print to a printer connected via Bluetooth. If you tried it, you’ve already found […]
If you want to handle different Dynamics NAV Server versions, ServiceTierAdministration is the way. No doubt about it. You may download it from Mibuso: https://mibuso.com/downloads/service-tier-administration-tool But you can do it using Windows sc command and/or hacking the Windows registry. So let’s learn how to do it by examples: 1. How to create a new service instance named […]
Dynamics NAV allows you to “easily” export information to an Excel file, via code, using the Excel Buffer table. To export a cell value as a formula, you may add and use the following function to your object: LOCAL EnterFormula(RowNo : Integer;ColumnNo : Integer;CellValue : Text[250];Bold : Boolean;UnderLine : Boolean;NumberFormat : Text[30]) ExcelBuf.INIT; ExcelBuf.VALIDATE(“Row No.”,RowNo); […]
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 […]
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 […]