January 2019 – Page 3

Automated Testing in Business Central

Testing is the essential part of the software development process and Cover User Scenarios. Developers take care of their unit tests and perhaps, some wider coverage when they deliver a finished module. When developer tests the software he only tests scenarios for which he have done…

15 January 2019

Data & Analysis

Use more variables in DAX to simplify your life

Today I ran across a pretty straightforward DAX challenge that is made so much simpler thanks to variables. So I decided to share it. Remember folks use variables for each and every measure (even if you don’t think you need them). It will prepare you for…

14 January 2019

Dynamics NAV & BC Tips & tricks

How to Use Date Functions in Microsoft Dynamics Business Central On Premises

There are various places throughout Microsoft Dynamics 365 Business Central where you can enter dates in fields. In fact, a good deal of data in the application is linked to dates. For example, in a sales order, you can set the shipment date. When filtering lists…

14 January 2019

Dynamics NAV & BC Tips & tricks

How to fetch data in Part type page using a Query in NAV?

First question is why query? Lets see the advantage of queries. 1.First you can limit the amount of data you retrieve from the server by defining only the specific columns you need 2.You can join multiple tables into one query saving loop code pattern. 3.They are…

11 January 2019

Dynamics NAV & BC Tips & tricks

Interface extensions with workflows

A while ago I wrote about our Extension Design Principles. In it I discussed various ways to interface between extensions without having to take dependencies. One of these interface methods was the workflows Business Central is equipped with. Because you can configure these workflows at run-time…

10 January 2019

Dynamics NAV & BC Tips & tricks

How Do I : Create a Document Report, and layout, in VSCode? (part1)

In my blog post: How Do I : Create a Report, and layout, in VSCode? I explained the basics on how you can create a simple report for Business Central. In this post, and due to many requests, I will explain how you can get started…

9 January 2019

Dynamics NAV & BC Tips & tricks

Codeunits in Microsoft Dynamics 365 Business Central

In Microsoft Dynamics 365 Business Central, there are a lot of codeunits already available. Every codeunit is a collection of different functions. If they are global functions, they can be called from within your own code. There are codeunits that help you work with XML data,…

8 January 2019