- Overview
- Open the Configure Fee Matrix Popup
- Add a Calculation
- Display the Fee in a View
- Edit or Remove a Configuration
Overview
The Configure Fee Matrix popup lets you apply a fee matrix to your element definitions and show the fee in their total blocks, all from the fee matrix itself. After a fee matrix has been created, configuring it has two steps:
- Calculate: Add a custom row on an element definition (for example, Quote) so the fee matrix calculates and adds to the element total. (A quicker way to Apply a Fee Matrix to an Element Definition)
- Display: Add that custom row to the total block of one or more views so it will show in element totals and reports. (A quicker way to Add a Fee Matrix Amount to the Total Block of an Element Definition)
To access Fee Matrices, the Can Manage Financial Document Definitions permission is required. To use the Configure Fee Matrix popup, the Can Configure Project Elements permission is required.
Open the Configure Fee Matrix Popup
The Configure Fee Matrix popup opens automatically after you add a new fee matrix. To add a new Fee Matrix, go to Main Menu > Financials > Fee Matrices, Add New Fee Matrix button in the bottom left. Then follow the steps in Add a Fee Matrix.
To open the Configure Fee Matrix popup for an existing fee matrix, go to Main Menu > Financials > Fee Matrices, click the Options menu in the fee matrix's row, then click Configure Fee Matrix.
The popup lists every saved configuration, grouped by element definition, showing each view the fee is displayed in.
Add a Calculation
- From the Options menu on an existing fee matrix line, click Configure Fee Matrix. On the popup, click Add calculation.
- Choose the element definition you want the fee to apply to and click Configure custom row.
- On the element popup, review the custom row field details:
- Code: The identifier for the row. This is what you select when adding it to a total block.
- Description: A description of the custom row and its purpose.
- Calculation Method: How the custom row calculates (locked to this fee matrix).
- Fee Matrix: The name of the matrix being used (locked to this fee matrix).
-
Result Type: Whether the custom row results in a price or cost.
- Price: Charged to the client.
- Cost: An internal cost to you.
- Pass Through: Both a price and a cost.
-
Resource Type: If this field is set, the custom row amount will:
- Export to QuickBooks using this resource type, which is important for account mapping.
- Be taxed at this resource type's percentage in the element's sales tax rule. Only applies when Tax Treatment is "Use Standard Tax Rule."
-
Tax Treatment: How the custom row is taxed.
- Not Taxable: The amount isn't taxed.
- Use Standard Tax Rule: The amount is taxed using the element's sales tax rule.
- Discount Tax Pro Rata: The amount reduces the element's sales tax in proportion to the sales tax rule percentage.
- Transient Calculation: If Yes, the custom row is for display only and doesn't add to any totals.
- Is Waivable: If Yes, users can manually change the custom row amount in the element's total block.
- Must Be Negative: If Yes, any manually entered amount becomes negative.
- Click Save custom row.
The fee matrix now calculates on that element definition, and the Display fee step opens. To open the Display fee popup for an existing custom row, navigate to the Options menu on a fee matrix line, click Configure Fee Matrix, locate the Actions menu on the row and choose Add to view.
Display the Fee in a View
- In the Display fee popup, choose a View, then click Configure display.
- Enter the total block row details:
- Caption: The display name of the row in the total block.
- Field Type: Choose "Custom Row."
- Tax Category: Not used for custom rows.
- Custom Row: Choose the code of the fee matrix custom row.
- Print if Zero: Whether the row prints on PDF reports when the amount is $0.
- Bold: Whether the row prints in bold on PDF reports.
- (Optional) Drag the row to change where it appears in the total block.
- Click Save display.
To show the fee in another view, click Add to view in the row's Actions menu and repeat these steps.
Edit or Remove a Configuration
From the Configure Fee Matrix popup, use the Actions menu in a configuration's row to:
- Edit calculation: Change the custom row details. If a row shows a warning that its calculation method doesn't use this fee matrix, click Edit calculation, then Save custom row to fix it.
- Add to view: Open the Display fee popup.
- Edit display: Change the caption or position of the fee in that view's total block.
- Remove from view: Remove the fee from that view's total block only. The fee still calculates, and other views keep their display.
-
Delete custom row: Stop the fee from calculating on that element definition. The fee matrix itself is not deleted. Deleting is disabled if a custom row is in use.
- Remove the fee from every view first.
- You can't delete a custom row if existing elements have an amount for it.