Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Financial Reporting isn't updating an specific dimension value

(1) ShareShare
ReportReport
Posted on by 50
Hello,
 
I have this cause if anyone can help to figure out what is happening. In a financial report, I see that the values aren't showing for a specific dimension. In the image below the dimension is the 22, as you can see for the other dimensions exist values.
 
I checked the G/L ledger entries for that dimension and it has ledger entries, in the periods that I have tested. I tried creating a new column definition and even creating the report again but the result is the same.
 
I'll appreciate any help you could provide.
Regards,
Alejo.
 
  • Alejo Bohorquez Profile Picture
    Alejo Bohorquez 50 on at
    Financial Reporting isn't updating an specific dimension value
    Hi,
     
    Thanks for your answer, I confirm that under the same filtering conditions of value (-5010.40) the dimension 22 is still empty. 
     
    I'm using analysis view in the report by the way.
     
    Filters for dimension 23
    Filters for dimension 22
     
     
    Regards,
    Alejo
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    Financial Reporting isn't updating an specific dimension value
    That's a bit weird, it looks like your general ledger entry doesn't include an entry with dimension 22.
    I suspect it is still a problem with the filtering conditions. For example, if you drilldown the following number (-5010.40) and check the filtering conditions. Under the same conditions, is the detail of dimension 22 empty?
     
    Hope this can give you some hints.
    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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans