Microsoft Dynamics 365 Business Central Statement Import Importing all Dates as January

Microsoft Dynamics 365 Business CentralOn a recent implementation of Microsoft Dynamics 365 Business Central we created some data exchange definitions for the import of statements, but when it came to testing the client reported that all lines were being imported dated in January.

So a transaction dated 20/6/2024 would import as 20/01/2024. I did a little exploring and realised that the issue was the data format I had applied to the date field on the column definition.

I had entered the data fromat as dd/mm/yyyy, but it needed to be dd/MM/yyyy:

Column Defintions fastab on the Data Exchange Definition page

This is actually quite common for dates to require te month to be capitals, as lower case mm is minutes. Once I updated the definition, the statements imported correctly.

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Migrate Record Links and Notes with Cloud Migration Tooling

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

The 12th of the new functionality in the Governance and administration section is Migrate record links and notes with cloud migration tooling.

Business users often attach links and notes to records in Business Central to add context and extra information. For businesses transitioning from on-premises to cloud environments, this feature ensures that these links and notes on records are included in the cloud migration without the need for the external tooling. The feature saves valuable time and reduces the risks of error with manual data transfer..

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

Feature Details

Previously, the record links and notes were not automatically migrated to the online tenant as part of the cloud migration process. Instead, you had to use manual means to move the data. Now, the cloud migration setup and replication tooling will automatically migrate the links and notes on records for you with minimal work on your part.

Screenshot of the item card in Business Central showing the record links and notes.

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

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1
Use Virtual Tables to Expose More Business Central Data in Dataverse
Improve Approval Processes via Power Automate
Add Table and Field Mappings for Existing Integration Tables
Find a Matching Record in a Power Automate Flow
Archive Projects
Usability Improves for Service and Projects
Use Deferral Codes in Purchase and Sales Journals
Define a Service Invoice Posting Policy for Various Users
Define Default Location for Project or Project Phase
Block Item, Item Variant or Service Item from Use in Service Management transactions
Connect Business Central With Shopify B2B
Set Up Financial Consolidation Runs More Efficiently
Simpler Shopify Connection
Use General Ledger Account Revaluation for More Accurate Financial Statements
Get More Productive While Entering Time Sheets
Create Projects That You Can Invoice to Multiple Customers
Assemble to Project
Invoice a Customer for Multiple Projects
Use New Excel Layouts for 35 Selected Reports
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Manage Work Orders in Field Service, Invoice Them in Business Central
Manage Document Attachments in Service Items and Documents
Export and Import Multiline Text Using Configuration Packages
Correct Errors in Service Invoices
Prevent Editing Number Series on Service Documents and Cards
Be More Productive When Approving Time Sheets
Inventory Package Numbers Work Like Item Tracking Dimensions
Assign Salesperson to Customer Ship-to Addresses
View Incoming Documents in Archived Quotes and Orders
Specify Dimensions on Posted Entries Applications With Realized Gains or Losses
Allow Lines with Amounts of Zero on Recurring General Journals
Automate the Reminders Process in Collections
See Improved Usability for Warehouse and Inventory
Ensure Accurate Inventory Valuation by Controlling Cost Adjustment
Use a New Role Center for Collection Management
Manage Subscription Billing and Revenue and Expense Recognition
Enable Sustainability Features for Integrations with APIs
Install Field Service Integration with Business Central from AppSource
Introduce Power Automate Copilot Integration with Business Central
Map e-Documents to Purchase Order Lines with Copilot
Create Sales Lines Easily with Copilot
Extend Copilot Using Richer Development Tools
Get to Insights Faster with Copilot-Generated Analysis Tabs
Complete Bank Account Reconciliation Faster With Copilot
Create Product Information Faster with Copilot
Learn More About Fields with Copilot
Chat with Copilot
Simplify collections with Copilot for Finance and Business Central
Automate Tests for your Copilot Extensions with the Business Central Test Toolkit
Automate IRS 1099 Form Submission in US
Enable Additional Countries and Regions
Install UK Localization as an App
Process Czech Bank Statements, Payment Orders More Productively
Improvement of Czech Localization Reports
Report Explorer has Additional Outputs in the Czech Version
Improved Updates of ARES Data in the Czech Version
Allow More Extendability of Advance Payments in the Czech Version
Print QR Codes on Sales Invoices in the Czech Version
Use Excel Layouts for Czech Reports
Handle Multiple File Uploads and File Drop Zones
Debug the System Application
Remove Friction When Working with External App Dependencies
Use In-client Page Scripting Tool for Acceptance Testing
Use AL-controlled Barcode Scanning For All Scenarios
Write flexible and performant code with NumberSequences
Use the OData V4 IN Operator in Web Service Queries
Define Extension Objects in Same App as Their Base Object
Use Cookies in HTTP Calls From Business Central
Define Tooltips on Table Fields
Use Linked Environment in Dataverse Integration
Audit Business Central Operations in Microsoft Purview
Encrypt Data At-Rest with Customer-Managed Encryption Key
Allow Customers to Consent to Microsoft Support Accessing Their Data
Link Business Central Environments to Power Platform Environments
Copy Companies with Dataverse Integration Safely
View and Filter Users With Additional User Details
Control partner access per environment
Analyze Telemetry Events Across Browser and Server for a Session or User
Use Premium License to Sign In to Environment with Essentials Licenses
Experience the New Embedded AppSource Marketplace Page
Migrate Record Links and Notes with Cloud Migration Tooling
See VAT Date in Posting Previews
Automate Country of Origin Listed for Item Tracking Code in Intrastat Reporting
Achieve Sustainable Compliance with Business Central
Discover Report and Data Analysis Content Easily
Use Drag and Drop to Attach Multiple Files
Use Actions to Navigate and Highlight or Fix Platform-Generated Errors
Share Error Details to Get Help from Another User
Access Worksheet Pages from Mobile Phones
Boost Productivity With the Modern Action Bar
Enhancements to the User Experience

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Automate Tests for your Copilot Extensions with the Business Central Test Toolkit

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

