Current Financial Year TB Snapshot

(3) Share

Report

Posted on by DG-22070506-0

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)

All responses (2)

Answers (1)

Verified answer

Holly Huffman 6,530 Super User 2025 Season 2 on at

Like (1)

Report
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:

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.

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.

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.

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.

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 :)

Was this reply helpful? Yes No
Suggested answer

Abhilash Warrier 5,402 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No