Includes DB Changes. Log all terminals out before upgrading

Tweaks and fixes

• EPC importing
  • Honda should be working with newer PE epc
  • Mojo : added a link for Surron
• Magician : tweak link / cykel qty output slightly so works correctly with online based inventory check; for dealers with websites when link/cykel parts are viewed on these websites. Old format was "qty (level)", e.g. "83 (high)", will now render as "high: 83" in c9, which is a better format for website supplier check integration
• Includes a couple of new GL codes intended for 5.3 only
• Change part : rename 'margin %' to 'markup %' to reflect actual computation applied
• Super / PayDay Super changes
  • Super report : was breaking staff entries that involve recurring vol super payments into two lines. The figures where fine, just didn't aggregate records fully. Now fixed
  • Super report : rerunning report would not reset the tally row at bottom of report, making tally figure progressively increase on every 'run report' button hit
  • Add special logic when payday is 7 days in future, generate the file but don't upload it immediately. Delay upload until payday.
  • Integrate payday into stp / finalise workflow
  • Add an alert into payroll that checks and warns about overdue bank recs linked to the payroll account. From July 1 use of c9s payroll system must be accompanied with a regular bankrec.
• Till Pay Terminal integration : improve handling on network errors. Previously would log network errors as failures but this is not necessarily the case. The till terminal could still progress to success in some circumstances. Exact changes:
  • In event of a network error assume txn is still in progress. Indicate txn is in state of network error. after 30 seconds pop an alert to really draw attention to this
  • If operator forces cancel on c9 and there are network errors still, write eftjournal status as unknown. Don't assume it failed
• Unit profit report : was not displaying '-' for -ve Line Margin results but if you exported the report as CSV it was there. Visual bug with report itself. Now fixed.
• Spares -> price change report. Name of report incorrectly was a copy / paste of a completely different report, creating confusion when report is saved, previewed or in print queue. Now fixed
• Weborder browsing : is pretty slow since changes six months ago to include order status / funds clearing & deposit holding to help with order finalisation. Screen performance should now be dramatically improved
• Email AR/AP txns :  embed transaction type into the email subject so it is obvious from email subject that a bill payment is a Remittance Advise for example.
• Fixed a subtle visual bug with some screens with lists and tabsd, when they are resized if you ta back and forth the # of columns shown will be wrong and weird. Obvious in a resized estimates screen when screen defaults to second tab. Tab back to first and it will be wrong. Note this fix may not fix remote c9 sessions; that will require a rebuild of remote c9 at some point. The bug is probably too minor to justify that effort at this stage.
• Cash till details report : was incorrectly printing online till clearing txns as till no #2.  suppress till_no for payment gateway clearing txns
• View customer : invoiced units tab. Show invoice price + GST
• View spares invoice : new button to edit notify method (no notification, notify any , notify all)
• Payroll leave backdating and overpay : subtle bug with computing overpay on backdated leave.
  • If there exists an active unbackdated leave record which was previously partially applied in prior payrun, any additional backdated record, even on a completely different employee can cause the slip to incorrectly compute a backdate reduction on pay. The system fails to recognise that some/all of that leave pay was successfully applied in a prior run so it tries to undo it.
  • Payroll system internally computes for each staff member a lastpay and that computation was broken. The effects of this are very subtle and unlikely to be bumped into.  Influences:
    • Prorata computation involving backdated LWP entries AND either payslip gap or overlapping payslips
    • Overlapping payrun filtering

Low level changes

• v9.0 txnengine : fix loc_id type on mv_txnqty materialization. Do not materialize v5.3 orderbook link hints to mv_txnqty.
• This version should now open up with later versions of java. Long term goal is to target java LTS 25 and sit with that for a few years. At this time later java vers remain untested and unsupported but this is some progress towards that. This version warns you if you are using a version later than java 8. Note at this time c9remote is still strictly java 8. A rebuild of remote client will be made at some point as well.