Skip to Content

Deleting line from External Bank Statement


I am trying to delete or close a line from a External Bank Statement

The issue is that there are reconciled lines after that. Is there a way to remove/ cancel line 4 ? When I left click delete line that next message appears

The productive DB has a lot more reconciled lines . What should i do if I need to remove that line without affecting the General Ledger



01.png (8.8 kB)
02.jpg (16.3 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jul 29, 2020 at 08:19 PM

    Hello Hector,

    Firstly, please check SAP Note 2385781 fixed in 9.2 PL07 to rule it out if you use that version.
    If not, please see the below:

    The Process External Bank Reconciliation only allows such deletions that are after the last record that has a reconciled number. When trying to delete anything above the last reconciliation in the line you will receive the message: Reconciled rows found; delete before adding/removing rows. The system by definition does not allow deleting the rows before the last reconciliation in the Process External Bank Reconciliation window. That is, deleting and adding row in Process External Bank Statement grid is allowed if the actual row (the row to be deleted) is the last row or followed by unreconciled payments (without Reconciliation No. in "Reconciled" column).

    In order to remove those kinds of rows, you will need to open the reconciliations made after this row via Manage Previous External Reconciliations functionality. After removing the needed rows you can reconcile them again. There is no other way to remove the rows from the system.

    Alternatively, you may as well consider external reconciliation of the legacy lines or adding reversal lines with an opposite sign to balance the lines to be "removed" out. However, this should be decided and tested by the customer's accountant.

    Hope this helps.

    Kind regards,
    David Andrusko
    SAP Business One Support

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.