How to access timestamp from C/AL? When you Google/Bing this question, you mainly get three answers:
1.Short answer: you can’t,
2.Write a SQL query using ADO.NET,
3.Create a SQL view and use a linked table on NAV,
Author: admin
The Order You Select Columns In The Power Query Editor Can Affect The Output Of Some Transformations
Maybe this is obvious to more experienced Power Query users, but something I always point out when I’m training people up on Power Query is that the order that you select columns in the Power Query Editor window (both in Power BI Desktop and Excel) can affect the output of certain transformations.
Extending the Outlook Add-in Experience in Microsoft Dynamics 365 Business Central and Microsoft Dynamics NAV
One of the showcase features of Dynamics 365 Business Central is the ability to use the product within Microsoft Outlook clients using Outlook add-ins. There are two add-ins that come out of the box with Dynamics 365 Business Central: The Contact Insights add-in and the Document View add-in.
Ultimate Time Based Calculations Cheat Sheet for DAX / Power BI (including Week based calculations)
Power BI provides great time intelligence features to calculate Year-to-date (YTD), Month-to-date (MTD) and Quarter-to-date (QTD) totals. There is no such thing as Week-to-date (WTD) or Period-to-date (PTD) where period could be any arbitrary period definition (I used two-month periods in my example below). If you want those, you will have to create the calculations yourself.
Cost Roll Procedure in Microsoft Dynamics NAV
The information below explains the steps to follow while rolling standard costs in Dynamics NAV. The process is relatively simple, but the goal of this document is to explain the importance of each step: and what is accomplished in those steps. So while this may appear to be a long blog, stick with is as it provides a thorough explanation and rationale of each step.
HOW DO I – Customize Report Word Layout
One Good example is Report 1320 “Notification Email”. This report is used for sending workflow email notification.
Docs for Dynamics NAV 2016 and earlier are now on Docs.microsoft.com
For almost 10 years, you might have become used to finding content online for Dynamics NAV in the MSDN Library. We announced last year that we’re moving to the Docs.microsoft.com site, and today we moved the last bits to the Docs site as well.
Online content for Microsoft Dynamics NAV 2016 and earlier versions of Dynamics NAV is now available in the Previous Versions section of the Docs site.