SQL Troubles: 🧾D365: GL

🧾D365: GL

Disclaimer: Attempting to map the various sources based on the General Ledger (GL) functionality and features. So, this is work in progress. Some links might stop working!

General Ledger

apply Sales tax to Item GL account: Keener
item groups

Post to Deferred Revenue Account on Sales Delivery Britstra

negative revenue: Britstra

Journal entries

General journals

post and transfer: Britstra
[10.0.29] allow edits to internal data on general ledger vouchers: Microsoft
ledger vs subledger: Britstra (BP1, BP2)
journal control: Britstra
voucher transactions: DAFTD365

Global general journals
Post journals
Periodic journals
Allocation journals
Reporting currency adjustment journals
Advanced ledger entries

Allocations

Allocation journals
Process allocation request
Ledger allocation rules
Ledger allocation basis
Allocation rules definition report

Period close

Financial period close workspace
All financial period close tasks
Financial period close configuration
Purchase order year-end process
General budget reservation year-end process
Closing period adjustments
Year end close

Month end close: DAFTD365

Ledger calendars
Fiscal calendars
Commitment close

Chart of accounts

Accounts

Main accounts
Chart of accounts
Main account categories
Main account templates
Ledger account alias: DAFTD365
Consolidation account groups
Additional consolidation accounts
Balance control accounts
Treasurer's fund accounts

Dimensions

Financial dimensions: Britstra

rename: Keener

Financial dimension sets
Financial dimension configuration for integrating applications
Financial dimension service parameters
Financial dimension default templates
Associate financial hierarchies
Derived financial hierarchies

Structures

Configure account structures
Advanced rule structures

Financial tags

Financial tags: Britstra

Funds

Funds

Fund types

Currencies

Foreign currency revaluation
Currency exchange rates
Exchange rate types
Currencies
Configure exchange rate providers
Import currency exchange rates
Currency revaluation posting profile
Currency revaluation accounts
Denomination currencies

Calendars

Ledger calendars
Fiscal calendars

Inquiries and reports

Trial balance
Accounting source explorer
Voucher transactions
Outstanding encumbrances
Voucher transactions history
Audit trail
Financial reports

Ledger reports
Dimension statement
Ledger transaction list
Print journal
Posted transactions by journal
Transaction list by date
Transaction origin
Encumbrance
Posted advanced ledger entry transactions
General ledger statement by main account
Treasurer’s statement of accountability

Period end reports

Close-of-year transactions report
General journal entries that have not been posted
Allocation rules definition

Consolidation reports

Consolidation transactions
Elimination rules definition

Standard Audit File for Tax (SAF-T)

Standard Audit File for Tax (SAF-T)

Setup

Ledger

General ledger parameters
Ledger calendars
Fiscal calendars
Year-end close template setup
Date intervals
Financial reporting setup
Period allocation categories
Check voucher series
Process automations

RPA: Edwards

Cash control configuration
Cash position parameters

Journal

Journal names:
General ledger workflows
Accrual schemes: Begum, Bharti, Soni
Journal descriptions
Default descriptions
Ledger reasons
Financial reasons

Posting

Accounts for automatic transactions
Intercompany accounting
Currency revaluation accounts
Transaction posting definitions
Posting definitions

posting layers: Britstra
posting dates: DAFTD365

Copilot for Finance

What's new and planned [link]

Updates for Finance

[10.0.43] features PP Jan-2025, GA1 Mar 2025, GA2 Apr 2025
[10.0.42] features PP Oct-2024, GA1 Dec 2024, GA2 Feb 2025
[10.0.41] features PP Jul-2024, GA1 Sep 2024, GA2 Oct 2024
[10.0.40] features PP Apr-2024, GA1 May 2024, GA2 Jun 2024
[10.0.39] features PP Jan-2024, GA1 Mar 2024, GA2 Apr 2024
[10.0.38] features PP Oct-2023, GA1 Dec 2023, GA2 Feb 2024
[10.0.37] features PP Sep-2023, GA1 Oct 2023, GA2 Nov 2023
[10.0.36] features PP Jul-2023, GA1 Sep 2023
[10.0.35] features PP May-2023, GA1 Jul 2023
[10.0.34] features PP Apr-2023, GA1 Jun 2023
[10.0.33] features PP Mar-2023, GA1 Apr 2023
[10.0.32] features PP Jan-2023, GA1 Mar 2023
[10.0.31] features PP Oct-2022, GA1 Jan 2023
[10.0.30] features PP Sep-2022, GA1 Oct 2022

Release waves for Finance

2025 wave 2:
2025 wave 1: overview
2024 wave 2:
2024 wave 1:
2023 wave 2:
2923 wave 1:

New Features

[10.0.35] Automatic split of large financial journals: Britstra
[10.0.32] 'Financial tags': Britstra
[10.0.31] General Ledger Adjustments: Britstra
[10.0.31] 'Awareness between ledger settlement and year-end close': Baumgarten, Britstra
[10.0.29] 'Allow edits to internal data on general ledger vouchers': Baumgarten
[10.0.29] 'Include or exclude reporting currency adjustments in the general ledger foreign currency revaluation': Baumgarten
Transaction text for ledger reversal entries: Britstra
Enable the Global general journal form to select multiple companies for posting: Britstra