Skip to Content
Author's profile photo Mahmoud Elnady

Payment Order Configuration

Payment order is  a Standard SAP tools used in payment process .. its firstly assign a payment order number against the open item paid with no payment entry generated then when processing bank reconciliation if the payment order appear in bank statement the system generates the payment entry and close the open item.. assignment of payment order number is preventing from duplicate payment ..


The configuration steps is:

T-code: OT84

          – ( Create account symbols) Y12 “Payment Order”

/wp-content/uploads/2015/07/1_746234.png

  • (Assign Accounts to Account Symbol ) assign Y12 to GL Account ++++++ as below

/wp-content/uploads/2015/07/2_746283.png

  • (Create Keys for Posting Rules) create a Keys for posting rule Y12

/wp-content/uploads/2015/07/3_746284.png

  • (Define posting rule)  define a posting rule like below

Posting Area 2 “Sub ledger posting “

Document Type: KZ

Posting Type : 7 “clear Debit Sub ledger account

/wp-content/uploads/2015/07/4_746297.png

  • T-Code FBZP “ Pmnt method in country” in posting details section choose Payment order only


/wp-content/uploads/2015/07/5_746298.png

  • T-code OT52 create manual bank statement posting rule

Interpretation Algorithm : 29 “Payment order”

/wp-content/uploads/2015/07/6_746306.png

  • T-code: OT43 Define Variant for Manual bank Statement

You have to add the payment order to variant

/wp-content/uploads/2015/07/7_746307.png

  • While Run F110 , SAP will create payment order Number for the selected invoice to be paid
  • You can display the payment order created from F110

/wp-content/uploads/2015/07/8_746308.png

/wp-content/uploads/2015/07/9_746313.png

/wp-content/uploads/2015/07/12_746323.png

  • When Run FF67 .. you have to enter payment order Number

/wp-content/uploads/2015/07/10_746318.png

  • SAP will create the below entry and clear the open item

/wp-content/uploads/2015/07/11_746322.png

Note that the payment order will not appear in FBL*N report due to standard SAP behavior .. you may refer the below link to insert the  payment order number in FBL*N report

How to insert Payment Order in FBL1N or FBL5N

Regards

Mahmoud EL Nady

