Skip to Content
Technical Articles
Author's profile photo Ratul Chakraborty2

Positive Pay file creation using Payment Medium Workbench(PMW) and Automatic Payment Program(F110)

This document has been prepared purely based on my analysis I did recently on Automatic Payment Program. We all are here to learn, continuously, to become better consultants. Any suggestion and critics are always welcome as this helps all of us to improve. So, let’s get started.

In this blog, we will discuss on how to create positive pay files for any bank using PMW (Payment Medium Workbench). Positive Pay is an automated fraud detection tool offered by the Cash Management Department of most banks. In its simplest form, it is a service that matches the account number, check number and dollar amount of each check presented for payment against a list of checks previously authorized and issued by the company. It is clear that registration of Check and the check numbers are mandatory for any positive pay file.

Configuration: Payment Method & Bank Selection for Payment Program

We will use the payment medium format US_POSIPAY for this demo. At the very beginning we must complete the Payment Method/Bank Selection configuration for Payment program (Transaction: FBZP)

Step 1: Set all company codes for Payment Transactions

SPRO > Financial Accounting > Accounts Receivable and Accounts Payable > Business Transactions > Outgoing Payments > Automatic Outgoing Payments > Payment Method/Bank Selection for payment program > Set all company codes for payment transactions

 

Step 2: Set up paying company code for payment transaction

SPRO > Financial Accounting > Accounts Receivable and Accounts Payable > Business Transactions > Outgoing Payments > Automatic Outgoing Payments > Payment Method/Bank Selection for payment program > Set up Paying company codes for payment transactions

 

Step 3: Set up payment methods per country

SPRO > Financial Accounting > Accounts Receivable and Accounts Payable > Business Transactions > Outgoing Payments > Automatic Outgoing Payments > Payment Method/Bank Selection for payment program > Set up Payment methods per country for payment transactions

Here, choose “Use payment medium workbench” and put US_POSIPAY in the payment medium format.

 

Step 4: PMW configuration

  • Click on “Format settings” after entering the required format and in the next screen tick the check box “Use of DME mapping engine”. This indicator determines whether the DME engine is used. If this indicator is set, the event modules of the DME mapping engine are used.

 

DME Engine will take us to the transaction DMEE, where we can customize the format as per the Bank’s requirement. The DME Engine gives you a lot of flexibility to construct your own file or amend SAP standard. There is very little need to use ABAP coding when using DMEE, however there is still a possibility to use Functional Modules to calculate the value of certain DMEE tree nodes.

 

  • Click on “Standard settings” to maintain the format specific attributes

 

 

  • Click on “Format in Company code” and assign the format US_POSIPAY to Company code, Payment Method & House Bank

 

 

  • Here we are using an SAP provided format: US_POSIPAY. A new format can be created using the transaction OBPM1. Then, the variant must be created for the report SAPFPAYM in transaction OBPM4 for US_POSIPAY

 

 

 

Step 5: Set up payment methods per company code for payment transactions

You can use transaction code FBZP or below path;

SPRO > Financial Accounting > Accounts Receivable and Accounts Payable > Business Transactions > Outgoing Payments > Automatic Outgoing Payments > Payment Method/Bank Selection for payment program > Set up payment methods per company code for payment transactions

 

Step 6: Set up bank determination for payment transactions

Transaction code FBZP can be use or below path;

SPRO > Financial Accounting > Accounts Receivable and Accounts Payable > Business Transactions > Outgoing Payments > Automatic Outgoing Payments > Payment Method/Bank Selection for payment program > Set up bank determination for payment transactions

We will assume that we already know the Bank Configuration required for Automatic Payment Program.

 

Step 7: Check lot creation and assignment with House Bank and Account ID

SPRO > IMG > Financial Accounting> Accounts Receivable & Accounts Payable > Business transactions > Outgoing payments > Automatic outgoing payment > Payment media > check management > define number ranges for checks

