Commitment Funding Sheet Log

To access the Commitment Funding Sheet log:

  1. Go to the project/shell tab and switch to User mode.
  2. In the left Navigator, click Cost Manager > Commitment Funding Sheet to open the Commitment Funding Sheet log.

The Commitment Funding Sheet log lists the Base Commit BP records (for example, Contracts or Purchase orders business processes) and has the following toolbar options:

Update Structure

Note: If your Commitment Funding Sheet log has no structure, then this option will change to Create Structure.

This toolbar option opens the Commitment Funding Structure window. The Commitment Funding Structure log columns provides details about the commitment funding columns by listing their names, data sources, and data formats.

Use the toolbar options to:

  • Add a column to the Commitment Funding Structure log columns (Add Column, the plus icon)
  • Open the Commitment Funding Structure properties (CFS Structure Properties icon)

    This option opens the Properties window which has the General tab and Assignment tab. In the General tab, you can enter the title, and in the Assignment tab you can set the assignment rules (Commitment Level-Manual or Commitment Level-Auto Ratio). The properties of a commitment funding sheet are copied from the structure it was created from (which in turn was copied from a template). You can use these properties, or modify them as necessary.

  • Find an item on the log (Find on Page)

Right-click a row to insert, make a column visible or invisible (Visible check box), delete, or reorder the rows and ultimately the columns.

You can double-click a row to open the Column Properties window and see the details or properties of that column. Alternatively, you can use the gear menu options to do the same. The gear menu appears next to each row, when you hover over that row. Similar to the Project Funding Sheet, new columns are created by filling the column properties fields.

The Type has three options: Direct Entry, Line Item Content, and Formula.

Columns such as Funding by Discrete Funds, Rows Funded by Discrete Funds, and so on are part of the Type: Line Item Content. The same Properties window is used for viewing the column properties, which can be opened by clicking Properties by right-clicking a column heading.

To close the Commitment Funding Structure window, click the X icon in the upper-right corner.

Actions

To set permissions for the commitment funding sheet. Click Permissions to open the Permissions window to add, remove, or find users or groups, and to modify or set permissions.

  • Modify Permission: This will allow user to modify record level permissions
  • Edit: This will allow user to modify data on the sheet
  • View: This will allow user to view the sheet

Refresh

To update the information displayed on the screen.

Print

This option enables you to print the information displayed on the screen (Print), export the list displayed to an external files (Export to CSV or Export to Excel).

Notes:

  • For export to Microsoft Excel, the system currently supports only Euro (EUR) and United States Dollar (USD) currency symbols.
  • If you export data from a business process (BP) record, sheet (such as an Activity Sheet), or log (such as Company Funding Sheet Log) to Excel, be aware that depending on how your negative values are formatted, you might need to configure your columns in Excel to match the correct data type (Number). Otherwise, the columns will not be treated as numeric and will not sum as expected. One supported format includes placing the negative sign between the currency symbol and the amount (for example, $-1,000).

Search

To open the search pane and use the following filters or fields to search for a particular record:

  • Base Record
  • Description
  • Date Created
  • Creator

Find on Page

This option enables you to find items on the displayed page. When you click this option, the system inserts a row that lets you enter filter parameters.

When you click a row (base record), or a fund attribute, the screen splits and the right pane displays the properties or fund attributes details of the record within the following tabs:

In the Commitment Funding Sheet log, each row (base record) has a gear menu ( ) option that enables you to:

With the exception of manual entry columns, all of the values are editable in the commitment funding sheet.



Last Published Sunday, July 20, 2025