Finance | Project Operations, Human Resources, ...

Ledger settlement after year end

(2) Share

Report

Posted on by SC-16091546-0

Hi,

In the General Ledger module, we are using the section ledger settlement and we settle all the transaction for a couple of account. The situation is that the module can only display one year and not multiple year. The balance that are not settle at the end 2025 are combine into one amount per GL-dimension. The issue is that only a portion of the amount can be reconcile. When we select the amount we cannot post it since there is a balance remaining. Can change the configuration so that we can match the each transaction or this is a limitation or we can adjust it?

For example we have 20 transaction that are open at the end of the year each line 5K (to make the example easy). We the year end is run to transfer the opening opening balance, all the balance are combine together.
60K gl-402205 dimension 1

30K gl-402205 dimension 2

10K gl-402205 dimension 3

For the Jan & Feb we need to settle 35K dimension 1, 5 K dimension 2 and 5K dimension 3. The system block us because the settlement doesn't net to zero. It there a way around it?

We have balance transfer from previous year and maybe balance from when in import the data when we implemented D365.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Paolo Cecchelli 605 on at

Like (0)

Report
Copy link

Link copied!

Hi,

if I have understood well your requirement, did you already try with the partial ledger settlement? https://learn.microsoft.com/en-us/dynamics365/finance/general-ledger/ledger-settlements-partial#:~:text=For%20partial%20ledger%20settlements%2C%20debits,grid%20to%20track%20this%20information.

Since it is intended to handle these year-end kind of situations in which the balance do not match. Maybe it can apply to your situation, too.

Hope it helps

Was this reply helpful? Yes No
Syed Haris Shah 1,557 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi @SC-16091546-0,

To better understand your current setup and why you are facing this issue, could you please confirm the following configurations in your system?

Partial Ledger Settlement enabled? This feature allows you to settle a portion of a transaction. In your scenario, it would enable you to settle 35K (Dimension 1) against the 60K opening balance, without requiring the total to net to zero.

Keep detail during year-end close enabled? This controls whether individual transactions are carried forward into the new fiscal year. If enabled, your 60K would remain as multiple transactions (e.g., 5K each), instead of being summarized into a single balance. Note: This capability is typically available when Advanced Awareness features are enabled.

Advanced Awareness enabled? This improves visibility and tracking of settlements, including partial settlements and remaining balances.

Important clarification for your current scenario:

If you enable all of the above now, only Partial Ledger Settlement will immediately help resolve your issue by allowing partial settlement (e.g., 35K out of 60K).
However, your existing opening balances will remain aggregated, meaning the system will still show a remaining balance (e.g., 25K) without transaction-level detail.
Enabling Keep detail during year-end close will not fix existing data, but it will prevent this issue in the next fiscal year by preserving transaction-level detail for settlement.

Note: If you want to use partial ledger settlement for new ledger settlement accounts and require detailed tracking for existing aggregated carry forward balances, you will need to post manual journal adjustments to split the aggregated opening balance into multiple detailed lines in the current year. This will allow more controlled and meaningful settlement.

If you find this answer helpful, please consider verifying the answer. 👍

Regards,

Syed Haris Shah

Was this reply helpful? Yes No
Syed Haris Shah 1,557 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @SC-16091546-0,

Just checking in, did the suggested solution work for you?

Regards,

Syed Haris Shah

Was this reply helpful? Yes No