Calculation Details Dialog Box

You can use calculations to produce control total information, such as entry or addenda counts, entry hash totals, total debit entry dollar amount, total credit entry dollar amount, and batch number for text files that are created for payments.

On the Calculation Details dialog box, enter the line type and field number that you want to sum or count in a text file.

Location

To display the dialog box, complete the following steps:

  1. From the Vision Navigation menu, click Configuration > Accounting > Banks.
  2. Click the User Defined File Format tab of the Bank Codes form. This tab is enabled only if you select User Defined in the Export to Text Format field on the Bank Codes tab of the Bank Codes form.
  3. In the Data Mapping field on the Employee or Vendor grid, select Calculation.
  4. In the Employee or Vendor grid, click in the Calculation field, and then click in the field.

Contents

Field Description
Sum Select this option to add together the values of a specific field in each record in a text file to provide a total in a text file. For example, you could sum the payment amounts to get a total monetary amount for the payment run.
Count Select this option to count fields to provide a total count in a text file.
Line Type From the drop-down list, select the line type of the field in the text file that you want to sum or count.
Field No From the drop-down list, select the field number of the field that you want to sum or count. The field numbers that display in the list are based on the line type that you enter in the Line Type field in this dialog box.