RSS Feed c9 logo Australia's best motorcycle shop retail software
Release 5.2.100 May 21, 2024 barney

Includes Database changes you need to log all terminals out during processing.

Online payment processing reconciliation : this version of c9 tweaks how paypal and tillpay txns make their way through the general ledger. Funds now flow through a set of GL clearing codes 1-1410 : Payment Gateways Unallocated.

This change creates a separation between funds being captured and funds used to fund a sale. So on capturing funds from an online sale we now post DR into existing gateway code : 1-1041-xxxx, but we also post a CR into new code 1-1410-xxxx.  Then on invoicing we DR this new code to bring it back to zero.

Previously c9 would just DR the 1-1041-xxxx code and most of the time, as long as c9 was used way we liked it to be used what you capture and what you invoice are same so you could just reconcile off what you invoice. But there are some edge cases where things would not line up, like bailing out of creating a txn at a critical time and never redoing the operation.

Purpose of this change is two fold:

  • make reconciliation more robust in face of a couple of edge cases.
  • a new feature with tillpay processing is we can now capture and pre-auth automatically on website. This allows alignment card experience with what is commonly expected for online CC sales for consumers. This situation though will definitely create a delay between capture of funds and invoicing, so fund capture in this future scenario must be indirect to maintain ease of reconciliation

Other features / consequences of this change:

  • For existing historical web orders they will remain as is, a posting to original 1-1041-xxxx code only. But when installing this version if you touch sales in progress these will be, on demand, migrated to the new models. This approach is to allow smooth transition into this model without risking journal /reconciliation issues with trying to touch up very old txns.
  • unallocated web order transactions will report under the deposits held report
  • New codes report on the balance sheet
  •  impemented for Tillpay, Paypal Rest and Paypal NVP
  • Important: it is impossible for us to properly test Paypal NVP integration since Paypal have disabled ability to create NVP credentials for testing. It is strongly advised to no longer use NVP; since c9 cannot test it we cannot debug or support it any more. C9 screens make this even more obvious now. NVP will be forcefully disabled in a near future version of c9.

Other tweaks and fixes:

  • Some floorplan tracking bugs fixed:
    • Some floorplan modifications ,such as modifying or deleting a curtailment in a way that moves a floorplan from paid to unpaid or back would not log correctly in the database, resulting in issues with auto adjust process incorrectly posting an inappropriate result : which would usually clear up after you modify the unit but still would leave ugly resullts in accounting reconciliation report to deal with.  Now fixed.
    • Treat overpaid floorplans as unpaid : do not log a paid out event, in dealership units code /filter them as unpaid.  Previously would treat them as paid. This change will hopefully help detect errors with floorplan management where result behaviour is floorplan is flagged as overpaid
  • Subtle bugfix in processing final receival for paypal / tillpay. If auto invoice doesn't trigger and operator needs to trigger pickup manually, system would assume because balance outstanding is zero , no instrument is needed. So it clears instrument entirely and doesn't pop tillpay/paypal processing screen to void the preauth. Now fixed.
  • Tillpay integration
    • option to trigger a debit in case extend auth fails and the underlying txn was created with recurring
    • tweaks to cope with possibility of preauth arrived pre-captured too. To align with more common ecomm experience where goods are paid for at checkout. Requires setting on website to be enabled
  • Payroll.  New 24/25 tax tables
    • Linear equation tables as published mid May at https://softwaredevelopers.ato.gov.au/PAYGWTaxtables
    • Super guarantee 11.5 for 24/25
    • Annual tables for following cross referenced with either .gov published sites or x-ref with above tables : resident, foreign, working holiday & STSL
  • WA paperwork changes.
    • Add new form 4 particulars
    • Add new form 5 defects
    • Note  : separate warranty forms you need to source and print yourself from WA Gov websites . Not bundled in c9 since nothing prints on them
  • Add/edit franchise : advanced tab option for web api filter. Used by a couple of different dealers
  • Freeform stocktake : stocking a part currently not stocked but on price file broken since last version. Now fixed.
  • Merge weborder : hide secure token alter alert if there is order being merged doesn't have a token.
  • In some shops, when is c9 left on login screen for a long time if you try to login it will fail but second login will succeed. The cause is a stale network disconnect is misinterpreted as login not found. Fixed by double checking a failed login test to give network connection a chance to re-establish if it is stale.
  • Point of Sale finish : hotkey invoice date to Alt+T, to allow keyboard only editing since inv date is no in normal keyboard tab list.
  • Browse dealer units : filter input will now also filter on rego/plate.
  • Gas Gas Magician : would not work if there was a space in franchise name "Gas Gas". Now fixed to match with or without
