Hello everyone.
As you are likely aware, dimensions are a highly effective feature within Business Central. They facilitate easier analysis of documents such as sales orders by allowing you to categorize entries. Dimensions act as attributes and values that help in tracking and analyzing data. For example, they can denote the project or department from which an entry originates.
There is no restriction on the number of dimensions you can utilize, but Business Central provides 8 dimensions that are particularly straightforward to analyze.
You can set these up on the “General Ledger Setup” page.
Please note: Required
Global Dimension 1 Code = Shortcut Dimension 1 Code
Global Dimension 2 Code = Shortcut Dimension 2 Code
On the majority of pages, you have the ability to easily access the “Design” feature, which allows you to display the Global Dimension 1 Code and Global Dimension 2 Code in a clear and organized manner.
For instance, when working with:
Sales Orders:
In case you want to display all Dimensions on the page, what are the options available?
I will present two approaches: one involves adding actual fields to the table, while the other simply requires adding variables to the page.
Let’s dive in.
Method 1 (Add new fields)
Add the 2 Global Dimensions & 6 Shortcut Dimensions to Item Ledger Entries.
First add new Shortcut Dimension fields to the “Item Ledger Entry” table.
Please pay attention to the properties of “CaptionClass” and “TableRelation”.
Next, present these fields on the “Item Ledger Entries” page.
Ultimately, considering that each of these fields is indeed a real and valid entity, it becomes crucial to integrate logical reasoning into the process of posting in order to ensure accuracy and coherence.
Method 2 (Using only variables)
Integrate the 2 Global Dimensions and 6 Shortcut Dimensions into General Ledger Entries.
All you need to do is create a Page Extension for this purpose.
Steps: Add variables for Shortcut Dimensions -> Present fields on the page -> Apply logic.
Publish and confirm.
Completed.
In my opinion, the first approach is more advantageous. When the fields are present in the actual table, they can be utilized for reporting, querying, and other purposes. However, if your only goal is to display the information, the second approach could also work well.
For additional guidance on displaying dimensions on different pages, you might find this blog helpful.
END.
Hope this Will help.
Thanks.
Aditya