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