Symptom
Some Outgoing Checks have been migrated into the system. However these documents are no longer required. Thus wish to reverse these migrated Outgoing Checks.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Liquidity Management work center.
- Go to Payment Monitor view.
- Select the migrated check.
Can see that it is not possible to Reverse the selected Outgoing Check by the standard procedure.
Cause
It is not possible to directly Reverse a migrated Outgoing Check since there is no source document, as it is a data migration posting.
Resolution
There are two approaches which can be applied in order to reverse the migrated outgoing checks.
Option 1 - Cancelation of the migrated checks via Journal Entry:
- Go to Liquidity Management work center.
- Go to Payment Monitor view.
- Select the relevant check.
- Under the Details: Outgoing Check section, click the Journal Entry ID, in the Accounting Data sub-section.
- On the screen that opens, click You can also button.
- Click View Business Transaction for Accounting.
- On the screen that opens, click View All button.
- Click Reverse button.
In this case, the posting date of the reversal will be the same as the one of the migration posting, unless SAP perform the changes via backend. This correction, in general, would only be valid during the migration period. Note that the backend changes are subject to further SAP evaluation and may not be a feasible approach.
The reversal posting will post on the same G/L Accounts as the original migration posting. So there will be a balance on the migration account, which has to be handled via a manual posting, e.g. Journal Entry Voucher, on a profit account.
Note: System will check the initial Migration Date that should be in an unblocked status even if the posting date is in a current opened period. Otherwise system might dump.
Option 2 - Confirmation of the migrated checks and posting the amount on a profit account:
In one of the next Bank Statements, for the concerned Bank Account, you should insert two bank statements items with Payment Method as Other incoming payment and Other outgoing payment. The amount of the bank statement items is the sum of the open migrated Outgoing Checks to be Confirmed. The bank statement opening and closing balances are not concerned by this. After posting the Bank Statement, two In Preparation payment allocations for the bank statement items will be created. On the one of the debit line, the checks are selected under the Payment Assignment tab, and the one of the credit line is posted via Allocation to G/L Account tab to a profit account.
This second approach does not require backend changes and it also can be done using system's standard transactions.
Keywords
Migration; Outgoing Checks; Journal Entry; Migration Date; reverse; migrated payments; greyed out; grayed out , KBA , AP-PAY , Payment Processing , How To