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
. 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
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.
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.
Amount for the specific bank statement transaction row. |
Amount of the specific document or transaction proposed for posting. |
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. |
Displays the same details as the Details field in the Bank Statement Details window. |
Displays the same details as the Details2 field in the Bank Statement Details window. |
Displays the same details as the Reference field in the Bank Statement Details window. |
Displays the same details as the Internal Code field in the Bank Statement Details window. |
Displays the same details as the Exchange Rate field in the Bank Statement Details window. |
Displays the same details as the Row Date field in the Bank Statement Details window. |
Displays the same details as the BP Code field in the Bank Statement Details window. |
Displays the same details as the BP Name field in the Bank Statement Details window. |
Indicates whether the specific document or transaction is proposed for posting. |
Code of the business partner for the specific document or transaction. |
Name of the business partner corresponding to specified business partner code. Value of the Name field in the original document header. |
The percentage of discount in the Discount % field in the original document or transaction. |
Value of the Total Before Discount field in the original document or transaction in the payment currency. |
Value of the Balance Due field in the original document or transaction in the payment currency. |
The amount shown in the field on the right in the Discount % field in the original document/transaction in the payment currency. |
Value in the Total field in the original document/transaction in the payment currency. Note For one or more proposals within one uncleared bank statement row, you can choose Ctrl+B to display the following:
This works also in multi-currency situations. End of the note. |
Value of the Total Before Discount field in the original document/transaction in the local currency. |
Value of the Balance Due field in the original document/transaction in the local currency. |
The amount shown in the field on the right in the Discount % field in the original document/transaction in the local currency. |
Value of the Total field in the original document/transaction in the local currency. |
Value in the Ref 1 field of the journal entry associated with the proposed transaction. |
Value in the Ref 2 field of the journal entry associated with the proposed transaction. |
Value in the Ref 3 field of the journal entry associated with the proposed transaction. |
Value in the BP Reference No. field in the original document as follows:
|
Value in the Posting Date field of the journal entry associated with the proposed transaction. |
Value in the Due Date field of the journal entry associated with the proposed transaction. |
Value in the Document Date field of the journal entry associated with the proposed transaction. |