The columns on the company funding sheet are used to track project/shell level funding and keep track of fund balances.
To add a column to the company funding sheet:
- From the Company Funding log, select the company funding sheet and click Open from the gear menu ( ), or double-click the company funding sheet. The Company Funding Sheet window opens.
- Click the Add Columns. The New Column window opens.
- Complete the fields as described in the following table.
- Click Save to add the new column to the company funding sheet.
In this field:
| Do this:
|
|---|
Name
| The name you choose will appear as the column header. You may manually enter a column name, or, if you leave the Name field blank, the selection you make in the Datasource field will automatically populate the Name field.
|
Type
| Choose one of the following types:
- From Business Process
- Direct Entry
- Line Item Content
- Formula
|
Datasource
| All columns must be associated with a data source. The data source that you choose will determine which of the following options are available. The types of Data sources available are as follow.
- Single Sources: These values roll up from a single, defined source, such as a business process or a system defined source.
- Logical Sources: These include user-defined Manual Entry or Formula columns.
|
Single Source
| Data sources that contain funding sources and consumption information; that is, Fund subtype of Cost business processes, which allocate funding and Spends business processes that consume funding.
- Business Processes: List of cost-type business processes that include funding data definitions.
- Project/Shell Funding: Sum of all funding sources at project/shell level for each project/shell, as rolled up from each individual project/shell funding sheet. The information that gets rolled up to this column is dependent on the project/shell funding sheet setup for each project/shell.
- CBS Funding: Sum of all funding sources at CBS level for each project/shell, rolled up from each individual project/shell funding sheet. The information that gets rolled up to this column is dependent on the project/shell funding sheet setup for each project/shell.
- Manual Funding by project/shell: Sum of all project/shell-level funds that are allocated at project/shell level manually.
- Manual Funding by CBS: Sum of all funds that are allocated at CBS level manually.
- Records Funded at Project/Shell Level: Sum of all records that are funded at project/shell level. These are records that have already ended their workflow or hit terminal status.
- Records Funded at CBS Level: Sum of all records that are funded at CBS Level. These are records that have already ended their workflow or hit terminal status.
- Transient Records Funded at CBS Level: Sum of all records that are funded at CBS Level. These are records that are currently in process.
- Transient Records Funded at Project Level: Sum of all records that are funded at project/shell level. These are records that are currently in process.
- Fund1 to Fund25: Generic data sources that can be used for manual entry or formula columns to make the values reportable.
|
Logical Sources
| Logical sources include the following data sources.
- Company Funding: This is commonly the column to use to manually enter the starting amount for each fund.
- Company Fund1 to Fund25: Generic data sources that can be used for manual entry or formula columns to make the values reportable.
|
Data Format
| The following options are applicable for Manual Entry or Formula columns.
- Currency: right-aligns column contents and includes a currency symbol, formatting the value to the specified currency for the sheet.
- Percentage: right-aligns the contents and includes a percentage symbol
|
Display Mode
| The following options refer to whether the column is displayed on the sheet.
- Show: Choose this option to allow users to view this column.
- Hide: Hidden columns are active but not displayed and can be accessed by users with "create" permission on the funding sheet.
|
Column Position After
| The new column will be inserted after the column selected.
|
Note: As funding is consumed from individual funds, the new balance will not be reflected on the company funding sheet by default. You can track your fund balances by adding columns to roll up funding assignments from business process or by manual assignments from the project/shell funding sheets, and then adding a formula column to keep track of the balance. You can also use the rules engine to create a rule to keep this balance from going less than zero (or another amount).