Tweaks and fixes

• Business -> Reports -> audit. Was not printing customer / clerk correctly. Now fixed
• Business -> reports -> Cash/Sales Recon. Was not working, wasn't converted to v5. Now fixed
• Honda dealer ID for Honda API.
  • Tweaked wording in edit franchise to make it more obvious it is needed. Later ver of c9 will consolidate back into a single code. Reason for split is long forgotten but I suspect it was to help with Honda transition to SAP when they partially transitioned pre-SAP 4 digit dealer codes to 5/6 digit SAP dealer codes.
  • Import Invoice API, the screen would only accept 5 digits. Now fixed
• V5 migration post installation : post install included some code that partially v5-ifies contact transaction lists (AR, AP & deposit txns). But code could fail in some circumstances when touching very old pre v4- general ledger (pre 2015) historical data killing c9 upgrade and preventing the upgrade from completing. The proper v5-ification is going to happen in v5.2 in a couple of months, so just pull this incomplete code out and implement it correctly there at a later date.

• Fixes and tweaks
  • Giftcards
    • Sell Giftcard to account not working. Now fixed
    • Business -> activity. Giftcard sales would not show total on this screen. Tweaked giftcard selling so they display total on this screen
  • Cash reconcile : could not access gateway instrument (Paypal), now added
  • Cash till print details : would print all txns when it needs to constrain the output based on selected till #

Monday, 4 Oct a dealer reported that their website was not working when getting to it via a web search. The problem was identified and fixed 90 mins later.

C9 hosted websites with SSL certificates stopped working on some devices, such as iPhones. On these devices the web browser would report that there is a security issue with the website and that the websites SSL certificate had expired.

Root cause: c9 hosted websites use letsencrypt for SSL certificates.  SSL certificates contain a list of certificates in a 'chain of trust'.  The root of letsencrypt certificates expired a couple of days ago and was replaced with a new root.

The problem I believe is that c9's webserver was configured such that it didn't provide the full certificate chain, it only provided the top of the chain.  Most web browsers fill in the gaps using trusted chains they know about. But with transition to a new root, some environments did not have enough information to fill in the gaps and could not validate that the link to the website was secure/trusted.

The fix involved making sure c9 webserver served the full chain of certificates.  The webserver we use made this fiddly to achieve so took a little longer than it ordinarily should of to resolve. One longer term mitigation we will need to reconsider our webserver stack (consider nginx to replace lighttpd).

• Tweaks and fixes
  • Purchase unit : system would let you enter in a trust receipt during purchase from someone else. Now disabled
  • Some more non functional payroll tweaks in preparation of STP Phase 2
    • CHE tweaks : tweaks /fixes to quarterly cycles. Options to disable PAYG and SuperG computation
  • Payroll : Working  Holiday Maker Tax Tables were wrong. Now updated
  • Under some circumstances which I am not entirely sure how, sell new giftcard could abort on saving cycle if user retries to save it will write the giftcard in a way that makes it unusable. This version fixes the underlying bug.
  • Print unit invoice : allow printing of invoices imported into c9 where we replaced a competitor system. V5 had a rule in it where it would only print if it could find a matching journal posting, which are never created with migrated data. Now relaxed that rule.
  • access txn audit via more details in reconcile
  • Some quality of life changes to bank rec
    • View details screen : new button more details on audit shows complete list of all audited modifications
    • New button 'View reference reconciliation'. When figuring out which txns are discordant, c9 figures out a previously saved reference reconciliation which logs subsequent changes potentially making that rec invalid. Potentially useful information when trying to hunt down reasons for discordant txns
  • Shipping Label, Better segregate sender addr with a gap and a line. Like so:
    
  • timesheet option to print highlighted mechanic only
  • unit sale modification, highlight when base price of a unit has changed in an edit session to help pickup situations where dealers have wrong target price locked in
  • unit deal, make it more obvious what parts are quoted and what are invoiced/ordered
  • settle finance across multiple units  where DOF doesn't evenly divide across the units. Make sure cents balance correctly using a more precise amortizer/quantizer.

Fixes and tweaks

