See the Explanation below for all the solution.
Explanation:
Step-by-Step Guide to Create a User Defined Formula for Admin Charges in Oracle Fusion Step 1: Navigate to Manage User Defined Formulas
* Log into Oracle Fusion with privileges to configure Subledger Accounting.
* Go toSetup and Maintenance.
* In theFunctional Setup Manager (FSM), navigate to:
* Financials
* Subledger Accounting
* Manage User Defined Formulas.
Step 2: Create a New User Defined Formula
* ClickCreateto define a new formula.
* Enter the following details:
* Name: Admin Charges Formula
* Subledger Application: AHC Billing
* Process Category: AHC Billing
* Event Class: AHC Billing
* Event Type: Customer Billing, Customer Pay In, Customer Refund, Customer Settlement
* Data Type:Number
* Description: Formula to calculate admin charges for billing events.
* ClickSave, then proceed to define the logic.
Step 3: Define the Formula Logic
Example Formula for Admin Charges:
AssumeAdmin Chargesare calculated as5% of Transaction Amount, with aminimum charge of $10.
* Enter the formula using Oracle's formula syntax:
CASE
WHEN {Transaction Amount} * 0.05 >= 10 THEN {Transaction Amount} * 0.05 ELSE 10 END
* ClickValidateto check for errors.
Step 4: Assign the Formula to the Required Accounting Rules
* Navigate toManage Account Rules.
* Find theAdmin Charges Account Rule(or create one if needed).
* In theCondition Definition, selectUser Defined Formulaas the Source.
* ChooseAdmin Charges Formulaas the value.
* ClickSave and Close.
Step 5: Validate and Deploy the Formula
* ClickValidateto ensure correctness.
* Deploy the formula by submitting the changes.
* Attach the formula to relevantJournal Entry Rule Sets(if applicable).
Step 6: Test the User Defined Formula
* Navigate toSubledger Accounting > Accounting Entries.
* Generate accounting for different test transactions:
* Example 1: IfTransaction Amount = $500, Admin Charges =$25(5% of 500).
* Example 2: IfTransaction Amount = $100, Admin Charges =$10(since 5% of 100 = $5, but the minimum is $10).
* Verify that theAdmin Chargesare correctly derived in accounting entries.