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
Click on New Entries, enter Clearing Rule (two characters ) and Description.
Save.
Select clearing rule and click on “Clearing Rule Fields” of Dialog structure on left hand side.
Click on New Entries, enter Item number 1 and Field KIDNO for payment reference.
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.
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.
Check Payment reference value in Vendor Line Item Report
Transaction Code: FBL1N
Post outgoing Payment
Transaction Code: F110 or F-53
Check value for payment reference for cleared and clearing item
Transaction Code: FBL1N
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
Hello Mr. KIM Khan,
Thanks 🙂
Thanks for providing helpful information…
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
Hi Zatopek,
I know its long back. Did you find solution for getting SGTXT?
Dear Mohammed,
Very helpful document. Thanks for preparing such a useful document.
Regards,
Tejas
Hi Kalim,
Nice document. Thanks for sharing your knowledge.
Regards,
Kesav
Nice Document!
Does anybody know if this can be enhanced so it is company code specific?
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
Hi,
Nice document. Thanks for sharing the knowledge 🙂
Regards
Karthi
Thanks for the share. Very nice document.
Best Regards,
Patricia
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