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.
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.