web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Current Financial Year...
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Current Financial Year TB Snapshot

(3) ShareShare
ReportReport
Posted on by DG-22070506-0 97
Hi
 
 I would like to know how we determine where the current financial  year is linked to in the Ledger Calenders in D365 F & O . 
 
 The reason for the question is that when we run the Trial Balance snapshot while having the FY26 period open but we want to be able to generation the TB snap shot  for the FY 25 . When we select the Current financial year as a prompt to  run the snap shot its generates data for the FY 26 and not for FY 25. Can you please advise where the current financial year is  linked in the Ledger Calenders.
 
Thank  you 
 
Dhakshi
Categories:
Dynamics 365 general
I have the same question (0)
  • Verified answer
    Holly Huffman Profile Picture
    Holly Huffman 6,554 Super User 2026 Season 1 on at
    Good morning, afternoon, or evening - depending on your location :)
    Hope you are well today!
     
    To address this issue in Dynamics 365 Finance & Operations, here's how the current financial year is linked to the Ledger Calendars and how you can ensure the correct snapshot for the desired financial year:
    Steps to Check and Adjust Financial Year Linkage:
    1. Ledger Calendar Configuration:
      • In D365 F&O, the financial year settings are linked to the Fiscal Calendars under the General Ledger module.
      • Navigate to General Ledger > Ledger Setup > Fiscal Calendars to review the configuration for the fiscal year periods.
    2. Determine Current Financial Year:
      • The system uses the current system date or the ledger's "current fiscal year" configuration to determine what constitutes the "Current Financial Year."
      • Verify which fiscal year the system date is falling into, as this can impact the Trial Balance snapshot's interpretation.
    3. Review Ledger Setup:
      • Go to General Ledger > Ledger to check the specific ledger setup for your company. Look for the fiscal calendar assigned to the ledger.
      • Confirm the open fiscal years and periods for that ledger and ensure FY25 is marked as active and open for transactions or reporting.
    4. Correcting the Trial Balance Snapshot:
      • If FY26 is being incorrectly selected, ensure that the date parameters for the Trial Balance snapshot are explicitly set. This overrides the "Current Financial Year" selection.
      • When running the Trial Balance snapshot:
        • Go to Trial Balance Snapshot > Parameters.
        • Specify the fiscal year start and end dates for FY25 instead of relying on the "Current Financial Year" option.
      • Ensure FY25 is open and properly configured in the fiscal calendar.
    5. Validate "Current Financial Year" Calculation:
      • If the system default for "Current Financial Year" isn't aligning with your expectations, you may need to adjust the fiscal calendar or the system date to reflect the correct fiscal year.
    Key Considerations:
    • Ensure that FY25 periods are not closed in the fiscal calendar setup, as this could cause the system to default to FY26 when generating the Trial Balance snapshot.
    • If your fiscal year spans multiple calendar years, verify that the correct fiscal year is being selected based on the system date logic.
     
    Hope this helps :)
  • Suggested answer
    Abhilash Warrier Profile Picture
    Abhilash Warrier 7,454 Super User 2026 Season 1 on at
    Hi 
     
    Could you please provide more insights. Are you trying to generate the Trail Balance from Inquires & Reports or using the Financial Reports? 
     
    If are using Trial Balance under the Inquires & Reports, you can try setups under Date & Intervals.
     
    If you are using the Financial Reports or Management reporter, then you can review the Row Definition & the Report Definition.
     
    Filter criteria for FY depends on the Date Intervals and setups. 
     
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
11manish Profile Picture

11manish 135

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 86 Super User 2026 Season 1

#3
Martin Dráb Profile Picture

Martin Dráb 58 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Welcome to the Microsoft Dynamics 365 forum!
Identifying an Org as CDS or Dynamics
Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans