Contents of the Create EFT File Screen

Use the fields and options to configure the Create EFT File 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

Select Bank Abbreviation

Field Description
Bank Abbr

Enter, or click to select, the bank account abbreviation for the bank from which EFT payments will be made. This field is required. Costpoint validates that the bank account abbreviation was entered on the Manage Company Bank Accounts (US Banks) screen. If this validation fails, Costpoint displays an error message and you cannot save your settings or create the EFT file.

You can create the EFT file for only one bank/bank account combination at a time.

After you enter a bank account abbreviation, a description of the bank account abbreviation displays in the adjacent field.

Currency

This non-editable field displays the bank account currency linked to the bank abbreviation.

Taxable Entity

Enter, or click to select, a valid taxable entity number.

Company Tax ID Qualifier (ICD)

Enter your company's tax ID qualifier in this field. The Identification Code Designator (ICD) is the first character of the company identification field. The default value for this field is 1.

File Information

Field Description
Effective Date

Enter, or click to select, the date on which the bank should credit the vendors' accounts. This is the date the payment becomes effective. The current system date automatically defaults into this field.

ACH File Name

Enter the name of the file Costpoint will create, and the path, if necessary, in this required field. Each time that you create an EFT file with this name, Costpoint overwrites the old file. To keep previous copies of the EFT file, Deltek recommends that you develop a system of naming that produces unique names for each file. For example, you could use a month/date approach, which would identify a file created on July 1 as BANK0701.DAT, a file created on July 31 as BANK0731, and so on. There is no default for this field because all ACH file names are dependent on the instructions from your bank.

Location

Enter, or click to select, the location code that identifies where the file is to be created.

Overwrite File

Select this check box if you want to overwrite the existing EFT file.

EDI Control No

Enter the control number for the Electronic Data Interchange (EDI) output file. The EDI is the electronic exchange of business transaction information in machine readable format. This number will be used to build the control numbers within the file.

EFT Transfer Type

Field Description
EFT Transfer Type

From the drop-down list, select the EFT transfer type that your bank has specified:

  • CTX: Corporate Trade Exchange
  • CCD: Cash Concentration or Disbursement
  • PPD: Prearranged Payment and Deposit Entry
  • 820 Transaction Set: Creates the EFT file using only the 820 Transaction Set; the ISA/IEA and GS/GE envelopes are not created around the 820 detail transaction set.

ACH Addenda

Field Description
Include Addenda Records

Select this check box to include addenda records with the EFT.

The CCD and PPD transfer types cannot have more than one addenda record for each vendor; otherwise, the bank will reject the record. Review the Print EFT Edit Report screen to see if the file contains too many addenda records.

Addenda Format

Select one of the following options as the format for the addenda records:

Field Description
ASC X12

Costpoint creates the addenda records using the ASC X12 format.

Non-standard

Costpoint creates the addenda records using a non-standard format.

Create EFT File

Click on the toolbar to create the EFT file.