Setting Up Financial Management › Financial Matrices › Add Rows to the Matrix

Add Rows to the Matrix

Complete your cost/rate matrix definition by adding rows of specific values for the matrix columns. For example, if you assigned Resource Role and Transaction Class as matrix columns, create rows by selecting unique combinations of roles and transaction classes.

Note: Verify that each matrix row is unique and the dates do not overlap.

The matrix rows let you define the criteria for applying rates and costs to investments and resources for transaction processing. The following sample matrix rows define the cost and rate for the Business Analyst role for two different transaction classes.

Follow these steps:

1. Open Administration, and from Finance, click Manage Matrix.
2. Click the matrix name to which you want to assign columns.
3. Click Edit Matrix Rows.
4. Click New.
5. Complete the requested information. The following fields require explanation:

   From Date

   Defines the beginning of the effective date range for this row. Any transaction that is processed within the range is applied the rates/costs from this matrix.

   To Date

   Defines the end of the effective date range for this row.

6. Select the values for the matrix columns that you assigned and complete the following information for your matrix rows:

   Rate

   Defines the billing rate to apply to a transaction for the row. A value of at least 0.00 is required.

   For equipment, materials, and expenses, rate is equal to the quantity. For example, if the cost of a single server is $1,000.00, then the rate set to 1.

   Standard Cost

   Defines the standard cost that is associated with any transaction matching the criteria established in the matrix.

   Standard cost is used in all cost fields. For example, in cost plans, planned cost is calculated as quantity * standard cost.

   Actual Cost

   Defines the actual cost that is associated with any transaction matching the criteria established in the matrix. Actual Cost can be used in custom reporting.

   Currency

   Specifies the currency for the row in the matrix. This value can be different for each row in the matrix and is assigned when a transaction match occurs.

   This field displays only when multi-currency is enabled.

   Cost Plus Code

   Specifies the cost plus code to use when a transaction matches the criteria that is established in the matrix.

7. Save the changes.

You have successfully set up a cost/rate matrix. The matrix applies standard costs and rates to all financial transactions from a centralized cost/rate table.