Release 5.2.99 May 13, 2024 barney

Includes database changes you need to log terminals out during upgrade

This version includes a new POS terminal integration option into Tillpayments terminals. At time of release the solution is not certified for production use yet but assuming all goes well with ongoing testing/cerification this version will be the first version that permits direct connectivity to tillpay terminals without having to go via PCEFTPOS / Linkly. Desired outcome is to eliminate presence of Linkly entirely and avoid all the reliability and complexity issues that come with it.

This version includes a significant functional change with Unit Finance Sales.  Previously finance sales would post sporadically to AR and AP balances creating a mass on AR/AP statement for the finance provider. This behaviour is mainly because of how v4 AR/AP worked and has remained in place since. This version of c9 exploits newer capabilities in v5.2 c9 to heavily rationalise onto one or the other while keeping the number of lines on the contact txn list to a sensible minimum.

  • For Finance contacts tagged as debtors / both : everything will rationalise onto AR
  • For Finance contacts tagged as creditors : everything will rationalise onto AP
  • For straight purchases invoicing Both / creditor : everything will rationalise onto AP, otherwise AR
  • Note that encumbered tradeins the encumbrance will always post to AP (as before)

Generally with this change in place you may want to flag your finance providers as being 'Creditors' so that circumstances where encumbrance is same as finance provider then everything rationalises onto AP.

This version advances a ease of life too started back in 2018 : statement reconciliation.  Import a PDF statement file and cross check it against txns in your system. A heap of changes here to try and make it more useful. Targeting KTM group dealerships first because their 'statements' are not statements in the classic (correct) sense and their accounts are extremely challenging to reconcile against because of this. Hopefully this tool will be especially useful here. Goto view transactions on your KTM Group supplier, click on statement reconciliation and feed in a KTM statement pdf. Things it does

  • Match txns on PDF statement against txns in c9.
  • Matching is 'fuzzy', so copes with slight typo variations, missing or extra characters in reference, mistyped numbers etc
  • Help visually identify missing or misinputed invoices.
  • print or export result to csv
  • KTM specific nonsense:
    • filter to spares only to remove pages of floorplan stuff
    • Mash split payments on statement into a single record
    • Some logic to try and filter older records in c9 but not on ktm statement because ktm only show things they consider 'open'

 

Other tweaks and fixes

  • miner order receive query fixes.
    • Previously could not link order item to received order. Would output an error
    • Tweak state radio toggles on orditem to allow more filters
  • Timesheet report : option to filter results to mechanics only
  • Today Clocked Screen : option to filter results to mechanics only
  • freeform stock take : screen blows up in subtle ways when you scan a superceded part number. Now fixed.
  • BRP fiche importer : working again for Can-Am ATV and SXS importing
  • Leads  : new tabs. Alerted leads only sorted by date and tab for leads sorted by create order only
  • Honda op2ma : tweaks to reporting. Unit counts were misreporting and incorrectly double tallying units on deals.
    • Specifically repairs Fields P28, P29, P30, P31, P35 , P36
  • Browse Eft journal : add column to show provider now there are 4 (PCEFTPOS, Tyro, TillPay online and now Tillpay Terminal)
  • Returns on Predeliver on deals : handle better in deals. Show -ve on modify unit screen. Allow -ve inputting on editing of lines
  • Point of Sale Import Miner query :  Default qty to qty on hand. Some issues with POS importing zero qtys. Now tidied
  • Spares profit report bug : displayed QoH incorrectly copied from a different part for parts no longer on file (in stock or pricefile). Now fixed
  • EMail setup : make it visually obvious that sender From addr for c9 routed emails requires SPF entries to be in place first and to contact c9