This function only applies if you generate invoices within Music Monitor. If you export your billing lines to be processed from another system, it doesn't apply.
The Debtor Report is a flexible report on amounts billed, amounts paid and account balances for any time period, and summarised by almost any field. To run the Debtor Report, go to Common Tasks > Financial Reports > Debtor Report.
The script will ask for a date and, optionally, a specific debtor.
The report will open initially showing only totals. The Display and Summarise By button gives you options for what additional detail to include.
When summarised by Debtor the report looks like this:
When summarised by Days Overdue the report looks like this:
When summarised by Debtor and Days Overdue the report looks like this:
When you select Show Detail in any summary, the report lists every invoice found in your initial search.
Hide Zero or Credit Balances will hide summary groups with zero or credit balances.
This option is not available for reports generated for past dates.
There are several buttons to perform other functions you may need when analysing outstanding amounts.
The Invoice Date and Invoice Ref entries are links to show the related invoice.
The debtor’s name is a link to show the related Debtor record.
There are three icons in the black top bar:
Save as Excel
Print
View the related Line Items as a list