MADIC dynamics Knowledge Hub Webinars: How to Create a Multi-company Report in Jet Reports

MADIC dynamicsIn our most recent webinar here at MADIC dynamics, we took a look at how to create a multi-company report in Jet Reports. This is a webinar which I presented.

If you want to catch up on this webinar, you can do so here.

  1. Introduction
  2. Multi-company data in reports
  3. Multi-company by columns
  4. Multi-company by sheets
  5. Consolidation sheet using INDIRECT function
  6. Conclusion

Introduction ^

Jet Reports is a third-party add-on for Microsoft Dynamics 365 Business Central which is widely used along side Business Central. It is popular because it is very flexible, allowing reports to be created against any table in Business Central, whether from a standard or third-party table. It can be used to create both financial and operational reports.

Many of the clients I work with have multiple companies in Business Central and therefore a need for multi-company reporting.

In this webinar I took a look at the way that the Jet functions can be used to pull data from multiple companies into a single report. The webinar focused primarily on doing so using the GL function, but the same can be done with the NL function.

Multi-company data in reports ^

When you build or run a Jet Report the data, if you do nothing to override it, will come from the default company specified in the company selection on the Excel action bar:

Excel action bar showing the Settings tab of Jet Reports

Continue reading “MADIC dynamics Knowledge Hub Webinars: How to Create a Multi-company Report in Jet Reports”

New Functionality In Microsoft Power Automate 2024 Wave 2: Monitor Performance For Cloud and Desktop Flow Activities In Automation Center

Power AutomateThis post is part of the New Functionality In Microsoft Power Automate 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 2.

The 5th of the new functionality in the Cloud flows section is monitor performance for cloud and desktop flow activities in Automation Center.

You can use a central consolidated view to monitor and understand the executions across cloud and desktop flows.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview:  Jun 5, 2024
General Availability: Nov 2024

Feature Details

With this feature, you have a single consolidated view to understand the automation performance across your cloud and desktop flows. This feature enables you to:

  • Understand the top trends across all of your automation assets (for example, success and failure) across different time periods.
  • Understand top errors and their trends.
  • Understand top flows with specific errors.
  • Seamlessly switch between cloud and desktop flows activity.

Click to show/hide the New Functionality In Microsoft Power Automate 2024 Wave 2 Series Index

In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the “Get Adaptive Card V3” Action

Microsoft Dynamics 365 Business CentralThis article is part of the In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… series, a sub-series of the In Microsoft Dynamics 365 Business Central (Power Automate), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

There are a number of actions available in Power Automate for Business Central which allow specific actions against the data of Business Central to be performed from within Power Automate.

The 10th action which is available is the Get adaptive card (V3) one which allows you to create an adaptive card which you can use in Teams or elsewhere. This is a new action, introduced in the 2-23 Wave 1 release.

Within a flow, click the add action button; search for Business Central and select the Business Central icon (make sure you select the SaaS one, which is a dark colour instead of the on-premises one which is mainly white):

Choose an action dialog with Business Central in the search results

Continue reading “In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the “Get Adaptive Card V3” Action”