A refinement on 5.1.79 migrator. More efficient algorithm for figuring out how to batch txns. (improved txn graph collator).

More work on 5.2 migrator.

Previous migrator  could fail with out of memory error, either in java itself or the database. The migrator 'batches' work to migrate processing all txns for a given contact in a single batch ( a batch might involve multiple contacts but each contact is processed in a single batch).  Problem is some systems, especially systems where we migrated data from competitor systems which defined cash sales as a contact, the # of txns for a single customer can be insanely large (Typically batch size is around 500 txns, but some systems can have customers with 70k txns against a single customer). New migrator includes some smarts to create much smaller batches of work, avoiding running into memory issues ( batch based on network graphs of interlinked txns, instead of batching by customer).

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).