Creating a Vendor Remittance Report with an Email Body in Business Central

Microsoft Dynamics 365 Business Central offers multiple ways to create a vendor remittance report; one option is an email. The video’s main focus is formatting the vendor payment advice through the payments journal. This video also shows all the steps needed to create a vendor remittance report with an email body, including the requirement of having an EFT setup in Business Central with your bank.

Source : ArcherPoint
Read more…

Dynamics 365 Business Central: Intellisense will suggest tables for report extension data-items

VS Code IntelliSense features are powered by a language service. A language service provides intelligent code completions based on language semantics and an analysis of your source code. If a language service knows possible completions, the IntelliSense suggestions will pop up as you type.

Source :Dynamics 365 Lab
Read more…

D365 Business Central : Using Excel Layout for Reporting

Since Business Central 2022 Wave 1 (BC20), we have the ability to use Excel Layout for reporting. Excel layouts work the same way as Word and RDLC layouts in that they can be edited and saved back again into Business Central. With Excel layouts for Business Central reports, users can now create and edit report layouts simply by using the full capabilities in Excel such as sliders, diagrams, charts, and pivot tables. Let’s try to create one using Inventory Order Details.

Source : That NAV Guy
Read more…

Dynamics 365 Business Central: report extensions and global variables in preview mode

Today I received a call from a partner that was going crazy on a problem during the preview of some statistical reports in Dynamics 365 Business Central.

The report was a custom modification of an existing one (done via a reportextension object). In this reportextension, the partner added some global variables used to perform filters and actions on the report’s dataitem, but the report seems not working correctly on preview (global variables changed in the request page was cleared).

Source : Stefano Demiliani
Read more…

Dynamics 365 Business Central: How to build extension (Package/Publish) without generating report layout files??? – (“al.compilationOptions” -> “generateReportLayout”)

Today I would like to share a mini tip of Business Central, how to build extension (Package/Publish) without generating report layout files in VS Code.

When we create a new report, there are two main tasks to consider. First, we define the report dataset of data items and columns. Then, we design the report layout.

Source : Dynamics 365 Lab
Read more…