Page History

Table of Contents
indent 10px

Installation

Please download the beta version from :

www.asamco.com/Software/MPBM/MPBM.2.0.0.0.zip

Installation steps can be found in the following page:

...

• MPBM database must be on version 1.9XXXX
• The MPBM database must NOT contain any validation errors.
• This release can only be used for internal testing.
• This release must not be installed at clients.
  
  

Find below the latest version of the validation script, needed to prepare for the prerequisites:

• Please run the script to add the latest validation script into the database: _as_sp_MPBM_ValidateDatabase 6.1.sql
• To run the validation, please use the following sql:
  • Exec _as_MPBM_ValidateDatabase6_1
    
• Some errors can be prevented by starting with:
  
  • Pushing in all accounts to Sage.

Release notes

Release notes new version MPBM; Front end 2.00.00 ; Back end 2.0.0.0 ; Database version 20

...

• _as_MPBM_AccountExtensionAllVersions
  • Name and SCOAversion
  • SegmentModel0Guid,SegmentModel1Guid,SegmentModel2Guid,SegmentModel3Guid,SegmentModel4Guid,SegmentModel5Guid,SegmentModel6Code,SCOAVersion
  • SegmentModel0Code,SegmentModel1Code,SegmentModel2Code,SegmentModel3Code,SegmentModel4Code,SegmentModel5Code,SegmentModel6Code,SCOAVersion
  • AccountExtensionId and SCOAVersion
    
    
• _as_MPBM_SegmentModelallversions
  • Code and SCOAVersion
  • NodeGuid, InternalBreakdownNumber and SCOAVersion
    
    
• _as_MPBM_BudgetLine
  
  • BudgertYearID and AccountExtenstionID
    
    
• _as_MPBM_Budgetyear
  
  • SDBIPGoalsID and BudgetType
    
    

_as_MPBM_SDBIPGoals

• SDBIPID and YearID

Version 2.0.0.3 Updates (Released 3 PM - 15/03/2018)

• Revised the deletion of objects within the MPBM
• Update on editting account description in MPBM
• Checkbox to show previous SDBIP years
• Budget year end procedure adds new SDBIPGoals and Budgetyears
• Budget year end procedure sets the old current year on Approved, and final as active
• Budget year end procedure sets all outer years  budget types to approved.

Version 2.0.0.4 Updates (Released 5PM - 16/03/2018)

• MSCOA tree in settings, in which you can preventions of selection/showing of budgets.

• SDBIP version selector is removed. From now on only the current SCOA version can be selected. (Automated)

• Fixed on SCOA switch truncation error _etblGLSegments (based on Ulundi database)

• Updated the ActiveSCOATree storedprocedure to handle the visible and active columns.

• Rewrote code to push in the budgets to Sage.

• Budgettracker is updated to Current year Outeryear 1 and 2

• Update on editting account description in MPBM (Fixed bug when not clicking on pencil)

• Account mapping report overview is updated with more details and layouting is fixed

• Updating the mapping in 6.2 while having 6.2 active, will update the _as_MPBM_AccountExtension and _as_MPBM_AccountExtensionAllVersions (_as_MPBM_AccountExtension will get status 5)

Version 2.0.0.5 Updates (Released 2PM - 19/03/2018)

• On mscoa creation, MSC segments pre-selected by Function will appear on the top of the grid
• Added UDF's to Accounts table to indicate the mapped accounts in Evolution (will be updated at db upgrade, and with sage push)
• Fixed column display error on Account Mapping Report page
• Estimated Costs are mandatory for the current year + the two following years
• Superadmin passwords that are still 'superadmin' will be updated to the password provided by Dumisani. (please contact Asamco or Dumisani for password)
• Fixed error opening new budget type on SDBIP
• Default budget page to the Active budget type, not the latest budget type
• Added Current Scoa Version and Rolling Year to top nav bar
• Menu and logo do not overlap anymore

Version 2.0.0.6 Updates (Released 10PM - 19/03/2018)

