RSS Feed c9 logo Australia's best motorcycle shop retail software

More problems with suzuki price files.

Latest price file Suzuki have published has structural modifications in it which they did not alert c9 to, nor do they ever give us the opportunity to quality control the file before they make it available on their website. 🙁

The problem is manually priced items.  Luckily it can be fixed with a bit of fussing about. C9 will look at making changes to allow c9 to cope with the changes, making sure it is able to import either format, but it will not be ready at least until Monday morning.

Manually priced items are hidden in a xls spreadsheet in the suzuki file.

Originally, and for years the file looked like this:

mpold

As of now it now contains a new column and daily and stock lines are back-to-front:

mpnew

To fix this without updating c9,  you need to unzip the ZIP file provided by suzuki to extract the Manual Priced Items MC.xlsx file and then you import the xlsx file a second time using Generic method. Generally to extract file you can right click on the .zip file in windows and select 'Extract To..'.

Generic config I believe should work. One issue though is that in xls file  Suzuki are not using convention of RRP = list price + GST for all the parts, in their file RRP is a bit all over the place.  so I am unsure which column should be imported here.  Sticking with how file worked originally, I am tentatively recommending using list price (Retail ex GST), but it is quite possible that RRP in this file is Suzuki's recommended, manually set price. Ultimately a question for them to answer.

generic

 

Husky Order Export August 1, 2016 barney

A new method for getting orders to Husqvarana is now available in c9.  C9 recommends using this mechanism over electronic export. Although it is more fiddly, it is more reliable in that it provides active feedback on the order process whereas the export system designed by AHG involves throwing orders out into the void without any confirmation of receipt of the order. Hopefully in near future they will provide a more reliable mechanism, similar to the reliabile-by-design system provided Whites Power Sports.

Processing Summary

The process involves uploading a file into Husky/KTM dealer portal. So it is two step.

  1. Generate order file in c9
  2. Uploadf order in dealer portal

Read more...

Release 4.638 July 27, 2016 barney
  • Unit consignment fixes
    • Don't ask for payment method when cash customer is selected on consigment. No payment has been made yet
    • For account customer is selected, consignment would flip out and report a GL journal entry error.  Now fixed
  • Husky / KTM Integration Stuff
    • Create new format for KTM/Husky portal. Will include instructions on another post
    • Popup a warning on existing Butmac AX integration that integration is potentially unreliable and operator should use portal method instead.
    • Got Husky part enquiry working again, changes to husky website portal broke it
  • Misc
    •  New workshop other report that shows invoiced sublets based on date sublet was invoiced, not when job was invoiced out.
    • Bugfix: receive spares with no parts would not create GL records or biz activity record or record bill to be paid against creditor. Now fixed
    • Workshop recall.  Now possible to configure c9 so on completion, only jobs whose job types are configured as 'service' jobs will trigger recalculation of recall date.
      Config option screen shot (setup -> main setup screen -> workshop notification tab):
      service
      Need to make job types service types as well: Workshop -> utilities -> job types
      minser
Release 4.637 July 21, 2016 barney
  • Various integration fixes due to website changes
    • Fixed F12 Magician for Mcleods
    • Fixed import parts images for Mcleods
    • Fixed fiche import for dealernet (KTM/Husky)
    • Yamaha : show qty in Japan if none local
    • Mcleods : show availability day it not immediately available
  • Other / misc
    • Unit Stocktake report : include a summary at end of the report. Option to print summary only
    • Tweak how distributor data synchronization programmes are configured in add/edit franchise.  Looking at some new reporting programmes for a few major suppliers. More details to follow in coming weeks.
    • Tweaks to workaround/disable archiving of dealership units.  Archiving only applies for customer units
    • Add parts to workshop job via workshop.  Make sure customer is recorded against parts move record
    • Do not allow deletion of workshop deposits/withdrawals in browse activity screen

A number of useful integrations into WPS built into c9 (Birdman)

1. Send Orders

Insteasd of printing orders for WPS you can export them directly.  Instead of 'print' select export on a WPS order. Then select Whites Power Sports as export method.

selmethod

Then all you need to do is provide your email and password used to access WPS website.  C9 will memorize these so you only need to provide once. Once order is submitted that is it, click OK and you are done.

export

You'll see following on progress and success. That's it, order is sent already - no need to mess with files or websites or anything like that.

exportsuccess

2. Import Price File

Importing price file for WPS will grab price file direct from WPS, no need to mess with price file attachments. Spares -> Utilities -> Import Price file.

Select import method of WPS, then provide your WPS website username/Password.

pricefilemethod

3. Query Availability

Magician for WPS works as well. In point of sale, on a WPS product press F12 to query.  System may ask you for WPS username and password which it will then memorize.  It will show you availability at WPS and for other c9 dealers as well.

 

 

 

 

