Compute Allocations

The allocation of pool dollars to base accounting distributions can now take place as the allocation percentages have been computed for all base types. The only parameter record update required is the change in the Run Mode value. The base allocation percentages are final for three of the four base types before running Compute Allocations. The Compute Allocations process may result in further adjustments to base allocation percentages if the base type is Direct and In-stream Financial.

The Compute Allocations run mode determines the information that should be retained from the Pool records for allocation. It may be COA values through COA inheritance or time-based values such as Fiscal Year and Budget Fiscal Year based on the settings on the Cost Allocation Process Parameters. During the initial periods of a new fiscal year, this run mode will identify the prior year records and determine if those records should be posted to a prior fiscal year and period.

Cost Allocation Journal Summary Records

Rec  #

Record Date

FY

BFY

APD

1

7/1/2016

2017

2017

1

2

7/1/2016

2017

2016

1

3

7/1/2016

2016

2016

13

Note: In the above examples, irrespective of frequency, record #2 is (Fiscal Year > Budget FY) while record #3 is a prior year record (Calendar Date Fiscal Year of Daily Run Date or Application Date > Source Fiscal Year if the process for 2016/13 is scheduled after 7/1/2016). Records #2 and #3 can be posted to a prior year period. If the Set Fiscal Year Equal to Budget FY is true when process selects record #2, then Fiscal Year will be set to 2016 and the Period will be set to the Prior Year Accounting Period value. When record #3 is eligible for selection, Accounting Period will be set to the Prior Year Accounting Period value, if populated. During the cross over period for frequencies other than Daily, it would be a good idea to specify the Prior Year Accounting Period and post the Cost Allocation transactions to that prior period. In case of daily frequency, if #3 needs to be posted to 2017/1 the Retain Fiscal Year indication needs to be false on the Cost Allocation Parameter record.

In addition to updates to the Allocation Percentage, a Consolidated Percentage field on Pool Base Setup may also be updated as part of the Run Mode. If the Perform COA Consolidation indication is true, then this Run Mode will consolidate all base accounting distributions in a single Step that have the same COA combination. The Consolidated Percentage field on Pool Base Setup will reflect the percentage that will be used in base expansion. The first record in a group of consolidated base records will reflect the sum of the Allocation Percentages for those records and the remaining records will have a value of zero as the Consolidated Percentage. Compute Allocations would then only generate base expansion records on Cost Allocation Expansion Results (CSAL_EXPN_RSLT) for those records with a non-zero Consolidated Percentage.