Work-in-progress (WIP) API V2
API Name: API_V2_WIP
-
The WIP analysis dashboard is primarily intended for Fixed Lump Sum and Unit Price contracts, and is not typically used for Cost Plus contracts.
-
Original cost and contract budgets are entered in the prime contract form.
-
Approved change order (CO) budgets are added to the original prime contract budgets (revised budgets).
-
Accurate cost budgets are critical for WIP analysis. If cost budgets are missing or incorrect, all WIP calculations will be inaccurate.
-
Procurement and time tracking transactions with a status of pending or not approved are excluded from this dashboard.
-
When reviewing WIP for inactive or completed projects, the start and end dates must be left blank. For active projects, a cutoff or end date might be used. For example, 31‑Mar‑2025.
- ProjectNumber
- ProjectTitle
- ProjectPMContactName
- ProjectBidContactName
- ProjectSalesContactName
- PrimeContractId
- PrimeContractNumber
- PrimeContractSubject
- PrimeContractIssueDateUtc
- PrimeContractIssueDateOrgLocal
- PrimeContractStatus
- PrimeContractStatusDateUtc
- PrimeContractStatusDateOrgLocal
- PrimeContractBillingType
- PrimeContractBillingTypeValue
- OwnerCompanyName
- OwnerContactName
- ContractorCompanyName
- ContractorContactName
- PrimeContractEstStartDateUtc
- PrimeContractEstFinishDateUtc
- PrimeContractEstFinishDateInclCODaysUtc
- PrimeContractEstStartDateOrgLocal
- PrimeContractEstFinishDateOrgLocal
- PrimeContractEstFinishDateInclCODaysOrgLocal
- RevenueBudget_Revised_Subtotal
- RevenueBudget_Revised_Total
- PrimeInvoice_Approved_GrossTotal
- PrimeInvoice_Approved_Total
- CostBudget_Revised
- CommittedCost_Approved_Subtotal
- CommittedCost_Approved_Total
- CostToDate_Approved_GrossTotal
- CostToDate_Approved_Subtotal
- CostToDate_Approved_Total
- Variance_PrimeInvoiceCostToDate_Approved_GrossTotal
- Variance_PrimeInvoiceCostToDate_Approved_Total
- Percent_PrimeInvoiceRevenueBudget_Approved_Gross
- Percent_CostToDateCostBudget_Gross
- Percent_CostToDateCommittedCost_Gross
- EarnedRevenue_CostToDateCostBudget_Approved_Gross
- Billing_Over_CostToDateCostBudget_Approved_Gross
- Billing_Under_CostToDateCostBudget_Approved_Gross
- EarnedRevenue_CostToDateCommittedCost_Approved_Gross
- Billing_Over_CostToDateCommittedCost_Approved_Gross
- Billing_Under_CostToDateCommittedCost_Approved_Gross
- Percent_ProfitMargin_PrimeInvoiceCostToDate_Approved_Gross
- Percent_ProfitMargin_PrimeInvoiceCostToDate_Approved_Total
- Percent_ProfitMarkup_PrimeInvoiceCostToDate_Approved_Gross
- Percent_ProfitMarkup_PrimeInvoiceCostToDate_Approved_Total