1. User Guide
  2. Business Rules Administration
  3. Application Specific Rules
  4. Allocation Specification
  5. Detail Screen
  6. Source Process Tab
  7. Source Definition Pane
  8. Management Ledger Source

5.3.1.1.3.1.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 Data Model Extension Guide for details on adding User-Defined Dimensions to the Management Ledger or for defining new User-Defined Management Ledger Tables.)

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.

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, the following macros are supported:

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

<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.

Note:

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