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)

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

• AusPOST integration
  • Refinements to add support for Startrack and to support multiple accounts simultaneously. Previously assumed startrack would come along for free as getting eparcel working and would be integrated into a combined API. Turns out doesn't work this way. also turns out startrack requires some changes with API integration. (e.g. requirement to specify package type).
• Refresh Analytics/KPI Report for HD
  • Updated to work with 5.2 database changes
  • Review  + Update based on current set of fields sourced from opt2ma platform
• Receive spares
  • add button next to tally to quickly adjust pricing to fix up any rounding errors. Only accessible if current discrepancy is less than $0.02 per received item.
  • Bugfix with import PDF where tally of parts doesn't match invoice total : would not refresh "qty of items" display on the screen. Now fixed.
• Includes some updates targeting new dealers to c9, some low level tweaks to help us more easily migrate data from competitor systems into c9 as part of cutover (helpcr code to help migrate AR/AP txn lists).
• General ledger posting tweaks
  • Post 5.2 migration tidyup.  References on transactions where not migrated to the 'correct' spot. Now fixed (were copied onto the line not the posting). Now when you export activity or browse / export journal you'll generally always see pre 5.1 references when logging bills etc where before it might show blank.
  • Browse journals - Sort by date, not journal id
  • Browse journals - Export option which allows you to export to CSV and display more fields, reference & txn details, tax coding etc
• BRP EPC importer : now working again
• Other tweaks and fixes
  • Select transaction from add transaction : filter option no longer working, would throw errors on screen when you try to use it. Now fixed.
  • Order item miner query : was not returned results for cost. Now fixed