Use this screen to upload your allocation basis journal from the ALLOC_BASIS_PREP table into your Costpoint ALLOC_BASIS_JNL table. You can populate the Maintain Allocation Journal screen (Projects » Cost and Revenue Processing » Cost Pool Processing & Reporting) by using this screen rather than manually entering the data.
Use this toolkit only for service center type pools with a Manual Calculation Base in the Service Center subtask of the Cost Pools screen (Projects » Cost and Revenue Processing » Cost Pool Setup). You can execute this screen more than once for the same fiscal year, period, subperiod, and pool number combination, but the system will delete any unposted records residing in the ALLOC_BASIS_JNL table for this same combination to ensure that duplicate data is not uploaded.
Before using this screen, you must populate the ALLOC_BASIS_PREP table. The layout of this table is noted in the processing instructions that follow. Records that successfully upload will populate ALLOC_BASIS_JNL and be deleted from ALLOC_BASIS_PREP. Records that do not successfully upload will be detailed in the table window with their respective error descriptions. These records will continue to reside in the ALLOC_BASIS_PREP table. Thus, you can adjust the data in the table and try again to upload them. Note that you should first either post the records that are successfully uploaded or populate ALLOC_BASIS_PREP with the same records from the original upload. You should process partial information only if you are using a standard cost service center. If you are using a year-to-date or current period service center, you must correct the failed records and post all records together. As noted previously, data in the ALLOC_BASIS_JNL is always deleted for the fiscal year, period, subperiod, and pool number combination that is being uploaded.
Use the fields in this group box to select the period information and pool number that will be associated with the data you are uploading.
Use this drop-down list to select the fiscal year of the records you want to upload.
Use this drop-down list to select the period of the records you want to upload.
Use this drop-down list to select the subperiod.
Use this drop-down list to select the pool.
Select this check box to upload input data from a text file.
Select this check box to create the Allocation Basis Journal (ABJ). This check box is selected by default.
Use the fields in this group box to enter information about the data file to be uploaded.
Enter, or use this button to select, the path and input file that you want to upload.
Use this drop-down list to select the format of the file that you want to upload. Valid options are:
Comma-Separated Values
Fixed-Length
Comma-separated value files contain data separated by commas with character fields surrounded by double quotes. Fixed-length files contain data positioned in a set range of columns for each field. For more information and examples of file formats, click the File Format Help button.
Use this drop-down list to select the action that will be performed if the values of the input file are larger than Costpoint will allow. Valid options are:
Always Truncate
Never Truncate
Warn Before Truncation
If the file format is Comma-Separated Values, all truncated value selections are available. If you select Fixed-Length, the only available selection is Never Truncate.
Click this button to obtain more information on file formats.
This table window displays the records that failed to upload and provides an error description for each.
Click this icon on the toolbar to execute the upload process.
Populate the ALLOC_BASIS_PREP table per the following layout:
|
ACCT_ID |
VARCHAR2 (15) |
NOT NULL |
|
ORG_ID |
VARCHAR2 (20) |
NOT NULL |
|
POOL_NO |
NUMBER (10,0) |
NOT NULL |
|
CUR_BASE_UNITS_QTY |
NUMBER (14,4) |
NOT NULL |
|
YTD_BASE_UNITS_QTY |
NUMBER (4,4) |
NOT NULL |
|
PROJ_ID |
VARCHAR2 (30) |
|
|
REF1_ID |
VARCHAR2 (20) |
|
|
REF2_ID |
VARCHAR2 (20) |
|
Execute this toolkit. Review the errors, if any. After correcting the errors for records that you want to upload, you have two options. The first option is to post the Maintain Allocation Journal for the records that successfully uploaded. You can then attempt to re-upload the records that were unsuccessful. The second option is to not post the successful records. You would then have to re-populate ALLOC_BASIS_PREP with the entire original selection of records before re-executing the toolkit. You should process partial records only if you are using a standard cost service center. If you are using a year-to-date or current period service center, you must process all records together.
This screen populates the Maintain Allocation Journal screen (Projects » Cost and Revenue Processing » Cost Pool Processing & Reporting) only with the units that will be charged to each project, account, and organization. To populate the Journal with the remaining columns such as Current Percentage, Current Allocation Amount, and Current Amount To Post, you must run the Compute & Print Pool Rates screen (Projects » Cost and Revenue Processing » Cost Pool Processing & Reporting) for the pools that have been uploaded. This can be completed separately or with your other pools during the normal cost and revenue process.
You can post the uploaded pools separately or in the normal process.