Hello
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
Regards
Hector
1 Answer
-
Best AnswerPosted 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 SupportAdd a comment
Add a comment