pending invoice

[Former Member]

hi! i'm working on a query to show all pending invoices (of the sales module) and i wanted to know what is the criteria under which SAP decides if an invoice is pending or not

this is a problem because (for me) this goes beyond the field that says if the invoice is open or not, because a partial payment closes the invoice, also is beyond the analisis of the PaidToDate vs the DocTotal field because of what i just said

¿it requires also an analisis of the reconciliation over the invoice? ¿ is that analisis even posible when you grab a bunch of invoices and reconciliate them against something else?

¿also do i need to analyze the credit memo linked to the invoice?

i need help with this, thank you all

[Former Member · Accepted solution]

Hi,

What do you mean pending here?

If an invoice is pending, it must have different PaidToDate from DocTotal.

Thanks,

Gordon

[Former Member · Accepted solution]

hi! i need to replicate the sales report "open item list" but i don't know the criteria under which SAP decides an invoice is pending... like you said, is it just the difference between doctotal and paidtodate? or it involves and analysis including other fields and things like credit memos and reconciliations?

[Former Member · Accepted solution]

Hi Samaria.....

Try this.....

Select T0.DocNum, T0.DocTotal, T0.PaidToDate From OINV T0 INNER JOIN INV1 T1 
ON T0.DocEntry=T1.DocEntry
Where T0.PaidToDate<T0.DocTotal and T0.DocStatus='O'

Above query will give you the list of pending invoices and just add the columns you want to add in report......

Regards,

Rahul

[Former Member]

Hi Samaria..........

If you refer Open Item List report then you get all the Pending Invoice list with all the details.......

For this report please go to Sales AR> Sales Report> Open Item List--> Select AR Invoice in Drop Down at Right Top Field.......

Regards,

Rahul