Includes Database changes you need to log c9 out during upgrade

Refinements & bug fixes for cross dealership giftcards

• v4/v5 patch for discount voucher behaviour  was not applying for external vouchers. making external discount vouchers unusable. Now fixed
• Bugfix with external voucher use sync back to issuer. Was generating an unbalanced GL posting making sync impossible. Now fixed.
• Tweak GL codes used to sync vouchers back to issuer for discount vouchers (sync to contra code)
• External Voucher rollback on txn error was broken. Writing wrong state forcing voucher to be consumed.
• Payment methods, never grey out giftcards for dealers that can use ext vouchers. Although they may not have any local vouchers, they might be able to access external vouchers

Other fixes:

• Recent changes to Unit Stock take report broke grouping of units in the report. The report correctly prints all units and info, but it messes up the now they are grouped (new, used, floorplan, etc). Now fixed.
• Bulk floorplan payout was not migrated to v5.1 : now done
• quicksuper export, date encoding was incorrect (quicksuper documentation is likely wrong). Now fixed, switched to DD/MM/YYYY format
• free nsw rego check disabled, appears NSW state gov made changes to their website which broke the scraper. Since we now have a professionally supported service, support for free scrapers will be gradually removed as each one fails due to website modifications.
• print deals, have option to apply filter inputted into screen to the report as well
• found another example of circular network graphs of spares invoices where it was not possible to print an invoice. Now fixed.
• a previous version of c9 (5.1.43) disabled ability to merge invoices into a new reserve invoice.  Some refinements here to enforce this behaviour. Some workarounds were possible to get around this constrain.
• Link Int magician check : working again.
• Mojo EPC importer : a couple of breaking API changes made/advised by Mojo's vendor. Implemented here.
• Cancel part on order book for workshop job. Under some circumstances (e.g. ordering the part a couple of different times on different spares invoices) would result in ord qty on workshop job being incorrectly updated. Now fixed

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

 

Whites Power Sports part renumbering.

Recently WPS renumbered their parts but their price file solution does not include a mechanism to supercede the old numbers to new.  Working with WPS we asked them to make changes to their their Price file API so that we can source old partnumber and link it to the new. WPS made those changes last week. This version of c9 includes further modifications to make use of those changes.

Spares -> utilities -> import price file. Pick whites and pick Whites Power Sports (New) import method. Push through and result should be old numbers  superceding to new numbers, like screengrab below

 

Bug fixes  and important tweaks

• Whites Power Sports price files, as described above
• PDF import for Toro.  Cope with fact that in toro parts the dashes as important and parts where only difference is dashes can describe completely different parts. e.g. : 3219-6 is a Hex Nut but 3-2196 supercedes to a Sheave. Made tweaks to PDF importer so it is a bit more Toro aware.
• Bugfix with unit sale, if sale fails to write, e.g. because you select No on reconcile alert, and then retry c9 will double up all GL postings. Now fixed.
• Stock take report tweaks and fixes
  • Retain capitalisation on floorplan make sections
  • Was incorrectly listing goods in with receipt units as not owned. Now fixed
• View spares invoice : would fail to show results if somehow operator created a circular graph of invoices now fixed

5Yamaha have published a new price file which includes very dramatic changes in pricing.

C9 cautions care with installing this price file with respect to existing stocking to minimise risk of losses.

For example, part 90176-10078 (NUT, CROWN) which fits a large number of bikes.

Prior to today, the part's RRP was 16.27+GST.  To buy it on stock it cost 9.52

Today, that same part's RRP is now 10.84+GST.

So to sell this part at todays prices for a part you brought a week ago, your margin has shrunk from 70% to 14%. Factoring in typical fixed costs, it is now a loss.

To help mitigate this, c9 contains some tooling which you can use to set pricing at prior RRP. Suggest you set pricing at prior RRP, and then over a few months revise pricing as you cycle stock through and purchase stock at newer, cheaper price.

Downside of this tooling is that you can only do this one part at a time. But you can click the button quickly to move through all your stocked items

• Spares -> Reports -> items repriced.

C9 will look to rush modifications to be ready later today so that you can reprice anything whose price has lowered as a simple bulk operation.  More details to come. [ Update: 5.2.41 version introduces a bulk price change option in items repriced report. Does exactly what it says on the packaging. ]

 

 

 

Giftcard refinements and cross dealership giftcards

This version of c9 does alot of ground work in order to accommodate ability to use giftcards between different instances of c9 for dealers who run multiple copies of c9 and want their different stores to share giftcards. In theory there is enough added into this version of c9 implement this but the feature is likely to be officially made available in mid November as further refinement and testing is likely needed. I need to press this version of c9 as part of progressing that work.

Functionally this version mostly fine tunes concurrent voucher locking & consumption between c9 store and website with more rigorous automated testing to verify all the various edge cases such as using a giftcard online exactly same time a giftcard is cancelled or modified in the shop for example, to make sure all the various timing issues are dealt with. This groundwork is essential for cross shop giftcard usage (for online sales it is less of a concern because actual transaction work happens back in the c9 system in store so remains centralised, but with cross shop giftcards, the txns happen in different shops so authoritative manipulation of giftcard balance is more diffuse and the shops need to coordinate precise status of a giftcard through all the things that can happen, such as cancelling a sale involving a giftcard, then undeleting that sale etc).

Work remaining on cross shop giftcards

• Configure giftcard prefixes to avoid giftcard # collisions
• make it impossible to disable online checks for c9 shops where cross shop giftcard sharing is enabled
• Define new Asset and liability codes for cross shop giftcard settlement, make sure these are baked into balance sheet and reconciliation tests.
• add new bank rec functions to settle cross shop giftcard settlement
• Verify issuer sync polling.
  • bake polling into scan giftcard and view giftcard to make it sync more instantaneously
  • Add server side sync poll so giftcard sync is faster.

Other tweaks and fixes

• Fiche diagrams. N/C Retail price displayed on this screen can be wrong in some circumstances. now fixed. PRoblem is screen doesn't pull back enough info in some circumstances. Specifics: packqty (likely a problem for BRP franchises because they code the price file to be packqtys), also daily/stock buy, for franchies where the dealer has configured a minimum margin in price breaks (rarely used but will be problematic for dealers who use this)
• add a setup switch in system/database to disable 4 hour auto logout feature recently added
• Add ppsr check button to add purchase unit screen
• Repriced parts : button to bulk reprice everything to older price, only for parts where older price is higher
• Tweaks and fixes with discount vouchers
  • Update Balance sheet so voucher liability excludes discount vouchers
  • Fix auto reconcile/reconciliation so it does not bark on discount vouchers
  • Long standing issue with contra GL code for discounts. Mixed 9-2600 and 5-5800.  Rationalised onto 9-2600. Deleted the code 5-5800
• Bulk bill pay / direct debit.
  • Customer BSB on screen was incorrect now fixed. (note exported ABA file is fine, just what was on screen was wrong).
  • Color code deleted lines so it is obvious when a highlighted line is also deleted (grey background, italic font). Previously couldn't tell if a highlighted line was deleted or not

Tweaks and Fixes

• SA Contract Paperwork
  • Include statutory cooling off rights  for used unit sales
  • New form : cooling off waiver
• Bugfix with add generic txn in bank rec screen. Under some exotic usage patterns the resulting posting can be a mashed together posting of 2 or more generic txns.  Now fixed. (abort txn on reconcile warning, change txn type and redo txn can trigger this behaviour)
• Some changes to help contend with with input credit pending floorplan bug fixed in 5.2.36 messing with reconciliation
  • Accounting reconciliation report: option to filter out auto adjust txns
  • Open floorplan report  - show gst pending figures at bottom of report
  • Open floorplan report - allow filtering on whether or not the floorplan came with an upfront tax invoice
• Print Payment remittance advise. Will print a detailed list of recociled txns instead of just the directly allocated txns. Only prints if following preconditions are met:
  • Is a payment or a billpay
  • all directly allocated txns belong to the same allocation event
  • all txns in allocation event tally to 0 and their allocation amounts match line txn amounts

Tweaks and fixes

• Estimates : heavily reworked estimates under structured estimates to be easier to use / drive. Uses alot of structures / idioms from website structure
  • Re-enable drag and drop. Was accidentally removed last time this screen was modified
  • Add website structure style move buttons
  • Reorganised how estimates display in structure. Previously any estimate younger than  3 months would display in structure. Now only estimates which are created explicitly in the structured estimates screen with display here.  For non structure estimates there is a checkbox on modify to drop them into the structured list of estimates.
