MPI_5403 Bank Import Transactions Report

This topic contains specific information about the MPI_5403 Bank Import Transactions report. It includes explanations about the Report Properties dialog pertaining to this report.

For more information, see The Report Properties Dialog.

Overview

The Bank Import Transactions report is a companion report to the MPI_5402 Bank Import Details Report. It provides details of all of the transactions included in the bank file import.

To run this report, you must know the bank file ID, which you can find on the MPI_5402 Bank Import Details Report.

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 usually 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.

However, this report does not use date ranges.

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:

  • SBankFileImport
  • SBankFileImportDetails

Subtotals/Breaks

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

Figure 2-465: Subtotals/Breaks page

The default Sort Order is BankAccount. Available sorts include:

  • Bank Account
  • State

This report has no categories in the Groups column.

This report allows four categories in the Sorts column. If you select Custom Sort Order , the sorts in Available Sorts are available:

Table 2-444: Available Sorts

Bank Account

Transaction Type

Company

Amount

Check Number

Record Type

As Of Date

Check Type

State

Additional Formulas

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

Figure 2-466: Additional Formulas page

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

Table 2-445: Additional Formulas
Formula Description
Bank File ID

Enter the bank import file identifier of the file you wish to review.

You must surround by the ID with braces; for example:

  • {323FBB77-30EC-49E1-9559-FC5EB9D7D560}
Item Identifier

Enter the GUID (record ID) of the transaction you wish to see.

An example of a GUID is shown above in the Bank File ID explanation.
Incomplete Only If you put a check in this check box, the report includes only those transactions that have not been completed.