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…

Export SQL data to CSV or XML File via Powershell

Sometimes it may be useful or necessary to use powershell to read data from SQL Server to export it to other formats This can also be used with older versions of Dynamics NAV which do not have access to the integrated powershell. Using standard powershell commands it is possible for example to read an SQL view and export it to CSV or XML file.

Source : Roberto Stefanetti Blog
Read more…

Dynamics 365 Business Central: How to directly export Report from page (Custom Filename For Report Export)

I was asked a interesting question yesterday, is there any way to customize the filename when exporting the report?

As you know, with standard feature in Business Central, we can choose Send to… in the Request page of the report. (A request page is a page that is run before the report starts to execute)

Source : Dynamics 365 Lab
Read more…