Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Include or Exclude GL Accounts in Report based on Dimension

Posted on by 5

Hi,

Our organization is new to BC, having migrated from GP and Management Reporter. 

We are trying to replicate a previous report which included expenses over several years (column layout, no problem) for a single Department (Global Dimension 1) for each GL account "related" to that department. For example, for our Technology Department we previously had a report that listed the total expenses for each individual GL account (as rows in the report), but only the GL accounts related to Technology. Note that several of the GL accounts listed for Technology also overlap with other "Departments" such as Labor and Wages, etc. Below is an example, with the account numbers highlighted in yellow and department highlighted in green.

BC_2D00_DeptReportEx.jpg_2D00_640x480.jpg_2D00_640x480.jpg_2D00_640x480.jpg

So my question is: Is there a way to link dimensions to a GL account so that they are included/excluded from showing in a report dynamically, when filtered in some manner by the Department Dimension?

I understand that you can assign default dimensions and allowed dimensions with a GL account, but can you exclude the accounts from a report based on the Allowed Values Filter? Or is there another way?

We would be grateful for a solution!

  • tshannon Profile Picture
    tshannon 55 on at
    RE: Include or Exclude GL Accounts in Report based on Dimension

    On the screen where you create the Account Schedule, there is a setting for each row that allows you to hide the zero rows.  So if the filtered department doesn't have any activity in that account, it won't appear on the report.

    pastedimage1660898423861v1.png

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,760 Super User 2024 Season 2 on at
    RE: Include or Exclude GL Accounts in Report based on Dimension

    Hi, I'm sorry that my understanding is wrong, as far as I know the standard feature can't do it, but you can do a small customization.

    Hope other experts can give you better advice.

    Thanks.

    ZHU

  • BC-Meister Profile Picture
    BC-Meister 5 on at
    RE: Include or Exclude GL Accounts in Report based on Dimension

    Perhaps I am explaining this wrong. I know I can filter the account schedule by Dimension, which filters the row values. I was hoping there was a way to filter the rows to show/hide by dimension. We don't want a report of hundreds of accounts, we only want the 10-20 accounts that are used by the dimension to show.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,760 Super User 2024 Season 2 on at
    RE: Include or Exclude GL Accounts in Report based on Dimension

    Hi, if you use the Account Schedule feature, you can filter Dimensions.

    pastedimage1660784610976v2.png

    pastedimage1660784599652v1.png

    More details: https://docs.microsoft.com/en-us/dynamics365/business-central/bi-how-work-account-schedule

    https://www.youtube.com/watch?v=8pXMvjC8rEo

    Hope this helps.

    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.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans