Project or Shell Cost Sheet Column Data Sources
Data Source | Description |
---|---|
Single Sources | Columns in which data is manually rolled up from business processes after the appropriate terminal status is reached. Can also include other specified sources. |
Cost-type Business Processes | Included in the Single Sources list are all of Cost BPs that are available for your project or shell, and all of their terminal statuses. |
AFC |
|
Assigned Budget | This column goes hand-in-hand with budget distribution. It allows the user to create specific, detailed line-items for each CBS code in the budget. Each line item can be assigned individually. |
Funded Records | This column shows records in which the CBS code is funded, that is, spend-type business process records that consume funds. |
Unfunded Records | This corresponds to spend-type BP records that are not funded. |
Prior Forecasts |
|
Yet To Buy | Part of the commitment that still must be purchased. For example, a base contract is for 1000 items, and 500 have been bought. There are 500 items "yet to buy." It is based on a currency amount. In Cost Sheet Properties, setting "Auto" "Transaction" options will track the yet to buy information. |
Logical Sources |
|
Budget Remaining Balance | This is a place holder for a formula you create (optional). |
Budget Variance | This is a place holder for a formula you create (optional). |
Commits | This is a place holder for a formula you create (include all commit columns; optional). |
Forecasts | This is a place holder for a formula you create (optional). |
Forecasts (Unaccepted) | This is a place holder for a formula you create (optional). |
Forecasts Variance | This is a place holder for a formula you create (optional). |
CBS Funding | Requires additional setting in Funding Sheet; see Setting up the Funding Manager. |
Manual Funding by CBS | Requires additional setting in Funding Sheet; see Setting up the Funding Manager. |
Revised Budget | This is a place holder for a formula you create (optional) |
Spends | This is a place holder for a formula you create (include all spend columns; optional). |
Project or shell Cost 1-25 | These can be used to roll up manual and formula columns to company and program cost sheets. Each data source can be used for one column.
|
Last Published Monday, August 28, 2023