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”

Upcoming Microsoft Dynamics 365 Business Central Knowledge Hub Webinars (Oct-Dec 2024) from MADIC dynamics

MADIC dynamicsEvery month, on the third Tuesday, at MADIC dynamics we will be presenting a Knowledge Hub Webinar on Microsoft Dynamics 365 Business Central and related products; I will be presenting some of the webinars, but other consultants will be getting involved as well, so there will be a variety of presenters through time.

We aim to have the next three monthly Knowledge Hub Webinars scheduled and details of them available. The next three webinars, starting next month, are:

No oct-2024 events found.

Upcoming Microsoft Dynamics 365 Business Central Knowledge Hub Webinars (Oct-Dec 2024) from MADIC dynamics

What’s new in Business Central 2024 Release Wave 2

Tuesday, 19th November 2024 – 14:00-14:45

Discover the upcoming new features in Microsoft Dynamics 365 Business Central 2024 Wave 2. This session will cover the latest updates and improvements to keep your system current.

Register Here

Upcoming Microsoft Dynamics 365 Business Central Knowledge Hub Webinars (Oct-Dec 2024) from MADIC dynamics

Year-End Best Practice in Business Central

Tuesday, 17th December 2024 – 14:00-14:45

Best practice recommended steps for closing the year in Microsoft Dynamics 365 Business Central 2024 Wave 2. This webinar will guide you through essential tasks to ensure a smooth and compliant year-end process.

Register Here

MADIC dynamics Knowledge Hub Webinar on Tuesday 17th September 2024: How to Create a Multi-Company Report in Jet Reports

MADIC dynamicsHere at MADIC dynamics we will be presenting a Knowledge Hub Webinar at 1400 UK time on Tuesday next week.

Learn how to use Jet Reports to create a multicompany report from Microsoft Dynamics 365 Business Central. This session will cover the steps to consolidate data from multiple companies into a single report.

The webinar is open to everyone who wants to sign up and join:

No sep-2024 events found.

Upcoming Microsoft Dynamics 365 Business Central Knowledge Hub Webinars (Sep-Nov2024) from MADIC dynamics

MADIC dynamicsEvery month, on the third Tuesday, at MADIC dynamics we will be presenting a Knowledge Hub Webinar on Microsoft Dynamics 365 Business Central and related products; I will be presenting some of the webinars, but other consultants will be getting involved as well, so there will be a variety of presenters through time.

We aim to have the next three monthly Knowledge Hub Webinars scheduled and details of them available. The next three webinars, starting next month, are:

No sep-2024 events found.

No oct-2024 events found.

Upcoming Microsoft Dynamics 365 Business Central Knowledge Hub Webinars (Sep-Nov2024) from MADIC dynamics

What’s new in Business Central 2024 Release Wave 2

Tuesday, 19th November 2024 – 14:00-14:45

Discover the upcoming new features in Microsoft Dynamics 365 Business Central 2024 Wave 2. This session will cover the latest updates and improvements to keep your system current.

Register Here

MADIC dynamics Knowledge Hub Webinar on Tuesday 20th August 2024: Workflow in Business Central

MADIC dynamicsHere at MADIC dynamics we will be presenting a Knowledge Hub Webinar at 1400 UK time on Tuesday.

Explore the capabilities of standard workflows in Business Central and how Power Automate can be used to extend those capabilities.

The webinar is open to everyone who wants to sign up and join:

No aug-2024 events found.

Upcoming Microsoft Dynamics 365 Business Central Knowledge Hub Webinars (Aug-Oct 2024) from MADIC dynamics

MADIC dynamicsEvery month, on the third Tuesday, at MADIC dynamics we will be presenting a Knowledge Hub Webinar on Microsoft Dynamics 365 Business Central and related products; I will be presenting some of the webinars, but other consultants will be getting involved as well, so there will be a variety of presenters through time.

We aim to have the next three monthly Knowledge Hub Webinars scheduled and details of them available. The next three webinars, starting next month, are:

No aug-2024 events found.

No sep-2024 events found.

No oct-2024 events found.

MADIC dynamics Knowledge Hub Webinars: Upgrading to Business Central

MADIC dynamicsIn our most recent webinar here at MADIC dynamics, we took a look at Upgrading (to) Business Central.

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

  1. Introduction
  2. Goal of an upgrade?
  3. Identify Key Users
  4. Preparing for an Upgrade
  5. Types of Upgrade
  6. MADIC dynamics’ 5 Phase Delivery Approach
  7. Pre-Implementation Summary
  8. Next Steps
  9. Conclusion

Introduction ^

This webinar was presented by my colleague Rufus Lunn who took a run through an approach to upgrading to Business Central from Dynamics NAV.

Goal of an upgrade? ^

Before staring an upgrade project you need to determine why an upgrade is necessary.

Common reasons for upgrading are:

  • Scale for future growth
  • Move from obsolete systems/li>
  • Regulatory Requirements
  • Benefit from new functionality
  • Consolidate Data
  • Save on Time & Money

Identify Key Users ^

A successful project requires input from a variety of people within the business; upgrading from Dynamics NAV can be a large undertaking as there are often many pieces of custom development which have been done to the system and which need to be reviewed and potentially replaced.

Having too many responsibilities on one person can lead to things being missed. The key users common to a project are:

  • Executive Sponsor – Ensures alignment with goals, secures funding, overall direction.
  • Project Manager – Organises teams, manages timelines, primary point of contact.
  • IT Lead – Admin for solution, manages technical aspects of the project.
  • User Stakeholders
    • Subject Matter Experts (SMEs) – Advise on business requirements.
    • Super Users – Define testing scripts, take on training activity.
    • End Users – Conduct testing, engage with final system.
  • Data Owners – Ensures accuracy of data migrated to the new system.
  • Change Managers – Facilitates user adoption, gathers feedback.
  • IT Support Teams – Manages technical aspects of the implementation.

Preparing for an Upgrade ^

When preparing for an upgrade there are a few preparatory elements to consider:

  • Current system and requirements:
    • Number of users?
    • Which are the affected business processes and workflows?
    • Other related systems?
  • Data Migration requirements:
    • Assess Data: Need, Scale, Accuracy, Format, Storage?
  • Customisations and Extensions:
    • What developed code is currently in your system?
    • What other systems could interact with the solution?
  • End user base:
    • What are their training requirements?
    • How do they perceive the proposed upgrade?
    • How much change management work is needed?

Types of Upgrade ^

There are two approaches you can look at with regards to upgrading to Business Central, each of which have pros and cons:

Technical Upgrade ^

Move from existing platform via sequential upgrades to the new solution.

  • Pros:
    • Preservation of Data and Customisations: A technical upgrade aims to retain existing data, configurations, and customisations. This can save time and effort in migrating and recreating these elements.
    • Familiarity for Users: The interface and functionalities remain largely similar, reducing the learning curve for existing users.
    • Shorter Implementation Time: It often takes less time to perform a technical upgrade compared to a fresh re-implementation.
  • Cons:
    • Accumulated Technical Debt: Previous customisations or configurations may not align with best practices or could be outdated, potentially causing issues in the upgraded environment.
    • Limited Opportunity for Process Optimisation: You may miss out on the chance to reevaluate and improve existing business processes.
    • Potential Compatibility Issues: Existing customisations might not seamlessly integrate with the new version, requiring additional development work.
    • Inherited Issues: If there were issues or inefficiencies in the previous version, they could carry over into the upgrade.

Re-Implementation ^

Implement a fresh instance of the latest solution and migrate data.

  • Pros:
    • Clean Slate for Optimisation: Allows for a complete reassessment of business processes, potentially leading to more efficient workflows.
    • Adoption of Best Practices: Can ensure that the system is implemented according to the latest best practices and standards.
    • Opportunity for System Streamlining: Unnecessary customisations or outdated configurations can be omitted, leading to a more streamlined system.
    • Potential for Improved User Experience: Can provide an opportunity to enhance the user interface and experience based on current requirements.
  • Cons:
    • Data Migration Complexity: Transferring existing data to the new system can be a complex task, potentially leading to data quality issues.
    • Learning Curve for Users: Since the system may have significant changes, there could be a steeper learning curve for existing users.
    • Potentially Higher Initial Cost: A fresh re-implementation may be more expensive upfront due to the additional work involved.
    • Extended Implementation Time: It may take longer to implement a fresh re-implementation compared to a technical upgrade.

MADIC dynamics’ 5 Phase Delivery Approach ^

At MADIC dynamics we take a five phase approach to projects:

  • Analysis and Design:
    We begin with workshops to gain a thorough understanding of your business needs, resulting in the creation of a Solution Design Document.
  • Development:
    We then create specifications for any gaps and complete the development process, ensuring alignment with your specific requirements.
  • Build:
    We configure the system, perform the initial data migration, implement extensions and conduct rigorous quality assurance.
  • Test:
    We provide comprehensive training to your team and support them in conducting User Acceptance Testing to validate that your business needs are met.
  • Go Live:
    We carry out the final data migration, provide immediate post-live support, before transitioning the project to our dedicated support team for ongoing assistance.

Pre-Implementation Summary ^

To summarise the steps to consider before starting a project:

  1. Find your ‘Ideal’ and identify success criteria.
  2. Identify Key Users.
  3. Assess your current IT Landscape and Business Requirements:
    • Current System
    • Business Requirements
    • Data Migration
    • Assess Customisations and Extensions
    • End Users
  4. Technical Upgrade or Re-Implementation?
  5. Analysis and Design.

Next Steps ^

If you are looking to do an upgrade of Dynamics NAV to Business Central, the steps for a project are:

  1. Speak to us!
  2. Upgrade Assessment
  3. Indicative Estimate and Approach
  4. Analysis & Design Estimate and Approval
  5. SDD Creation and formal Project Estimate
  6. Begin Implementation

Conclusion ^

Upgrading Dynamics NAV to Business Central can, depending on the complexity of your system be an involved process, but taking a structured approach can mitigate the majority of problems which might arise. MADIC dynamics have considerable experience at both implementing Business Central and upgrading clients from Dynamics NAV. Even if you don’t plan to work with us on upgrading your system, the points outlined in this webinar should provide a good starting point when beginning the process of upgrading from Dynamics NAV.

One point to note, for those still using Dynamics NAV, is that all versions are now out of mainstream support which means support for any problems can only be delivered by your partner, with no assistance from Microsoft.

The webinar recording is available.

Upcoming Microsoft Dynamics 365 Business Central Knowledge Hub Webinars (Jun-Aug 2024) from MADIC dynamics

MADIC dynamicsEvery month, on the third Tuesday, at MADIC dynamics we will be presenting a Knowledge Hub Webinar on Microsoft Dynamics 365 Business Central and related products; I will be presenting some of the webinars, but other consultants will be getting involved as well, so there will be a variety of presenters through time.

We aim to have the next three monthly Knowledge Hub Webinars scheduled and details of them available. The next three webinars, starting next month, are:

No june-2024 events found.

No july-2024 events found.

No aug-2024 events found.

MADIC dynamics Knowledge Hub Webinars: What’s New in Business Central 2024 Wave 1

MADIC dynamicsIn our most recent webinar here at MADIC dynamics, we took a look at What’s New in Business Central 2024 Wave 1.

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

  1. Introduction
  2. New Features
  3. Conclusion

Introduction ^

This webinar was presented by my colleage at MADIC dynamics, Simon Bellinger, and covered the top new functionality he identified in the 2024 Wave 1 release of Microsoft Dynamics 365 Business Central which would be of most benefit to clients and others.

New functionality is announced for a release wave, but might not actually be released at the start of the wave, but anytime within the six months of the wave. The functionality Simon covered in the webinar, is mainly functionality which is already available for use.

New Features ^

The features covered by Simon were:

Two others that Simon would have covered, time permitting, were:

Conclusion ^

Business Central is in rapid development with Microsoft and has two annual release waves, both of which contains many enhancements and new functionality. The New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 series on this blog covered all of the announcements and it is worth keeping an eye on the functionality as it is announced, sp that you can see what will be released soon. It’s also worth keeping an eye on what is removed from a release as well; sometimes a piece of new functionality is announced, but then withdrawn for a, usually, undisclosed reason. These features are often re-announced, but other times they just disappear.

The ones covered by Simon in the webinar are announced and still listed and, in most cases, already available.

The webinar recording is available.

MADIC dynamics Knowledge Hub Webinar on Tuesday 21st May 2024: What’s New in Business Central 2024 Wave 1

MADIC dynamicsHere at MADIC dynamics we will be presenting a Knowledge Hub Webinar at 1400 UK time on Tuesday.

Discover the upcoming new features in Microsoft Dynamics 365 Business Central 2024 Wave 1.

The webinar is open to everyone who wants to sign up and join:

No may-2024 events found.