Contents of the Import Asset Disposals Screen

Use the fields and options to configure the Import Asset Disposals screen.

Identification

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, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.

Field Description
Parameter ID

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 on the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made on 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 on the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Options

Input File

Use this group box to specify the format, file delimiter, and network location for the input file.

Field Description
File Location

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.
Format

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.

File Delimiter

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.
Allow Partial Processing

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.

Use F/A Settings Default G/L Account

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.

Overwrite the Existing records

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.

Process Table Option

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.

Note: Refer to the Import Asset Disposals Processing topic for a detailed description of the interaction between the following options and the toolbar buttons you use to produce reports and process table records.
Field Description
Load Unprocessed Records

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.

Reprocess Error Records

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.

Delete Imported Records

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.

Gain/Loss Account Info

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.

Field Description
Account, Organization, Project, Ref 1, Ref 2

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.

Note:

The fields Ref 1 and Ref 2 may display a different label if they have been changed on the Configure General Ledger Settings screen. For example, the Ref1 and Ref2 fields may be set up on that screen to display as AC 1 and AC 2.

FY/Pd Info

Field Description
Fiscal Year, Period, Subperiod

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.