Bugfix with printing spares invoices for statement runs.  Print runs involving any invoice that contains cost or margin based discounting would not print correctly. Now fixed.

• Images : display an image preview when browsing for images. So you don't have to open an image file to see what it is.
• Point of Sale ad-hoc/freeform/quick orders. Complete redesign to make it easier to use
• Easier to to select quick order or ad-hoc supplier order.
• Permit ad-hoc franchise order
• Permit specification of part number (i.e. part not on price file.)
• Give user option to add part to price/stock file if part number is specified
• Business : option to record cash taking on transactions where no cash was selected.

Note that this option should not be used to facilitate deferred payments/debtors; i.e. as a substitute for account customers and pickup later functions; and the screen says as such.  We don't want to encourage improper use of the software and a tool like this if repurposed to handle deferred payments puts you at risk of losing track of your debtors, costing you moey.  The tool is provided to complete functionality and to help with balancing cash till and to correct errors during point of sale.  Ideally, 'No Cash' option should be disabled and it can be disabled via c9 by configuring clerk keys appropriately, but we don't want disable it outright because invariably removing this function will have negative impacts as we suspect many shops regularly use it.

• Units : modified stock report so you can see stock at a given point in time, or current stock as of now.
• Analytics:  Deloitte Honda program changes.  Value of units changed to be cost price of unit; (less additional costs); not asking price. Also tuning selection a little better to better cope with sold units and split/merged units
• Catalogs
• Fix with Triumph : replace exotic characters that do not store correctly in the database.
• Fix with Triumph #2 : some notes on additional parts would not import. Now fixed.
• Fix with Honda and Yamaha (mainly honda).  On a diagram a reference can have multiple part numbers. Alternatives and old pre-supercession numbers. We don't want to show old pre-supercession numbers as this makes it harder to read diagrams. Prior versions simply ignored duplicates, but this inadvertently filters out alternatives.  Modified so it filters out superceded numbers but only if the new number is also listed on the diagram.
• Remove KTM PDF file import. Allow 'BUTMAC' as a franchise name match KTM Dealer.NET import.
• Online backup (technical changes)
• Verification cycle is now better able to detect when database has simultaneously changed, and is able to detect this mid verification and abort verification process midway.
• Removed a race condition in the process of retransmitting backup data and handling of subsequent backup ACK from server; the ACK could in theory result in wrong meta data sync records being removed. I cannot figure out a way that this bug could of resulted in improper backups, but a race condition and a race condition too many, so it has now been removed.
• Bug fixes
• Costmetic: Clear account details before printing spares order. so that if order is emailed, a spurrious account code will not appear next to the email in Notification History list
• Receive order. Print barcodes from stocked items on receive order would not include items that do not have an original order number. i.e. parts added ad-hoc onto the receive. Now fixed.

Sometimes you may need to do a forceful reimport of fiche diagrams; typically because of a BFU as Dave calls them; a type of programming bug.  Adding the ability to import catalogs into c9 is a fiddly and delicate business; and getting it spot-on is a significant software engineering challenge for us; our error rate for bugs in this part of c9 is substantially higher than our overall defect rate. Occasionally we will release versions that fix catalogue importers that require data already imported to be removed and import to be redone all over.

Following explains how to do this.

Read more...

Like a neighbourhood burglar alarm that goes off with the slightest provocation; backup error emails are really starting to annoy me.

Actual backups are working correctly. The problem is that the process of verifying that the backup is an exact copy of your database sometimes returns an error when in fact the databases are perfect replicas.  This sends emails overnight incorrectly stating that there are backup errors.

The cause is largely the recent addition of fiche diagrams into c9.  These increase the size of the database significantly.  This increases the time it takes for online backup to perform a verification cycle.  Because of the increase in verification time there is increased chance that while a verification is in progress, a change to the database is made that invalidates the verification.  Result : a false alarm.

I will rethink the design of online backups and come up with a method that eliminates the inherent 'race condition' (as it is known in IT lingo), that triggers the false alarm during verification.

Inclusion of fiche diagrams has been a great addition to c9; but it has not been without its technical challenges;  which we are slowly mastering and resolving.

Update: Worked out a better system. Deployed bulk of changes to our webserver. Will take a few days to monitor and ensure it is working as designed before complete migration to new verification methods; but if they are working correctly should provide instant relief.  Next version of c9 will also include some minor changes to remove some 'race conditions' that exist in c9 itself during the process of creating verification statistics; but this is a much lesser issue than the server issues now corrected. False alarms are generated mainly because of how our backup web server was doing its job of cross checking fidelity of the backup.  Another advantage of new system is that our webserver will generally be much more responsive.   Verification workload on server has now been significantly reduced. Previously, running verification would load the webserver so much you could notice a difference in performance when loading our web pages for example; but new design this no longer happens. Also, I expect that online backup will be alot quicker, especially when installing a new system, as server code has now been tuned for increased performance.

Bugfix with Triumph catalog import.  Was not getting unit list right. i.e. missing Tiger 800 XC

