Actuals by Sync
InEight Control allows you to import actuals by synchronizing with other systems. Using the Sync feature, you can import:
-
Actual quantities from InEight Plan
-
Actual hours and costs from your ERP system
You access all Sync operations from the Actions menu when on the CBS register tab. You will note there are other Sync related operations on the Actions menu, but for this lesson, you will focus on the Get operations that bring actuals into InEight Control. (See InEight Control Interfaces for more information on sync operations.)
Sync Actual Quantities from InEight Plan
The following steps walk you through the process for synchronizing quantities from InEight Plan.
Sync Quantities from InEight Plan
-
From the InEight Control main page, click the Actions menu.
-
Select Sync from the Actions drop-down list.
-
Select Get Plan Quantities from the Sync drop-down list.
-
Select the Through previous pay period option from the Get Plan Quantities drop-down list.
Follow the same steps for synchronizing with your ERP system to import actual hours and costs using the Get Actual Costs and MH option.
Sync Actual Hours and Costs from ERP
You follow the same steps for synchronizing with your ERP system to import actual hours and costs, using the Get Actual Costs and MH option.
Get Actual cost from InEight Contract
The Get actual cost from Contract feature lets you pull the actual cost from Contract and show in Control > Workspaces.
After the Get actual cost from Contract setting is enabled in Settings > Control > Project Tracking, contract actual costs can be shown in Control > Workspaces after the batch process between Contract and Control is run. The goods receipts and invoice receipts are sent to Control via the Actuals batch job which runs approximately every 10 minutes.
You can see actual costs from Contract in Control Workspaces. Actual costs from Contract can consist of a goods receipt, an accrual, or an invoice receipt/payment form.
The updated actuals appear in the cost item slideout in Control > Workspaces > Actuals Details > Actuals History.
The actuals only include whichever is greater between the sum of the goods receipts and the sum of the invoices on the cost item.
Update % Complete from Contract
When a schedule of value line item is claimed against in Plan, the Contract progression information can be configured to interface with Control for cost items that are associated to the contract.
In Settings > Control > Project Tracking > Actuals, you can switch the Update % complete from Contract toggle to On to let this information interface with Control.
Under the Update % complete from Contract toggle is the Calculate percent complete for individual cost items as a percentage of, drop-down menu option. This lets you define how you want to calculate the percent complete for cost items.
In Contract, if you have a schedule value of $1,000.00 worth of work, you can start to claim against that $1,000.00 in quantity tracking. Quantities can be claimed in both Contract and Plan.
The selection made in the Calculate percent complete for individual cost items as a percentage of setting in Settings > Control > Project Tracking > Actuals determines how the percent complete is calculated for your cost item in Control > Workspaces. The calculation for this is option: (updated % complete on the cost item) = (SOV unit price) x (Claimed qty in Contract or Plan) ÷ (Denominator in settings).
When the Get Quantities sync is run in Control > Workspaces, the claims made against the contract item generates a new % complete value based on the settings and claimed quantity in Control to match.
Calculations
The calculation for this is option: (updated % complete on the cost item) = (SOV unit price) x (Claimed qty in Contract or Plan) ÷ (Denominator in settings). Actual qty (to date) = % complete * Forecast (T/O) qty OR CB total qty (depending on settings).
The Get Quantities sync must be executed in order for the claims made against the contract item(s) to show in Control > Workspaces.