In prior Version of Business Central, only the primary Dimensions (Dimension 1 and 2) were widely and easily accessible in the system. Although the user could define six additional dimensions, these were only referred to as shortcut dimensions. In this version of Business Central, Microsoft has added the ability to see the additional dimension in key pages, such as the General Ledger entries archive.
Additional Dimensions – Business value
Because Excel is still the tool of choice for most accountants and finance professionals, it’s important that all dimension attributes are available across application for easy ad hoc analysis in Excel, and for filtering data in Business Central.
You can specify shortcut dimensions on the General Ledger Setup page so that you can filter entries pages, such as general ledger entries, customer or vendor ledger entries, and many others, using the dimension value. For example, if you add Area as a shortcut dimension, you’ll be able to filter general ledger entries by area. To enable this, add a newly created dimension—for example, Area—as a shortcut dimension in the Dimensions FastTab on the General Ledger Setup page.
Additionally, you can now export data from these columns to Excel for easy ad hoc analysis of entries, such as general ledger entries, customer or vendor ledger entries, and many others—for example, by creating pivot tables.