To access the Rate Sheets log, go to the shell (User mode), click to expand the Activity Manager module, and click Rate Sheet.
Note: The location may differ in your implementation based on the Project/Shell User Mode Navigator configuration.
You can use the Rate Sheets log to:
- See a list of rate sheets.
- Review the following information (on the right-hand pane of the log) about a selected activity sheet:
- Audit Log
- Permissions
- Schedule
The Rate Sheets log has the following toolbar options:
Toolbar option | Description |
---|---|
Create | To create a new rate sheet by copying a data from Company Workspace and Activity Sheet. |
Refresh | To refresh the contents of the page. |
Delete | To delete an item |
Find on Page | To find an item on the page. |
The Rate Sheets log has the following columns:
Column | Description |
---|---|
Name | The name of the rate sheet entered in the Create Rate Sheet dialog. |
Description | The description for the rate sheet entered in the Create Rate Sheet dialog. |
Last updated | The date the sheet was last updated manually or through Refresh. |
Created By | The name of the user who created the rate sheet. |
The Rate Sheets log lists the rate sheets and each rate sheet row has a menu options that you can access by way of the gear menu (). The following table explains the gear menu () options for each rate sheet:
Option | Description |
---|---|
Open | To open a rate sheet. Note: You can also double-click to open the sheet. |
Copy | To select a rate sheet and create a copy of that rate sheet. Enter a name and description and then click Save to complete the action. |
Delete | To delete one or multiple rate sheets. Note: The Delete option in the toolbar allows you to delete multiple rate sheets simultaneously. If a rate sheet is being used in the Activity Sheet, then it cannot be deleted. |
Refresh | To refresh a rate sheet based on resources and roles that are used in the system activity sheet of the shell. Select a single or multiple rate sheets and click Refresh to update the list of resources and roles based on the latest data available in the Activity Sheet, and the corresponding rates from the Master Rate Sheet. Click Yes in the Confirmation window to update. On refresh, the following updates are implemented:
|
Export CSV | Use the options to export Role or Resource Rate Breakdown as CSV. This comprises the list retrieved from the shell Activity Sheet. The structure includes ID, name, status, effective date, cost type, rate type, and price/unit information.
|
Update Data | Use the options to import the modified Role or Resource Rates CSV files in order to update role and resource rates.
|
The Rate Sheets log displays the rate sheet properties on the right-hand pane within the following tabs:
Tab | Description |
---|---|
Audit Log tab | To provide the following information:
|
Permissions tab | To provide information about:
|
Schedule tab | To set Frequency for Refresh Rates. |
Tip: Click the expand icon, in the right pane, to better view the tab details.
The following explains each tab in details.