Dynamics 365 Business Central: How to export Work Description (Blob) in Sales Documents to excel

Last week I saw a question on the Business Central forum, how to export the Work Description in Sales Documents to excel?

As far as I know, Microsoft added this new field in Sales Documents since NAV 2017. It help users to add more details about Sales Quote or Sales Invoice.

Source : Dynamics 365 Lab
Read more…

Dynamics 365 Business Central: Shared layout view and Detached layout view (Unique layouts of the columns on a list)

Today I would like to talk about Shared layout view and Detached layout view in Business Central.

As you might know, when you have set a filter on a list and you want to keep the filter for later, you can save it as a view.

Source : Dynamics 365 Lab
Read more…

D365 Business Central : Using Query to Get Distinct Values

When working with table data, there will be times when we need to retrieve a unique record value from the table (also called SELECT DISTINCT). Unfortunately, D365 Business Central does not provide this logic out of the box. We will need to find a way to do this ourselves.

Source : That NAV Guy
Read more…