MPBM version 2.1.XX

Data structure changes

_as_MPBM_accountExtension

• iUDF column is added  to the table
  • Based on the provided mapping from NT the IUDF is looked up in the scoa view : _as_MPBM_V_A1ScheduleMapping
• Mtsf column is added to the table
  • Based on the provided mapping from NT the Mstsf is looked up in the scoa view : _as_MPBM_V_A1ScheduleMapping
    
    

_as_MPBM_accountExtensionAllversions

• Accounttype colum is added to the table
  • This column will increase the speed of all the reports/extracts and MPBM
• ucBSACOSAItemCombi column is added to the table
  
  • This column will increase the speed of all the reports/extracts and MPBM
• ucOSAFunctionCombi column is added to the table
  
  • This column will increase the speed of all the reports/extracts and MPBM

_as_MPBM_SegmentModelAllVersions

• 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

To call the sp with full data:

EXEC 
		_AS_SP_DataExtract
			 @StartYear = 2018	
			,@PrintStartYear = 2019	
			,@DataType ='Original Budget'			---Select 'Draft' Union all Select 'Original' union all Select 'Adjusted' union all Select 'Actuals' union all Select 'Virements'
			,@IncludeVirements =0
			,@Actuals =0
			,@IncludeCommitments =0								
			,@ReportType = 'Full system' 			--Select 'Full data' Union all select 'Duplicate check' union all Select 'DataExtract'
			,@ScoaVersion = 'mSCOA_V6.2'
			,@IncludeData ='AA-AR-BB-BN-V-C-SB'

• mSCOA BS .sql
  • Performance is improved
• mSCOA OSB.sql
  • Performance is improved
• Data extract - Actuals Movement only.sql
  • Performance is improved
• mSCOA BSAC.sql
  • Performance is improved
• mSCOA OSA.sql
  • Performance is improved
• Data extract - Actuals .sql
  • Performance is improved
• IDP extract.sql
  • Performance is improved
• _AS_MPBM_RME.sql
  • Performance is improved
• _asf_GetAgeingTransactions.sql
  • Performance is improved
• mSCOA Ageing SP.sql
  • Performance is improved
• Debit credit GUID listing is updated for 6.3

Reports

Trial balance pack

• • Trial balance pack is updated for 6.3
  • Trial balance pack used budgets from  the MPBM database
  • Trial balance pack shows Budgets vs Actuals

Report pack

• Report pack is updated for 6.4
• BVA - per account type V2 is added.
  • Based on the full budget extract
  • virement + commitments
  • Budget versus actuals
  • Difference MBPM versus Sage budgets

MPBM changes

Features and improvements

• Updated frontend framework to Angular 6. This provides increased performance and ensures maintainability of the application in the future.
• General refactoring and updates of backend solution for increased performance and future maintainability.
• Implement new license module
  • Increased stability of the license module
  • License contracts can now handle licensing of submodules (such as C&R, Arrears, etc.) so that we can control access to these modules without accessing the client's server
• Improved performance of account retrieval
• 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.
  • Solved bug where with loading the accounts to map
• 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.
• Rewrote the budget to sage push
  • Improved speed significantly
  • Uses the same logic as the data extract
    • with it the correct debit/credit logic
  • Uses the virements from MPBM to push these in correctly
• IUDF and MTSF fields on the AccountExtension
  • Added fields the account extension
  • These will be saved automatically when creating/updating accounts
  • Added display fields on accountsoverview grid and accounts detail modal
• Added loading data spinners on datagrids that were missing these
• Added return buttons on pages that were missing
• Created separate error message for all login errors that are not caused by wrong username/password so user will know when login failure is not his fault
• Improved the MPBM => Evolution implementation
  • Removed the necessity to fill in the login details for the Evo Admin user
  • Increased stability of this implementation
  • Increased performance of this implementation
  • This will mostly improve the performance of the C&R and Arrears Module
• Open changing password, whenever possible, user will not be logged out
• Virement changes
  • Added functionality to only allow virements on certain accounttypes
  • Added virement rules functionality
    • Must be in same department
    • Must have same MSC
    • Must have some project type
    • Must meet a custom percentage demand
    • Must meet a budget validation (either yearly or monthly)
  • Allowed to switch between a monthly or yearly budget validation style
  • Allowed to set a maximum percentage of the budget allowed (either yearly/monthly)
  • Allowed to copy virements
• Rate tariffs can now be retrieved from the server and used to create detail lines
• Sorted overview grids by code by default
• Improved information messages on several grids
• Added functionality to automatically set accounttypes on creating new accounts in MPBM
• Added functionality to all grids to toggle to the filter fields above all columns.

Bugfixes

• Fixed non-loading breakdown segments
• Fixed bug where when logging out, settings and database validation were remembered
• Fixed bug with refreshing municipal settings on new login
• Fixed bug with wrong navigation on budgeting settings
• Fixed a layout issue on small screens for the longitude/latitude fields of the SDBIP detail page
• Fixed a layout issue on the navigation page
• Fixed a bug where budgets weren't available for editing immediately upon reopening the budget
• Fixed a bug in account creation of Opening Balance
• Fixed a bug with loading default Cost segment
• Fixed a bug with the coordinates map modal

Arrears changes

Features and improvements

• Added per-service grouping and selection to the transactions available for arrangement. 
• Added initial transaction date to arrangement for proper handling of Sage transactions
• By default, only customers with outstanding budget will be shown
• Show outstanding amounts in the customer transactions grid
• Added functionality to multi-select transactions to include in arrangement
• Added functionality to reverse arrangement releases

Bugfixes

• Fixed a bug where customer transactions grid wasn't refreshed after creating arrangement
• Fixed a bug on the due installments page

Contract and retention changes

Features and improvements

• Improved information on the purchase orders grid
• Added a contract costs grid
• General performance improvements
• Improved performance of the SDBIP lookup on the contracts detail page
• New feature: Allow/block transactions to closed periods
  • By default transactions to closed periods will be blocked
  • This can be overwritten with a setting in C&R settings
• Added info field for the use of the account filter on C&R settings
• Added functionality to link and unlink transaction to the contract
• Added a savety check on 0 amount retentions
• Added summary to invoices, cessiont ransaction and release retentions
• Added a trigger that automatically links new transactions made in Sage to a contract found via supplier and the linked accounts SDBIP

Bugfixes

• Fixed a saving contract error
• Fixed a bug where sometimes the add button on cession transactions grid would disappear
• Fixed a bug with refreshing relevant grids on linking transactions to a contract
• Fixed some general layout issues
• Fixed a bug with refreshting transaction after releasing / writing off retentions

Performance and management changes

SCOA changes

• SCOA 6.3 database is added to the system
  • Views, SP and functions are updated with 6.3 data
  • New Account types are added
  • Mapping between 6.2 and 6.3 is created
  • MPBM 6.3 selection options are added.
• Updated the new (missing) 6.3 BSAC/OSAC and function mapping (see attachement Excel for overview)
• Update the _etblGLmSCOAAccounts table with new scoa version records
• Added NT A 6.2 schedule mapping to the database. Mapping can be found in the view : SCOA.DBO._as_MPBM_V_A1ScheduleMapping