• Website structure. Some low level tweaks in order to reuse the code here for estimate stuff described above. Some functional improvements
  • Inactive menu options are italic / grey
  • external links are blue
  • webclass customized pages are green
  • Smarter pre-expanded tree on opening window based on # of records in the tree
• bugfix with selling parts to a deal. If deal doesn't have a customer attached to it at time parts are ordered, on receive you'll get some screwy but ignorable errors that pop on screen at time of parts receive.
• constrain default discount manipulation on customer based on login. In login setting is a new switch. Enable it to constrain access to discount settings on modify contact
  
• linkint parts image downloader refreshed
• Low level bugfixs
  • Modify value of some unit connected txn postings via business -> activity, such as rebates would throw a nullpointerexception. Now fixed
  • Receive daily order. If you exit receive daily order, c9 wants to save work so far to a local file. IF this fails for some reason, e.g. windows file permission issue, c9 would throw a nullpointerexception. Now tidied to cope better with failure to save temporary changes
  • Under some very exotic circumstances with functions like modify connected txns, c9 could throw a NullPointerException. In specific case of modify connected a precondition of triggering the bug is you re-select the txn you are connecting : a redundant step so workaround is to not do this.  Now fixed (Bug in loadByQuery() optimisation when multiple txns but only one more needs to be loaded as others are already loaded )
  • Backdating a txn with deleted lines would fail. e.g. unit purchased flipped to goods only would delete bank payment posting. Then backdating that txn will not work. Now fixed (was not correctly materializing last supply/alloc dates on deleted lines, blowing up the db check constraints )

Since Friday (2-Sep-22) a number of c9 clients have reported c9 server down.

The common problem is antivirus software malwarebytes. It appears to be falsely identifying parts of c9 as being malware.

This is a reasonably common occurrence with antivirus software, known as a false positive. It is the first time this has happened wholesale with malwarebytes although.

The easiest/quickest repair to date requires changes to malwarebytes on server computer.

• Add the c:\c9db\ folder into malwarebytes exception list
• any files in malwarebytes virus fault which are in c:\c9db\ : restore them.
• restart computer

At time of writing, I am aware of 4 of our clients who have been impacted so far. The above repair worked for all of them.

As always contact support if still experiencing issues. Also consider using something other than malwarebytes. We consider the default AV built into windows, windows defender, generally adequate. It is difficult to make recommendations on antivirus, they are by design blunt and imperfect instruments: they generate false positives like this one, or false negatives (fail to detect an actual nasty), and there are plenty of actual cases where the AV software itself weakened security of the computer. So we are and always have been reluctant to give advise here, but internally, for windows computers we have at c9 we use windows default AV.

 

 

Tweaks and fixes

• Price file tweaks : clear variation info for superceded parts. Dataset is only useful for non super parts. Prior version would create extraneous variation datasets, especially with pricefiles that contain barcodes as well (e.g. monza)
• Update price file screen tweaks
  • Show age since supplier was updated in repo
  • Alert when a c9 update is needed to update a supplier (for future fenced repo versions)
  • Color code supplier list. Green: up2date. Red : needs updating. Purple : old or un-upgraded price file
• Bulk txn
  • Option to sort by supplier then date or just date (as it currently does)
  • Option to print bulk txn list
• Print deal part list : print deal no on the report
• sell parts to a unit. On the underlying created workshop job make sure job is tagged with default location.

Database: you need to log all terminals out during upgrade

Price files: Versions of c9 prior to this will no longer see price file changes. Keep c9 up2date to keep your pricefiles up2date

---

Contract of sale terms and conditions changes

On consultation with solicitors c9 engages to create T&C's on vehicle sales, new T&C's are included in this version of c9 for QLD, NSW, VIC, SA & NT

All T&Cs have a new clause added as per below to contend with current climate of significantly delayed supply + steadily increasing costs.

Importing Part variants as part of price file updates

Some suppliers provide some good data on variations, such as size and colour information. Especially useful for apparel & armor, boots/helmets etc.  C9 can now automatically grab this data as part of price file updates. Price files in repo will now encode this information.

To date this has only really being useful for websites. But variation info is now also merged into alernatives.

Initially implemented with a couple of suppliers (Fox and Monza). We will assess repo price files one at a time as we process them to see if we can extract anything useful from other suppliers.

Example screen grab. Key in a monza part number in point of sale. e.g. AS201201497914

