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

• Tweaks and fixes
  • Online Backup
    • include post restore instructions to automatically rebuild phonebook + customer search
    • included metadata used by backup server to make sure correct backup trigger regime in put in play for restored master files (hard to explain what this means without writing a novel. Impact to c9 without this is under some circumstances, installing new price files might not backup newly added parts correctly after having to rebuild a c9 system from online backups. Easily fixable problem once detected, detected via backup verify, but now fixed more properly with this update.)
  • WA forms : expose previously removed file, because apparently it is still actually needed
  • payroll 2021 updates
    • 10% super guarantee
    • Tables : PAYG etc
    • Provide visual alert for July payruns if nominal # of runs does not match actual # of runs in financial year. e.g. 2021-2022 there are 53 Thursdays in the year, not 52, meaning earnings are higher so tax on each payrun is computed a little higher too
  • General Ledger caching mechanism updated to allow smooth transition to v5. (Cache system precalculates gl open/close figures so system doesn't have to tally up everything everytime a GL code balance is needed making GL stuff much faster)
  • Bugfix with import price file : if you abort price file partway via close c9 or click on a different section the price file will partially install in a way where it is not possible to install another price file. Now fixed.
  • Shopify : update version id ahead of scheduled July 1 deprecation

• Tweaks and fixes
  • Replaced TeamViewer with AnyDesk as our primary remote support tool.
  • Install pricefiles, improved an efficiency issue with massive price files which are not loaded via c9 repo such as John Deere and BMW.  [ Defer using primary key with on conflict () update so we are not burning pk ids. Generally not a huge issue but with suppliers with millions of parts, the upper limit of about 2 billion parts will be reached fairly quickly with such wastage ]
  • Suzuki Magician check - working again
  • Select customer via phone book. Include an add button here
  • Spares menu : assign a hotkey to despatching screen
  • Disable cybersec warning : was not affecting workshop invoices.
  • View Invoice : showing wrong count for cancelled parts. Now fixed

Bug fixes

• Some classes of errors would cause future unrelated txns in c9 to fail too. Now fix (technical description: autoinc key management was fragile. Now flushes keys to autoinc always).
• Add part via orderbook would under some circumstances not work (if last part in orderbook happened to be finalized). 10 year old bug that was papered over mostly, except with recent changes in last ver of c9 with supers at orders. The supers changes are fine, but they pulled back the covers on this very old bug.

Tweaks

• F6 unstocked part. Show part/description and a couple of other bits of info. So can see exactly what part you are looking at and quickly right click and copy parts info from this screen
• WA registration form updated

• Tweaks and fixes
  • Order book - add part would not work under some circumstances depending on content of orderbook.  Clicking button would do nothing. Bug standing bug that never triggered because of how orderbook supers were resolved. Recent changes exposed the underlying bug.  Now fixed.
  • Cyber Sec warning on bottom of key invoices. Option in setup in printers tab to disable this
  • Tweak supplier returns to allow for returning as goods only. to be used as a returned unsold goods under consignment process
  • Yamaha YPIC import import. added a guard for missing images in YPIC which could blow up c9 import
  • Add/edit franchise : button in network/magician allows you to drop link between franchise and c9 repo. to help fix up franchises that are incorrectly mapped.
  • weborder processing from other c9 dealers (direct order upload.) Switch sale to on account if dealership is tracked as an account customer.
  • Record BAS, PAYG GL posting would record against withheld expense always, even if liability tracking is enabled. Tweaked to record against liability code if liability tracking is setup.

Tweaks and fixes

• Something a bit screwy with version number increments on last update. Number update process wasn't performed correctly. Pushing number forward again in order to tidy.
• Print A4 invoice, increase name size to 40chars
• Browse dealer floorplan/consignment units. do not show sold consignments
• Bugfix with Harley KPI report. Would not generate any data (regression caused by profit summary by clerk key contains in Nov 2020)

• Import from PDF. Apply packqty adjustments for parts configured with a packqty setting and orderpack flag is set.
• View customer, on order tab. Deposit held figure would incorrectly show deposit held for last invoice on the list, when it should of displayed the total tally for all parts on order. Now fixed.
• Included new VicRoads Dealer Online Auth form
• Supercessions on orders. Normally these resolve as expected but there are a couple of edge cases where resolution doesn't go according to plan. For example receiving parts on order X, but fulfills order Y, the system will not correctly update supers on order Y.  Now fixed by using a more efficient and more exhaustive supers check.

This version of c9 is a slight fix to 4.874 upgrade

The DB upgrade steps in 4.874 could potentially fail under some exotic circumstances. This update makes the upgrade more resilient.

If you are running 4.874 already then this ver does nothing useful. If you are running a version before 4.874 then this new update includes more robust DB upgrade instructions. This version of itself is not a db upgrade version.

Technical specifics: bankrecitem update enforces non-null on reconciled amount but it is in theory possible to have a bankrecitem without a corresponding journal posting. To fix, this ver will write these in with a zero value to avoid null constraint check.

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

This version includes some non functional changes to bank reconciliation. V5 c9's general ledger is alot more flexible allowing postings to be modified : changing amounts, GL codes etc whereas with V4 all you can do is toggle delete/restore a posting.

Being able to fiddle other things on a posting has obvious implications for bank rec. In order to make transition from v4 to v5 simpler it makes sense, from a technical perspective, to drop a few things into v4 now to lay groundwork to accommodate this instead of rolling in bigger set of changes into v5.

Honda order submission changes

Low level java bugfix with how java handles failed http POST requests. Java has a 15 year old bug in it where it will resubmit POST requests if they disconnect. Instead of fixing the bug, like they should of, java instead decided to add an obscure switch to fix the bug which you have to explicitly enable. This  version of c9 now throws that switch. ( https://bugs.java.com/bugdatabase/view_bug.do?bug_id=6382788 ).

In terms of c9 integration to Honda what this means is that reports of orders doubling up should no longer occur after updating to this version. Overall there still remains outstanding issues, i.e. the timeouts that trigger the resends in the first place are still of themselves harmful and these are confirmed via packet sniffing to be coming from the Honda service, but this change at least represents a solid step forward towards improving the overall interconnect.

Other changes

• View bug in contacts - > view transactions. Under some circumstances view button can get disabled (due to txn referencing a non existing sale for example), but once it is disabled clicking on any other txn will not re-enable it. Now fixed
• Shopify sync : for orders where there is no shipping address, only a billing address, pull details from billing address
• View account -> parts handled tab.  Display invoice type. As is hard to figure out if items have been supplied or just looking at a quote.

• Unit sales. Reworked unit sale $ input screen to make things flow a bit better with base prices etc.
  • added Explicit Base price + GST field
  • Added explicit checkbox toggles to toggle fixed price
  • Now there are toggles tweaked computation logic a bit so it is more intuitive. Main thing is locked base price behavior is more ergonomic, you now explicitly switch it on and off as needed as opposed to before where you had to make obscure, unintuitive user interface incantations to get it to toggle
• Business balance sheet report, multiple fixes
  • Was not tallying banks into total. Now fixed
  • Was doubling up PAYG withholding, when it should of be been reporting PAYG and super as separate lines. Now fixed
• cust view parts on order bugfix
• highlight/colorcode workshop/unit images buttons if there are images/attachments. On following key screens:view job, modify job, complete and pickup
• KTM group magician :  show simple tally only instead of showing that tally is aggregated across multiple lines. This is necessary to to get web based part availability working for crossover parts. It will require a restart of messenger to work
• Add option to import Gas Gas EPC for non Gas Gas dealers who are otherwise KTM group dealers.

Includes database changes. You need to log all terminals out during upgrade

• Single touch payroll tweaks. Data sent to STP was slightly wrong (was not sending commencement date). Tweaked in order to correctly support jobmaker. (See below for info on how to tag an employee for jobmaker)
• F7 alterns, reworked the screen a bit. Works alot faster on loading shows a bit more info. The amount of records it shows is slightly less. It will only show a given part once.  Working on a new data set with alot of alternatives, old way of doing things blew out the resulting list to millions of records with old way to traversed the graph of interlinked parts.

How to tag an employee for Job Maker credit

The staff record needs to have following set:

• Their date of birth (on General Stuff tab)
• Their start date (on Payroll tab)

Then in payrun you need to add a manual pay record. Structured like so:

Specifics:

• Make sure type is Allowances
• Make description exactly this:  JMHC-NOM
• Make amount one cent. This will trigger a 0.01 once off pay increase for the payrun but is necessary to push data via STP
• On Notes tab, make sure Other is selected in Allowances