from which table ,i ll get both the invoice and cleared amount ???

[Former Member]

Hi Friends,

i am making a report for my sales client where finance part is also required.

the requirement is : the sales people want know the status of the invoice generated at their end.the report shud be like if they enter the invoice no,fiscal year and coustomer they will be able to see the status of the invoice.how much pmt has received for that particular invoice,wheather it is open or fully cleared?

From which table i can get both invoice no. and the payment/pmts rerceived against that invoce/invoices.

plz guide.

Regards,

Biswa

[Former Member · Accepted solution]

You should be able to get the details from BSAD table for fully cleared invoices along with the amount.

Regards,

Mamta Sarda

[Former Member]

HI,

check table:-BSAK and BSIK

regards

SU*

[Former Member]

Hi,

SAP Standard Report itself covers all the requirements mentioned. With FBL5N, we get to know how much has been invoiced, paid and cleared and how much advance has been paid by customer etc., in one screen. Apart from this we have also all signs which show, which all invoices are due, overdue and its easy to analyse as well.

Was this requirement given by client after seeing this standard report?

Hope this info is helpful.

Regards,

Venkat