Skip to main content

Notifications

Business Central forum
Suggested answer

Filter to exclue zero balance

Posted on by 5

When I run the trial balance report and try to filter for zero balances using the below filter:

pastedimage1667479599091v1.png

I get the error:

pastedimage1667479651949v2.png

Does anyone know how to resolve this?

This filter has always previously worked. 

  • Suggested answer
    Amit_Sharma Profile Picture
    Amit_Sharma 2,545 on at
    RE: Filter to exclue zero balance

    Hi,

    Uninstall the Report extension and install the latest extension of Reports. 

    Regards

    Amit Sharma 

    www.erpconsultors.com

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,190 Super User on at
    RE: Filter to exclue zero balance

    Hi

    you should try the previous version of BC

    to me it sincerely seems like abnormal behaviour

    even on my BC 21 environment I get the same error for all flowfields when they are filtered

    it would give you an error even if you filter BALANCE = 1

    can you test it with a previous version?

    DAniele

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 20,995 Super User on at
    RE: Filter to exclue zero balance

    Please refer the below link, there is bug with this. You can log a support ticket to Microsoft directly.

    github.com/.../7224

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Filter to exclue zero balance

    put value >0

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Filter to exclue zero balance

    put filter >0

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Waed Ayyad!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 289,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 227,174 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans