Customer Invoice

[Former Member]

Hi,

How can I know that whether a customer has a invoice to be paid? which table-field that i have to look into?

Is there some indicator which shows that a customer is debitor? and due date has already expired?

Thanks

Mary

[Former Member]

Hi Mary, Welcome to SDN. Can this standard report: RFDOPR10 be useful for you??

[Former Member]

hi Rhode,

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

In FBL5N, you have the options to choose "Open Items", "Cleared Items" and "All Items".

If you choose "Cleared Items", 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.

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.

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.

Also,

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

Hope this helps.

cheers,

Hema.