The generate WIP projects service creates WIP project objects based on calculations of the extended forecast.
Actuals are calculated using data from the general ledger cost and revenue, project estimate, and project contract, combined with the CFO forecast from the prior WIP period.
Generate WIP projects for a WIP schedule period.
Subscription | Construction |
---|---|
User type | Business, Project Manager |
Permissions | Add WIP Projects |
periodEndDate required | string <date> The ending date of the WIP schedule's reporting period. Example: "2023-05-31" | ||||
required | object The entity assigned to this WIP period. | ||||
| |||||
periodStartDate | string <date> The beginning date of the WIP schedule's reporting period. Example: "2023-05-01" |
OK
Bad Request
{- "periodEndDate": "2023-01-01"
}
{- "ia::result": {
- "wipProjects": [
- {
- "project": {
- "name": "Dimensions - Berkeley Technology Inc",
- "id": "DIM - BTI",
- "key": "1"
}, - "customer": {
- "name": "Berkeley Technology Inc",
- "id": "BTI",
- "key": "14"
}, - "projectStatus": {
- "id": "In Progress"
}, - "projectType": {
- "id": "Tenant Improvement"
}, - "manager": {
- "name": "Sanford; Dennis G",
- "id": "EMP00002"
}, - "class": {
- "name": "Project Class",
- "id": "Project Class"
}, - "location": {
- "name": "Beaverton",
- "id": "BEAVERTON"
}, - "department": {
- "name": "Construction Operations",
- "id": "OPERATIONS"
}, - "cfoForecast": {
- "percentComplete": 70,
- "costToComplete": "4000.00",
- "contractValue": "10000.00",
- "costAtCompletion": "9500.00",
- "lastUpdatedDate": "2023-05-26T10:06:00Z"
}, - "projectManagerForecast": {
- "percentComplete": 90,
- "costAtCompletion": "9000.00",
- "costToComplete": "3000.00",
- "contractValue": "10000.00",
- "lastUpdatedDate": "2023-05-26T10:06:00Z"
}, - "cfoForecastGrossProfitAtCompletion": "26110.00",
- "grossProfitPercentOfContract": 0.99,
- "estimatedCostToComplete": "-5203.07",
- "overUnderBillingAmount": "76578540.49",
- "isFinalized": false,
- "grossProfitVarianceAmount": "0.00",
- "earnedProfitToDateAmount": "76578010.58",
- "priorYearsProfit": "0",
- "remainingProfit": "0",
- "endOfPriorYearEarnedToDateAmount": "0",
- "endOfPriorYearEarnedProfit": "0",
- "estimatedPercentComplete": 29.12,
- "grossProfitPercentOfCost": 141.14,
- "remainingBacklogAmount": "-76557103.65",
- "contractVarianceAmount": "0",
- "cfoForecastGrossProfitMarginPercent": 0.99,
- "totalGrossProfitEstimatedAtCompletion": "26110.00",
- "jobToDateBillings": "4858.16",
- "jobToDateCosts": "5388.07",
- "estimatedCostToDateAmount": "185.00",
- "earnedToDateAmount": "76583398.65",
- "totalRevisedContract": "26295.00",
- "yearToDateCostAmount": "15000",
- "yearToDateBillingAmount": "15000",
- "yearToDateEarnedRevenueAmount": "15000",
- "jobToDateOverBillingAmount": "15000",
- "jobToDateUnderBillingAmount": "15000",
- "yearToDateEarnedProfitAmount": "15000",
- "currentPeriodBillingAmount": "15000",
- "currentPeriodCostAmount": "15000",
- "currentPeriodEarnedProfitAmount": "15000",
- "currentPeriodEarnedRevenueAmount": "15000"
}
], - "lastRefreshDateTime": "2023-06-02T14:47:14Z",
- "wipCostBreakdownLevel": "costCodeAndCostType"
}, - "ia::meta": {
- "totalCount": 1,
- "totalSuccess": 1,
- "totalError": 0
}
}