Show TOC

Object documentationManage Previous External Reconciliations Window Locate this document in the navigation structure

 

This window lists the external reconciliations that match the selection criteria you specified in the Manage Previous External Reconciliations - Selection Criteria window.

To open the window, choose   Banking   Bank Statements and External Reconciliations   Manage Previous External Reconciliations  .

This window contains three tables:

  • The upper table contains previous reconciliations.

  • The left-lower table lists the transactions in books associated with the reconciliation selected in the upper table.

  • The lower-right table lists the external statements associated with the reconciliation selected in the upper table.

Note Note

This topic documents fields and other elements in this window that either are not self-explanatory or require additional information.

End of the note.
Upper Table Fields
G/L Acc./BP Code

Displays the code of the G/L account or business partner for which the reconciliation was performed.

Recon. No.

Sequential reconciliation number assigned to the external reconciliation by SAP Business One when the reconciliation took place. Each business partner or G/L account has the same sequence of reconciliation numbers, starting from 1.

Recon. Amount

Total amount of the reconciliation.

Recon. Type

Type of reconciliation:

  • Manual

    Reconciliation was performed in one of four ways: performed manually, performed in the Reconciliation Bank Statement window (see Manually Reconciling Bank Statements: AU, BR, CA, CN, CY, GB, IN), performed in the Process External Bank Statement window (see Automatically Creating Incoming Payments to Reconcile Bank State), or performed by selecting the Manual radio button in the External Reconciliation - Selection Criteria window (see Manually Performing External Reconciliations).

  • By Total

    Reconciliation was performed in one of two ways: by selecting the Automatic radio button in the External Reconciliation - Selection Criteria window without considering any other factors or by selecting the Semi-Automatic radio button in the External Reconciliation - Selection Criteria window and considering only the Amount parameter.

  • Due Date, Posting Date

    Reconciliation was performed by selecting either the Automatic or the Semi-Automatic radio button in the External Reconciliation - Selection Criteria window and considering either the due date or the posting date of the transactions.

  • Ref. 1, Ref. 2, Ref. 3

    Reconciliation was performed by selecting either the Automatic or the Semi-Automatic radio button in the External Reconciliation - Selection Criteria window and considering reference 1, 2, or 3 of the transactions.

In addition, the value in the Recon. Type field can be a combination of the due date or posting date and the reference number.

Example Example

If you decide to consider Due Date and Ref. 3 in the selection criteria for the reconciliation, the value in the Recon. Type field is Ref. 3 + Due Date.

End of the example.
Reconciliation Date

Date on which the reconciliation was performed. However, if you perform external reconciliation using bank statement processing, the field displays the due date from the bank statement line.

Creation Date

Date on which the reconciliation was performed.

Lower Table Fields
Display Data for G/L Account/BP

Specify whether to display all the reconciliations in the defined range, or reconciliations performed for a specific G/L account or business partner.

Trans. No or Row

In the lower-left table: displays the journal entry number of the transaction involved in the selected reconciliation.

In the lower-right table: displays the row number of the transaction involved in the selected reconciliation in the Process External Bank Statement window.

Due Date

Due date of the transaction involved in the selected reconciliation.

Ref. 1

In the lower-left table: displays the reference number as it appears in the Ref. 1 field for the transaction in the Journal Entry window.

In the lower-right table: displays the reference number as it appears in the Reference field for the transaction in the Process External Bank Statement window.

Amount

Original amount posted in the specific row of the transaction involved in the selected reconciliation.