Skip to Content
Author's profile photo Mohammed Kalim

How to Populate value of a field from cleared document to clearing document?

You can achieve this requirement through FI clearing rule(transaction code OBIA and OBIB).

For example, you want to populate same payment reference value from vendor invoice document to payment document.

Create FI Clearing Rule


Transaction Code: OBIA

SAP.png

Click on New Entries, enter Clearing Rule (two characters ) and Description.

SAP.png

Save.

Select clearing rule  and click on “Clearing Rule Fields” of Dialog structure on left hand side.

SAP.png

Click on New Entries, enter  Item number 1 and Field KIDNO for payment reference.

SAP.png

Save the entry.

Maintain Maintenance view for assigning FI clearing rules


Transaction Code: OBIB

Click on new entries and select account type (K for vendor D for customer and S for GL)& assign your clearing rule which you created through OBIA.

SAP.png

Now setting has been done for populating payment reference value from  invoice document to payment document for vendor.

Post incoming invoice


Transaction Code: FB60

During posting an invoice, click on payment tab and enter payment reference value.

SAP.png

Check Payment reference value in Vendor Line Item Report


Transaction Code: FBL1N

SAP.png

Post outgoing Payment

Transaction Code: F110 or F-53

Check value for payment reference for cleared and clearing item


Transaction Code: FBL1N

SAP.png

Assigned Tags

      13 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Consultant Khan
      Consultant Khan

      Hi Kalim,

      Very helpful document. Normally for this kind of requirement, most of us end up doing some enhancement (like substitution exit) to achieve the solution. Simple and straight forward solution without the need to take any help from ABAP guys.

      Thanks for posting.

      Regards

      KIM

      Author's profile photo Mohammed Kalim
      Mohammed Kalim
      Blog Post Author

      Hello Mr. KIM Khan,

      Thanks 🙂

      Author's profile photo Mariks .
      Mariks .

      Thanks for providing helpful information...

      Author's profile photo Zatopek Ondrej
      Zatopek Ondrej

      Dear Mohammed,

      do you know whether it is possible to transfer SGTXT field from payment request to a clearing document in F111 transaction? I have a payment request created without document but the field SGTXT is in the PAYRQ table. I would need to transfer it to clearing document. Now the clearing document is completely empty. Thanks in advance.

      Regards

      Ondrej

      Author's profile photo Satish Karemore
      Satish Karemore

      Hi Zatopek,

      I know its long back. Did you find solution for getting SGTXT?

      Author's profile photo Tejas Gupte
      Tejas Gupte

      Dear Mohammed,

      Very helpful document. Thanks for preparing such a useful document.

      Regards,

      Tejas

      Author's profile photo Former Member
      Former Member

      Hi Kalim,

      Nice document. Thanks for sharing your knowledge.

      Regards,

      Kesav

      Author's profile photo Former Member
      Former Member

      Nice Document!

      Author's profile photo Jean Daniel Keller
      Jean Daniel Keller

      Does anybody know if this can be enhanced so it is company code specific?

      Author's profile photo Hidyath pasha
      Hidyath pasha

      HI

      We  have tested this scenario but here one question is system should pick automatically invoice reference number as  payment reference then it is worth doing configuration.

      manually input the same invoice reference number in payment reference user usually will not accept

      Regards

      Hidyath

      Author's profile photo Former Member
      Former Member

      Hi,

      Nice document. Thanks for sharing the knowledge 🙂

      Regards

      Karthi

      Author's profile photo Patricia Fino
      Patricia Fino

      Thanks for the share. Very nice document.

      Best Regards,
      Patricia 

      Author's profile photo Manivannan Karunanithy
      Manivannan Karunanithy

      Hi Kalim,

      Thank you for sharing your knowledge with us. I need some clarification in these. What happens if there are multiple invoices are paid at once.

      Ex:

      Invoice 1 = 50000.00 (pmt ref - ABC999)

      Invoice 1 = 30000.00 (pmt ref - ABC998)

      Invoice 1 = 70000.00 (pmt ref - ABC997)

      Payment = 150000.00(pmt ref - ?)

      Hope you understand my requirement. Would you please help me?

       

      Thanks in advance

      Manivannan K