Tweaks and fixes

• Tweaks to HD epc importer to get it working again
• Job complete , send email + costs. Would crash . Now fix (5.2 deposit changes not integrated into email notify msg construction).

Bug fixes with 5.2 migrator which would prevent migration from working. GL rebalance logic busted when rebalancing on days where there exists deleted txns conaining gl codes that require rebalancing.

Migrate to 5.2 tweaks : improve migration of old taxed spares deposits.

Includes DB changes you need to log all terminals out during upgrade

This version includes a repair for 5.1 to 5.2 install. If v5.2 install fails, the messenger gets locked. Upgrading to this version unwedges that

This version (and in 5.2) includes changes to messenger to make it's unattended upgrade function work better. Unattended upgrade is supposed to trigger an automatic install on messenger computer if messenger computer isn't in use. It can go haywire in some circumstances. This version tweaks the logic a bit : wait until DB is fully upgraded before attempting to do an automatic update. Should minimise messenger going haywire significantly.

5.2.8 changes only

• Edit txn would not work on some txns created in v4 or v5 (bills and invoices). Should be okay now.

v4: nags user that v4 is at end of life.

v5.1: nags user to install v5.2

• Edit received line on order book, include option to permit toggling of receival as unit or spare parts in modify line
• print pickup job : print key location on invoice
• receive spares : disallow any manipulation of line pricing when the tally of lines does not match tally on screen. Force operator to deal with mismatch as a first action. This UX change is intended to cope with dealers who use PDF electronic importing involving suppliers where arrival of goods isn't consistent AND the scenario where suppliers do not round individual part supply exactly to one cent causing rounding issues on invoices (for example, order 3 items as $9.95 each, at 15% discount is applied but the discount is applied on line total, round(9.95*3*0.85) = 25.37. but if applied to individual cost and rounded it would be 25.38. And dealer wants to split receival into multiple receivals using goods in technique but still get pricing correct
• AR/AP Bulk ABA file generation broken by 5.2 changes. Now working again
• Scheduler changes
  • Bug fixes / improvements with how fixed tasks are handled. Presence of fixed tasks could cause abnormal gaps with floating tasks under some circumstances (typically when there is a fixed task in the day already elapsed and a future fixed task).  The code was broken in fundamental ways: fixed tasks are supposed to start and finish at a fixed time / yet still snap/constrain to actual availability configuration (day/smoko/holidays etc), without clocking so as the day passes through a locked task the task automatically reduces and then unlike floating tasks automatically disappears. So locked tasks behave more like availability rules than tasks. The code that handles this behavior was quite broken, so ripped it out and rewrote it correctly. Added automated tests to validate.
  • colour code jobs in rhs job list using same colour code scheme in scheduler
• add view audit / journals / details buttons to view contact -> activity tab

• Tweaks and new features
  • Add payment txn. Visual bug with default GL code for things like bills. Would not show GL code linked to supplier. System would still correctly assign the default code, it just wouldn't display on screen on initial opening of the screen. Now fixed
  • New report : repriced items. Allows you to review pricing changes from a supplier after a price file is dropped in. So you can push button opt to revert to original retail pricing that existed prior to installing the price file on individual stocked items. Similar to items below RRP report. Is automatically triggered as part of installing a new price file or can be accessed via spares reports or review price file imports.
  • Modify payment / deposit etc via view deposits : is now full featured popping the same screen on creating a new txn line allowing any aspect of the original txn to be modified.
  • Print build date on unit sales
  • WPS integration : use new Rest API for magician check and image grab

Includes DB Changes you need to log all terminals out during upgrade

Recent changes to make AR/AP things like lists work faster ran into a bug with postgresql itself.  Certain operations would not update txn list correctly. e.g. adding a payment for an AR balance.

Most common version of pg we have installed has a defect documented [here]

This update includes some tweaks to workaround the triggering conditions of the bug.

Bug was not detected in internal testing because testing is against later version of postgres (which is downloadable off website).

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

This version is likely the last version of 5.1.  5.2 migration tested against 20+ different backup systems and working well.

More work on migration to 5.2

• handle deposits incorrectly logged on spares invoices moving parts onto workshop/units/deals
• handle historically mismatched AP/AR txns where posted journal's status is mismatched.
• cope with historically invalid deposits, such as deal deposits incorrectly parked on an invoice
• assume reclaim_total for spares deposits is authoritative, not merely materialized tally of deposit_reclaims and bend general ledger around this.