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:
- Put the file path & name while creating the Variant for the program SAPFPAYM or
- 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
Excellent Explanation
Regards
Ashfaq Attar
Thank you
Nice explanation
Cheers
Good explanation
Thank you. I hope it helps.
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
Hi Arun,
In the payment medium format settings, you can choose more than one output format. Please refer to the screen shot.
Cheers
Ratul
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:
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
Hi Arun,
We can get in touch in Linkedin.
http://linkedin.com/in/theratulchakraborty
Cheers
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
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
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.
Hi
Are you able to generate IDOC and Positive pay at the same time?
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.