Create Description Rules and a User-Defined Formula

In this procedure you create a user-defined formula and description rules.

Create a User-Defined Formula

Navigate to the Manage Mapping Sets page.

1. From the Setup and Maintenance work area, click the Implementation Projects button.

2. Search for the FAH Implementation project.

3. Expand the task list: Define Accounting Configuration for Rapid Implementation.

4. Expand the task list: Define Accounting Rules for Rapid Implementation.

5. Select the task: Manage User-Defined formulas.

6. Click Go to Task.

Create a formula on the Manage Formulas page.

1. Click Create icon.

2. Enter Name. The Short Name is created but can be updated.

3. Enter Data Type.

4. Enter Event Class.

5. Click Save.

• In this formula you abbreviate a loan type value. For example, if the loan type is Fixed Rate, then its new value is FR; otherwise the value is AR.

  In the Expression region:

  1. Click Insert Function.

     1. Enter Type = Conditional.

     2. Click Search.

     3. Select IF THEN ELSE

     4. Click OK.

  2. Place the cursor after the IF,.

  3. Click Source.

     1. Select Subledger Application.

     2. Select Name = Loan Type.

     3. Click Search.

     4. Select Loan Type.

     5. Click OK.

  4. Click More.

  5. Select Equal To (=).

  6. On the IF line, after the = enter 'Fixed Rate' including the single quotes.

  7. On the THEN line, enter 'FR'.

  8. On the ELSE line, enter 'AR'.

  9. Validate the formula.

     1. Click Validate.

     2. Click OK on the Information message.

     3. Click Save.

  10. Activate the formula.

      1. Click Actions > Change Status > Activate.

  11. Click Save and Close.

Create Description Rules

In this exercise, you create a header description rule for an accounting event. In this example, we display the loan type, event type, and the customer number at the header level of the journal entry.

Navigate to the Manage Description Rules page.

1. Click Go to Task for the Manage Description Rules task.

2. Click Create icon.

3. Enter Name.

4. Enter Short Name.

5. Click Save.

6. In the Rules region, enter the description rule components.

   1. Click Create icon.

   2. In the Description Details text box enter Loan Type.

   3. Click Source.

      1. In the Source Search enter Type, Formula.

      2. Select the formula you created in the prior step.

      3. Click OK.

   4. In the Description Details text box, place your cursor at the end of the text and append:

   5. Click Source.

   6. Search by Name: Accounting Event Type Name.

   7. Click OK.

   8. In the Description Details text box, place your cursor at the end of the text and append:

   9. Click Source.

   10. Search by Name: Customer Number.

   11. Click OK.

7. Click Save and Close.

8. Click Save and Create Another.

In this exercise, you create a line description for an accounting event. In this example, we display the loan rate at the line level of the journal entry.

1. Click Create icon.

2. Enter Name.

3. Enter Short Name.

4. Click Save.

5. In the Rules region, enter the description rule components.

   1. Click Create icon.

   2. In the Description Details text box enter Rate:.

   3. Click Source.

      1. In the Source Search enter Name, Loan Rate.

      2. Click OK.

6. Click Save and Close.

7. Click Save and Close.

8. Click Done.