Beginning with Release 3.0, you can manage an average balance ledger. This is an additional ledger that is assigned to a 'normal' direct posting ledger (in FI or SL) and which also inherits the attributes of the direct posting ledger (such as fiscal year variant, assigned table, and so on).
As the name suggests, the average balances are stored per period in the average balance ledger, that is, all incoming and outgoing postings are weighted with the posting date.
Example: Average monthly balance sheet change
| Posting | Posted | Portion | Balance | Average balance |
|---|---|---|---|---|
| date | value | |||
| 11.01. | 1000.-- | 30/30 -> | 1000.-- | 1000.-- |
| 11.16. | 1000.-- | 15/30 -> | 500.-- | 1500.-- |
| 11.28. | 1000.-- | 3/30 -> | 100.-- | 1600.-- |
You can specify a user exit for an average balance ledger. However,
you only need to specify a user exit if the posting date is not to be used to calculate the average balance.
The user exit must be defined as follows: xyy, where x is an
application identification code; the customer can thus use Y and Z, and
xx is a two-digit number. Based on this specification, a function module called x_D_LEDGER_yy is called up.
The average balance ledger can currently not be processed further (for example, planning, allocation, rollup); it is only available for reporting and displaying.
To create an average balance ledger, you must call up ledger maintenance for the direct posting ledger and then select Extras -> Average bal.ledger.
Usage in the Report Writer:
You must create a report for the original ledger in the Report Writer.
You access the average balances via separate key figures (HMB, KMB and
TMB for the average monthly balances and HYB, KYB and TYB for the year-to-date values.
For tables that were created before Release 3.0, you can install the key figures as follows:
You have to start the installation program for this table. In the specification pop-up window, however, you only have to select the
Report Writer component.