Migrate to v5 tweaks

• On install v5 failure, make sure DB is reset back to a state where messenger doesn't think an upgrade is happening. Previously a failure would break messenger
• Migrator changes : see migrator changelog for details.

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

• Fixed up a couple of database tables in schema, didn't have a primary key. Would cause potential performance issues especially with online backup. One table in particular can be quite big.  Now sorted. (affected tables: authaudit and taxform)
• Under some exotic, forced circumstances it is possible to have deposits with -ve deposits. (when you force reclaim to be > then original deposit on F12 cust pickup). But in view invoice/deposit screen the -ve wouldn't show. Now fixed)
• Updated QLD vehicle inspection sheet form to latest

No functional changes, just tweaks to v5 migration stuff. This version is first post pilot upgrade candidate and could in theory be the last ever version of v4 c9 (likely there will be a couple more updates to cope with oddball data in some v4 systems as they are encountered).

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

This version fine tunes fixes payroll liability changes outlined in v5.1.10.  The liability fix was incorrectly tagging liability codes as input taxed. This ver removes this tagging as it is incorrect.

Tweaks and fixes

• Balance Sheet report, would incorrectly show banks in liabilities section under some circumstances. Now fixed
• UX ease of use improvement for post manual journal : open up GL select window instead of having GLs in a drop down list. GL Select window has some improvements too : is hot key searchable also shows todays balance on each gl code.

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

• Spares Credit to cash deposit would fail with a journal error. Now fixed.
• Unit sales : would post extraneous $0 GL lines for spare parts movement even when there are no spares. Tidied up.
• Included new powerful report under accounting reports.  "Reconciliation". It reconciles P&L against balance sheet and reports on transactions which fail to reconcile.
• Payroll general ledger changes. Previous versions of c9 were not very opinionated about how payroll events should be journalled and there were a number of settings in setup screen that modified c9s behaviour here. This is no longer the case. Payroll now journals in very specific way and this version backdated modifications to existing payrun journals to conform to this new strict model in order to properly support strict GL based compliance reporting. Specifically:
  • On finishing a payrun a journal will compose of following
    • NET pays are journaled as an expense, and CR'd against default bank
    • Tax withholding, super & and garnished salaries are journaled as expenses and CR'd against relevant liability codes.
  • Withholding/salary payout in bank rec (and BAS submit), DR liability code against whatever bank is being reconciled.

• Two small bugs that combine into a nasty bug.  You push through on a sale to print screen using cash, then back out and change to invoice payment. It will fail with a journal error because it tries to journal both invoice payment and the cash sale. You try again and this time it succeeds, but the txn that is posted doubles everything up. It balances but has 1x cash + 1x accounts receivable and 2x sale to balance it out.  Two fixes
  • clear payment function wasn't actually clearing payment. Now working
  • On error at txn save, completely throw away any new txns and force them to be rebuilt from scratch. This version of v5 is sort of blended v4/v5 tech where v5 still shadows alot of v4 structures. If v4->v5 construction fails we need to restart the process of constructing a txn. Longer term, pure v5 design won't work this way but this is necessary for time being.
• A number of bug fixes and connected to discoveries from ongoing reconciliation report work (report not yet in this version). Specifically:
  • Balance sheet changes
    • Include Pending input credits for both notional GST purchases and floorplan purchases. Split GST into input credits vs owing (previously these were aggregated into a single figure)
  • P&L / Trading statement Changes
    • Was not correctly reporting costs of consigned units.  Now fixed. Fix is retroactive for data migrated from v4. A number of refinements here to make P&L etc work better
      • New tax code : notional GST under consignment
      • New GL code : Cost of Consigned Goods Sold. Rolls into trading statement computation.
  • General Changes
    • On Road Costs, paid by dealer not being tax coded correctly. Now fixed

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

Fixes

• Refund spares to account. Would generate journal error. Now fixed.
• Bankrec delete : not working now fixed
• Bankrec tally, tally the adjusted close tally figure near top left of screen would change in weird ways when you toggle lines. Now working again
• Floor units, data migration issue. Floor stock concerns such as posted on stock floor valuation wasn't migrated quite correctly so when modifying floorstock c9 would think there were no existing records and it would recreate them, effectively doubling things up on the general ledger. This version fixes up these records and where double up has occurred, delete the older, incorrectly migrated record. (Root cause, migrator did not set loc_type correctly)

This version reworks how debtor/creditor/custdeposit txn records are managed. Migrator is working correctly, but newly created txns in c9 after migration were not presetting item/loc/origin style tracking. Generally not a functional issue, but will cause some grief down the road when we go for v5.2 changes. Some minor functional issues. e.g. on workshop payment to invoice, it would say 'payment' at bottom of invoice, not the correct 'On Account Owing'.

Another issue to fix is that v5 online backups downloaded are not restoreable. Data is fine, but generated schema is busted and needs to be manually tweaked before installing. (Incorrect priming/inferencing of primary key sequences on v4 txn tables).

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

• PC-EFTPOS/Tyro/Paypal integration. Was only sending base amount, not including rounding or surcharging. Now fixed
• Accounting period report tweaks
  • Added a v4 compatibility mode to accounting reports to yield same output as old v4 vs strict GL based generation. Key differences
    • Any supplier bills that post to Asset or  Liability code assume it is a capex txn. (Strict mode txns must be tax coded as capex)
    • Ignore GL postings for payroll expenses, instead consult payrun data instead. This is important where payroll is misconfigured to not post expense to liability codes on payruns.
    • Include 2-9030 on trading statement (Goods Yet to be Received)
• Bugfix with returning parts to supplier using option invoice later in point of sale where qty returned is >1
• Save BAS : tax code not being set for withholding expense (this is only relevent for mis-configured payroll systems, all payroll should be configured to track laibibilities. More information coming on this)

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

Version 4.890 was supposed to include the following changes but what was deployed didn't actually include them. This update backfills / fixes this up. Specifics:

• v5 migrate tweaks to get more systems able to push through migration
• WS scheduler changes to deal with unusual issue with locks leaving gaps in schedule
• Improved pricefile import handling of barcoded entries

Bonus changes:

• KTM EPC import, working again.