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.
When defining a user-defined formula or a condition to other setup rules, after selecting a source, the source name is suffixed by an additional string such as (Payable, S, S) if the same source name is used in more than one subledger. This additional string indicates:
-
which subledger owns the source,
-
whether it's a system source(S) or application source(A), and
-
what's its type, S for source, F for user defined formula.
If the source is a GL account source, then
-
<SOURCE_CODE>.All means the entire GL account combination is used.
-
<SOURCE_CODE>.<SEGMENT_QUALIFIER> means one of the segments from the GL account combination is used.
A user-defined formula isn't supported in the transaction account builder.