How to create a Windows Service and connect it with Business Central to manage Local files

Since the arrival of Business Central on Cloud, a big question arose, how to now connect Local Files, Printers, and other peripherals with the ERP? To achieve this there are several ideas, such as One Drive, an SFTP server, or the one I want to show in this post, through a Local Service on the PC/Server/Laptop that needs to connect and expose it publicly so that later from Business Central it allows the relevant operations like read/write/delete and to create this exposure, we will use Azure Relay.

Source : Ivan Singleton
Read more…

Dynamics 365 Business Central: FileManagement.BLOBExport only save last file? -> Adding multiple files into a zip file

Last year, we have discussed how to save the report as a PDF, Excel, Word, HTML, or XML file.
More details: Dynamics 365 Business Central: How to save the report as a PDF, Excel, Word, HTML, or XML file (Report.RunRequestPage Method and Report.SaveAs Method) | Dynamics 365 Lab (yzhums.com)

As you might know, Report.SaveAsPDF() function or Report.SaveAsExcel() function not supported in Business Central Cloud SaaS (Cloud). So I tried to save report in Stream objects then convert to file using BlobExport function.

Source : Dynamics 365 Lab
Read more…

How to Create Functionality to Attach Multiple Files to Records in NAV

In the Stock Exchange Bookkeeping App I wanted to be able to attach multiple files (ex: PDFs) to BVB Entries.

The attachments are files received from the brokerage firm and they refer to a transaction. For example, if I buy 1 stock, I will have 3 BVB Entries with the same Transaction Number. If I attach files, they will be linked to the Transaction Number and visible as below, in a Factbox, for all BVB Entries with the same Transaction Number:

Bron : Andrei Lungu
Lees meer…

Making Sure All Columns Appear When You Combine Data From Multiple Files In Power BI/Power Query M

Here’s a really common problem that occurs when combining data from multiple files, or indeed any type of data source, in Power BI/Power Query/Excel Get&Transform. Imagine you have a folder with two Excel files in, and each Excel file contains a table called SalesTable:

Bron : Chris Webb’s BI Blog
Lees meer…