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

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

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

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 17th of the new functionality in the Application section is add an item as a Shopify variant.

The new release of the Shopify connector allows you to export items from Business Central as variants in Shopify. This gives you more flexibility and convenience when you manage product information across both applications.

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

Feature Details

Shopify and Business Central both offer extensive features for managing products and variants. Depending on your needs, you can choose different options. In Shopify, where you focus on convenience for customers, and in Business Central, where other criteria are taken into consideration, such as the ability to define an assembly BOM.

Microsoft are adding support for export scenarios when Shopify has products with variants, but the list of items is flat on the Business Central side. You can use the Add item as Variant action on the Variants subpage of the Shopify Products page.

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Add An Item As A Shopify Variant”

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 16th of the new functionality in the Application section is allow more than one user to post warehouse entries at a time.

In busy warehouses where lots of things are moving around, it’s important that warehouse employees don’t get in each other’s way or slow each other down. That includes registering their activities in Business Central. Multiple workers can now work on transactions that involve warehouse entries without locking each other out, which means less waiting time and more productivity.

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

Feature Details

To avoid the warehouse entry table being locked while warehouse employees posts transactions, Microsoft now use a number sequence to assign entry numbers to warehouse entries and entries in the Warehouse Register table. This feature is controlled by a feature key, which is enabled by default. However, you can turn it off if needed—for example, if you have an extension that requires the previous behavior.

My Opinion

It seems odd that only one user could post warehouse entries at a time, so it is good to see this restriction lifted. The backward compatibility option is a nice touch for anyone who does need the old processes maintained.