AR Aging

[katycomputer]

I select Billing | Reports

Format: CSV
Report type: Aging Invoices
Status: Any

I get a list of 12 voided invoices and one draft invoice, but no open (and unpaid) invoices.

I want to know who has been invoiced and has not paid.

Where have I gone wrong? 

[activa]

Confirmed, The status is not list the closed one.

[katycomputer]

It seems like there should be an open AR aging report.

For my purposes, I can use Billing | Invoices, then use Chrome's CopyTables extension (# ekdpkppgmlalfkphpibadldikjimijon ) to copy the table values into Excel.

[Tyson]

The AR report lists open invoices in the given status that were due at least 30 days ago. It breaks them down by 30/60/90 day intervals past due for reference.

If you just need a list of open invoices, you can create a custom report fairly easily to generate you that list. Otherwise, it sounds like you may be interested in adding a "0" column to the AR report so that it will list all open invoices that were due at least 0 days ago and breaks them down by 0/30/60/90 day intervals.

[katycomputer]

Where do I add/change the column settings?

[Tyson]

If you're familiar with php you can update /components/reports/aging_invoices/aging_invoices.php to alter the data export for the AR report.