Notifications
Announcements
No record found.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 3,151
Jainam M. Kothari 1,443 Super User 2025 Season 2
YUN ZHU 1,092 Super User 2025 Season 2
