Define General Ledger Conversion Rules
You can define conversion rules for all predefined journal sources except these:
- Revaluation, Move/Merge, and Move/Merge Reversal -- MRC will not convert journals that have these journal sources. Instead, you need to run each of these processes in both your primary and reporting sets of books.
- Receivables, Assets, Projects, AX Payables, and AX Receivables -- MRC converts transactions from these sources directly in the subledgers and stores the related reporting currency amounts in those subledgers.
To assign conversion rules to General Ledger:
- 2. Mark the Convert check box if you want journals with the specified journal source and category to be converted to your reporting currency. Leave the check box unmarked if you do not want journals with the specified journal source and category to be converted.
- 3. Enter the journal source and category for which you want to set conversion rules.
Note: You can enter a specific journal source or category or enter Other to select a source or category other than those you have specifically defined.
- 4. Select the Reporting Conversion Type and No Rate Action to use when converting journals with the specified journal source and category.
- 5. Save your work.
Journal Source/Category Combinations
MRC uses the journal source and category combinations you define in your GL conversion rules to determine if a journal should be converted.
When you post journals in your General Ledger primary set of books, MRC notes each journal's source and category as it is posted. MRC then searches your defined conversion rules for a matching source and category combination. MRC searches the conversion rules in the following order, regardless of the order you entered the rules on the GL Conversion Rules window:
| Search Order | Journal Source | Journal Category |
|---|---|---|
| 1 | Specific source | Specific category |
| 2 | Specific source | Other |
| 3 | Other | Specific category |
| 4 | Other | Other |
| Table 1 - 3. (Page 1 of 1) | ||
If MRC finds a matching source/category combination, it notes the reporting currency type and checks to see if transactions with the identified source/category combination are to be converted. If they are to be converted, MRC converts the journal amount to the reporting currency and creates the converted journal in the reporting set of books. Otherwise, the journal is not converted and the next journal in the posting batch is processed.
Note: If MRC cannot find a matching source/category combination, or if you have not defined any GL conversion rules, the journal will not be converted.
Below are three examples that illustrate how journals are converted based on different conversion rules.
Example Assumptions
| Journal Source | Journal Category | |
| Journal #1 | Manual | Adjustment |
| Journal #2 | Consolidation | Consolidation |
| Journal #3 | Manufacturing | Freight |
| Journal #4 | Spreadsheet | Adjustment |
| Journal #5 | Manufacturing | Labor Cost |
Example 1
The following six conversion rules are defined:
| Source | Category | Convert | Result |
|---|---|---|---|
| Manual | Adjustment | Yes | Journal #1 is converted, using the defined conversion options for this combination. |
| Consolidation | Consolidation | No | Journal #2 is NOT converted. |
| Other | Freight | Yes | Journal #3 is converted, using the defined conversion options for this combination. (i.e., All journals with category Freight are converted). |
| Spreadsheet | Reclass | Yes | No journals in the example match this combination. (All journals with source Spreadsheet and Category Reclass are converted, using the defined conversion options for this combination.) |
| Spreadsheet | Other | No | Journal #4 is NOT converted. (i.e., All journals with source Spreadsheet (except those with category Reclass) are NOT converted.) |
| Other | Other | Yes | Journal #5 is converted, using the defined conversion options for this combination. |
Example 2
The following three conversion rules are defined:
| Source | Category | Convert | Result |
|---|---|---|---|
| Manufacturing | Freight | No | Journal #3 is NOT converted. (i.e., All journals with source Manufacturing and category Freight are NOT converted.) |
| Manufacturing | Other | Yes | Journal #5 is converted. (i.e., All journals with source Manufacturing are converted, except those with category Freight.) |
| Other | Other | Yes | Journals #1, 2, and 4 are converted, using the defined conversion options for this combination. |
Example 3
The following two conversion rules are defined:
| Source | Category | Convert | Result |
|---|---|---|---|
| Manufacturing | Freight | No | Journal #3 is NOT converted. (i.e., All journals with source Manufacturing and category Freight are NOT converted.) |
| Manufacturing | Other | Yes | Journal #5 is converted. (i.e., All journals with source Manufacturing are converted, except those with category Freight.) |
Note: In this example, Journals #1, 2, and 4 are NOT converted, since there is no conversion rule defined with a source of Other and a category of Other.
Changing Conversion Rules
You can delete General Ledger conversion rules at any time. You can also change a conversion rule as needed. For example, for any journal source/category combination, you can change the Convert option, Reporting Conversion Type, and No Rate Action value. Note that the changes are effective immediately, but that they apply only to new journals. The change has no effect on previously entered journals.
Comments
Post new comment