The 11th of the new functionality in the Copilot and AI innovation section is automate tests for your Copilot extensions with the Business Central Test Toolkit.

As the partner community brings generative AI capabilities to market and matures their offerings, partners need new engineering tools and practices to help them succeed in the AI era. Data-driven test automation is vital to ensure AI systems are accurate against diverse inputs, preserve the trust and safety of customers and their data, and are resilient to changes in AI model versions. The developer tools for Copilot in Business Central are an end-to-end toolkit covering development, deployment, administration, feedback loops, and now test automation.

Enabled for: Users by admins, makers, or analysts
Public Preview: Jul 2024
General Availability: Dec 2024

Feature Details

With this feature, you can:

  • Author tests for your prompt dialogs using a familiar framework in AL and Visual Studio Code.
  • Organize your test datasets based on purpose and prompt variations.
  • Implement automated verification depending on your feature use case.
  • Run tests as fully automated or semi-automated.

Initially, this feature launches as a PR on the Business Central BCApps repo on GitHub, which allows partners to review and try out the tool with their own Copilot features and provide feedback.

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

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1
Use Virtual Tables to Expose More Business Central Data in Dataverse
Improve Approval Processes via Power Automate
Add Table and Field Mappings for Existing Integration Tables
Find a Matching Record in a Power Automate Flow
Archive Projects
Usability Improves for Service and Projects
Use Deferral Codes in Purchase and Sales Journals
Define a Service Invoice Posting Policy for Various Users
Define Default Location for Project or Project Phase
Block Item, Item Variant or Service Item from Use in Service Management transactions
Connect Business Central With Shopify B2B
Set Up Financial Consolidation Runs More Efficiently
Simpler Shopify Connection
Use General Ledger Account Revaluation for More Accurate Financial Statements
Get More Productive While Entering Time Sheets
Create Projects That You Can Invoice to Multiple Customers
Assemble to Project
Invoice a Customer for Multiple Projects
Use New Excel Layouts for 35 Selected Reports
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Manage Work Orders in Field Service, Invoice Them in Business Central
Manage Document Attachments in Service Items and Documents
Export and Import Multiline Text Using Configuration Packages
Correct Errors in Service Invoices
Prevent Editing Number Series on Service Documents and Cards
Be More Productive When Approving Time Sheets
Inventory Package Numbers Work Like Item Tracking Dimensions
Assign Salesperson to Customer Ship-to Addresses
View Incoming Documents in Archived Quotes and Orders
Specify Dimensions on Posted Entries Applications With Realized Gains or Losses
Allow Lines with Amounts of Zero on Recurring General Journals
Automate the Reminders Process in Collections
See Improved Usability for Warehouse and Inventory
Ensure Accurate Inventory Valuation by Controlling Cost Adjustment
Use a New Role Center for Collection Management
Manage Subscription Billing and Revenue and Expense Recognition
Enable Sustainability Features for Integrations with APIs
Install Field Service Integration with Business Central from AppSource
Introduce Power Automate Copilot Integration with Business Central
Map e-Documents to Purchase Order Lines with Copilot
Create Sales Lines Easily with Copilot
Extend Copilot Using Richer Development Tools
Get to Insights Faster with Copilot-Generated Analysis Tabs
Complete Bank Account Reconciliation Faster With Copilot
Create Product Information Faster with Copilot
Learn More About Fields with Copilot
Chat with Copilot
Simplify collections with Copilot for Finance and Business Central
Automate Tests for your Copilot Extensions with the Business Central Test Toolkit
Automate IRS 1099 Form Submission in US
Enable Additional Countries and Regions
Install UK Localization as an App
Process Czech Bank Statements, Payment Orders More Productively
Improvement of Czech Localization Reports
Report Explorer has Additional Outputs in the Czech Version
Improved Updates of ARES Data in the Czech Version
Allow More Extendability of Advance Payments in the Czech Version
Print QR Codes on Sales Invoices in the Czech Version
Use Excel Layouts for Czech Reports
Handle Multiple File Uploads and File Drop Zones
Debug the System Application
Remove Friction When Working with External App Dependencies
Use In-client Page Scripting Tool for Acceptance Testing
Use AL-controlled Barcode Scanning For All Scenarios
Write flexible and performant code with NumberSequences
Use the OData V4 IN Operator in Web Service Queries
Define Extension Objects in Same App as Their Base Object
Use Cookies in HTTP Calls From Business Central
Define Tooltips on Table Fields
Use Linked Environment in Dataverse Integration
Audit Business Central Operations in Microsoft Purview
Encrypt Data At-Rest with Customer-Managed Encryption Key
Allow Customers to Consent to Microsoft Support Accessing Their Data
Link Business Central Environments to Power Platform Environments
Copy Companies with Dataverse Integration Safely
View and Filter Users With Additional User Details
Control partner access per environment
Analyze Telemetry Events Across Browser and Server for a Session or User
Use Premium License to Sign In to Environment with Essentials Licenses
Experience the New Embedded AppSource Marketplace Page
Migrate Record Links and Notes with Cloud Migration Tooling
See VAT Date in Posting Previews
Automate Country of Origin Listed for Item Tracking Code in Intrastat Reporting
Achieve Sustainable Compliance with Business Central
Discover Report and Data Analysis Content Easily
Use Drag and Drop to Attach Multiple Files
Use Actions to Navigate and Highlight or Fix Platform-Generated Errors
Share Error Details to Get Help from Another User
Access Worksheet Pages from Mobile Phones
Boost Productivity With the Modern Action Bar
Enhancements to the User Experience

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Simplify collections with Copilot for Finance and Business Central

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

