• Import fiche : include logic to detect if last import was aborted and allow user to resume the import.  Useful for doing full re-import when import source is unreliable (i.e. internet based import)
• Spares Point of sale : you can now sell parts to unit deals from within point of sale
• Order book : option to print order book
• Order book : option to move a part from Daily->Stock and vice versa

• Unit deals : option to receive onto floor a unit on order inside the deal itself.  Saves you having to back out and goto purchase.
• Workshop warranty: keying in money received on warranty would break GST component out incorrectly.  Now fixed. Fix will also retrospectively fix existing records
• Business activity : option to filter out workshop warranty invoices
• Unit finance sale : recording on business activity was incorrect. Now fixed.
• Unit purchase ergonomics.  Keying in reference that already exists would throw your data away and load in details of the duplicate unit.  Most often, you don't want this to happen, instead you want it to generate a new unique ID. Modified so it behaves the latter.
• Unit sale ergonomics in a deal.  Clicking back on a on-order deal would pop unit select browse.  Now fixed

• New fiche importer for Suzuki Online EPC.  Existing CD based import is still there but towards bottom of the list.  Recommend Suzuki dealers to do a full reimport of Suzuki diagrams.  This new importer provides a number of improvements.
• Older diagrams are hotspotted
• Diagram quality is generally better
• Algorithms for pruning diagram list, both units and diagrams on a unit are more sophisticated and better able to filter out units not shipped to Australia, and diagrams that do not apply for a given unit.
• Note that new importer, importing from a website, takes significantly longer to run.   Leave it running overnight.
• Import parts from EPC, such as YPIC etc.  Increase path length from 50 chars to 128 chars
• Receive Order. For workshop jobs print last mechanic/scheduled mechanic on the receive sheet

• New main menu function. Search. Type in a search term,  c9 will make a heroic guess at what you want to do and allow you to jump straight to that function without having to navigate the menu structure.
• Browse EPC Fiche diagrams. Allow a diagram to mix parts from multiple suppliers. Previously assumed supplier of a part was the same as a supplier of the unit.  Some things brewing with KTM/Husaberg WRT to this.
• Import price file, setup option to not include discount code in description
• Phonebook.  Print supplier list
• View deal : display ID on screen
• Import price file.  If import deletes a stock item because it's qty, max qty and 12 month sales history  is zero, write a line on the log report: Part X (Loc) is no longer carried.  C8 used to do this but this functionality was lost very early on on c8->c9 transition.
• Setup - database tasks. Added a couple of functions to rationalise part numbers from KTM/Husaberg's currently problematic price files.  More on this in a separate post.
• Unit floor stock report. Print reference, not VIN
• Bug: Print receive order sheet.  Sometimes it would falsely print units information for a list of parts which are not even associated with a unit.  This is purely a printing artefact, not a problem with the underlying database. Fixed report to not do this.

• New fiche diagram importer : BMW
• Sell deal unit not yet on floor.  type [..] button takes user to wrong browse. Stock types, not unit types. Now fixed.
• Purchase unit : tab keyboard order of floorplan entry fields was a mess. Now fixed.
• Manual backup : reporting error with dopea_pk_seq.  Now fixed. Note that backups generated which report this error are accurate backups.  The error message is a false positive error only and can be ignored.   Always ensure your backups are good by periodically performing a test/dress rehearsal restore from backup.  If you are not doing this, and don't want to do this, you really should subscribe to our online backup service.
• Unit open floorplan report : new filter option: filter by location:  sold or on the floor.
• email spares order :  default email subject to the name of the shop. Also include order # in the subject
• Workshop job types.  Default notes is only permits storage of small amount of text. Increased x4 (to match notes on jobs themselves)
• Finance company customer; forces customer type to account customer.
• Miner - various fixes
• Regression bug fix.  Sorting numeric columns would sort them lexically not numerically. Example. Consider numbers 1,5,10.  Numerically their order is 1,5,10.  Lexically their order is 1,10,5.
• Tweaked way miner query results are internally stored.  Removes the 40 column limit and makes memory/processing of miner reports slightly more efficient
• Export to CSV.  " chars where being escaped with \.  This is not valid CSV.  Proper escape is to escape a quote with a quote. i.e. " ".  Now fixed

