Understanding Burdening-Based Allocations
Unlike the programs used for account balance-based allocations, the programs for burden-based allocations base the source and basis amounts for allocations on data in the Burdening Summarized Ledger table (F52G02). Burden-based allocations also use data from the F0901 and F0006 tables, as do account balance-based allocations.
For burden-based transactions, you can select any of these variables as the basis ratio for an allocation:
Contract type (user-defined code (UDC) table 51/CT).
Employee pool grouping code (UDC table 00/12).
Job pool grouping codes (UDC table 00/12).
Business units, related business units, business unit types, and category codes 1–50.
The advanced variable numerator allocations programs enable you to perform complex allocations on burden-based transactions, such as:
Include or exclude certain criteria from the F52G02 table, such as burden categories for fringe or overhead, in the source or basis data selection (R09123C).
Identify the burden type (cost or alternate cost) for source and basis for each allocation (P09123).
For direct allocations, use the basis business unit as the destination business unit or retrieve the business unit from the contract master.
For indirect allocations, use the basis business unit as the destination business unit. Alternatively, you can set up destination business-unit overrides so that destination amounts can be allocated to multiple basis values.
For example, assume that the basis business unit includes base values for pools 1 and 2 (which each include 10 business units). You could set up the allocation so that the destination entry for pool 1 is recorded in override business unit A and the destination entry for pool 2 is recorded in override business unit B.
Define direct allocations of labor based on the home business unit of the employee or job (from the F48S84 table) in the source or data selection (R0948S84). Then specify an employee pool or a job pool grouping code for the allocation (P09123).
Calculate allocations based on user-specified dates for the source and basis (P09123). Then specify the from and thru periods and fiscal year in the processing options (R09123).
Use the results of one allocation as the source or basis of another allocation. To do this, you should run the allocations in different batches and schedule the batches to run in a single thread. In the processing options for the R09123 program, specify a General Ledger Post (R09801) version that calls a version of the R52G11 program to create burden transactions in the F52G11 and G52G02 tables. The results of the first allocation must be burdened before the next allocation runs; otherwise, the results of the second allocation are not be accurate.
Functionality that is available for burden-based allocations, as well as account balance-based allocations, includes creating destination business-unit overrides for based-upon values (P09123A) and designating a destination account that is different from the source or basis account (P09123).
Review the setup tasks that are required for advanced variable numerator allocations for the burden-based transactions:
Create business unit overrides in the P09123A program.
Create data selection versions for source and basis pool groupings over the F48S84 table in the R0948S84 program.
Create data selection versions for source and basis accounts over the F0006, F0901, and the F52G02 tables in the R09123C program.
Set up specifications for source, basis, destination, and offset accounts in the P09123 program.
Print the specifications for source, basis, destination, and offset accounts in the R09123A program.
Calculate the source, basis, destination, and offset amounts in the R09123 program.
Typically, after you complete the setup tasks for allocations, revise the specifications and test the output until you are satisfied with the results. After the initial setup, revise the specifications only if you receive new requirements or a change occurs in the organization.
On a routine basis, calculate allocations based on the specifications that you set up. Calculating allocations is the final, and recurring, step in the allocation process. To do this, run the R09123 program.