Average transaction / invoice report
Submitted by annaplatt on Sat, 10/06/2017 - 01:33
Good morning,
Can someone point me in the right direction to download a report that tells me
1. How much money each vet generates
2. Average Invoice written by a vet
3. Number of invoices written by a vet
because I am really confused regarding all the terminology.
Such as Item, transation & Includes item as when I run Practice Clinician Sales Report if I add up all the Items ( and Includes items) for the various Vets or No clinicians it does not equal the amount on the Customer Payment reports for the same period.
We have just upgraded to 1.9 but I am yet to upload all the necessary reports
Thanks Anna
Re: Average transaction / invoice report
Hi Anna,
There are a bunch of new and very nice upgraded reports (thanks to TimG) that are in the 1.9 release. Your implementor should be able to load them for you (they download with the release pack).
It is highly recommended to install these as they are a vast improvement on previous reports, far more consistent in their behavior and very well documented. The issue with the old reports and the reason for mismatches in figures are they are counting things differently (e.g. invoices vs invoice items).
The reports you are looking for that will do what you want (and more) are:
- Clinician Sales Report
- Practice Summary Report.
Another report I will give a plug for that you may like is the Key Performance Indicators Report.
With regards to confusion. This should be improved in 1.9 reports. The important things are to:
- Click "Display Explanation". This will specify very precisely what each line means.
- Make sure you understand if you are looking at a report that bases its analysis on Invoices Vs Invoice Items. Some reports look at an invoice total and the clinician that started an invoice when working out figures. Others look at the clinician recorded on each invoice item. We mainly use reports that look at clinician associated with each invoice item (and force OVPMS to require a clinician for each invoice item). This is because we have many vets often on the same invoice. So I want to know who is charging what. Single vet clinics or when looking at different things may want to use reports that look at the vet that started the invoice...
Let me know if this helps or if you need further pointers in where to find these updated reports.
Re: Average transaction / invoice report
Thanks for the reply - not sure if it is the Clinician Sales report you meant or the Practice Clinician Sales Report as they are very different when I run them.
I have just added the Practice Summary Report to our system - there are 5 report - how do I tell which is the Report and which are the 4 sub reports?
Thanks Anna
Re: Average transaction / invoice report
Hi,
The practice clinician sales report is what I think you are looking for.
The practice summary report should also have this info. Practice Summary.jrxml is the report. There are 10 other sub-reports (in my 1.9.1 release at least). This report should also have the information you are looking for.
Re: Average transaction / invoice report
Thanks ... I do find the names of the reports very confusing.
There must be something that I am doing wrong - when I go to the Resource Library -> catalogue and look for Practice Summary I can only see 5 reports
http://www.openvpms.org/customisation/practice-summary-report-updates
So I am really not sure where the above reports and sub reports are that you mention?
Tony has updated our system last week to 1.9 but I have not been given any information about additional reports.
Thanks again,
Anna
Re: Average transaction / invoice report
Anna - I would have hoped that Tony loaded all the new templates.
One way to check is to use Administration|Templates and search for 'block' - you should see something like:
If the new templates were not loaded, neither of the two highlighted ones will be present. [The bottom 3 will not be there - they are our tailored ones - which we need because we use non-standard 'made in Hong Kong' window envelopes.]
If the A4 template set got loaded then the first one will be present; if the A5 template set got loaded then the first two will be present.
So - if there is no 'Letterhead AddressBlock' stuff there, contact Tony & discuss the situation.
Note: Resource Library stuff: I have been trying to move to a situation where the standard release contains all that a practice needs. I do put stuff in the Resource Library (eg the Product Sales Price Age Report that went in last week), but if these reports are seen as 'one really needs to this run an efficient practice' then they should be part of the standard release.
Regards, Tim G