The 10th of the new functionality in the Copilot and AI innovation section is Simplify collections with Copilot for Finance and Business Central.

Improve your cash flow and lower the cost of collecting payments for unpaid invoices by empowering your collections team with easy access to relevant and timely data about customers with outstanding payments, without having to do expensive task-switching between applications.

Enabled for: Users by admins, makers, or analysts
Public Preview: Jun 2024
General Availability: Sep 2024

Feature Details

A healthy cash flow is key to business operations, and in a perfect world, all customers pay their invoices on time. When they don’t, the cost compounds in delayed payments combined with the costly effort of collecting payments. This release helps you claim payments faster by increasíng the effectiveness and productivity of your collections team to drive down the cost of collections while improving your cash flow.

Business Central supports native integration with Copilot for Finance. This integration lets you access and work with real-time financial data from Business Central directly within Copilot for Finance in Outlook. The direct access to financial data helps you make informed decisions and act quickly, without wasting time switching between Outlook and Business Central to look up key information about the customer. This integration supports your collections team with relevant and timely information to support constructive dialogs with the customers.

Copilot for Finance provides AI-powered assistance while working in Microsoft 365 applications, eliminating the need to juggle tasks, making financial processes more streamlined and automated.

Key features of the integration

  • Copilot assistance with drafting dunning letter emails and other correspondence with customers who have outstanding balances. This helps your collections team draft personalized emails for every customer.
  • Real-time access in Outlook to customer aging data from Business Central, contextual to the company of the current email, which is key to understanding the customer’s payment patterns.
  • Access in Outlook to unpaid invoices from Business Central, contextual to the company of the current email. It’s easy to attach the invoice to the email draft, and providing the document makes the process more convenient for your customer convenience and can speed up payment.
  • Access in Outlook to contact information from Business Central, related to the company of the current email.
  • Set a Promised to Pay date on a posted invoice in Business Central directly from Outlook. The date adds transparency so that other stakeholders know that payment of the invoice is underway and agreed with the customer.

All of this makes your collections more efficient because people don’t have to switch between Outlook and Business Central while they’re in a dialog with customers over email.

The integration is easy to set up and use, and is designed to help you save time and improve your financial management processes. With Copilot for Finance and Business Central working together, you can free up time for your finance and collections teams.

For more information about the Copilot for Finance integration to Business Central, including regional and language availability, see the Copilot for Finance release plan here.

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

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1
Use Virtual Tables to Expose More Business Central Data in Dataverse
Improve Approval Processes via Power Automate
Add Table and Field Mappings for Existing Integration Tables
Find a Matching Record in a Power Automate Flow
Archive Projects
Usability Improves for Service and Projects
Use Deferral Codes in Purchase and Sales Journals
Define a Service Invoice Posting Policy for Various Users
Define Default Location for Project or Project Phase
Block Item, Item Variant or Service Item from Use in Service Management transactions
Connect Business Central With Shopify B2B
Set Up Financial Consolidation Runs More Efficiently
Simpler Shopify Connection
Use General Ledger Account Revaluation for More Accurate Financial Statements
Get More Productive While Entering Time Sheets
Create Projects That You Can Invoice to Multiple Customers
Assemble to Project
Invoice a Customer for Multiple Projects
Use New Excel Layouts for 35 Selected Reports
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Manage Work Orders in Field Service, Invoice Them in Business Central
Manage Document Attachments in Service Items and Documents
Export and Import Multiline Text Using Configuration Packages
Correct Errors in Service Invoices
Prevent Editing Number Series on Service Documents and Cards
Be More Productive When Approving Time Sheets
Inventory Package Numbers Work Like Item Tracking Dimensions
Assign Salesperson to Customer Ship-to Addresses
View Incoming Documents in Archived Quotes and Orders
Specify Dimensions on Posted Entries Applications With Realized Gains or Losses
Allow Lines with Amounts of Zero on Recurring General Journals
Automate the Reminders Process in Collections
See Improved Usability for Warehouse and Inventory
Ensure Accurate Inventory Valuation by Controlling Cost Adjustment
Use a New Role Center for Collection Management
Manage Subscription Billing and Revenue and Expense Recognition
Enable Sustainability Features for Integrations with APIs
Install Field Service Integration with Business Central from AppSource
Introduce Power Automate Copilot Integration with Business Central
Map e-Documents to Purchase Order Lines with Copilot
Create Sales Lines Easily with Copilot
Extend Copilot Using Richer Development Tools
Get to Insights Faster with Copilot-Generated Analysis Tabs
Complete Bank Account Reconciliation Faster With Copilot
Create Product Information Faster with Copilot
Learn More About Fields with Copilot
Chat with Copilot
Simplify collections with Copilot for Finance and Business Central
Automate Tests for your Copilot Extensions with the Business Central Test Toolkit
Automate IRS 1099 Form Submission in US
Enable Additional Countries and Regions
Install UK Localization as an App
Process Czech Bank Statements, Payment Orders More Productively
Improvement of Czech Localization Reports
Report Explorer has Additional Outputs in the Czech Version
Improved Updates of ARES Data in the Czech Version
Allow More Extendability of Advance Payments in the Czech Version
Print QR Codes on Sales Invoices in the Czech Version
Use Excel Layouts for Czech Reports
Handle Multiple File Uploads and File Drop Zones
Debug the System Application
Remove Friction When Working with External App Dependencies
Use In-client Page Scripting Tool for Acceptance Testing
Use AL-controlled Barcode Scanning For All Scenarios
Write flexible and performant code with NumberSequences
Use the OData V4 IN Operator in Web Service Queries
Define Extension Objects in Same App as Their Base Object
Use Cookies in HTTP Calls From Business Central
Define Tooltips on Table Fields
Use Linked Environment in Dataverse Integration
Audit Business Central Operations in Microsoft Purview
Encrypt Data At-Rest with Customer-Managed Encryption Key
Allow Customers to Consent to Microsoft Support Accessing Their Data
Link Business Central Environments to Power Platform Environments
Copy Companies with Dataverse Integration Safely
View and Filter Users With Additional User Details
Control partner access per environment
Analyze Telemetry Events Across Browser and Server for a Session or User
Use Premium License to Sign In to Environment with Essentials Licenses
Experience the New Embedded AppSource Marketplace Page
Migrate Record Links and Notes with Cloud Migration Tooling
See VAT Date in Posting Previews
Automate Country of Origin Listed for Item Tracking Code in Intrastat Reporting
Achieve Sustainable Compliance with Business Central
Discover Report and Data Analysis Content Easily
Use Drag and Drop to Attach Multiple Files
Use Actions to Navigate and Highlight or Fix Platform-Generated Errors
Share Error Details to Get Help from Another User
Access Worksheet Pages from Mobile Phones
Boost Productivity With the Modern Action Bar
Enhancements to the User Experience

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Install Field Service Integration with Business Central from AppSource

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

The 35th of the new functionality in the Application section is install Field Service Integration with Business Central from AppSource.

The Field Service Integration application published on AppSource is designed to improve the integration experience, reduce the complexity of the setup, and prepare for future scalability and flexibility. It also aims to minimize disruption for existing users while paving the way for broader adoption.

Enabled for: Users by admins, makers, or analysts
Public Preview: –
General Availability: Jul 2024

Feature Details

To avoid disrupting existing integrations to Sales for customers who aren’t using Field Service integration, you can now install and enable Field Service Integration as an application from AppSource. Although it introduces additional steps for setting up Field Service integration, the process is documented and the Set up integration to Dynamics 365 Sales assisted setup guide, which is currently a prerequisite part for integrating with Field Service, now contains an optional step to install the Field Service Integration application from AppSource.

Screenshot shows new optional step for installing Field Service Integration app in Sales setup guide

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Install Field Service Integration with Business Central from AppSource”

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Enable Sustainability Features for Integrations with APIs

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

The 34th of the new functionality in the Application section is enable sustainability features for integrations with APIs.

You can use sustainability features in Business Central with third-party software. For example, you might use data about your greenhouse gas emissions in Business Central to enrich data in another application.

Enabled for: Users, automatically
Public Preview:  Jun 1, 2024
General Availability: Jul 2024

Feature Details

Sustainability pages will have APIs enabled, so in the future you can use Business Central data with other applications—for example, so that you can use sustainability features for collaboration with Power Automate or Power Apps, or for reporting in Power BI.

