RSS Feed c9 logo Australia's best motorcycle shop retail software
Release 5.2.4 March 20, 2022 barney

Includes database changes. You need to log all terminals out during update. Note that data database changes in this update may take longer than usual to apply.

v5.2 database Performance improvements.  The pilot has uncovered some performance issues with 5.2 , especially with systems with 10 to 20+ years of history in them. Performance issues present in screens where balance, txn lists and especially historical point in time balance is required (such as historical statements). Updates now will generally outperform original v4 code in equivalent areas.

Specific changes

  • transalloc : which tracks payments to invoices, was not indexed at all. Now fixed
  • improve performance of view transactions screen (via use of a newly added materialized view. Also realise pg doesn't transmit not null via views, so force c9 to think underlying view has a non null date, so it index scroll efficiently)
  • reworked balance views to be more efficient, in place using newly created materialized views
  • materialize track last date when a payment is consumed (mv_last_supply), which has its existing analogue in tracking when an invoice is paid (mv_last_alloc). Use this, in combination with date range based GIST indexes to create a very efficient historical point in time open balance query. This will eventually also form basis of point in time/historical stock holding reports for spares once 5.3 is done.

Other changes:

  • Bugfix with using vouchers on point of sale spares. Would throw a journal error. Now fixed.
  • Relaxed STP error alerts to only consider last stp submission made, not last per payrun submission for last 2 weeks. So less naggy about historical/ignored issues
  • Account aging bug fix. A txn on 1st of current month would incorrectly appear in 30 days, not current. Now fixed
  • uom related qty display bug in point of sale in some circumstances.
  • cash till : show a padlock button next to other held over field on cash till so it is more obvious that non cash assets are tallying here
  • view customers. Add a new find by amount button