New Functionality In Microsoft Power Automate 2024 Wave 1: Connect to Other Environments from the Microsoft Dataverse Connector

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 5th of the new functionality in the Cloud Flows section is connect to other environments from the Microsoft Dataverse connector.

Users can create flows that combine data and perform operations across different Microsoft Dataverse databases.

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

Feature Details

Currently, you must use the Microsoft Dataverse (legacy) connector to connect to environments outside of the current environment. With this feature, you can connect to other environments from the Microsoft Dataverse connector’s actions and triggers

My Opinion

In order to judge this enhancement, I need to get more up to speed on the Dataverse and specifically how it interacts with Business Central, as most of my work is with that ERP and the flows I create interact with it in some way.

New Functionality In Microsoft Power Automate 2024 Wave 1: Monitor Performance for Cloud and Desktop Flow Activities

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 4th of the new functionality in the Cloud Flows section is monitor performance for cloud and desktop flow activities.

You can use a central consolidated view to monitor and understand the executions across cloud and desktop flows.

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

Feature Details

With this feature, you have a single consolidated view to understand the automation performance across your cloud and desktop flows. This feature enables you to:

  • Understand the top trends across all of your automation assets (for example, success and failure) across different time periods.
  • Understand top errors and their trends.
  • Understand top flows with specific errors.
  • Seamlessly switch between cloud and desktop flows activity.

My Opinion

This looks to be a good enhancement to monitoring which will allow you to see if any flows are problematic.

Working with Power Automate Child Flows: Error Encountered Saving a Flow Which Calls a Child Flow

Power AutomateThis article is part of the Working with Power Automate Child Flows series and of the larger Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC.

If you create a child flow and call it from a parent, you may receive this error:

Child Flow Error

However, you will only be receiving the error if you have missed a step when creating the child flow; you need to change the run-only users setting, which I covered in this article.

Working with Power Automate

Working with Power Automate
What is Power Automate?
What Type of Flow Are Available?
What Type of Cloud Flows Are Available?
Power Automate with Business Central
Working with Power Automate Solutions: What Are Solutions?
Working with Power Automate Solutions: What Types of Solution Are There?
Working with Power Automate Solutions: What is a Solution Publisher?
Working with Power Automate Solutions: Create a Solution Publisher
Working with Power Automate Solutions: Create a Solution
Working with Power Automate Solutions: Publish a Solution
Working with Power Automate Solutions: Version Numbering for Solutions
Working with Power Automate Solutions: Exporting An Unmanaged Solution
Working with Power Automate Solutions: Importing An Unmanaged Solution
Working with Power Automate Solutions: Exporting A Managed Solution
Working with Power Automate Solutions: Importing A Managed Solution
Working with Power Automate Solutions: Change the Managed Properties of a Solution Component
Create a Visio Diagram of a Flow
What Are Environment Variables and Why Should They be Used?
Create an Environment Variables
Create a New Cloud Flow From a Template
Managing Large Flows
What is a Scope?
Example of How to Use a Scope
Best Practice For Using Scopes
Working with Power Automate Child Flows: What are Child Flows?
Working with Power Automate Child Flows: Create a Child Flow
Working with Power Automate Child Flows: Change Run Only Users For Child Flow
Working with Power Automate Child Flows: Add a Child Flow To a Parent Flow
Working with Power Automate Child Flows: Test the Parent/Child Flow Examples
Working with Power Automate Child Flows: Error Encountered Saving a Flow Which Calls a Child Flow

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Control partner access per environment

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 8th of the new functionality in the Governance and administration section is Control partner access per environment.

Business Central customers with multiple environments are often working with many partners to support each environment. With this feature, customer administrators can now easily and efficiently control partner access to environments. This feature simplifies partner management by allowing administrators to assign partner tenants to each environment.

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

Feature Details

In 2024 release wave 1, Microsoft are introducing new environment settings in the Business Central admin center that enable internal administrators to control which environments delegated users and multitenant apps from partner tenants can access and administer. Internal administrators can specify the tenant IDs of partners that should be able to access each environment. Delegated users and multitenant apps accessing or administering the environment must belong to an allowlisted tenant. This feature is optional, and if no tenants are allowlisted for an environment, delegated users and multitenant apps will be able to access and administer the environment as they did before. This feature only affects the use of the admin center API by multitenant apps that have been authorized within the admin center

My Opinion

This sounds like a double edged sword; good for users to have the ability to restrict access to environments, but also too easy for something to be set incorrectly and deprive necessary access. However, the same can be said of any security on a system, so I’d say this is a good enhancement. Some of the clients I’ve worked with in the past have had very locked down systems, so they’d like this for witholding access to production while giving access to dev, QA and UAT environments. It could also be useful for companies operating in multiple countries by allowing only the partner for a specific country to access an environment.

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
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
Automate IRS 1099 Form Submission in US
Enable Additional Countries and Regions
Install UK Localization as an App
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 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
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

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: View and Filter Users With Additional User Details

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 7th of the new functionality in the Governance and administration section is view and filter users with additional user details.

Additional user details and technical data helps administrators be more effective when they handle user requests and resolve issues..

Enabled for: Users, automatically
Public Preview: Mar 2024
General Availability: Apr 2024

Feature Details

You can view additional details about users on the Users page by choosing the Show more details action.

Shows new Show more details action in Users page

The Users details page offers multiple views that administrators can filter. For example, an administrator might want to view all users with a Microsoft 365 license, or users who are assigned to the SUPER permission set.

