Mapping Ledgers to Resources

This section lists prerequisites and discusses how to:

Set up Activity-Based Management ledger mapping rules.
Set up ledger-to-resource mapping.

Pages Used to Map Ledgers to Resources

Page Name	Definition Name	Navigation	Usage
Ledger Map Rule	ABM_LEDMAP_RULE	select Activity Based Management, then select Setup, then select Ledger Source, then select Ledger Map Rule	Specify the source ledgers to use for actual and budget amounts.
Map Ledger to Tree	ABM_LM_TOPT_TBL	select Activity Based Management, then select Setup, then select Ledger Source, then select Ledger Mapping Tree Usage	Set up ledger mapping tree usage for ChartFields.
Ledger Mapping Defaults - Tree and Node Views	ABM_LED_TMPL_TBL1	select Activity Based Management, then select Setup, then select Ledger Source, then select Ledger Mapping Defaults, then select Tree and Node Views	Configure ledger mapping defaults by entering the tree view, tree node, and tree to use for those ChartFields that are identified as using trees.
Ledger Mapping Defaults - Tree View	ABM_LED_TMPL_TBL2	select Activity Based Management, then select Setup, then select Ledger Source, then select Ledger Mapping Defaults, then select Tree View	Select the specific trees to use for mapping.
Ledger to Resource Mapping	ABM_LEDMAP_TBL1	select Activity Based Management, then select Setup, then select Ledger Source, then select Ledger to Resource Mapping	Assign costs to resources by using or overriding ledger defaults that you define using the Ledger Mapper Defaults page.

Prerequisites

Before setting up Activity-Based Management ledger-to-resource mapping rules, complete the following business rules setup:

Access the Ledger Source page to identify the source of information to be mapped and specify the ChartFields to use.
Access the Map Ledger to Tree page, and then select the check boxes next to the ChartFields that you want to associate with the trees.
Access the Ledger Mapping Defaults - Tree and Node Views page.

The system displays your changes from the Map Ledger to Tree page. Enter the tree view, tree node, and tree to use for those fields identified as using trees. Specify whether the field accepts all values or tree values and if the field is required.
Access the Ledger Mapping Defaults - Tree View page.

The tree names display for the ChartFields that you want to associate with the trees. In the Validation group box, select all check boxes associated with required fields.

Ledger Map Rule Page

Use the Ledger Map Rule page (ABM_LEDMAP_RULE) to specify the source ledgers to use for actual and budget amounts.

Navigation

select Activity Based Management, then select Setup, then select Ledger Source, then select Ledger Map Rule

Image: Ledger Map Rule page

This example illustrates the fields and controls on the Ledger Map Rule page. You can find definitions for the fields and controls later on this page.

Actuals Source ID

Select the identifier of the actuals source.

Note: A source is identified by its datamap and ChartField configuration.

Constraint Code - Actuals

Enter the code associated with the actual constraint to identify where the PeopleSoft EPM constraint definition tables are located for this model such as the datamap, source, and ChartFields to use by the rule for ledger-to-resource mapping.

Note: The constraint code filters values for objects at runtime. Invalid or duplicate constraint codes cause jobstreams to abort.

Note: The constraint used for actual and budget can be (but is not required to be) the same.

Budget Source ID

Select the identifier of the budget source.

Constraint Code - Budget

Enter the code associated with the budget constraint to identify where the PeopleSoft EPM constraint definition tables are located for this model—the datamap, source, and ChartFields to be used by the rule for ledger-to-resource mapping.

Note: The constraint code filters values for objects at runtime. Invalid or duplicate constraint codes cause jobstreams to abort.

Note: The constraint used for budget and actual can be (but is not required to be) the same.

Ledger to Resource Mapping Page

Use the Ledger to Resource Mapping page (ABM_LEDMAP_TBL1) to assign costs to resources by using or overriding ledger defaults that you define using the Ledger Mapper Defaults page.

Navigation

select Activity Based Management, then select Setup, then select Ledger Source, then select Ledger to Resource Mapping

Image: Ledger to Resource Mapping page

This example illustrates the fields and controls on the Ledger to Resource Mapping page. You can find definitions for the fields and controls later on this page.

Mapper Type

Select the mapping on which you are currently working. Values are:

Actuals: Specifies that the current mapping represents the actual costs of the accounting period.

Budgeted: Specifies that the current mapping represents the amount used to calculate the capacity rates as well as the budgeted model results.

Source Unit

Enter the source business unit that you want to map to Activity-Based Management.

Percentage

Enter the percentage of cost assigned to the specified resource based on the mapping rule.

Note: For example, from a GL source, account 150000 assigns 20 percent of the posted amount to Resource 1.

Displays up to eight editable ledger mapping ChartField settings associated with the model's source. Indicate which ChartField values to use, either all ChartField values, the ChartField values included in a tree node, or a specific ChartField value.

The system hides unused ChartFields.

Note: To configure ChartFields, access the Ledger Source page.

All

Select to use all of the values that are defined for the ChartField.

Tree

Select to use only the ChartField values that are included in the selected tree node.

Note: If Tree Name not defined displays, specify the tree name using the Tree and Node Views page.

Note: If you do not select All or Tree for a ChartField, you may enter a specific value, or select one from the prompt list. However, a prompt list appears only if the record metadata for the source ledger has a prompt table defined for that ChartField.

Warning! When mapping activity based costing resources, do not mix tree nodes and direct accounts as this may lead to duplicate mappings that result in engine failure. Use the PeopleTools Tree Manager page to create tree nodes and prevent duplicate mappings.