Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Problems with Balance Sheet

Posted on by 56

Hi,

When I am trying to generate a balance sheet - standard report I get the following error message.

Make sure that the report was generated with the following settings:

  • A valid report date
  • Valid dimensions and accounts
  • A valid reporting tree unit
Change your report options or work with your report designer or generator to make sure the report is using the right settings.
I have a valid report date. Valid dimensions and accounts, where can I see if the dimensions and account is valid? Since I choose a standard report I assume that the reporting tree unit is valid.
Plx help me. 
Matilda
  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 12,003 Super User 2024 Season 2 on at
    RE: Problems with Balance Sheet

    Hi Matilda,

    Do you want to generate standard report Balance Sheet - Default (i.e. Financial report)? Have you done any customization in this report?

    pastedimage1665570053476v1.png

    If you get the following message, it can be related to that there is no transaction in the company:

    pastedimage1665570464068v2.png

    If you have data in the company, you can check if on Dimension set is assigned main account or financial dimension. If not you can create a new one.

    pastedimage1665572049088v1.png

    pastedimage1665572059303v2.png

    then check if main accounts have main account category:

    pastedimage1665572228415v1.png

    If there is dimensions on Dimension set, you can evaluate to reset "Data mart". 

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans