I'm encountering an issue in a finance/management report and need your guidance to resolve it. The report is displaying an error message stating, /Starting period 1 for fiscal year 2024 and ending period 12 for fiscal year 2023 do not form a valid date range./ It seems there's a discrepancy with the fiscal year dates in the report. Additionally, last month's report included a large number of accounts,
but the current report, which should reflect the end of December or the previous month, is showing both incorrect values and a reduced number of accounts. This leads me to believe that the finance department may not have closed December's accounts yet. Could you please advise on how to correct this error or suggest a workaround?
Could this have to do with SQL row versioning or SQL Change Tracking?
Error: Starting period 1 for fiscal year 2024 and ending period 12 for fiscal year 2023 do not form a valid date range (Finance Report Designer)