New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Experience Enhancements To Chat With Copilot

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

The 13th of the new functionality in the Copilot and AI innovation section is experience enhancements to chat with Copilot.

For our customers, much of their workday revolves around chatting with coworkers, customers, and vendors to get insights and solve problems. Now, Dynamics 365 Copilot helps them continue the conversation in Business Central with AI-powered chat alongside their data. Copilot in Business Central transforms how people approach business applications by empowering workers to express themselves using their own language.

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

Feature Details

In this wave, Microsoft evolve chat with Copilot (first announced for 2024 release wave 1) based on community feedback:

  • Faster: Copilot fetches records more quickly.
  • Better at data inquiries: Copilot generates analysis tabs directly from the Chat pane to help you get to insights about your data. Copilot takes this approach whenever you ask questions that are best illustrated by grouped records or simple math such as totals or averages. Try entering, “In which countries are my top customers?”
    An example response from Copilot indicating handoff to the Analysis Assist feature
  • Awareness of the current page: Copilot responds to requests to find data from the currently open page, using its ability to filter, sort, and generate analysis tabs to help you get to insights. Try entering, “Which products are blue on the current page?” while the Items list page is open.
  • Interconnected AI: Copilot helps you understand how it can provide additional AI-powered assistance on the current page, identifying built-in features as well as extensions to Copilot. Try entering, “What can Copilot do on this page?”
  • More knowledgeable: Copilot uses more sources of information from Microsoft Learn to explain and guide. For example, it now searches learning paths and release plans.
  • More examples: The prompt guides (displayed at the bottom of the chat pane) include new example prompts and a link to tips and tricks to improve your prompt skills.
    The prompt guides menu, displaying example prompts grouped by their purpose

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Experience Enhancements To Chat With Copilot”

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Display Errors And Messages In Copilot Prompt Dialogs

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

The 12th of the new functionality in the Copilot and AI innovation section is display errors and messages in Copilot prompt dialogs.

Users learning to work with Copilot often need a simple and effective feedback loop to help them experiment and make the most out of their AI-powered assistant.

Copilot features that display a prompt dialog can now show errors and messages directly inside the dialog. While prompt dialogs aren’t intended for conversational experiences, the integrated feedback keeps users focused on the dialog without distraction.

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

Feature Details

Errors and messages that are thrown by the code logic in Copilot prompt dialogs now surface directly inside the dialog rather than in a separate pop-up dialog. There’s no additional work required by developers to enable this feature, apart from authoring proper error handling and warnings as you already do today. Both the classic Dialog.Error() and Dialog.Message(), as well as the newer ErrorInfo patterns are supported. In the case of the latter, the title and description will both be shown.

If the code throws more than one message, only the latest will be shown, but the user is told that there were multiple issues. Also, as has already been the case, if an error is thrown, a subsequent message will be suppressed. If the error or message contains line breaks, these are ignored, as opposed to rendering in dialogs.

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Display Errors And Messages In Copilot Prompt Dialogs”

Location Error Entering an Assembly Order in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business CentralWhile working with a client to help them implement Microsoft Dynamics 365 Business Central they reported an error to me when trying to process an assembly order in the Assembly Orders (902) page. When they entered the details of the assembly and clicked post, they received an error message:

Error dialog when trying to post an assembly order

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

Continue reading “Location Error Entering an Assembly Order in Microsoft Dynamics 365 Business Central”

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Raise Awareness Of Copilot Actions On Card, Document, And Listplus Pages

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

The 11th of the new functionality in the Copilot and AI innovation section is raise awareness of Copilot actions on Card, Document, and ListPlus pages.

In 2024 release wave 1, the developer tools for Copilot in Business Central introduced Copilot prompt actions, a new way to draw attention to Copilot capabilities in your extensions. A prompt action is a standard action, which is rendered with greater prominence on the page, such as in a floating bar, and is connected to the Copilot brand.

In the first iteration, Business Central supported Copilot prompt actions on List, ListPart, Worksheet, and StandardDialog page types. To help with more Copilot experiences and address partner feedback, we’re now introducing support for Copilot prompt actions on Card, Document, and ListPlus page types.

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

Feature Details

You can now use Copilot prompt actions on Card, Document, and ListPlus page types to nudge users to use your Copilots on such pages. The required AL code follows the same model as when adding Copilot prompt actions to list pages.

As an example, this code adds four prompt actions to the Customer Card via a page extension, where two of the Copilot prompt actions are nested in a group.

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Raise Awareness Of Copilot Actions On Card, Document, And Listplus Pages”

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Use A Default Quantity Of 1 For Accounts On Documents

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

The 22nd of the new functionality in the Application section is use a default quantity of 1 for accounts on documents.

Some people prefer to enter a specific quantity on document lines, while others like to have a default value entered for them that they can overwrite. To accommodate the latter preference, Business Central lets you specify that you want lines for general ledger accounts on sales documents to have a quantity of 1 by default.

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

Feature Details

Default values on documents can speed up data entry. If you want new lines for general ledger accounts on sales and purchase documents to have a quantity of 1 by default, on the Sales & Receivables Setup and Purchase & Payables Setup pages, turn on the Default G/L Account Quantity toggle .

New field for default quantity of 1 for G/L Account lines

My Opinion

A small change, but a nice level of control for when adding purchase or sales documents using a G/L account. I can see a few clients using this, especially on the purchasing side for overhead invoices.

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

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2
Auto-Apply Templates When You Synchronize Data With Dataverse
Use New Reports And Demo Data for Financial Reporting
Manage Subscription Billing and Revenue and Expense Recognition
Integrate Field Service with Service Management
Archive Service Management Documents
View Item Availability in Field Service Work Orders
Export Posted Sales Invoices to Shopify
Replenish Items for Projects
Reconcile Payment Transactions in Shopify with Invoices
Use Directed Put-Away and Pick Warehouses with Projects
Capture Data from E-Docs with Azure AI Document Intelligence
Add Invoice and Receipt Documents to E-Documents in Bulk
Import, Export Product Info Using Shopify Metafields
Define Shipping Information For Shopify Shipping Fees
Enable Locations In Shopify Refunds
See Improved Usability For Service And Projects
Allow More Than One User To Post Warehouse Entries at a Time
Add An Item As A Shopify Variant
Use Excel Reports For Consolidation And Fixed Assets
Synchronize Product Translations To Shopify
Use Specific Prices And Discounts When Synchronizing Prices In Shopify
Add Extended Text To Project Planning Lines
Use A Default Quantity Of 1 For Accounts On Documents
Suggest Number Series with Copilot
Chat with Copilot and Learn to Use Installed Add-On Apps
Complete Bank Account Reconciliation Faster with Copilot
Create Product Information Faster with Copilot
Summarize Any Record with Copilot
Experience Enhancements to Analysis Assist with Copilot
Start Using Copilot Without Having to Set Things Up
Create Sales Lines Easily with Copilot
Automate Tests for Your Copilot Extensions with the Business Central Test Toolkit
Start Creating Power Automate Flows With Copilot
Raise Awareness Of Copilot Actions On Card, Document, And Listplus Pages
Display Errors And Messages In Copilot Prompt Dialogs
Experience Enhancements To Chat With Copilot
Get Usage Telemetry On Copilot Extensions As An ISV
Start Using Integration with IRS for 1099 Submissions
Start Using E-Documents Framework Localized for Germany
Enable Additional Countries and Regions
Show Features With Demo Dataset For Czechia
Deferral Accounting – Posting The Original Amount As Correction – Czechia
Posting Of Alternative Customer-Vendor Posting Groups – Czechia
Calculate And Post Vat Settlement By Activity Code – Italy
Advance Letters With Reverse Charge – Czechia
Vat Return Feature Now Available – Czechia
Include Employee Transactions In Exchange Rate Adjustment Report – Czechia
Improve Vat Reporting And Adjustments – Czechia
Allocations Functionality In Cash Desks – Czechia
Sales Advance From The Project – Czechia
Enable Use Of Other Currencies – Czechia
Set Up Easier In-Client Performance Profiling with Rules
Use the Ternary Operator when Coding in the AL Language
Pull Extension Source from GitHub when Opening Visual Studio Code from the Web Client
Use the 'This' Keyword for CodeUnit Self Reference
Restore Extensions if Publishing from Visual Studio Code Fails
Use Improved Features for Report Documents
Package Resources in Extensions and Access from AL
Run Code Action for 'With' for File, Project, or Workspace
Type Testing and Casting Operators for Interfaces
Extend Al Interfaces
Extend and Customize Profiles from Other Extensions
Remove Friction When Working With External App Dependencies
Specify And Use Full-Text Search Indexes On Table Fields
Manage Environment Updates More Flexibly
Migrate Record Links and Notes with Cloud Migration Tooling
Manage Per-Tenant Extensions in Admin Center
View App Compatibility with Future Versions in Admin Center
Get Notified About Issues with Job Queue Background Processing
Get List of Manageable Environments for Microsoft Entra Apps
Support IPv6 for Enhanced Security and Scalability
Encrypt Data At-Rest With Customer-Managed Encryption Key
Get External Notifications When Job Queue Entries Fail
Use E-Documents with Power Automate
Use Multiple VAT Numbers for a Customer
Achieve Sustainability Scorecards and Goals
Navigate the Sustainability Manager Role Center with Ease
Add Attachments When You Send Electronic Documents
Record Greenhouse Gas Emissions Using Purchase Invoices
Report Sustainability Entries with Financial Reports
Use New Service Providers in the E-Documents Framework
Purchase Carbon Credits
Enable Internal Carbon Fee Calculation in Sustainability
Track Sustainability Certificates For Items And Vendors
Use Multiple Subcategories For One Sustainability Account
Use Embedded Power Bi Reports Out Of The Box
Do Ad Hoc Analysis On Fixed Assets, Projects, And Services
Use Advanced Settings In The Power Bi Connector
Use Built-In Named Formulas In Excel Layouts
Access Keys with Key Tips In More Languages
Use Drag and Drop On File Upload Dialog to Attach Multiple Files
Resize Columns Even when Personalization isn't Enabled
Change The Data Search Method In Lists

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Add Extended Text To Project Planning Lines

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

