Tips on How to Reverse All Payment Documents Generated by a Payment Run

  • by Koen Van Langeraert, Freelance SAP FI/CO Consultant
  • March 1, 2016
Learn how to reverse a payment run in one shot with a program that SAP recently released.
Learning Objectives

After reading this article, you’ll know how to:

  • Mass reverse your payment run
  • Overcome the prerequisite for the mass reverse
Key Concept

The RFF110S_REVERSE program was introduced via SAP Note 2125220 - F110: Cancel payment run. It was first released in February 2015.Although it is not assigned to a specific transaction code, you can use transaction codes SA38 or SE38 to execute the program.

Once in a while you need to reverse the payment documents generated by a payment run (transaction code F110). The need to reverse a payment run may be the result of many circumstances. You may have entered the wrong posting date. You may have put the due date too far in the future so that you are paying more than is needed. You may have realized that you took the wrong house bank, and there is not enough money in your bank account. You may have used the wrong customizing settings.

Note
In theory, you can maintain the available amounts before you run the proposal, but in my experience, most users don’t even know they can do that, and the ones that do know frequently forget to complete this step.

Also, when you are testing your configuration in a development environment, you need outstanding invoices to be able to make a payment run. After these invoices are paid, you can’t use them anymore to do another test. Either you create new invoices or you reverse the payment documents.

Reversing one payment or a few documents is not a problem. However, a real payment run can easily have hundreds of payment documents.

This is how you normally cancel such a document. To find the payment documents of your payment run, execute transaction code F110 and follow menu path Menu > Edit > Payment > Payment list (or Ctrl + F3).

To cancel a payment document, you usually execute transaction code FBRA (Reset cleared items). You can also follow menu path Accounting > Financial Accounting > Accounts Payable > Document. In the screen that appears (Figure 1), enter the document number in the Clearing Document field, a code in the Company Code field, and a year in the Fiscal Year field. Click the save icon to save your data.


Figure 1
The initial screen to reset cleared items

The system then displays a pop-up screen that asks you if you just want to reset the clearing or reverse the posting. Typically, you want to choose the second option, so you click the Resetting and reversing button shown in Figure 1. The system displays another pop-up (Figure 2) asking for the reversal reason and the posting date that you can enter in case you don’t want to use the same one as the payment document. Click the enter icon (the green check mark) after you enter a value in the Reversal Reason field (e.g., 01 - Reversal in current period).


Figure 2
A pop-up screen with a reversal data

This process for reversing a payment document is sufficient, but it is not very user friendly if you have many documents to cancel.

I often had to create Legacy System Migration Workbench (LSMW) or a little program so that this can be performed en masse. You use a little file that has all the documents you want to reverse and then undo the clearing as explained above.

As a regular user, you might not even have the authorization to use these kind of tools, so you need to log a ticket with your support team. This makes the process time-consuming. To address these issues, SAP recently created a new program that can reverse all the payment documents of one payment run in one shot.

To use the program, you need to complete two steps:

  1. Install the RFF110S_REVERSE program
  2. Run the RFF110S_REVERSE program

Koen Van Langeraert

Koen Van Langeraert has been working 20 years as an SAP FI/CO consultant. He started his career in Deloitte Belgium. Since 2008 he has been working as a freelance consultant. He has done projects in many European countries and industries.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.