APIs will be enabled for the following pages:

  • Sustainability Account
  • Sust. Account Category
  • Sust. Account Subcategory
  • Sustainability Journal Line
  • Sustainability Entry

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

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1
Use Virtual Tables to Expose More Business Central Data in Dataverse
Improve Approval Processes via Power Automate
Add Table and Field Mappings for Existing Integration Tables
Find a Matching Record in a Power Automate Flow
Archive Projects
Usability Improves for Service and Projects
Use Deferral Codes in Purchase and Sales Journals
Define a Service Invoice Posting Policy for Various Users
Define Default Location for Project or Project Phase
Block Item, Item Variant or Service Item from Use in Service Management transactions
Connect Business Central With Shopify B2B
Set Up Financial Consolidation Runs More Efficiently
Simpler Shopify Connection
Use General Ledger Account Revaluation for More Accurate Financial Statements
Get More Productive While Entering Time Sheets
Create Projects That You Can Invoice to Multiple Customers
Assemble to Project
Invoice a Customer for Multiple Projects
Use New Excel Layouts for 35 Selected Reports
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Manage Work Orders in Field Service, Invoice Them in Business Central
Manage Document Attachments in Service Items and Documents
Export and Import Multiline Text Using Configuration Packages
Correct Errors in Service Invoices
Prevent Editing Number Series on Service Documents and Cards
Be More Productive When Approving Time Sheets
Inventory Package Numbers Work Like Item Tracking Dimensions
Assign Salesperson to Customer Ship-to Addresses
View Incoming Documents in Archived Quotes and Orders
Specify Dimensions on Posted Entries Applications With Realized Gains or Losses
Allow Lines with Amounts of Zero on Recurring General Journals
Automate the Reminders Process in Collections
See Improved Usability for Warehouse and Inventory
Ensure Accurate Inventory Valuation by Controlling Cost Adjustment
Use a New Role Center for Collection Management
Manage Subscription Billing and Revenue and Expense Recognition
Enable Sustainability Features for Integrations with APIs
Install Field Service Integration with Business Central from AppSource
Introduce Power Automate Copilot Integration with Business Central
Map e-Documents to Purchase Order Lines with Copilot
Create Sales Lines Easily with Copilot
Extend Copilot Using Richer Development Tools
Get to Insights Faster with Copilot-Generated Analysis Tabs
Complete Bank Account Reconciliation Faster With Copilot
Create Product Information Faster with Copilot
Learn More About Fields with Copilot
Chat with Copilot
Simplify collections with Copilot for Finance and Business Central
Automate Tests for your Copilot Extensions with the Business Central Test Toolkit
Automate IRS 1099 Form Submission in US
Enable Additional Countries and Regions
Install UK Localization as an App
Process Czech Bank Statements, Payment Orders More Productively
Improvement of Czech Localization Reports
Report Explorer has Additional Outputs in the Czech Version
Improved Updates of ARES Data in the Czech Version
Allow More Extendability of Advance Payments in the Czech Version
Print QR Codes on Sales Invoices in the Czech Version
Use Excel Layouts for Czech Reports
Handle Multiple File Uploads and File Drop Zones
Debug the System Application
Remove Friction When Working with External App Dependencies
Use In-client Page Scripting Tool for Acceptance Testing
Use AL-controlled Barcode Scanning For All Scenarios
Write flexible and performant code with NumberSequences
Use the OData V4 IN Operator in Web Service Queries
Define Extension Objects in Same App as Their Base Object
Use Cookies in HTTP Calls From Business Central
Define Tooltips on Table Fields
Use Linked Environment in Dataverse Integration
Audit Business Central Operations in Microsoft Purview
Encrypt Data At-Rest with Customer-Managed Encryption Key
Allow Customers to Consent to Microsoft Support Accessing Their Data
Link Business Central Environments to Power Platform Environments
Copy Companies with Dataverse Integration Safely
View and Filter Users With Additional User Details
Control partner access per environment
Analyze Telemetry Events Across Browser and Server for a Session or User
Use Premium License to Sign In to Environment with Essentials Licenses
Experience the New Embedded AppSource Marketplace Page
Migrate Record Links and Notes with Cloud Migration Tooling
See VAT Date in Posting Previews
Automate Country of Origin Listed for Item Tracking Code in Intrastat Reporting
Achieve Sustainable Compliance with Business Central
Discover Report and Data Analysis Content Easily
Use Drag and Drop to Attach Multiple Files
Use Actions to Navigate and Highlight or Fix Platform-Generated Errors
Share Error Details to Get Help from Another User
Access Worksheet Pages from Mobile Phones
Boost Productivity With the Modern Action Bar
Enhancements to the User Experience

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: 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 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 1.

