13.3.1.2.1 Management Ledger Source

This section describes using the Management Ledger as the Source in allocation rules.

The Management Ledger is a seeded table of a new Management Ledger class of tables (see the OFS Data Model Utilities User Guide for details on adding user-defined dimensions to the Management Ledger or for defining new user-defined Management Ledger tables. The Management Ledger table supports nearly identical allocation functionality as the Ledger/Stat table. From Release 8.1, the Management Ledger replaces the Ledger/Stat table. Customers starting new implementations must use the new Management Ledger table for ledger-level management accounting. For details on the new Management Ledger table, see Management Ledger.

When your Source is the Management Ledger table, use the <Current Amount> macro as your column name. The Management Ledger table is the default table for new allocation rules (except for the Constant type), and <Current Amount> is the default column. The <Current Amount> macro selects the current month from your Management Ledger based on your As-of-Date and Fiscal Year definitions. If your As-of-Date is set to any day in March, <Current Amount> is interpreted as Fiscal Month 3. If your fiscal year begins in April, your March data is stored in the Management Ledger under Fiscal Month 12, since March is the last month in your fiscal year. For details on the fiscal year, see Fiscal Year Information.

Note:

Allocation rules that aggregate instrument-level data to the Management Ledger table maintain literal As-of-Dates when posting to the management ledger, but when data is retrieved from the Management Ledger table (such as in Allocation Sources or Allocation Drivers), it is consolidated into a month-to-date balance. For example, if you perform daily instrument-level Funds Transfer Pricing and if you use an allocation rule to aggregate daily Funds Transfer Pricing Charges or Credits from the instrument level to the Management Ledger, each day's charges and credits are posted to the Management Ledger by As-of-Date (by business date). Allocation rules that reference these Management Ledger balances, however, combine the daily postings to obtain month-to-date balances. Similarly, all outputs at the management ledger level are inherently month-to-date balances.

When your Source is the Management Ledger table, Profitability Management also supports the following macros:

  • <Last_Mo_Amount>
  • <Months_Ago_Amt>
  • <Current_Amount>
  • <YTD_Amount>
  • <Months_Ago_YTD_Amt>
  • <Last_Mo_YTD_Amt>
  • <Accrual_Basis>

<Last Mo_Amount> selects month-to-date balances from the month before your As-of-Date. <Months_Ago_Amount> selects month-to-date balance as of a designated number of months ago. For example, with a typical January to December fiscal year, if today's As-of-Date is March 31, 2015 (Fiscal Month = 3, Fiscal Year = 2015) then in the Enter Months field, enter 6 months ago. This corresponds to September, 2014 (Fiscal Month = 9, Fiscal Year = 2014). The month range for entering Months is from -99 to 999. For details on the fiscal year, see Fiscal Year Information.

Note:

When you select any of these macros, the Entered_Balance column in the Management Ledger table gets selected.

Figure 13-7 Allocation Specification - Source tab


This screen allows you to define the Management Ledger as the Source in allocation rules.