in the File Location field to select an alternate file location. If you choose the second option, leave the File Location field blank and use the File Upload Manager to upload the input file to the Costpoint database.The Import Asset Disposals application facilitates the initialization of large numbers of fixed asset disposal edit records into Costpoint. You typically process this screen when moving disposal edit records from one Costpoint database to another, but you can also use it to import disposal edit records from a legacy system. The application imports a delimited ASCII file of fixed assets disposal data generated by the Export Asset Disposals application when importing with a file. Users can also script data into import tables set up for this purpose. Scripting the import disposal data into the import tables would generally be done when setting up disposal edit records from a legacy system. In either case, before the data reaches the fixed assets tables, the application performs validations that are otherwise available only when manually adding records one at a time through the Manage Disposal Transactions screen or via the Create Multiple Disposal Transactions screen.
The Import Asset Disposals application stops users from importing data from a file with a fiscal year and period in the header row that does not match Costpoint's Current Fiscal Year and Current Period as displayed on the Configure Posting Settings screen. The Import Asset Disposals application only uploads an input file with a fiscal year and period that matches the Posting Settings in the “receiver” Costpoint database. This feature ensures that mass disposal record transfers from one Costpoint database to another are uploaded into the receiver database in the same Fixed Assets year and period in which the assets were downloaded from the provider database.
in the File Location field to select an alternate file location. If you choose the second option, leave the File Location field blank and use the File Upload Manager to upload the input file to the Costpoint database.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. After 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. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.
Enter, or click 
to select, a parameter
ID of up to 15 alphanumeric characters. 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 run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display in the screen, you can override the defaults.
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Use this group box to specify the format, file delimiter, and network location for the input file.
Enter the location of the input file you are importing. There are two ways to do this:
In the File Location field, enter, or click to select, the alternate file location where the input file is located. Alternate file locations are set up in the Manage Alternate File Locations screen.
or
From the Global Menu, click Process » File Upload. On the File Upload Manager dialog box, click Browse and use the dialog box to select the file you want to import. If you select the Overwrite? check box, Costpoint will overwrite any file of the same name that already exists in the Costpoint database. Click Upload when you are finished. If you use this method, leave the File Location field blank. For more information about the File Upload Manager, see the File Upload Manager topic in the Getting Started Guide.
Select the file format of the Fixed Assets disposal data to import into Costpoint from the drop-down list. Valid values are:
Delimited ASCII File — Select this option to indicate that you generated the input file with the Export Asset Disposals application in Costpoint. This option enables the remaining fields in the Input File group box and disables the Allow Partial Processing check box and the Process Table Options group box.
Table — Select this option to indicate that you will populate the FA_IMP_DISP (Import Asset Disposal Info Prior to Posting) table via scripts. This option disables the remaining Input File group box fields and enables the Allow Partial Processing check box and the Process Table Options group box.
For the input filename, in the unlabeled field to the right, enter, or click to select, the input file that is appropriate to upload into this receiving database during the present Fixed Assets Year and Period.
The system enables the File Delimiter field when you select Delimited ASCII File in the Format drop-down list. Select the delimiter to use in the Delimited ASCII input file from the drop-down list. The available options are:
Comma — The system selects Comma by default.
Other — If you select this, you must specify the one-character delimiter in the field to the right of the drop-down list. This field is enabled only when you select Other as the File Delimiter.
Select this check box to enable the system to process table records and generate an edit report if the table contains at least one error-free record for the option you selected in the Process Table Options group box.
Clear this check box to prevent processing the table records or printing the edit report when the table contains at least one records with one or more errors.
This check box is enabled when you select Table in the Format drop-down list.
Select this check box to so that imported records without values in any of the account/organization/project/Ref1/Ref2 combination of fields will have those fields populated with the values in the Gain/Loss Account Info group box. Once the check box is selected, the Gain/Loss Account Info group box will be enabled and you can enter or modify the default gain/loss account settings for use when importing the input file or table. If you choose to edit the settings, the system allows you to enter only valid Account/Organization/Project/REF 1/REF 2 combinations. The values in the Gain/Loss Account Info fields will be inserted into any input table or file records that do not contain G/L Account data for the disposal when the disposal edit records are created.
Clear this check box to disable the Gain/Loss Account Info group box and not have gain/loss account data inserted into import file or table records even when the account/organization/project/Ref1/Ref2 fields are empty on records you are attempting to import.
Select this check box to replace all of the records from an input file or that were scripted into the preprocessor tables that were previously validated but have not yet been imported to create disposal edit records with a new set of records that have not yet been processed. Clear this check box to keep the existing records ready to be imported.
Select the option in this group box that indicates the processing action you want Costpoint to take. You must select Table in the Format drop-down list to enable this group box.
Select this option to process rows of previously unprocessed data from the import table. This option is selected by default. This and the other Process Table Option selections do not apply to input files and are non-editable if you select Delimited ASCII File in the Format drop-down list.
Select this option to reprocess rows in the Import Asset Disposal Info Prior to Posting table (FA_IMP_DISP) that were previously uploaded with errors, but now contain corrected data. The system performs validations on these records prior to processing them.
If some of these records still contain errors that keep them from being processed into disposal edit records and the Allow Partial Processing check box is cleared, no records will be imported. However, if the Allow Partial Processing check box is selected, records without such errors will be imported and the records with errors will be available for correction and future import activity.
Select this option to delete records that have been processed into assets. To delete these records, you must click drop-down arrow of 
and select Validate Input File from the list.
When the screen is initially opened, the Gain/Loss Account Info group box is disabled and populated with Gain/Loss information from the Configure Fixed Assets Settings screen. The Use F/A Settings Default G/L Account check box is cleared by default, and this setting disables the Gain/Loss Account Info group box.
When you check the Use F/A Settings Default G/L Account check box, this group box, and the fields within the group box will be enabled and editable.
The system automatically displays the account, organization, project, reference 1 and reference 2 that have been set up in the Default Gain/Loss Account for GL Book group box on the Configure Fixed Assets Settings screen.
The non-editable fields in this group box display the current Fiscal Year, Period, and Subperiod on Fixed Assets Configure Posting Settings screen. If the header row of the input file or table contains a fiscal year/period combination that differs from what displays here, the system rejects the input file or table so that disposal edit records will not be imported into Costpoint at an inappropriate time. For example, if the asset records associated with the disposal edit records were previously depreciated through June in the previous database, and the disposal edit records were to be imported and accidently posted in May in the receiving database, the disposal posting entry would contain incorrect data for Accumulated Depreciation and for the Gain/Loss account. Thus, this validation ensures that the Fiscal Year/Accounting Period in Configure Posting Settings for the database that exported the disposal edit records matches the Fiscal Year/Accounting Period in Configure Posting Settings for the database receiving the disposal edit records.
IMPORT ASSET DISPOSALS PROCESSING