Urgent Error: Starting period fiscal year, ending period fiscal year do not form a valid date range

(1) Share

Report

Posted on by SashaCodes

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)

All responses (3)

Answers (0)

Frank Hamelly | MVP... 46,485 Super User 2025 Season 1 on at

Like (0)

Report

Urgent Error: Starting period fiscal year, ending period fiscal year do not form a valid date range

Where in report designer are you seeing that message? When you try to generate the report? Can you post a screenshot of the Column definition for the report?
SashaCodes 13 on at

Like (0)

Report

Urgent Error: Starting period fiscal year, ending period fiscal year do not form a valid date range

Can you show me, where you would put the start date? @BillurSamdancioglu
Suggested answer

BillurSamdancioglu 17,153 Most Valuable Professional on at

Like (0)

Report

Urgent Error: Starting period fiscal year, ending period fiscal year do not form a valid date range

Hi,

I think report is very incorrectly designed.

How can a start date be in 2024 and end date 2023?