New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Prevent Editing Number Series on Service Documents and Cards

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 22nd of the new functionality in the section is Prevent editing number series on service documents and cards.

For each company where you set up service management, you must assign unique identification codes to things such as service items, invoices, and other documents. Numbering isn’t only important for identification purposes. A well-designed numbering system also makes the company more manageable and easier to analyze, and can reduce the number of errors that occur in data entry.

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

Feature Details

Behavior of the No. field on documents and cards

On service documents and all cards, the No. field can be filled in automatically from a predefined number series, or you can add it manually. However, under certain circumstances, the No. field isn’t available so that you can’t edit its value.

Invisible No. field

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Prevent Editing Number Series on Service Documents and Cards”

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Correct Errors in Service Invoices

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 21st of the new functionality in the Application section is correct errors in service invoices.

Mistakes can happen, so it’s important to be able to quickly correct them. This update enhances your flexibility and efficiency in managing service contracts and invoices by making it easier to fix mistakes.

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

Feature Details

You can delete service invoices that have service ledger entries associated with them. This means that you can correct errors or make changes to service invoices without getting stuck or losing data. For example, if you forget to assign a product posting group to a G/L account, you can add it later and recreate the service invoice.

Use the Delete action to delete a service invoice. A corrective service ledger entry will be posted, and the invoicing date and invoicing period will be restored in the service contract so you can create the invoice again. Note that you can revert several invoices, but you must do it sequentially starting from the very last invoice. Business Central won’t allow you to delete a service invoice if its details, such as the invoicing period or the prepaid toggle were changed in the related service contract. Make sure that you delete invoices before you make such changes.

My Opinion

this looks to be a useful enhancement for correcting errors. While we all want to avoid errors, sometimes they happen and an easy ay to correct them is welcome.

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
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
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 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
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

Working with Power Automate Child Flows: Series Index

Power AutomateAs I have a number of articles to write on Power Automate child flows, I’ve decided to break these out into a sub-series of the main Working with Power Automate series; they will appear as posts within both series in the order written, so you can easily access and read them from within either.

The series index, below, will automatically update if you’re reading the original article on azurecurve | Ramblings of an IT Professional. If you’re reading elsewhere, the original article, which will update automatically is here.

Working with Power Automate Child Flows

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Export and Import Multiline Text Using Configuration Packages

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 20th of the new functionality in the section is export and import multiline text using Configuration Packages.

Avoid having to manually export and import multiline text by using an improved configuration packages capability that allows you to do that with efficiency and ease. This feature is especially useful for businesses that deal with large amounts of multiline texts and need to transfer them between different companies or environments.

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

Feature Details

You can now use BLOB type fields, which usually contain multiline text, to import and export data using Configuration Packages.

Simply choose Include Field on the Config. Package Fields page to include fields that contain multiline text, such as the Work Description field, in your package.

Shows configuration package fields page with Work description (BLOB) field included

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Export and Import Multiline Text Using Configuration Packages”

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Manage Document Attachments in Service Items and Documents

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 19th of the new functionality in the section is manage document attachments in service items and documents.

Digitalize document management of service-related documents (such as maintenance manuals, warranty certificates, or inspection reports) by attaching them directly to service items, contracts, and invoices. Access critical documentation on the go, ensuring efficient service delivery.

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

Feature Details

In this release, Microsoft have made document attachments available on pages in Service Management. The Document Attachment FactBox is available in multiple places, like:

  • Service Item Card (page 5980 "Service Item Card")
  • Service Items (page 5981 "Service Item List")
  • Service Items (page 5988 "Service Items")
  • Service Contract (page 6050 "Service Contract")
  • Service Contracts (page 9321 "Service Contracts")
  • Service Contract Quote (page 6053 "Service Contract Quote")
  • Service Contract Quotes (page 9322 "Service Contract Quotes")
  • Service Credit Memo (page 5935 "Service Credit Memo")
  • Service Credit Memos (page 9320 "Service Credit Memos")
  • Service Invoice (page 5933 "Service Invoice")
  • Service Invoices (page 9319 "Service Invoices")
  • Service Order (page 5900 "Service Order")
  • Service Orders (page 9318 "Service Orders")
  • Service Lines (page 5905 "Service Lines")
  • Service Quote (page 5964 "Service Quote")
  • Service Quotes (page 9317 "Service Quotes")
  • Service Quote Lines (page 5966 "Service Quote Lines")
  • Posted Service Credit Memo (page 5972 "Posted Service Credit Memo")
  • Posted Service Credit Memos (page 5971 "Posted Service Credit Memos")
  • Posted Service Invoice (page 5978 "Posted Service Invoice")
  • Posted Service Invoices (page 5977 "Posted Service Invoices")