Symbol next to part indicates it has variants / alternatives. For variant only parts the symbol is red, if part has alternatives the original blue symbol is visible.

Press f7 and you'll see the lot.

Alternatively on website, variants are selectable for customers to fine tune what they want.

Other changes and tweaks

• various -ve workshop bug fixes. Workshop job is in -ve because $ value of  returned parts exceeds rest of invoice.
  • display -ve sign on all costs tab on fields that can -ve : Modify job, View job, complete job. Pickup job.
  • -ve sign inputs for discounts on above screens could be break discounting on -ve lines too. Now fixed.
  • On pickup would through a low level txn error. Now fixed.
• Bugfix with specific serious of events of adding a payment. Now fix. Add payment. Start with billpay, select amount and instrument and back out. then redo as bill+pay, would blow up with journal error and then a NPe on retry. Now fixed
• realtime reconciliation alert. Accidently disabled in prior version in an attempt to silence it when used in unattended mode. Now restored
• activity report, option to export list of txns linked to AR or AP open as of supplied start date (sort of halfway option between accruals and cash for those what want to deep dive txn listing of open txns).
• Activity report / BAS in cash basis mode : with recent introduction of split payments, spit invoices might incorrectly double up lines in these two parts of c9 on cash basis reporting as each split payment will cause underlying txn to be considered for cash reporting. Now fixed
• Edit price file, attribute value was only 20 characters. Extended to 200, to accommodate recent inclusion of multi supers data as an attribute for KTM group brands.
• Website slider / carousel.  Removed ancient settings  which only applied for v1/v2 era websites. Added settings to control sizing and animation speed for current v3 websites
• Paperwork / contracts
  • Vicroads forms :use registered owner not customer on key forms, e.g. for insurance written off claims.
  • Vic, SA, NSW, QLD & NT : update T&C's to include price change clauses
  • SA Changes
    • used unit contract: was emitting new unit terms, not used terms. Fixed
    • Paper size for new/used wrong. Was US legal, switched to a4 and reformatted
    • Changed T&C font size to make it consistent with other states

Part number 47030005144  ( CYLINDER W. FLANGE 85 SX 07)

It fits A few different SX 85 models between 2006 and 2009

The part supersedes, but instead of superseding to just one part as has been the convention in automotive for decades, it supersedes to all of the following....

   format    |            header             
-------------+------------------------------ 
 0025060256  | HH collar screw M6x25 TX30 
 0402040980  | NEEDLE ROL.DIN5402 NRB 4X9,8 
 0603061001  | CU-SEAL RING DIN7603-6X10X1 
 0770540020  | O-RING 54X2 VITON 
 0770800021  | O-RING  80,00X2,00  VITON 
 47130006000 | CYLINDER HEAD 85 SX 
 47130038000 | CYLINDER + PISTON 85 SX 
 47137007000 | CONTROL COVER 
 47137008000 | GASKET CONTROL COVER 
 47137020000 | CONTROL FLAP 
 47137086000 | STOP PLATE 
 47137091000 | GASKET RUBBER

Now KTM have a facility to create parts which are kits, which explode into component parts ( making reading their invoices painful whenever this happens ). They could use this facility in order to super such parts to a kit, preserving decades long automotive convention of many to one mapping for supersessions, but for the time being they have chosen not to do this, at least not for all affected parts.

Baked into c9's latest price file is some data to help partially manage / mitigate this

You key in such a part number into c9.

The parts description comes up warning you part is a multi SS.

F6 the part. For non stocked items goto modify price file then goto attributes tab. You'll see all parts listed in there as an attribute. For stocked items it will be under the attributes tab.

At time of this post, there are <300 parts in each of the brands in KTM group (KTM/HQV/GAS) price files that behave this way so it is luckily a rare thing.

One final point, years ago during early AX troubles for KTM and supers were also quite fucked, we added a switch into c9 to try and cope with their broken price files, where it would not clear supers incase you added some supers manually in order to workaround their inability to provide accurate pricing/supers info (a problem that now persists today with SAP too). This setting will interfere with above price file changes as in these parts previously supered, but now they don't, but if this setting is enabled, then updating price file will not clear them out. So you now probably want to get rid of the setting.  Edit franchise, advanced tab. Make sure the option is NOT set. The screen in question. Make sure the green section is NOT ticked. So looks the same as below.