Approve Budget Data and Upload to Costpoint
Use this procedure to approve budget data and upload it to Costpoint.
To approve EAC, ETC, or PC budget data and upload it to Costpoint:
- Select the Project > Budget Development module.
- From Reports and Action menu, click Actions > Costpoint Revenue Integration.
-
In the Costpoint Revenue Integration screen, select the accounting period from the B&P Accounting Period drop-down list for the projects and the Fiscal Year-Period-Sub Period for Costpoint.
The ITD Costs and the ETC will be based on the B&P Period selected. The Fiscal Year/Period/Sub Period for Costpoint is for reference only.
- Select the projects to calculate by filtering on the Project, Project Manager, Source (either EAC or Budget), Status (None, Calculated, Approved, Rejected) or Revenue Formula.
-
Select the checkbox next to each project you want to include, and click
Calculate.
The checkbox only displays if an approved budget or EAC exists for the project. Only approved budget or EAC data displays in this application.
-
When the calculation is finished, the
Status field changes to
Calculated and the following fields are populated.
- ITD Cost
- ITD Revenue
- Cost at Completion
- EAC
- ETC
- % Complete
- Calculated Amount
- Calculated Date
- Approved By
-
After you review the data, edit the Budget/EAC if necessary, and then approve it and recalculate.
After the project data is to your satisfaction, you can approve the project for upload. If you are not ready to upload the project information to Costpoint for certain projects, you can clear the status of those projects or not select them for approval.
-
After you click
Clear Status, the following fields are cleared of data:
- ITD Cost
- ITD Revenue
- Cost at Completion
- EAC
- ETC
- % Complete
- Calculated Amount
- Calculated Date
- Approved By
-
After the projects are approved, a user with authorized access can upload the project data to Costpoint.
The value to be uploaded is displayed in Calculated Amount and is dependent on the revenue calculation for the project:
- If the revenue calculation is Cost Incurred Using Estimate at Completion, the EAC amount is uploaded.
- If the revenue calculation is Cost Incurred Using Estimate to Complete, the ETC amount is uploaded.
- If the revenue calculation is Contract Value Times Percent Complete, the “% Complete” percentage is uploaded.
If an approved project should not be uploaded, the status can be changed to Rejected by the user. A note screen will display for the rejected project, where the user can enter a reason for the rejection. The reject notes can be later viewed by clicking the Rejected link in the Status field.
-
Select the checkbox for each project you want to upload, and click
Upload.
Only projects with a status of Approved are uploaded. The uploaded project data is copied to the History subtask, where it provides an audit trail, but it also remains available for recalculating and uploading in the Costpoint Revenue Integration screen.
Note: To view the project history after it is uploaded, click Upload History. The project history displays in a pop-up window, where you can view the information by the date upon which it was uploaded.