Set Up User-Defined Account Rules

Use account rules to create simple or complex rules to assign general ledger accounts to accounting events.

There are several predefined accounting rules that are available and are easily identifiable by looking at the Created By Application column. The predefined account rules aren't ready-to-use as they aren't created in the context of the chart of accounts. The predefined account rules are provided to help you create your own rules by using them as templates.

For example, create an account rule for identifying the general ledger account rules for the Cost of Goods Sold event class.

1. Click Navigator > Setup and Maintenance.

2. On the Setup and Maintenance page, click the Manufacturing and Supply Chain Materials Management offering, and then click Setup.

3. On the Setup: Manufacturing and Supply Chain Materials Management page, based on your requirement, click the Cost Accounting or the Receipt Accounting functional area.

   The subledger accounting related setup tasks are in the respective functional areas.

4. Click the Manage Account Rules task.

5. In the Manage Account Rules page, search for the predefined account rule for Cost of Goods Sold.

   The Cost of Goods Sold event class is discussed here as an example.

   To identify the predefined rules, set the Created by Application search parameter to Yes.

6. Click the Duplicate icon to create a duplicate of the predefined account rule for Cost of Goods Sold. Enter a rule name, a short name (in capital letters) and then select the chart of accounts.

   Once chart of accounts is assigned to an account rule and this task is saved, you cannot modify the assignment.

7. Click Save and Close.

   The Edit Account Rule page is displayed.

8. Specify the account selection criteria in the Rules region; however, don't change any values in the Conditions region.

9. In the Rules region, the Value Type column has four options.

   • Source

   • Constant

   • Accounting Rule

   • Mapping Set

   Source Value Type

   Source is only applicable to the Accrual Account Rule in Receipt Accounting and the Offset Account Rule in Cost Accounting when the account is retrieved from the purchase order for the Accrual account and from the Miscellaneous Transaction for the Offset account.

   If you select Source as Value Type, then set the value as Code Combination Identifier.

   Constant Value Type

   If the Value Type is set to Constant, you can select the specific account from the chart of accounts as the default general ledger account type of the Journal line type.

   Accounting Rule Value Type

   Use this value type to retrieve values from the accounting rule.

   Mapping Set Value Type

   A mapping set is useful when you have a matrix of input values that produce distinct output values. For each input value, specify a corresponding account combination. One or more related pairs of these input values with the account combination output values form a mapping set. Ensure that a Chart of Accounts is associated with the mapping set.

   Once a mapping set is defined, you can associate the mapping set to an account rule. Copy each predefined account rule and create a rule.

   For more information on these four options, see documentation on Oracle Fusion Financials, Implementing Subledger Accounting Account Rules.