New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Business Central Virtual Tables Fully Supported on Microsoft Dataverse

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

The eleventh of the new functionality in the Adapt faster with Power Platform section is Business Central virtual tables fully supported on Microsoft Dataverse.

Business Central virtual tables allow for inbound interactions from apps, flows, and pages running on Microsoft Dataverse to perform create, read, update, and delete (CRUD) operations on Business Central physical tables without the need to replicate data into Dataverse.

Enabled for: Users by admins, makers, or analysts
Public Preview: –
General Availability: Nov 2023

Feature Details

With Business Central virtual tables, your apps, flows, and pages built using Power Apps, Power Automate, and Power Pages on Power Platform can easily interact with Business Central physical tables. Synthetic relations can be created between native Dataverse tables and Business Central virtual tables, allowing related data to be presented together on Power Apps and Power Pages.

Additionally, changes made to Business Central physical tables can trigger outbound interactions from Business Central into Dataverse by emitting create, update, and delete (CUD) events that start Power Automate flows with the When a row is added, modified, or deleted trigger set to the corresponding Business Central virtual tables.

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Business Central Virtual Tables Fully Supported on Microsoft Dataverse”

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Create Power Automate Flows that Dynamically Support Different Companies

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

The tenth of the new functionality in the Adapt faster with Power Platform section is Create Power Automate flows that dynamically support different companies.

Building Power Automate flows that are easily portable and work with multiple companies helps partners and consultants use Power Platform when adapting Business Central to the needs of small and medium-sized businesses.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: Sep 2023
General Availability: Oct 2023

Feature Details

This feature provides the following capabilities to Power Automate makers as they create or edit flows:

  • Access to a list of API categories and APIs/tables in all actions—without even specifying a company.
  • Edit the corresponding flow steps with all metadata details even though no company was provided.
  • Use of Dataverse environment variables for environments and companies.
  • Support for application lifecycle management (ALM) with Dataverse environment variables in AL-Go for GitHub.
  • Use a standard variable for company ID and make flows that can run in the context of different companies.
  • Use the output of the new List Companies action to perform actions or read data across companies.
Business Central connector supporting dynamic values for companies

My Opinion

I need to do some exploring of the new features outlined above, but on the surface they sound like they will be very useful.

The first item, access to the list of API categories and tables without selecting a company will resolve an irritation, where at present you have to explicitly select the environment and company to see the lists. This is annoying for a flow which could be run against any company, meaning you need to pick the environment and company to select from the API and then remove them and set back to the variables. This change means this won’t need to be done.

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2
Change Modification Limits for Triggering Flows and Bulk Updates
Support Business Events in Business Central Connector for Power Automate
Enable Specific Virtual Tables When You Connect to Dataverse
Get Control Over How to View Power BI Embedded Content
Availability Overview Helps You Calculate Quantities in Your Warehouse
Configure The Right Level of Handling For Different Warehouse Operations
Do financial Consolidations Across Environments in Multicompany Setups
Edit in Excel on Item Journals and Warehouse Worksheets
Get More Productive While Approving Time Sheets
Get More Productive While Entering Time Sheets
Include Approvals for Intercompany General Journals in Your Workflows
Make Intercompany Transactions Across Business Central Environments
Suggest the Next Step For Sales and Production Orders
Sync Document and Posting Dates for Sales and Purchases
Troubleshoot Shopify Integration Issues
Usability Improves for Warehouse, Inventory, and Tracking
Use Directed Pick and Put-away Suggestions in Basic Warehouse Configurations
Use General Ledger Allocations to Distribute Costs and Revenue More Efficiently
Complete Bank Account Reconciliation Faster With Copilot
Get Marketing Text Suggestions with Copilot
New Design for Report Language and Region Settings
Advance Payment and a Posting Preview of Tax Documents – Czechia
Direct Transfer – Czechia
E-submission of VAT Return in Denmark
Iceland Localization App – Delocalization
Intercompany Posting Cues to the Accountant Role Center – Czechia
New Intrastat – Czechia
Registration and Notification Functionality for Denmark
E-invoicing with NemHandel in Denmark
Supporting More Countries and Regions
Open Visual Studio Code From Web Client to Investigate or Troubleshoot Extensions
Turn Off Data Analysis Mode on Pages and Queries
Turn Off Indexes as a Partner
Use the Built-in Rich Text Editor to Enter Data
Assign More Granular Administration Rights
Improved Update Release Processes
Cancel Cloud Migration Replication Runs
Digital Vouchers
E-documents Core as a Global Solution
Large Companies to Report Payment Times
Modify Texts on the Welcome Banner and Skip Banner Intro State
Set Initial Role Before First Sign-in for a Better First-Run Experience
Enhancements to Excel Add-in
Analyze, Group, and Pivot Data on Queries Using Multiple Tabs
Discover Report and Data Analysis Content Easily
Get Power BI Reports for Reporting and Data Analysis on Finance, Sales, and Inventory
Data Loads Faster in the Server
Faster Application Scenarios
Pages Load Faster in Client
Performance Gain Reducing Locks in the Database
Add Existing Table Fields to Optimize Your Pages
Get to Data Search From Anywhere in Business Central
Distinguish Browser Tabs When Multitasking
Share Readable Deep Links to Pages and Records
Manage User Expectations with Selection Context-Based Actions
Peek at Summarized Data From Editable Fields
Search for Pages and Data in the Mobile App
Use Actions to Navigate or Fix Errors From Inline Validation Dialog
Updates to the Release Plan
Power Pages Support via Business Central Virtual Tables on Dataverse
Synchronize More Fields in Your Integration with Dataverse and Dynamics 365 Sales
Consolidated Power Automate Flow Creation from Business Central Templates
Get List of Companies Using Business Central Connector in Power Automate
Simplified Power Automate Approval Flow Experience
Create Power Automate Flows that Dynamically Support Different Companies
Business Central Virtual Tables Fully Supported on Microsoft Dataverse
Relate Native and Virtual Tables to Expose More Business Central Data in Dataverse
Include Only Open Entries on Customer Statements
Adjust Exchange Rates Easily, Replace the Built-in Batch Job
More Control Over General Journal Approvals
Use Different General Ledger Accounts for Payables, Receivables
Add More Columns to Pages for Better Insight
Availability Overview Helps You Calculate Quantities in Your Warehouse
Block Item Variants
Identify and Track Items Easier with Item References
Improved Processes for Inventory Counts and Adjustments
Navigate Easier Between Order, Receipt, and Invoice Documents
Print and Scan Barcodes
Receive More Items Than Ordered by Using Inventory Put-away Documents
Generate a Customer Statement Only With Open Entries
Responsibility Centers Are Supported for Advance Payments in Czechia
Easier Management of System Application Permissions
Get the AL Language Extension in Prerelease Versions on Visual Studio Code Marketplace
Find All References Now Works on Triggers, System Methods, and Trigger Events
Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
Hover Over Label Variable to See Text String Value
Set New Output Folder Setting for Storing App Files at AL Project Build
Choose Between More Sampling Intervals for Snapshot and In-client Profiling
Get IntelliSense for Adding Variables in Visual Studio Code AL Debugger Console
Get Smarter Method Signature Recommendations in IntelliSense
Set the Default Folder Location for New AL Projects
Track Source and Build Metadata on Extensions
Use SecretText Type to Protect Credentials and Sensitive Textual Values From Being Revealed
Document Your Extensions With the ALDoc Tool for Partners
Segment AL Code and Reduce Naming Conflicts with Namespaces
Show List of Keys While Working on AL Code
Use the AL Language Extension for Linux in Preview
Provide Queries for Users to do Ad Hoc Data Analysis Across Tables
Add a New FieldGroup to an Existing Table
Add Teaching Tooltips on Queries and Report Request Pages
Get Syntax Highlighting for AL in Azure DevOps
Sell Business Central Apps Through AppSource
AppSource ISV Publishers Can Preview Their AppSource Apps With Select Customers
Extend General Ledger Posting Aggregations
Define multi-worksheet datasets for Excel reports
Include or Exclude Tables From Cloud Migration
Delete Data from Uninstalled Extensions as an Admin
Automatically Update AppSource Apps With Minor Updates
Transfer Environments Between Microsoft Entra Tenants
Control Partner Access Per Environment
Use Drop Shipments for Triangular Intrastat Trade
Start Faster with Refreshed and Enhanced Setup Data
VAT Posting in General Ledger Setup
Demo Tool and Data for Service Scenarios
Analyze, Group, and Pivot Data on Lists
Share a Data Analysis With a Co-worker
Synchronize Multiple Business Central Companies With the Same Dataverse Environment
New Operational Limits on Scheduled Tasks and Web Requests Improve Throughput
Service-to-Service Apps and Device License Users Can Schedule Tasks
Mark Fields as Read-only When Customizing UI
Scan barcodes with Business Central mobile app for iOS and Android
Access Worksheet Pages From Mobile Phones
Use Virtual Tables to Expose More Business Central Data in Dataverse
Reverse a Customer and Vendor Ledger Entry with a Realized Gain or Loss Entry
Use General Ledger Account Revaluation for More Accurate Financial Statements
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Chat with Copilot
Improved Data Upgrade Troubleshooting for Dynamics GP Migration
Retain Permissions When Enabling Cloud Migration
Detect Invalid Cloud Migration Configurations with Proactive Warnings
Multiple VAT Numbers per Customer

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Simplified Power Automate Approval Flow Experience

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

The ninth of the new functionality in the Adapt faster with Power Platform section is Simplified Power Automate approval flow experience.

Approving documents or data changes in a modern company must be straightforward. Microsoft listen to feedback and continue to improve this area, making sure this experience matches business users’ expectations.

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

Feature Details

In the previous release, Microsoft have introduced several new templates and a simplified approval experience based on Power Automate. With this wave, Microsoft have improved this area by introducing several new changes:

  • Microsoft automatically set the environment and company in approval templates so that the user doesn’t need to choose those every time.
  • Microsoft have added the requestor to the request for approval and confirmation emails, making it clear who requested and who approved the change.
  • The Approval step in Microsoft’s templates now includes “Requested by” to indicate the proper requestor.
  • Correctly handle the “cancel approval request” decision on the Power Automate side.
  • An optional adaptive card can be posted to a chosen Teams channel (or user) with information that a given document was approved.

My Opinion

These changes all look to be very useful ones. I’ve been doing work with some clients recently on approval workflows from Business Central and these changes will be useful as we move forward into the build phase for the project.

The fourth item in the list looks particularly important to make sure that data isn’t corrupted, while the second and third expose additional information to the approval requests.

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2
Change Modification Limits for Triggering Flows and Bulk Updates
Support Business Events in Business Central Connector for Power Automate
Enable Specific Virtual Tables When You Connect to Dataverse
Get Control Over How to View Power BI Embedded Content
Availability Overview Helps You Calculate Quantities in Your Warehouse
Configure The Right Level of Handling For Different Warehouse Operations
Do financial Consolidations Across Environments in Multicompany Setups
Edit in Excel on Item Journals and Warehouse Worksheets
Get More Productive While Approving Time Sheets
Get More Productive While Entering Time Sheets
Include Approvals for Intercompany General Journals in Your Workflows
Make Intercompany Transactions Across Business Central Environments
Suggest the Next Step For Sales and Production Orders
Sync Document and Posting Dates for Sales and Purchases
Troubleshoot Shopify Integration Issues
Usability Improves for Warehouse, Inventory, and Tracking
Use Directed Pick and Put-away Suggestions in Basic Warehouse Configurations
Use General Ledger Allocations to Distribute Costs and Revenue More Efficiently
Complete Bank Account Reconciliation Faster With Copilot
Get Marketing Text Suggestions with Copilot
New Design for Report Language and Region Settings
Advance Payment and a Posting Preview of Tax Documents – Czechia
Direct Transfer – Czechia
E-submission of VAT Return in Denmark
Iceland Localization App – Delocalization
Intercompany Posting Cues to the Accountant Role Center – Czechia
New Intrastat – Czechia
Registration and Notification Functionality for Denmark
E-invoicing with NemHandel in Denmark
Supporting More Countries and Regions
Open Visual Studio Code From Web Client to Investigate or Troubleshoot Extensions
Turn Off Data Analysis Mode on Pages and Queries
Turn Off Indexes as a Partner
Use the Built-in Rich Text Editor to Enter Data
Assign More Granular Administration Rights
Improved Update Release Processes
Cancel Cloud Migration Replication Runs
Digital Vouchers
E-documents Core as a Global Solution
Large Companies to Report Payment Times
Modify Texts on the Welcome Banner and Skip Banner Intro State
Set Initial Role Before First Sign-in for a Better First-Run Experience
Enhancements to Excel Add-in
Analyze, Group, and Pivot Data on Queries Using Multiple Tabs
Discover Report and Data Analysis Content Easily
Get Power BI Reports for Reporting and Data Analysis on Finance, Sales, and Inventory
Data Loads Faster in the Server
Faster Application Scenarios
Pages Load Faster in Client
Performance Gain Reducing Locks in the Database
Add Existing Table Fields to Optimize Your Pages
Get to Data Search From Anywhere in Business Central
Distinguish Browser Tabs When Multitasking
Share Readable Deep Links to Pages and Records
Manage User Expectations with Selection Context-Based Actions
Peek at Summarized Data From Editable Fields
Search for Pages and Data in the Mobile App
Use Actions to Navigate or Fix Errors From Inline Validation Dialog
Updates to the Release Plan
Power Pages Support via Business Central Virtual Tables on Dataverse
Synchronize More Fields in Your Integration with Dataverse and Dynamics 365 Sales
Consolidated Power Automate Flow Creation from Business Central Templates
Get List of Companies Using Business Central Connector in Power Automate
Simplified Power Automate Approval Flow Experience
Create Power Automate Flows that Dynamically Support Different Companies
Business Central Virtual Tables Fully Supported on Microsoft Dataverse
Relate Native and Virtual Tables to Expose More Business Central Data in Dataverse
Include Only Open Entries on Customer Statements
Adjust Exchange Rates Easily, Replace the Built-in Batch Job
More Control Over General Journal Approvals
Use Different General Ledger Accounts for Payables, Receivables
Add More Columns to Pages for Better Insight
Availability Overview Helps You Calculate Quantities in Your Warehouse
Block Item Variants
Identify and Track Items Easier with Item References
Improved Processes for Inventory Counts and Adjustments
Navigate Easier Between Order, Receipt, and Invoice Documents
Print and Scan Barcodes
Receive More Items Than Ordered by Using Inventory Put-away Documents
Generate a Customer Statement Only With Open Entries
Responsibility Centers Are Supported for Advance Payments in Czechia
Easier Management of System Application Permissions
Get the AL Language Extension in Prerelease Versions on Visual Studio Code Marketplace
Find All References Now Works on Triggers, System Methods, and Trigger Events
Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
Hover Over Label Variable to See Text String Value
Set New Output Folder Setting for Storing App Files at AL Project Build
Choose Between More Sampling Intervals for Snapshot and In-client Profiling
Get IntelliSense for Adding Variables in Visual Studio Code AL Debugger Console
Get Smarter Method Signature Recommendations in IntelliSense
Set the Default Folder Location for New AL Projects
Track Source and Build Metadata on Extensions
Use SecretText Type to Protect Credentials and Sensitive Textual Values From Being Revealed
Document Your Extensions With the ALDoc Tool for Partners
Segment AL Code and Reduce Naming Conflicts with Namespaces
Show List of Keys While Working on AL Code
Use the AL Language Extension for Linux in Preview
Provide Queries for Users to do Ad Hoc Data Analysis Across Tables
Add a New FieldGroup to an Existing Table
Add Teaching Tooltips on Queries and Report Request Pages
Get Syntax Highlighting for AL in Azure DevOps
Sell Business Central Apps Through AppSource
AppSource ISV Publishers Can Preview Their AppSource Apps With Select Customers
Extend General Ledger Posting Aggregations
Define multi-worksheet datasets for Excel reports
Include or Exclude Tables From Cloud Migration
Delete Data from Uninstalled Extensions as an Admin
Automatically Update AppSource Apps With Minor Updates
Transfer Environments Between Microsoft Entra Tenants
Control Partner Access Per Environment
Use Drop Shipments for Triangular Intrastat Trade
Start Faster with Refreshed and Enhanced Setup Data
VAT Posting in General Ledger Setup
Demo Tool and Data for Service Scenarios
Analyze, Group, and Pivot Data on Lists
Share a Data Analysis With a Co-worker
Synchronize Multiple Business Central Companies With the Same Dataverse Environment
New Operational Limits on Scheduled Tasks and Web Requests Improve Throughput
Service-to-Service Apps and Device License Users Can Schedule Tasks
Mark Fields as Read-only When Customizing UI
Scan barcodes with Business Central mobile app for iOS and Android
Access Worksheet Pages From Mobile Phones
Use Virtual Tables to Expose More Business Central Data in Dataverse
Reverse a Customer and Vendor Ledger Entry with a Realized Gain or Loss Entry
Use General Ledger Account Revaluation for More Accurate Financial Statements
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Chat with Copilot
Improved Data Upgrade Troubleshooting for Dynamics GP Migration
Retain Permissions When Enabling Cloud Migration
Detect Invalid Cloud Migration Configurations with Proactive Warnings
Multiple VAT Numbers per Customer

In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Pick in Two Steps by Releasing the Source Document

Microsoft Dynamics 365 Business CentralThis post is part of the In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), 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.

In a previous article of this series on understanding inventory picks, I mentioned there was three ways in which an inventory pick could be processed:

  1. Process an Inventory Pick from the Source Document
  2. Process Multiple Inventory Picks Using a Batch Job
  3. Process an Inventory Pick in Two Steps by Releasing the Source Document

In this article, I am going to take walk through the processing an inventory pick using a two step process using the BLUE location on which I enabled Require Pick.

The first step is an ordinary one when processing a sales order; that of releasing the document which is done by clicking Release » Release. This is something which you usually have to do in order to email or print he PO document to the vendor.

released sales order

Continue reading “In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Pick in Two Steps by Releasing the Source Document”

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Get List of Companies Using Business Central Connector in Power Automate

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

The eighth of the new functionality in the Adapt faster with Power Platform section is Get list of companies using Business Central connector in Power Automate.

More often, customers and partners are trying to instrument workflows working across companies in Business Central, but they’re blocked. Having an action in the Business Central connector that retrieves a list of companies in Business Central unblocks these customers and partners, providing greater flexibility for executing flows across multiple companies.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: Sep 2023
General Availability: Oct 2023

Feature Details

With this new action in a workflow, you can get all Business Central companies available in a given environment and then either iterate through them all or find a specific one.

This capability enables the creation of more dynamic workflows that function seamlessly across different companies.

List Business Central companies in Power Automate

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Get List of Companies Using Business Central Connector in Power Automate”

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Consolidated Power Automate Flow Creation from Business Central Templates

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

The seventh of the new functionality in the Adapt faster with Power Platform section is Consolidated Power Automate flow creation from Business Central templates.

It’s essential that all Power Automate integration capabilities and sample templates are clearly defined, marked, and visible in the product so that decision makers can use them effectively when needed.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: Sep 2023
General Availability: Oct 2023

Feature Details

This feature in Business Central provides advanced users with a single entry point to create flows based on templates. New actions have been added to enable flow creation in the following categories:

  • Defining an approval request workflow if the page supports it. This was previously available as an application action but was difficult to find.
  • Creating an automated background flow (for instance, flows based on external business events). Prior to this addition, such automations were only possible in Power Automate, and there were no Business Central templates supporting them.
  • Creating a manual or instant flow. While this capability existed before, several new templates have been added to expand its functionality.

Microsoft also added several new automated and instant flow templates to their gallery.

Learn more about Business Central and Power Automate integration at Workflows in Dynamics 365 Business Central.

My Opinion

I’ve started working with Power Automate recently and I think this will be a good change which will make creating flows easier.

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2
Change Modification Limits for Triggering Flows and Bulk Updates
Support Business Events in Business Central Connector for Power Automate
Enable Specific Virtual Tables When You Connect to Dataverse
Get Control Over How to View Power BI Embedded Content
Availability Overview Helps You Calculate Quantities in Your Warehouse
Configure The Right Level of Handling For Different Warehouse Operations
Do financial Consolidations Across Environments in Multicompany Setups
Edit in Excel on Item Journals and Warehouse Worksheets
Get More Productive While Approving Time Sheets
Get More Productive While Entering Time Sheets
Include Approvals for Intercompany General Journals in Your Workflows
Make Intercompany Transactions Across Business Central Environments
Suggest the Next Step For Sales and Production Orders
Sync Document and Posting Dates for Sales and Purchases
Troubleshoot Shopify Integration Issues
Usability Improves for Warehouse, Inventory, and Tracking
Use Directed Pick and Put-away Suggestions in Basic Warehouse Configurations
Use General Ledger Allocations to Distribute Costs and Revenue More Efficiently
Complete Bank Account Reconciliation Faster With Copilot
Get Marketing Text Suggestions with Copilot
New Design for Report Language and Region Settings
Advance Payment and a Posting Preview of Tax Documents – Czechia
Direct Transfer – Czechia
E-submission of VAT Return in Denmark
Iceland Localization App – Delocalization
Intercompany Posting Cues to the Accountant Role Center – Czechia
New Intrastat – Czechia
Registration and Notification Functionality for Denmark
E-invoicing with NemHandel in Denmark
Supporting More Countries and Regions
Open Visual Studio Code From Web Client to Investigate or Troubleshoot Extensions
Turn Off Data Analysis Mode on Pages and Queries
Turn Off Indexes as a Partner
Use the Built-in Rich Text Editor to Enter Data
Assign More Granular Administration Rights
Improved Update Release Processes
Cancel Cloud Migration Replication Runs
Digital Vouchers
E-documents Core as a Global Solution
Large Companies to Report Payment Times
Modify Texts on the Welcome Banner and Skip Banner Intro State
Set Initial Role Before First Sign-in for a Better First-Run Experience
Enhancements to Excel Add-in
Analyze, Group, and Pivot Data on Queries Using Multiple Tabs
Discover Report and Data Analysis Content Easily
Get Power BI Reports for Reporting and Data Analysis on Finance, Sales, and Inventory
Data Loads Faster in the Server
Faster Application Scenarios
Pages Load Faster in Client
Performance Gain Reducing Locks in the Database
Add Existing Table Fields to Optimize Your Pages
Get to Data Search From Anywhere in Business Central
Distinguish Browser Tabs When Multitasking
Share Readable Deep Links to Pages and Records
Manage User Expectations with Selection Context-Based Actions
Peek at Summarized Data From Editable Fields
Search for Pages and Data in the Mobile App
Use Actions to Navigate or Fix Errors From Inline Validation Dialog
Updates to the Release Plan
Power Pages Support via Business Central Virtual Tables on Dataverse
Synchronize More Fields in Your Integration with Dataverse and Dynamics 365 Sales
Consolidated Power Automate Flow Creation from Business Central Templates
Get List of Companies Using Business Central Connector in Power Automate
Simplified Power Automate Approval Flow Experience
Create Power Automate Flows that Dynamically Support Different Companies
Business Central Virtual Tables Fully Supported on Microsoft Dataverse
Relate Native and Virtual Tables to Expose More Business Central Data in Dataverse
Include Only Open Entries on Customer Statements
Adjust Exchange Rates Easily, Replace the Built-in Batch Job
More Control Over General Journal Approvals
Use Different General Ledger Accounts for Payables, Receivables
Add More Columns to Pages for Better Insight
Availability Overview Helps You Calculate Quantities in Your Warehouse
Block Item Variants
Identify and Track Items Easier with Item References
Improved Processes for Inventory Counts and Adjustments
Navigate Easier Between Order, Receipt, and Invoice Documents
Print and Scan Barcodes
Receive More Items Than Ordered by Using Inventory Put-away Documents
Generate a Customer Statement Only With Open Entries
Responsibility Centers Are Supported for Advance Payments in Czechia
Easier Management of System Application Permissions
Get the AL Language Extension in Prerelease Versions on Visual Studio Code Marketplace
Find All References Now Works on Triggers, System Methods, and Trigger Events
Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
Hover Over Label Variable to See Text String Value
Set New Output Folder Setting for Storing App Files at AL Project Build
Choose Between More Sampling Intervals for Snapshot and In-client Profiling
Get IntelliSense for Adding Variables in Visual Studio Code AL Debugger Console
Get Smarter Method Signature Recommendations in IntelliSense
Set the Default Folder Location for New AL Projects
Track Source and Build Metadata on Extensions
Use SecretText Type to Protect Credentials and Sensitive Textual Values From Being Revealed
Document Your Extensions With the ALDoc Tool for Partners
Segment AL Code and Reduce Naming Conflicts with Namespaces
Show List of Keys While Working on AL Code
Use the AL Language Extension for Linux in Preview
Provide Queries for Users to do Ad Hoc Data Analysis Across Tables
Add a New FieldGroup to an Existing Table
Add Teaching Tooltips on Queries and Report Request Pages
Get Syntax Highlighting for AL in Azure DevOps
Sell Business Central Apps Through AppSource
AppSource ISV Publishers Can Preview Their AppSource Apps With Select Customers
Extend General Ledger Posting Aggregations
Define multi-worksheet datasets for Excel reports
Include or Exclude Tables From Cloud Migration
Delete Data from Uninstalled Extensions as an Admin
Automatically Update AppSource Apps With Minor Updates
Transfer Environments Between Microsoft Entra Tenants
Control Partner Access Per Environment
Use Drop Shipments for Triangular Intrastat Trade
Start Faster with Refreshed and Enhanced Setup Data
VAT Posting in General Ledger Setup
Demo Tool and Data for Service Scenarios
Analyze, Group, and Pivot Data on Lists
Share a Data Analysis With a Co-worker
Synchronize Multiple Business Central Companies With the Same Dataverse Environment
New Operational Limits on Scheduled Tasks and Web Requests Improve Throughput
Service-to-Service Apps and Device License Users Can Schedule Tasks
Mark Fields as Read-only When Customizing UI
Scan barcodes with Business Central mobile app for iOS and Android
Access Worksheet Pages From Mobile Phones
Use Virtual Tables to Expose More Business Central Data in Dataverse
Reverse a Customer and Vendor Ledger Entry with a Realized Gain or Loss Entry
Use General Ledger Account Revaluation for More Accurate Financial Statements
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Chat with Copilot
Improved Data Upgrade Troubleshooting for Dynamics GP Migration
Retain Permissions When Enabling Cloud Migration
Detect Invalid Cloud Migration Configurations with Proactive Warnings
Multiple VAT Numbers per Customer

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Synchronize More Fields in Your Integration with Dataverse and Dynamics 365 Sales

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

The sixth of the new functionality in the Adapt faster with Power Platform section is Synchronize more fields in your integration with Dataverse and Dynamics 365 Sales.

Companies often customize their integration between Business Central and Dataverse or Dynamics 365 to fit their specific business needs. To make that easier to do without help from a developer, Microsoft have made more fields available for mapping in the standard integration table mappings.

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

Feature Details

Microsoft have made more fields available in the standard CUSTOMER, VENDOR, CONTACT, SALESPERSON, and OPPORTUNITY integration table mappings. On the Integration Table Mapping page, you select the table mapping for which you want to enable field mappings by choosing Mapping, and then the Fields action.

Shows additional fields that can be mapped in Integration Field Mapping list

To start synchronizing data from the fields you’ve chosen, change the status of the field to Enabled.

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2
Change Modification Limits for Triggering Flows and Bulk Updates
Support Business Events in Business Central Connector for Power Automate
Enable Specific Virtual Tables When You Connect to Dataverse
Get Control Over How to View Power BI Embedded Content
Availability Overview Helps You Calculate Quantities in Your Warehouse
Configure The Right Level of Handling For Different Warehouse Operations
Do financial Consolidations Across Environments in Multicompany Setups
Edit in Excel on Item Journals and Warehouse Worksheets
Get More Productive While Approving Time Sheets
Get More Productive While Entering Time Sheets
Include Approvals for Intercompany General Journals in Your Workflows
Make Intercompany Transactions Across Business Central Environments
Suggest the Next Step For Sales and Production Orders
Sync Document and Posting Dates for Sales and Purchases
Troubleshoot Shopify Integration Issues
Usability Improves for Warehouse, Inventory, and Tracking
Use Directed Pick and Put-away Suggestions in Basic Warehouse Configurations
Use General Ledger Allocations to Distribute Costs and Revenue More Efficiently
Complete Bank Account Reconciliation Faster With Copilot
Get Marketing Text Suggestions with Copilot
New Design for Report Language and Region Settings
Advance Payment and a Posting Preview of Tax Documents – Czechia
Direct Transfer – Czechia
E-submission of VAT Return in Denmark
Iceland Localization App – Delocalization
Intercompany Posting Cues to the Accountant Role Center – Czechia
New Intrastat – Czechia
Registration and Notification Functionality for Denmark
E-invoicing with NemHandel in Denmark
Supporting More Countries and Regions
Open Visual Studio Code From Web Client to Investigate or Troubleshoot Extensions
Turn Off Data Analysis Mode on Pages and Queries
Turn Off Indexes as a Partner
Use the Built-in Rich Text Editor to Enter Data
Assign More Granular Administration Rights
Improved Update Release Processes
Cancel Cloud Migration Replication Runs
Digital Vouchers
E-documents Core as a Global Solution
Large Companies to Report Payment Times
Modify Texts on the Welcome Banner and Skip Banner Intro State
Set Initial Role Before First Sign-in for a Better First-Run Experience
Enhancements to Excel Add-in
Analyze, Group, and Pivot Data on Queries Using Multiple Tabs
Discover Report and Data Analysis Content Easily
Get Power BI Reports for Reporting and Data Analysis on Finance, Sales, and Inventory
Data Loads Faster in the Server
Faster Application Scenarios
Pages Load Faster in Client
Performance Gain Reducing Locks in the Database
Add Existing Table Fields to Optimize Your Pages
Get to Data Search From Anywhere in Business Central
Distinguish Browser Tabs When Multitasking
Share Readable Deep Links to Pages and Records
Manage User Expectations with Selection Context-Based Actions
Peek at Summarized Data From Editable Fields
Search for Pages and Data in the Mobile App
Use Actions to Navigate or Fix Errors From Inline Validation Dialog
Updates to the Release Plan
Power Pages Support via Business Central Virtual Tables on Dataverse
Synchronize More Fields in Your Integration with Dataverse and Dynamics 365 Sales
Consolidated Power Automate Flow Creation from Business Central Templates
Get List of Companies Using Business Central Connector in Power Automate
Simplified Power Automate Approval Flow Experience
Create Power Automate Flows that Dynamically Support Different Companies
Business Central Virtual Tables Fully Supported on Microsoft Dataverse
Relate Native and Virtual Tables to Expose More Business Central Data in Dataverse
Include Only Open Entries on Customer Statements
Adjust Exchange Rates Easily, Replace the Built-in Batch Job
More Control Over General Journal Approvals
Use Different General Ledger Accounts for Payables, Receivables
Add More Columns to Pages for Better Insight
Availability Overview Helps You Calculate Quantities in Your Warehouse
Block Item Variants
Identify and Track Items Easier with Item References
Improved Processes for Inventory Counts and Adjustments
Navigate Easier Between Order, Receipt, and Invoice Documents
Print and Scan Barcodes
Receive More Items Than Ordered by Using Inventory Put-away Documents
Generate a Customer Statement Only With Open Entries
Responsibility Centers Are Supported for Advance Payments in Czechia
Easier Management of System Application Permissions
Get the AL Language Extension in Prerelease Versions on Visual Studio Code Marketplace
Find All References Now Works on Triggers, System Methods, and Trigger Events
Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
Hover Over Label Variable to See Text String Value
Set New Output Folder Setting for Storing App Files at AL Project Build
Choose Between More Sampling Intervals for Snapshot and In-client Profiling
Get IntelliSense for Adding Variables in Visual Studio Code AL Debugger Console
Get Smarter Method Signature Recommendations in IntelliSense
Set the Default Folder Location for New AL Projects
Track Source and Build Metadata on Extensions
Use SecretText Type to Protect Credentials and Sensitive Textual Values From Being Revealed
Document Your Extensions With the ALDoc Tool for Partners
Segment AL Code and Reduce Naming Conflicts with Namespaces
Show List of Keys While Working on AL Code
Use the AL Language Extension for Linux in Preview
Provide Queries for Users to do Ad Hoc Data Analysis Across Tables
Add a New FieldGroup to an Existing Table
Add Teaching Tooltips on Queries and Report Request Pages
Get Syntax Highlighting for AL in Azure DevOps
Sell Business Central Apps Through AppSource
AppSource ISV Publishers Can Preview Their AppSource Apps With Select Customers
Extend General Ledger Posting Aggregations
Define multi-worksheet datasets for Excel reports
Include or Exclude Tables From Cloud Migration
Delete Data from Uninstalled Extensions as an Admin
Automatically Update AppSource Apps With Minor Updates
Transfer Environments Between Microsoft Entra Tenants
Control Partner Access Per Environment
Use Drop Shipments for Triangular Intrastat Trade
Start Faster with Refreshed and Enhanced Setup Data
VAT Posting in General Ledger Setup
Demo Tool and Data for Service Scenarios
Analyze, Group, and Pivot Data on Lists
Share a Data Analysis With a Co-worker
Synchronize Multiple Business Central Companies With the Same Dataverse Environment
New Operational Limits on Scheduled Tasks and Web Requests Improve Throughput
Service-to-Service Apps and Device License Users Can Schedule Tasks
Mark Fields as Read-only When Customizing UI
Scan barcodes with Business Central mobile app for iOS and Android
Access Worksheet Pages From Mobile Phones
Use Virtual Tables to Expose More Business Central Data in Dataverse
Reverse a Customer and Vendor Ledger Entry with a Realized Gain or Loss Entry
Use General Ledger Account Revaluation for More Accurate Financial Statements
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Chat with Copilot
Improved Data Upgrade Troubleshooting for Dynamics GP Migration
Retain Permissions When Enabling Cloud Migration
Detect Invalid Cloud Migration Configurations with Proactive Warnings
Multiple VAT Numbers per Customer

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Power Pages Support via Business Central Virtual Tables on Dataverse

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

