Tag: Microsoft Dynamics 365 Business Central 2023 Wave 1

This post is part of the In Microsoft Dynamics 365 Business Central (Financial), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

After creating the general business posting groups, the next element to create is the general product posting group, which is the “what” part of the key combination to the general posting setup. There “what” is often something like retail/trade/services.

To configure, search for general product posting groups and enter the Code and Description for each of the required general product posting groups:

Enter a Code and Description for each of the codes; you can also enter a Default VAT Business Posting Group and whether this should Auto Inert the Default.

As Business Central saves as you work, you can just close the page when all of the required codes have been entered.

This post is part of the In Microsoft Dynamics 365 Business Central (Financial), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

To configure the setup for general posting roups requires three steps, which I’ll start covering in the first post of this series and complete in the next two.

The first element to configure is the general business posting group, which is the “who” part of the key to the general posting setup. This is often setup for regional groups such as domestic, European or ROW (Rest of World).

To configure, do a search for and select the General Business Posting Group page:

Enter a Code and Description for each of the codes; you can also enter a Default VAT Business Posting Group and whether this should Auto Inert the Default.

As Business Central saves as you work, you can just close the page when all of the required codes have been entered.

This post is part of the In Microsoft Dynamics 365 Business Central (Administration), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

On reflection, the terminology in the post on understanding posting groups, isn’t all that clear. It uses terminology similar to the official terminology from Microsoft and it took me a while to determine and properly understand what they meant.

In the UK, Tax Posting Groups are known as VAT Posting Groups and like the general posting groups, the VAT posting groups use a combination of business and product posting groups in combination which determine the VAT code and rate which should be applied.

For example, you might have a VAT Business Posting Group of UK and a VAT Product Posting Group of S which combine to give the rate of 20%, which is setup in the Tax Posting Setup.

This post is part of the In Microsoft Dynamics 365 Business Central (Administration), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

On reflection, the terminology in the post on understanding posting groups, isn’t all that clear. It uses terminology similar to the official terminology from Microsoft and it took me a while to determine and properly understand what they meant.

At the simplest level, a specific posting group, such as the Vendor Posting Group, is used to determine the accounts which would always be the same for the record type. In the case of vendors, this would be the accounts payable control account, discount, rounding accounts and so on.

The Inventory Posting Groups are slightly different as they can be combined with the location to allow different G/L accounts per site to be used.

This post is part of the In Microsoft Dynamics 365 Business Central (Administration), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

On reflection, the terminology in the post on understanding posting groups, isn’t all that clear. It uses terminology similar to the official terminology from Microsoft and it took me a while to determine and properly understand what they meant.

There are two connected elements to the general posting groups:

1. The General Business Posting Group defines to whom you are selling; for example, you might define this based on country or sector.
2. The General Product Posting Group defines what you are selling; for example, the type of product, such as fashion or furniture or retail or trade.

The combination of the business and product general posting groups then determine the posting setup (i.e. the accounts used for the combination).

This post is part of the In Microsoft Dynamics 365 Business Central (Administration), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

Posting groups are how Dynamics BC determines to which G/L accounts transactions are posted. They work by mapping entities, such as customers, vendors, items, sale documents, purchasing documents and so on, to the G/L accounts in order to save time and reduce errors.

There are three types of posting group in Dynamics BC:

1. General posting groups are used to define how transactions should be posted to the general ledger for a particular customer, vendor, item, or resource. They allow you to specify default accounts for different types of transactions based on the entity being used in the transaction. For example, you might use a General Posting Group to specify the default accounts for sales or purchases for a particular customer or vendor.
2. Specific posting groups which are used to specify how transactions should be posted to the general ledger for a particular item or resource. They allow you to define default accounts for different types of transactions involving a specific item or resource. For example, you might use a Specific Posting Group to specify the default accounts for inventory transactions for a particular item.
3. Tax which are used to specify the VAT (Value Added Tax) posting setup for a customer or vendor. They allow you to define default VAT accounts for different types of transactions involving a particular customer or vendor. For example, you might use a Tax Posting Group to specify the default VAT accounts for sales or purchases for a particular customer or vendor

In the next few articles in this series, I’ll take a deeper look into each of the posting group types.

This post is part of the In Microsoft Dynamics 365 Business Central (Financial), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

Over a few articles in this series, I’ve taken a look at dimensions in Dynamic BC and how they’re maintained. I will cover how they are used on transactions in future articles, but I just want to mention dimension sets before I do this.

When you enter transactions and pick the dimensions you want to assign, the selected dimension values are stored in the database. However, they are stored as dimension sets in the Dimension Set Entry.

For users on the front end of Dynamics BC, this makes no difference to how they enter or view transactions and the linked dimensions. However, when to comes to reporting this is quite an important distinction as you will need to join to a different table.

If you have two transactions which have the same combination of dimensions and dimension values, then they will be linked to the same dimension set.

This post is part of the In Microsoft Dynamics 365 Business Central (Financial), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

In an earlier article, I discussed what dimension combinations are and then I covered how to set up blocks and limits. In this article, I’m going to show how dimension combinations can be removed.

To remove a dimension combination, search for dim comb and select Dimension Combinations:

Continue reading “In Microsoft Dynamics 365 Business Central (Financial), how do I… Remove Dimension Combination”

This post is part of the In Microsoft Dynamics 365 Business Central (Financial), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

In an earlier article, I discussed what dimension combinations are and in this one I am going to cover how you can configure dimension combination limits.

A dimension combination limit can be configured to stop users using a combination of dimension values. An example of when this would be useful, is when I have dimensions for sales campaign and business group and I wanted to make sure that users could not use a specific sales campaign for one, or more, of the business groups on the same transaction; a dimension limit will allow me to stop users doing this.

To add a dimension combination limit, search for dim comb and select Dimension Combinations:

Continue reading “In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure Dimension Combination Limits”

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

The eighth of the new functionality in the User experiences section is Improved alignment of headers in statistics pages.

The default behavior across Business Central is to right align numeric fields and left align text fields. However, when pages display fields arranged in special tabular layouts, such as customer statistics or on most journal footers, the mixed data types often result in column headers being misaligned with their data. With this update, users benefit from improved readability of data with automatically aligned headers.

Enabled for: Users, automatically
Public Preview: Feb 2023
General Availability: Apr 2023

Feature Details

• Improved readability: When a fixed layout group control is used on a page, Business Central automatically detects the first visible value in a column, and the header is left-aligned or right-aligned accordingly.
• Just works: No additional effort is required from developers to specify alignment.

My Opinion

This sounds like a simple change which will, as advertised, improve visibility by displaying data with a consistent alignment.