Sunday, March 10, 2013

Unpaid Invoices by Date

This query was very useful to me. It can give coun of unpaid invoices for each pay group and payment method by due date. This query can give me an idea of how many invoices will be processed by payments run.

This query can serve as an example to LISTAGG function too.


No comments:

Post a Comment