Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Problems in Trial Bala...
Microsoft Dynamics NAV (Archived)

Problems in Trial Balance Detail/Summary Report (#10021)

(0) ShareShare
ReportReport
Posted on by Community Member

I've found these issues with the North American report 10021 Trial Balance Detail/Summary, Version tag NAVNA7.10.  They can be reproduced in Cronus and I'm posting here in hopes the development team will view and correct them in the next cumulative update.

*  Report option "Show: Accounts With Balances" or "Show: Accounts with Activities"
   If the filters return no data, report Preview returns
     "An error occurred during local report processing.
     The Hidden espression used in tablix 'Table1' returned a data type that is not valid."
*  Report option "Print Transaction Detail"
   The subtotal line "Beginning Balance" prints twice for each G/L Account
*  Report totals are always forced to a new page at the end of the report; is this necessary?  Would prefer them to follow the last printed account.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: Problems in Trial Balance Detail/Summary Report (#10021)

    Does anyone know how to move the "Report Totals" to appear on first page. The body of the report is extending and printing blank data which is forcing a second page. Thanks

  • Suggested answer
    PreetGor Profile Picture
    PreetGor 47 on at
    RE: Problems in Trial Balance Detail/Summary Report (#10021)

    Found Solution for this Report Error.

    the Hidden Expression In layout is the reason for this error.
    hidden expression is First(Boolean var) Gives Blank Value in Dataset because of the filters there is no data available in NAV and it will generate Blank Dataset.

    Solution :

    Rsolve this issue by Using IsNothing(Standard Exp.,True,False) Layout hidden expression and its done.

  • PreetGor Profile Picture
    PreetGor 47 on at
    RE: Problems in Trial Balance Detail/Summary Report (#10021)

    i have similar error in the report...tried to remove "entries in red font color" but did't work..

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Problems in Trial Balance Detail/Summary Report (#10021)

    hi,

    check in the report if there are tables (tablixes) with field entries in red font color. if so, these are controls you could delete. before deleting check the visibility.

    the problem of controls, which are set invisible is, that they are printed anyway. that means on the print there is space reserved for them. so, to do not print these controls remove them. use only controls in reports, which are really used.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans