Skip to main content

Notifications

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

Close Income Statement issue

(2) ShareShare
ReportReport
Posted on by 18

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:

  1. 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
  2. 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.
  3. 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:

  1. Corrected the fiscal year setup for 2025 and beyond to ensure they align with a January–December fiscal year.
  2. 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. 
  3. 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:

  1. How can I close 12/31/2023 properly, because as you can see in the image I am unable to close it ?
  2. 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!

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 77,201 Super User 2025 Season 1 on at
    Close Income Statement issue
    Hi, the Close income statement accounts function is used to close the fiscal year, not the monthly.
    More details:
     
    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
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,787 Super User 2025 Season 1 on at
    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.
     
  • JohnGPIT Profile Picture
    JohnGPIT 18 on at
    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 
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,787 Super User 2025 Season 1 on at
    Close Income Statement issue
    that still looks like january 31, not december 31 in your screenshot
  • JohnGPIT Profile Picture
    JohnGPIT 18 on at
    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?

  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,787 Super User 2025 Season 1 on at
    Close Income Statement issue
    In your screenshot in the fiscal year ending date you have january 1. You need to enter december 31.
     
  • JohnGPIT Profile Picture
    JohnGPIT 18 on at
    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?
     
     
     
     
     
     
     
     
     
     
     
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 77,201 Super User 2025 Season 1 on at
    Close Income Statement issue
    Hi, hope the following helps as well.
    Dynamics 365 Business Central: Can we skip/ignore field validation errors?
     
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,787 Super User 2025 Season 1 on at
    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.
     
  • JohnGPIT Profile Picture
    JohnGPIT 18 on at
    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 
     
     
     
     
     
     
     
     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,111 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,934 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans