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?
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
Good Catch MahGah, I believe you are correct...
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,900 Super User 2024 Season 2
Martin Dráb 229,275 Most Valuable Professional
nmaenpaa 101,156