The 21st of the new functionality in the Application section is add extended text to project planning lines.

Add detailed, customized information to project planning lines for items, resources, standard text, and general ledger accounts. You can use extended text to communicate information about special prices, terms, or instructions for your projects with your customers, vendors, and employees.

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

Feature Details

You can extend the description for items, general ledger accounts, and resources by adding extra lines as extended text on purchase and sales documents. Now, you can add extra lines on project planning lines. You can have multiple extended texts, and automatically or manually add them to documents using criteria that gives you an extra capability to communicate important information to customers, vendors, and employees.

For example, you can automatically add a particular text, such as details about a special price, to project planning lines on all your German projects for a limited period.

To define extended text for an item

  1. Open the card for an item that you want to add extended text to, and then choose the Extended Text action.
  2. Choose New.
  3. Fill in the Code and Description fields.
  4. If you want to apply extended text only for projects in a specific language, fill in the Language Code field. To use all language codes, select the All Language Codes checkbox.
  5. To limit the dates on which the extended text is used, fill in the Starting Date and Ending Date fields. The Document Date defined in the project planning line is used as a filter.
  6. In the Text field, write the extended text.
  7. Select the relevant checkboxes for the document types where you want the extended text printed. To include projects, select Projects on the Sales FastTab.
  8. Close the page.

You can activate the Automatic Ext. Texts to automatically add an extended text on sales, purchases, or project documents for an item. You can also add the extended text to documents manually.

