Report Designer

(0) Share

Report

Posted on by Community member

Hi guys . I am having an issue with a Financial report in D365 F&O. Its for budgets for 2024: when i run the report in the front end i get this error :

When I open the designer i notice that the base year is set for 2023, when i try to change it , it will not switch to 2024. I changed it and hit save, but the report defaults back to 2023:

any idea why this is happening and how do i fix it ?

All responses (7)

Answers (0)

Frank Hamelly | MVP... 3,807 Super User 2024 Season 2 on at

Like (1)

Report

Report Designer

I would try a Data mart reset if you haven't done that yet. It's likely not an issue with the way 2024 was setup or users would be seeing odd behavior in transaction processing.
Ramon L 133 on at

Like (0)

Report

Report Designer

Hi Team

@Hana Xue i have checked these and can find no issues at all. The one thing i noticed is that if I run the same date range across the other financial reports for 2024/12/31 i'm now getting the same issue/error. So it seems to be linked to what can only be the financial periods. All the reports run perfectly for the 2023 period, but when run for 2024 I get this error.

@Frank I did make the change you suggested and it returned the same error shown above. I'm concerned that it may have something to do with the way the finance department created the 2024 financial and ledger periods, but I can not find any issues with the creation or setups. i must be missing something here

regards
Suggested answer

Hana Xue Microsoft Employee on at

Like (1)

Report

Report Designer

Hi,
Have you checked according to the prompt information? What does the fiscal year look like in your column definition? In addition, what makes Base Period and Base Year exceptional is that you can run a report over them right before the report is rendered and it is not saved within the report definition. The Default Base Period setting determines the initial settings for the Base Year and Base Period. This is the only setting that is saved with the report definition.

For information on specifying report period and date definitions in reports, you can view this link: http://www.dynamicbusinesssolutions.ru/managementreporter.en/html/0f289674-393e-748f-afdd-4f2eefffec73.htm
Best Regards,
Hana
Frank Hamelly | MVP... 3,807 Super User 2024 Season 2 on at

Like (1)

Report

Report Designer

Can you try changing the Company from @ANY to an actual company and see what results you get? Is there a reporting tree involved?
Ramon L 133 on at

Like (0)

Report

Report Designer

Hi team , the fiscal periods are created and are open . As for the default base period, I do not have an S period, but I do have an S+1 which I changed it to, re-ran the report, and still the same error is being generated . Any other ideas will be greatly welcomed
Suggested answer

Frank Hamelly | MVP... 3,807 Super User 2024 Season 2 on at

Like (1)

Report

Report Designer

Is Fiscal 2024 setup yet in F&O?
Suggested answer

BillurSamdancioglu 13,600 Super User 2024 Season 2 on at

Like (1)

Report

Report Designer

Can you please try after to change the default base period to S