query or report to get customers list for internal reconciliation

[former_member319241]

Hi,

I want to show customer list for internal reconciliation using query or report.

I want to show customers having open AR invoices

and Credit Notes and incoming payments not reconciled and I need to prepare query for that.

Thanks.

[msqadri]

Thanks agustin.marcoscividanes. This query also addressed my problem of tracing the A/P Reserve Invoice's paid 'status' while transition(s) are not shown on the 'relationship map'.