March 2019 – Page 2 – Pardaan.com

Graphical planning tools in Dynamics NAV and Business Central

The complete\detailed planning in Dynamics 365 Business Central (and in Dynamics NAV sure..) is done through the MPS\MRP planning which can be launched from the planning worksheet (you can find some posts on the planning parameters in this blog); However, it is also possible to use…

13 March 2019

Data & Analysis

SQLBits Power BI And Analysis Services Videos Now Free To View Online

SQLBits is one of the best Microsoft data platform conferences around, and last week’s event in Manchester was particularly good. As usual, videos of almost all of the sessions are available for everyone to view for free online (no registration required) here: Source : Chris Webb's…

12 March 2019

Dynamics NAV & BC Tips & tricks

How To: Work with Multiple AL Projects in One Workspace Using Visual Studio Code in Microsoft Dynamics Business Central On Premises

If you’re new to Microsoft Dynamics Business Central on premises, you need to know how to easily customize it. In this blog, you’ll learn how you can work with multiple AL projects in one Visual Studio Code editor in Microsoft Dynamics Business Central on premises. Source…

11 March 2019

Dynamics NAV & BC Tips & tricks

Event subscription and performance

When we design and write our code we need to think about performance. We have been used to thinking about database performance, using FindFirst(), FindSet(), IsEmpty() where appropriate. We also need to think about performance when we create our subscriber Codeunits. Bron : Gunnar's Blog Lees…

8 March 2019

Dynamics NAV & BC Tips & tricks

Matrix Heatmap Add-In

Matrix Heatmap Javascript Control Add-in for Microsoft Dynamics NAV. A heat map is a graphical representation of data where the individual values contained in a matrix are represented as colors. Bron : Oleg Lobakov Lees meer...

7 March 2019

Data & Analysis

Query by Example to Extract YYYY-MM from a Date Column

I was answering a question for a student in one of my online training courses this week. The question was, “Do you know of a way in power query to efficiently extract YYYY-MM from a Date column?” This can be done ‘manually’ with multiple steps including:…

7 March 2019

Dynamics NAV & BC Tips & tricks

Business Central as an app: getting to the al source code

You must have heard the latest news: Microosft released the first devpreview (on docker) where Business Central is an app, and there is close to no C/AL anymore. Either you might have gotten it from the blog from Microsoft, or Stefano’s blog, where he explained how…

6 March 2019