Skip to Content
Technical Articles

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

15 Comments
You must be Logged on to comment or reply to a post.
  • 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

  • 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

  • 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

    • /
      • 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.

         

         

        /
        • 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

          • 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

            /
          • 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