MPI_6101 Simple Bank Export

This topic contains specific information about the MPI_6101 Simple Bank Export report. It includes explanations about the Report Properties dialog pertaining to this report.

For more information, see The Report Properties Dialog.

Overview

This report creates files that can be sent to a bank for use in a Positive Pay program. It is typically used with service bureau accounts.

Positive Pay programs prevent attempted check fraud. The banks compare check numbers received by the bank to those received in these files; if check has a check number that does not match, it may be fraudulent.

The format of Positive Pay files vary from bank to bank.

In this report, you can include up to ten fields in the export files. Each field can be formatted and sequenced according to the bank’s specifications.

Important: The Simple Bank Export does not support login, header, or footer records. If they are required by the bank, you need to add them to the file after it is created.

Date Selection

In the Report Properties dialog, click on the Date Selection tab. The system displays the Date Selection page.

As explained in Date Selection, you can use Override Dates  to select specific check date/process number combinations. Millennium® actually bases each report on one or the other: the date or the process number.

This report is based on the process number.

This report uses service bureau-style default date ranges, which are:

  • Today
  • Yesterday
  • This Week
  • Last Week
  • Override Dates
  • Current Month
  • Previous Month
  • Current Quarter
  • Previous Quarter

Data Selection

In the Report Properties dialog, click on the Data Selection tab. The system displays the Data Selection page.

As explained in Data Selection, you can use this page to include company filters to narrow down the selected data for this report. If you want to create a filter, design it to access the following database tables:

  • CCalendar
  • CInfo

Subtotals/Breaks

In the Report Properties dialog, click on the Subtotals/Breaks tab. The system displays the Subtotals/Breaks page:

Figure 2-505: Subtotals/Breaks page

The report has no default Sort Order and no ability to do custom groups or sorts.

Additional Formulas

In the Report Properties dialog, click on the Additional Formulas tab. The system displays the Additional Formulas page:

Figure 2-506: Additional Formulas page

For more information about using additional formulas, see Additional Formulas. Each additional formula for this report is explained below:

Account ID

Enter the code or identifier for the bank account. It must match the account ID set up in Millennium® exactly.

File Type

Use this drop-down list to select the format of the output file that will be created. The valid entries include:

  • Fixed
  • CSV
Field 01 – Field 10

Use this drop-down list to select one of the options below or enter alphanumeric characters directly. The valid drop-down entries include:

Table 2-449:  Available formula values for Field 01 through Field 10

Check Number

Pay to Name

Filler

Account Number

Pay to Address1

Additional 1

Check Date

Pay to Address2

Additional 2

Void Indicator

Pay to City

Additional 3

Check Type

Pay to State

Additional 4

Check Amount

Pay to Zip

 

The Field nn Format, Additional Data n, Outstanding Char, and Void Char fields all work in conjunction with the values you enter in the Field nn drop-down lists.

Field 01 Format – Field 10 Format

Enter text that represents the format code that determines the format of the corresponding fields Field 01 through Field 10.

If you typed alphanumeric characters directly into the corresponding Field, you must enter either TEXT or a format (see below).

Formatting for each field depends on the type of field you choose:

  • Number — Enter the formula value in the 9(nn) format, where nn is replaced by the number of columns for the numeric field.

For example, if the file specification calls for a ten-digit check number, you would enter 9(10).

  • Amount — Enter the formula value in the 9(nn)V99 or 9(nn).99 format, where nn is replaced by the number of positions to the left of the decimal.

If the decimal place is implied, use the 9(nn)V99 format.

If the field requires a decimal place, use the 9(nn).99 format.

  • Date — Enter the formula that represents the date format required by the file specification:
Table 2-450: Date format
Desired Data Format Formula Value (what you enter)

2-digit Year month day [no slashes]

DATE - yyMMdd

4-digit Year month day [no slashes]

DATE - yyyyMMdd

4-digit Year month day [with slashes]

DATE - yyyy/MM/dd

Month Day 2-digit Year [no slashes]

DATE - MMddyy
  • Filler — Enter the formula value in the X(nn) format, where nn represents the number of spaces you require, to:
  • Create blank spaces.
  • Format text strings (as defined in the Additional Data n fields).

Examples of what you might enter for these fields are shown in Figure 2-507:

Figure 2-507: Examples of Field xx Format formula values

Additional Data 1 – Additional Data 4

Enter the value that will be displayed for the associated Field 01 through Field 10 field.

The purpose of these fields is to define constants in the export file. Some bank specifications require that each record contain the same value in a certain position or column.

The data you enter in these fields is displayed in the file if you have selected Additional1 (2, 3, or 4) in any of the Field 01 through Field 10 drop-down lists.

For example, a specification for one of your banks requires that positions 1–12 of each record contain the following: BankPosPay.

In the Formula Value column for Additional Data 1, you type BankPosPay.

In the Formula Value column for Field 01, you select Additional1 from the drop-down list.

In the Formula Value column for Field 01 Format, you type x(12).

Add Quotes to Text

If you put a check in this check box, all text fields will be surrounded with quotes.

Text Justification

Use this drop-down list to select the text justification for all text fields. The valid entries include:

  • Left
  • Right

Note: The system activates the Outstanding Char and Void Char additional formulas—and includes them on the report—only if you select VoidIndicator for one of the Field 01 through Field 10 formulas.

Outstanding Char

Enter the character that flags a record as an outstanding check (not yet cashed). The system default is O, but you can change the value according to the bank’s requirements.

If the bank requires that only voided checks be indicated, this field should be blank.

Void Char

Enter the character that flags a record as a voided check. The system default is V, but you can change the value according to the bank’s requirements.

Show Void as Positive

If you put a check in this check box, voided transaction amounts will be displayed as a positive number only.

Include Third Party Sick Pay

If you put a check in this check box, third-party sick pay checks will be added to the report.

Name Style

Use this drop-down list to select how employee names are presented in the report. The valid entries include:

  • LastFirst
  • FirstLast
Show Header Record

If you put a check in this check box, the report displays the header record.

Header Record Field 01 – Header Record Field 08

Use this drop-down list to select one of the options below or enter alphanumeric characters directly. The valid drop-down entries include:

  • Check Date—A single check date.
  • Creation Date—The date on which the export was run.
  • Creation Time—The time at which the export was run.
  • Filler—Enter the formula value in the X(nn) format, where nn represents the number of spaces you require, to:
  • Create blank spaces
  • Format text strings (as defined in the Additional Data n fields)
Header Record Field 01 Format – Header Record Field 08 Format

These are similar to the Field 01 Format – Field 10 Format formulas described above.

Show Column Header

If you put a check in this check box, the report displays column headers.

Show Trailer

If you put a check in this check box, the report displays the trailer record.

Trailer Field 01 – Trailer Field 08

Use this drop-down list to select one of the options below or enter alphanumeric characters directly. The valid entries include:

  • BLANK
  • Check Date—A single check date.
  • Check Amount—The sum of all the check amounts in the export.
  • Creation Date—The date on which the export was run.
  • Record Count—The number of export records, excluding the header and/or trailer record.
Trailer Field 01 Format – Trailer Field 08 Format

These are similar to the Field 01 Format – Field 10 Format formulas described above.

Note: Messaging has been added to help the user with cases in which there is no data.