Reference field value in the F110 Payment document

[Former Member]

Dears

We are running the automatic payment run for the vendor invoices posted.

In each vendor invoice, we have filled the reference field, text field, etc.  However, while running the payment in F110, the system does not reproduce this reference field value in the payment document.  Hence we are not able to match the items for comparison.

Have we left out any setting in FBZP or somewhere ?

[ajaycwa1981 · Accepted solution]

Hi Niki

What you are expecting is not standard.

Did you turn on the individual payments check box in Vendor master? Without that it does not make sense.

Also, you might end up using a BTE to copy the fields.

Br. Ajay M

[Former Member · Accepted solution]

If the reference field is there, for example, how the bank reconciliation is going to clear the items after statement upload ? Is this not standard ?

[Former Member · Accepted solution]

If the reference field is not there. for example, how the bank reconciliation is going to clear the items after statement upload ? Is this not standard functionality ?

[Former Member · Accepted solution]

Hi,

Usually, All invoices are clubbed in one payment document. Reference or text field doesnt not flow from Invoice to payment document.

As Ajay mentioned, you have option to tick Individual Payment check box in vendor master data. It will post one payment document against each invoice document. You can define substitution rule to update Reference and text field in payment document.

Standard algorithm compares the bank statement Tag 61 with Document number. You dont need value in Reference field for Bank statement upload.

Hope, it clarifies.

Thanks,

Deepanshu

[Former Member]

Hi,

Kindly check & implement below OSS note, if you have one payment document per invoice.

Note 213551 - F110: Reference document not transferred

Regards,

Jyoti

[vinod_vemuru2]

Hello,

Apart from above suggestions, you can check linked invoices to payment document through below option.

Open payment document in FB03, go to Menu->Environment->Payment usage

This will list all invoices cleared through that payment document.

If you are looking for tables, Pass payment document number , company code, year, account type and account to AGKO table and get the clearing date. Pass these details to BSAK and get list of cleared documents.

AUGDT = Clearing date from AGKO

AUGBL= Clearing document from AGKO

and other details passed earlier.

Hope this helps.

Thanks,

V V