1. Implementing Subledger Accounting
  2. How You Define Mapping Sets

How You Define Mapping Sets

Define a mapping set when you have a matrix of input values that produce distinct output values. For each input value, specify a corresponding account combination or segment output value.

One or more related pairs of these input values with the segment or account combination output values form a mapping set.

To define a mapping set, select the input sources, output type, and mappings. The mappings section displays how input values are mapped to output values. You can define multiple mapping sets for different combinations of input sources.

To define mapping sets:

  • Specify the output type:

    • The output type for a mapping set can be an account combination, segment, or value set.

    • Use value set:

      • If the value set is used by more than one chart of accounts,

      • And the mapping set can be reused across multiple charts of accounts.

    • Expected input or output combinations are constant across the charts of accounts.

    • Based on the selection, the mapping set provides the value for an account, segment, or value set.

  • Select the input source:

    • Specify the input source for mapping.

      • The input source is provided for predefined mapping sets. You can select input sources through a lookup or value set.

      • You can add up to 10 input sources in a mapping set.

  • Select either the chart of accounts, segment, or value set for which mappings are to be defined depending on the output type entered.

  • Define the mappings:

    • For a given set of input values, enter the corresponding output value.

    • The account rule uses this value to populate either the account or the segment.

      • If the output type is a value set, the output value is an individual value from the value set entered.

      • If the output type is a segment, the output value is an individual segment value.

      • If the output type is an account combination, the output value is an entire account.

    • If the input source is a GL account, enter a Transaction Chart of Accounts and a GL account in the context of the transaction chart of accounts. The transaction chart of accounts refers to the chart of accounts with which the transaction is associated, and this is usually the primary ledger's chart of accounts.

Mapping set with account combination output type can be assigned to account rule if:

  • The account rule type is account combination, and it's not associated with any chart of accounts, or

  • The account rule type is account combination, and it has been assigned the same chart of account as the mapping set.

Mapping set with segment output type can be assigned to account rule if:

  • The account rule type is a segment, and it's not associated with any chart of accounts, and the segment label matches with the segment in the mapping set, or

  • The account rule type is a segment, and it has the same chart of accounts and segment of the mapping set.

Mapping set with value set output type can be assigned to account rule if:

  • The account rule type is value set, and the value set on the account rule and mapping set is the same, or

  • The account rule type is a segment, and the value set on the mapping set is assigned to the chart of account and segment of the account rule.

Assign a default value to the mapping set

  • In certain situations, one of the rows can be assigned as a default value in the mapping set. This can be used in cases where it's not possible to define all the values. When defining a row as default, enter the output value and select the Set Default button. it's not required to enter any input values.

Identifying the Sources for New Mapping Sets

  • When creating a new mapping set, the input sources have to be selected based upon the Event Class, where the mapping set will eventually be used.

  • Sources may or may not have a value set or lookup type assigned. You can assign a value set or lookup type if the input source doesn't have one assigned yet. However, the mapping set works only if the value defined in the value set or the lookup code matches with the input source value.

Example to Create Mapping Set with Single Source

In the following example, the chart of accounts is set up with four segments. A mapping set is defined with a value set for Supplier Type as described in the following table.

This table contains examples of input values and output values.

Input Value

Output Value

Services

01-100-6120-000

Consulting

01-400-6110-000

Assume that two invoices are entered, one for a supplier with a type of Services and one for a supplier with a type of Manufacturing.

When using the mapping set, the source value Supplier Type is compared with the mapping set input values to determine the account.

In this example, there's a match for the first case; the invoice with a supplier type of Services maps to an input value. However, the invoice with a supplier type of Manufacturing doesn't map to an input value.

This table contains the derived accounts based on the example.

Invoice

Supplier Type

Output Value

1

Services

01-100-6120-000

2

Manufacturing

No account generated

To ensure that invoice 2 is accounted, you may want to define a default output in the existing mapping set, or modify the account rule to which the mapping set is assigned so that a different account rule priority is applied when supplier type is Manufacturing.

Note: When a match isn't found in the mapping set, and there's no default value, and:.

Example to Create Mapping Set with Multiple Sources

In the following example, multiple input sources are set up with an account combination. This table contains examples of input values and output values.

Inventory Organization Code

Sub inventory Code

Costing Category Identifier

Item Number

Output Value

M1

*

*

*

99-100-1110-00

M2

LAA019

*

*

99-100-1120-00

M2

*

*

*

99-100-1110-00

P1

UXA843

L100

*

99-120-1110-00

P1

UXA843

L200

A92348425

99-220-1110-00

P1

*

*

*

99-130-1110-00

*

*

*

*

99-000-1290-00

In some cases, all the input values might not be relevant. For example,

  • If inventory organization is M1, then always map to 99-199-1110-00 regardless of the sub inventory, cost category, and item number, then use * (any value) for the last three sources.

  • If inventory organization is M2 and sub inventory is LAA019, then map M2 to 99-100-1120-00, and other sub inventory codes to 99-100-1110-00.

  • If inventory organization is P1

    • And if sub inventory is UXA843, and cost category L100, then for any item number map to 99-120-1110-00

    • And if sub inventory is UXA843, and cost category L200, and item number A92348425, then map to 99-220-1110-00

    • For other sub inventory, cost category, and item number, map to 99-130-1110-00

  • For any other input value combination, map to 99-000-1290-00. The last row can be entered with output value and then select the Set Default button.

Use any value (*) for multiple input mapping sets to indicate that the value of a particular input should be ignored for certain mappings. Don't leave them blank. When * is used in one of the input sources, subsequent input value must also be *. For example, the following mappings are invalid and can't be entered.

Inventory Organization Code

Sub inventory Code

Costing Category Identifier

Item Number

Output Value

*

XXX123

*

*

99-100-1110-00

M

*

A1234

*

99-100-1110-00

*

*

*

99999999

99-100-1110-00

*

A1234

*

99-100-1110-00
Note: If the account rule is already assigned to the journal entry rule set, and if the accounting method is active, then run Create Accounting to verify if the mapping set is working as expected. there's no need to activate the accounting method again after modifying or adding any mapping.

Related Topics