Need query to exclude credits for unpaid and paid invoices

[former_member666435]

Hi Guys I have a request to do a report where i need to exclude credits for paid and unpaid invoices, anyone got an idea?

Warm regards,

Daniel

[kvbalakumar]

Sorry to tell you, we didn't got an idea of what you asking. So don't have an idea to suggest you, please.

Could you please clarify, what is your expected output columns and from which document?

[former_member666435]

Thanks Nagarajan,

Although now i have different requirements this might be usefull in the future

[kothandaraman_nagarajan]

Hi,

Check below threads,

https://answers.sap.com/questions/10362462/details-of-paid-invoices-for-each-incoming-payment.html

https://answers.sap.com/questions/11536705/need-query-for-ar-invoice-linked-with-incoming-pay.html

Regards,

Nagarajan

[former_member666435]

hi guys anyone wanna have a go 🙂