Transaction: FCHI

 

 

 

Illustration – APP process:

  • Check for the Vendor invoices that are still open – Transaction FBL1N

 

  • Go to transaction F110 & put the parameters as mentioned below

 

 

 

To create the positive pay file, we can choose either of the following 2 options:

  1. Put the file path & name while creating the Variant for the program SAPFPAYM or
  2. Put the Check extract creation program name RFCHKE00 (Transaction – FCHX) and the variant as TEST_POSIPAY

 

 

Results:

Now, it’s the time to review the results for the payment run:

Run date: 12.09.2019

Identification: TEST4

 

  • Proposal run job log:

  • Payment run job log:

  • Clearing document:

 

  • Check registry:

 

  • Payment Medium files: DMEE Administration

 

Follow the path F110 (Status tab) -> Environment -> Payment Medium -> DME Administration for the list of Payment Medium files generated.

 

  • Positive Pay files:

Transaction: AL11

Directory: DIR_SAPUSERS

We can enter the correct file path if we want to send the file to a specific directory in AL11.

Here, as we entered only the file name, the file was created in the default DIR_SAPUSERS directory.

 

TEST POSIPAY 2 file was created because of the variant we created for SAPFPAYM program

TEST_POSIPAY0050 was created for the Proposal run

TEST_POSIPAY0051 was created for the Payment run

 

  • Positive Pay file structure:

I hope you enjoyed reading this blog. If you are working on APP, I’m sure the following blog will help you as well.

https://blogs.sap.com/2019/10/16/troubleshooting-automatic-payment-program-f110/

Let’s keep learning, together.

Cheers

