Job page · General ledger
Out of balance ledger settlements
A page that finds ledger settlements that are out of balance in an open fiscal year.
- Used by
- Accountant, Accounting manager, Accounting supervisor and 2 more roles
- Business process
- —
- Menu item
LedgerTransSettlementBalanceValidation- Main table
LedgerTransSettlementInvalidHeaderTmp- Data entity
- —
- Setup steps
- —
Show what matters for
Everyone
1What it is and why
| What it is | A page that finds ledger settlements that are out of balance in an open fiscal year. |
|---|---|
| What you do here | Used to review and unsettle out-of-balance ledger settlements so that the year-end close doesn't fail with an out-of-balance error. |
| Example | Find and unsettle cross-year ledger settlements that were made before the Enable advanced awareness options parameter was set to Yes. |
Functional consultant · Solution architect
2Where it fits
| Business process | — |
|---|---|
| Menu path | General ledger › Periodic tasks › Out of balance ledger settlements |
| Set up first | General ledger parameters Microsoft Learn ↗ |
| Used next by | Year end close Microsoft Learn ↗ |
| Related pages | Ledger settlements Microsoft Learn ↗ |
End user · Functional consultant
3How to do it
Microsoft's steps
- Go to General ledger > Periodic tasks > Out of balance ledger settlements.
- Select the fiscal year, and then select Show ledger settlements.
- Select a Settlement ID to see all the transactions settled under it.
- Mark the settlement lines to reverse, and then select Unsettle marked records.
Source: Microsoft Learn ↗
Field guide
| Field | What it means | Worked example | Table column |
|---|---|---|---|
| Fiscal year | The fiscal year to check; only open fiscal years can be chosen.Microsoft Learn ↗ | — | — |
| Reversal blocked | Shows when a settlement can't be reversed from this page, for example because it includes a closed year or a realized gain or loss.Microsoft Learn ↗ | — | — |
| Settlement ID | Opens all transactions settled together under that ID, including ones outside the selected year.Microsoft Learn ↗ | — | — |
Functional consultant
4Setup decisions
| Setup step | Recommended value and why | Decision · common mistake · test |
|---|---|---|
| — No setup is made on this page. | ||
Solution architect
5Design impact
| Shared or per company | — |
|---|---|
| Can it be undone | — |
| Feature or country | — |
| If you change it later | Settlements reversed here shouldn't be settled again the same way, because they were out of balance. Microsoft Learn ↗ |
Technical architect
6Technical
| Menu item | LedgerTransSettlementBalanceValidation Checked in Dynamics 365 |
|---|---|
| Form | LedgerTransSettlementBalanceValidation Checked in Dynamics 365 |
| Table | LedgerTransSettlementInvalidHeaderTmpShown as “Ledgertranssettlementinvalidheadertmp” in Record infoChecked in Dynamics 365 |
| Data entities | — |
| Who can open it | PrivilegesSettle ledger transactions LedgerTransSettlementProcessLedgerTransSettlementView LedgerTransSettlementViewDutiesLedgerSettlementTransactionsProcess LedgerSettlementTransactionsProcessLedgerSettlementTransactionsView LedgerSettlementTransactionsViewMaintain ledger journal transactions RentalLedgerJournalsAndTransMaintain5 security rolesAccountantLedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerRental manager RentalManager |
| Actions on the page | Buttons: Unsettle marked recordsChecked in Dynamics 365 |
Developer
7Developer
| Open it directly | https://<your-environment>/?mi=LedgerTransSettlementBalanceValidation |
|---|---|
| Integrate with | — |
| Table definition | — |
Everyone
8Sources and checks
- learn.microsoft.com/dynamics365/finance/general-ledger/ledger-settlement-out-balance
- learn.microsoft.com/dynamics365/finance/general-ledger/ledger-settlement-out-balance
- Checked in a working Dynamics 365 system, version 10.0.49: the menu item, form, table and security, the page.