• Unit stock take report : new column: unit floor age in days
• Balance sheet, include motor vehicle asset codes.
• Payroll
  • Bug with adding additional employer super where 450 min super threshold is configured. The 10% super calc would assume additional super is part of 10% super and would compute delta changes on subsequent runs undoing the effect of additional employer super, but only when the additional super is not part of the last payday of the month.  This behaviour only impacts on c9 customer, but generally the ability to log additional employer super is broken in this scenario. Now sorted.
  • STP Phase 2 only
    • added some checks for special TFNs that denote TFN application pending / no TFN supplied
    • Config switch to distinguish between registered for working holiday maker (probably no-one in our industry) and non-registered.

• Fixes and tweaks
  • Unit sales
    • Retroactive tweak to v4 migrated data for account unit sales, would itemize on account payments when it shouldn't
    • Show total outstanding for on account payments
  • Add parts via workshop  : under some exotic circumstances, parts you add via work would forget what job you are working on and attach to a different iob, or a null job.  ( when you are in pos screen if you deep dive into a parts history and do things like reprint a historial receival for that part, that can usually trigger this issue, very old bug been there for ages, now fixed )
  • QLD TMR authority forms, print customers drivers licence in CRN fields on these forms.
  • Change c9 support phone number in help about.

• Y-Shop integration : now uses Yamaha's API. Bonus is model fitment data! Example link here
• Bug fixes and tweaks
  • return parts via point of sale with qty>1 , would throw a journal error
  • Fine tune screen refresh on using a voucher for payment where voucher amount is not sufficient to cover invoice total
• Some txnscript tweaks to allow easier remote access for diagnostic support ( txnscript now accessible via c9 server console, similar to remote DB access )

Some more refinements to v5 migration to get a few more systems over the line.

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

Fixes and tweaks

• Cash / Bank Reconciliation. Couple more exotic scenarios
  • 1) Do a cash-till reconcile on period A -> B which was previously reconciled.  If since rec some txns were backdated into A->B period and into before A as well, and as part of cash till you try and record banked changes at the same time, under some certain combinations the save would fail. (discordant txn list from journalrec_base would alter on posting the banked txn and how that txn influences the old reconcile, when in reality it shouldn't make any difference
  • 2) re-do a reconcile. Held over txns that where previously okayed in overlaid rec would come through as ok, but effect of overlaid rec should be ignored in this scenario, forcing the user to redo handling of heldover txns and reconsider the reconcile that precedes chronologically
• Payroll tweaks, for STP phase 2 : included alternative tax table computation, that uses linear equations & formulas ATO publishes in NAT spreadsheets, as opposed to using progressive tax tables ATO also publish, to help smooth out STP Phase 2 compliance
• View/Change part quick stock order. 'Daily' and 'Alt' buttons would still order part under stock. Now fixed.

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

Tweaks and fixes

• Bank / Cash reconciliation.
  • A specific set of behaviours would generate unexpected reconciliation results. If you backdate a txn and redo cash till on that date where final balance changes, the following days cash till would seem okay, but day after would correctly highlight some sort of discordant reconciliation error. Now fixed so discordant reconciliation error appears immediately on next day as well.
  • Separate out discordant txn tally into a separate column in cash till, so does not merge figure into in/out columns. Should hopefully make dealing with cash tills broken by things such as backdated txns a bit more intuitive.
• Create labour rate. Fix long standing bug where under some circumstances the rate would be ex GST
• spares complete: allow 3 digit negative freight value entry.
• finished deals: view deposit history from here.
• reconcile txns button on view txns would look at customer type to figure out what class of txns to reconcile. Now preferentially looks at what sort of txn is currently highlighted. Needed where cust type and txn type do not align or are ambiguous (as in case of contacts who are both suppliers & debtors)
• Color code deals based on deal/quote and whether or not their pickup date is today/in the past
• Unit deal that is invoiced, rolled back and reinvoiced which has rebates defined on the deal itself. Re-invoice would fail with a save mode error, now fixed
• print a4 spares receipt. Make depositing printed the initial deposit only. Print a 'time of print' deposit history on the a4 invoice

txnscript : This version of c9 includes a new diagnostic tool to help us do more advanced diagnostics and repairs on c9. For last 10 years, advanced support relied on direct access to the database. But direct DB is no longer adequate with v5, as v5s database structure is too complex to manage this way. The tool is a beanshell like scripting engine called txnscript designed specifically for v5 c9. Given direct access to c9 db is too complex to manage directly, the old DB scanner tool has been removed.