The 33rd 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.

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

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1
Use Virtual Tables to Expose More Business Central Data in Dataverse
Improve Approval Processes via Power Automate
Add Table and Field Mappings for Existing Integration Tables
Find a Matching Record in a Power Automate Flow
Archive Projects
Usability Improves for Service and Projects
Use Deferral Codes in Purchase and Sales Journals
Define a Service Invoice Posting Policy for Various Users
Define Default Location for Project or Project Phase
Block Item, Item Variant or Service Item from Use in Service Management transactions
Connect Business Central With Shopify B2B
Set Up Financial Consolidation Runs More Efficiently
Simpler Shopify Connection
Use General Ledger Account Revaluation for More Accurate Financial Statements
Get More Productive While Entering Time Sheets
Create Projects That You Can Invoice to Multiple Customers
Assemble to Project
Invoice a Customer for Multiple Projects
Use New Excel Layouts for 35 Selected Reports
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Manage Work Orders in Field Service, Invoice Them in Business Central
Manage Document Attachments in Service Items and Documents
Export and Import Multiline Text Using Configuration Packages
Correct Errors in Service Invoices
Prevent Editing Number Series on Service Documents and Cards
Be More Productive When Approving Time Sheets
Inventory Package Numbers Work Like Item Tracking Dimensions
Assign Salesperson to Customer Ship-to Addresses
View Incoming Documents in Archived Quotes and Orders
Specify Dimensions on Posted Entries Applications With Realized Gains or Losses
Allow Lines with Amounts of Zero on Recurring General Journals
Automate the Reminders Process in Collections
See Improved Usability for Warehouse and Inventory
Ensure Accurate Inventory Valuation by Controlling Cost Adjustment
Use a New Role Center for Collection Management
Manage Subscription Billing and Revenue and Expense Recognition
Enable Sustainability Features for Integrations with APIs
Install Field Service Integration with Business Central from AppSource
Introduce Power Automate Copilot Integration with Business Central
Map e-Documents to Purchase Order Lines with Copilot
Create Sales Lines Easily with Copilot
Extend Copilot Using Richer Development Tools
Get to Insights Faster with Copilot-Generated Analysis Tabs
Complete Bank Account Reconciliation Faster With Copilot
Create Product Information Faster with Copilot
Learn More About Fields with Copilot
Chat with Copilot
Simplify collections with Copilot for Finance and Business Central
Automate Tests for your Copilot Extensions with the Business Central Test Toolkit
Automate IRS 1099 Form Submission in US
Enable Additional Countries and Regions
Install UK Localization as an App
Process Czech Bank Statements, Payment Orders More Productively
Improvement of Czech Localization Reports
Report Explorer has Additional Outputs in the Czech Version
Improved Updates of ARES Data in the Czech Version
Allow More Extendability of Advance Payments in the Czech Version
Print QR Codes on Sales Invoices in the Czech Version
Use Excel Layouts for Czech Reports
Handle Multiple File Uploads and File Drop Zones
Debug the System Application
Remove Friction When Working with External App Dependencies
Use In-client Page Scripting Tool for Acceptance Testing
Use AL-controlled Barcode Scanning For All Scenarios
Write flexible and performant code with NumberSequences
Use the OData V4 IN Operator in Web Service Queries
Define Extension Objects in Same App as Their Base Object
Use Cookies in HTTP Calls From Business Central
Define Tooltips on Table Fields
Use Linked Environment in Dataverse Integration
Audit Business Central Operations in Microsoft Purview
Encrypt Data At-Rest with Customer-Managed Encryption Key
Allow Customers to Consent to Microsoft Support Accessing Their Data
Link Business Central Environments to Power Platform Environments
Copy Companies with Dataverse Integration Safely
View and Filter Users With Additional User Details
Control partner access per environment
Analyze Telemetry Events Across Browser and Server for a Session or User
Use Premium License to Sign In to Environment with Essentials Licenses
Experience the New Embedded AppSource Marketplace Page
Migrate Record Links and Notes with Cloud Migration Tooling
See VAT Date in Posting Previews
Automate Country of Origin Listed for Item Tracking Code in Intrastat Reporting
Achieve Sustainable Compliance with Business Central
Discover Report and Data Analysis Content Easily
Use Drag and Drop to Attach Multiple Files
Use Actions to Navigate and Highlight or Fix Platform-Generated Errors
Share Error Details to Get Help from Another User
Access Worksheet Pages from Mobile Phones
Boost Productivity With the Modern Action Bar
Enhancements to the User Experience

New Functionality In Microsoft Power Automate 2024 Wave 1: Scale Faster with Power Automate Process Mining Thin Client App

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

The 2nd of the new functionality in the section is scale faster with Power Automate Process Mining thin client app.

The current Power Automate Process Mining desktop app requires that you download the process model to the client computer in order to work with it. This download puts specific requirements on the hardware resources on the client computer. To unblock your resources, you can use the Azure Process Intelligence Analytic Service instead. With this service, you can use a lightweight desktop app with a process intelligence engine without the need to download the process model. The functionality of the thin desktop application offers features that are identical to the previous full desktop app. This allows you to scale faster, it supports larger process models, and doesn’t put specific requirements on your client computers.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: Sep 2024
Early Access: –
General Availability: Nov 2024

Feature Details

Process Intelligence Analytic Service offers analytical functions in the form of an Azure API. When the desktop application connects to Process Intelligence Analytic Service, you have access to the identical functionality as in the full Power Automate Process Mining desktop app.

With Power Automate Process Mining thin client app, there’s no need to:

  • Download the process model, which takes up your resources.
  • Fulfill special hardware requirements when working with large process models.
  • Install desktop application updates in case of analytical operation modifications.

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

New Functionality In Microsoft Power Automate 2024 Wave 1
Use Generative AI to Achieve a Process in AI Flows
Receive Intelligent License Recommendations for Admins
Be More Productive with Power Automate and Excel Desktop
View a Power Automate Visual in a Power BI Report
Monitor Performance for Cloud and Desktop Flow Activities
Connect to Other Environments from the Microsoft Dataverse Connector
Push Cloud Flow Execution Data into Application Insights
Use Your Own Encryption Key for Encrypting Data At-Rest for Existing Environments
Create Power Automate Flows in Excel
View Two Action Properties Panes Simultaneously
Use Undo and Redo While You Build Cloud Flows in the Designer
Use Copy-Paste for Container Actions Like Scope, Condition, and Apply to Each
Use a Simplified OData Editor in Actions like Get Items and Get Files
Manage Unpublished Solution-Aware Cloud Flows Using Admin APIs
Cancel all Flow Runs for a Version of a Flow
Create a Flow on a File in Teams
Cloud Flows are Automatically Defined in Dataverse Solutions
Use Workflows on Calendar Events in Teams and Outlook
Create AI Flows in Power Automate
Use Copilot with French Language
Recommendations to Reassign Orphaned Cloud Flows
Generate Descriptions for Cloud Flows using AI
Use Flows with Connections from Users in Copilot Studio
Use Process Mining Microsoft 365 Personal Recommendations
Create and Edit Expressions with Copilot
Get Quick Insights and Recommendations in Copilot for Process Mining
Troubleshoot with Copilot for Cloud Flows Execution
Automate With Ease Using the AI Recorder
Enter into a Conversation-first Copilot Experience to Build Flows
Transform Scripting Using AI-driven Natural Language
Maximize Your Productivity with Generative Answers
Streamline Workflow Creation with the Next Best Action
Generate Flow Description Using AI
Use Natural Language to Create a Flow in Teams
Leverage Desktop Automation with the Power Automate Plugin for Windows Copilot
Set Up Fallback UI Automation Mechanism
Power Fx Integration with Power Automate for Desktop
Use Power Platform Connectors in Power Automate for Desktop Actions
Use CyberArk Credentials in Desktop Flow Connections
Use Azure Key Vault Credentials in Flow Connections
Connect Your Own Virtual Network with Hosted Machine Group
View Attended Desktop Flow Runs Using Picture-in-Picture Execution Mode
Self-heal UI and Browser Automation Actions at Execution with AI
Use the Run Power Fx Expression
Use Python v3 in Power Automate for Desktop
Use Machine to Credential Mapping in Desktop Flow Connections
Create a Reusable Collection of UI Elements
Use Customer-managed Encryption Key for Hosted RPA
Automation Center to Monitor and Manage All Your Automations and Related Assets
Trigger Attended Desktop Flows in Picture-in-Picture
Use Copilot in Automation Center to Analyze Cloud Flow Runs
Trigger Attended Desktop Flows in Picture-in-Picture Mode Through the Power Automate Console
Use Copilot in Automation Center to Analyze Desktop Flow Runs
Use Copilot in Automation Center to Analyze Work Queue Data
Use Copilot in Automation Center to Ask Power Automate Product Questions
Use New Data Table Actions
Use New Excel Actions in Power Automate for Desktop
Use the New Desktop Flow Running Timeout Property
Ingest Process Data from Customers' Data Lake
Scale Faster with Power Automate Process Mining Thin Client App

New Functionality In Microsoft Power Automate 2024 Wave 1: Use the New Desktop Flow Running Timeout Property

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

The 25th of the new functionality in the Desktop Flows section is Use the new desktop flow running timeout property.

This feature allows makers to set a maximum runtime for desktop flows. If this duration is exceeded, the flow will automatically time out and halt, ensuring that flows don’t run indefinitely or become unresponsive due to unforeseen conditions in the target application or potential infinite loops in the flow logic.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: –
Early Access: –
General Availability: Jun 2024

Feature Details

This setting is off by default but can be activated through a toggle in the Power Automate for desktop console. Once enabled, makers can define the maximum duration for the flow, using a format of hours, minutes, and seconds.

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

New Functionality In Microsoft Power Automate 2024 Wave 1
Use Generative AI to Achieve a Process in AI Flows
Receive Intelligent License Recommendations for Admins
Be More Productive with Power Automate and Excel Desktop
View a Power Automate Visual in a Power BI Report
Monitor Performance for Cloud and Desktop Flow Activities
Connect to Other Environments from the Microsoft Dataverse Connector
Push Cloud Flow Execution Data into Application Insights
Use Your Own Encryption Key for Encrypting Data At-Rest for Existing Environments
Create Power Automate Flows in Excel
View Two Action Properties Panes Simultaneously
Use Undo and Redo While You Build Cloud Flows in the Designer
Use Copy-Paste for Container Actions Like Scope, Condition, and Apply to Each
Use a Simplified OData Editor in Actions like Get Items and Get Files
Manage Unpublished Solution-Aware Cloud Flows Using Admin APIs
Cancel all Flow Runs for a Version of a Flow
Create a Flow on a File in Teams
Cloud Flows are Automatically Defined in Dataverse Solutions
Use Workflows on Calendar Events in Teams and Outlook
Create AI Flows in Power Automate
Use Copilot with French Language
Recommendations to Reassign Orphaned Cloud Flows
Generate Descriptions for Cloud Flows using AI
Use Flows with Connections from Users in Copilot Studio
Use Process Mining Microsoft 365 Personal Recommendations
Create and Edit Expressions with Copilot
Get Quick Insights and Recommendations in Copilot for Process Mining
Troubleshoot with Copilot for Cloud Flows Execution
Automate With Ease Using the AI Recorder
Enter into a Conversation-first Copilot Experience to Build Flows
Transform Scripting Using AI-driven Natural Language
Maximize Your Productivity with Generative Answers
Streamline Workflow Creation with the Next Best Action
Generate Flow Description Using AI
Use Natural Language to Create a Flow in Teams
Leverage Desktop Automation with the Power Automate Plugin for Windows Copilot
Set Up Fallback UI Automation Mechanism
Power Fx Integration with Power Automate for Desktop
Use Power Platform Connectors in Power Automate for Desktop Actions
Use CyberArk Credentials in Desktop Flow Connections
Use Azure Key Vault Credentials in Flow Connections
Connect Your Own Virtual Network with Hosted Machine Group
View Attended Desktop Flow Runs Using Picture-in-Picture Execution Mode
Self-heal UI and Browser Automation Actions at Execution with AI
Use the Run Power Fx Expression
Use Python v3 in Power Automate for Desktop
Use Machine to Credential Mapping in Desktop Flow Connections
Create a Reusable Collection of UI Elements
Use Customer-managed Encryption Key for Hosted RPA
Automation Center to Monitor and Manage All Your Automations and Related Assets
Trigger Attended Desktop Flows in Picture-in-Picture
Use Copilot in Automation Center to Analyze Cloud Flow Runs
Trigger Attended Desktop Flows in Picture-in-Picture Mode Through the Power Automate Console
Use Copilot in Automation Center to Analyze Desktop Flow Runs
Use Copilot in Automation Center to Analyze Work Queue Data
Use Copilot in Automation Center to Ask Power Automate Product Questions
Use New Data Table Actions
Use New Excel Actions in Power Automate for Desktop
Use the New Desktop Flow Running Timeout Property
Ingest Process Data from Customers' Data Lake
Scale Faster with Power Automate Process Mining Thin Client App

