Default dimensions in Dynamics 365 Business Central can help you categorize and track your G/L accounts. Assigning default dimensions to your G/L accounts will save time on entries, as well as maintain consistency.
With default dimensions, your dimensions will be automatically assigned when transactions are entered, or you will be thrown an error message as a reminder to attach the specific dimension before posting.
I will show you how to assign default dimensions to your G/L accounts and how they are applied in purchase invoices.
Creating Default Dimensions
Begin by navigating to the Chart of Accounts under Finance and Chart of Accounts. Alternatively, you can search for this in the search bar at the top-right of your screen.
In your Chart of Accounts window, you can begin selecting the accounts you would like to assign dimensions to. Next, click the three dots on the top menu bar and select Account, then Dimensions-Single:
Note that Dimensions-Multiple is used if you select more than one account and want to assign the same criteria to all of those accounts.
Default Dimensions Criteria
Within the Dimensions-Single page, there are a few areas that you will need to fill out.
Dimension Code: here you will enter the dimensions itself.
Dimensions Value Code: enter a value if applicable.
Value Posting: here you have a few options:
- Blank: if you leave Value Posting blank, it will not present any restrictions on what can and cannot be selected.
- Code Mandatory: a user must select any of the dimension values permitted within the specified dimensions. An error will appear if the dimension is not selected prior to posting.
- Same Code: the dimension code and dimension value must be indicated, and the GL account will require both when this specific GL is selected. This sets the default values and makes them a required value.
- No Code: the dimensions would be considered blocked. A user cannot opt to add the dimension or dimension values on a specified criterion.
In the example above, I have entered the department code as well as the admin value code, but no value posting. I will go over some account examples with different requirements:
For my miscellaneous expense account, I have DEPARTMENT as my dimension code and Code Mandatory as my value posting:
For my depreciation expense account, I have the value posting as Same Code, BUSINESSGROUP as my dimension code, and OFFICE as my Dimension Value Code:
Applying Dimensions to Purchase Invoices
Let’s take a look at how this applies to purchase invoices. Navigate to Purchasing in the top menu bar and select Purchase Invoices:
Begin by entering a new purchase invoice:
In the new purchase invoice window, enter your vendor’s name to populate vendor details.
Note that a red star icon will appear next to all required information.
Indicate the Type as G/L account:
Enter your expense number in the No. field and additional information will populate:
You can scroll to the right to view additional required fields.
Looking at dimensions or the “Department Code” field in this example, admin has been automatically assigned. This is because the value posting was set to Blank. You can change this, and it won’t present any errors:
When you enter a G/L account that has been set to Code Mandatory for department, you will see that no code has been assigned. In this case, if you try to post it through, an error message will pop up advising that, for that specific G/L account, we need to indicate a department dimension.
Once a department dimension is assigned, you can preview your posting and no error message will appear:
Note that, if you’ve entered a required business group and receive an error message, ensure that the dimension value code is correct.
Once all the errors have been corrected, your purchase invoice is ready for posting.
You can also assign default dimensions to any master records; it is not limited to G/L accounts. It can be added to vendors, customers, items, and more.
For further details, watch this video:
If you have any questions about your Business Central environment, please contact us.
Tips & Tricks for AP Checks and EFT/ACH Transactions in Dynamics 365 Business Central
In this webinar, we’ll begin with an overview of AP checks and EFT/ACH transactions in D365 Business Central, and then demonstrate how to address common problems and error messages within the system.
10:00 am – 10:30 am PST
Webinar - AP Checks and EFT Transactions
10:00 am – 10:30 am PST