A day ledger is a totals table with a fiscal year variant of 366 periods and containing all original postings for the general ledger.
You create a day ledger if you want to create reports for average balances (reports for displaying average daily balances). You can activate the day ledger for drilldown reporting. For more information, see SAP Note 599692.
Caution
You may not define a day ledger as the leading ledger or as the representative ledger in a ledger group.
For day ledgers, you also cannot define different posting periods and a fiscal year that differs from the fiscal year of the representative ledger.
When defining a cycle for a ledger, you can specify a ledger group .
You can define this ledger group so that it contains the source ledger and the day ledger.
Note, however, that an allocation is posted as period-end closing on the last day of the period.
Let us assume that you have made the following postings:
Date |
Amount in EUR |
---|---|
January 5 |
100 |
January 8 |
200 |
January 17 |
300 |
February 5 |
400 |
This results in the following balances in the ledgers:
Leading Ledger (16 Periods) Period/Amount |
Day Ledger Period/Amount |
---|---|
1 /600 |
5 /100 |
2 /400 |
8 /200 |
17 /300 |
|
36 /400 |
If you perform the allocation for January (postings up until January 31), you distribute EUR 600 to other units:
Leading Ledger (16 Periods) Period/Amount |
Day Ledger Period/Amount |
---|---|
1 / 0 |
5 /100 |
2 /400 |
8 /200 |
17 /300 |
|
31 / -600 |
|
36 /400 |
Note
For more information on allocation in New General Ledger Accounting, see Allocation .