Announcements
No record found.
Is there any way to update the format of the financial statements (balance sheet, income statement, etc..) so the excel version of the reports (when you export) are more appealing?
@rcboiler: can you elaborate what you mean by more appealing?
If it's just the format or column or row positioning, you can use account schedules to create custom financial statements.
The excel output for this report is not formatted very well - namely wasted (empty) lines that make the report very difficult to use. The PDF format is acceptable.
@rcboiler: As I mentioned before the format is in your hands. i.e. the column and row definitions, in addition to these you have a column named "Show" which can be used to control what fields are shown/hidden on the report.
I forgot to mention one thing when you edit in excel you will see some extra lines, but when you will print to excel you wont see those extra lines.
We must be looking at different reports. The output (Send To: excel) results look very bad.
are you looking at the standard out of box financial statements or is it something you designed yourself? in my case I designed them myself as the standard ones didn't fulfill my client's requirement.
100% agree! I have tried building multiple variations of balance sheet reports and income statements and every time it adds blank rows below each row when printing to excel. Even if the account schedule has the Row No of 1,2,3,4. It also outputs all of the numbers stored as text which makes it impossible to do any analysis in excel. And you cant easily convert these via Text to Columns because Business Central reports merge so many different random cells. One column will be merged but the next will not.
Hello,
I create some nice Account Schedules with good spacing so I can export to Excel. However, nothing is perfect so I would recommend, as I do for my customers, you use Jet Reports. It is easier and your formatting meets your needs. You get sample B/S and I/S to work with and you are up and running in a few hours.
Thanks,
Steve
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to a top community star!
In our never-ending quest to help the Dynamics 365 Community members get answers faster …
Welcome to the next edition of the Community Platform Update. This is a status …
Stay up to date on forum activity by subscribing.