Use this screen to purge the Allocation Basis Journal History table. This table stores historical data when you post the Pool Journal, and is used for the Import feature for manual service centers. Use this process to remove data from the Allocation Basis Journal History table that is no longer useful. You can use the Fiscal Year and Period/Subperiod fields to purge specific data.
Use this screen after using the Import feature in the Maintain Allocation Journal screen (Projects\Transactions\Allocations).
|
|
Note: If you purge the ALLOC_BASIS_JNL_HS table, you cannot to use the Import feature in the Maintain Allocation Journal screen. The Import feature is available for manual service center pools only and pulls the historical data from the ALLOC_BASIS_JNL_HS table. |
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 block to select allocation group and pool numbers that you want to purge. You can also select the accounting periods that should be purged.
Enter, or use Lookup to select, an allocation group number to be purged. The default value is "1," which represents your primary allocation group.
The non-editable field to the right displays the allocation group description based on the number selected in the Allocation Group Number field.
Pool *
Use this drop-down box to select the range of pools that you want to include in the process. The following options are available:
All - Select this option to include all available pools. The Start and End fields are disabled for this option.
One - Select this option to include only one pool. 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 pools. 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 pools from the beginning of the available pools to a specific pool 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 pools from a specific pool to the end of all the available pools. 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 Option field, you must enter a pool number in this field.
If you select "All" or "From Beginning" in the Pool Option field, this field will be inactive.
Enter, or use Lookup to select, an ending pool number for the range that you want to include on the report.
If you select "All," "Range," or "From Beginning" in the Pool Option field, you must enter a pool number in this field.
If you select "One" or "To End" in the Pool Option field, this field will be inactive.
Fiscal Year *
This non-editable field displays the "One" option. This is because you can only run this process for one fiscal year at a time.
Enter, or use Lookup to select, the starting fiscal year for the range you want to purge.
Period/Subperiod *
Use this drop-down box to select the range of periods/subperiods that you want to include in the process. The following options are available:
All - Select this option to include all available periods/subperiods. The Start and End fields are disabled for this option.
One - Select this option to include only one period/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 periods/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 periods/subperiods from the beginning of the available periods/subperiods to a specific period/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 periods/subperiods from a specific period/subperiod to the end of all the available periods/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 starting period number for the range that you want to include in the process.
If you select "One," "Range," or "To End," in the Period/Subperiod Option field, you must enter a period number in this field.
If you select "All" or "From Beginning" in the Period/Subperiod Option field, this field will be inactive.
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 Period/Subperiod Option field, you must enter a subperiod number in this field.
If you select "All" or "From Beginning" in the Period/Subperiod Option field, this field will be inactive.
Enter, or use Lookup to select, an ending period number for the range that you want to include on the report.
If you select "All," "Range," or "From Beginning" in the Period/Subperiod Option field, you must enter a period number in this field.
If you select "One" or "To End" in the Period/Subperiod Option field, this field will be inactive.
Enter, or use Lookup to select, an ending subperiod number for the range that you want to include on the report.
If you select "All," "Range," or "From Beginning" in the Period/Subperiod Option field, you must enter a subperiod number in this field.
If you select "One" or "To End" in the Invoice Period/Subperiod Option field, this field will be inactive.
* A red asterisk denotes a required field.
This screen updates the ALLOC_BASIS_JNL_HS (Allocation Basis Journal History) table.
