Dimensions

Omar K

195

Like ( 0 )

Report

In this post I will be comparing Dimensions, let’s start with a few notes:

I will be comparing MS Dynamics GP “Analytical Accounting” not the “Multi-Dimensional Analysis” with Business Central Dimensions.
In both, a dimension is a dimension.

In MS Dynamics GP:

A “Class ID” should be created and then it can be assigned to a “G/L Account”, in Business Central a dimension can be assigned directly to the “G/L Account”, “Customer”…etc.
Dimensions are assigned to G/L Accounts, but in Business Central, Dimensions can be assigned to Customer, Vendors, Items…etc.

MS Dynamics GP – Dimensions and Dimensions Codes

Business Central – Dimensions and Dimension Values

In Business Central:

“Dimension Values” can’t be created on the fly as in MS Dynamics GP.
Two dimensions can be specified as a “Global Dimensions”, “Global Dimensions” are the most important dimensions to the business, they are located every where and can be used as filters. (G/L Entries, Financial Reports, Reports and Sales & Purchase Document Headers).
Six dimensions can be specified as “Shortcut Dimension”, mainly used to filters on Journals document lines.

How it works:

I will explain how it works in two scenarios

Scenario 1 (General Journal):

In the scenario, I will create a journal, the first line is an expense account and the amount is 100 (Debit), this account is linked to a dimension called “Project”.

As you can see above, In MS Dynamics GP the amount “100” can be assigned to 1 project or 2 projects (Split), In Business Central, is it sort of similar, Business Central will automatically assign the dimension values (or manually if required) but with 1 difference. 1 Line can only have 1 dimension value for a dimension, so “Splitting” as above is not possible.

Scenario 2 (Sales Invoice):

As I mentioned before, In Business Central, a dimension can be assigned to a “Customer”, so in this scenario when creating a “Sales Invoice”, Business Central will copy the “Global Dimensions” from the “Customer” to the “Sales Invoice Header” and then from “Sales Invoice Header” to the “Sales Invoice Lines”.

Finally, when this invoice is posted, the dimension will be coped to the “Posted Sales Invoice” and the “Posted G/L Entries”

In MS Dynamics GP, the user need to assign the Dimension to the G/L Accounts before posting.