Client turnover and reminders

Hi,

I was wondering if anyone knows of existing reports for that supply the following data.

Client turnover - a report that lists all the clients which have not
had an invoice in the past 18 months.

% clients responding to reminders - a report which lists clients which have
been sent a reminder and if they have/have not had an invoice on their
account within a desired timeframe, for example 3 months.

Many thanks in advance if anyone could assist.

Oliver

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Client turnover and reminders

Hi Oliver,

I haven't seen a report to detail client turnover.  It could definitely be written though if someone wanted to specifiy how it woudl look and operat enad sponsor its development.

The Reminder Statsitics report is on the drawing board and in fact I am part the way through developing one.  It doesn't use invoice information but instead uses information recorded in the reminders including reminder count (no of reminder sent), when completed etc.  This can be used to develop a very accurate report of reminder effectiveness.  

I would be intersted to know how people would like to have this formatted. i.e   rows for each reminder type, and columns indicating numbers and % for 1st, 2nd, 3rd , subsequent reminder counts.  Criteria would allow stipulating reminder due date range and reminder type. ??

Cheers

Tony

Re: Client turnover and reminders

Hi,

Given no responses on the preferred operation and format of the reminder statistics report I have created one anyway and you can find it here  

http://www.openvpms.org/customisation/reminder-statistics-report

Look forward to your comments.  :-)

Cheers

Tony

Re: Client turnover and reminders

Tony
A great report to have.
Thanks again

Cheers
Chris

On 27/02/2011, at 12:01 PM, tony@openvpms.org wrote:

> Hi,
>
> Given no responses on the preferred operation and format of the reminder
> statistics report I have created one anyway and you can find it here
>
> http://www.openvpms.org/customisation/reminder-statistics-report
>
> Look forward to your comments. :-)
>
> Cheers
>
> Tony
>
>
> _______________________________________________
> OpenVPMS User Mailing List
> users@lists.openvpms.org
> To unsubscribe or change your subscription visit:
> http://lists.openvpms.org/listinfo/users
> Posts from this mailing list can be viewed online and replied to in the OpenVPMS User's forum- http://tinyurl.com/openvfu
_______________________________________________
OpenVPMS User Mailing List
users@lists.openvpms.org
To unsubscribe or change your subscription visit:
http://lists.openvpms.org/listinfo/users
Posts from this mailing list can be viewed online and replied to in the OpenVPMS User's forum- http://tinyurl.com/openvfu

Syndicate content