Project Actuals Converted Object Fields
This object and fields are for system use only.
The Project Actuals Converted stores Project Actuals which have been converted into different currencies.
Revenue Actuals
| Field | Description | |
|---|---|---|
| Billed | Sum of billed amounts. Expenses, timecard splits and miscellaneous adjustments that are billable contribute to billed revenue after they are billed/invoiced. Milestones contribute to billed and invoiced revenue after they are billed/invoiced. | |
| Billings | Sum of ready-to-bill revenue from timecards, milestones, and miscellaneous adjustments. | |
| Bookings | Booked revenue for this project. Budgets of type Customer PO and Customer PO Change Order contribute to bookings. | |
| Expense Budget | Sum of expense budgets for the project. The Expense Amount field of a budget contributes to this field if the budget is of type: Customer PO, Customer PO Change Order, Internal Budget or Internal Budget Change Request. | |
| Internal Budget | Sum of internal budgets for the project. The Amount field of a budget contributes to this field if the budget is of type: Internal Budget or Internal Budget Change Request. | |
| Invoiced | Sum of invoiced amounts. Expenses, timecard splits and miscellaneous adjustments that are billable contribute to invoiced revenue after they are billed/invoiced. Milestones contribute to invoiced revenue after they are billed/invoiced. | |
| Margin | Billings minus Total Costs. | |
| Pass-Through Billing | Sum of pass-through billings, including expenses. | |
| Pre-Billed | Amount already billed for the project. | |
| Revenue | Revenue is not calculated or rolled up. Enter a miscellaneous adjustment A catch-all business record that allows you to correct data entry errors or adjust transactions. to show revenue on the project actuals Totals for a given time period.. |
NRV Revenue Actuals
Non-Rolled-up Value (NRV), actuals fields enable you to view the source of the rolled-up actuals fields.
| Field | Description | |
|---|---|---|
| NRV Billed | Non-rolled up value (NRV) of the amounts marked as billed. Derived from this project alone, separate from child project roll ups. | |
| NRV Billings | Non-rolled up value (NRV) of ready-to-bill revenue from business records. Derived from this project alone, separate from child project roll ups. | |
| NRV Bookings | Non-rolled up value (NRV) of Customer POs and Customer PO Change Order budget amounts. Derived from this project alone, separate from child project roll ups. | |
| NRV Expense Budget | Non-rolled up value (NRV) of expense budget amounts. Derived from this project alone, separate from child project roll ups. | |
| NRV Internal Budget | Non-rolled up value (NRV) of Internal Budget and Internal Budget Change Request amounts. Derived from this project alone, separate from child project roll ups. | |
| NRV Invoiced | Non-rolled up value (NRV) of the invoiced amounts. Derived from this project alone, separate from child project roll ups. | |
| NRV Margin | Non-rolled up value (NRV) of Billings and Pass-Through Billings minus Total Costs. Derived from this project alone, separate from child project roll ups. | |
| NRV Pass-Through Billing | Non-rolled up value (NRV) of Billable expense and miscellaneous adjustment pass-through-ready-to-bill revenue amounts. Derived from this project alone, separate from child project roll ups. | |
| NRV Pre-Billed | Non-rolled up value (NRV) of pre-billed amounts from budgets or miscellaneous adjustments. Derived from this project alone, separate from child project roll ups. | |
| NRV Revenue | Non-rolled up value (NRV) of miscellaneous adjustment revenue amounts. Derived from this project alone, separate from child project roll ups. |
Cost Actuals
| Field | Description | |
|---|---|---|
| Internal Costs | Sum of internal costs, whether billable or not. Internal costs are only for resources that are not marked as External. They are calculated using this formula: Approved timecard hours * Cost rate |
|
| External Costs | Sum of external costs, whether billable or not. Milestones may contribute to flat External Cost if the External Cost field is completed, and the Log Cost as External checkbox is selected. For example, when you count subcontractor fees as a flat cost amount that helped you reach the milestone and achieve the billings. |
|
| Expense Costs | Sum of approved expenses in expense reports, whether billable or not. | |
| Other Costs | Any other project costs. Other costs might include things like material or capital costs incurred on the project. These are only generated through miscellaneous adjustments which can also generate any other category of revenue or cost. The Amount field of a budget also contributes to this field if the budget is of type Work Order or Work Order Change Request. | |
| Total Costs | Total costs from all projects in the project hierarchy. |
NRV Cost Actuals
Non-Rolled-up Value (NRV), actuals fields enable you to view the source of the rolled-up actuals fields.
| Field | Description | |
|---|---|---|
| NRV Internal Costs | Non-rolled up value (NRV) of costs from internal resources. Derived from this project alone, separate from child project roll ups. | |
| NRV External Costs | Non-rolled up value (NRV) of costs from external resources. Derived from this project alone, separate from child project roll ups. | |
| NRV Expense Costs | Non-rolled up value (NRV) of costs associated with expenses. Derived from this project alone, separate from child project roll ups. | |
| NRV Other Costs | Non-rolled up value (NRV) of miscellaneous adjustment other cost amounts. Derived from this project alone, separate from child project roll ups. | |
| NRV Total Costs | Non-rolled up value (NRV) of internal, external, expense and other costs. Derived from this project alone, separate from child project roll ups. |
Time Actuals
| Field | Description | |
|---|---|---|
| Billable Hours (External) | Billable timecard hours from external resources. | |
| Billable Hours (Internal) | Billable timecard hours from internal resources. These hours typically contribute to utilization. | |
| Credited Hours |
Timecard hours from internal resources, where the timecard has the Time Credited checkbox checked. These hours typically contribute to utilization. |
|
| Excluded Hours | Timecard hours from internal resources, where the timecard has the Time Excluded checkbox selected. These hours are also typically subtracted from calendar hours in utilization. | |
| Non-Billable Hours (External) | All non-billable timecard hours from external resources, even if the Time Credited or Time Excluded checkboxes are selected. | |
| Non-Billable Hours (Internal) | Non-billable timecard hours from internal resources, where the Time Credited and Time Excluded checkboxes are both deselected. |
NRV Time Actuals
Non-Rolled-up Value (NRV) actuals fields enable you to view the source of the rolled-up actuals fields.
| Field | Description | |
|---|---|---|
| NRV Billable Hours (External) | Non-rolled up value (NRV) of billable timecard hours from external resources. Derived from this project alone, separate from child project roll ups. | |
| NRV Billable Hours (Internal) | Non-rolled up value (NRV) of billable timecard hours from internal resources. Derived from this project alone, separate from child project roll ups. | |
| NRV Credited Hours |
Non-rolled up value (NRV) of credited Non-Billable timecard hours from internal resource. Derived from this project alone, separate from child project roll ups. |
|
| NRV Excluded Hours | Non-rolled up value (NRV) of excluded Non-Billable timecard hours from internal resource. Derived from this project alone, separate from child project roll ups. | |
| NRV Non-Billable Hours (External) | Non-rolled up value (NRV) of Non-Billable timecard hours from external resources. Derived from this project alone, separate from child project roll ups. | |
| NRV Non-Billable Hours (Internal) | Non-rolled up value (NRV) of Non-Billable timecard hours from internal resources. Derived from this project alone, separate from child project roll ups. |