Assigned Tags

      20 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ashfaq Ahmad Attar
      Ashfaq Ahmad Attar

      Excellent Explanation

      Regards

      Ashfaq Attar

      Author's profile photo Ratul Chakraborty2
      Ratul Chakraborty2
      Blog Post Author

      Thank you

      Author's profile photo Srinath Reddy
      Srinath Reddy

      Nice explanation

      Author's profile photo Ratul Chakraborty2
      Ratul Chakraborty2
      Blog Post Author

      Cheers

      Author's profile photo Mahesh Muthumula
      Mahesh Muthumula

      Good explanation

      Author's profile photo Ratul Chakraborty2
      Ratul Chakraborty2
      Blog Post Author

      Thank you. I hope it helps.

      Author's profile photo Henry Zambrano
      Henry Zambrano

      Hello Ratul,

      I am studying the procedure you expose, however; I have a question, for the issuance of checks through PMW, where is it indicated which batch of checks will take the program?, according to what is indicated in point 7.

      Example: in the classic program RFFOUS_C, it is possible to specify the batches.

      Thanks for sharing these types of tutorials with the community.

      Best regards.

      HZ

      Author's profile photo Ratul Chakraborty2
      Ratul Chakraborty2
      Blog Post Author

      Hi Henry,

      Check lot number can be entered at the selection screen of  RFFOUS_C. I hope you can create the variant accordingly. But, the problem I can think of is that you will have to keep on changing the variant with a new lot number.

      Cheers

      Ratul

      Author's profile photo Arun Gattani
      Arun Gattani

      Hi Ratul,

      How do we generate the positive pay file & printing check together using single payment method. using Payment medium workbench US_POSITIVE_PAY & CHECK. We are in S/4 Hana 1909

       

      Thanks,
      Regards,

      Arun

      Author's profile photo Ratul Chakraborty2
      Ratul Chakraborty2
      Blog Post Author

      Hi Arun,

      In the payment medium format settings, you can choose more than one output format. Please refer to the screen shot.

       

       

      Cheers

      Ratul

      Author's profile photo Arun Gattani
      Arun Gattani

      Thanks for your input Ratul,

      I have already ticked those both boxes. I have only one payment method where I have assigned positive pay payment medium format but in Company code format I have assigned the CHECK PMW

      format & in T code FBPM I have assigned the form as well so the printing should take place for both physical printing cheque & Positive pay file. Currently it is not generating the positive pay file when executed the program F110. For Check printing the spool get generated but positive pay file is not generated & transferred to application server though I'm using event 21 to transfer the file on the fly.

      So what Shall I check where it should get triggered both at a time.

       

       

      Author's profile photo Arun Gattani
      Arun Gattani

      Adding one more point. Is it mandatory to trigger the Positive pay file with FCHX transaction

      because I'm using payment medium workbench to trigger the positive pay file?

      What could be the reason for not triggering the positive pay file. It just becauseI have not assigned the PMW in company code data. ? If we don't assign the PMW CHECK it doesn't print check. At a time you can assign only 1 PMW in company code format option under the payment method.

      I appreciate your feedback on this.

      Thanks,
      Regards,

      Arun Gattani

      Author's profile photo Ratul Chakraborty2
      Ratul Chakraborty2
      Blog Post Author

      Arun,

      If I have understood your problem correctly, here is what my suggestion would be:

      • FCHX or any program is mandatory to create the files right? That is why we create variants in OBPM4 so that in the run time of F110 the program is called in the back ground with the parameters we have set as variant
      • If your config is correct, I suppose the program RFCHKE00 is not getting called from F110. Check the following screen shot. Did you maintain the variant for this program?

       

      Cheers

      Ratul

      Author's profile photo Arun Gattani
      Arun Gattani

      Hi Ratul,

      I don't want to use the FCHX to create the postive pay file.

      Requirement is to trigger the positive pay file using Payment medium program SAPFPAYM & physical cheque printing together.

      I have check configuration is correct in OBPM1 & DMEE also look correct.

      Issue is CHK printing format is getting printed but DMEE postive pay XML file is not getting created.

      Pls note I don't want the FCHX to be used for positive pay as per you Blog option 1 needed.

       

      Pls provide your contact number as well

      Thanks,

      Regards,

      Arun Gattani

       

       

       

      Thanks,
      Regards,

      Arun Gattani

       

      Author's profile photo Ratul Chakraborty2
      Ratul Chakraborty2
      Blog Post Author

      Hi Arun,

       

      We can get in touch in Linkedin.

      http://linkedin.com/in/theratulchakraborty

       

      Cheers

      Author's profile photo ratibha chadha
      ratibha chadha

      Hi Arun,

      I have exactly the same requirement as you have . Can we generate Check as well as positive pay file through Payment medium program itself.

      Let me know if you have figured out any solution for same.

      Thanks,

      Ratibha

      Author's profile photo Anitha Ganesha
      Anitha Ganesha

      Hi Sir,

       

      In Excel format need to generate DMEE file,used FPAYHX- CHECK but check number not getting populated in DME file,Could you please help me with the same.Sent request in linked in please access.

       

      Thanks,

      Anitha

      Author's profile photo Ratul Chakraborty2
      Ratul Chakraborty2
      Blog Post Author

      Hi,

       

      First of all check if system has assigned the check number to the payment run or not. If the check number has not been allotted, then it is quite obvious that no check number will be populated in the DME file. If check number has been assigned, then you have to check the field mapping in DMEE transaction. You may take help from your ABAPer in that case.

      Secondly, there could be 2 common causes of check number not being allotted by the system:

      1. Check number not available or next check lot is not maintained

      2. Payment methods are not maintained in the check register.

      Author's profile photo master mind
      master mind

      Hi

       

      Are you able to generate IDOC and Positive pay at the same time?

      Author's profile photo Ravi Ravipati
      Ravi Ravipati

      Very good walkthrough of how the Payment program is configured and Positive pay file is generated.   Just a note to those who are asking specific problems while configuring and testing this scenario.  You cannot bother Author with specific problems you have seen. You should learn as you fix them and be sensitive to asking several questions that pertain to your projects.