Use this screen to control the posting of the Pool (Allocation) Journal to the Ledger. It takes information from the Current Amount to Post field in the Maintain Allocation Journal screen (Projects\Transactions\Allocations) and updates the G/L with that amount for each account/organization or project/account/organization combination shown on the Maintain Allocation Journal screen. The credit (or offset) account/organization for each pool is taken from the Default Accounts tab of the Cost Pools screen (Projects\Maintain\Allocations).
Once the posting process is complete, the system deletes the records in the Maintain Allocation Journal screen for the selected pools and subperiods. The journal code for this posting is PAJ.
Use this screen whenever you need to post pool (allocation) journal records. Print the Service Center Cost Allocation Report and the Allocation Journal Edit Report (Projects\Review\Allocations) before you post this journal.
Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. Once you have saved a parameter ID and its related parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. Many users save a unique set of parameters for each different way they run a report or process. If you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults. You can change any of the associated selection defaults as necessary.
Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters. You should choose characters for your parameter ID that help identify the type of selections you made in the screen, such as “PERIOD” or “QUARTERLY.”
When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.
You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.
Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.
Use the fields in this group box to limit the pools that will be posted and to select the period in which you want to post the pool journal.
Pool Numbers *
Use this drop-down box to select the range of pool numbers that you want to include in the posting. The following options are available:
All - Select this option to include all available pool numbers. The Start and End fields are disabled for this option.
One - Select this option to include only one pool number. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of pool numbers. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the pool numbers from the beginning of the available pool numbers to a specific pool number in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the pool numbers from a specific pool number to the end of all the available pool numbers. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, a starting pool number for the range that you want to include in the process.
If you select "One," "Range," or "To End," in the Pool Numbers Option field, you must enter a pool number in this field.
If you select "All" or "From Beginning" in the Pool Numbers Option field, this field will be inactive.
Enter, or use Lookup to select, an ending pool numbers for the range that you want to include in the process.
If you select "All," "Range," or "From Beginning" in the Pool Numbers Option field, you must enter a pool number in this field.
If you select "One" or "To End" in the Pool Numbers Option field, this field will be inactive.
Subperiods *
Use this drop-down box to select the range of subperiods that you want to include in the posting. The following options are available:
All - Select this option to include all available subperiods. The Start and End fields are disabled for this option.
One - Select this option to include only one subperiod. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of subperiods. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the subperiods from the beginning of the available subperiods to a specific subperiod in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the subperiods from a specific subperiod to the end of all the available subperiods. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, a valid fiscal year in which you want to post the pool journal.
Enter, or use Lookup to select, a valid period in which you want to post the pool journal.
Enter, or use Lookup to select, a starting subperiod number for the range that you want to include in the process.
If you select "One," "Range," or "To End," in the Subperiods Option field, you must enter a subperiod number in this field.
If you select "All" or "From Beginning" in the Subperiods Option field, this field will be inactive.
This non-editable field displays the ending date for the subperiod entered in the Subpd (Start) field.
Enter, or use Lookup to select, an ending subperiod number for the range that you want to include in the process.
If you select "All," "Range," or "From Beginning" in the Subperiods Option field, you must enter a subperiod number in this field.
If you select "One" or "To End" in the Subperiods Option field, this field will be inactive.
This non-editable field displays the ending date for the subperiod entered in the Subpd (End) field.
Exclude Zero Allocation Amounts to G/L
If you select this checkbox, the application does not post any rows to the general ledger where the current amount to post is zero in the Maintain Allocation Journal screen (Projects\Transactions\Allocations). In additional, those rows are not copied from ALLOC_BASIS_JNL to ALLOC_BASIS_JNL_HS for regular cost pools and automatic service centers. No rows for manual service centers are deleted because the history tables can be used to import manual service center pool bases. By default, this checkbox is not selected.
* A red asterisk denotes a required field.
Changes in this screen update the following tables:
FS_SUM (Financial Statement Summary)
GL_POST_SUM - (General Ledger Posting Summary)
GL_DETL - (General Ledger Detail)
REF_SUM - (Reference Number Summary)
ALLOC_BASIS_JNL_HS - (Allocation Basis Journal History)
OPEN_BILLING_DETL - (Open Billing Detail)