katycomputer Posted August 18, 2018 Report Share Posted August 18, 2018 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? Quote Link to comment Share on other sites More sharing options...
0 activa Posted August 19, 2018 Report Share Posted August 19, 2018 Confirmed, The status is not list the closed one. Quote Link to comment Share on other sites More sharing options...
0 katycomputer Posted August 19, 2018 Author Report Share Posted August 19, 2018 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. Quote Link to comment Share on other sites More sharing options...
0 Tyson Posted August 20, 2018 Report Share Posted August 20, 2018 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. Quote Link to comment Share on other sites More sharing options...
0 katycomputer Posted August 21, 2018 Author Report Share Posted August 21, 2018 Where do I add/change the column settings? Quote Link to comment Share on other sites More sharing options...
0 Tyson Posted August 21, 2018 Report Share Posted August 21, 2018 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. katycomputer and activa 2 Quote Link to comment Share on other sites More sharing options...
Question
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?
Link to comment
Share on other sites
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.