Contents of the Create EFT File Screen

Use the fields and options to configure the Create EFT File screen.

Create EFT File

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.

Same Day ACH

Select this checkbox to indicate that the payment is to be processed on the same day as the Effective Date.

This field displays only if the EFT Format Type is ACH and the EFT Transfer Code is not IAT.

Note: If you submit a same-day ACH file that has a past Effective Date, the transaction will be processed in the next available processing window, either on the same day or the next day.
EFT Direct Upload

Select this checkbox to upload created EFT files directly to the website or system of the bank account you entered in the Bank Abbr field.

This field displays only if the EFT Format Type is ACH and the EFT Transfer Code is not IAT.

Note: This checkbox is enabled only if the Bank Abbrev you entered is assigned a Bank Integration ID on the Manage Company Bank Accounts (US Banks) screen.
Same Day Window Options

Select the processing time window for your payment. The options in this drop-down list follow the ACH schedules and funds availability for same-day payments.

  • 1PM Window
  • 5PM Window
  • 6PM Window

This group box displays only if you selected the Same Day ACH checkbox.

Bank Submission Deadline

This field displays the time you must submit the ACH file to your company’s bank.

Note: Once you create the same-day ACH file, be sure to submit it to your company’s bank on the Effective Date you entered, before the time displayed on 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 Format Type

Select the type of EFT file you want to create. The options are:

  • ACH: Select this option to create an Automated Clearing House type EFT file.
  • 820: Select this option to create 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.
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
  • IAT: International ACH Transaction.

    This option is available only if the EFT Format Type is ACH, and the Currency of the Bank Abbr you selected and your functional currency are both USD.

    Note: For Costpoint Cloud, you can choose to opt in to this feature for the Costpoint 8.2.15 release. The ability to opt in is temporary and will be removed when the feature becomes automatically enabled for all users as part of a future Costpoint release. See the Manage Opt-In Features topic for more information.

ACH Addenda

This group box displays only if the EFT Format Type is ACH and the EFT Transfer Code is not IAT.

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

This group box displays only if the EFT Format Type is ACH and the EFT Transfer Code is not IAT.

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.

IAT File Selections

This group box displays only if the EFT Transfer Code you selected is IAT.

Note: For Costpoint Cloud, you can choose to opt in to this feature for the Costpoint 8.2.15 release. The ability to opt in is temporary and will be removed when the feature becomes automatically enabled for all users as part of a future Costpoint release. See the Manage Opt-In Features topic for more information.
Field Description
Pay Currency

Enter, or click to select, the code of the currency in which the pay vendor is expecting payment.

Destination

Use this field to enter or select the two-character country code of the payment destination.

Exchange Indicator

This field displays the exchange rate type for the payment transaction.

If the Pay Currency is USD, this field displays Fixed to Fixed (FF). Otherwise, it displays Fixed to Variable (FV).