This 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 4th of the new functionality in the Reporting and data analysis section is use built-in named formulas in Excel layouts.

Microsoft’re saving Excel report authors time and energy by providing built-in named formulas that make it easy to access data from metadata sheets.

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

Feature Details

To make it easier to use data from metadata sheets, named formulas are now built in to Excel layout workbooks (when generated in 2024 release wave 2). Instead of taking time to develop complicated VLOOKUP or XLOOKUP formulas, report authors can use named formulas, such as ReportRequest.Date or ReportMetaData.ReportHelpLink.

This article is part of the Using Extended Texts In Microsoft Dynamics 365 Business Central series, but articles within it will also be part of the ongoing In Microsoft Dynamics 365 Business Central (Financial), how do I… and In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

Extended texts can be added to G/L Accounts for use on sales and purchase transactions. To add an Extended Text to a G/L account, open the account card and then click the Related » Account » Other » Extended Texts action:

Continue reading “Using Extended Texts In Microsoft Dynamics 365 Business Central: Add Extended Texts to a G/L Account”

This 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 Legislation section is use multiple subcategories for one sustainability account.

By enabling the use of more diverse account subcategories for the sustainability account, users can reduce the number of different accounts needed and consolidate various types of information into a single account.

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

Feature Details

Users can set a default Sustainability Account Subcategory for each Sustainability Account, and this information must be included during setup. However, users can also configure multiple subcategories for a single account.

When working with Sustainability Journals, users can easily change the Sustainability Account Subcategory on each line if multiple options are available. This approach allows entries to be posted to the same Sustainability Accounts but with different emission factors in the formulas. For example, if a user wants to use one account for all company cars, they can handle different emission factors for different types of cars more easily. And using it this way, they can post all entries using only one account, but they can use subcategories as an additional analytic.

Additionally, users can now post entries to the Sustainability Ledger Entry even with zero emissions if their Sustainability Account Subcategories are marked as Renewable Energy. In this case, the system will post only the basic information used in the formula, but the total emissions will be zero, and the entry will be marked as Renewable Energy.

This 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 9th of the new functionality in the Governance and administration section is get external notifications when job queue entries fail.

Sometimes tasks, reports, or batch processes can take a long time to complete. To keep people productive in the meantime, companies often use Business Central’s job queue to run processes in the background. If something goes wrong and an important background process stops, or isn’t scheduled for some reason, being notified about the issue can help you react quickly to resolve it.

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

Feature Details

To be notified about issues with job queue processing, start by running the Set up Job Queue Notifications assisted setup guide from the Assisted Setup page. The guide will help you set up your notifications. Follow the steps as described in the Get notified about issues with job queue background processing release plan.

Choose Next on the second step to specify how to send notifications. In addition to In-product notifications, you can choose to manage your notifications through external business events by turning on the Control notifications with business events (preview) toggle.

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Get External Notifications When Job Queue Entries Fail”

This 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 Development section is specify and use full-text search indexes on table fields.

With the new full-text search metadata on table fields, AL developers can significantly enhance data search features, making them easier and faster for users. This feature improves user satisfaction and productivity by providing more precise and relevant search results.

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

Feature Details

p>As an AL developer, you can now specify which table fields are included in full-text search indexes on the database. By doing this, the following search features will be faster and provide better search capabilities:

• Companywide search (data search)
• List page search
• Lookup search

To specify full-text search, you set the OptimizeForTextSearch property on fields in tables or table extensions.

In AL code, you can also use a new && filter syntax in the SetFilter() method. For example:

FieldRef.SetFilter('&&' + SearchString + '*')

The new syntax supports a subset of SQL Server’s CONTAINS operator.

You can also use new OptimizedForTextSearch property on the Field virtual table and IsOptimizedForTextSearch on variables of the FieldRef data type.

This article is part of the Using Extended Texts In Microsoft Dynamics 365 Business Central series, but articles within it will also be part of the larger ongoing In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

Extended Texts can be used to add additional description or text to items, stock-keeping units, general ledger accounts and resources in Business Central.

All of these types of data allow descriptions to be added, but are typically limited to a maximum of one or two hundred characters. Sometimes, however, a longer description is required, and extended texts is how Business Central allows you to manage these extended descriptions.

Multiple extended texts of unlimited number of lines, although each line is limited to 100 characters, on a record are supported and they can be limited by a start and end date for when they are available; they can also be limited to the type of purchase or sales transaction to which they can be added.

In subsequent posts of this series, I will show how extended texts can be added to records as well as used on transactions in the purchasing and sales modules.

