This fix addressed two issues with the Cash Flow report when Real Money is toggled on when generating the report, including discrepancies in figures and incorrect discount periods.
Issue 1
Before -
The report incorrectly discounted figures for specific years, notably applying a shorter discount period than the actual timeline, causing mismatched real money values for future years.
The ‘Allocated to Savings’ and ‘Unallocated Surplus’ figures were being discounted improperly, leading to discrepancies where their sum did not match the Surplus/Shortfall total, potentially misleading users about available funds.
After -
The “Allocated to Savings” and “Unallocated Surplus” rows should match that which is shown in the detailed cash flow lets see chart, with real money toggled on, and the values should add up to the “SURPLUS / SHORTFALL” row.
Issue 2
Before -
The issue with incorrect discount periods was identified for future years (e.g., 2034, 2039, 2044, 2049), where the discount periods used in the report did not align with the actual timeline, affecting the accuracy of present value calculations.
After -
When specifying a year range and generating with real money toggled, the table values should match the report when a year range IS NOT specified and real money is on. Previously, the real money calculations were getting mixed up whenever not all years in the plan were specified (when the first year isn’t included in the year range, and the range is not continuous).