Reviewing Bank Statement Files

This topic discusses how to review bank statement files.

Page Name

Definition Name

Usage

Review Bank Statement Files Page

BSP_FILE_INQUIRY

Review summary and detail information about the import status of bank files.

View Bank Statement File Log Page

BSP_FILE_INFO

View summary information of system events that were logged for a specific bank statement file.

See the Review Bank Statement Files Page for more information.

View Bank Statement File Page

BSP_FILEDATA_SP

View the bank statement file that is transmitted from the bank.

See the Review Bank Statement Files Page for more information.

Use the Review Bank Statement Files page (BSP_FILE_INQUIRY) to review summary and detail information about the import status of bank files.

Navigation:

Banking > Bank Statements > Review Bank Statement Files

This example illustrates the fields and controls on the Review Bank Statement Files page. You can find definitions for the fields and controls later on this page.

 Review Bank Statement Files page

The Review Bank Statement Files page enables you to review the imported bank statement files. You can see whether the system successfully loads a file. And if a file does not load successfully, use the View Bank Statement File Log page to determine exactly where the system encounters a file loading error.

Important! Any user with access to these pages can view the file details. Restrict user access by using PeopleTools Security functionality.

See the product documentation for PeopleTools: Security Administration.

Enter search parameters on the Review Bank Statement Files page and click the Search button.

Field or Control

Description

File Status

Options are:

  • Error: Appears if the file is not successfully loaded. A red square also appears next to the file name. You must correct the error and then reimport the file.

  • Formatting: Appears if the system is still transforming the file to a PeopleSoft-readable layout.

  • Reading: Appears if the system is still reading the file data before loading the data to the staging tables.

  • Staged: Appears if the system has loaded the transformed data to the staging tables. A green circle also appears next to the file name.

  • Warning: Appears if the file is loaded with errors. A yellow, inverted triangle also appears next to the file name.

View File

Click to access the View Bank Statement File page, where you can review bank statement file transmittal information.

View Event Log

Click to access the View Bank Statement File Log page, where you can review event log information for a bank statement file.