Dynamics 365 Business Central: Select a report layout before printing

Recently I was asked a very interesting question, is there any way to select a layout file when printing a report?

As you might know, we have powerful report management features in Business Central. We can manage and select the default layout for the report in the Report Layout Selection page.

Source : Dynamics 365 Lab
Read more…

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.

Bron : Chris Webb’s BI Blog
Lees meer…

Dynamics NAV 2018- Select invoices to post- Batch post specific invoices

Dynamics NAV 2018 introduces a new method to post multiple invoices at one time. Simply go to your list view and hold down the Ctrl key and select the invoices you want to post and then from the ribbon at the top of the screen, select ‘Post’.

Bron : Advanced Business Systems
Lees meer…

Application Design Pattern: SELECT DISTINCT with Queries

This pattern explains how to perform SELECT DISTINCT by using queries in Microsoft Dynamics NAV. It is brought to you by Bogdana Botez from the Dynamics NAV team here at Microsoft Development Center Copenhagen (MDCC).

When you work with tables, sometimes you must perform a SELECT DISTINCT (also known as SELECT UNIQUE) from a table. As Dynamics NAV does not provide this out of the box, we present below a way to select unique records by using queries.

Bron : Microsoft Dynamics NAV Team Blog
Lees meer…