1. User Guide
  2. GL to Management Reporting
  3. Maintaining the Mappers for GL to Management Reporting Result Table
  4. Possible Mapping Combinations
  5. Mapping Combinations at Child Hierarchy Level
  6. One-to-One mapping with or without Debit Credit Indicator

29.4.2.1.1 One-to-One mapping with or without Debit Credit Indicator

To map one GL Code to one Reporting Line Code, use the Mapper Maintenance utility. In this utility, select one member in the General Ledger Code for Mgmt Reporting hierarchy, select one member in the Debit Credit Indicator hierarchy with the value Debit or Credit or Missing, and select one member in the Reporting Line Code hierarchy. As a result, during the T2T process, the corresponding data from the Stage GL Data table for the selected GL Code loads into the Fact Management Reporting table.

Note:

The conditions for the Debit Credit Indicator column values in the Stage GL Data table are:
  • The value must be M, when you map GL Code to the Missing (MSG) member. If nothing is mapped, the system automatically sets value to M.
  • The value must be D, when you map GL Code to the Debit member.
  • The value must be C, when you map GL Code to the Credit member.

To perform One-to-One mapping with or without Debit Credit Indicator, follow these steps:

  1. In the Mapper Maintenance page, in the Member combinations section, click Add.

    Figure 29-4 Select Add in the Mapper Maintenance page for the One-to-One mapping at child hierarchy level


    This illustration shows selecting Add in the Mapper Maintenance page for the One-to-One mapping at child hierarchy level.

  2. The Add Mappings page is displayed. For illustration, select the member of the General Ledger Code for Mgmt Reporting hierarchy OTH - Others, and the member of the Debit Credit Indicator for Mgmt Reporting hierarchy D - Debit to map to the member of the Reporting Line Code for Mgmt Reporting hierarchy 100 - Corporate with the member of the GL Rollup Signage for Mgmt Reporting hierarchy P - Positive Multiplier.

    Figure 29-5 Add Mappings page for the One-to-One mapping at child hierarchy level


    This illustration shows the Add Mappings page for the One-to-One mapping at child hierarchy level. Select the required codes.

  3. To map the members, click Go. The list of mapped members appear at the bottom. To save the mappings, click Save.

    Figure 29-6 Map the members and save the mappings


    This illustration shows mapping the members and saving the mappings. Click Go to proceed with the mapping. Then click Save to save the mappings.

  4. An acknowledgement message is displayed. To confirm saving the mapping, click Yes.
  5. The mapped member combinations are listed in the Mapper Maintenance page.

    Figure 29-7 Added mappings listed in the Mapper Maintenance page


    This illustration shows the added mappings listed in the Mapper Maintenance page.