Includes DB changes, you need to log all terminals out during upgrade

Tweaks and fixes

• DB performance tweak on cash till. Loading of till no list was not efficient, especially on systems with alot of history. Now fixed.
• General Ledger performance caching : gl tallies are cached automatically on month boundaries. To help keep the cache fast, automatically generate cache overnight for last 20 years of activity.
• Reworked unit selling / buying and rolling back so that relevant database records are explicitly locked and validated before operations go ahead to protect against undefined outcomes when a these operations are performed simultaneously on different terminals.
• Aged payables report: was incorrectly using creation date, not due date for determining age on some open txns (bills okay, but purchases or any other txn type would incorrectly work off creation date ), now fixed
• Print deposits for unit/workshop/spares deposits. Would no longer print reference the deposit applies for for deposits added since upgrading to 5.2. Now fixed.
• View txn details, unroll unit info a bit more so it is obvious what unit is being affect. Added a button 'view line details' to help with seeing txn line details. All this is to help figure out more easily what unit a factory purchase appears under
• Expand size of audit/id on some key screens for txn ids for systems with huge amounts of history

Heavy reworking of packqty logic especially around behaviour with pricefiles based on packs setting. Previously this setting would only influence pricing on stock file record and would only recompute on installing a price file. New changes:

• N/C stocked pricing : factor in pack settings so displayed retail price for example is sensitive to pack size and pack setting
• Recompute list & retail price when pack settings are manipulated in view change part
• Update prices : applies pack pricing
• Factor in pack settings on add part to stock
• Allow ecordqty to not be a multiple of packqty where orderpack setting is not for packs.

Part of this change is to help facilitate MCS price files. MCS price file contains alot of parts in pack form. Now dealers may wish to sell some/all of those items on pack basis or individual basis. The above design changes will help facilitate this. A separate post will be included to help explain how to effectively manage MCS stocking with respect to packs.

Fixes and tweaks

• Honda SAP Magician working again. (Tweak HTTP header payload)
• Cash till detailed report : was not printing instrument name for cash tills with a till no of 2 or above. Now fixed

Tweaks and fixes

• Newly added 'Items Repriced' screen looks visually similar to existing 'Items Below RRP' screen, but these two screen do very different, almost opposite things. Added some color and bold headers to help make it very obvious which one a dealer is in.
• Added facility to tag units for online advertising to target i-motor 3rd party platform
• Deals and unit sales : profit figures to show line margin (non spares invoice lines & passed on PD charges)
• Orderbook : new button to access received order the part was received in on

Note there are some changes to KTM / HQV PDF importer to try and cope with kit parts. On importing PDF c9 will now list the kit and it will list component parts underneath it, setting components to 0 qty and kit qtys + price as needed. How c9 figures out  kit qty is a bit complex and is an imprecise 'guess' because kit qty information isn't definitively encoded on their invoices but it should be accurate 99% of the time. C9 will warn you of kit parts where the kit qty is imperfect and require manual checking.

Example result below

As always with these ongoing improvements, provide feedback and raise issues as you run into them as we try to zero in on some viable solutions for problems/challenges our industry throws at us.

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

• Tweaks and fixes
  • Honda magician
    • Reworked magician code, something NQR about old code. (Rewrote to use std java http apis instead of apache httpclient)
    • Integration with Honda public deadstock website working again (with their new site addr)
  • Modify job : include button 'view unit', similar to UX design for view customer button
  • Previously reported bug with nullpointerexception on workshop parts positively identified and fixed (bind error view in selCustDailyOrder)
  • Paperwork for dealers in SA, default to SA (previously was defaulting to Vic paperwork)
  • View spares invoice : for spares invoices which are part of a complex graph of multiple invoices because of repeated use of 'merge invoice' function, some invoices would not be accessible / viewable because they did not land in the graph of invoices as expected. Problem only occurs in some very narrow circumstances and structuring of invoices. Fixed in this version so should work for all possible ways invoices could organise.

Something broken with 5.2.16, pc-eftpos integration not working with it.

No actual bug in the code, I suspect some sort of issue with compilation of code into program. Did a full recompile. Okay now.

Includes DB changes, you need to log all terminals out during upgrade

• Tweaks and fixes
  • Bank rec and cash till : tweaked some times to improve database performance. Significantly snappier on systems I tested ( nested SQL procedures do not seem to be optimising well. Rewrote core query as plpgsql function, stored ref/prior rec ids in temporary variables. The resulting plan is essentially the same but it is significantly faster, suggests STABLE flag on prior/ref stored procs is not working as advertised and might be getting executed multiple times. Some more testing strongly suggests this is indeed the case )
  • low level v5 changed to help improve data migration tooling. (allow dbtool to hook into any JDBC database, not just c9 postgres. Improve performance of TrImport using cursors and some logic fixes on job batching not isolating self contained txn runs perfectly)
  • Couple of reports of add part to workshop triggering nullpointerexception. Problem likely caused by a closed table in a view which is triggered when keying in a part on order (pops select customer order screen). Added some guards to prevent tables from being accidently closed on main thread.

• Tweaks and fixes
  • Billpay fixes and tidies: all fixed
    • Edit transaction - would not let you modify due date on spares receival bills.
    • Browse unpaid bills, would not show spares receival bills.
    • Pay selected bill in unpaid bills : would not  allocate payment to selected bill instead would instead use default logic of paying txns from oldest to most recent ordering
  • Biz activity report and recently added cash reconcile
    • Removed BAS - Cash basis as an option. Instead add a new option to report on accruals or cash, separate so can apply irrespective of tax code filter selected
  • Piaggio Group EPC importing : up and running again
  • Stihl Warranty export : change fuel question so it is tri-state. Instead of checkbox is now a radio with 3 options: Yes, No or N/A (N/A applies for things like electric items)

Tweaks and fixes

• Reworked cash reconcile / GL Reconile report into a new powerful report that generates partial trial balances from the general ledger allowing various groupings / filtering. For example get a list of all GL postings touching BAS tax codes and/or cash instrument codes, aggregated by txn type. Useful as an alternative source of data for extracting and moving data into an external accounting product (as opposed to using biz activity report)
• Bug fix : print statement for combined trial balance. Extracted open/close balance is wrong and would report historical aged balances as all zeros no matter what. Only a problem in combined statement mode, worked fine otherwise. Now fixed (Bug introduced on migration to 5.2)
• Edit deal : add calendar convenience functions for promise date

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

Tweaks and fixes

• System would incorrectly warn about late balance threshold issues for accounts with a $0 balance owing. Logic/test was not written correctly in 5.2 changes. Now fixed.
• Unattended Messenger's are supposed to auto upgrade. There has been a long standing issue where upgrade would get stuck in a loop and keep spinning every minute firing off a new messenger. Thought recent changes fixed this but problem is still happening. Found a new possible cause of issue, now fixed in this version. When running multiple copies of c9, 2 or more JVMs could be running, especially on older, resource constrained systems : it is possible messenger is in JVM #1 and is triggering JVM #2 to restart, thinking incorrectly it is restarting itself. Added some logic to force restart initiator to forcefully shutdown. The problem may still occur on updating to this version, but followup updates should hopefully now be okay.
• 5.2 cash basis BAS was not implemented. Now fixed. (Cash basis query is alot faster in 5.2)