To add an extended item text on a project planning line

  1. Open a project, and then choose a project task with a line for an item that has extended text.
  2. Select the line, and then choose the Insert Ext. Text action.

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

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2
Auto-Apply Templates When You Synchronize Data With Dataverse
Use New Reports And Demo Data for Financial Reporting
Manage Subscription Billing and Revenue and Expense Recognition
Integrate Field Service with Service Management
Archive Service Management Documents
View Item Availability in Field Service Work Orders
Export Posted Sales Invoices to Shopify
Replenish Items for Projects
Reconcile Payment Transactions in Shopify with Invoices
Use Directed Put-Away and Pick Warehouses with Projects
Capture Data from E-Docs with Azure AI Document Intelligence
Add Invoice and Receipt Documents to E-Documents in Bulk
Import, Export Product Info Using Shopify Metafields
Define Shipping Information For Shopify Shipping Fees
Enable Locations In Shopify Refunds
See Improved Usability For Service And Projects
Allow More Than One User To Post Warehouse Entries at a Time
Add An Item As A Shopify Variant
Use Excel Reports For Consolidation And Fixed Assets
Synchronize Product Translations To Shopify
Use Specific Prices And Discounts When Synchronizing Prices In Shopify
Add Extended Text To Project Planning Lines
Use A Default Quantity Of 1 For Accounts On Documents
Suggest Number Series with Copilot
Chat with Copilot and Learn to Use Installed Add-On Apps
Complete Bank Account Reconciliation Faster with Copilot
Create Product Information Faster with Copilot
Summarize Any Record with Copilot
Experience Enhancements to Analysis Assist with Copilot
Start Using Copilot Without Having to Set Things Up
Create Sales Lines Easily with Copilot
Automate Tests for Your Copilot Extensions with the Business Central Test Toolkit
Start Creating Power Automate Flows With Copilot
Raise Awareness Of Copilot Actions On Card, Document, And Listplus Pages
Display Errors And Messages In Copilot Prompt Dialogs
Experience Enhancements To Chat With Copilot
Get Usage Telemetry On Copilot Extensions As An ISV
Start Using Integration with IRS for 1099 Submissions
Start Using E-Documents Framework Localized for Germany
Enable Additional Countries and Regions
Show Features With Demo Dataset For Czechia
Deferral Accounting – Posting The Original Amount As Correction – Czechia
Posting Of Alternative Customer-Vendor Posting Groups – Czechia
Calculate And Post Vat Settlement By Activity Code – Italy
Advance Letters With Reverse Charge – Czechia
Vat Return Feature Now Available – Czechia
Include Employee Transactions In Exchange Rate Adjustment Report – Czechia
Improve Vat Reporting And Adjustments – Czechia
Allocations Functionality In Cash Desks – Czechia
Sales Advance From The Project – Czechia
Enable Use Of Other Currencies – Czechia
Set Up Easier In-Client Performance Profiling with Rules
Use the Ternary Operator when Coding in the AL Language
Pull Extension Source from GitHub when Opening Visual Studio Code from the Web Client
Use the 'This' Keyword for CodeUnit Self Reference
Restore Extensions if Publishing from Visual Studio Code Fails
Use Improved Features for Report Documents
Package Resources in Extensions and Access from AL
Run Code Action for 'With' for File, Project, or Workspace
Type Testing and Casting Operators for Interfaces
Extend Al Interfaces
Extend and Customize Profiles from Other Extensions
Remove Friction When Working With External App Dependencies
Specify And Use Full-Text Search Indexes On Table Fields
Manage Environment Updates More Flexibly
Migrate Record Links and Notes with Cloud Migration Tooling
Manage Per-Tenant Extensions in Admin Center
View App Compatibility with Future Versions in Admin Center
Get Notified About Issues with Job Queue Background Processing
Get List of Manageable Environments for Microsoft Entra Apps
Support IPv6 for Enhanced Security and Scalability
Encrypt Data At-Rest With Customer-Managed Encryption Key
Get External Notifications When Job Queue Entries Fail
Use E-Documents with Power Automate
Use Multiple VAT Numbers for a Customer
Achieve Sustainability Scorecards and Goals
Navigate the Sustainability Manager Role Center with Ease
Add Attachments When You Send Electronic Documents
Record Greenhouse Gas Emissions Using Purchase Invoices
Report Sustainability Entries with Financial Reports
Use New Service Providers in the E-Documents Framework
Purchase Carbon Credits
Enable Internal Carbon Fee Calculation in Sustainability
Track Sustainability Certificates For Items And Vendors
Use Multiple Subcategories For One Sustainability Account
Use Embedded Power Bi Reports Out Of The Box
Do Ad Hoc Analysis On Fixed Assets, Projects, And Services
Use Advanced Settings In The Power Bi Connector
Use Built-In Named Formulas In Excel Layouts
Access Keys with Key Tips In More Languages
Use Drag and Drop On File Upload Dialog to Attach Multiple Files
Resize Columns Even when Personalization isn't Enabled
Change The Data Search Method In Lists

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Use Specific Prices And Discounts When Synchronizing Prices In Shopify

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

