Moorgate Roles and Access Rights: How do they work

Moorgate has a number of standard User Roles built in. Each of these roles gives a user access to specific screens and functions. Roles are cumulative. To give a user more rights, add them to the specific role. The role governs what the user can do. Which accounts they can work on and see data for is decided by the Product and Fund Companies they are assigned to. So what are these roles and what access do they have?

• Admin: Access to the Home, Setup and Help Menu Items and all sub menu items. An Admin user can perform all setup tasks and add other Admin users to the system
• Asset Allocation: Access to the Home, Funds and Help Menu Items and all sub menu items. This user can import Prices and capture Asset Allocation Data
• Capturer: Access to the Home, Transactions and Help Menu Items and all sub menu items. A Capturer can import Transaction and Confirmation data and manually capture Confirmations. They can also edit and remove confirmations, roll back imports and initiate Market Actions. Additionally they can view transactions and confirmations on accounts which they have access to
• Daily Process: Access to the Home, Daily Process and Help Menu Items and all sub menu items. This user can view the Dashboard and kick off scheduled processes
• Manager: Access to the Home, Transactions and Help Menu Items and all sub menu items. A Manager can do all the same things a Capturer can and they can Authorise and Reject Initiated Market Actions.
• Reconciliation: Access to the Home, Reconciliation and Help Menu Items and all sub menu items. This user can perform Manual and Auto Reconcilations and Manage Tags
• Reports: Access to the Home, Reports and Help Menu Items and all sub menu items. A user with the Reports role can View all Reports added to the system
• Static Data Maintenance: Access to the Home and Help Menu and all sub menu items as well as the Tag Types, Balancing Entry Types, Product Companies, Products, Fund Companies, Funds and Accounts sub menu items of the Setup menu item. This user can set up and maintain the static data required within Moorgate
• User Maintenance: Access to the Home and Help Menu and all sub menu items as well as access to the Users sub menu of the Setup Menu item. This user can add and maintain users and assign them to all roles except Admin users. They cannot edit existing Admin users and they cannot edit their own access rights. Only an Admin user can do that

Even if a user has access to the Home Screen, they won't be able to view any of the accounts unless they have been granted an appropriate Role and are assigned to the Product and Fund Companies.

Moorgate 1.4.948.1116 is available

Moorgate 1.4.948.1116 is available for download from the Twenty57 website. It contains the following features and fixes

New Features

• Same-side Auto Match rules are allowed. The dataset names now need to be specified to correctly identify which side the transactions come from. Previously all Left Datasets were Transactions and all Right Datasets where Confirmations (no matter what name they had).  Please update all existing rules accordingly. e.g:

<LeftDataset Name="Transactions">

<RightDataset Name="Confirmations">

or as required for your rule. All existing rules should be as above but please confirm. I have a script that can help you if needed but it wasn't deployed with the build because not all rules tested converted successfully. To do a same-side match you would specify both datasets as Confirmations or both Datasets as Transactions and write the SQL queries are required to identify both sets of transactions.

• Only the first four codes (ordered by ID) are shown in the Account Selector pop-up. This is to ensure it doesn't widen past the screen if there are a lot of them. It only applies to many internal codes on the Management Company or Fund and you can see all the codes by mousing over the Company or Fund entry in the drop down. 
• You can now configure a web service method from Moorgate to import the Finswitch Price File automatically. There is a new Menu item Setup>Price Import Definitions. Add a new one and Moorgate will default the wsdl to the Finswitch Production download wsdl and default the Type and Date. Specify the other parameters as per your business. You can then schedule the import to run automatically using a Process Schedule (Setup>Process Schedule). Moorgate will always run the automated download for today's date. This means you will want to schedule the automated run for late in the evening once the Finswitch Price file is available. Users can kick off the web service download manually for any date (Funds>Import Price).

Bug Fix:

• Opening Balance of zero was giving an error on the Edit Failed Confirmations screen
• The Manager Role access rights have been amended to prevent access to all the Setup screens

A big thank you to Shivkant for doing all the development work included in this build

Moorgate 1.4.918.1068 is available

Moorgate 1.4.918.1068 is available for download from the Twenty57 website. It contains one small bug fix:

• Export to CSV on View Transactions Screen now works properly

Moorgate 1.4.912.1058 is available

Moorgate 1.4.912.1058 is available for download from the Twenty57 website. It contains the following features:

• View Recons in Market Actions after they have been created
• Create User and Create Date are included in the filters on the Market Action screen and be added to the Grid
• Populate the Proposed Units Column when a Market Action is created
• Change the order of the Error Message on Internal and Confirmation Database imports. The batch which fails is shown at the top with the Balance and Transaction information directly below it. The details of all batches which have 'passed' are shown below the failed batch
• Show the difference between the Moorgate Closing Balance and the Finswitch Balance on the Edit Failed Confirmations screen. As the user captures missing transactions the balance is recalculated
• Added a Unique Constraint to the ProductCompanyFundCompanyUser table to prevent duplicate entries. This shouldn't affect you but if you find the update script is failing let me know and I will give you a script to clear out the table and repopulate it with one entry per combination
• New Standard Report Consolidated Report to Date (Standard). This splits the differences between the Internal Transaction and Confirmation Balances by Balancing Entry and Tag Type. We have made use of dynamic SQL to be able to generate this report for any implementation so you won't see it in the list of reports in the install folder. It is created automatically though and regenerates whenever there are changes to the Balancing Entry Types and Tag Types. There are some additional Standard Views and Stored Procs created for this report

A big thank you to the developers for the work done, especially around the Consolidated Report.