Business Central 2022 wave 2 (BC21) new features: Multiple Remit Addresses (Use multiple remit-to addresses for vendors)

Remit addresses are used when you print checks to pay your vendors. Vendors can have multiple remit-to addresses for payments. For example, a vendor might supply an item from a subsidiary company, but wants to receive payment at their headquarters.

Source : Dynamics 365 Lab
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…

Create a relationship with multiple columns in Power BI

When building Power BI reports we often need to join two (or more) tables together, but what if the relationship is defined by two or more columns? Relationships in Power BI are limited to single columns, but whilst this seems like a major limitation there is actually a simple solution to create a relationship with multiple columns in Power BI.

To create a relationship with multiple columns in Power BI we simply need to create a new column by merging the required columns together. What’s more, if we use the same name in both queries Power BI will automatically create the relationship for us.

Source : Dan Kinsella
Read more…

Business Central Send Email with Multi Attachments

The purpose of this APP is to be able to send an email with a series of attachments; in this case the email is sent to the user (to himself) so that it can then be changed in the email client before sending. In practice, both the Master document (ex Purchase Order) and all attachments are sent in bulk (obviously, keep an eye on the size of the files!).

Source : Roberto Stefanetti Blog
Read more…