-
API Integration
how to call .net url through codeunit in navision
-
Power Pivot Charts integration with NAV
Hello Experts!!! Today I just finished some Power Pivot charts using NAV data , I found its very useful and have very rich look with better business intelligence. So I just came up with a query that, is there any possibilities to get that Pivot charts back in to NAV dashboards/Role Center? If yes, then please share the…
-
Support for data classification (can be useful for getting GDPR compliant) in Dynamics NAV
We added support for data classification in Dynamics NAV (versions 2015, 2016, 2017, and 2018). Read more about it on the Dynamics NAV team blog: https://blogs.msdn.microsoft.com/nav/2018/03/08/classifying-data-in-dynamics-nav/
-
Extending ExcelBuffer in NAV2013 (Without external Assembly)
I'd like to share my solution for extending the excel buffer in NAV2013, since this was a common thing we've done in previous versions and now the whole ExcelBuffer handling completly changed! First of all, i already covered the topic in a blogpost here: http://devch.wordpress.com/2013/05/08/extending-excelbuffer-nav2013/…
-
Increment by 10
Hi guys :) I have a table Transport Line and I want to increase value of field "Line No." by 10 when I go to a new row. How can I do this without No. Series? "Line No." is my primary key. I tried this code but it doesn't work :/ Line No. - OnValidate() IF "Line No." = ' ' THEN BEGIN Lines.FINDLAST; "Line No." :=…
-
How to instrument your AL code in NAV2018
We added the new function SENDTRACETAG to the AL language in NAV2018 to enable our app teams to instrument the application in Dynamics 365 for Financials. Then during the preparation for Directions 2017, we realized that our partners could access all telemetry on the platform as well as telemetry written using…
-
Dynamics NAV 2018 -> PowerBi filtering
Do anybody have a nice guide how to make the filtering from NAV link through to a PowerBI Report? I want to set a filter on a item report so that it only shows data for the selected item in the powerbi factbox that has been added with NAV 2018. I cannot seem to find any guides/videos for this yet :(
-
how to put page link in cues
hi guys. how do I add these in my cues page? thank you for answering my question.
-
Auto Transfer Fields
I'm trying to implement a process that calculates the average of days where the customer actually pays an invoice and inserts into table Customer. I'll try to be as specific as possible: I've created a function that calculates the average number of days that a customer pays for invoices taking in account 2017. The goal is…
-
Export to existing Excel template
Hi everyone. How can I export data from my page, subpage etc. to Excel template that I have gotten for that purpose. I knpw that I should use Excel buffer table but do not know how. Practical steps could be useful since I looked online and found nothing useful. Thanks! :)
-
How no to show Location code when selecting Bin Code
Hi guys, I needed to show the bin code itself in the request page, But whenever i select the bin code in the screenshot above. this happens. it shows the same value in the location code whilst, i chose the bin code. why is this happening? is there something wrong in my declaration in the request page? this is the structure…
-
Dynamics NAV Extensions will make NAV upgrades much easier
Dynamics NAV solutions can be customized by partners, value-added resellers (VARs), and even some customers. This is an important benefit of the product and the service continues to be available. However, it has traditionally been carried out by overlayering the application code. The move to the cloud with more agile…
-
How to make automatic testing (regression) in NAV
Hello, I'm wondering whether there is a possibility to create automatic testing in NAVison? Have you ever been doing something like this in your projects? Thank you
-
Parallelism and Muti-threading in Dynamics NAV
With regards to performance tuning of NAV, I have a couple of cases where we need to look deeper into how NAV utilizes the allocated system resources (CPU cores, RAM memory, hard drives). The scope is locally for the NAV processes, and not related to the SQL service. Does anyone have in-depth information on how NAV…
-
Make sure Navision processes your c# automation events
This topic is for the .NET geeks who are among us. We will assume you know basics of C# and Navision automation. I'm developing a lot with Navision and Navision automation. On my previous projects I had already discovered that not all events that are fired by the automation components actually are processed by Navision.…
-
What’s New in Microsoft Dynamics NAV 2018?
The 1st of December is the launch day of Microsoft Dynamics NAV 2018. There were lots of rumors about new Dynamics NAV version, as we remember, but finally, the new Dynamics NAV 2018 is here and let‘s shortly review it and get some insights from Simplanova team about NAV 2018 in our new blog post.
-
Can't find a specific table " 99001451 " in Configuration packages
hello, i am trying to create a configuration package to export data and subsequently import data to excel. I found many of the tables i was looking for, yet i can't find - in the drop down ID menu within the configuration package NEW card - the table with the ID 99001451 which holds the barcode numbers. The peculiar thing…
-
Convert Dataports to XMLport NAV2016
Hi All, I maked a report to Convert Dataports (NAV2009) to XMLports (NAV2016). This not Perfect but with many Fields, lot of Code, Variabels etc it will get you a much easier way to do the Conversion If you know about other Tools that make it better, share it. If you make any improvals of this REP, just share that to. I…
-
Problem when send to Excel?
I can't figure out why excel doesn't show all columns that are on page which i want to send to excel? Is there a problem because i get data from different tables? Please help. Thanks in advance
-
How Send XML Document via HTTP Post Using DotNet?
Hi to all, I'd like to know how you can send an XML file via HTTP POST using DotNET. I'm currently using the seguende code: http://forum.mibuso.com/discussion/comment/296881/#Comment_296881 In the case: URL[1] := '\\****************\************\ICT\JSS\EDI\Invoice200117.xml';
WebaddressToPostTo :=…
-
Be sure to consider temporary tables as you create event subscriptions
Temporary tables of NAV standard tables are often used to store a subset of records to be able of changing some non-primary-key field values for later processing. This is why marking the records is not the solution. After the event subscribers have come into life, these functions !always! fire on each Insert, Modify,…
-
Haw to add PageBreaks to excell worksheet.
Hi, I've prepared excell worksheet using ExcellBuf. To meet the requirements should have Page Breaks. Is any method to ad it using CA/L ?
-
Special language character
Hi all, What does it depend on showing special character in .txt doc when exporting NAV objects? I can use special character to define captions in NAV, but when I export object, notepad doesn't recognize it. Regards, Stefan
-
AND Operator
Hi Experts As far as I see, NAV doesn't stop evaluating an AND statement after the first wrong expression. Example: IF expression1 AND expression2 THEN... Imho, expression2 is evalutated even expression1 is FALSE. The question: If expression2 is an expensive function, for example with DB access, is it better to write like…
-
VALIDATE Function
Hello, I have some piece of code, I am using it in lines. The result depends on 3 variables: "Finish Date Of Lease", "Start Date Of Lease" and "Discount %". Can you explain how can I use the VALIDATE function to enumerate result each time when some of this variable value will be change I used this tutorial…
-
Free Dynamics NAV Objects usage log tool
Upgrading your customers solutions from the classic version of NAV starts with analysis and defining the project scope. Simplanova knows that this process takes time and discussion with the customer which are usually non-billable hours so, in order to make this process easier and based on statistics, we have released a…
-
Opening page that depend on bool value
Hi all, Does anyone have any suggestions how to setup opening page that depend on some bool value in setup table, if some bool value is mark open one page and if is not open default page? Regards, Stefan
-
The 5 must-know facts about upgrading Microsoft Dynamics NAV Dataports to XMLports
Upgrading Dataports can be quite a difficult and challenging task as its structure has changed completely. All the experience and knowledge that you have in developing Dataports might be not so useful working with RTC equivalent – XMLports. We review some important issues that might be faced while developing XMLports in…
-
Get Currency Exchange from Bank of Canada
Good Morning, Did you get your Currency Exchange Rates from Bank of Canada? The format just changed as of June 1, 2017 and you now need to set it up via the new format. use this link : https://klemmensen.ca/ sub_title: Get Currency Exchange from Bank of Canada way to import multiple currencies juste use ',' between each…
-
Help to make a NAV query: That show records from table 1 that does NOT exist in table 2
hi Can anybody help on creating this query in NAV? In SQL it could be either one of 2 queries: SELECT * FROM Table1 LEFT OUTER JOIN Table2 ON Table1.name = Table2.name WHERE Table2.id IS NULL OR SELECT name, id from Table1 EXCEPT SELECT name,id FROM Table2