Fixes and tweaks

5.2.1

• Select transactions to pay for creditors (and deposits) got direction back to front. Now fixed
• Added new field on select transactions / view transaction screen. ext reference. Shows unit vin for some key txn types

5.2.2

• Add transaction : email receipt would throw a NPE error. Now fixed

5.2.3

• Fixed long standing bug with rebates screen : rebate tally would incorrectly also tally provisional rebates logged onto deals in progress.
• KTM shop / magician check : now working again.
• Trial balance screen : tweak for some performance gains (some more work to do here to improve further)
• View account : view parts on order. Show creation date
• Units reports : add filter for units on/not on deal for key reports Being:
  • stock list
  • open floorplans
  • stock take

This version is the pilot release for c9 version 5.2 . It is being made available to a small # of dealers only.

v5.2 reworks money balance tracking systems in c9. Specifically:

• AR & AP balances
• Deposits : customer, spares, workshop and unit deal deposit tracking

Reworking improves a number of things and capabilities moving forward for c9. Such as improved pos experience and improved historical deposit reporting capabilities.

Tweak : unit sales / profit report. Under some fairly exotic circumstances report could incorrectly calculate a line margin for on road cost lines. ORCs never have a line margin. Now fixed.

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

Tweaks and fixes

• Added SA sale forms (contract of sale, form 2 + form 4)
• Performance bugfix with customer filter. Some filters can cause c9 to grind to a halt. Some tweaks here which hopefully fix up some pathological cases in database query performance (search for something like kvak0 breaks into two full texts, 'kvak:*' and '0'. '0' will often seqscan because of its huge hitrate which of itself isn't terrible, but in context of original query with tsquery aggregates etc would generate lousey performance, reworked design of query so now alot faster)
• Profit summary bugfix. Spares profit reporting was quite borked and has been for some time probably and would not return much data for spares. Now fixed (query issue with null columns and dealing with invoice sales where invoice lines have not been merged onto another invoice )

Tweaks and fixes

• Print order receive report. Would incorrectly print notify disabled for invoices where notify status is not set now fixed
• Bug in c9 means we cannot invoice out February rego lookup invoices because we didn't log which dealers did the actual queries.  So rego lookups in Feb will be free and c9 will eat this cost. Now fixed in this ver. Prev versions of c9, rego check will no longer work. You need to update to this version of c9 to regain this functionality

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

This version refines a step in 5.1.65 about hosing out useless supp.format metadata out of pricefiles.

For dealers who are installed 5.1.65 already, this update will be non functional. But for dealers not yet updated, this version applies this fix in a more thorough/efficient way. Also if forces DB upgrade lock to make sure the job is done.

Backstory: c9 now includes the ability to magically reformat part numbers from suppliers who don't bother to format them nicely for our eyeballs but retain the suppliers formatting where needed because some suppliers not only kill off spaces and dashes, but they leave them in some parts and representing them this way is essential for processes such as electronic ordering 🙃. The solution is a bit of a quick and dirty cludge in that it parks the supplier formatted number as a price file attribute and uses that at key points (order export & magician query), and the underlying problem is a complex one. But hopefully now it is sorted / robust.

• Tweaks and fixes
  • Supplier part number reformat writing. Fix a few bugs and issues here
    • supplier format issue could result in that part picking up the last parts valid supplier format string. Now fixed
    • Efficiently hose out unused/ unneeded blank supp.formats . These make price files a bit messy, especially the repo.
    • Recommend anyone how has done a part number reformat previously to redo it after updating to this version, especially KTM franchises. If you don't know what this means, probably doesn't apply to you.
  • KTM MAgician
    • Rework output for a part with an eta order so it shows 0 (ETA:date).  Backorder magician will no longer incorrectly green these
    • Disable website supplier check for KTM and Husky. Doesn't work and even if it did, it is too slow.

Tweaks and fixes

• Obscure bug with v5 migration. v5 migrated workshop jobs where the jobs where invoiced but then reopened in v4 and were open at time of migration will not migrate to v5 correctly. Subsequent operations on the job will not journal correctly. Now fixed in this ver of c9.
• Part of cancel pickup, make sure any cust deposit txn lines are also flagged as deleted as part of deleting txn lines

Fixes and tweaks

• New rego query was not correctly presetting free option for relevant states (QLD, NSW). Now fixed
• Bankrec : under some circumstances bankrec would not correctly identify most recent bankrec and will preset start date to start of current month. Now fixed. (bankrec was looking at insmask which was retired ages ago instead of looking al GL codes for figuring out latest bank rec)
• recently added supplier part number format facility : would send the reformatted part, not supplier part # to magician queries. Which for some supplier will not return results. Now fixed.

Includes DB changes you need to log terminals out during upgrade

Changes and tweaks

• New rego lookup facility
• BAS : option to computer payroll component based on last month in the period only
• F2 lookup. Visually indicate whether or not parts are the end of a supercesion chain.  Knowing this can be handy in some situations, (e.g. on picking and old parts have not been retagged yet).
• tweaks to make install and upgrade of v5 more robust after some issues with a dealer who recently updated. Only impacts dealers who have not yet installed v5 (vacuum analyze key txnengine tables post migrate. Make sure failed upgrade can reliably re-do various bankrec changes)