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

• Tweaks and fixes
  • Payroll 2022 updates
    • Super rate set to 10.5
    • Disable <450 super threshold rule
    • Update and enable tax tables (only STSL has changed in 2022)
    • Payslip tweaks
      • Do not include FBT in net or gross tallies
      • Do not include garnish in  gross tally
    • Payroll  general ledger posting changes : c9 payruns will have a different construction from 2022 onwards. Instead of posting net and tax as expenses, the expenses posted will be gross salary figures only, but subdivided into salary, wages, commissions, and per diem. Tax /garnish etc will track as liabilities only. For purposes of historical consistency, any payrun before july 2022 performed with this version of c9 will still maintain older posting structure. Main purpose of this change is so that P&L c9 emits is a bit more polished, grouping payroll expenses on P&L in a more meaningful way.
    • Add / Modify leave : show dates with full 4 digits, to help guard against bad data entry being visually hidden. e.g. keying in 2122 instead of 2022 granting someone 100 years of sick leave but not being visually obvious this is what is happening bc all you see on key screens is 22
    • Long standing typo fix on edit payrun : "Staff" instead of "customer" on print payslip button
  • Bills and transactions
    • Supplier bill split payments. Add and manipulate split due dates for big suppliers. either in add txn you can split payments, or modify txn (for non txn bills such as spares receival). See screengrabs below
    • View transactions : displayed reference is both txn reference and line reference
    • Modify txn. Allow modification of line reference here as well as txn  reference
  • Modify txn : if you modify a txn which is a sale and on account, c9 would always nag to use deposit if any.  Now only nag for new txns or modified txns which previous were not active
  • print a4 spares : accomodate a -ve refund/exchange value greater than 10,0000. Previously prints as hashes ####. Now fixed
  • Bank Rec
    • Increase size of reference
    • For cash till, set reference to also include the payment instrument and till #. Not just the word 'banked', for easier bank rec
  • PPSR report : suppress raw report page by default
  • Low level systems fix : restore from backups can take a long time with v5 because of bad DB stats and that v5 contains alot of materialized views that require repopulation: tweak restore so it forces a stats refresh before redoing materialized views
  • Fitment finder : for franchises where dealer initially used remote EPC but then switched to locally installed EPC the fitment finder would always return error, as it would try to do a remote EPC lookup even though remote EPC is no longer in play. Now fixed
  • spares receival label and a4 printout.
    • Labels : print ordernum with phonenumber if ordernum is set (to help with web orders)
    • Labels and a4 : print 'OP' and instead of 'SP' for weborders (OP being online parts sales)
  • Low level v5 changes : mostly in part to support 5.3 work. But two things relevant for 5.2
    • rewrote DB layer constraint trigger : faster, simpler, better error reporting, improved constraint checks. Constraint triggers main job is to protect more complex invariant on the database layer itself, such as GL trial balance always tallying CR and DRs the same.
  • Added an aging adjusment feature : view transactions : adjust aging. It works a bit differently to how this sort of hing is handled in past where we would post new txns to force aging to values we want. Instead new system juggling allocations of payments to bills to arrive at desired aging. So no requirement to post anything to general ledger in order to arrive at desired aging figures.
  • Add/Modify rebate : display / allow user to toggle whether or not the rebate is to be included in profit figures for that unit
  • View contact : parts on order. Added view part/view invoice buttons on this tab
  • 5.2 regression fix : on workshop jobs, completed but fully deposited jobs would colour code purple.  Behaviour was accidently lost on moved to 5.2. Readded