...
- SCOAFile
- AccountNumber
- AccountNumberPrefix
- ShortCode
- SCOAAccount
- ShortDesc0
- ShortDesc1
- ShortDesc2
- ShortDesc3
- ShortDesc4
- ShortDescription
- These columns increases the sql speed of reports and MPBM
_AS_MPBM_ServiceMapping
- NTDescription
- Added for contract and retension
Report changes
Sql's
- _asf_GetBalancesAllaccounts.sql
- The script is updated for 6.3
- Performance is improved
- _ASf_GLBalancesPerAccount.sql
- The script is updated for 6.3
- Performance is improved
- _as_sp_UpdateAccountType.sql
- The script is updated for 6.3
- Performance is improved
- The following types are added:
- 3100 - Property Rates by Usage [Revenue - Non-exchange Revenue]
- 3200 - Service Charges [Revenue - Non-exchange Revenue]
- Reporting - Create static tables.sql
- The script is updated for 6.3
- _as_SP_SetSCOAActiveTable.sql
- The script is updated for 6.3
- _as_MPBM_AccountExtensionAllVersionExtended.sql
- The script is updated for 6.3
- Performance is improved
- _as_GLAccountsFullMPBM.sql
- Has become depreciated
- Sagebudget.SQl
- Performance is improved
- _as_MPBM_Virements.SQL
- Performance is improved
- DataExtract Commitment.sql
- Performance is improved
- mSCOA DataExtract Budget.sql
- Performance is improved
- Added Full data sql to get the following:
- Actuals
- Actuals running
- MPBM budgets
- Sage budgets
- Calculated next budget type
- Virements
- Commitment
...
- Account mapping tool is upgraded with new features to make it easier and quicker to map between types
- Auto map tool that only maps accounts with 100% match between 6.2 and 6.3 (average auto map percentage is 80-90% of the accounts)
- Speed is significantly improved
- Solved a bug in the mapper where segments were not broken down.
- Solved bug where previous mapping was not picked up.
- Budget year end procedure:
- procedure is updated for 6.3 and checked for budget types 2
- Added more safety changes in the script.
- SCOA version switch
- procedure is updated for 6.3
- Switching between all version 6.1,6.2 and 6.3 is possible.
- improved performance.
...