NEW1.06.07 · Released 27 March 2013
- Opened13 Mar
- Closed15 Mar
- Released27 Mar
Reporting; Query optimisations and other minor changes
The following optimisations have been made in the Account Control query:
- Account Classes filter only included if neccessary
The following optimisations have been made in the Account Credit Card Expiry query:
- Account Classes filter only included if neccessary
The following optimisations have been made in the Account Exception List Account Correspondance Exception List queries:
- Account Classes filter only included if neccessary
- Account Statuses filter only included if neccessary
The following optimisations have been made in the Accounting Ledgers List query:
- Accounting Ledger Status filter only included if neccessary
- Account Classes filter only included if neccessary
The following changes and optimisations have been made in the Bank Account Suspense Item List query:
- If Allocated column is included, the BankTransactionPk column is forced to include
- If AllocatedTo column is included, the BankTransactionPk column is forced to include
- Question marks shown on the end of the 'Show Deleted' and 'Show Unallocated' parameters
- Was always joining on BatchHeader and GlExport tables
The following changes and optimisations have been made in the Bank Transaction List query:
- Minor structural changes
- CreatedUtcDate column is not longer always included
- ProcessedExternal columns can now be included, grouped and filtered
The following changes and optimisations have been made in the Client Invalid Address List query:
- ClientContactAddress.Pk column renamed to 'Pk' as per other queries
The following changes and optimisations have been made in the Australian PPSRG2B Transaction List query:
- Minor structural changes
The following changes and optimisations have been made in the New Zealand PPSRG2B Transaction List query:
- Minor structural changes