Use shortcut dimensions in G/L entries for financial reporting

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Enabled for	Public preview	General availability
Users by admins, makers, or analysts	Dec 16, 2020	Jan 11, 2021

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.

Feature details

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.

Tell us what you think

Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcideas.

Thank you for your idea

Thank you for submitting this idea. We listened to your idea, along with comments and votes, to help us decide what to add to our product roadmap.

See also

Working with Dimensions (docs)