Moorgate.1.4.715.689 is available

There is a new version of Moorgate available from the Twenty57 website.

The main new feature is the significant changes to the Finswitch Confirmation File import and error handling. Moorgate will now import all the confirmations in a file that it can and provide you with a screen to handle those that failed.

• New screen 'Failed Confirmations' that lists all confirmations that could not be imported. This screen can be reached from the dashboard and the Transactions menu.
• Links to the Static data screens to update Moorgate data when mapping failed.(Confirmation File Import Missing Account Action setting on Product Company setup is set to Fail)
• New Setting on Product Company Setup: Confirmation File Missing Balances Action (default is Ignore). If set to Ignore Records on the Finswitch file with no balances are accepted automatically using the Moorgate balances. If set to Fail they will appear on the Failed Confirmation Screen for the user to follow up on.
• For missing Balances or Opening Balance on the Finswitch file does not equal Moorgate's previous Closing Balance the user can verify the batch and capture any missing transactions directly if needed.
• Failed Confirmations can be removed completely without fixing them. The user will then need to capture them manually.

Additional Features and Bug Fixes:

• Exclude Balancing Entries from the Unresolved Transaction Count on the Landing Page.
• Include the Static Data codes on the View Transactions across Accounts and View Confirmations across Accounts pages.
• Account selector breadcrumb: correct dependency of Product Company, Product, Fund Company, Fund and Account.
• Bug: Error when capturing first confirmation movement on an account.
• Bug: Match note was not populating with the Auto Match Rule name.
• Bug: Multiple matches were combined in one match.
• Bug: Balancing Entry Type ID was shown instead of the name in the matched section of the manual recon screen.

A very big thank you to Anand and the team for this build. There was significant development needed to change how the Finswitch file logic works.

Please send me all your feedback. The Failed Confirmation screen and Error Handling process are new concepts in Moorgate and need your input to become even more streamlined and useful.

Integration with Finswitch - the next step for Moorgate

Finswitch Trade Confirmation and Price files can be imported into Moorgate. But it is still a manual process. And Confirmation files can have a number of exceptions which currently need to be dealt with one by one - a very tedious exercise. So we are fixing that.

We are currently busy redesigning how the Confirmation file is processed in Moorgate. Instead of rejecting errors one by one, we will import the entire file, apply ordering to it to ensure the accounts and transactions are grouped together correctly and then process what we can and provide an interface within Moorgate to handle the exceptions - static data issues, balance issues and the like. Expect this functionality in the next 2-3 weeks, if not sooner.

Once that is done we will be able to automate the download of the Confirmation file from Finswitch using the available web services and automatically import it. The user will then just need to address any exceptions.

Price files are available at 6pm daily - using the web services we will automate the download and import of these too.

Finswitch is also now providing the ASISA generated Quarterly Asset Allocation Data through their system. Moorgate will be enhanced to download and import this data to minimise the need for manual capture and allow you to do your Asset Allocation Reporting more quickly.

And as a final cherry on the top of Finswitch integration we will provide a Finswitch format Transaction Request file from the Authorised Market Actions which can then be automatically uploaded into Finswitch if required.

These enhancements will make Moorgate the obvious choice for any company in the South African market looking for Unit Reconciliation software. And of course make the daily processing for our current users even simpler.

Moorgate Build 1.4.673.595 is available

The latest build of Moorgate available on the Twenty57 website contains bug fixes. Most of these are to the Market Action Process and Screens. The approach to dealing with Market Actions in Moorgate is very different to Unit Recon but I think we have ironed out all the kinks now.

Bug fixes are:

- Bug: Proposed amount is calculated in cents instead of rands in initiate market action screen.
- Bug: Incorrect values are displayed in proposed units field while initiating market action having units >= 1000. - Bug: When units column is placed anywhere except position 3, the wrong value is shown as proposed units in initiate market action screen.
 - Bug: Numbers on market action and initiate market action do not have space as the thousand separators.
 - Bug: When trying to remove confirmations, a datetime/string conversion error comes up when DateDisplayFormat is set as dd/MM/yyyy.
- Balance Check on Transaction Imports only looks at Import Batches and not at Balancing Entry Batches.

The next development work planned on Moorgate is better handling of Finswitch Confirmation file import errors (allowing all correct confirmations to be imported and providing an interface to edit the rejected lines) as well as the ability to reject an Authorised or Initiated Market Action.

Thanks to Anand and the team for all the development done.

New build: 1.4.668.583

Moorgate has gone live at a client. There have been a few hiccups but on the whole it seems relatively smooth and is working well. Well done to the implementers on supporting it to Production and over these first few weeks.

This build adds some urgently needed functionality to the Manual Recon screen that had not been picked up on before. You can get it from the Twenty57 website.

• Single-entry matching is now allowed
• Same-side matching of Confirmations which have a unit difference within the Fund tolerance

A big thank you to Anand and the team for the quick work in getting this build out.

I hope everyone has a wonderful festive season and New Years! May 2012 send Moorgate onto greater heights.

Moorgate build 1.4.666.579

There is a new Moorgate build available from the Twenty57 website, version 1.4.666.579.

The following features have been added:

• Confirmation Capture: Exposed the Management Fee column.
• Landing Page: Selecting an account on the Landing Page will navigate the user to the Manual Recon screen.
• Calendar Control: Highlight the current date.
• Manual Recon: Load the last used profile by default.
• Webhelp URL: Is included as part of the install so it is immediately available to users.

And Bugs fixed:

• 'Clear All' button was disabled once transactions were moved to the matched area
• Proper Handling if the service is restarted and the database connection cannot be made to ensure any process definitions are loaded correctly. Please add following attributes in <appSettings> of Twenty57.Moorgate.ProcessService.exe 

•  <add key="ServiceStartMaxAttempts" value="3"/> to configure no of attempts to check whether DB is up. 
•  <add key="DelaySecondsBetweenAttempts" value="60"/> to configure time interval between 2 attempts to check whether DB is running.

Thanks to everyone for the great work.

Moorgate 1.4.649.541 is available for download

There is a new Moorgate build available on the Twenty57 website. Version 1.4.649.541 has some changes to the Tag screen.

1. Bug Fix: Tags can now be deleted.
2. Tag Screen ordering is defaulted to ID desc (so the newest Tags are shown first).
3. Tag Create Date has been included in the filter and the grid.

A number of client sites are close to Go-live. Good luck for the production switch over. I look forward to hearing how it goes and what your experiences are when you start using Moorgate daily.

Moorgate 1.4.643.529 available for download

There is a new Moorgate build available from Twenty57. The Balancing Entry and Market Action functionality has been extended to make it easier to manage the Market Actions from identification through to Authorisation and Completion.

Balancing Entries and Market Actions

• Balancing Entry Type has been added so you know what the recon difference is for: Setup>Balancing Entry Types to maintain.
• Default Type can be set and will appear first in any dropdowns
• Type is required for any differences - auto and manual matched
•  New Market Action Status's: Authorised and Submitted
• New User role 'Manager'. A Manager can authorise 'Initiated' Market Actions
• External Systems can process Authorised MA's and update them to 'Submitted'
• Profiles on the MA screen allow you to customise your view
• Recon's relating to MA's which have been Authorised, Submitted or Completed cannot be removed

Other Features

• Dashboard: Only grid refreshes not the whole page
• Report Frames are bigger
• Bug: Export to csv duplication fixed
• Confirmation Definition Import Rollback 

As always all feedback is wanted. Let me know how you find the improved Market Action process as well as your everyday interaction with Moorgate.