Assigned Tags

      35 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Wonderful document. Keep up the good work. Thanks for the time and effort behind this.

      Author's profile photo Mahmoud Elnady
      Mahmoud Elnady
      Blog Post Author

      Hi sam

      thanks for your valuable feedback. .

      Regards

      Mahmoud El nady

      Author's profile photo Former Member
      Former Member

      Thanks a million Mahmoud for your usual great Innovation

      Author's profile photo Mahmoud Elnady
      Mahmoud Elnady
      Blog Post Author

      Hi Emad

      Thanks for your Encouraging words..

      Regards

      Mahmoud EL Nady

      Author's profile photo Prakash Sutar
      Prakash Sutar

      Hi Mahmoud,

      Useful document. Keep it up.

      Regards,

      Prakash

      Author's profile photo Mahmoud Elnady
      Mahmoud Elnady
      Blog Post Author

      Hi Prakash

      Thanks for your valuable feedback. .

      Regards

      Mahmoud el Nady

      Author's profile photo Roger Sunny
      Roger Sunny

      While running F110, I get an error saying "Payment Run has been Cancelled". Would you know why this error might occur? I have followed all required settings for Payment order and I'm not able to figure out the problem.

      Author's profile photo Mahmoud Elnady
      Mahmoud Elnady
      Blog Post Author

      Hi Roger

      For this issue you have to check the error log in F110 It should give the reason for cancelling the payment run.

      The reasons could be as below: 

      The open invoice items may not be due or overdue for payment.

      Depending on the next run date, APP might have not picked the open items for payment.

      The open item might have been blocked for payment.

      The vendor master record itself might have a payment block.

      Regards

      Mahmoud El Nady

      Author's profile photo Roger Sunny
      Roger Sunny

      Shukran Mahmoud

      Regards

      Roger

      Author's profile photo Mahmoud Elnady
      Mahmoud Elnady
      Blog Post Author

      You are most welcome Roger..

      Regards

      Mahmoud EL Nady

      Author's profile photo Raghuveer d
      Raghuveer d

      Hello Mohmoud,

      I am new to this so please forgive me if i am asking a stupid question.

      Is this functionality used for lock box related files BAI where the files are send to the client from bank and using them the client clears the open items

      Thanks in advance

      Regards

      Raghuveer

      Author's profile photo Mahmoud Elnady
      Mahmoud Elnady
      Blog Post Author

      Hi Raghuveer

      Thanks for your comments  and welcome to SCN.. unfortunately my knowledge in Lock box is limited.. you may post your question and you will find experts that they willing to provide helps..

      Regards

      Mahmoud EL Nady

      Author's profile photo Former Member
      Former Member

      Payment order have nothing to do with lockbox. Payment order has being explained here very well by Mahmoud Elnady.

      Lockbox-Imagine a scenario where one company has 1000's of customers and all customers are instructed to sent invoice payment to the company's bank branch address (not directly to the company address). Once bank receives these checks/payments, they will process all the payment and credit the amount to the company's bank account.

      All processed customer payment details are sent to the company through a file which is generated by the bank processing software. That file type can be BAI, BAI2 etc. Once the company receives that file from the bank, it is uploaded to the R3 system and all the customer payment will get credited instantly at one shot. Very simple, but very powerful.

      Author's profile photo Raghuveer d
      Raghuveer d

      Hello Sam and Mahmoud,

      Thank you very much for your reply and your explanation. 

      What i am trying to understand is that can this be applied to Lockbox scenarios.

      What i understand from the above is that the open items will be assigned a particular payment order number and while reconciling they will be cleared using the payment order number.

      Keeping the above in mind when we receive the BAI files from the bank, using them we have to clear the open items (since the payments are made to the bank directly) then in that case we can use this file and create a posting rule and clear the open items.

      Is this possible. Please advise

      Regards

      Raghuveer

      Author's profile photo Former Member
      Former Member

      Payment order is a type of payment method, where the payment is done, but the paid items are not cleared until it appears on the bank statement. So when the ebs statement is uploaded and payment order is entered the all the relevant invoices with the payment method is selected and posted. Bank has no role here.

      Lockbox-main purpose is bulk process of customer payments.In lockbox case,bank plays the main role. Processing all payments, crediting the amount, sending payment file to the client. Charging for their services. any mass correction etc...

      Author's profile photo Mahmoud Elnady
      Mahmoud Elnady
      Blog Post Author

      Hi Sam

      your explanation always is very helpful .. Thanks

      Regard

      Mahmoud El Nady

      Author's profile photo Ranu Eugene
      Ranu Eugene

      Hi Mahmoud Elnady

      Thanks for sharing such a good document.

      Very well explained with screen shots.

      Keep up the good work. 🙂

      Best of Luck 🙂 🙂

      Regards

      Eugene

      Author's profile photo Mahmoud Elnady
      Mahmoud Elnady
      Blog Post Author

      Thanks Ranu.. appreciate your positive feedback. .

      Regards

      Mahmoud el nady

      Author's profile photo SAP FiCO
      SAP FiCO

      Thanks for sharing......... Great work man !

      😎 🙂

      Author's profile photo Mahmoud Elnady
      Mahmoud Elnady
      Blog Post Author

      Thanks for your feedback. .

      Regards

      Mahmoud el nady

      Author's profile photo Mohammed Kalim
      Mohammed Kalim

      Hi Mahmoud,

      Nice document.

      Author's profile photo Mahmoud Elnady
      Mahmoud Elnady
      Blog Post Author

      Hi Mohammed

      Appreciate your feedback ..

      Thanks

      Mahmoud El nady

      Author's profile photo Rohit raj
      Rohit raj

      Hi Mohammed,

      Superb document. I really like to appreciate the efforts you are putting to share your knowledge. Keep up the good work. We expect many more new concepts to come from you.

      Regards,

      Rohit Raj....

      Author's profile photo Hidyath pasha
      Hidyath pasha

      Hi Mahmoud El nady,

      Superb once again , great to see this kind documents so we can new things .

      but we have doubt here payment order will not work for WHT is it ? for payment .

      Thanks

      Author's profile photo Mahmoud Elnady
      Mahmoud Elnady
      Blog Post Author

      Thanks again for your valuable comment.. i will test it and update the document once available..

      Regards

      Mahmoud El Nady

      Author's profile photo Mahmoud Elnady
      Mahmoud Elnady
      Blog Post Author

      Hi

      I checked for WHT  .. if I keep the WHT information in the posted invoice , its take effect while posting the payment clearing entry as per last screen shot in the document. . Thanks for your comment.

      Regards

      Mahmoud el nady

      Author's profile photo Sanjai Babu Kopuri
      Sanjai Babu Kopuri

      Hi Mahmoud,

      Its really a good document. Appreciate for sharing.

      I have a query.

      a) In the posting rule ( Y12) screen shot , you mentioned only a single posting rule meaning

          Vendor Acct      Debit

          Bank Main Acct Credit

          But if the company has sub account scenario, can this be addressed with another

          posting rule with a posting area "1"  to address GL posting.

      b) In the posting rule Y12 screen shot, why is posting key " Blank" under DEBIT tab?

      Rds

      Sanjai

      Author's profile photo Mahmoud Elnady
      Mahmoud Elnady
      Blog Post Author

      Hi

      In my opinion that the transfer when it appears in bank account does not need to post to reconciliation accounts.. as if you post it to recon account , subsequently you need to post it to main account..

      Thanks for your useful tip..

      Regards

      Mahmoud El Nady

      Author's profile photo Former Member
      Former Member

      Hi Mahmoud,

      could you capture the parameters for FF67 as I tried it which always show "First statment" message and I see your current screen capture, the posting don't have bank reference field, it seems not match with OT43 configuration, thanks.

      Regards,

      Edmond

      Author's profile photo Mahmoud Elnady
      Mahmoud Elnady
      Blog Post Author

      Hi

      Thanks for your comment..could you share screen shot for your error. bank reference in my case is used to match checks that cashed from bank with the checks issue ..

      Regards

      Mahmoud

      Author's profile photo Former Member
      Former Member

      Hi,

      Nice document. Thanks for detailed explanation.

      Regards

      Karthi

      Author's profile photo Mahmoud Elnady
      Mahmoud Elnady
      Blog Post Author

      Hi Karteek

      Thanks for your encouraging words.. Hope you find it useful .

      Regards

      Mahmoud

      Author's profile photo LOKANATH REDDY
      LOKANATH REDDY

      thanks for giving useful information

      Author's profile photo Virginia Fortin
      Virginia Fortin

      Hello

       

      Mahmoud

       

      Thanks for this document

       

      I have a question, in OT43 how can I add fiel payment order ?

       

      Author's profile photo Dan Goodhart
      Dan Goodhart

      This is an awesome document. Thanks for sharing.