Create a new EFT Template

Made2Manage provides you with the following NACHA format templates that you can customize for your use:

• CCD (Corporate Credit or Debit) : Used to pay or collect from other corporate (business) accounts. For example, for making vendor payments.
• PPD (Prearranged Payment and Deposit) : Used to pay or collect from personal (consumer) accounts. For example, for direct deposit of payroll to employees

For more information about the NACHA format templates, refer to the NACHA website. However, you can create other EFT templates using the EFT Template Designer ( EFTTMPL) window, The EFT Template Designer (EFTTMPL) window is available only if you have have assigned appropriate permissions for the EFT Template Designer (EFTTMPL) window in the User Permission Wizard (PERMWIZ). For more information about assigning permissions, see Assign default permission to the new windows/reports and Manage user permissions. You can copy an existing template and modify it or create a new one from scratch. To enable successful processing, standards have been defined for most EFT templates. Refer to the appropriate documentation for the template that you want to create and plan its structure before you create the template. Determine the mandatory fields in your template. Then, perform the steps described in this topic. To create a new EFT template

1. To open the EFT Template Designer(EFTTMPL) window, press Alt+T, type EFTTMPL, and click OK.

2. On the Active Form ribbon, click New ().

3. In the EFT File Template Name field, type the template name.

4. Specify the filler record information, if required: 1. Select the Include Filler Records check box. 2. In the Filler Value field, type the character to use in the filler records. 3. In the Filler Row Width field, specify the row width of the filler records.

** Note: **The Filler Value and Filler Row Width fields are enabled only when you select the Include Filler Records check box.

5. To include debit memos: 1. Select the Include DM check box. 2. In the Replacement Code field, type 27. 3. In the Replacement Column field, type the transaction code column in which the replacement code must be substituted specified in the format | <row number > - <column number >|

6. Select the Include Zero Amount Vendor Records check box to include zero payment amounts in the generated EFT file.

7. Select the tables that you want to associate with the template: 1. In the header area, click Tables. The Tables window is displayed. 2. On the grid toolbar, click New (). 3. Click the Name Lookup Reference button (). 4. In the Lookup for Name window, select the required table row. 5. Click Select. 6. Perform steps 6b - 6e for all the tables that you want to add to the template. 7. On the header, click Save (). The message “There are some changes made in the parent window. Do you want to continue with Saving?” is displayed.

8. Click **Yes** to save the changes.

9. Close the **Tables** window.

8. In the Row Details area, add the row details: 1. On the grid toolbar, click New (). The Row Sequence value is automatically assigned based on the number of rows that exist.

1. From the **Row Type** list, select the row content type:
   * **Header** : Select this if the row is a header record such as the file header or the batch header records.
   * **Detail** : Select this if the row is a detail record.
   * **Trailer** : Select this if the row is a control record such as the file control or the batch control records.
2. In the **Row Description** cell, type a brief description of the row.
3. In the **Row Width** cell, type the row width .
4. In the **Header Link** cell, type the parent row number.

** Note: **The Header Link value must be at least 1 less than that of the Row Sequence.

5. In the **Row Space** cell, type the spacing for the row, if required.

** Note: **If no value is given, single spacing is assumed.

6. Repeat steps 8a - 8f for each row that you want in your EFT file.

9. In the Column Details area, specify the column details of each row: 1. In the Row Details area, select the row for which you want to add the column details. 2. On the grid toolbar, click New (). The Column Sequence value is automatically assigned based on the number of columns already added for the row. The Data Start Position is also automatically computed.

3. In the **Data End Position** cell, type the length of the column.

The Data Length is automatically computed and displayed.

4. In the **Column Description** cell, type a brief description of the column.
5. From the **Data Type** list, select the column data type:
   * **FreeText** : For hard coded text.
   * **Expression** : For a computed expression.
   * **Current Date** : For the system date.
   * **Current Time** : For the system time.
   * **System** : For an M2M field from one of the tables associated with the template.
6. In the **Data Source** cell, specify the column value's source for the following data types:
   * **FreeText** : Type the hard coded text.
   * **System** : Click the corresponding **Data Source** Lookup Reference button (![](../Resources/Images/LookupRef.png)) and select the Made2Manage field in the **Lookup For** window.

** Note: **If you select a Made2Manage date field, you must specify the date format.

7. Select the corresponding check box in the **Mandatory** column if a value must be present for the column in the EFT file.
8. In the **Justified** cell, select the justification that must be applied to the column value if it is less than the column width.
9. In the **Padding Value** cell, type the character to use for padding if the column value is less than the column width.

** Note: **The default padding value is space.

10. If the **Data Type** of the column is **Expression** or **System** , from the **Source Data Trim** list, select the position from which the data must be trimmed if the value exceeds the data length: **Right** or **Left**.
11. If the **Data Type** of the column is **Expression** , perform the following actions:
  1. From the **Expression** list, select the expression to be used for the column:
     * **Count of** : To count the occurrences of one or more rows.
     * **Concatenation of** : To concatenate the values in a particular column.
     * **Sum of** : To sum the values of a column that contains decimal data.
  1. Select the corresponding cell in the **Expression Reference** column.
  2. Click the **Expression Reference** button (![](../Resources/Images/ExpressionRefButton.png)).

The Expression Reference window displays the different columns in the different rows.

  3. Select the check boxes in the **Select** column of the rows that correspond to the required columns.
  4. On the header, click **Save** (![](../Resources/Images/HeadSave.png)).

