Previous  Next          Contents  Index  Glossary  Library

Step 6 - Define General Ledger Conversion Rules

When you use MRC with General Ledger, you need to define conversion rules in addition to the effective dates you specify for General Ledger's conversion options in the previous step. Conversion rules control journal conversion at the journal source/category level.

You can define conversion rules for all predefined journal sources except these:

Note that GL Conversion Rules for the Payables and Purchasing journal sources are applied only to encumbrance journals. MRC will not convert actual journals that have these journal sources assigned.

See: Special Considerations for General Ledger

   To assign conversion rules to General Ledger:

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.

See: Defining Journal Sources
  Defining Journal Categories

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

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.


         Previous  Next          Contents  Index  Glossary  Library