SAP Knowledge Base Article - Public

1873738 - How to Reverse Migrated Outgoing Checks

Symptom

You have migrated Outgoing Checks to the system, however these documents are no longer required. You now wish to reverse the Outgoing Checks.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Liquidity Management work center.
  2. Go to Payment Monitor view.
  3. Select the migrated check.

You will 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:

  1. Go to Liquidity Management work center.
  2. Go to Payment Monitor view.
  3. Select the relevant check.
  4. Under the Details: Outgoing Check section, click the Journal Entry ID, in the Accounting Data sub-section.
  5. On the screen that opens, click You can also button.
  6. Click View Business Transaction for Accounting.
  7. On the screen that opens, click View All button.
  8. 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.

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

Product

SAP Business ByDesign all versions