web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Trial Balance Error wh...

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

Answered

Trial Balance Error when trying to exclude 0 balances

(0) Share

Report

Report

Posted on by SeanLo

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?

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

PieroMsys79 5 on at

Like (0)

Report

Hi,

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

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

This is known bug and has been reported to Microsoft.

github.com/.../7224

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 2,238

#2

YUN ZHU 773 Super User 2025 Season 2

#3

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans