Estimations - item order
Hi there,
We have only been using Open VPMS for 6 weeks and this is my first post.
Our practice does lots of detailed estimates for clients and I am finding it really annoying that the items I add to an estimate show up in an apparenly random order once printed. This is irrespective of what order I've put them into the estimate. I find it really confusing for clients as I'm trying to go through and explain the estimate items - my consults show up mid way down the list, the hospitalisation items are broken and spread, and the medications are randomly dispersed also. I can't find any rhyme or reason for the way items are listed; there appears to be no pattern. Is there something I can do about this? Does anyone else find this frustrating??
Cheers!!
Kimberley
Estimations - item order
Hi Kimberley,
The order of the items in the estimation template is determined by the configuration of the subreport which prints the estimation items in the estimation template. The default order in some of the templates is strange as it orders by Patient Name, Product Display Name and then Product Name. Thsi woudl defeinitely look strange ..
Fortunately the solution si very easy as it just requires someone to edit your estimation template and change this order in the sub report settings. To do this:
1. Open up the estimation template in iReport editor.
2. Right click on the subreport and select properties.
3. Click on the subreport tab.
4. Change the datasource expression from $P{dataSource}.getDataSource("items", new String[]{"target.patient.entity.name", "target.product.entity.displayName", "target.product.entity.name"}) to $P{dataSource}.getDataSource("items", new String[]{"target.patient.entity.name", "target.startTime"})
5. Save the Report.
6. Load the new report into the Estimation template in OpenVPMS.
This all might sound a bit foreign at thsi stage so get your local implementer to help you do this. Should solve the problem quickly.
Cheers
Tony
Estimation order
We use them all the time and I had never noticed...
Thanks Kimberley and Tony!
Estimation order
Hi Guys,
Unfortunately the change I suggested didn't work as expected due to a difference between the way estimations and invoicing works. The date attached to estimation items is not displayed and they all default to the same date, the date the estimation was created. In the case of invoices the date on the items is visible and is set by default to the current date/time. Essentially this means sorting by startTime in estimations does not help with the ordering issue.
To fix this we will need to either set the date to the current date or add some kind of sequence number to allow the sequence the items were entered to be kept and used when printing the estimation. The former is an easy change so I think I will JIRA that first but a sequence number would be a good improvement as well.
Cheers
Tony
Estimations - item order
Hi Guys,
Have raised JIRA https://openvpms.atlassian.net/browse/OVPMS-938 and fixed in latest 1.4 version. Was relatively straight forward so happy to include in current release.
Cheers
Tony