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

Accounts Schedule - suppress zeros or blanks

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi there

Does anyone know if there is a way of suppressing zeros or blank rows on accounts schedules? I've done a bit of research and it seems this isn't possible in 2009 version but hope I'm wrong.

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Accounts Schedule - suppress zeros or blanks

Hi Vanessa, many thanks for your prompt response. I can see that this works. Just a shame it doesn't apply on screen or even on excel export
Suggested answer

Vanessa Garcia on at

Like (0)

Report

RE: Accounts Schedule - suppress zeros or blanks

Hello,

you cannot suppress rows with zeros in the own Account Schedule Overview, but you can set a certain row to show in the Printed Report or not depending on that.

For example, Edit an Account Schedule and use this option for a row where you find no values (Show: If Any Column Not Zero):

Then, in the own Account Schedule Overview, you will still see Column 111:

But not in the Account Schedule report layout: