Symptom
One bank statement is required for Postprocessing, and it has the same items with another bank statement which has already been posted and allocated.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Liquidity Management work center, and select the Bank Statements view.
- Select the bank statement in question, and you can see that the value for Postprocessing is shown as Required.
Cause
The reason for the duplicate bank statement is that you first create and post a bank statement, and directly afterwards create the next bank statement. As the payment allocation run has not finished yet, and therefore the items of the first bank statement are not allocated yet, which are still selectable in the second step of the guided activity for creating bank statements.
Resolution
To fix the issue, you have the following options:
- To reverse the bank statement in question, but if there is at least one bank statement with a later date that has been already posted or uploaded and ready to be posted manually, you should reverse all the follow-up bank statements for the same bank account starting from the latest one.
- The other option is to work on the payment allocations of bank statement in question, marking all the allocations as Returns, and posting the returns in new bank statement.
- Go to the Liquidity Management work center, and choose the Bank Statements view.
- View the bank statement in question.
- For each item, choose Required link under Postprocessing.
- In the upcoming Payment Allocation, choose View All.
- In the new screen, set the Return Reason as 9- Correction of duplicate entry, and then choose Mark As Return under Actions.
- Repeat the above steps for all items of the bank statement in question.
- After that, create a new manual bank statement on the same bank account.
- In the step Selected Items, you find for each outgoing check an entry with Payment Method being Incoming Return of an Outgoing Payment, select all these items.
- For the incoming checks or incoming bank transfers, go directly to bank statement step Create and Edit Items, for each incoming check or bank transfer, create an item with payment method Outgoing Return of an Incoming Payment and debit the amount of the incoming check/bank transfer.
- Then press Required link in the Postprocessing column.
- In the upcoming Payment Allocation screen, under the Payment Assignment tab, select the bank transfer/incoming check in the lower table, and press the Arrow Up button to add the item to the bank statement.
- After that, choose Save and Return.
- Post the bank statement.
Keywords
bank statement; duplicate; duplicated; reverse bank statement , KBA , mark as return , duplicate bank statement , AP-PAY , Payment Processing , How To