web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Trial Balance Error when trying to exclude 0 balances

(0) ShareShare
ReportReport
Posted on by 16

Hi,

Microsoft pushed out the latest version of Business Central last week and its causing us some issues.

Historically, when we wanted to run a Trial Balance, and exclude zero balances, we would add a Balance Filter and add the text "<>0".

Now when we do this, we get the error message "The supplied column ID '34' cannot be found in this query" 

Can anyone help with this issue?

  • PieroMsys79 Profile Picture
    5 on at

    Hi,

    I also have the same problem, it's obviously a bug.

  • Suggested answer
    Nitin Verma Profile Picture
    21,812 Moderator on at

    This is known bug and has been reported to Microsoft.

    github.com/.../7224

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 674 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 362 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 359 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans