Applies to Product - Dynamics 365 Business Central
What’s happening?
Trying to suppress rows with zero amounts in financial reports, but rows with no activity are still being displayed.
Reason:
The financial report layout being used may have static rows that do not allow for the suppression of blank or zero rows when using the "Create New" and "Update template with data" functionalities.
The financial report layout being used may have static rows that do not allow for the suppression of blank or zero rows when using the "Create New" and "Update template with data" functionalities.
Resolution:
To generate the financial report while suppressing rows with zero amounts, the following methods can be used: 1. From the Financial Report layout page, click on "Export to" or "Print - Print." In the Run Financial Report, mark the options for "Show Row Number" and "Zero Balance Lines," then click "Send to..." and choose "Microsoft Document (data and layout)." 2. Alternatively, back out to the Financial Reporting list page, highlight the report in question, and click "Print/PDF." In the Balance Sheet report page, mark "Show Row No." and "Zero Balance Lines," then send to "Microsoft Document (data and layout)."
To generate the financial report while suppressing rows with zero amounts, the following methods can be used: 1. From the Financial Report layout page, click on "Export to" or "Print - Print." In the Run Financial Report, mark the options for "Show Row Number" and "Zero Balance Lines," then click "Send to..." and choose "Microsoft Document (data and layout)." 2. Alternatively, back out to the Financial Reporting list page, highlight the report in question, and click "Print/PDF." In the Balance Sheet report page, mark "Show Row No." and "Zero Balance Lines," then send to "Microsoft Document (data and layout)."