-
How to convert Dynamics NAV reports to NAV Extensions
Dynamics NAV Extensions are a way for Microsoft Dynamics NAV developers and ISVs to extend the functionality of NAV without modifying Microsoft’s original source code. In this blog post we will provide detailed information on how to move Dynamics NAV reports to NAV Extensions V2, also we will explain how to modify…
-
Now is the time to upgrade to Microsoft Dynamics NAV 2018 – why and how?
Microsoft has announced that D365 Business Central will be released on April 2, 2018. Now we can see details of the functionalities of Dynamics 365 Business Central. So, the question coming from the Dynamics NAV community is – should we migrate to Dynamics NAV 2018 now, wait for the Dynamics NAV 2018 updates, or start…
-
Text Editor NAV 2018
Hi, Does anyone know of a text editor that is usable with Nav 2018? Or have an example without an Automation object, if it is possible? T.I.A.
-
NAV Functions
How is RecordRef function used and under which circumstances..... could you give example... Thanks
-
Passing along new line commands to Report Header
I am modifying a report in Dynamics NAV 2016 with the SQL Report Builder. Its based in the 206 Sales invoice report. In the header it uses an array of length 8 for the address. But if for example the total use of the array is 4 and I want to add a field right after the customer address (its VAT) there will be 4 empty…
-
Remaining Amount penny about
Hello, I have a customer statement report.This report shows OPEN customer ledger entries. But I want to exclude the entries which remaining amount fields are between 0,01 and -0,01. In other words, I only want to show the data with remaining amounts greater than 0,01 and less than -0,01 becauuse I have some ledger entries…
-
Tip #36 | Using Mark and MarkedOnly in the RTC
Tip #36 | Using Mark and MarkedOnly in the Role Tailored Client When the Role Tailored Client was introduced in 2009 one of the things that is missing from the UI was the ability to Mark some records and filter on Marked Only records. This is usefull when you want a subset of your data with records that have no common…
-
News from Microsoft: the official name and launch date for Microsoft Dynamics 365 Business Central
For the last year, we have lived with a code name “Dynamics 365 Tenerife” and were waiting for the news from Microsoft. A couple of days ago in Msdynamicsworld.com and other Official Microsoft sources was announced that the official name will be Microsoft Dynamics 365 Business Central and will be launched on April 2, 2018,…
-
Everything you wanted to know about Dynamics 365 Business Central
During Directions Monthly Webinar: Microsoft Dynamics 365 Business Central Update, we have received some answers about D365 Business Central, which were a headache for most of Dynamics partners. In our blog post we will share with you some of the most important answers from Microsoft received during the webinar about…
-
Powershell Function/Script for Odata SSL
Greetings everyone, This is my first time posting here, so I hope this is the right place. I've created a function/script that can be used for setting up SSL on Odata on NAV2015/2017. This script also accounts for the bug in setting up the Odata SSL by turning it off and back on again after setting up the certificate. This…
-
RDP password decryption / encryption from NAV2017
Is it possible or is there a way to decrypt / encrypt RDP password from NAV2017. what is best approach/solution to do this?
-
Is there a way to start an RDP connection from NAV2017?
We want to start an RDP conection from NAV 2017. But we have no idea, if it is possible or what is the best way to do it.
-
Improved documentation of External Tables
In case you use Dynamics NAV on-prem. We made significant improvements to the documentation of External Tables: https://docs.microsoft.com/en-us/dynamics-nav/external-tables
-
Dynamics NAV Check Tool
Hi, I add this topic because i’m looking for a good tool to automatic check Dynamics NAV Guidelines. After searching with google I found a tool of a german company Implexis-Solutions, does somebody knows this company or tool? https://www.implexis-solutions.com/en/nav-check-tool#intro Or are there other/better tools to…
-
SQL from NAV - connection string
Hello, We have a NAV application that makes a direct SQL query from the NAV C/AL code. We need to do it to leverage some non-NAV functionality, and it works well except for one thing. We want to be able to get the NAV server and NAV database dynamically from the C/AL code. Right now we hardcode the connection information…
-
Record Timestamp Dynamics NAV 2016
Hello, In older NAV versions I've used a datetime timestamp field and a secondary key on the field in order to know when a record has been modified and to filter records for sending them to an interface. I've tried the same scenario in Dynamics NAV 2016 with a field type BigInteger and SQL timestamp property set to yes. If…
-
Problem with piece of code
Hello All. I have some problem with code: FOR I := 255 DOWNTO 128 DO CharTXr[CharTX] := I; Its strange Because in nav2009 it is work good, but in 2017 I get error like on screen. Can You explain me why?
-
Sales Cue, new Sales Orders /month
Hello, is it possible to create a cue that show´s all the new sales orders in the active month? somethin like this... Count("Sales Header" WHERE (Document Date=FIELD(Date Filter2))) ...but with this :p Count("Sales Header" WHERE (Document Date=FIELD(this month)))
-
Import data using RecordRef and FieldRef - How I Import data to correct tables and fields?
I created a Codeunit which by RecordRef and FieldRef export data to file or Table including all data from each field; this works great. Based on the info I have I now want to import data to correct tables and fields but seams to give me some problems. Anybody have an idea for how to? I really appreciate if anybody can help…
-
Trying to use codeunit 419 File management to show a dialog
I am new and trying to show a dialog with an image on it. The image content is stored as BLOB. I want to show this image on the dialog with OK button. I tried to use codeunit 419 FileMgt to do this. Is it possible? Any expert suggestion?
-
nav Report Sales orde
In sales line there is tow fields quantity and quantity shipped. i want to subtract the the two values and get it in report. The line value should print in Remain QTY1 and second value should print in Remain QTY2 and 3rd value should print in Remain QTY3 if more lines are there then it should print in Remain QTY3 The…
-
Change Visible property on subpage from test codeunit
Hi all, As far as I know and understand, this can't be done this way, but I would like to hear other opinions as well, or suggestion. I've failed some standard test, because Visible property of some fields on subpage is set to FALSE. I know that we can control Visible property with global variable, but here I don't want to…
-
Codeunit which updates global dimensions in the table G/L Entry.
Hi all, I am new in NAVISION and I need your help. I need to update Global Dimensions(those who are empty) in table G/L Entry. Please can you help me on this? I will appreciate your help. Thanks, Maddy.
-
Brick view on List Part in Web Client Nav 2017
Hi experts, Is there any way to set up brick view on list part page ? For example: Page A, which is in brick view, and SubPage B to be in brick view. Tnx,
-
Addressing Performance issues in Dynamics NAV and Dynamics 365 Business Central
Hi Guys, I wrote an article on addressing performance issues with the new versions of Dynamics NAV. Mainly NAV 2017 release and versions after this release. http://www.dynamicsnavconsultant.com/addressing-performance-problem-in-dynamics-nav-and-dynamics-365-business-central/
-
Create any graph in NAV using Excel
Simple example showing 3D clustered bar showing customer sales (LCY) last three years: ExcelApp Automation 'Microsoft Excel 15.0 Object Library'.Application ExcelBook Automation 'Microsoft Excel 15.0 Object Library'.Workbook ExcelSheet Automation 'Microsoft Excel 15.0 Object…
-
NAV 2017 web services with java
hey Here the old interface must be set up by a NAV 2017 web services, which must be set up in the NAV and called up in the JAVA.
-
Run codeunit with -consolemode, how to pass parameters?
Id like to execute a specific function instead of CODEUNIT.RUN. Is this possible?
-
How to find the position of space in text
Foe example I have a textdemo:='abc bcd def'. how to find the position of space in the demo? I have tried using strpos asSTRPOS(demo,' ') but I always get 0 or 1 as a result.
-
Cross docking based on Transfer order
Hi Advance WH Expert I am facing the issue on Cross-docking function in NAV. How can i cross-dock in warehouse receipt from TO.? any tips do you have? Odgo