Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In the Create Adjusted NAV Expense Rule panel, you can create a new ledger based adjusted NAV expense rule or update an existing ledger based adjusted NAV expense rule with additional rule criteria.

When the system calculates the underlying NAV Compoonent for a variable expense that uses the Ledger Based method, the starting point is zero. For rule components included in the adjusted NAV expense rule, it adds the net amount to the ledger based NAV. For rule components excluded in the adjusted NAV expense rule, it subtracts the net amount from the ledger based NAV. When you define a ledger based rule, the rule can simply consist of a range of one or more ledger accounts targeted for an expense, can consist of a component such as a security, security type, processing security type, sub security type, or or it can include additional exclusion criteria in addition to the defined ledger account range. The exclusions you define target only the ledger accounts that fall within the rulecomprise multiple criteria that you include and/or exclude.

WRITERS NOTE: must a ledger based rule include at least one row that is a Ledger component? are there other restrictions to setting up rules? review intro

To create a new ledger based adjusted NAV expense rule: 

  1. In Accounting Center, in the left navigation pane, click Setup Expense > Adjusted NAV Expense Create Adjusted NAV Expense Rule.
    You see the Create Adjusted NAV Expense Rule panel.
  2. In the Add or Update Adjusted NAV Expense Rule list, click Add to create a new rule and enter related rule criteria.
    Otherwise, you can select Update if you want to enter additional rule criteria for an existing rule.
  3. In the Adjusted NAV Expense Rule Name field, enter the name of the rule.
  4. In the Adjusted NAV Expense Rule Type list, click Ledger Based.
  5. In the Expense Rule Component list, select the criteria you want to use, and then specify the value to use in the corresponding field that appears. For example, you select Processing Security Type as the expense rule component and then choose EQCSCS (common stock) as the processing security type. Options include:
    - Ledger
    - Security ID
    - Security Type
    - Processing Security Type
    - Sub-Security Type
  6. In the Chart of Account Name field, specify the name of the Chart of Accounts associated with the rule.
  7. In the Include/Exclude Component list, click Include Item or Exclude Item. 
  8. If the rule criteria applies only to long or short amounts, set the Long Short list to Long or Short. 
  9. If you want to define multiple rule criteria, use the pane at the bottom of the panel, as follows: 
    - Click the grid at the bottom of the panel. 
    - Right-click and select Add Rows. 
    - Enter the number of rows you want to add in the Enter Rows Count dialog box and click OK. You need to add a row for each additional rule criteria you want to associate with the rule. 
    - Complete the options on each row you added.
  10. Click Submit.

After you create an adjusted NAV expense rule, you can assign that rule to a variable expense or to a group variable expense. 

...