Bugfix : viewing locked payruns where payday is in July would crash c9. Recent addition of a warning screen that warns about variations between actual/nominate paydays in a financial year : this code broke view payrun screen when looking at locked runs. Now fixed

This version of c9 also includes alot of non-functional groundwork for V5 migration code. Not yet 100% ready. Next ver of c9 likely will include tooling to permit upgrading to V5.

Bugfix with importing price files + Toro where Toro franchise is configured to cope with dashes (-) being significant.  Recent price file import changes broke Toro dash stuff and import price file would not succeed. Now working again.

Fixes and tweaks

• Honda Order Export API : Make shipping config separate from shipping setting for OPEA based export. Because of reliability issues with DealerNet API dealers occasionally need to switch to OPEA method. Shipping setting here is different to setting for Export API. Making their storage separate will make process of switching export method a bit smoother.
• Bugfix with import PDF files for receive spares where some spares have packqty set.   The system recomputes qtys for packed items but it incorrectly can use pack settings from unrelated parts to influence other parts on the receival under some complex circumstances, causing their qtys to stuff up.  Now fixed in this version.

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.