How do we know tat a customer paid an invoice through the same Invoice no.

[Former Member]

Hi gurus,

How do we know that a customer has paid an invoice through the same Invoice no.

If it is in accounting document no, can u say where it can be seen.

Moreover I want to generate a mail to customers who didn't pay their Invoice.

So wat field will be appropriate in an invoice to trigger an mail?

Regards,

vimal

[Former Member · Accepted solution]

Hi Vimal,

Payment document and payment date can be found in clearing field BSEG-AUGBL and BSEG-AUGDT

Regards,

~gum+

[Former Member · Accepted solution]

BSEG is a cluster table. It advisable to use the BSID table. Both AUGDT and AUGBL fields are available here. BSID being the table for open items only there will be only the accounting docs corresponding to bills not yet "knocked off". The performance of the report(or program) will be better if you use this table.

[Former Member · Accepted solution]

Hi,

Thanx for ur quick response.

But where can we find payment date and payment no in an Invoice no?

Regards,

vimal

[Former Member · Accepted solution]

You have to link invoice to the corresponding accounting doc.

VBRK-BELNR <-> BKPF-AWKEY (BKPF-GJAHR)

BKPF-BELNR (BKPF-GJAHR) <-> BSID-BELNR (BSID-GJAHR)

Make sure you use the GJARH (Fiscal year) field since in FI the document numbers usually repeat every year.

[Former Member · Accepted solution]

Hi ashish,

Ur solution was useful.

So apart from the table link we cant find directly in an billing document whether customer has paid or not .....

Regards,

vimal

[Former Member · Accepted solution]

If you want it for individual invoice then from VF03 (or VF02) you enter the invoice number and click on the document flow icon and see if the accounting document is "cleared" or "not cleared"

[Former Member · Accepted solution]

Hi,

So I feel that might be the only solution available.

Regards,

vimal

[former_member183879]

The tcode FBL5N will give you all the details of payment of a customer and the corresponding invoice number. I t hink that can give you a very good information about what you are asking for.

Hope this helps.

Reward if this helps you

[Former Member]

Hi,

I do know we can find it in tcode FBL5N. But is it possible to find directly from the billing document no.

Regards,

vimal

[Lakshmipathi]

Dear Vimal

In <b>FBL5N</b>, you have the options to choose <i>"Open Items", "Cleared Items" and "All Items".</i>

If you choose "<i>Cleared Items</i>", you can see a list of billing documents and on the left side, there will be a green circle which means, those invoices were paid by the customer.

Thanks

G. Lakshmipathi