Skip to Content

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

January 18, 2014 | 2,733 Views |
Follow

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

To report this post you need to login first.

12 Comments

You must be Logged on to comment or reply to a post.

  1. 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

    (1) 
  3. 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

    (0) 
  8. 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

    (0) 

Leave a Reply