Use this screen to view the amounts that will be posted to the General Ledger for pools and service center pools for a given fiscal year, period, and subperiod. This screen is populated by the Compute and Print Pool Rates process. It can also be populated manually if you have service centers with a manual base in your pool structure.
The tables in this screen store both current period and year-to-date calculations for the calculation period. The radio button you select in the Apply Burdening Based On group box in the Corporate Settings subtask of the Project Settings screen (Administration\Configure\Projects) determines the amount that the tables post (current or YTD).
For service center pools only (and specifically service center pools with a Manual Calculation of Base method selected in the Service Center subtask of the Cost Pools screen (Projects\Maintain\Allocations)), you can edit the Current Number of Units, Current %, Current Allocation Amount, and Current Amount to Post fields.
Also, for manual service center pools only, you can import the allocation rows based on the allocation journal history, and thus populate the table window based on the historical allocations for this pool.
|
|
Note: If you have a YTD Manual Service Center that is allocated using units as the basis, you should enter data in both the Current Number of Units and YTD Number of Units fields. The Import feature sums the current units quantity from the Allocation Basis Journal History table and inserts this number in both the Current Number of Units and YTD Number of Units fields. If you do not enter data in these two fields, the number of units imported will be zero. |
This screen is made up of one block, a table window, and one subtask. They can be used as follows:
Use the Basic Information block to enter the allocation group, the pool number, and the period information. The pool name and basic description will automatically display when you enter the pool number and allocation group.
Use the Table Window to view the allocation amounts inserted by the Compute & Print Pools Rates screen (Projects\Process\Allocations).
Use the Import subtask to enter the periods from which you want to import allocation history.
You can edit this screen only for service center pools for which you selected Manual in the Calculation of Base group box in the Service Center subtask of the Cost Pools screen (Projects\Maintain\Allocations). You should maintain this screen whenever service center allocations are required (usually monthly), or whenever adjustments to a service center allocation are necessary. After you have executed the Compute & Print Pools Rates screen (Projects\Process\Allocations), non-service center pools will populate this screen.
Use the fields in this block to view identification data for the pool number and period information.
Use the fields in this group box to view the allocation group, pool number, pool name, and basic description.
Enter, or use Lookup to select, the allocation group number for the pools specified in the journal. The group number can include groups that are not group one, but only amounts for group one will be posted to the General Ledger.
Pool *
Enter, or use Lookup to select, the pool number being allocated. The adjacent field displays the name of the selected pool number.
This non-editable field displays the basis description from the Cost Pools screen (Projects\Maintain\Allocations) for the pool number identified.
Use the fields in this group box to review or select the period through which costs are included in the pool. If you are manually entering service center information, you can select the period to which you would like to post. Otherwise, the Compute Pools process will automatically insert the period information entered in the Compute & Print Pools Rates screen (Projects\Process\Allocations).
Enter, or use Lookup to select, a fiscal year.
Period *
Enter, or use Lookup to select, a period.
Enter, or use Lookup to select, a subperiod.
Use this fields in this table window to view the details of the cost pool calculations.
Line *
This non-editable field displays the line number that identifies each transaction separately.
Account *
Enter, or use Lookup to select, the account to receive the allocation of costs contained in the allocation journal from the pool displayed in the Identification group box.
Enter, or use Lookup to select, the organization that, in combination with the selected allocation accounts, will receive the allocation of costs contained in the allocation journal for the pool displayed in the Identification group box.
Enter, or use Lookup to select, the abbreviation of the organization entered. Enter the abbreviation here to display the organization number in the Organization field.
Enter, or use Lookup to select, the project that will receive the allocation of costs contained in the allocation journal for the pool displayed in the Identification group box.
Enter, or use Lookup to select, the project abbreviation of the project number entered. Enter the abbreviation here to display the project number in the Project field.
Enter the number of units that form the basis of the pool displayed in the Identification group box for the Account/Organization/Project combination entered. The number of units can include head count, number of pages, square footage, percents, etc.
The Compute & Print Pools Rates process (Projects\Process\Allocations) will automatically populate this field if the record is a non-service center pool.
This non-editable field displays the system-calculated percentage of total current units that are represented by the number of units entered into each row.
This field displays the system-calculated allocation amount derived by multiplying the Current % by the total cost in the pool, or by multiplying a standard rate by the current units. The system calculates this amount "on the fly" during the Compute & Print Pools Rates program (Projects\Process\Allocations). However, you can edit the Current Allocation Amount to make adjustments.
This field displays the amount to post derived by subtracting from the Current Allocation Amount or YTD Allocation Amount any amounts that have already been posted to the Account/Organization/Project combination. You can edit this amount to make adjustments.
Enter the number of YTD units that forms the basis of the pool displayed in the Identification group boxfor the Account/ Organization/Project combination entered. The number of units can include head count, number of pages, square footage, percents, etc.
This non-editable field displays the system-calculated percentage of total YTD units that is represented by the number of YTD units entered in each row.
This field displays the system-calculated allocation amount derived by multiplying the YTD % by the total cost in the pool or by multiplying a standard rate by the YTD Number of Units. The system calculates this amount "on the fly" during the Compute & Print Pools Rates program (Projects\Process\Allocations). However, you can edit the allocation amount in order to make adjustments.
Enter, or use Lookup to select, a reference 1.
Enter, or use Lookup to select, a reference 2.
* A red asterisk denotes a required field.
Use this pushbutton to recalculate the data in the table window.
Select this link to open the Import subtask, where you can import allocation rows from Allocation Journal History.
Changes to this screen update the ALLOC_BASIS_JNL (Allocation Basis Journal) table.
