MainAccount shown in default dimensions

Introduction

At one of my D365-FO customers I encountered a very strange issue where the main account appears as a financial dimension in the "Default dimensions" tab in customer, vendors, products and any other entity which uses the "Default dimensions" tab within the system.

This is shown in the screenshot below:

After technical investigations from a developer it was discovered that the root cause of the issue is as follows. In the dimension entry control handling classes, there is a query that finds the dimensions that should appear in the default dimension over the master data, this query eliminates the main account from being used in the financial dimension tab by making a non exist join. But the strange thing at this customer, was that there should be at least one dimension attribute set that contains the main account only, this set is system generated but unfortunately it was missing there. Maybe it was deleted during some data clean-up or migration effort..

The solution was to create the missing record through the table browser using the entry from the demo data VM as the record`s relative records are already exist in application, just the dimension attribute set item record was missing.

I hope this helps you if you ever encounter this strange issue in your project.