• Fixed error when adding budgets
• Fixed problems caused by trying to select the 0th account to map
• Functions can no longer link to multiple MSC segments
• Costing segment is default to "Default" in mscoa creation across all SDBIP
• Account Mapping Report references the SDBIP
• Added loading message to Account Mapping Report, SCOA report, SCOA master-detail report and Old & New report
• Removed segment defaults from KPA

• Loading bar on Segment links

Version 2.0.0.7 Updates (Released 6pm- 21/03/2018)

• Hotfix on mapping feature for MSC, which was causing errors. 

Version 2.0.0.8 Updates (21/03/2018)

• Fixed issue on account mapping, preventing the display of a segment.
• Updated the Budget year end procedure, old version caused errors in new budgetheaders.
• Added safetly check to prevent having accounts on lower version than the current MSCOA version.
• Switching budget years only allowed to a higher version than the current year
• Fixed issue where no new budget type could be created after switching to new budget year
• Added auditing to the all versions tables (AccountExtension, Accounts and SegmentModels)
• Extra security checks on saving of budget lines
• Prevented timeout of database backup on scoa and year switch
• Updated message during mass approving of accounts because this functionality does not take hours anymore!

Version 2.0.0.9 Updates (26/03/2018)

•  If Draft is not the first type, when adding a new type draft will be the new type.
•  Backup functionality is removed from switching SCOA and Budget year (Timeout should not be happening now)
• Added button for backing up database (This will might not work, due to timeout)
• New SDBIP Budget year/type is started with Draft.
• Updated validation script
• Fixed break bug in system, causing account not to save.
• Budget year amount validation is only applied on current budget type
• Login and logout functionality is improved.
• Mapping is improved to ensure that all segments are saved with all segments (backend check)
• Mapping timeout and sql improved for loading accounts to mapp.
• increased version number to 23. Front end to 0.9

Version 2.0.0.10 Updates (27/03/2018)

• Login and logout functionality is improved.
• Updated validation script
• SCOA switch is improved to facilitate new MSC's
• Mapping functionality is improved.
• Accountmapping report is corrected

Version 2.0.0.11 Updates (28/03/2018)

• New validation rule: Item expenditure cannot be linked to non-funding transaction, except for default expenditure
• New validation rule: Capital projects can only be linked to capital funds
• New validation rule: Operational projects can only be linked to operational funds
• Fixed an issue with editing accountextensions when there is no MSC segment
• Ensured there are no hanging top navbar buttons on the overview pages
• Fixed title of the MTSF page
• Corrected notification texts on Opening Balance
• Fixed text on budget year approve button
• In a new virement batch, created by user is new filled in to the logged in user
• Fixed issue with empty lookup title bars
• Made the budget type overview read only
• Estimated Costs are now only required when there is a budget corresponding to that year
• Fixed validation issues on the master data screens
• Fixed issue with category defaults page showing an empty page
• Fixed issue hanging while saving new sdbip 
• Fixed issue where delegation page was not inline with format of rest of application
• Fixed issue with obsolete delete delegatee button on delegation screen
• Budget validation only on current year
• General setting on connection string for sql connection timeout allowing us to prevent all future timeouts

Version 2.0.0.12 Updates (29/03/2018)

• EmployeeId must now be unique
• Fixes to employee validation process
• Master sub account laten zien bij budgetten grid, descriptons in 62 zijn niet uniek
• Fix issue where segment defaults were not working on the SDBIP
• Fix Adata issue in EvolutionModule
• Fix issue with new budgets being created on edited invalid accounts which caused an overwrite of any existing budgets

Version 2.0.0.13 Updates (05/04/2018)

• Fix issue with Sdbip overview loading double lines
• Update FinalToOuter stored procedure
• Update DatabaseValidation stored procedure
• New feature: validation rules are now toggleable.
• Added extra security check to prevent switching of sdbip years
• Prevent issue of pushing editing accounts taking up the wrong accountlink
• Fixed issue where segment model is not saved if it doesn't exist yet but there is an all versions copy available

Outstanding issues

• Revise core / Non core to be done per function instead of global. 

• Prevention of switching of SDBIP years, if we have budgets linked.

• Amounts can be added on funding segment level. Budget amounts are compared against the fund/grant limits.