• Create new job : default to booked in or start immediately (in progress).  Option to toggle this is now available in setup.
• Add alternative part. Make user interface alot more intuitive by reusing existing 'Find any part' screen.
• Unit Rebate reports : show rebate both Ex and Inc GSTs
• Catalogs
• Added support for Triumph
• Modified Paul Feeney so it permits directly login to softway website. (MV Agusta and Husqvarna)
• Minor fix with web based catalogs. Was downloading catalogs 3 times. Web downloads should now be marginally quicker
• Catalog download: provide user visual feedback as to what download is doing. Useful especially for some web based downloads that have a long pause at the start of the process while priming the download by getting unit list and catalog list of first few units to process.
• Miner : after F4 process query. Provide ability to delete items in the list; so user can pare back a bulk email/sms list for example before doing actual send.
• Bug Fixes
• Sell parts on invoice; system  was not passing line item discounts onto account. So account statement differed from invoices.  Statement was not subtracting discounts. Now fixed (on future raised invoices only)
• Miner: recent changes to workshop meant that previously saved workshop line item reports that refer to line item totals and prices would not work. Now fixed.

• Profit Summary report. Improved and expanded.
• More detailed breakdown.  Now separates  Sales and COGS on the report.
• Workshop : reported labour is invoiced labour.  Previously was booked labour. Also previously was incorrectly including labour on estimates.
• Workshop : separate out profit on spare parts here
• Other profit reports
• Spares profit report; only report on credit note adjustments  which match other invoice types. i.e. if workshop+credit notes are selected, then credit notes reported are only credit notes on workshop jobs (and parentless credit notes).
• Units profit report: was not handling write backs correctly. Write back should subtract on sale profit an add to subsequent tradein sale. It was doing the former but not the latter
• Point of sale freeform: increase description size from 20 characters to 60
• Image manipulation
• Bug with resizing image window, clicking on size and apply in quick succession damages image size.
• Set business header logo or invoices. Use image resizing system to make managing/cropping dealer logo/header easier

Redesigned the layout of gallery items so that text in a 'cell' cannot overflow into the cell below it.  Generally visually improve the layout of gallery items.  Interesting software development lesson in all of this (about accepted wisdom of not using tables to express html structure), but won't bore you with the details.

Also redesigned checkout process so initial checkout page is hopefully more intuitive.  More suggestions here welcome.

Finally, fixed an annoying IE9 bug relating to browser compatibility.

This version requires database changes and will force you to log all terminals out during upgrade

• Overhaul workshop discounting, tax and profit tracking
• Workshop spares: track cost price for profit reporting. Defaults to current price for existing items on upgrade. (i.e. no profit on workshop items).
• Discounting Spares : differentiate between group discounts and line item discounts.  Parts discounted when sold to workshop job are treated as line item discounts.  Parts not yet discounted will be discounted by discount % set on the workshop job; i.e. group discount. This not only provides line item discounting in workshop, it solves a problem in prior version where you could accidently double discount a part.
• Modify spares pricing; modifying spares pricing adjusts line item discount to indicate spares discount has been awarded.  If price is set above current retail price, then retail price presented on invoice is raised.
• Spares : More accurate tracking of cost price for profit reporting.
• Default discount: do not set default discount on workshop job if account uses cost or margin based discounting.  These notions exist in spares only.  To apply them, you need to sell parts from spares to workshop setting appropriate discount
• Workshop item pricing : allow user to modify pricing to set either ex GST price or inc GST price; at users discretion. e.g. in prior version c9 would usually only track one price; i.e. ex GST for labour.  If you wanted to charge $90 in GST, c9 now internally tracks the line item as $90 inc GST, instead of internally tracking it as $81.82 ex GST and recalculating to GST; which can create some rounding problems.  e.g. $12.70 INC = 11.55 Ex. But converting from 11.55 ex back to inc the result is 12.71.
• Workshop spares: track whether retail price is inc or ex GST, as per above described behaviour. Note the above behaviour changes do not apply to default staff rates.  Labour line items will track modified pricing, but default staff rates is always ex GST.
• Business : in activity is an option to 'lock' c9.  Transactions inserts or modifications that occur prior to the current lock date are disallowed.  i.e you cannot delete transaction records or insert new transaction records or make certain changes for items that occur in a prior GST reporting period.
• Bugfix with database connectivity.  C9 is designed to invisibly reconnect to database on network error. But it should not do this while in the middle of a database transaction; because this violates database integrity. Modified c9 to not do this.  Very rare condition because typically transactions only exist for a fraction of a second and if there are network breaks prior to transaction start the process of establishing a new transaction corrects the disconnect. Yet I know of at least once instance where this has probably happened.
• Catalog fixes
• Web based catalogs would not save the last two units. You had to run import 2 more times to get these. Now fixed
• Recent change broke catalogs that use tif encoded images (i.e. Honda/Yamaha/Suzuki). Imported images would be tiny white images with nothing in them.  Now fixed.

Bugfix : online web order processing could send out emails with 'Bolton Motorcycles' hard coded into the email message. Now fixed.