Friday, June 18, 2021

Query to get Count of Payable Invoices by Year and Status (Paid, Unpaid or Cancelled)


We were purging payable invoices and i wanted to know how many invoices are still not paid in a given year. So i used this simple query.

No comments:

Post a Comment