Applies to Product - Dynamics 365 Business Central
What’s happening?
The financial report is not calculating the total percentage correctly when printed, although it displays correctly in the interface.
Reason:
This appears to be caused by the mixed use of various codes for Row Numbering in the Financial Statement, which affects calculations based on the Row Numbers. If the Row Numbers in the Financial Statement are not consistent in content and order, it may cause problems with formula calculations due to how SQL sorts the rows.
Resolution:
- It is recommended to use consistent and sequential numbering for Row Numbers to ensure that calculations are made correctly and in the correct order when the rows are sent to print or PDF.
- The current Row Numbers are mixed characters with mixed lengths. For example, ensure that Row Numbers follow a consistent format and length.
- If adjustments have been made to the COLUMN definition, ensure that these modifications do not disrupt the calculations. Specifically, check if the modifications align with the related Comparison Period Formula.
- If the issue persists after making these adjustments, further investigation may be required to identify any additional underlying causes.