May 2019 – Pardaan.com

Enum Object in Business Central – How to create and how to extend!

Since the dawn of Business Central Era (2nd April 2018 - Today), there are many new data types introduced by Microsoft. One such data type is Enum(Enumeration). Essentially, what enumeration is having a single select value with multiple options at a given time! Well, I know…

17 May 2019

Dynamics NAV & BC Tips & tricks

Generate Number Series from one Company and use it in another company

When dealing with Number Series where the Intercompany Documents are created automatically using the code, using standard number series generation Codeunits cause problems. In this blog, I'll be explaining why this issue is caused and how to resolve such issues. Source : OLISTERR'S NAV/BC - BLOG…

16 May 2019

Data & Analysis

Extracting All The M Code From A Power BI Dataset Using The DISCOVER_M_EXPRESSIONS DMV

DMVs (Dynamic Management Views) are, as the Analysis Services documentation states, “queries that return information about model objects, server operations, and server health”. They’re also available in Azure Analysis Service, Power BI and Power Pivot and are useful for a variety of reasons, for example for…

15 May 2019

Dynamics NAV & BC Tips & tricks

Use Excel to create a permission set

When developing in AL creating permission sets isn’t the must fun thing to do…. I thought it must be possible to find a better tool than editing the xml file manually and found some inspiration here. Based on that I created this excel sheet that you…

14 May 2019

Dynamics NAV & BC Tips & tricks

How To: Create a Job in Microsoft Dynamics Business Central

This blog describes two ways to create a new job that includes budgets in Microsoft Dynamics Business Central. By including budgets, you increase visibility into cost, which helps you predict cost overruns and maximize revenue. Source : ArcherPoint Read more...

13 May 2019

Data & Analysis

Using The “Skip Test Connection” Option For Power BI Data Sources To Avoid Scheduled Refresh Failures

One of the most popular blog posts I have written in recent years is this post on how the RelativePath and Query options for the Web.Contents() M function can be used to allow datasets that use web services as data sources to refresh successfully in the…

10 May 2019

Dynamics NAV & BC Tips & tricks

How to manually upgrade to Dynamics 365 Business Central events

If you just started working with Dynamics 365 Business Central events, you should read this short article from Microsoft first. If you are already familiar with what the events are, let‘s dig further into that. Everyone knows that 365 Business Central Upgrade to events might be…

9 May 2019