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?

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Nitin Verma 21,569 Moderator on at

Like (0)

Report

RE: Trial Balance Error when trying to exclude 0 balances

This is known bug and has been reported to Microsoft.

github.com/.../7224
PieroMsys79 5 on at

Like (0)

Report

RE: Trial Balance Error when trying to exclude 0 balances

Hi,

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

Helpful resources

Quick Links

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

#1

Sohail Ahmed 2,655

#2

Mansi Soni 1,574

#3

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans