New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Manage Subscription Billing and Revenue and Expense Recognition

Microsoft Dynamics 365 Business CentralThis post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 2.

The 2nd of the new functionality in the Application section is manage subscription billing and revenue and expense recognition.

Businesses are finding ways to create recurring revenue streams by selling goods and services on a subscription basis. This release lets you manage subscription contracts in Business Central. The new subscription module lets you spend more time selling and less time organizing and invoicing contracts.

Enabled for: Users, automatically
Public Preview: Sep 2024
General Availability: Oct 2024

Feature Details

Companies across sectors have increased their adoption of digitalization and are revamping their products and services to accommodate subscription-based business models.

You can now support many different types of subscription scenarios in Business Central. There’s a simple set of processes that let you manage portfolios of the items and services that you bill on a recurring schedule. For example, hardware maintenance, IT support, cleaning services, and so on. You combine the sale of services and items in mixed subscription contracts that hold information about the items, services, and billing schedule.

Templates simplify the process of creating subscription contracts by standardizing the parameters and schedules for recurring billing. You can manage current pricing and plan for future price updates. On the accounting side, posting accruals to balance sheet accounts is automated, and revenue or expense are assigned to the correct periods in the income statement.

The new module comes with:

  • Contracts for which you do recurring billing for items and services.
  • Billing schedules with flexible parameters that cater to typical use cases for recurring billing.
  • Usage-based billing.
  • Automated billing.
  • Deferral integration.
  • Revenue recognition based on billing schedules.
  • Contract updates (parameters and prices).
  • Standard reports for contracts, customers, billing schedules, recognized revenue, future billing dates and amounts, and so on. Most reports are available as Power BI reports.

My Opinion

It’s interesting to see this module introduced; I can see how more Business Central users would be interested in this module. I’ll need to take a look and see how things work.

I do wonder what impact this will have on the ISVs out there with extensions for Business Central in this area? Is the new Microsoft module comprehensive or do the third party extensions offer more functionality?

Click to show/hide the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2 Series Index

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2
Auto-Apply Templates When You Synchronize Data With Dataverse
Use New Reports And Demo Data for Financial Reporting
Manage Subscription Billing and Revenue and Expense Recognition
Integrate Field Service with Service Management
Archive Service Management Documents
View Item Availability in Field Service Work Orders
Export Posted Sales Invoices to Shopify
Replenish Items for Projects
Reconcile Payment Transactions in Shopify with Invoices
Use Directed Put-Away and Pick Warehouses with Projects
Capture Data from E-Docs with Azure AI Document Intelligence
Add Invoice and Receipt Documents to E-Documents in Bulk
Import, Export Product Info Using Shopify Metafields
Define Shipping Information For Shopify Shipping Fees
Enable Locations In Shopify Refunds
See Improved Usability For Service And Projects
Allow More Than One User To Post Warehouse Entries at a Time
Add An Item As A Shopify Variant
Use Excel Reports For Consolidation And Fixed Assets
Synchronize Product Translations To Shopify
Use Specific Prices And Discounts When Synchronizing Prices In Shopify
Add Extended Text To Project Planning Lines
Use A Default Quantity Of 1 For Accounts On Documents
Stay Current With Shopify Connector
Analyze Fixed Asset And Subscription Billing In Power BI
Use Refreshed Demo Data For Sustainability
Suggest Number Series with Copilot
Chat with Copilot and Learn to Use Installed Add-On Apps
Complete Bank Account Reconciliation Faster with Copilot
Create Product Information Faster with Copilot
Summarize Any Record with Copilot
Experience Enhancements to Analysis Assist with Copilot
Start Using Copilot Without Having to Set Things Up
Create Sales Lines Easily with Copilot
Automate Tests for Your Copilot Extensions with the Business Central Test Toolkit
Start Creating Power Automate Flows With Copilot
Raise Awareness Of Copilot Actions On Card, Document, And Listplus Pages
Display Errors And Messages In Copilot Prompt Dialogs
Experience Enhancements To Chat With Copilot
Get Usage Telemetry On Copilot Extensions As An ISV
Use Copilot With Agent Capabilities To Automate Sales Order-Taking
Start Using Integration with IRS for 1099 Submissions
Start Using E-Documents Framework Localized for Germany
Enable Additional Countries and Regions
Show Features With Demo Dataset For Czechia
Deferral Accounting – Posting The Original Amount As Correction – Czechia
Posting Of Alternative Customer-Vendor Posting Groups – Czechia
Calculate And Post Vat Settlement By Activity Code – Italy
Advance Letters With Reverse Charge – Czechia
Vat Return Feature Now Available – Czechia
Include Employee Transactions In Exchange Rate Adjustment Report – Czechia
Improve Vat Reporting And Adjustments – Czechia
Allocations Functionality In Cash Desks – Czechia
Sales Advance From The Project – Czechia
Enable Use Of Other Currencies – Czechia
Submit IRS 1099 Forms Electronically To IRIS
Use The E-Documents Framework In The Spanish Version
Use Updated Saf-T 1.3 In Norway
E-File IRS 1099 Forms Without Integration
Set Up Easier In-Client Performance Profiling with Rules
Use the Ternary Operator when Coding in the AL Language
Pull Extension Source from GitHub when Opening Visual Studio Code from the Web Client
Use the 'This' Keyword for CodeUnit Self Reference
Restore Extensions if Publishing from Visual Studio Code Fails
Use Improved Features for Report Documents
Package Resources in Extensions and Access from AL
Run Code Action for 'With' for File, Project, or Workspace
Type Testing and Casting Operators for Interfaces
Extend Al Interfaces
Extend and Customize Profiles from Other Extensions
Remove Friction When Working With External App Dependencies
Specify And Use Full-Text Search Indexes On Table Fields
Run Page Scripts In Pipelines For Automated Testing
Manage Environment Updates More Flexibly
Migrate Record Links and Notes with Cloud Migration Tooling
Manage Per-Tenant Extensions in Admin Center
View App Compatibility with Future Versions in Admin Center
Get Notified About Issues with Job Queue Background Processing
Get List of Manageable Environments for Microsoft Entra Apps
Support IPv6 for Enhanced Security and Scalability
Encrypt Data At-Rest With Customer-Managed Encryption Key
Get External Notifications When Job Queue Entries Fail
Use E-Documents with Power Automate
Use Multiple VAT Numbers for a Customer
Achieve Sustainability Scorecards and Goals
Navigate the Sustainability Manager Role Center with Ease
Add Attachments When You Send Electronic Documents
Record Greenhouse Gas Emissions Using Purchase Invoices
Report Sustainability Entries with Financial Reports
Use New Service Providers in the E-Documents Framework
Purchase Carbon Credits
Enable Internal Carbon Fee Calculation in Sustainability
Track Sustainability Certificates For Items And Vendors
Use Multiple Subcategories For One Sustainability Account
Use Embedded Power Bi Reports Out Of The Box
Do Ad Hoc Analysis On Fixed Assets, Projects, And Services
Use Advanced Settings In The Power Bi Connector
Use Built-In Named Formulas In Excel Layouts
Access Keys with Key Tips In More Languages
Use Drag and Drop On File Upload Dialog to Attach Multiple Files
Resize Columns Even when Personalization isn't Enabled
Change The Data Search Method In Lists

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Use New Reports And Demo Data for Financial Reporting

Microsoft Dynamics 365 Business CentralThis post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 2.

The 1st of the new functionality in the Application section is use new reports and demo data for financial reporting.

New reports are provided as demo data for Business Central. The reports can serve as ready to use reports, or as template you can use to create your own financial reports. In addition, you can generate more demo data to get a better idea of what data the reports display.

Enabled for: Users, automatically
Public Preview: –
General Availability: Oct 2024

Feature Details

The list of standard reports for financial reporting is expanded to include five new reports. In addition, a set of five new row definitions and 12 column definitions are provided. You can combine them to create more than 25 new reports.

The following table lists the new reports:

Name Description
TB Trial Balance
BS DET Balance Sheet Detailed
BS SUM Balance sheet Summary
IS DET Income Statement Detailed
IS SUM Income Statement Summary

The new row definitions have the same names and descriptions as the reports.

The following table lists the new column definitions:

Name Description
BBDRCREB TB Beginning Balance Debits Credits Ending Balance
BSTREND BS 12 Months Balance Trending Current Fiscal Year
CB BS Current Month Balance
CB V PB BS Current Month Balance v Prior Month Balance
CB V SPYB BS Current Month Balance v Same Month Prior Year Balance
CNC IS Current Month Net Change
CNC BUD IS 12 Months Net Change Budget Only
CNC V PNC IS Current Month Net Change v Prior Month Net Change
CNC VSPYNC IS Current Month Net Change v Same Month Prior Year Net Change
CNCVPNCYOY IS Current Month v Prior Month for CY and Current Month v Prior Month for PY
CVC YTDBUD IS Current Month v Budget Year to Date v Budget and Bud Total and Bud Remaining
ISTREND IS 12 Months Net Change Trending Current Fiscal Year

note NOTE

The five reports are ready to use for the US version. For other country version, you must map the row definitions to your chart of accounts in order for the reports to display any data. Microsoft will work on providing the ready-to-use experience for more country version in future releases.

Financial reporting demo data

Financial reporting is at the core of every business, and when evaluating business management applications it’s often desirable to view the reporting capabilities as they would look like for a running company. The new demo data can be generated by running the Contoso Financial demo data from the Contoso Demo Data tool page. The data will contain three years of G/L entries, broken down to dimensions with a Budget for the current year for variance analysis reporting.

New income statement report

My Opinion

This sounds like it could be a good enhancement with additional reports available for demo purposes, although it will require work for anyone outside of the US to configure the row definitions with the chart of accounts.

Click to show/hide the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2 Series Index

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2
Auto-Apply Templates When You Synchronize Data With Dataverse
Use New Reports And Demo Data for Financial Reporting
Manage Subscription Billing and Revenue and Expense Recognition
Integrate Field Service with Service Management
Archive Service Management Documents
View Item Availability in Field Service Work Orders
Export Posted Sales Invoices to Shopify
Replenish Items for Projects
Reconcile Payment Transactions in Shopify with Invoices
Use Directed Put-Away and Pick Warehouses with Projects
Capture Data from E-Docs with Azure AI Document Intelligence
Add Invoice and Receipt Documents to E-Documents in Bulk
Import, Export Product Info Using Shopify Metafields
Define Shipping Information For Shopify Shipping Fees
Enable Locations In Shopify Refunds
See Improved Usability For Service And Projects
Allow More Than One User To Post Warehouse Entries at a Time
Add An Item As A Shopify Variant
Use Excel Reports For Consolidation And Fixed Assets
Synchronize Product Translations To Shopify
Use Specific Prices And Discounts When Synchronizing Prices In Shopify
Add Extended Text To Project Planning Lines
Use A Default Quantity Of 1 For Accounts On Documents
Stay Current With Shopify Connector
Analyze Fixed Asset And Subscription Billing In Power BI
Use Refreshed Demo Data For Sustainability
Suggest Number Series with Copilot
Chat with Copilot and Learn to Use Installed Add-On Apps
Complete Bank Account Reconciliation Faster with Copilot
Create Product Information Faster with Copilot
Summarize Any Record with Copilot
Experience Enhancements to Analysis Assist with Copilot
Start Using Copilot Without Having to Set Things Up
Create Sales Lines Easily with Copilot
Automate Tests for Your Copilot Extensions with the Business Central Test Toolkit
Start Creating Power Automate Flows With Copilot
Raise Awareness Of Copilot Actions On Card, Document, And Listplus Pages
Display Errors And Messages In Copilot Prompt Dialogs
Experience Enhancements To Chat With Copilot
Get Usage Telemetry On Copilot Extensions As An ISV
Use Copilot With Agent Capabilities To Automate Sales Order-Taking
Start Using Integration with IRS for 1099 Submissions
Start Using E-Documents Framework Localized for Germany
Enable Additional Countries and Regions
Show Features With Demo Dataset For Czechia
Deferral Accounting – Posting The Original Amount As Correction – Czechia
Posting Of Alternative Customer-Vendor Posting Groups – Czechia
Calculate And Post Vat Settlement By Activity Code – Italy
Advance Letters With Reverse Charge – Czechia
Vat Return Feature Now Available – Czechia
Include Employee Transactions In Exchange Rate Adjustment Report – Czechia
Improve Vat Reporting And Adjustments – Czechia
Allocations Functionality In Cash Desks – Czechia
Sales Advance From The Project – Czechia
Enable Use Of Other Currencies – Czechia
Submit IRS 1099 Forms Electronically To IRIS
Use The E-Documents Framework In The Spanish Version
Use Updated Saf-T 1.3 In Norway
E-File IRS 1099 Forms Without Integration
Set Up Easier In-Client Performance Profiling with Rules
Use the Ternary Operator when Coding in the AL Language
Pull Extension Source from GitHub when Opening Visual Studio Code from the Web Client
Use the 'This' Keyword for CodeUnit Self Reference
Restore Extensions if Publishing from Visual Studio Code Fails
Use Improved Features for Report Documents
Package Resources in Extensions and Access from AL
Run Code Action for 'With' for File, Project, or Workspace
Type Testing and Casting Operators for Interfaces
Extend Al Interfaces
Extend and Customize Profiles from Other Extensions
Remove Friction When Working With External App Dependencies
Specify And Use Full-Text Search Indexes On Table Fields
Run Page Scripts In Pipelines For Automated Testing
Manage Environment Updates More Flexibly
Migrate Record Links and Notes with Cloud Migration Tooling
Manage Per-Tenant Extensions in Admin Center
View App Compatibility with Future Versions in Admin Center
Get Notified About Issues with Job Queue Background Processing
Get List of Manageable Environments for Microsoft Entra Apps
Support IPv6 for Enhanced Security and Scalability
Encrypt Data At-Rest With Customer-Managed Encryption Key
Get External Notifications When Job Queue Entries Fail
Use E-Documents with Power Automate
Use Multiple VAT Numbers for a Customer
Achieve Sustainability Scorecards and Goals
Navigate the Sustainability Manager Role Center with Ease
Add Attachments When You Send Electronic Documents
Record Greenhouse Gas Emissions Using Purchase Invoices
Report Sustainability Entries with Financial Reports
Use New Service Providers in the E-Documents Framework
Purchase Carbon Credits
Enable Internal Carbon Fee Calculation in Sustainability
Track Sustainability Certificates For Items And Vendors
Use Multiple Subcategories For One Sustainability Account
Use Embedded Power Bi Reports Out Of The Box
Do Ad Hoc Analysis On Fixed Assets, Projects, And Services
Use Advanced Settings In The Power Bi Connector
Use Built-In Named Formulas In Excel Layouts
Access Keys with Key Tips In More Languages
Use Drag and Drop On File Upload Dialog to Attach Multiple Files
Resize Columns Even when Personalization isn't Enabled
Change The Data Search Method In Lists

What is the Microsoft Power Platform?

Power PlatformI’ve been posting about working with Power Automate in general and using it with Business Central for a while now, but I’ve never really explained the Power Platform, of which Power Automate is a part (although I did introduce Power Automate itself).

The Power Platform is a low-code platform for rapidly building customised end-to-end business solutions. Power Platform includes four main products, which can be used individually or together:

Power AppsPower AutomatePower BIPower Pages

  1. Power Apps – allows apps to be created which can be run on a browser or mobile device, they can be used by internal users.
  2. Power Automate (formerly Microsoft Flow) – automation of tasks and activities acorss numerous services using integrated or custom connectors.
  3. Power BI – business intelligence solution which provides interactive data visualization BI tools to help users visualize and share data and insights across their organization.
  4. Power Pages (formerly part of Power Apps until 2022) – secure, secure, enterprise-grade, low-code software as a service (SaaS) platform for creating, hosting, and administering modern external-facing business websites.

While Microsoft bill all parts of the Power Platform as low-code, I think that developers, or at least people with experience in programming, will find the logic patterns required to build flows easier to manage than someone without experience.

Certainly with Power Automate there are development principles which should be followed, such as Application Lifecycle Management which requires the use of solutions, separate environments for development, testing and production and use of child flows.

The other areas of Power Platform are very similar; organisations which allow a free for all in Power Platform are storing up a lot of trouble for the future.