The 20th of the new functionality in the Application section is use specific prices and discounts when synchronizing prices in Shopify.

The latest release of the Shopify connector adds individual prices and discounts that complement the global and customer price group/customer discount group prices and discounts. Individual prices and discounts give you more flexibility and personalization for B2B customers.

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

Feature Details

If you use Shopify B2B, you can configure the connector to synchronize prices for Shopify catalogs that are linked to B2B customers. The following steps explain the process.

Sync catalogs from Shopify

  1. Select the Tell Me icon, enter Shopify Catalogs, and select the related link.
  2. Select Get Catalogs.
  3. Select the entry for which to define and export prices, and then fill in the fields as necessary.

You can use two strategies. One is the default strategy, where you can use settings similar to the ones for synchronizing the Price and Compare at Price fields for Shopify products (Shopify variant). The following table describes settings for the default strategy.

Field Description
Customer Price Group Determine the price for an item in Shopify. The sales price of this customer price group is taken. If no group is specified, the price on the item card is used.
Customer Discount Group Determine the discount to use when calculating the price of an item in Shopify. Discounted prices are stored in the Price field and the full price is stored in the Compare at Price field.
Allow Line Disc. Specifies whether you allow a line discount when calculating prices for Shopify. This setting applies only for prices on the item. Prices for the customer price group have their own toggle on lines.
Prices including VAT Specifies whether price calculations for Shopify include VAT.
VAT Business Posting Group Specifies which VAT business posting group is used to calculate prices in Shopify. This should be the group you use for domestic customers.

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Use Specific Prices And Discounts When Synchronizing Prices In Shopify”

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Synchronize Product Translations To Shopify

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

The 19th of the new functionality in the Application section is synchronize product translations to Shopify.

Automatically synchronizing translations from Business Central to Shopify guarantees consistent product descriptions and details across various languages. Offering customers product information in their native language enhances accessibility and satisfaction, which can boost conversion rates and foster customer loyalty.

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

Feature Details

To include translations to the product synchronization, follow these steps:

  1. Choose the Tell Me icon, enter Shopify shops, and choose the related link.
  2. Select the shop to open the Shopify Shop Card page.
  3. To open the Shopify Languages page, choose the Languages action.
  4. To import languages enabled on Shopify, choose the Refresh action. Notice that the primary language isn’t be listed. For the primary language, continue to use the Language Code field in the Shopify Shop Card.
  5. For each language you want to include ino synchronization, fill in the Language Code field and turn on the Sync translations toggle.

That’s it. Translations are included every time you run the Sync Product task either manually or by using the job queue.

More information

  • A new Shopify permission (scope) is needed: read_locales. You must request a new access token.
  • The first export of items, initiated by the Add item to Shopify action, doesn’t include translations. You need to run Sync product and turn on the Can Update Shopify Products toggle.
  • Marketing text is only added for the primary language.
  • Extended texts are added for each language, plus extended texts where the All Languages toggle is turned on.
  • Attributes are added for each language. If a translation is missing, the primary language is used.
  • Item translations are added for each language if a translation is defined.
  • Variant translations aren’t used because the connector only exports the variant code, and not its description.

