on 11-30-2007 6:12 AM
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
Hi Vimal,
Payment document and payment date can be found in clearing field BSEG-AUGBL and BSEG-AUGDT
Regards,
~gum+
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.