The message “There are some changes made in the parent window. Do you want to continue with Saving?” is displayed.

  5. Click **Yes** to save the changes.
  6. Close the **Expression Reference** window.
12. If the **Data Type** of the column is **Current Date** or if the **Data Type** of the column is **System** and the **Data Source** is a date field, perform the following actions:
  1. From the **Date Format** list in the corresponding cell, select the date format to apply to that column value.
  2. From the **Time Format** list in the corresponding cell, select the time format to apply to that column value, if required.
  3. From the **Separator** list in the corresponding cell, select the separator to be used for the date and time value, if required.
13. To mark the column value as the unique identifier for the row, select the check box in the corresponding cell of the **Unique Identifier** column.

** Tip: **It’s a good practice to set at least one column as the unique identifier for a row.

14. If the **Data Type** of the column is **FreeText** , and if you have specified an integer value in the **Data Source** field, in the cell in the **Increment** column, type the number by which the value must be incremented, if required.
15. If the column value must be wrapped to the next row when it exceeds the row width, select the check box in the cell of the **Row OverFill** column .

** Note: **When you select the Row Overfill check box, data length validation is not done for the column.

16. If the column value is an expression that loops based on the unique column identifier, select the check box in the in the cell of the **Loop Expression** column.

** Note: **This check box is enabled only if you select the Row Overfill check box and is usually applicable for Addenda records.

17. If the column value has decimal digits, perform the following actions:
  1. In the cell in the **Decimal Length** column, type the number of decimal digits that must be considered.
  2. In the cell in the **Decimal Separator** column, type the decimal separator to use.

10. On the Active Form ribbon, click Save () to save the template.

To copy an existing template and customize it

1. To open the EFT Template Designer (EFTTMPL) window, press Alt+T, type EFTTMPL, and click OK.

2. Select the EFT template that you want to copy and customize: 1. On the Active Form ribbon, click Browse (). 2. In the Browse for EFT Template Designer window, select the required EFT template. 3. Click OK.

3. On the Active Form ribbon, click Copy ().

4. In the EFT File Template Name field, type the template name.

5. Modify the filler record information, if required:

   • If you do not want to include filler records, clear the Include Filler Records check box.
   • To include filler record information:
   1. Select the Include Filler Records check box.
   2. In the Filler Value field, type the character to use in the filler records.
   3. In the Filler Row Width field, specify the row width of the filler records.

** Note: **The Filler Value and Filler Row Width fields are enabled only when you select the Include Filler Records check box.

6. To include debit memos: 1. Select the Include DM check box. 2. In the Replacement Code field, type 27. 3. In the Replacement Column field, type the transaction code column in which the replacement code must be substituted specified in the format | <row number > - <column number >|

** Tip: **To exclude debit memos, ensure that the Include DM check box is not selected.

7. To include zero payment amounts in the generated EFT file, select the Include Zero Amount Vendor Records check box. To exclude zero payment amounts in the generated EFT file, ensure that the Include Zero Amount Vendor Records check box is not selected.

8. To change the tables that you want to associate with the template: 1. In the header area, click Tables. The Tables window is displayed.

2. To add a new table:

  1. On the grid toolbar, click **New** (![](../Resources/Images/New.png)).
  2. Click the **Name** Lookup Reference button (![](../Resources/Images/LookupRef.png)).
  3. In the **Lookup for Name** window, select the required table row.
  4. Click **Select**.
3. To remove a table from the template:
  1. Select the table row.
  2. On the grid toolbar, click **Delete** (![](../Resources/Images/Delete child button.jpg)).

The message “Preparing to delete this information. Are you sure?” is displayed.

  3. Click **Yes** to confirm the deletion.
4. On the header, click **Save** (![](../Resources/Images/HeadSave.png)).

The message “There are some changes made in the parent window. Do you want to continue with Saving?” is displayed.

5. Click **Yes** to save the changes.
6. Close the **Tables** window.

9. In the Row Details area, change the row details: * To add details of a new row: 1. On the grid toolbar, click New (). The Row Sequence value is automatically assigned based on the number of rows that exist.

   2. From the **Row Type** list, select the row content type:
      * **Header** : Select this if the row is a header record such as the file header or the batch header records.
      * **Detail** : Select this if the row is a detail record.
      * **Trailer** : Select this if the row is a control record such as the file control or the batch control records.
   3. In the **Row Description** cell, type a brief description of the row.
   4. In the **Row Width** cell, type the row width .
   5. In the **Header Link** cell, type the parent row number.

** Note: **The Header Link value must be at least 1 less than that of the Row Sequence.

   6. In the **Row Space** cell, type the spacing for the row, if required.

** Note: **If no value is given, single spacing is assumed.

 * To delete a row's details
   1. In the **Row Details** grid, select the required row.
   2. On the grid toolbar, click **Delete** (![](../Resources/Images/Delete child button.jpg)).

The message “Preparing to delete this information. Are you sure?” is displayed.

   3. Click **Yes** to confirm the deletion.
 * To modify a row's details
   1. In the **Row Details** grid, select the required row.
   2. Make the required changes.

10. In the Column Details area, modify the column details for the required rows: * To add details of a new column, see Step 9 of To create a new template. * To delete the details of a column: 1. Select the required column row. 2. On the grid toolbar, click Delete (). The message “Preparing to delete this information. Are you sure?” is displayed.

   3. Click **Yes** to confirm the deletion.
 * To modify the details of a column:
   1. Select the required column row.
   2. Make the necessary modifications.

11. On the Active Form ribbon, click Save () to save the template.

|