Use shortcut dimensions in G/L entries for financial reporting
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|
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.
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.
Working with Dimensions (docs)