Create a User-Defined Formula
In this procedure, you create a user-defined formula for an existing Payables description rule.
Create a User-Defined Formula
Navigate to the Manage Formulas page.
-
In the Setup and Maintenance work area, go to the following:
-
Offering: Financials
-
Functional Area: Any subledger (for example, Payables, Receivables, Projects, Fixed Assets, Collections, and so on)
-
Task: Manage User-Defined Formulas
-
Create a formula on the Manage Formulas page.
-
Click Create icon.
-
Enter Name. The Short Name is created but can be updated.
-
Enter Data Type.
-
Enter Event Class.
-
Click Save.
-
This formula is used in a description rule for the Invoices event class.
In the Expression region:
-
Click Insert Function.
-
Enter Type = Conditional.
-
Click Search.
-
Select IF THEN ELSE
-
Click OK.
-
-
Place the cursor after the IF.
-
Click Source.
-
Select Subledger Application.
-
Select Name = Intercompany.
-
Click Search.
-
Select Intercompany Invoice Indicator.
-
Click OK.
-
-
Click More.
-
Select Equal To (=).
-
On the IF line, after the = enter 'Y' including the single quotes.
-
On the THEN line, click Insert Function.
-
Select Type = Alphanumeric.
-
Click Search.
-
Select Concatenate.
-
Click OK.
-
-
Double-click String1, and replace with 'Intercompany Invoice'.
-
Double-click String2.
-
Double-click Source.
-
Select Subledger Application = Payables.
-
Enter Name = Invoice Number.
-
Click Search.
-
Select Invoice Number.
-
Click OK.
-
-
Copy and pasts the THEN clause Concatenate('Intercompany Invoice',"Invoice Number") to the ELSE clause.
-
Remove 'Intercompany Indicator'.
-
Validate the formula.
-
Click Validate.
-
Click OK on the Information message.
-
Click Save.
-
-
Activate the formula.
-
Click Actions > Change Status > Activate.
-
-
Click Save and Close.
-
Add the User-Defined Formula to a Description Rule
Add the user-defined formula to an existing description rule.
-
In the Setup and Maintenance work area, go to the following:
-
Offering: Financials
-
Functional Area: Any subledger (for example, Payables, Receivables, Projects, Fixed Assets, Collections, and so on)
-
Task: Manage Description Rules
-
-
Click Edit on the Invoice Type description rule.
-
Remove the existing source.
-
Click Source button.
-
Search by Type
-
Select Invoice Header with Type.
-
Click Save and Close.
-
-
Click Save and Close.