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

Account Schedules - adding headers and blank lines

(0) Share

Report

Posted on by Marilyn R

In preparing our account schedules, we want to add headers and blank lines to obtain a more professional look to our financial statements.

I can do this by adding posting lines and changing Show column to 'Yes".

My dilemma is that our numbering format is set to "Accounting format, no currency". This makes the report look more professional and adds dashes when amounts are zero to allow your eyes to follow along on a page without jarring blank gaps when items have no value.

Unfortunately, this also adds dashes to any headers and blank lines I've created because account schedule only allows you to add a formula, posting or totalling type which forces it to also generate a numeric value of 0.00.

Is there a way around that without losing the ability to place dashes in places where the values are legitimately zero?

All responses (4)

Answers (0)

Suggested answer

YUN ZHU 77,351 Super User 2025 Season 1 on at

Like (1)

Report

RE: Account Schedules - adding headers and blank lines

Hi, Is it possible to just modify the Layout file?
As follows.

Or Or directly modify the formula and add conditions.

Hope this will help.

Thanks.

ZHU
Dallefeld 171 User Group Leader on at

Like (1)

Report

RE: Account Schedules - adding headers and blank lines

Good Catch MahGah, I believe you are correct...
Suggested answer

MahGah 15,433 on at

Like (0)

Report

RE: Account Schedules - adding headers and blank lines

Hi Kim Dallefeld

I am not familiar with finance. Do you think the following future in upcoming version will resolve this issue?

docs.microsoft.com/.../new-capabilities-financial-reporting-account-schedules
Suggested answer

Dallefeld 171 User Group Leader on at

Like (1)

Report

RE: Account Schedules - adding headers and blank lines

You're looking for the blank line as show below:

But you want to have dashes when zero.

I think you will need to export to Excel and format the amount column.