Create a Materials Rate Table

Background

Create and manage rate tables with effective/expiration dates and define custom cost and billable rate columns.

Columns are configured in the company's Rate tool settings, while rows populate automatically from your project's Materials inventory.

labor and equipment rate tables

Rate tables for Labor and Equipment are created and managed in the Company level Rates tool.

Things to Consider

Required User Permissions
Rate tables are effective between the effective date and the expiration date.
When a calculated rate column is included in a table, the associated source columns from the calculated rate's formula are also added.
You can add and edit the rates for the source columns within a calculated rate's formula, but you cannot override the final calculated value.

Prerequisites

Materials must be listed in your inventory using one of the following methods:
- Create Materials Requirements
- On an active project, the Commitments tool was used to create a commitment change order or purchase order for materials, and includes the following information:
  - The status is Approved
  - The Schedule of Values (SOV) includes the following for each line item:
    - Description
    - Unit of Measure (UOM)

Steps

Tip

You can also copy a rate table.

Navigate to the Project level Rates tool.
Click Create Material Table.
Enter the general information.
Show/Hide Fields
- Name. The name of the rate table.
- Effective Date. The date the rate table goes into effect.
- Expiration Date. The date the rate table expires.
- Description. A description of the rate table.
Add Columns.
- Move the toggles ON or OFF to include or exclude columns.
Click Create.

Next Steps

Add Rows to a Materials Rate Table

See Also