Announcements
How can I print a general ledger report that will subtotal by dimensions like location?
Have you tried G/L Balance by Dimension?
Hi,
Analysis view will be met your requiement. In the figure below the column is the Accounting Period, you can replace it with the Dimension Code.
On this page, switch the column field from Accounting Period to Dimension Code.
I hope this helps you.
S.Kawamura
If you where in the newest version you could create a report in Power BI showing a map with several location and then embed that report into Business Central. Would not be 100% like a live tracking but it would give you a picture of the situation at a given time.
Hi,just adding to others' reply.
You can try to use G/L Dimension Overview feature in General ledger Entries page.
And in the next major version (BC21), there will be the following new feature.
Try Power BI apps with dimensions
https://docs.microsoft.com/en-us/dynamics365-release-plan/2022wave2/smb/dynamics365-business-central/try-power-bi-apps-dimensions
Hope this helps as well.
Thanks.
ZHU
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 647 Super User 2026 Season 1
Gerardo RenterÃa Ga... 447 Most Valuable Professional
YUN ZHU 366 Super User 2026 Season 1