Requires database changes. You will be forced to log all terminals out during upgrade

• Added warranty registration export for Honda and Stihl
• Added tracking for consignment units
• Fix for regression bug introduced with deals.  Ability to print paperwork via view invoiced units was broken and would crash c9
• Bug fix with clipboard.  On windows under very rare circumstances clipboard operations will fail and crash c9.  Fixed so graceful handling is that the clipboard operation fails but does not crash c9

Fixes for regressions introduced in prior version 4.316

• Analytics based reports, including profit summary no longer working.
• Quick Books synchronization contains a feature when you map a new supplier it would default payable/expense selection to the most commonly used one so far.  This was no longer working.

• Miner : added new advanced reporting sub system. See post below for more details
• Website : permit configuration of multiple separate website structures.  This is intended to be used to allow creation of multiple websites and/or different menus on a single website.
• Cash Till Report :  Control+T opens till
• Spares Profit Report : option to filter out web sales etc over counter sales
• Under some circumstances ability to remotely access database for maintenance/support purposes does not work; in situations involving change of IP addresses etc. Now fixed.

Includes database changes. Will force you to log all terminals out during upgrade

An ongoing difficulty with building C9 is coping with damaged price files provided by the knuckle draggers residing in the IT departments of some of the industry suppliers.

This release contains fixes/workarounds for a number of related issues

1) excessively large XLSX files that crash c9 due to insufficient memory on the computer.  i.e. Monza Price files should now import into c9 as is without difficulty; for the time being at least....

2) Price files that contain the same part more than once.  Previously c9 had no fixed rule about which part of a list of duplicate parts to actually import.  Sometimes it would import the first instance, sometimes the last instance.  C9 now strictly processes the last part encountered on the price file. Example, Monza again:

3) An optimized supercession checker on import price file to cope with price files with an excessive number of bad supercession chains. i.e. John Deere.  Other price file importers now run a little quicker too.

Includes database changes.  You will be forced to logout during upgrade

This version represents a significant overhaul on how unit sales are managed.  In terms of unit sales a number of key things have been delivered

• The ability to construct a deal over time.  A deal remains open and tracks details of the deal over an extended period of time. Possibly weeks or months.  So instead of having to feed in a sale into c9 all in one go, you can slowly build up a deal over time, from expression of interest to final closure.
• Proper costing of line items on sold units.  So you can more accurately track profit on things such as passed on/discounted/waived  pre-delivery costs, document/inspection fees etc.
• The ability, via deals to track and manage deposits taken on individual units.
• The ability to record encumbrances owing on purchased units at point of sale (or on a deal)

Other changes in this version

• Gift card bug fix.  Certain rare sequence of operations will damage a gift card and render it unusable. Workaround is to cancel card and create a new one.
• New price file importer : John Deere.
• Note : John Deere file contains a huge number of supercession (4oo k) records that mostly fail (mainly dead chains). C9's current supercession resolver on import is not terribly efficient, nor in the past was it necessary for it to be efficient.  But with John Deere file it takes about 30 minutes to trace busted supercessions.  TODO : modify import to use a more optimized supercession check.  I have a tested solution in play, that is at least x10 faster, but will not be part of this release due to time constraints. Next one probably.
• Import price file : remove MCS from list. MCS now publish an Excel price file
• Suggested max/restocking rule. Redesigned window so visually more intuitive.  i.e. do not allow user to tweak rules unless last stock order for franchise in question used historical analysis method of reordering. Also fixed a NPE crash bug.
• Workshop job screen.  A glitched network error while trying to modify job record could cause the job record to be damaged effectively deleting it.  Improved error checking logic associated with workshop screen so network problems are handled more gracefully (and non destructively)