Small and medium business | Business Central, N...

Close Income Statement issue

(2) Share

Report

Posted on by JohnGPIT

Hello D365 BC Community,

I’m currently facing an issue with closing a fiscal year and aligning my fiscal year setup in Dynamics 365 Business Central. Here’s the situation:

The Problem:

Incorrect Fiscal Year Setup for 2024:
- My fiscal year was initially set up incorrectly for 2024, where the New Fiscal Year checkbox was marked for 12/1/2024 instead of 1/1/2024.
- As a result, the system seems to treat December 2024 as part of the next fiscal year instead of the end of 2024, I couldn't delete it because there was transactions posted in 2024 which made the activated the date lock field in the Accounting periods
Closing 12/31/2023:
- I need to close 12/31/2023, but due to the above misalignment, I’m not sure if the system will treat this correctly.
- I have already attempted to adjust the Accounting Periods, but because of existing transactions in 2024, I cannot delete or fully realign the 2024 fiscal year.
Existing Transactions in 2024:
- Transactions were created and posted in 2024 before the Accounting Periods for 2024 were defined. This has caused additional complexity in adjusting the fiscal year setup.

What I’ve Tried So Far:

Corrected the fiscal year setup for 2025 and beyond to ensure they align with a January–December fiscal year.
Verified that General Ledger Setup allows posting within the appropriate date ranges, thinking this should allow me to remove the date lock in the accounting periods but that wasn't successful and it didn't work.
Attempted to close the income statement for 12/31/2023, but I want to ensure this will not create further issues with the misaligned December 2024 period.

Questions for the Community:

How can I close 12/31/2023 properly, because as you can see in the image I am unable to close it ?
Is there a way to fix the fiscal year alignment for 2024 without reversing or deleting the posted transactions for that year?

Any guidance or recommendations would be greatly appreciated! Let me know if you need more details or screenshots to clarify the issue.

Thank you in advance for your help!

Categories:

Dynamics 365 Business Central

Accounting Period...

Close Income Stat...

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

YUN ZHU 91,851 Super User 2025 Season 2 on at

Like (1)

Report

Close Income Statement issue

Hi, the Close income statement accounts function is used to close the fiscal year, not the monthly.

More details:

https://learn.microsoft.com/en-us/dynamics365/business-central/year-close-income-statement?wt.mc_id=DX-MVP-5004336

For monthly closing, you only need to control it through Allow Posting From/Allow Posting To. And inventory Period can be closed monthly, there is no problem with that.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 29,195 Super User 2025 Season 2 on at

Like (0)

Report

Close Income Statement issue

Typically, you only close once per fiscal year. Is there a specific reason you’d like to close monthly?

The system allows closing only when there’s an accounting period marked with the New Fiscal Year boolean on the Accounting Periods page for the next period. If you want to close monthly, you would need to mark this boolean as Yes every month. However, as mentioned, this isn’t something I would recommend.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
JohnGPIT 18 on at

Like (1)

Report

Close Income Statement issue

@Valentin Castravet but I want to close each month separately.

I put 12/31/2023 will it close all the months of 2023? if yes, is there a way just to close one month at a time

Thank you again for your continuous support and guidance.

John

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 29,195 Super User 2025 Season 2 on at

Like (0)

Report

Close Income Statement issue

that still looks like january 31, not december 31 in your screenshot

Was this reply helpful? Yes No
JohnGPIT 18 on at

Like (0)

Report

Close Income Statement issue

Hi @Valentin Castravet,
I have tried that before and I got the same error.
I also logged out and logged back in incognito mode thinking that it could be cached but it didn't work.
What do you think the issue could be?

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 29,195 Super User 2025 Season 2 on at

Like (0)

Report

Close Income Statement issue

In your screenshot in the fiscal year ending date you have january 1. You need to enter december 31.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
JohnGPIT 18 on at

Like (0)

Report

Close Income Statement issue

I have used the Data Editor table and corrected the dates accordingly
However, I closed 12/31/2022 from the Close Income Statement, however I am unable to close 01/31/2023

What's going on? am I missing something?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 91,851 Super User 2025 Season 2 on at

Like (0)

Report

Close Income Statement issue

Hi, hope the following helps as well.

Dynamics 365 Business Central: Can we skip/ignore field validation errors?

https://yzhums.com/44435/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 29,195 Super User 2025 Season 2 on at

Like (0)

Report

Close Income Statement issue

When you open a table using the data editor app there's a boolean field "Without Validation" that you can select. You need to select this option, otherwise you will get the error messages below.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
JohnGPIT 18 on at

Like (0)

Report

Close Income Statement issue

@Valentin Castravet, thank you for your suggestion.
I installed the custom app that you suggested, please see images below.

I'm still unable to edit the Fiscal Year from the accounting period.
Is there something else that I need to do to be able to edit the fiscal year?

Thank you for your help

Was this reply helpful? Yes No