Month: October 2023

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

Ian Grieve3 minute read0 comment

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

Ian Grieve3 minute read0 comment

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

How To Install Microsoft SQL Server 2022: Install SQL Server Management Studio

Ian Grieve2 minute read0 comment

Microsoft SQL ServerThis article is part of the series on How To Install Microsoft SQL Server 2022; I do not claim to be an expert on SQL Server and this series is installing SQL Server in a development/testing/demo environment. If you’re installing SQL into a production environment there will be additional work required to harden the SQL Server and avoid security issues.

in the last article of this series, I gave the download link for SQL Server Management Studio; once you’ve downloaded the installer, you can launch it and amend the Location if necessary.

Click Install to begin the installation:

Welcome, Click "Install" to begin

Continue reading “How To Install Microsoft SQL Server 2022: Install SQL Server Management Studio”

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

Ian Grieve3 minute read0 comment

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

Ian Grieve3 minute read0 comment

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

Ian Grieve3 minute read0 comment

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

Ian Grieve2 minute read0 comment

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

In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Pick from the Source Document

Ian Grieve2 minute read0 comment

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 from the source document using the BLUE location on which I enabled Require Pick.

To create an inventory pick for a sales order, open the Sales Order page and click the Process » Create Inventory Put-away/Pick/Movement action:

Sales Order page showing the pick action button

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

How To Install Microsoft SQL Server 2022: Download SQL Server Management Studio

Ian Grieve3 minute read0 comment

Microsoft SQL ServerThis article is part of the series on How To Install Microsoft SQL Server 2022; I do not claim to be an expert on SQL Server and this series is installing SQL Server in a development/testing/demo environment. If you’re installing SQL into a production environment there will be additional work required to harden the SQL Server and avoid security issues.

An application, not listed as a feature of SQL Server, is SQL Server Management Studio (SSMS). This is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. You can use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications and build queries and scripts.

It is an invaluable tool for working with SQL Server; it used to be packaged as part of the main SQL Server installation media download, but was separated out a few years ago to allow for more
regular updates. It will work with any version of SQL Server, so you just need to get the latest version.

The latest download is available from here:

Download SQL Server Management Studio (SSMS)

Continia Certified: Continia Expense Management Professional User

Ian Grieve1 minute read0 comment

Microsoft Dynamics 365 Business CentralSince I started working with Microsoft Dynamics 365 Business Central last year, I’ve also been learning some of the add-ons which are commonly used. One of those add-ons is Expense Management from Continia Software.

They seem pretty well organised and have a Continia Learn which is very much along the same lines as Microsoft Learn; you can also do an exam for each of their products which results in a credential which you can register with Credly.

I passed the Document Capture certification in March and have, this week, passed the one for Expense Management:

Certificate confirmation