Using Extended Texts In Microsoft Dynamics 365 Business Central
What are Extended Texts?
Add Extended Texts to Items
Add Extended Texts to Stockkeepping Units
Enable Item Extended Texts to be Added to Transactions Automatically
Create a Purchasing Transaction with Manually Added Extended Texts
Create a Sales Transaction with Manually Added Extended Texts

This 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 Development section is remove friction when working with external app dependencies.

Resellers who develop per-tenant extensions for customers and publishers who create AppSource apps commonly build on the work of other publishers, and thereby take a dependency on these. In order to develop or test, they need access to the AppSource apps they depend on.

Today, this involves a tedious manual process where resellers and publishers with dependencies must contact publishers owning the applications they depend on and ask for symbols to develop against or runtime packages to test with. This is not only required once, but continuously as new versions of the Business Central first-party applications and the publishers’ applications emerge, making the process time-consuming and error-prone.

In this version Microsoft plan to unblock developing and compiling against external applications and test in online sandboxes.

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

Feature Details

In this release Microsoft add support for resellers and publishers to download symbols for AppSource applications to develop against, providing a public NuGet feed with packages containing symbols for AppSource applications. If you are using AL-Go for GitHub, then it will automatically locate and download these symbols during the build. You can also take advantage of AL-Go for GitHub to run tests in online sandboxes.

My Opinion

This sounds like a very useful enhancement, although I’m not too involved on the development side of Business Central.

This 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 14th of the new functionality in the Country and regional section is enable use of other currencies – Czechia.

Recent Czech legislation allows Czech companies to determine a functional currency and record their accounting in a currency other than Czech. It’s now possible to use a foreign currency for corporate accounting and to use the Additional Currency Reporting functionality for other records and reports that must be in Czech currency.

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

Feature Details

The new amendment to Act No. 563/1991 Coll., on Accounting, effective from January 1, 2024, introduces the concept of functional currency as the currency of accounting. Functional currency means the currency of the primary economic environment in which the entity operates and may be other than the Czech currency. The functional currency of an entity can be determined on the basis of the criteria for determining the functional currency under IFRS as governed by European Union law.

If the company decides to implement accounting in a foreign currency, then for other records and reports that must be in Czech currency, it uses the Additional Reporting Currencies functionality for reporting. However, this only deals with the creation of material items and VAT items, but not with subsequent reporting. All VAT reporting must be done in Czech currency (CZK), so the reporting functionalities have been adapted as follows:

• Preview of the VAT statement
• VAT control report
• VAT control report statistics
• VIES Declaration
• Export of the VAT statement
• Export of VAT control report
• Export of the VIES Declaration
• Printing the VAT statement (Report 11769)
• Printing of the Recording Obligation (Basis for VAT) and List of Tax Documents (Report 11756)
• Test report of the VAT Control Report (Report 31103)
• Test report of the VIES Declaration (Report 31064)

New VAT rate to additional reporting currency (Document Currency/Additional Reporting Currency) fields have been added to the purchase and sales documents to allow the currency rate to be adjusted if necessary. Similar functionality has been added to purchase and sales advances. The printing of document reports has also been modified.

This 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 Country and regional section is sales advance from the project – Czechia.

Creating Sales advances from Project can save users time and effort by reducing the need to manually enter data. Sales advances can be created for the entire project or only for a project task.

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

Feature Details

The process improves productivity and efficiency by allowing you to quickly and easily create sales advances for the entire project or only for a project task.

The project number is entered in the sales advance invoice and the project task number is also entered in the advance line. This link between the project and the advance allows you to determine the amounts of the advances with a link to the project.

However, there won’t be a linking (applying) of advances as with sales orders to ensure that the advance is automatically deducted when the invoice is created from the project. A factbox is added to the project card to show the number of advances created from the project and the amounts of advances total, to be paid and to be used.

This 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 Country and regional section is allocations functionality in Cash Desks – Czechia.

To make data entry efficient and reduce errors for recurring types of posting, you can use allocations to predefine how to distribute revenue for transactions or cost amounts across G/L accounts and dimensions. You can use allocation keys on cash desk document lines.

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

Feature Details

You can use allocation keys to automate the distribution of revenue or cost transactions in journals, sales documents, purchase documents and newly created cash desk documents. Allocation keys can trigger automatic G/L entry postings and allocations across different accounts and dimensions.

For example, allocation keys can automate postings related to payroll overhead. When posting total salary expenses at the end of the month, you can use automatic account codes to assign a percentage of the total salary to automatically post as overhead expenses. Or, you can use headcount per department to distribute the cost to the department-related dimension.

You can define your allocation keys based on:

• Fixed amounts
• Variable amounts (balance, net change)
• Statistical accounts (non-financial quantities you track through the Statistical Accounts feature)