Extensibility impact

The CreateProductBody procedure in the Product Export codeunit takes language codes as parameters so it can be used for each language. Now this procedure is called multiple times according to the list of selected languages. Because it contains the OnBeforeCreateProductBodyHtml and OnAfterCreateProductBodyHtml events, those events are now triggered multiple times per item. The events now include the language code as a parameter, so you can skip translation or add your own logic.

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

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2
Auto-Apply Templates When You Synchronize Data With Dataverse
Use New Reports And Demo Data for Financial Reporting
Manage Subscription Billing and Revenue and Expense Recognition
Integrate Field Service with Service Management
Archive Service Management Documents
View Item Availability in Field Service Work Orders
Export Posted Sales Invoices to Shopify
Replenish Items for Projects
Reconcile Payment Transactions in Shopify with Invoices
Use Directed Put-Away and Pick Warehouses with Projects
Capture Data from E-Docs with Azure AI Document Intelligence
Add Invoice and Receipt Documents to E-Documents in Bulk
Import, Export Product Info Using Shopify Metafields
Define Shipping Information For Shopify Shipping Fees
Enable Locations In Shopify Refunds
See Improved Usability For Service And Projects
Allow More Than One User To Post Warehouse Entries at a Time
Add An Item As A Shopify Variant
Use Excel Reports For Consolidation And Fixed Assets
Synchronize Product Translations To Shopify
Use Specific Prices And Discounts When Synchronizing Prices In Shopify
Add Extended Text To Project Planning Lines
Use A Default Quantity Of 1 For Accounts On Documents
Suggest Number Series with Copilot
Chat with Copilot and Learn to Use Installed Add-On Apps
Complete Bank Account Reconciliation Faster with Copilot
Create Product Information Faster with Copilot
Summarize Any Record with Copilot
Experience Enhancements to Analysis Assist with Copilot
Start Using Copilot Without Having to Set Things Up
Create Sales Lines Easily with Copilot
Automate Tests for Your Copilot Extensions with the Business Central Test Toolkit
Start Creating Power Automate Flows With Copilot
Raise Awareness Of Copilot Actions On Card, Document, And Listplus Pages
Display Errors And Messages In Copilot Prompt Dialogs
Experience Enhancements To Chat With Copilot
Get Usage Telemetry On Copilot Extensions As An ISV
Start Using Integration with IRS for 1099 Submissions
Start Using E-Documents Framework Localized for Germany
Enable Additional Countries and Regions
Show Features With Demo Dataset For Czechia
Deferral Accounting – Posting The Original Amount As Correction – Czechia
Posting Of Alternative Customer-Vendor Posting Groups – Czechia
Calculate And Post Vat Settlement By Activity Code – Italy
Advance Letters With Reverse Charge – Czechia
Vat Return Feature Now Available – Czechia
Include Employee Transactions In Exchange Rate Adjustment Report – Czechia
Improve Vat Reporting And Adjustments – Czechia
Allocations Functionality In Cash Desks – Czechia
Sales Advance From The Project – Czechia
Enable Use Of Other Currencies – Czechia
Set Up Easier In-Client Performance Profiling with Rules
Use the Ternary Operator when Coding in the AL Language
Pull Extension Source from GitHub when Opening Visual Studio Code from the Web Client
Use the 'This' Keyword for CodeUnit Self Reference
Restore Extensions if Publishing from Visual Studio Code Fails
Use Improved Features for Report Documents
Package Resources in Extensions and Access from AL
Run Code Action for 'With' for File, Project, or Workspace
Type Testing and Casting Operators for Interfaces
Extend Al Interfaces
Extend and Customize Profiles from Other Extensions
Remove Friction When Working With External App Dependencies
Specify And Use Full-Text Search Indexes On Table Fields
Manage Environment Updates More Flexibly
Migrate Record Links and Notes with Cloud Migration Tooling
Manage Per-Tenant Extensions in Admin Center
View App Compatibility with Future Versions in Admin Center
Get Notified About Issues with Job Queue Background Processing
Get List of Manageable Environments for Microsoft Entra Apps
Support IPv6 for Enhanced Security and Scalability
Encrypt Data At-Rest With Customer-Managed Encryption Key
Get External Notifications When Job Queue Entries Fail
Use E-Documents with Power Automate
Use Multiple VAT Numbers for a Customer
Achieve Sustainability Scorecards and Goals
Navigate the Sustainability Manager Role Center with Ease
Add Attachments When You Send Electronic Documents
Record Greenhouse Gas Emissions Using Purchase Invoices
Report Sustainability Entries with Financial Reports
Use New Service Providers in the E-Documents Framework
Purchase Carbon Credits
Enable Internal Carbon Fee Calculation in Sustainability
Track Sustainability Certificates For Items And Vendors
Use Multiple Subcategories For One Sustainability Account
Use Embedded Power Bi Reports Out Of The Box
Do Ad Hoc Analysis On Fixed Assets, Projects, And Services
Use Advanced Settings In The Power Bi Connector
Use Built-In Named Formulas In Excel Layouts
Access Keys with Key Tips In More Languages
Use Drag and Drop On File Upload Dialog to Attach Multiple Files
Resize Columns Even when Personalization isn't Enabled
Change The Data Search Method In Lists

