Show TOC

Object documentationBank Statement Row - Details Expanded Window Locate this document in the navigation structure

 

Use this window to perform manual reconciliation on a selected bank statement row. The fields displayed vary according to the following types of posting methods:

  • Business Partner from/to Bank Account

  • G/L Account from/to Bank Account

  • Bank Interim Account from/to Bank Account or External Reconciliation

To open this window, from the SAP Business One Main Menu, choose   Banking   Bank Statements and External Reconciliations   Bank Statement Processing   Bank Statement Summary   Bank Statement Details  . In the table in the Bank Statement Details window, double-click a row number. SAP Business One automatically proposes transactions in this window.

For bank statement row whose posting method is Business Partner from/to Bank Account, to add open marketing documents to this window, choose the Add Open Documents button. For more information, see Add Open Documents Window.

For bank statement row whose posting method is Business Partner from/to Bank Account, to add open journal entries that are business partner related to this window, choose the Add Open BP JEs button. For more information, see Add Open BP Journal Entries Window.

For bank statement row whose posting method is Business Partner from/to Bank Account, to create journal entries for manual reconciliation, choose the Create New JEs button. After you enter and post the new journal entry, the new data is copied to this window. For more information, see Journal Entry Window.

Note Note

If you create a journal entry with a posting date later than the posting date of the bank statement row in the Bank Statement Details window, this journal entry will not appear in the Bank Statement Row Details - Expanded window. To display the journal entry, make sure that its posting date is earlier than or the same as the posting date of the bank statement row. If the Posting Date field of the bank statement row is empty, make sure that the posting date of the journal entry is earlier than or the same as the current system date.

End of the note.

For a bank statement row with a posting method of Bank Interim Account from/to Bank Account or External Reconciliation, to add open transactions, choose the Add Open Transactions button. For more information, see Add Open Transactions Window.

General Area
Bank Row Amt

Amount for the specific bank statement transaction row.

Applied Amt

Amount of the specific document or transaction proposed for posting.

Balance

Calculated difference between the Bank Row Amt and Applied Amt fields for the payment currency and for the local currency.

This field is updated every time the value in the Applied Amt field is changed.

Details

Displays the same details as the Details field in the Bank Statement Details window.

Details2

Displays the same details as the Details2 field in the Bank Statement Details window.

Ref.

Displays the same details as the Reference field in the Bank Statement Details window.

Operation Code

Displays the same details as the Internal Code field in the Bank Statement Details window.

Rate

Displays the same details as the Exchange Rate field in the Bank Statement Details window.

Row Date

Displays the same details as the Row Date field in the Bank Statement Details window.

BP Code

Displays the same details as the BP Code field in the Bank Statement Details window.

BP Name

Displays the same details as the BP Name field in the Bank Statement Details window.

Row Details
Selected

Indicates whether the specific document or transaction is proposed for posting.

BP Code

Code of the business partner for the specific document or transaction.

BP Name

Name of the business partner corresponding to specified business partner code. Value of the Name field in the original document header.

Default Cash Discount %

The percentage of discount in the Discount % field in the original document or transaction.

Original Amt - Payment Currency

Value of the Total Before Discount field in the original document or transaction in the payment currency.

Balance Due - Payment Currency

Value of the Balance Due field in the original document or transaction in the payment currency.

Discount Amt - Payment Currency

The amount shown in the field on the right in the Discount % field in the original document/transaction in the payment currency.

Applied Amt - Payment Currency

Value in the Total field in the original document/transaction in the payment currency.

Note Note

For one or more proposals within one uncleared bank statement row, you can choose Ctrl+B to display the following:

  • When the balance due of the bank statement row is larger than the balance due of the proposed transaction minus the discount amount, this field displays the balance due of the proposed transaction minus the discount amount.

  • When the balance due of the bank statement row is smaller than the balance due of the proposed transaction minus the discount amount, this field displays the balance due of the bank statement row.

This works also in All currency situations.

End of the note.
Original Amt - Local Currency

Value of the Total Before Discount field in the original document/transaction in the local currency.

Balance Due – Local Currency

Value of the Balance Due field in the original document/transaction in the local currency.

Discount Amt – Local Currency

The amount shown in the field on the right in the Discount % field in the original document/transaction in the local currency.

Applied Amt – Local Currency

Value of the Total field in the original document/transaction in the local currency.

Ref. 1

Value in the Ref 1 field of the journal entry associated with the proposed transaction.

Ref. 2

Value in the Ref 2 field of the journal entry associated with the proposed transaction.

Ref. 3

Value in the Ref 3 field of the journal entry associated with the proposed transaction.

BP Reference No.

Value in the BP Reference No. field in the original document as follows:

  • A/R Documents (except payments): Customer Reference No. field

  • A/P Documents (except payments): Vendor Reference No. field

  • A/R and A/P Incoming/Outgoing Payments: Reference field (from payment header

Posting Date

Value in the Posting Date field of the journal entry associated with the proposed transaction.

Due Date

Value in the Due Date field of the journal entry associated with the proposed transaction.

Document Date

Value in the Document Date field of the journal entry associated with the proposed transaction.