The fifth of the new functionality in the Adapt faster with Power Platform section is Power Pages support via Business Central virtual tables on Dataverse.

Power Pages support will enable both anonymous and authenticated external users to perform create, read, update, and delete (CRUD) operations on Business Central tables that are available as virtual tables in Microsoft Dataverse.

Enabled for: Users by admins, makers, or analysts
Public Preview: Nov 2023
General Availability: –

Feature Details

In many commerce and collaboration scenarios, external users may need to participate in processes that involve Business Central data, such as bidding or onboarding, even if they are not Business Central users. With anonymous access via Power Pages, external users can perform operations on Business Central tables without signing in. Authenticated access via Power Pages requires external users to sign in to perform operations on tables or rows that are accessible to them. Business Central admins can select only the necessary operations, tables, and rows to be enabled for anonymous or authenticated access by external users.

Power Pages support also enables authenticated access by internal or existing Business Central users, similar to authenticated access via Power Apps or Power Automate. Microsoft are excited to announce the preview of this feature and always appreciate your feedback and suggestions.

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Power Pages Support via Business Central Virtual Tables on Dataverse”

In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process Multiple Inventory Picks Using a Batch Job

Microsoft Dynamics 365 Business CentralThis post is part of the In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), 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.

In a previous article of this series on understanding inventory picks, I mentioned there was three ways in which an inventory pick could be processed:

  1. Process an Inventory Pick from the Source Document
  2. Process Multiple Inventory Picks Using a Batch Job
  3. Process an Inventory Pick in Two Steps by Releasing the Source Document

In this article, I am going to take walk through processing inventory picks using a batch job for the BLUE location on which I enabled Require Pick.

To use the batch job for creating inventory picks, search for the Create Inventory Put-away/Pick/Movement page.

The options on this page will need to be configured to restrict which incoming documents have inventory picks created. I have opted for all (released) sales orders; click OK to create the picks or Schedule to schedule the batch job to run at a designated time:

Create Inventory Put-away/Pick/Movement

Continue reading “In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process Multiple Inventory Picks Using a Batch Job”

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Updates to the Release Plan

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

I published this series of articles back in July when the planned features document was published; I discovered the other day that it has been updated my Microsoft.

There appears to be four planned features which have been removed; I’ve updated them to acknowledge the removal, but I have left the articles live. The removed features are:

In terms of added functionality since July, there seems to be more new added functionality than there was originally listed. Release 2023 Wave 2 is looking like it is going to be quite big, with some good new features coming.

