Skip to Content
author's profile photo Former Member
Former Member

Invoice no for payment received.

Hi,

I have found all payment entries made today against customer.

But I want to find out the related invoice no for the same.

how to get this and from which table.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 30, 2007 at 10:38 AM

    Hi Vinayak,

    Use TCode VF25 List of Invoice Lists

    Tcode VF23 Display Invoice List ...... You can restrict the display by choosing proper values in invoice list Search Help (F4 help).

    Hope this will help.

    Regards,

    Naveen.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 30, 2007 at 10:51 AM

    Hi,

    Try looking in table BSID.

    SJ

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Goto TCode FB03 and view the payment document. Now goto environment - Payment usage, the system will show the documents against which the payment has been made.

      A second way is to view the cleared line items using FBL5N and doing a subtotal on the clearing document column. Thus the invoice documents and the payment documents get clubbed together.

      A third way way to view the cleared line items using FBL5N and performing a subtotal in the assignment field. But note that for this to work the sort key in the customer master, account assignment tab, must be the reference field (You will have to create this sort key in TCode OB16) .

      Rgds

      Shivram.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.