cancel
Showing results for 
Search instead for 
Did you mean: 

Invoice no for payment received.

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Try looking in table BSID.

SJ

Former Member
0 Kudos

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.