Service Item

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Manage Document Attachments in Service Items and Documents”

Function in Jet Reports to Get List into a String

Jet ReportsWhile working on a Jet Report for a client recently, working with data from Microsoft Dynamics 365 Business Central, I had need to return the output of an NL Filter into another function which required a string rather than a list, which meant that I couldn’t use the NL Filter directly.

Fortunately, there is a What in the NP Jet function which allows you to exactly this.

My NL Filter was in cell D4 which I can reference in the Array field of the NP function; the third field to set is the Join String which is the character which will separate the joined items from the list; you need to place the double quotes around the join string yourself:

Jet Function Wizard with a What of Join, Array of $D4 and Join String of "|"

Continue reading “Function in Jet Reports to Get List into a String”

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Find a Matching Record in a Power Automate Flow

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 5th of the new functionality in the Adapt faster with Power Platform section is find a matching record in a Power Automate flow.

Using Power Automate to build flows is already relatively easy, but from time to time, makers are stumbling into this common element of a given process: querying Business Central for a single record that matches certain criteria.

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

Feature Details

Currently, the Find records action always returns a collection or list of records, even if there’s only one record that matches specific criteria, such as the unique record ID. The current action also requires that Power Automate makers understand the syntax of the OData query.

The new Find one record action not only lets makers find a single record that matches their criteria, but also gives them a more friendly user interface to provide parameters and define conditions.

Makers can select several conditions for various fields in the requested API, add sorting conditions so that the proper record is found, and the Power Automate connector transforms these settings into an OData query.

Finding a single record also ensures that all subsequent actions in the flow can operate on it, without requiring the Apply to each loop.

note Note

This feature is only available in Business Central online, but it’s in the Power Platform connector so it’s backward compatible with all supported versions of Business Central.

A new Find one record action in Power Automate connector

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Find a Matching Record in a Power Automate Flow”

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Add Table and Field Mappings for Existing Integration Tables

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 4th of the new functionality in the Adapt faster with Power Platform section is add table and field mappings for existing integration tables.

Business needs change and so do business processes. Changes of business processes require data being exchanged through integrations with Business Central to be implemented in a fast and cost-effective way.

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

Feature Details

You can add new table mappings by choosing the New Table Mapping action on the Integration Table Mappings page.

Shows New Table Mapping action in Integration Table Mappings page

The action starts the New Integration Mappings assisted setup guide, which will help you set up new integration table and field mappings.

Shows New Integration Mappings guide page with a placeholder to enter new mapping name

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Add Table and Field Mappings for Existing Integration Tables”

Restoring the Quick Access in Windows 11 Explorer

WindowsI changed jobs last year which meant a new laptop to setup and configure as I need. I had most things configured as I wanted them when an update to Windows 11 came through and the quick access section in Explorer disappeared; this is a section to which you can pin folders to which you want quick access when using Windows Explorer.

It appears at the top of the left navigation pane, or used to appear there anyway. At first I thought Microsoft had removed it entirely, before realising that the options to add a folder to the quick access was still on the right click context menu, which was either a very sloppy change or evidence that the functionality was still present, albeit hidden:

Windows Explorer with the quick access section missing

Continue reading “Restoring the Quick Access in Windows 11 Explorer”

Create a Calculated Field in the Jet Reports Table Builder

Jet ReportsI’ve recently been creating some reports for a client using Jet Reports and data pulled from Microsoft Dynamics 365 Business Central. One of the requirements was to have a report which pulled out Intrastat related information in a specific format. As well as pulling out the standard information, they also wanted a calculation of the net weight for a sales order line, which mean linking from the Purch. Inv. Line (123) to the Item (27) table and multiplying the quantity by the net weight.

I initially tried to do this using a calculated field in the Excel PivotTable which was added on top of the data returned by Jet Reports, but quickly realised that the result wasn’t correct. This [prompted me to go back to the source data and see if I could perform the calculation using Jet Reports as it got the data rather than afterwards.

The report was being built using the Table Builder tool of Jet Reports; to add a calculated field in Table Builder, click the Add Formula button in the bottom left:

Table Builder with the Add Formula button ringed

Continue reading “Create a Calculated Field in the Jet Reports Table Builder”