Thanks very much for Tony De Keizer from vertical connect for modifying this report for me to allow searches for payment types over a specified period. 

We use this to track which debtors are in collections. Instead of using the built-in debtors reports, this one cross-references with a customer alert called "In Collections" to ensure that our internal staff don't call to these clients who are already being processed by a collections agency. In order to use effectively, you need to create an alert called "In Collections", or modify the report to pick-up whichever name you're using for this presently.

This report shows invoice line items per clinician, for a specific time period (as well as to whom it was sold). Our clinic uses these dates for commission calculation. This detail allows one to ensure that the proper items (products) are getting into that calculation.

I created this report to be able to get sales figures over a given period sorted by payment type. This report can be used to get the sales figures for use with the AVA chart of accounts. 

In order to use it for this each product needs to have a product type which should correlate with the chart of accounts income catagories. 

This report analyses product sales by species and product type.  You can filter by date range and product type.

This report shows reminders that should have been sent (in the past), but have not been... and are also not cancelled or complete. We're using this to identify those reminders that may have been enterred incorrectly. It appears that some people put the wrong year when they add them manually, and they never get picked up by the reminder runs. This helps catch them.

Update -- making this ignore inactive clients and their pets.

This plots four series over the time selected: Sent reminders, Due reminders, Sent customers, Due customers.

The customer lines are also based on reminders, but aggregate. This should give you an idea of how much you're paying in postage (if you're doing that).

One of these may be a better leading indicator for revenue than the other... but I haven't experimented with that.

I'd appreciate if someone can check the SQL logic, because it got a little complicated in there.

This calculates a monthly running total for each month, and displays the months on top of each other. It's useful to see if there's a monthly "curve" in your business, to compare monthly revenue streams and their variation, and to see how you're doing in the current month against previous months.

Note, the SQL query in this is somewhat "heavyweight"... it runs a subquery for each day and may take time to run depending on your setup.

v2:

This report sums up each day, and calculates the average per day of week over the date range specified.

Hi

Please find attached a change - thank you Tony - to the Product Structure Report.

This report will list all products by:

Product Type - also grouping any products currently without a Product Type

Frame Work

Classification - lists all classifications if more than one.

This is a great report to allow you to understand then tidy up your product details ensuring every product is in the correct Product Type (great for reporting) and then allows you to tidy up Classifications for stock control