I’m going to take a look through the coming functionality over the coming days/weeks, so watch out for the posts.

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2
Change Modification Limits for Triggering Flows and Bulk Updates
Support Business Events in Business Central Connector for Power Automate
Enable Specific Virtual Tables When You Connect to Dataverse
Get Control Over How to View Power BI Embedded Content
Availability Overview Helps You Calculate Quantities in Your Warehouse
Configure The Right Level of Handling For Different Warehouse Operations
Do financial Consolidations Across Environments in Multicompany Setups
Edit in Excel on Item Journals and Warehouse Worksheets
Get More Productive While Approving Time Sheets
Get More Productive While Entering Time Sheets
Include Approvals for Intercompany General Journals in Your Workflows
Make Intercompany Transactions Across Business Central Environments
Suggest the Next Step For Sales and Production Orders
Sync Document and Posting Dates for Sales and Purchases
Troubleshoot Shopify Integration Issues
Usability Improves for Warehouse, Inventory, and Tracking
Use Directed Pick and Put-away Suggestions in Basic Warehouse Configurations
Use General Ledger Allocations to Distribute Costs and Revenue More Efficiently
Complete Bank Account Reconciliation Faster With Copilot
Get Marketing Text Suggestions with Copilot
New Design for Report Language and Region Settings
Advance Payment and a Posting Preview of Tax Documents – Czechia
Direct Transfer – Czechia
E-submission of VAT Return in Denmark
Iceland Localization App – Delocalization
Intercompany Posting Cues to the Accountant Role Center – Czechia
New Intrastat – Czechia
Registration and Notification Functionality for Denmark
E-invoicing with NemHandel in Denmark
Supporting More Countries and Regions
Open Visual Studio Code From Web Client to Investigate or Troubleshoot Extensions
Turn Off Data Analysis Mode on Pages and Queries
Turn Off Indexes as a Partner
Use the Built-in Rich Text Editor to Enter Data
Assign More Granular Administration Rights
Improved Update Release Processes
Cancel Cloud Migration Replication Runs
Digital Vouchers
E-documents Core as a Global Solution
Large Companies to Report Payment Times
Modify Texts on the Welcome Banner and Skip Banner Intro State
Set Initial Role Before First Sign-in for a Better First-Run Experience
Enhancements to Excel Add-in
Analyze, Group, and Pivot Data on Queries Using Multiple Tabs
Discover Report and Data Analysis Content Easily
Get Power BI Reports for Reporting and Data Analysis on Finance, Sales, and Inventory
Data Loads Faster in the Server
Faster Application Scenarios
Pages Load Faster in Client
Performance Gain Reducing Locks in the Database
Add Existing Table Fields to Optimize Your Pages
Get to Data Search From Anywhere in Business Central
Distinguish Browser Tabs When Multitasking
Share Readable Deep Links to Pages and Records
Manage User Expectations with Selection Context-Based Actions
Peek at Summarized Data From Editable Fields
Search for Pages and Data in the Mobile App
Use Actions to Navigate or Fix Errors From Inline Validation Dialog
Updates to the Release Plan
Power Pages Support via Business Central Virtual Tables on Dataverse
Synchronize More Fields in Your Integration with Dataverse and Dynamics 365 Sales
Consolidated Power Automate Flow Creation from Business Central Templates
Get List of Companies Using Business Central Connector in Power Automate
Simplified Power Automate Approval Flow Experience
Create Power Automate Flows that Dynamically Support Different Companies
Business Central Virtual Tables Fully Supported on Microsoft Dataverse
Relate Native and Virtual Tables to Expose More Business Central Data in Dataverse
Include Only Open Entries on Customer Statements
Adjust Exchange Rates Easily, Replace the Built-in Batch Job
More Control Over General Journal Approvals
Use Different General Ledger Accounts for Payables, Receivables
Add More Columns to Pages for Better Insight
Availability Overview Helps You Calculate Quantities in Your Warehouse
Block Item Variants
Identify and Track Items Easier with Item References
Improved Processes for Inventory Counts and Adjustments
Navigate Easier Between Order, Receipt, and Invoice Documents
Print and Scan Barcodes
Receive More Items Than Ordered by Using Inventory Put-away Documents
Generate a Customer Statement Only With Open Entries
Responsibility Centers Are Supported for Advance Payments in Czechia
Easier Management of System Application Permissions
Get the AL Language Extension in Prerelease Versions on Visual Studio Code Marketplace
Find All References Now Works on Triggers, System Methods, and Trigger Events
Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
Get Inlay Hints in Source Editor for AL Method Parameters and Return Types
Hover Over Label Variable to See Text String Value
Set New Output Folder Setting for Storing App Files at AL Project Build
Choose Between More Sampling Intervals for Snapshot and In-client Profiling
Get IntelliSense for Adding Variables in Visual Studio Code AL Debugger Console
Get Smarter Method Signature Recommendations in IntelliSense
Set the Default Folder Location for New AL Projects
Track Source and Build Metadata on Extensions
Use SecretText Type to Protect Credentials and Sensitive Textual Values From Being Revealed
Document Your Extensions With the ALDoc Tool for Partners
Segment AL Code and Reduce Naming Conflicts with Namespaces
Show List of Keys While Working on AL Code
Use the AL Language Extension for Linux in Preview
Provide Queries for Users to do Ad Hoc Data Analysis Across Tables
Add a New FieldGroup to an Existing Table
Add Teaching Tooltips on Queries and Report Request Pages
Get Syntax Highlighting for AL in Azure DevOps
Sell Business Central Apps Through AppSource
AppSource ISV Publishers Can Preview Their AppSource Apps With Select Customers
Extend General Ledger Posting Aggregations
Define multi-worksheet datasets for Excel reports
Include or Exclude Tables From Cloud Migration
Delete Data from Uninstalled Extensions as an Admin
Automatically Update AppSource Apps With Minor Updates
Transfer Environments Between Microsoft Entra Tenants
Control Partner Access Per Environment
Use Drop Shipments for Triangular Intrastat Trade
Start Faster with Refreshed and Enhanced Setup Data
VAT Posting in General Ledger Setup
Demo Tool and Data for Service Scenarios
Analyze, Group, and Pivot Data on Lists
Share a Data Analysis With a Co-worker
Synchronize Multiple Business Central Companies With the Same Dataverse Environment
New Operational Limits on Scheduled Tasks and Web Requests Improve Throughput
Service-to-Service Apps and Device License Users Can Schedule Tasks
Mark Fields as Read-only When Customizing UI
Scan barcodes with Business Central mobile app for iOS and Android
Access Worksheet Pages From Mobile Phones
Use Virtual Tables to Expose More Business Central Data in Dataverse
Reverse a Customer and Vendor Ledger Entry with a Realized Gain or Loss Entry
Use General Ledger Account Revaluation for More Accurate Financial Statements
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Chat with Copilot
Improved Data Upgrade Troubleshooting for Dynamics GP Migration
Retain Permissions When Enabling Cloud Migration
Detect Invalid Cloud Migration Configurations with Proactive Warnings
Multiple VAT Numbers per Customer