Journal Conversion Rule Examples

This section describes examples that illustrate how journals are converted based on different journal conversion rules.

Example 1: Specific Journal Source and Journal Category Match

The following example shows a matching source/category combination. It also shows that no conversion takes place if there is not a match with any of the defined conversion rules.

Conversion rules are defined in the following table.

Example 1: Journal Conversion Rules

Source Category Convert Journals
Other Other No
Manual Adjustment Yes
Consolidation Consolidation No
Manufacturing Labor Cost Yes

The following table describes the results for journals converted to the reporting currency.

Example 1: Journals Converted to the Reporting Currency

Journal Number Source/Category Results
1 Manual/Adjustment Journal is converted using the defined conversion options for this combination.
2 Consolidation/Consolidation Journal is not converted because the Convert option is set to No.
3 Manufacturing/Freight Journal is not converted because there is no rule defining Journal Source Manufacturing and Category Freight.

Example 2: No Specific Journal Source or Category

The following shows an example of matching a journal source but not a category; and another example of matching a journal category but not a source.

Conversion rules are defined in the following table.

Example 2: Conversion Rules

Source Category Convert Journals
Manufacturing Other Yes
Other Adjustment Yes
Manufacturing Adjustment No

The following table describes the results for journals converted to the reporting currency.

Example 2: Journals Converted to the Reporting Currency

Journal Number Source/Category Results
1 Manufacturing/Labor Cost Journal is converted because the first rule only has a requirement to match to a source of Manufacturing with any category.
2 Manual/Adjustment Journal is converted because a rule has a requirement to match to any source with the Adjustment category.
3 Spreadsheet/Adjustment Journal is converted because a rule has a requirement to match any source with the Adjustment category.
4 Manufacturing/Adjustment Journal is not converted because the Convert option is set to No for this source/category combination.

Example 3: Journal Source and Journal Category Conflicting Rules

The following example shows what happens when you set up contradictory rules for journal source/category combinations. The rule for the source always overrides the rule for the category.

Conversion rules are defined in the table below.

Example 3: Conversion Rules

Source Category Convert Journal
Other Adjustment No
Manual Other Yes

The following table describes the results for journals converted to the reporting currency.

Example 3: Journals Converted to the Reporting Currency

Journal Number Source/Category Results
1 Manufacturing/Adjustment Journal is not converted because it matches the first rule to not convert.
2 Manual/Adjustment Journal is converted because the second rule requires conversion of all journals with the source Manual. The source rule overrides the category rule.