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,
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.
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.
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.
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.
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.