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

This version includes further modifications to bank rec. (The 12th iteration since Oct last year, bankrec is hard and v5 is especially challenging because of how v5 allows you to re-code journals, modify values etc, something v4 didn't allow so the 'problem space' around bankrec is more complex and varied now).

Specifics of this one:

• Fix an edge case where re-coded journal in a prior period (e.g. change payment method from cash to eft after fact) was breaking attempts to save a new later journal.  The later reconcile needs to treat the re-coded journal as a deletion but wasn't doing that. (Workaround to this is to redo reconcile for period covering the recoded txn, this change means this workaround is not necessary)
• This version of bank rec is alot smarter about how to handle residual values from discordant transactions.  A new value is tracked in bank rec called adjusted value.  This value tracks what was previous reconciled and allows better management of incorrectly reconciled behaviours. Easier to describe with an example. Lets say cash closes at $100 and there is a $100 invoice on that day. The next day, you backdate a delete for that transaction. On next day you want to show a open balance of $100 and a discordant effect of $-100. Previously c9 would not make such a calculation. It now does by explicitly tracking the need to undo the effect of the prior, now broken reconcile. i.e. on screen:
  
  In txn details you'll see a new column ,adjusted ,exerting an influence on opening balance
  
• Reconcile requires figuring out which reconcile is previous to current rec, chronologically and which reconcile to consult to figure out what reconciliation errors require attention. Usually but not necessarily they are the same. There are a class of errors that happen when reconciles are done in a haphazard way, e.g. going back a couple of days and saving a new rec but not rec'ing the following day, or saving a rec when the day has barely begun. This version improves how this reference recs are determined and we have improved our automated internal testing, hopefully now haphazard reconciliation hygiene should no longer cause issues with saving off additional recs.
• Lots of other little tweaks and tidies to bank rec. Just to document briefly.
  • Repeatability of reconcile : if you redo a reconcile then discordant txn listing should be the same as what was previously computed. Previously would not necessarily work that way
  • Deleted txn include toggle, no longer influences open balance.  The old behaviour was a bit of a cludge to try and emulate removing incorrect influence of prev reconciled txns. Since adjusting for prev reconciles is now formalised and tracked separatly this is no longer necessary
  • New buttons to query prior chonological rec and reference rec as they can be different and difference can be important.

Other fixes and tweaks in this release

• bugfix with tradein purchase on finance where purchased unit has dealer costs logged on it. Now fixed.
• workshop invoices for insurance jobs : show outstanding balance line total
• tweaks to historical aged balance report to show 6+ figure numbers. Currently clips to 99,999.99
• tweaks to view transaction unallocated column.  For 6+ figure numbers it displays all hashes #####
• Tender amount : allow inputting of 6+ digit figures.
• cash till : reintroduce cash till counting for paypal.  Was forcefully disabled in v5. Although cash till is designed to be used for on premises assets which can be counted/settled on an everyday basis, some dealers have a workflow where they rely on this screen to help manage delayed settlement instruments too, such as bank and web integrated paypal

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 #

• 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

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.

Bugfixes with 'use deposit to pay new account sale' behaviour. Would consistently fail with an error along lines of 'Cowardly refusing to add a txn without a customer' and would write changes which would be damaged.