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.

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

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

From the drop-down list, select your input source:

• ASCII File (fixed length)
• Tables: The Tables setting uses three database tables for importing vouchers. The tables correspond to the three parts of a voucher: header, expense lines, and labor. The columns in the input file layout are also in the tables. There are two additional columns:
• Record Number (REC_NO): Used as the primary key. You should make sure that it is unique when populating the tables with data. 
• Status Code (S_STATUS_CD): Used to identify rows that have not been processed, are in error, or have been imported.

  The tables are:

  Table	Contains Information to be Imported for the:
  AOPUTLAM_INP_HDR	Header-type record
  AOPUTLAM_INP_DETL	Detail-type record
  AOPUTLAM_INP_LAB	Labor-type record

Select this option to use the voucher numbers provided in the input file when importing vouchers to Costpoint tables. This is the default.

Select this option to assign unique voucher numbers sequentially when importing to the Costpoint tables. Costpoint uses the Last System Voucher Number from the Configure Accounts Payable Voucher Settings screen to determine the next voucher number.

Select this option to enter a beginning voucher number in the data field directly below this option. Unique voucher numbers are assigned sequentially when you import, starting with the beginning voucher number you enter.

If you select the Use Last System Voucher Number option, the Costpoint system-wide setting for the Voucher Numbering Method option on the Configure Accounts Payable Voucher Settings screen must be set to System, and the Last System Voucher Number field must be greater than or equal to zero.

Select this option to process rows from the input tables having a status (S_STATUS_CD) of NULL. The rows are selected from the Header, Detail, and Labor tables.

Records that pass validation and records that fail validation are loaded into separate temporary tables; this is the same procedure for processing input files. The status code (S_STATUS_CD) column is then updated to E (Error) in all the input tables for the corresponding records that contain errors.

When you click the Import Vouchers button on the toolbar, all the records that passed validation are inserted into the base tables (VCHR_HDR, VCHR_LN, VCHR_LN_ACCT, and VCHR_LAB_VEND). The Status Code column is then updated with an I (Imported) to show that these rows have been successfully imported.

Select this option to re-process rows from the input tables having a status (S_STATUS_CD) of E (Error).

Select this option to delete rows from the input tables having a status (S_STATUS_CD) of I (Imported). If you select this option, Costpoint deletes records from the AOPUTLAM_INP_HDR, AOPUTLAM_INP_DETL, and the AOPUTLAM_INP_LAB input tables.

Select this check box to print the edit report when you run the Validate Input File process.

Select this check box to expand the Account, Org, Project, Reference Number 1, and Reference Number 2 fields in the input file when processing.

If you select this check box, Costpoint pads any segment of the affected fields that is shorter than the specified length for that segment:

• If the value is numeric, Costpoint pads the segment with zeros on the left.
• If the value is alphanumeric, Costpoint pads the segment with spaces on the right.

Keep this check box selected (the default) to allow overwriting of existing records during the import process. Clear this check box to prevent overwriting of existing records.

Keep this check box selected (the default) to instruct Costpoint to continue processing if it encounters error records. Clear this check box to have Costpoint stop processing if it encounters error records.

Select this check box to import multicurrency vouchers that are not assigned to the logged on user.

This field displays the transaction currency of the file that you are importing. All records in the file or rows in the table must have the same transaction currency. You originally specified the transaction currency on the Configure Multicurrency Settings screen. If necessary, you can change the transaction currency by using the Exchange Rates subtask.

Click or drop-down list and select Validate Input File to read the input file, create temporary tables, validate records, and print the Error Report. This step can be performed simultaneously by more than one user.

When you select the Print Edit Report during validate check box, the edit report prints after validation.

Click drop-down list and select this option to validate and import vouchers. This action will print both the error and edit reports.

Only one user at a time can perform this step on this application and you cannot run it simultaneously with the Validate Input File option. You can set this step on the Manage Jobs screen so that the validate and import process can be done at the job server.

The following output files are generated by this preprocessor:

• Error File (Input File name + .ERR)
• Edit Report
• Error Report