-
AuthorPosts
-
December 8, 2011 at 1:24 pm #31285
Is it possible to have a report created please? I can’t see any reports in the standard templates and I could really do with one.
What I would like is to search by patient, by date and by service or product, and get a report of what items they have had bought from my clinic (i.e. invoice items from the financial items of service or products).
This way, when my customers come in and ask what products they bought in the past, we can easily look it up and tell them. Customers sometimes forget the names of the products they have bought in the past and the dates when they bought them.
Is this possible to do myself with one of the report templates that already exist?
thanks for your help
December 8, 2011 at 2:08 pm #32965Hi PlasticMan – thanks for your post.
I believe that there is a report already that does what does what you’re asking. It’s in the Financial section of the Reports & Templates screen, entitled “Invoiced Items & Services by Patient”.
If this report does not appear in your list, please follow the below steps :-
- Click “Import” on the Reports & Templates page[/*:2ewd6ljt]
- Navigate to your ClinicOffice Installation folder.
(By default this is “C:Program FilesPioneer SoftwareClinicOffice v4cov4_defaults”)[/*:2ewd6ljt] - Find the “Invoiced Items & Services by Patient [Financial].COv4_Report” and double click to open.[/*:2ewd6ljt]
You should receive a message that report has been imported and the “Invoiced Items & Services by Patient” report will be available for you to use in the “Financial” category.
Please let us know if this report does what you’re after – thanks!
December 8, 2011 at 11:23 pm #32966thanks for the reply. That would be a report that I would use.
However, in the report display options, in the drop down arrow to the right of the button that says “search”, when I select “show all records”, the date isn’t displayed.
Also, I’ve put through some financial transactions for product sales (as opposed to services sales) and the products don’t seem to getting displayed
can you help?
December 12, 2011 at 8:19 pm #32967hi – bumped for further help 🙂
December 13, 2011 at 1:59 pm #32968Support
KeymasterHi Plasticman,
>> in the report display options, in the drop down arrow to the right of the button that
>> says “search”, when I select “show all records”, the date isn’t displayed.This is an agreggated report which summarizes how many items of a certain type have been purchased by a patient over your specified period of time. For example, if Mrs Smith had 3 treatments over the course of a year, then you would see ONE line in the report saying “Mrs Smith – Treatments – Qty 3”.
It’s not possible to summarize the data AND display individual dates for each item.
>> I’ve put through some financial transactions for product sales (as opposed to
>> services sales) and the products don’t seem to getting displayedI’ve just tested this here and it works perfectly for all sales regardless of their category. Please can you try again and make sure that you don’t specify a search criteria for “Item Category” in the search critieria box.
December 16, 2011 at 10:41 am #32969Thanks. I must have done something wrong as it is working for both services and products.
It’s not possible to summarize the data AND display individual dates for each item.
This is something I would really like. Is it possible to commission a report for this?
thanksDecember 16, 2011 at 2:37 pm #32970Support
Keymaster>> This is something I would really like. Is it possible to commission a report for this?
It’s a physical impossibility to summarize data (i.e. to say “Patient X purchased a total of 10 ice packs totalling £x.xx”) AND to list the dates of each purchase separately on the same agreggated report.Do you mean that you would want the report to simply list each purchase separately and not summarise the data? If so, that would be possible and I can pass it on to our developers to look at, although there may be a small charge for producing it as a custom report for you. Please let us know if you’d like to proceed?
December 20, 2011 at 9:43 pm #32971ultimately, this is what I’m looking for:
when my customers come in and ask what products they bought in the past, I want to easily look it up and tell them. Customers sometimes forget the names of the products they have bought in the past and the dates when they bought them.
Thanks
December 21, 2011 at 10:24 am #32972Support
KeymasterThanks for explaining what you require. We have modified the original “Invoiced Items & Services by Patient” report by removing all agreggation and adding in the “date/time” and “invoicenum” fields.
Please try the attached report and let us know if it’s what you are after.
Instructions for importing a report can be found here :-
https://pioneersoftware.co.uk/forums/topic/how-do-i-import-a-report-file-into-my-database
Attachments:
You must be logged in to view attached files. -
AuthorPosts
- You must be logged in to reply to this topic.