Includes database changes, you need to log all terminals out during upgrade

Fixes and tweaks

• Bugfix with recent memory optimisation changes for EPC importing. Was breaking will nullpointers with Curated suzuki and high resolution image option. Now fixed
• Select spares quote
  • Optimised database performance a bit
  • Add a order number /customer name filter on screen
• F2 find part
  • highlight parts with a notes icon which have notes
  • Description filter also filters notes (both stock and master file notes)
• Unit invoice tweaks
  • Capitalise Hours to make it consistent with other printed fields
  • Recipient invoices : print odo/hours if recorded
• make sure activity screen refreshes correct after a GL posting change, e.g. such as changing the posting date.
• Contract of sale particulars : print middle name if set.
• Cash till : add a refresh button to reload txns incase txn changes were made on a different screen.
• browse dealer unit screen can be slow. Make it faster with some DB optimisation (non materialized views: make sure works on sold tab especially)
• Payment : allow consumption of customer deposits, but in some strictly limited cases.
  • Funding of additional unit / workshop / spares deposit
  • AR and AP payments
  • Only permit this if there is sufficient balance to fund the txn in full
• Job part pick list : print some job particulars in printout header (job #, customer and unit)
• AusPOST integration, was not forcing states into correct form (all uppercase) on creating shipment record, causing AusPOST system to whinge. Now fixed.
• Unit invoices : itemise tax invoice items directly beneath the unit they are linked to, not below all units.
• Bugfix with missing important unique record constraint on a key database table in c9 (c9 configuration file prop). Suspect this problem goes all the way back to the pre java/pre postgres migration on old c9 v3 to v4. Problem is only present for a couple of clients how have 15+ years of history with c9