**Updated 4/11/2015 with polished formatting
**Updated 3/11/2015 to correct the calculation of 'unbilled'
**Updated 13/10/2015 to fix some problems and add features

This report is used to manage current debtors and is specifically designed to meet the needs of accounting staff. It is essentially an improved version of the customer balance report got using Reporting|Debtors|Report.

This report only shows the current position.  If you want the debtors situation as at a historical date, use the Debtors Report - Historical.

The parameter selection screen is:

Output sample:

The explanatory text is:

This shows the Current Debtors position at the time the report was run.
The customer location and account type selection fields entered have % added so that leaving them blank will find all, and entering say location %branch will find all customers with locations containing 'branch' in their name, and account type C will include all types starting C. The selection is case insensitive.
If there is no Customer Location selection then customers with no Practice Location set will be included. Using the selection '-' will select just those with no Practice Location set. The same applies for the Account Type selection.
Inactive customers (those whose active flag is not set) will not be included unless the 'Include Inactive Customers' box is checked. An "!" in column 1 will indicate any inactive customers.
The Balance and Outstanding columns include only Finalised transactions.
The Unbilled column shows the total of any In Progress, On Hold and  Completed transactions, and the Projected amount column shows the sum of the Balance and Unbilled columns.
The Last Invoice shown is the last Finalised Invoice.
If the 'Show Outstanding 60+ only' box is checked then only customers with amounts outstanding for 60 or more days are shown; otherwise
all customers with amounts outstanding will be shown and also those customers with credit balances if the 'Show Credit Balances' box is checked.  Credit amounts are shown as (123.45)
Customers with zero balances are never shown even if they have In Progress transactions.
Note that the Totals include all customers selected even if they have not been displayed. The Totals do not include inactive customers unless the Include Inactive Customers box is checked  The Total amounts are in whole dollars to allow large amounts to be displayed.

======

Note that as well as the jrxml file for the report, there as two subreports. [remember not to change their file names]