Shows new user details page with extra columns and views

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: View and Filter Users With Additional User Details”

Picking Only Reserved Goods in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Centralvan Labrador Gonzalez, an experienced system engineer, has on his IVAN SINGLETON | A blog about Business Central, Xamarin and Arduino blog recently posted an article on enhancing the picking process within warehouse management so that only reserved goods are included on the pick as it is created.

Unfortunately, this is not something which is available as standard in Business Central; when you create the pick, the whole quantity of goods from the order are included on the shipment and resulting pick.

The way Ivan gets only the reserved items onto the pick is be developing an extension which adds a new button to the Warehouse Shipment (7335) page. Fortunately, in the article he details the step by step to create this customisation, including all of the required code.

Warehouse Shipment page with new action button

The article, including code examples, can be found here and complete code is on GitHub.

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Copy Companies with Dataverse Integration Safely

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 6th of the new functionality in the Governance and administration section is copy companies with Dataverse integration safely.

Administrators in small or medium-sized companies often wear multiple hats and do many different tasks. It’s important that you can efficiently and safely copy companies if you integrate with Dataverse or Dynamics 365 Sales, reducing the risk of data inconsistencies and saving you valuable time. This enhancement streamlines your workflow so you can focus on strategic tasks, driving your business forward.

Enabled for: Users, automatically
Public Preview: Mar 2024
General Availability: Apr 2024

Feature Details

When an administrator copies companies in an environment that has Dataverse or Dynamics 365 Sales integration enabled, Business Central clears the following settings while copying to the target company:

  • Dataverse and Dynamics Connection Settings to ensure that integration correctly re-initiates in the target company.
  • Integration records to ensure that the target company doesn’t point to records that are coupled in the source company.
  • Integration synchronization jobs to stop synchronization background jobs.
  • Integration synchronization errors to clean synchronization errors, it they exist, because they point to errors in source company and would just be considered noise in the target company.

My Opinion

This sounds like a very welcome enhancement as the current process is open to quite a bit of risk. Clearng these settings will help prevent environments syncing incorrectly.

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
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
Automate IRS 1099 Form Submission in US
Enable Additional Countries and Regions
Install UK Localization as an App
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 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
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

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

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

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

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

Jet Reports & Business Central

Tuesday, 16th April 2024 – 14:00-14:45

Learn how Jet Reports can be used to increase your financial and operational reporting capabilities from Business Central.

Register Here

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

What’s New in Business Central 2024 Wave 1

Monday, 20th May 2024 – 14:00-14:45

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

Register Here

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

Upgrading (to) Business Central

Tuesday, 18th June 2024 – 14:00-14:45

Learn the ins and outs of upgrading NAV to Business Central and the steps to upgrade to new versions of Business Central.

Register Here

Error Preview or Posting Assembly Order in Microsoft Dynamics 365 Business Central: “Document No. must have a value in Item Journal Line…”

Microsoft Dynamics 365 Business CentralI was doing a project to implement Microsoft Dynamics 365 Business Central with a client recently. When they were doing some UAT they were getting an error when trying to preview or post an assembly order.

I tried the same process on my demo/test environment and did not get the same error as the we were seeing in the client environment. The error they were seeing was this one:

Error message when previewing or posting an assembly order

Document No. must have a value in Item Journal Line: Journal Template Name=, Journal Batch Name=, Line No. =0. It cannot be zero or empty

Continue reading “Error Preview or Posting Assembly Order in Microsoft Dynamics 365 Business Central: “Document No. must have a value in Item Journal Line…””

FritzBox and Other Machines No Longer Available by Name

I was trying to deal with a website issue the other day and started the NAS to access to some saved files. I usually do this using \\nas, but it didn’t work from the PC I was on. I started another PC and tried the same thing to see if it was a local issue, but had the exact same problem.

When I tried to ping the machine name, instead of an internal IP, it resolved to 45.76.93.104 instead.

I checked on the PiHole, which is what controls the DNS servers I use, and everything looked fine, so tried to log onto the router via the web browser, but found this also didn’t work. I tried the IP and was able to access the router settings without issue, and the DNS settings were pointing at the PiHole.

At this point I fell back to searching online and found an article from late January explaining the issue.

The problem is that the FritzBox uses the domain fritz.box, which is hardcoded.

The cause of this is that in mid-January the .box domain went live for registrations and someone, not the maker of the FritzBox router, has registered the fritz.box domain and created a website which the domain now resolves to, and takes precendent over the router itself (if you’re using third party DNS servers; I understand if you’re letting the FritzBox handle the DNS servers then things will continue to work).

It seems that the makers of the router, German company AVM, are in a sales process to purchase the domain, having become aware of the problem after someone else bought the domain; I presume they will then remove the DNS resolution so routers again work correctly.

In the meantime, you can use the IP of the FritzBox or of the machine to access them, neither of which is ideal. I’m not particularly experienced with DNS, but I’ve been told if you set the primary DNS server as the router then it will check this first and correctly resolve internal machine names and then use the secondary DNS server for the external domains.

I’ve not tested this approach as I found a setting on the PiHole which I could use to sort the problem without making the change to DNS servers.

In the PiHole admin, this the Local domain name (optional) field in Settings » DNS » Advanced DNS Settings » Conditional forwarding. I set this field to fritz.box, saved the settings and found that I could again navigate using machine names.