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)

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

BillurSamdancioglu 20,521 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

I think report is very incorrectly designed.

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

Was this reply helpful? Yes No
SashaCodes 13 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Moderator on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No