Creating and Updating a Project Cost Percent Complete Dataset
To create or update a project cost percent complete dataset from the Analytics page:
To create or update a project cost percent complete dataset:
-
Go to Analytics.
-
Click the Datasets tab to edit or create a new dataset.
Note:For more information, refer to Custom Workbooks and Datasets.
-
Select the required dataset.
-
Click the information icon next to the name of the dataset.
-
Click See Dataset Column Details.
-
Add the Percent Complete Project, Percent Complete Date, and Percent Complete Amount aliases. You should map the aliases to the project type, date type, and amount type dataset columns, respectively.
-
Click Apply.
The default workbook is Project Percent Complete Custom Criteria, and it's linked to the following default shipped datasets:
-
Project Percent Complete Actual Labor
Important:To use the shipped Project Percent Complete Actual Labor dataset:
-
Go to Setup > Accounting > Accounting Preferences.
-
Check the box for each of the following features.
Subtab
Feature Name
Time & Expenses
-
Require Approvals on Time Records
-
Advanced Approvals on Time Records
-
-
Click Save.
-
-
Project Percent Complete Actual Non Labor
-
Project Percent Complete Budget Labor
-
Project Percent Complete Budget Non Labor
Note:For the Project Percent Complete Budget Non Labor dataset, go to Formulas > Amount. The default margin is zero, but you can change it as per your business requirements.
The date filter doesn't apply to Labor Budget, Non Labor Budget, and Additional Cost Budget Dataset datasets on the Project Cost Percent Complete Rule page.
The default datasets include filters, can be customized, and can’t be deleted.
To use the shipped datasets:
-
Go to Setup > Company > Enable Features.
-
Check the box for each of the following features.
Subtab
Feature Name
Company
-
Job Costing and Project Budgeting
-
-
Click Save.
Related Topics
- Project Cost-to-Cost Percent Complete
- Installing the Project Cost-to-Cost Percent Complete SuiteApp
- Prerequisites for Installing the Project Cost-to-Cost Percent Complete SuiteApp
- Roles and Permissions
- Supported Languages in Project Cost-to-Cost Percent Complete SuiteApp
- Project Cost-to-Cost Percent Complete SuiteApp Error Messages
- Language Specific Actual Cost Label
- Project Cost-to-Cost Percent Complete SuiteApp Limitations