Statement Import Summary

 

The Statement Import Summary allows a user to confirm and adjust batch settings for the import including the batch description, cash/clearing account, and batch date. These can be set through Statement Detail as well.

 

Additionally, errors found during the statement file translation are listed within the Problem Encountered During Import data grid, from which a user can select individual records and perform the following functions to each listed problem:

    Associate an item to a correct Order Number using the Associate Order function

    Update the Payment Code of the batch through the Set Payment function

    Set the option to create a charge to the vendor on the corresponding transaction

 

Figure 6: Statement Import Summary screen

 

The following table describes the fields and functions available within this screen.

 

Note: The data listed in the order in which appears in the statement import file.

 

Field/Function

Description

Branch

 

The branch associated to the import record displays in this field.

Division

The division associated to the import record displays in this field.

Statement Amount

The total dollar amount originally associated to the batch displays in this field.  Users can update this value through Statement Detail.

Description

Enter the name set as the description for the batch record (up to 128 characters).

Users can update this value through Statement Detail, as well.

Cash/Clearing Account

Select a master general ledger account form the list defined within Payment Management Posting Account Setup to generate accounting entries under for the batch. 

Users can update this value through Statement Detail.

Wire/Journal Date

Enter the date of fund deposit or transmittal.

This value can also be set using Statement Detail.

Number Of Items

Displays the total number of records included in the statement import file.

Problems Encountered During Import

Accounting Notes

Set and view the Accounting Note associated to the selected error record. Notes added here will be visible within the Detail Processing tab.

Order/Control

The Order Number or GL control number of a vendor displays in this column.

Description/Shipper

The text description of the transaction or the shipper name appears in this column.

Transaction Date

Displays the date that the selected transaction took place on.

Payment Code

The Payment Code determines how the selected item is applied within the Payment Application screen. Payment Code is set to a value defined within in Statement Payment Code Setup.

You can update this value through the Select Payment Code screen.

Amount

The dollar amount associated to the selected transaction.

Problem

Displays the text of the error encountered during the import process.

Associate Order

Opens the Find and allows the user to select an order using order, customer, and/or store information.  Use this function to correct an invalid Order Number item.

The Order/Control and Description/Shipper fields will update to reflect the selected order.

Set Payment Type

This function opens the Select Payment Code screen allowing a user to modify the payment code for the selected transaction. The Payment Code determines how the item is applied within the Payment Application screen.

 

Charge Matching Vendor (for payables and claims)

This option, when set, instructs the application to verify transactions associated to the vendor linked to the driver through the Accounting tab within Personnel Setup along with the driver. When this option is not set, the application only verifies transactions associated to the driver.

 

Note: This option is ignored when the Auto Apply to existing and matching AP documents option is set for the Import Auto Apply Options.

 

Auto Apply Options

If the Auto Apply option is set within the import file (see Generic Import File Format) or if the Import Auto Apply Options are in effect, this option is available allowing you to modify the Import Auto Apply Options for this particular import.

Done

Instructs the application to verify and save changes made to the statement import.

Cancel

This function halts the import process and discards all changes made to the statement.

 

RELEATED TOPIC:

Statement Import Summary (Generic Import)