Setting Up Funds Distribution

All Participating Activities

Select to indicate that the rule applies to all activities in a project.

Specify Activity

Select to indicate that the rule applies to one participating activity in a project. When selected, enter an activity ID in the field to the right.

Effective Date

Enter a date that determines when the rate plan or rate set is to be used for burdening.

Status

Select Active or Inactive.

Rate Selection

Select Rate Plan or Rate Set.

Rate

Select a rate plan or a rate set, depending on the selection in the Rate Selection field.

View Rates

Click to access the rate plan or rate set definition pages in update mode.

View/Add Rates

Click to access the rate plan or rate set definition pages in add mode.

Group Target Definitions

The initial value of this field defaults from the Project Costing Definition page. You can override the value on this page.

Select to indicate that the funding source rules can be grouped manually. Each target definition can be associated to a set of rules.

Deselect to indicate that each funding source rule will be associated with separate target definition.

This check box will be display-only if the child target definition has a distributed amount not equal to zero.

Target

Click to access the Funds Distribution - Target page for the corresponding row.

Target Group ID

Enter suitable target group IDs based on which source rules will be grouped together. You can enter any alphanumeric combination for the Target Group ID. You can also enter sequential number such as 1, 2, and 3. Each ID can be assigned to multiple source rules.

This field is only visible if Group Target Definitions checkbox is selected. It is a required field. However it will be display-only if there are any child target definitions found with a distributed amount not equal to zero.

If Group Target Definitions checkbox is not selected then this field is hidden and each source rule will have separate target definition.

Analysis Group

This field defaults to ‘%’. For a particular source rule you can only enter a value for either Analysis Group or Analysis Type. Source rules will be grouped together based on the analysis group or analysis type you enter. If source rule is entered by analysis group then the corresponding target definition will apply to all the analysis types within that analysis group.

Analysis Type

Select the analysis types of the source transactions, which are used by the Funds Distribution process for this rule. When defining a new rule, the analysis types that are included in the Funds Distribution Defaults (PSDEF) analysis group are used to populate these rows. You can delete or add analysis types.

Sort Ascending/Descending Sequence

Click to sort the threshold sequence in ascending or descending order.

Sequence

Enter a sequence number that indicates the order in which the Funds Distribution process applies the funding when a valid source transaction is processed.

Each active sequence represents an approved amount of available funding to which costs can be distributed. Different distribution percentages and ChartFields can be defined for each sequence.

Status

Select Active or Inactive. This field enables you to inactivate a particular sequence within a rule but have all other sequences remain active. You may need to do this if an incorrect appropriation was used. If the status is changed to inactive, you can reactivate it only if the distributed amount for the sequence equals zero.

When the Adjustment check box is selected, the status does not apply to the row.

Adjustment

Select to indicate that the sequence row is an adjustment sequence. When this option is selected, the target Percentage distribution field is not available for entry. However, the Threshold Amount and Distributed Amount fields are available for entry.

This option enables you to synchronize the manual adjustments from Billing with the funds distribution rules and reports. Adjustment sequences are not recognized and are not processed when the Funds Distribution process runs.

When the threshold amount and distributed amount for a sequence is equal zero, the Adjustment check box can be changed.

For more information about applying adjustments:

See Applying Adjustments to the Funds Distribution Rule.

Start Date

Enter a beginning date that the sequenced rule can be used to distribute source transactions. Costs with an accounting date or transaction date that is greater than or equal to this date are eligible to be distributed using this sequence, provided it is active and the threshold amount is not fully distributed.

If the Adjustment check box is selected, then the start date does not apply to the row.

End Date

Enter an ending date that represents when the sequenced rule is no longer used to distribute source transactions. Costs with an accounting date or transaction date that is less than or equal to this date (and greater than or equal to the start date) are eligible to be distributed using this sequence, provided it is active and the threshold amount is greater than zero. This field is optional.

If the Adjustment check box is selected, then the end date does not apply to the row.

Threshold Amount

Enter an amount that represents the maximum amount of source transactions that may be distributed to funding sources according to the distribution rules defined for the sequence. This amount typically represents an approved amount of funding for which project costs can be billed. If different distribution rules are needed for different amounts of funding, then multiple sequences can be defined.

If the Update Threshold Amounts field on the Installation Options - Project Costing Integration page is selected, then this field can be modified after costs have been distributed against the threshold. However, the threshold amount cannot be less than the distributed amount.

If the Update Threshold Amounts field on the Installation Options - Project Costing Integration page is not selected, then this field cannot be modified after costs have been distributed against the threshold. If additional funding is received, a new sequence must be added to create additional distribution rows.

Distributed Amount

Displays the amount of costs distributed for the sequence. The distributed amount cannot exceed the threshold amount. This amount includes all exceptions that have been budget checked and are outstanding.

Exception Amount

Displays the amount of costs distributed that have been held from additional processing due to budget checking exceptions. These transactions have not been added to PROJ_RESOURCE. Use the Funds Budget Exceptions page to view and re-budget check these transactions.

If a target distribution for a source transaction fails the Budget Checking process, all of the target distributions for that source transaction are held until the error is resolved. Therefore, the exception amount may contain target distributions that failed budget checking and those that did not. For example, if three target distributions are created for a source transaction and one failed budget checking, then all three are held from additional processing and are included in the Exception Amount field.

Percentage

Enter the percentage of the source transaction that is to be distributed to the specified funding source. You can enter as many rows as needed because project costs can be distributed among multiple funding sources. The sum of the percentages specified for a sequence must equal 100 percent.

This field is not available when the Adjustment check box is selected.

Analysis Type

Select an analysis type that is used to identify the distributed funds during the Funds Distribution process. For example, FDF (Funds Distribution Federal) indicates that the amount is sourced by federal funds and FDS (Funds Distribution State) is sourced by state funds.

Activity

Enter the activity ID that is associated with the target distribution row. The value in this field can be:

• The same activity that is specified on the rule.

• A different activity that overrides the activity on the source transaction.

• A wild card value (a percent sign) to inherit the same activity as the source transaction.

Source Type, Category, and Subcategory

Perform one of these actions:

• Enter a value for the system to assign to the resulting target distribution rows.

• Enter the wildcard value (a percent sign) for the target distribution row to inherit the same value as the source transaction row.

• Leave the field blank for the target distribution rows to inherit a blank value

Threshold Amount

Displays the percent of the total threshold amount for the source. This is the portion of the overall threshold for the sequence that is allocated to the funding source.

Distributed Amount

Displays the total costs that are distributed to the funding source specified for the row.

Budget Check

Select to indicate that the resulting distribution is to be budget checked. This option should be selected if the commitment control budget for the target distribution is different than the commitment control budget for the source transaction.

This field is available only when these conditions exist:

• The Enable Commitment Control option is selected for Project Costing on the Installation Options - Products page.

• The analysis type for the row has a value of Actuals and Recognized in the Commitment Control Amount Type field on the Analysis Type page.

Reversals

Select to indicate that reversals are allowed for the row. This option generates an accounting entry that reverses the impact of the original source transaction in the amount of the distribution. Use this option to synchronize distribution transactions in Project Costing with accounting entries in the general ledger.

When this option is selected, the Funds Distribution process generates a second row containing a FDR (Funds Distribution Reversal) analysis type. This row has the same amount (but opposite sign) as the selected row and the same ChartFields from the source row.

If the Budget Check check box is selected, then the Reversals check box is automatically selected.

If the Allow Generate Reversals option on the Installation Options - Project Costing Integration Options page is selected, then this check box is available.

Balancing

Select one row in a sequence to indicate that this target distribution row should be used by the system if rounding differences are encountered during the Funds Distribution process (PC_FND_DIST).