Release 4.636 July 13, 2016 barney

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

Improved Magician and c9 dealer integration further.

  • When exporting an order to another c9 dealer, if the order is an accessory order for a magician mapped supplier c9 will automatically select that dealer and submit the order as a web order to them direct into their c9 system. It will correctly map franchsies etc based on magician mappings. So you could feasibly order a mix of Honda + Suzuki + KTM parts from Bolton's for example on the one order.
    magexport

 

  • When creating an invoice via point of sale, at end of the process c9 will give you the option to automatically export parts on order from magician mapped c9 dealers direct to them. No need to goto the order book to fire these orders off for once offs. Can happen entirely in point of sale screen.
    autoorder

Other changes:

  • Bug fix with magician lookup. If no magician matches come up view supplier option for part mart is greyed out. Now fixed.
  • Website content.
    • Include a 'class' field which James will be able to use to make c9 powered website look even more mint.
    • Tweak spec sheet config to include pricing, webclasses and notion of whether an item is summary only or detail only
  • Import Kawasaki Fiche diagrams. Recent website changes broke import. Now working again.
Release 4.635 July 5, 2016 barney
  • Spares
    • Bug Fix : Credit invoice, delete one of the parts to credit and c9 would loose track of invoice being credited, also meaning info such as discount schemes applied on original invoice are thrown away. Now fixed
    • Import Generic Price file. System was only memorizing settings for first 10 columns in the imported spreadsheet, not all 12. Now tweaked to memorize last 2 columns as well. Generally only relevant for a couple of suppliers since most price files utilise no more than 8 columns in their spreadsheets.
    •  Magician
      • Suzuki Dealer Net Query. Looks like some website changes have broken c9 part lookup.  Should now be back to normal.
      • F9 will query all magician parts on order
      • View Order : new option to query all parts, not just backordered items
      • In Magician lookup is a new option which allows you to link magician supplier to supplier in your c9. If not found c9 will automatically create supplier for you. Similarly you can use this option to change supplier for part to be ordered.magc9supp
  •  Units
    • Uncollected rebates report. Separate report into two sections, sold and unsold units
    • Floorplan payout. Added a tool under setup to allow you to do a bulk payout of units on floorplan but sold. Payout is set to date of sale.  Defaults to units sold more than 30 days ago
  • Business
    • Map Xero supplier to c9 supplier : show xero suppliers in alphabetical order
  • System/Other
    • Cloud backup was not reporting velocity of updates like it used to: just showing either 'synchronized' or 'not backed up'. Now restored velocity data.
      rps
Release 4.634 July 4, 2016 barney

Bug fix : latest version caused an issue with web order merge customer details screen. Screen would not work correctly. Now fixed.

Release 4.633 June 29, 2016 barney

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

  • Contacts
    • Increase allowed size of address fields to better accomodate international addresses.
  • Workshop
    • Sell parts to internal department, departments would not be visible if workshop location was set to something other than 'Show all'. Now fixed
  • Units
    • Add terminal locking to deals, to prevent two terminals trying to modify the same deal at the same time, which can cause weird things to happen like deposit on deal being tracked being all messed up.
  • Spares
    • More work on Honda Dealer integration, hopefully almost ready to go live.
Release 4.632 June 22, 2016 barney
  • Fiche diagram import
    • Got Harley/Partsmart working again
    • BRP import. Try to cope with alternate part listings where price file description is same but analyzing descriptions of parts on a diagram with same reference # and extract the different text and adding it as a note to the item on the diagram.
  • Magician
    • Tweak Yamaha integration a little bit, hopefully more reliable now.
  • Unit Deals
    • Print Deal # on resulting invoices
    • Show deal number in units - > invoiced units. Allow printing of deal sheet
    • Show finished deals in Sales -> deals. Allow printing on either deal sheet or resulting tax invoice from here.
  • Spares
    • Receive order. If you select cancel on IRREVERSABLE operation warning screen in pickup and try again. C9 will popup an error screen about lock depths. Error itself is ignorable, but looks scary. Now fixed. (Caused by recent changes to only lock franchises at point of actual receive).
  •  Misc
    • Locked activity. C9 can be setup to disallow txns before a certain date, for purposes of accounting reporting.  But if a user attempts to then backdate and modify an old txn system will usually fail with random system errors without any clue to the cause being lock date.  Modified to give user more useful feedback to cause of the failure. i.e. see screenshot below
      txnlock
    • Previously old versions of c9 could have shortcuts that launch into specific parts of c9. i.e. c:\c9\startup /workshop would jump into workshop. This functionality was lost when new UI system came into play. Now restored this functionality.
    • SMS Replie: under some rare circumstances a SMS reply might get duplicated multiple times. In one instance saw a sms duplicated 1000s of times. Added tweaks to prevent this.
« Previous PageNext Page »