Error Importing Sales Invoice into Microsoft Dynamics 365 Business Central Using a Configuration Package: “Attempted to divide by zero”

Microsoft Dynamics 365 Business CentralI was working on a client project recently to help them implement Microsoft Dynamics 365 Business Central. We encountered an error when using a configuration package to import the customers opening balances as sales invoices.

I haven’t yet covered configuration packages in my In Microsoft Dynamics 365 Business Central, how do I… series, but should be doing so fairly soon. Configuration Packages, formerly known as RapidStart, is a tool which allows you to import (or export) data to Business Central from a Microsoft Excel spreadsheet.

We had created a configuration package to update the Gen. Journal Line (81) table which holds the sales journals, selected the fields to import, populated the sheet and run the import, but when we validated the file we were presented with three errors:

Config. Package Errors - Gen. Journal Line

Attempted to divide by zero

Continue reading “Error Importing Sales Invoice into Microsoft Dynamics 365 Business Central Using a Configuration Package: “Attempted to divide by zero””

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Use Excel Reports For Consolidation And Fixed Assets

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

The 18th of the new functionality in the Application section is use Excel reports for consolidation and fixed assets.

Excel reports give you the underlying data that they’re based on, so that you can reformat the data to build a custom report—for example, to get a specific insight or for troubleshooting.

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

Feature Details

In this release Microsoft have added four Excel report layouts that cover the consolidation and fixed assets areas:

  • Consolidated Trial Balance (Preview)
  • Fixed Asset Details (Preview)
  • Fixed Asset Analysis (Preview)
  • Fixed Asset Projected Value (Preview)

The report layouts are available through search and the Accountant home page.

