OpenVPMS 1.9.1

The OpenVPMS development team is pleased to announce the release of OpenVPMS 1.9.1.


  • fixes a number of bugs in the 1.9 release
  • improves performance and stability
  • includes report enhancements, contributed by Tim Gething

The release can be downloaded from the Download page.

See Installing OpenVPMS for installation instructions.

NOTE: users upgrading from 1.9 do not need to perform any migration other than loading changed report templates.



See Requirements for a list of installation requirements.

  • [OVPMS-1416] - Suppress payment dialog if the customer balance is <= zero
  • [OVPMS-1837] - Use DejaVu Sans as the default font in JasperReports to ensure portability
  • [OVPMS-1847] - Prevent session locking while user entering text
  • [OVPMS-1849] - Report Package improvements and fixes
  • [OVPMS-1854] - Further report improvements
  • [OVPMS-1865] - Customer Payments Report
  • [OVPMS-1867] - New report - Product Price Structure
  • [OVPMS-1686] - Leave appointment type blank if no default appointment type defined for schedule
  • [OVPMS-1830] - Include IDEXX species lookups in release
Bug fixes: 
  • [OVPMS-1593] - NPE receiving ESCI invoices missing tax information in AllowanceCharge
  • [OVPMS-1790] - Location selector includes locations not linked to the practice
  • [OVPMS-1806] - Consult on task with no patient displays "Context doesn't specify a patient" error
  • [OVPMS-1819] - Schedule views don't exclude inactive schedules
  • [OVPMS-1829] - Printing invoiced Estimate displays incomplete warning
  • [OVPMS-1831] - 1.8 to 1.9 migration script can fail on Linux
  • [OVPMS-1832] - Investigation Print downloads PDF instead of printing JasperReports templates
  • [OVPMS-1835] - Changing calendar block repeat to No repeat doesn't clear the repeat
  • [OVPMS-1836] - Release missing till balance adjustment authorities
  • [OVPMS-1838] - Improve error handling exporting OpenOffice documents
  • [OVPMS-1839] - Reminders on jasperreports pulling inactive/past patient owners
  • [OVPMS-1840] - NPE thrown when saving medication with no List Price
  • [OVPMS-1844] - OpenVPMS Editor Launcher signed with incorrect key
  • [OVPMS-1846] - Cannot add new contact immediately after clicking Apply
  • [OVPMS-1848] - Preferences update fails with error when two windows open
  • [OVPMS-1850] - Prescription medications not restricted by patient species
  • [OVPMS-1851] - Refreshing a patient letter with no document displays incorrect message
  • [OVPMS-1853] - Calendar block Name and Notes not propagated to other blocks in a series
  • [OVPMS-1855] - Products - Information table doesn't show Active column
  • [OVPMS-1856] - System Message Print fails with long message
  • [OVPMS-1857] - Product Price List Report omits some products
  • [OVPMS-1861] - Maximum price discount ignored when changing fixed prices
  • [OVPMS-1863] - Grouped Reminders JasperReport failing
  • [OVPMS-1864] - Printing document doesn't set Printed flag unless it is Finalised
  • [OVPMS-1869] - Fatal error printing a estimate that needs more than 1 page


Report Templates

Note that as a result of switching to DejaVu fonts for all JasperReports templates (see OVPMS-1837), it is strongly recommended that the new template set should be loaded using the templateload utility.

New Reports

The following new reports have been added:

  • Wait Time Statistics
  • Task Time Statistics
  • Customer Retention Report
  • Duplicate Customers & Patients Estimates Report
  • Product Price Structure

Enhancements and Fixes

The following enhancements and fixes are included:

  • OVPMS-1849 Report Package improvements and fixes
  • Key Performance Indicators report
    Errors fixed:
  1. DISTINCT customer count included OTC ‘customer’ – should not
  2. Patient activity test for inactive patients was incorrect
  3. Number of days calculation incorrect for prior periods – assumed all periods had same length – not so if current is a leap year – this will be 366 but prior will be 365
  4. Initial customer count was wrongly including customers created on the first day of the period.
  5. Tweaked layout to fix field overlaps which were preventing correct export
  6. Adjusted OTC and Invoice calculations so that OTC includes only Counter Sales to anonymous customers, and Invoices includes Count Sales to known customers (to match Practice Summary)
  7. Moved Adjustments from the ‘billing’ bucket to the ‘income’ bucket. i.e.
    was Total Billed = Invoices + OTC – Credits + Adjustments; now Total Billed = Invoices + OTC – Credits
    was Total Income = Payments – Refunds; now Total Income = Payments – Refunds + Adjustments
  8. Payment discount rate was being wrongly calculated (was always 0)
  9. US Letter version fails due to bad table cell alignment
  • AddressBlock – would not handle an OTC customer (ie when printing an OTC Sale invoice)
  • Customer Acquisition Report – corrected logic so that gives same new customers count as KPI and Customer Retention reports.
  • Historical Debtors Report - added option to allow credit balances to be ignored so the totals only include money owed.
  • Practice Summary Report
  1. Outstanding Debtors subreport – was including credit balances when should not have been, replaced SQL by that cloned from Historical Debtors report.
  2. Income by Clinician – adjusted test for OTC account to use archetype party.organisationOTC rather than name like ‘%Counter Sales’
  3. Income by Location – adjusted test for OTC account to use archetype party.organisationOTC rather than name like ‘%Counter Sales’
  1. Batch Usage Report revised to improve layout
  2. Product List Report revised to include classification
  3. Stock Valuation report revised to allow selection by classification, detection of zero costed items, and the ability to ignore products in a specified group
  4. Template load xml files revised to improve report descriptions
  • OVPMS-1865 Customer Payments Report
    Enhanced to show the payment/refund type and totals for each type, and also to allow selection of the customer location.
  • Samples - letterhead usage examples
    The sample reports (in <OPENVPMS-HOME>/reports/Sample) now include letterhead support in the "Sample Patient Form.jrxml" and in the new "Sample Rabies Certificate.jrxml".