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.
Now we have Enums, but how do we ensure that apps we create with enums are actually extendable? Just because the Enum can be extended does not ensure that the usage of them us truly extendable.
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.
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’.
This video demonstrates how to perform a select distinct with queries in Microsoft Dynamics NAV. The demonstration covers the following steps: What is a Select Distinct?
I don’t know how they did it, but my colleague (who’s blog I can only recommend :-)) pointed me to a new tiny small possibility in the DEV environment that was added in the newest Cumulative Update. Let’s not hold it from you ..
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.