Creating and Updating a Project Cost Percent Complete Dataset
To create and update a project cost percent complete dataset from Analytics page:
To create and update a project cost percent complete dataset:
-
Go to Analytics.
-
Click the Datasets tabs 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 is 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 of the column is 0. You can modify the margin as per the business requirements.
The date filter is not considered for Labor Budget, Non Labor Budget, and Additional Cost Budget Dataset datasets on the Project Cost Percent Complete Rule page.
The default shipped datasets:
-
have predefined filters
-
can be customized
-
cannot 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 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