The content of each report covers the content of one or more existing RDLC reports, and gives you the underlying data so you can create custom reports.

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

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2
Auto-Apply Templates When You Synchronize Data With Dataverse
Use New Reports And Demo Data for Financial Reporting
Manage Subscription Billing and Revenue and Expense Recognition
Integrate Field Service with Service Management
Archive Service Management Documents
View Item Availability in Field Service Work Orders
Export Posted Sales Invoices to Shopify
Replenish Items for Projects
Reconcile Payment Transactions in Shopify with Invoices
Use Directed Put-Away and Pick Warehouses with Projects
Capture Data from E-Docs with Azure AI Document Intelligence
Add Invoice and Receipt Documents to E-Documents in Bulk
Import, Export Product Info Using Shopify Metafields
Define Shipping Information For Shopify Shipping Fees
Enable Locations In Shopify Refunds
See Improved Usability For Service And Projects
Allow More Than One User To Post Warehouse Entries at a Time
Add An Item As A Shopify Variant
Use Excel Reports For Consolidation And Fixed Assets
Synchronize Product Translations To Shopify
Use Specific Prices And Discounts When Synchronizing Prices In Shopify
Add Extended Text To Project Planning Lines
Use A Default Quantity Of 1 For Accounts On Documents
Suggest Number Series with Copilot
Chat with Copilot and Learn to Use Installed Add-On Apps
Complete Bank Account Reconciliation Faster with Copilot
Create Product Information Faster with Copilot
Summarize Any Record with Copilot
Experience Enhancements to Analysis Assist with Copilot
Start Using Copilot Without Having to Set Things Up
Create Sales Lines Easily with Copilot
Automate Tests for Your Copilot Extensions with the Business Central Test Toolkit
Start Creating Power Automate Flows With Copilot
Raise Awareness Of Copilot Actions On Card, Document, And Listplus Pages
Display Errors And Messages In Copilot Prompt Dialogs
Experience Enhancements To Chat With Copilot
Get Usage Telemetry On Copilot Extensions As An ISV
Start Using Integration with IRS for 1099 Submissions
Start Using E-Documents Framework Localized for Germany
Enable Additional Countries and Regions
Show Features With Demo Dataset For Czechia
Deferral Accounting – Posting The Original Amount As Correction – Czechia
Posting Of Alternative Customer-Vendor Posting Groups – Czechia
Calculate And Post Vat Settlement By Activity Code – Italy
Advance Letters With Reverse Charge – Czechia
Vat Return Feature Now Available – Czechia
Include Employee Transactions In Exchange Rate Adjustment Report – Czechia
Improve Vat Reporting And Adjustments – Czechia
Allocations Functionality In Cash Desks – Czechia
Sales Advance From The Project – Czechia
Enable Use Of Other Currencies – Czechia
Set Up Easier In-Client Performance Profiling with Rules
Use the Ternary Operator when Coding in the AL Language
Pull Extension Source from GitHub when Opening Visual Studio Code from the Web Client
Use the 'This' Keyword for CodeUnit Self Reference
Restore Extensions if Publishing from Visual Studio Code Fails
Use Improved Features for Report Documents
Package Resources in Extensions and Access from AL
Run Code Action for 'With' for File, Project, or Workspace
Type Testing and Casting Operators for Interfaces
Extend Al Interfaces
Extend and Customize Profiles from Other Extensions
Remove Friction When Working With External App Dependencies
Specify And Use Full-Text Search Indexes On Table Fields
Manage Environment Updates More Flexibly
Migrate Record Links and Notes with Cloud Migration Tooling
Manage Per-Tenant Extensions in Admin Center
View App Compatibility with Future Versions in Admin Center
Get Notified About Issues with Job Queue Background Processing
Get List of Manageable Environments for Microsoft Entra Apps
Support IPv6 for Enhanced Security and Scalability
Encrypt Data At-Rest With Customer-Managed Encryption Key
Get External Notifications When Job Queue Entries Fail
Use E-Documents with Power Automate
Use Multiple VAT Numbers for a Customer
Achieve Sustainability Scorecards and Goals
Navigate the Sustainability Manager Role Center with Ease
Add Attachments When You Send Electronic Documents
Record Greenhouse Gas Emissions Using Purchase Invoices
Report Sustainability Entries with Financial Reports
Use New Service Providers in the E-Documents Framework
Purchase Carbon Credits
Enable Internal Carbon Fee Calculation in Sustainability
Track Sustainability Certificates For Items And Vendors
Use Multiple Subcategories For One Sustainability Account
Use Embedded Power Bi Reports Out Of The Box
Do Ad Hoc Analysis On Fixed Assets, Projects, And Services
Use Advanced Settings In The Power Bi Connector
Use Built-In Named Formulas In Excel Layouts
Access Keys with Key Tips In More Languages
Use Drag and Drop On File Upload Dialog to Attach Multiple Files
Resize Columns Even when Personalization isn't Enabled
Change The Data Search Method In Lists