New Functionality In Microsoft Power Automate 2024 Wave 1: Use New Excel Actions in Power Automate for Desktop

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

The 24th of the new functionality in the Desktop Flows section is use new Excel actions in Power Automate for desktop.

This group of newly introduced actions simplify the authoring process and enables makers to construct Excel flows more intuitively, preventing the need for complex logic.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: –
Early Access: –
General Availability: Jul 2024

Feature Details

The actions pane now includes the following dedicated Excel actions:

  • Get table range
  • Set range color
  • Copy worksheet
  • Append range
  • Look up range
  • Read cell formula
  • Auto fill range

These actions provide new capabilities previously unavailable, empowering makers to enhance their desktop flows involving Excel, one of the most common categories for automation.

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

New Functionality In Microsoft Power Automate 2024 Wave 1
Use Generative AI to Achieve a Process in AI Flows
Receive Intelligent License Recommendations for Admins
Be More Productive with Power Automate and Excel Desktop
View a Power Automate Visual in a Power BI Report
Monitor Performance for Cloud and Desktop Flow Activities
Connect to Other Environments from the Microsoft Dataverse Connector
Push Cloud Flow Execution Data into Application Insights
Use Your Own Encryption Key for Encrypting Data At-Rest for Existing Environments
Create Power Automate Flows in Excel
View Two Action Properties Panes Simultaneously
Use Undo and Redo While You Build Cloud Flows in the Designer
Use Copy-Paste for Container Actions Like Scope, Condition, and Apply to Each
Use a Simplified OData Editor in Actions like Get Items and Get Files
Manage Unpublished Solution-Aware Cloud Flows Using Admin APIs
Cancel all Flow Runs for a Version of a Flow
Create a Flow on a File in Teams
Cloud Flows are Automatically Defined in Dataverse Solutions
Use Workflows on Calendar Events in Teams and Outlook
Create AI Flows in Power Automate
Use Copilot with French Language
Recommendations to Reassign Orphaned Cloud Flows
Generate Descriptions for Cloud Flows using AI
Use Flows with Connections from Users in Copilot Studio
Use Process Mining Microsoft 365 Personal Recommendations
Create and Edit Expressions with Copilot
Get Quick Insights and Recommendations in Copilot for Process Mining
Troubleshoot with Copilot for Cloud Flows Execution
Automate With Ease Using the AI Recorder
Enter into a Conversation-first Copilot Experience to Build Flows
Transform Scripting Using AI-driven Natural Language
Maximize Your Productivity with Generative Answers
Streamline Workflow Creation with the Next Best Action
Generate Flow Description Using AI
Use Natural Language to Create a Flow in Teams
Leverage Desktop Automation with the Power Automate Plugin for Windows Copilot
Set Up Fallback UI Automation Mechanism
Power Fx Integration with Power Automate for Desktop
Use Power Platform Connectors in Power Automate for Desktop Actions
Use CyberArk Credentials in Desktop Flow Connections
Use Azure Key Vault Credentials in Flow Connections
Connect Your Own Virtual Network with Hosted Machine Group
View Attended Desktop Flow Runs Using Picture-in-Picture Execution Mode
Self-heal UI and Browser Automation Actions at Execution with AI
Use the Run Power Fx Expression
Use Python v3 in Power Automate for Desktop
Use Machine to Credential Mapping in Desktop Flow Connections
Create a Reusable Collection of UI Elements
Use Customer-managed Encryption Key for Hosted RPA
Automation Center to Monitor and Manage All Your Automations and Related Assets
Trigger Attended Desktop Flows in Picture-in-Picture
Use Copilot in Automation Center to Analyze Cloud Flow Runs
Trigger Attended Desktop Flows in Picture-in-Picture Mode Through the Power Automate Console
Use Copilot in Automation Center to Analyze Desktop Flow Runs
Use Copilot in Automation Center to Analyze Work Queue Data
Use Copilot in Automation Center to Ask Power Automate Product Questions
Use New Data Table Actions
Use New Excel Actions in Power Automate for Desktop
Use the New Desktop Flow Running Timeout Property
Ingest Process Data from Customers' Data Lake
Scale Faster with Power Automate Process Mining Thin Client App