Moorgate Release Notes
----------------------
The release note will always include all the revisions, listed from latest to earliest.
All the revisions with numbers between the previous version's revision number and the current version's revision number will represent new functionality.
See the relevant blog post for more information
Release 1.24.1296.1984 (11 April 2025)
---
ZEN18717 - Transaction Import error logging. When a closing balance error was reported, the import process was not properly handling the end of the transaction batch. This would cause misleading errors to be reported for subsequent transaction batches because the previous batch had not been properly closed off. This has been corrected.
Release 1.24.1295.1982 (7 April 2025)
---
- ZEN17510 - Fund Company and Product Company Editors. Tooltips have been added to provide more information on the Product Company Amount Tolerance and Fund Company Import Tolerance. Additionally, the database default for the Fund Company Import Tolerance was set to 1. This default has been changed to 0 to align with the front-end default.
- ZEN18036 - Transactions -> Failed Confirmations page. The Select All header checkbox was selecting all items regardless of their status. The intended behaviour is to select all but those items with the Fixed status. This behaviour has been restored.
- ZEN18112 - Reports - Current Reconciliation Status Report (Standard). To prevent the Start Date parameter from resetting to the default value after viewing the report, the Start Date default was removed. The Start Date will no longer reset after viewing the report. This change was made to the .rdl file (Current Reconciliation Status Report (Standard).rdl) in the Reports directory of the Moorgate installation (usually C:\Program Files (x86)\Twenty57 Moorgate\Reports). To incorporate this change one must upload the .rdl file via Setup->Reports->Current Reconciliation Status Report (Standard). This makes the change optional to prevent the possibility of overwriting any previous customisations to this report.
Release 1.23.1294.1976 (11 February 2025)
---
- ZEN18114 - Reports - The vertical and horizontal scrollbars were not behaving correctly when viewing a report. This has been addressed.
Release 1.23.1293.1973 (15 January 2025)
---
- ZEN18023 - The "Kill Process" functionality on the Dashboard had been lost due to the click event not working correctly. This functionality has been restored.
Release 1.23.1291.1969 (22 October 2024)
---
- ZEN17511 - Confirmations File Import - Blank values for Price and Amount are interpreted as 0. This only affects Holding Balance line items.
Release 1.22.1290.1965 (2 October 2024)
---
- ZEN17161 - Reports timing out - Added the "executionTimeout" setting in the web.config's "httpRuntime" element. This property indicates the maximum number of seconds a request is allowed to execute before being automatically shut down. The default is 110 seconds. This was causing timeout errors when attempting to view reports.
- ZEN17401 - Asset Allocation file import - The Date Submitted column may optionally include a timestamp. Moorgate is now able to parse both the original format and the format that includes the time.
Release 1.21.1289.1961 (6 June 2024)
---
- ZEN16541 - The Capture Confirmations page was throwing an error when navigating to that page from a report. This has been fixed.
Release 1.20.1287.1957 (18 April 2024)
--------------------------------------
Support
ZEN15590 - It was possible for a scheduled process to unexpectedly crash the process service. This was due to a missing Log4Net dll that is used for logging. The Moorgate build now deploys this dll.
ZEN15526 - Some SMTP servers do not allow emails to be sent on behalf of another user. Sending a Tag by email by default sends on behalf of the logged in user i.e. the "from" address will be that of the logged in user. If the server does not allow this, there is a new "Email Sender Address" field in Preferences. If this is populated, Tag emails are sent with this address as the "from" address.
ZEN15999 - Product Companies can be set up to restrict users from unreconciling transactions. In some cases, this was not working due to malformed sql generated by Moorgate. The sql has been fixed.
Release 1.19.1284.1947 (19 January 2024)
----------------------------------------
Support
- ZEN15315 - Grid paging on the Failed Confirmations page been fixed
- ZEN15004, ZEN15201 - Reports - The reports no longer use values from the Account Selector for report parameters named ProductCompanyID, ProductID, FundCompanyID and FundID. If the intention is to use values from the Account Selector for a report, the parameters must be named CurrentProductCompanyID, CurrentProductID, CurrentFundCompanyID, and CurrentFundID.
- ZEN14923 - Added an index for the ClosingBalanceDate field in the InternalBatch table.
----------------------------------------
Features
- ZEN14168 - Added option on Product Company to restrict Confirmation Removal based on Linx web service validation
----------------------------------------
Support
- ZEN14035 - Optimizations
Transaction Details Import
Notes:
This process was re-written to improve performance. It is recommended that regression testing be done for all existing processes. There are some changes to how the process log details are written.
----------------------------------------
Support
- ZEN13323 - Asset Allocation Import - Added support for new File Headers from Finswitch. Added 'Use Legacy Asset Allocation File Headers' setting in Preferences.
Maintenance
- MG326 - Updated library used for Report Viewer engine. Support added for reports created with the latest version of MS Report Builder and Power BI Report Builder.
Notes:
- Microsoft Report View Redistributable 2012 no longer required as a pre-requisite.
- Existing installs will require an update to the web.config. Add the following to the bottom of the file, before the </configuration> tag.
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Microsoft.ReportViewer.WebForms" publicKeyToken="89845dcd8080cc91" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-11.0.0.0" newVersion="11.0.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="Microsoft.SqlServer.Types" publicKeyToken="89845dcd8080cc91" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-16.0.0.0" newVersion="16.0.0.0" />
</dependentAssembly>
</assemblyBinding>
</runtime>
Release 1.15.1273.1909 (16 May 2023)
----------------------------------------
Support- ZEN12819 - Confirmations File Import - Fixed issue with calculating opening balances when multiple cycle dates exist for the same account.
Release 1.15.1272.1907 (08 February 2022)
Release 1.15.1269.1898 (06 April 2022)
Release 1.15.1267.1890 (22 February 2021)
Release 1.14.1250.1848 (19 November 2020)
----------------------------------------
Release 1.13.1246.1840 (06 October 2020)
----------------------------------------
Release 1.12.1225.1784 (14 April 2020)
----------------------------------------
Support
- MG256 - Fixed issue with New Profiles and Restore Default button resetting Account filter to 0 instead of All
- ZEN6197 - Remove Confirmations - moved the the execution to a process to prevent UI timeouts when working with large datasets.
- ZEN6078 - Consolidated Recon Screen - Prevent Apply & Hide button from being clicked until column change scripts have completed
- ZEN6402 - Bulk Initiate Market Action config - added Balancing Entry Type to Test button filtering. Optimized the Bulk Initiate Market Action process
Release 1.10.1220.1772 (30 March 2020)
----------------------------------------
Features
- ZEN6087 - Account Selector - updated from "starts with" lookup, to "like" lookup condition.
- ZEN6032 - New Recon Page - Account Filter - updated to "like" lookup condition.
Support
- ZEN6090 - Updated the below configurations to encrypt passwords at rest
Upon upgrade, the following configurations must have the password recaptured and re-saved
- Price Import Definition
- Confirmation Import Definition
- Asset Allocation Import Definition
Release 1.9.1215.1761 (03 February 2020)
----------------------------------------
Features
- ZEN4843 - New Recon Screen - updated labels
- MG199 - Asset Allocation - Added Process Definitions and Source Key by quarter for web service imports, updated manual run dates to display quarters
Support
- ZEN5358 - Added a validation on the recon step to check if any transaction from the reconciliation group has already been reconciled. Manual Transactions will display a warning prompt for this scenario, Automated Transactions will skip the reconciliation.
- ZEN5479 - Optimized queries on Confirmations Rollback
Large datasets may require a system level config change to the transaction timeout
File:
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config
Add Key:
<system.transactions>
<machineSettings maxTimeout="04:00:00" />
</system.transactions>
Release 1.8.1210.1749 (17 January 2020)
----------------------------------------
Features
- ZEN5621 - Updated the account selector to include a direct search for account by ([Account Number] - [Product Name] - [Fund Name] )
- ZEN4856 - Added a Finswitch WebService API for Asset Allocation Imports
- ZEN5285 - Added a link to the Process Dashboard to display data from Successful Confirmation imports
- ZEN4843 - Added Manual Recon (Consolidated) screen
- ZEN5265 - Added Web Services to invoke the following processes:
ImportConfirmations
ImportTransactionDetails
ImportTransactions
RunAutoReconciliation
The webservices are access via the URL
http://[Instance]/Services/WebServices.asmx
http://[Instance]/Services/WebServices.asmx?wsdl
The following must be added to the web config if upgrading from an older version of Moorgate:
<location path="Services/WebServices.asmx">
<system.web>
<authorization>
<allow users="*" />
</authorization>
</system.web>
</location>
Support
- MG247 - Fixed issue with Home (Unresolved Transactions) page displaying accounts where user does not have access
Release 1.5.1165.1592 (16 August 2019)
----------------------------------------
Features
- ZEN4857 - Unresolved Transactions screen - added count of accounts being displayed
Support
- ZEN4858 - Fixed issue errors loading tag that has been disabled, prevent user from saving tags that have been marked as inactive
- ZEN4862 - Corrected heading labels when editing an Asset Allocation
- ZEN4878 - Added additional details to process log for Confirmation SQL Import
Release 1.5.1160.1579 (20 June 2019)
----------------------------------------
- Asset Allocation enhancements
Imported FinSwitch asset allocation records with status = CORRECTED now update appropriately in the Moorgate database.
FinSwitch file imports no longer fail for multiple records in the file and where there is at least one record with a validation error. Valid records are updated in the Moorgate database and invalid records return an error message viewable per the Dashboard details link.
Release 1.5.1158.1575 (07 June 2019)
----------------------------------------
- Asset Allocation feature
The old Asset Allocation feature was updated to accommodate the current SARB format
The Moorgate application now allows for the importing of FinSwitch Asset Allocation file types as well as allows for capturing and editing of fund asset allocations manually via the Moorgate front-end
For FinSwitch Asset Allocation imports, the following fields are calculated and not validated if the fields are not populated in the FinSwitch file
> Local - Actual % of Portfolio
> Foreign - Actual % of Portfolio
> Total %
For manual capture via the Moorgate front-end, the following fields are calculated and by Moorgate:
> Local - Actual % of Portfolio
> Foreign - Actual % of Portfolio
> Total % - (also validated to equal 100.00%)
> Equities (sub-total)
- Fixed an issue where an inactive user was able to access the application when Windows Authentication is applied
- Enhanced the Moorgate FinSwitch web service call functionality to accommodate FinSwitch TLS 1.2 security upgrades and TLS 1.0 and TLS 1.1 deprecation
Release 1.5.1143.1538 (07 March 2019)
----------------------------------------
- Fixed an issue where including the Last Tag Type and/or Last Tag filter columns on the manual recon causes an error when dragging transactions down for matching
- Fixed an issue when a new user created logs in without selecting the account and navigates to the Manual Recon page
- Fixed an issue when clicking on an account on the LandingPage.aspx, which navigates to the ManualRecon page and the Filter not being applied - where LastTag, LastTagType column is selected within filter
- Fixed an issue when clicking 'Export to CSV' button where multiple aliased references were included in the filter
Release 1.5.1141.1534 (05 February 2019)
----------------------------------------
- Fixed an issue where selecting a filter profile did not update the records returned
Release 1.5.1140.1532 (23 January 2019)
----------------------------------------
- Fixed an issue where selecting all market action items, subsequently deselecting a few market action items and clicking authorise results in all market action items in the filter being authorised
Release 1.5.1138.1528 (10 January 2019)
----------------------------------------
- Fixed an issue where the incorrect column name was displayed on the Capture Confirmation page
Release 1.5.1137.1526 (12 December 2018)
----------------------------------------
- Fixed an issue when using Internet Explorer, where viewing a report containing a high amount of data resulted in the data being displayed outside the report frame
- Fixed an issue where viewing details of a recon related to MarketActionIDs greater than a certain threshold resulted in an error
Release 1.5.1126.1501 (6 September 2018)
----------------------------------------
- Proxy settings are now configurable in Setup>Preferences.
- FinSwitch web service confirmation and price import definitions now have an additional parameter called 'Enable Proxy' for proxy settings applied to the call.
Release 1.5.1122.1493 (10 July 2018)
----------------------------------------
- Process Dashboard now correctly filters for the last 20 items per the filter criteria set.
- Market Action error on authorisation "Input string was not in a correct format" has been addressed
- Market Action 'Initiate Market Action' button is no longer incorrectly greyed out when selecting all entries and then deselecting an entry on another page.
Release 1.5.1119.1487 (14 May 2018)
----------------------------------------
- Confirmation Import Definition now includes a FinSwitch web service call import type
- Bulk Initiate Market Action feature has been added
- Price Import Definition has been improved to allow filedate parameter to be set to current date or previous day's date
- Market Action page has been improved with a check box to select all check boxes across all pages
Release 1.5.1094.1427 (13 September 2017)
----------------------------------------
- Fixed a bug where paging disappeared when clicking on # of entries and closing the pop-up on Failed confirmations page
- Fixed an bug where loading a tag from the ViewTagDetails page resulted in a page load error
- Fixed an issue where attempting to delete an unreconciled tag from the ViewTagDetails page had no effect
- Fixed a bug where details link on Manualreconciliation page resulted in a page load error
- Fixed a bug where clicking a specific ReconID on the InternalTransactionAllAccountsList page would navigate the user to the incorrect ReconID
- Fixed a bug where clicking the 'Cancel' button would navigate the user to the incorrect page
- Fixed a bug where clicking 'Cancel' for Save Tag had no effect
- Fixed a bug where clicking 'Cancel' from the ReconciliationDetails page navigated to the incorrect page
- Fixed a bug where paging on ReconciliationDetails page was not working correctly
- Fixed a bug where paging for Transactions and Confirmations on the TagEditor page was not working correctly
- Fixed a bug where paging for Marketactions page was not working correctly
- Fix applied to prevent Manual reconciliation page from refreshing when using the Account Selector link to select a different Product, Management Company and Fund
- Fixed a bug where authorising an Initiated Market action did not change the status
- Fixed a bug where filtering Price, Units or Amounts with 'Like' condition would result in a page load error
- Fixed a bug on the TagEditor page. The message popup for 'Send Email' checkbox no longer loops when the user has no email address.
- Fixed a bug where the Email field was not validated on the UserEditor page
- Queries loading data for pages InternalTransactionList, InternalTransactionAllAccountsList, ExternalTransactionList, ExternalTransactionAllAccountsList improved to increase page loading speed
- Current Reconciliation Status Report calculated fields updated
- Internal and external transactions are now validated that all the transactions are in the same account.
- Deleting and paging improvements made where the option to delete or select different page numbers are available
- Test function in Transaction Import definition editor now works for Oracle queries with sub-queries
- Added the following setting to web.config
<add key=""CommandTimeout"" value=""3600""/>
- Chrome browser - Landing page. Grid links now show an icon on mouse hover.
- Chrome browser - Landing page. Fixed a bug where clicking an Account number would result in an JS error
- Chrome browser - Failed Confirmations page. Fixed a bug preventing failed confirmations from being removable.
- Chrome browser - Failed Confirmations page. Fixed a bug preventing the filter popup from being displayed.
- Chrome browser - TagEditor page. Fixed a bug where 'Save as New Tag' was incorrectly enabled but should have been disabled
- Internet Explorer 9 browser - Import Confirmations page. Fixed a bug where 'Choose File' button was not visible.
Release 1.4.1060.1340 (28 September 2016)
----------------------------------------
- Rollback Transaction Detail Imports
- Assign the default balancing entry type to small differences created through the auto-reconcile functionality on the Manual Recon screen
- HO/HC balance codes now supported on all Import Definitions
- Fix: Product Company setting Confirmation File Import Missing Account Action is honoured
- Fix: Batch ordering and processing handled correctly when the Finswitch file contains incomplete batches
- Fix: Filters on Failed Confirmation Screen
Release 1.4.1056.1331 (29 February 2016)
----------------------------------------
- Processing of Finswitch Files containing Holding Opening (HO) and Holding Closing (HC) balances
- Hide Inactive accounts on the Home Screen
- Default Fund Price Field added for Amount Type Funds
- Product, Fund and Account information included in the Tag Email
Release 1.4.1047.1311 (18 January 2016)
----------------------------------------
- Check to ensure already reconciled items cannot be reconciled again
- Data Refresh is complete and consistent when working on multiple tabs
- Pop-up Warning that the account change is going to happen has been removed
- If the account is changed while on the Edit Tag screen, the user is navigated to the Home Screen without the tag being saved
Release: 1.4.1044.1304 (10 December 2015)
-----------------------------------------
- Moorgate now installs on Windows 10/IIS 10
- More readable messages when an error occurs during install
- If the install fails you can select to view the log file directly from the msi.
- Remove and Rollback functionality has been separated out from the Capturer Role into a new role Remove Data
- Recons now match to the 6th decimal place and Balancing entries are created accordingly
- Update to the stored procedure Rpt_ConsolidatedReportStandard to use the Internal Batch Closing Balance rather than calculating it
- Ensure data integrity is maintained when a user has 2 tabs open at the same time
- Test Oracle Import Definition now works correctly. You will need to add the following settings to your config files
- appSettings section of the web.config file:
<add key="OracleImporterURL" value="tcp://localhost:8090/OracleImporter" />
- services section of the ProcessService.exe.config file
<wellknown type="Twenty57.Moorgate.API.OracleImporterProxy, Twenty57.Moorgate.API" mode="SingleCall" objectUri ="OracleImporter" />
- Oracle Stored procedures are now supported for all Import Definitions
- The release notes have been moved to this page
- The Release notes link under the Help Menu will direct you here
Release: 1.4.1029.1264 (20 January 2015)
---------------------------------------
- SMTP settings moved to the Preferences screen and stored in the database
- Unit Difference between transactions and confirmations displayed alongside the amount difference on the Add/Edit Tag Screen
- Better handling of failed Finswitch Confirmation batches that don't have codes
- New Setting per Product Company: Confirmation File Non-Zero First Balance Action
- Transaction Import Tolerance extended to Opening Balance = Previous Closing Balance check
- Help link navigates to http://help.moorgate.twenty57.com
- Fixed: Finswitch File Import and Capture Confirmations works independently of Regional Date Format
- Fixed: Instruction Date not lost when additional rows added on the Capture, Edit and Failed Confirmations Screen
- Fixed: Menu spelling typo:
Revision: 1.4.1017.1237 (18 June 2014)
---------------------------------------
- Allow for a tolerance (for rounding errors) on internal transactions when checking opening balance + nett transactions = closing balance.
Revision: 1.4.1016.1235 (17 April 2014)
---------------------------------------
- New standard report, User Activity Report (Standard).
- New standard report on failed confirmations.
- Management Companies now have a new setting Confirmation Source which specifies where the confirmations will come from. Options are Finswitch and Confirmation Import Definition. Only data from the selected source will be processed for the management company.
- Transaction Imports will now show all failures and not just the first one.
- Audit Trail for Static Data Changes.
- The new Holdings Balance message type on Finswitch Confirmation file will be ignored.
- The entire Finswitch Confirmation import can now be rolled back.
- Added Created by and Created Date to the Market Action screen.
- Instruction Date displayed on Failed Confirmation Screen.
- Cycledate is now mandatory on Transaction Import Definitions.
- Consolidated report logic changed to calculate closing balances from opening balance + sum(transactions) on both transactions and confirmations.
- Email notification on saving a tag.
- Removed the results limit on the unresolved Transactions Screen.
- Allow for internal names to be displayed on the Failed confirmations page.
- Allow filtering on the dashboard page.
- Update Reports to report viewer 2012.
Bug Fixes:
- Manual Recon Account selector was empty under certain conditions.
- Recon balancing entry "disappearing" from manual recon screen.
- Prevent the Object reference error on matching a single confirmation where there is no transaction batch. An empty transaction batch will be created and the balancing entry will be put in it.
- Prevent rerunning a transaction import while once it has been started.
Revision: 1.4.948.1116 (4 October 2013)
---------------------------------------
- Automatically import prices using the Finswitch Web service.
- Same side auto match rules are allowed.
- Limit Internal codes to the first four in the account selector pop-up.
- Bug Fix: Failed Confirmation Screen error when the opening balance is zero.
- Fixed Manager role permissions.
Revision: 1.4.918.1068 (3 June 2013)
----------------------------------
- View transaction: Fixed error while export to excel.
- Updated database import error message.
- Market Action Screen: Add Columns Created By and Created Date.
- Consolidated Report enhancements.
- Report view enhancements.
- Fixed List screen errors related to VirtualItemCount.
Revision: 1.4.907.1046 (18 Mar 2013)
----------------------------------
- Market Acton screen:
- Allow paging through the grid once market action is initiated.
- Populate the proposed Units column with the Initiated value.
- Activate the Recon link.
- Report List Screen: No paging to be displayed.
- Reports: Included these Reports as Standard Reports:
- Captured Confirmations Report
- Consolidated Report To Date
- Bug: Auto Match Rules: The test button is not working.
- Failed Confirmation screen: Show the difference between the FS and Moorgate Closing balances.
Revision: 1.4.888.1001 (5 Nov 2012)
----------------------------------
- Bug: Manual Recon Screen: The Last tag type and Last Tag columns are not shown when the transaction is loaded into the Matched Section.
- Bug: Confirmation Import process: Imports process is creating the Opening and Closing balance records in the External Transaction.
- Market Acton screen: Prevent multiple clicks of Initiate Market Action button.
- Failed Confirmation screen:
- Confirmation records were Opening balance units not match due to decimal places issue.
- Add a filter to the Failed Confirmations Screen.
- Export to CSV.
- Account Selector: Display Products dropdown in alphabetical order.
- Tag Types menu: Place Tag Type menu between Transaction Types and Balancing Entry Types.
- User Maintenance User Role: Access to User screen.
- Static Data Maintenance User Role: Access to following Screens;
Tag Types
Balancing Entry Types
Product Companies
Products
Management Companies
Funds
Accounts
- Filters: make filters movable.
- Bug: Balancing entries not deleted when unreconclied.
- Reports: Included these Reports as Standard Reports:
Unresolved Transaction Report
Last Closing Balance Report
Current Reconciliation Status Report
Current Reconciliation Status Report Per Fund
- Remove Reconciliation: Don't show the Confirm removal with reason pop-up if Reconciliation can't be removed
- Manual Recon Screen Filter: Remove the Market Action ID column and add a Market Action Status column.
Revision: 1.4.851.945 (12 Oct 2012)
----------------------------------
- Installer: Add the test Database connection string functionality.
- Filter: dd/MM/yyyy format issue fix.
- Manual Recon screen: Error while adding Last Tag or Last Tag Type columns to the selected Internal Transaction grid.
- Error screen: Show error information.
- Bug: FS Confirmation Imports creating Opening and Closing Balance records in External Transaction
Revision: 1.4.842.927 (04 Oct 2012)
----------------------------------
- Improved the performance of Imports from definitions for large volumes of data.
- Account Selector:
- Display the External Fund Code in Fund Dropdown.
- Move the popup if long list of Fund Managers is not visible.
- Display the External Fund Code in the Account Selector ribbon.
- Captured Confirmations Report: Formatting and functional changes.
- Installer: Allow User to choose between Forms and Windows authentication.
- Upgrade Moorgate to .net Framework 4.
- Application upgraded to .net 4.0 framework. Please make following changes to configuration files.
- 1) Open the properties window of virtual directory and change the ASP.NET Version to 4.0 in ASP.NET tab.
- 2) Change the Web.config file as mentioned below:
- Delete configSections tag
- Add following attribute in the compilation tag: targetFramework="4.0"
- Delete assemblies tag
- Add following attributes in pages tag: controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID"
- Delete below section from controls tag
<add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
- Delete below section from httpHandlers tag
<remove verb="*" path="*.asmx" />
<add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false" />
- Delete httpModules section
<httpModules>
<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
</httpModules>
- Delete system.codedom section
<system.codedom>
<compilers>
<compiler language="c#;cs;csharp" extension=".cs" warningLevel="4" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
<providerOption name="CompilerVersion" value="v3.5" />
<providerOption name="WarnAsError" value="false" />
</compiler>
</compilers>
</system.codedom>
- Delete below tags from system.webServer section
<modules>
<remove name="ScriptModule" />
<add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
</modules>
<handlers>
<remove name="WebServiceHandlerFactory-Integrated" />
<remove name="ScriptHandlerFactory" />
<remove name="ScriptHandlerFactoryAppServices" />
<remove name="ScriptResource" />
<add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
</handlers>
- Delete runtime section
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0" />
</dependentAssembly>
</assemblyBinding>
</runtime>
- 3) In the Twenty57.BankRecon.ProcessService.exe.config file change Version to 4.0.0.0 in add attributes of <system.web> tag.
- Add below startup tag in the Twenty57.BankRecon.ProcessService.exe.config file after </system.web> tag.
<startup><supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/></startup>
- 4) Restart the process service.
Revision: 1.4.831.904 (18 Sep 2012)
----------------------------------
- Reprocess Failed Confirmations: Use CycleDate instead of ValueDate.
- Account Selector: Allow second account number selection.
- Allow Import Balance only batches on the FS file.
- Failed confirmations screen: Allow manual capture of Opening Balance and Valuedate if its the first batch.
- Failed confirmations screen: The batches which cannot be imported as they are not in a valid format and fail correctly with the correct reasons are displayed in the Process Details Message.
- Include the ReconId column in the Default filters.
- Failed Confirmations: Allow fixing of the error Combination of codes cannot be mapped uniquely.
- Process Log Details:
- Show failed/rejected batches and transaction before the list of successful imports and order the list by Account Code.
- Keep the popup open and allow the user to work with Moorgate and other open tabs.
- Account screen filter: Include the Active Flag, Product and Fund External and Internal Codes in the filter and grid.
- Capture and Edit of confirmations: Auto Calculate the units if an amount and price are given.
- Setup guidelines on Import Definition screens: make the into boxes/pop-ups which allow the user to continue working and to reference them at the same time.
- Bug: Confirmations Import error Value was either too large or too small for an Int32.
- Import Transactions should also work with only mandatory columns.
Revision: 1.4.799.846 (23 Aug 2012)
----------------------------------
- Bug: Error in account selector when new Fund Company Added.
- Market Action Screen: Paging applied.
- Market Action screen: If Fund has 2 different Internal Codes then duplicate record is displayed on screen.
- Default rule "Group Internal and External by Account, TransactionType and ValueDate" changed.
- Balancing Entry process: when deleting the Recon having balancing entries If the other side of the BE is reconciled. Do not delete it.
- Filter: Use of the quotation symbol (") in the names.
- Filter: Show distinct values in the account filter dropdowns.
- Filter: Show distinct values in the product filter dropdowns.
- Confirmation import : Change the ordering logic for FS files to use Cycle Date instead of Value Date to determine the batches.
- Failed confirmation screen: Error when saving either the first or second batch from the failed confirmation screen.
- Fund Company screen: When a new Fund Company is added, automatically assign users who are assigned to the Product Company to which the Fund Company is linked access to the Fund.
- Edit Failed Confirmations Screen: Add Cancel Button.
- Failed Confirmations Screen: FS transaction with the Account, Product and Fund Codes without balances into Moorgate
The transaction is imported
Please check for accounts first and if it passes then check for balances.
- FS Import Balance Tolerance:
Apply the tolerance to check if the previous closing balance in Moorgate falls in the tolerance limit with the FS opening balance.
- Failed Confirmation: If it is the first import into Moorgate for the account use the FS balances as the Moorgate balances
- Failed Confirmations screen: displayed single entry when duplicate external codes but unique account mapping.
- Save Failed Confirmations: displayed confirmation message on the Failed Confirmations screen.
- Import definitions screens: Add Test button to test the import query.
Revision: 1.4.753.748 (14 Jun 2012)
----------------------------------
- View Transactions/View Transactions Across Accounts: Include details link.
- Bug: Negative transactions captured through Capture a Confirmation screen shown as positive on the Manual Recon screen.
Revision: 1.4.750.743 (25 May 2012)
----------------------------------
- Market Action Screen: Include Internal Fund Code in the grid and filters.
- View Transactions/Confirmations across account screen: Allow saving User Filter Profiles.
- Auto Recon Rules screen: Use default connection string provided in config file.
- Reconciled Transactions screen: Log the unreconciled entries as cancelled with timestamp, user detail and reason.
- User screen: Assign Users to Mancos.
- Bug: Apply a format mask for ValueDate in Confirmation Capture screen.
- Bug: Apostrophe in a filter value causes error.
Revision: 1.4.715.689 (09 Apr 2012)
----------------------------------
- FS File Import changes: An interface is provided to edit the balance and static data errors for the failed confirmations.
- A new screen 'Failed Confirmations' provides the view of all the failed batches.
- A new manual capture screen to edit the failed balance errors is provided which can be navigated to from 'Failed Confirmations' screen.
- Product Company: If there are no balance records in FS file and the ‘Confirmation File Missing Balances Action’ is set to Fail then the error is shown in Failed Confirmations summary screen otherwise balances will be created automatically and message will be shown in Dashboard screen as batches did not had balances.
- Bug: Auto match rules was creating recons with multiple transaction types.
- Bug: Match note was not populating auto match rule name.
- Bug: Balancing entry type ID was shown in Matched Section of the manual recon screen instead of Balancing entry type.
- Bug: Few funds were getting populated in account selector for which there were no accounts.
- Bug: When trying to capture the first transaction for an account an error is returned.
Revision: 1.4.691.637 (15 Mar 2012)
----------------------------------
- Landing page: Balancing entries exlcuded from unresolved transaction count.
- View Trasactions Across Accounts: Static codes for product company, product, fund company and fund added in grid and filters.
- View Confirmations Across Accounts: Static codes for product company, product, fund company and fund added in grid and filters.
- Confirmation file import: Files without balance records will be process and Moorgate will create balance records.
- COnfirmation file import: Files with incorrect ordering of transactions will be ordered to ensure the accounts and transactions are grouped together correctly and then process the file.
Revision: 1.4.681.616 (16 Feb 2012)
----------------------------------
- Recon Details: Balancing entry type is shown on Transactions grid in recon details screen.
- Imports: Transactions, transaction details and confirmations can be imported from oracle database.
- Market Action: Users with Manager role can reject the initiated market actions.
- Account filter: Associated product, fund company and fund will be populated when product company is selected in the account filter pop up.
- Tags: Users can delete the tags created by other users.
- Capture Confirmations: The review screen showing the balancing entries and confirmations has been removed. On click on Save the confirmations will be saved directly.
- View transactions: Market actionID is added to grid and filter in view transactions screen.
- Capture Confirmations: If two users capture the confirmations for an account at same time, while saving the batch a check is added to verify whether that the batch's opening balance is still the same as the previous batch closing balance and if not a message about the new opening balance is shown to user.
- Edit Confirmations: When the last confirmations is deleted then a message is shown to user as 'Batch removed successfully.' which is faded after 30 seconds.
Revision: 1.4.673.595 (19 Jan 2012)
----------------------------------
- Transaction Import: Balance check done on previous imported batch only if the latest batch is of reconciliation type.
- 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.
Revision: 1.4.668.583 (23 Dec 2011)
----------------------------------
- Manual Recon: Added provision to have same side confirmation matching when the unit difference is within the specified fund tolerance.
- Manual Recon: Added provision to allow single transactions on both the Confirmation and Transaction side to be reconciled with a balancing entry if the unit value is within the tolerance of the fund.
Revision: 1.4.666.579 (08 Dec 2011)
----------------------------------
- Manual capture: A new column added to capture management fee.
- Preferences: The URL for webhelp updated in 'WebHelp URL' field in Preferences screen.
- Landing page: User will be navigated to manual recon screen after they select any account in landing page.
- Calendar control: Today's date will be default highlighted.
- Profiles: Last used profile will be loaded by default.
- Bug: 'Clear All' button in manual recon gets disabled when any action is performed after transactions are moved to match area.
- Bug: If the database connection is down when the service is restarted, the process definitions are not loaded into the service and thus do not run. A force restart of the service is then required to get it working 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.
Revision: 1.4.650.543 (03 Nov 2011)
----------------------------------
- Landing page: Changes made to improve the performance of the landing page.
Revision: 1.4.649.541 (17 Oct 2011)
----------------------------------
- Tags: Bug - Delete Tag functionality not working.
- Tags: Create Date column added to Tag listing screen. This column is available in filters as well.
- Tags: Tags are listed by ID in descending order.
Revision: 1.4.643.529 (09 Sep 2011)
----------------------------------
- Filter: Criteria column for Balancing Entry Type changed from textbox to dropdown.
Revision: 1.4.633.507 (25 Aug 2011)
----------------------------------
- Market Action: Following changes are made to market actions:
- Added a new screen to setup Balancing Entry Types
- Added two new status as 'Completed' and 'Authorised'
- Added a new Manager role for authorising the Initiated market actions.
- Managers will get a checkbox next to Initiated market actions to authorise the market actions.
- Added a balancing entry type dropdown to manual recon screen. It is mandatory to select balancing entry type for recons creating balancing entries.
- Add ‘Balancing Entry Type for Differences:’ dropdown to the Auto Match Rule setup screen.
- Filter has been defaulted to <>'Completed' and profiles added.
- Manual Recon: Clicking on a tag link from the manual recon screen will navigate users to tag details screen directly, not the tag listing screen.
- Confirmation Import Rollback: Last batches (as per the last key date of the import definition) imported with a confirmation import definition will be roll backed.
- Bug: Export data from Transactions, Confirmations, View across Accounts screen has duplicate columns.
- Bug: When wide reports are viewed, the heading bar is stretched very far with the logo and user being off the screen and accessible by scrolling.
Revision: 1.4.616.462 (30 Jun 2011)
----------------------------------
- Bug: ReconId on the 'Initiate Market Action Screen' doesn't display link to allow the user to view the reconciliation.
Revision: 1.4.615.460 (28 Jun 2011)
----------------------------------
- Market action: Added filter to initiate market action screen.
Revision: 1.4.611.454 (20 Jun 2011)
----------------------------------
- Filter: The filters will be dependent on the items (Product company,product,fund company,fund & account) with Product company least dependent and Account most dependent.
- Bug: When the Preferences is set to "dd/MM/yyyy", the Asset Allocation screen gives error while trying to view the allocation for captured date having date greater than 12.
- Bug: Report data source screen gives error when trying to add new data source.
Revision: 1.4.604.441 (06 Jun 2011)
----------------------------------
- Profiles: Users can save their filters as profiles. There is a provision to save multiple filters for a grid and edit/delete these profiles.
Revision: 1.4.601.435 (19 May 2011)
----------------------------------
- Filter: Records can be filtered on two different Tag Types/ Tags at the same time. The 'OR' condition on the Last Tag Type and Last Tag filter fields will be by default enabled.
- Added a new screen 'View Transactions Across Accounts' to view transactions across accounts associated with product companies users are assigned to.
- Added a new screen 'View Confirmations Across Accounts' to view confirmations across accounts associated with product companies users are assigned to.
- Manual Recon : Added 'Auto-Reconcile' checkbox next to the match button which when clicked will automatically reconcile the records when Match button is clicked in case of exact match. If there is a difference, the transactions will be handled as normal.
Revision: 1.4.588.408 (26 Apr 2011)
----------------------------------
- Manual capture: A new column added to show running total.
- Manual capture: Negative sign will be shown in front of the unit text box when any negative transaction type is selected.
- Manual capture: Balancing entries formatted to make them consistent with the rest of the app.
- Filter on View transaction, confirmation and manual recon changed to accept BETWEEN criteria for dates. Please enter the dates separated by comma for the BETWEEN condition.
- Tag Screen Enhancements: Filter added to Tag screen. Included TagID column.
- Dashboard: Added the file name in Import Name column for price file imports. For multiple transaction rollback definitions, column name will show text as 'Multiple Definitions'
- All references to Fund Manager changed to Management Company.
- Report name will be displayed when reports are executed.
- Filter: Fund names ordered alphabetically.
Revision: 1.4.578.380 (01 Apr 2011)
----------------------------------
- Manual capture: Instruction date will be saved as valuedate and holding source as 'Unit Register'.
- Manual capture: Opening balance value date will not be changed if the confirmation is backdated. If the latest confirmation is before the opening balance then the closing balance value date will be the same as the opening balance.
- Filters: Only Transaction Type will always be mandatory.
If fund type of selected account is 'Units' then Units will be mandatory but Amount will be optional.
If fund type of selected account is 'Amount' then Amount will be mandatory but Units will be optional.
Revision: 1.4.575.373 (25 Mar 2011)
----------------------------------
- Added date format DD/MM/YYYY in Preferences screen.
- Account filter: Associated Fund company and Fund will be populated when product company is selected in the account filter pop up.
- Price Import: The status in dashboard screen will be shown as 'Warning' if a line cannot be imported but other lines are imported without error.
- Transaction Import Rollback: The details pop up on dashboard screen will show more details like no of transactions, initiated market actions and recons removed for a given valudate.
- Bug: The confirmations on the manual recon screen reflect as positive for all transaction types.
Revision: 1.4.569.359 (14 Mar 2011)
----------------------------------
- Multiple internal codes for fund company and fund.
- Manual capture: Unit and price restricted to 6 decimals and amount to 2 decimals.
- Bug: All values in manual capture should be displayed as absolute values irrespective of the sign in the database.
- Rollback Transactions: Older imports should be allowed to be rollbacked if newer imports do not have data for accounts imported in older imports.
- User: Filter added on user screen. Default columns will be LoginName, Name and Surname.
- Bug: In manual capture screen, Price is displayed in cents but treated as Rands when calculating the amount
- Bug: The '>' and '>=' and the '<' and '<=' operators are swapped around for all date filters on the Manual Match Screen.
Revision: 1.4.561.343 (02 Mar 2011)
----------------------------------
- Manual Capture: Units and price allowed upto 6 decimals and amount upto 2 decimals only.
- Edit Manual Confirmation: All values will be displayed as absolute values irrespective of the transaction type.
- Fund Manager maintenance: Multiple internal codes are allowed.
Revision: 1.4.558.334 (24 Dec 2010)
----------------------------------
- Manual Recon: Tagged filter column renamed to Tags and added provision to filter on transactions and confirmations which are having 0, 1 or more than 1 tags.
- Manual Recon: Filter link removed from the matched section grids.Filter in top grids will be applied to grids in matched section as well.
- Numeric Value Display Format : All numeric values will be shown with a single space as the thousands separator.
- Fund maintenance: Following fields are added : Max Foreign Percentage, Max Local Equity Percentage, Max Foreign Equity Percentage
- Manual Capture: Added provision to capture backdated confirmations. It will be driven by preference setting called "Validate Value Date in Manual Confirmation Capture".
Revision: 1.4.548.313 (17 Dec 2010)
----------------------------------
- Manual Capture: Manual Capture will use the Transaction Type to determine and store the Transaction values with correct sign.
- Bug : Active process schedule with disabled scheduling runs at scheduled time. The Process has to be made inactive to stop it running.
- Bug: Initiate market action throws error sometimes.
- The HoldingSource field for manually captured confirmations will be saved as empty.
- Manual Recon: Provision to filter transactions and confirmations for tagged or untagged items only.
- Manual Recon: Added a "Show tags for all users" check box, on the right hand side of the "Load Existing Tags" drop down list, to load tags created by other users.
- Filter: Column 'Transaction Name' renamed to 'Transaction Type' for consistency.
- Increased the loading performance of RollBack Transaction screen.
- Asset Allocation: Added dropdowns for 'Management Company' and 'Fund'.
- Fund maintenance: Following fields are removed : Max Foreign Percentage, Max Local Equity Percentage, Max Foreign Equity Percentage
- Manual Recon: Provision for selection and ordering of the columns in the Matched Section for selected transactions and confirmations.
- Manual Recon: Provision for de-selecting all the checked transactions or confirmations by clicking 'Clear All' button placed next to 'Match' button.
Revision: 1.4.534.282 (24 Nov 2010)
----------------------------------
- Bug: Manual Recon Filters were not displayed correctly.
Revision: 1.4.532.278 (15 Nov 2010)
----------------------------------
- Bug: Report fails if there are XML special characters in parameter values
- Asset allocation: Delete button added to delete existing asset allocations
Fund Manager and Fund dropdowns removed. The asset allocation will be shown for the selected account's fund.
Revision: 1.4.528.268 (08 Nov 2010)
----------------------------------
- Bug: Internal and external transactions that have grouping give error while executing.
- Asset Allocation : Provision added to enter asset allocation for any date. User can edit existing asset allocations for selected fund.
- Dashboard screen refresh will be paused when the account selector window is active.
- Unresolved Transactions : Numbers in Transactions, confirmations and total columns will be shown as integers.
: Default column order in the filter will be - Account Fund Product Transactions Confirmations Total
: Contents of Account column hyperlinked with tool tip "Select account."
Revision: 1.4.524.259 (22 Oct 2010)
----------------------------------
- Bug: Inactive auto recon rules should not be available for run.
- Bug: User should not be able to click on import button again once clicked on Import Transactions,Confirmations,Transaction Details and Auto recon screen.
- Select all functionality added in import confirmations screen.
- Dashboard: File name will be shown in 'Import Name' column for file import.
Revision: 1.4.522.254 (14 Oct 2010)
----------------------------------
- Nulls suported in Internal Transaction Details Mapping.
Revision: 1.4.520.250 (04 Oct 2010)
----------------------------------
- Filter: Performance improved for loading Account dropdown.
Revision: 1.4.518.246 (27 Sep 2010)
----------------------------------
- Logout and change password link will not be shown if windows authentication is on.
Revision: 1.4.516.241 (24 Sep 2010)
----------------------------------
- Bug: Javascript error on loading accounts in filter screen when no of accounts is large.
Please add following section to web.config
<system.web.extensions>
<scripting>
<webServices>
<jsonSerialization maxJsonLength="2147483647"/>
</webServices>
</scripting>
</system.web.extensions>
- Bug: Product company, product and fund dropdowns are empty sometimes in filter screen.
Revision: 1.4.515.237 (15 Sep 2010)
----------------------------------
- Bug: Cancel button on manual recon does not stop the reconciliaton process and reconciliation is done.
- Bug: If the matched difference in manual recon screen is shown as zero after applying the rounding then no balacing entries will be created.
- Market Action: If the proposed amount/unit is less than 0.005 then market action can not be initiated.
- Exception logging: A preference setting 'Log StackTrace To EventLog' if set to true will log all the inner exceptions in event log of the installed machine.
- Asset Allocation: Three new columns added to show the calculated percentages.
- Dashboard: A new intermediate state 'Aborting' will be shown when user clicks on Kill Process link for Busy process.
- Dashboard: Kill Process link is shown next to pending processes so that they can be aborted.
- Menu: Setup Transaction Details menu items moved up level.
Revision: 1.4.507.216 (02 Sep 2010)
----------------------------------
- Bug: Filter fails or duplicates funds and accounts
- Asset Allocation: Screen accepts input as values instead of percentage. All values rounded to 2 decimals.
- Bug: User is not navigated to dashboard screen immediately after Rollback button is clicked in Rollback transactions screen.
- Account Breadcrumb: Internal codes are shown next to product and fund. Product company and fund manager removed from account breadcrumb.
- Authentication: "Access is Denied" message will be shown if windows authentication is on and user is not found in database.
- Bug: Grid scrollbar visible when no scrolling is required.
Revision: 1.4.503.202 (18 Aug 2010)
----------------------------------
- Asset allocation: Addded a new label to show users, the total of all entered Asset Allocations.
Revision: 1.4.500.196 (12 Aug 2010)
----------------------------------
- Auto scheduling: A new setting "Process Schedule User" added in Preferences screen to set the name under which the auto schedule shoud run.
Auto scheduling can be set only for those who have either admin or daily process rights.
- Manual Recon: Label renamed from "Matched Balance" to "Matched Amount".
Revision: 1.4.495.184 (06 Aug 2010)
----------------------------------
- Recon by amount : Fund having reconciliation type set to amount can be reconciled using amounts.
- A new screen added in Dashboard menu to manually run the schedules made for auto run.
Revision: 1.4.487.169 (28 July 2010)
----------------------------------
- ReconID filter column added in fund listing screen.
- Auto scheduling import process:
- The AppSetting ProcessServiceURL is deprecated from the config, and is replaced by the preference setting Moorgate Service URL
- Add following element to the ProcessService Config file under the <Service> section
<wellknown type="Twenty57.Moorgate.API.SchedulerProxy, Twenty57.Moorgate.API" mode="SingleCall" objectUri="Scheduler" />"
Revision: 1.4.487.160 (22 July 2010)
----------------------------------
- Auto scheduling import process:
Preferences screen: Added a new field "MoorgateServiceRoot URL" for configuring the service url
- Manual Recon: Clear All button added to clear all the transactions and confirmations from the match area
- Manual Recon: Tags hyperlinked in all four grids for navigating user to tag listing screen.
- Tags column added in view transactions and confirmations screen.
- Bug: Report extensions in exported reports solved.
- ReconID filter column added in view transactions and confirmations screen.
Revision: 1.4.475.128 (05 July 2010)
----------------------------------
- Manual Recon: Round Price and Amount Columns to 2 Decimal Places
- Import: Confirmation Import Truncates Balances to 4 decimals
- Import: Allow Transaction and Confirmation Imports to have empty batches with no transactions
- Bug: Transaction detail import losses transactions.
- Link for source data rules in transaction, confirmation and transaction details edit screen.
Revision: 1.4.470.116 (25 June 2010)
----------------------------------
- A new textfield called "WebHelp URL" added in Setup/Preferences to link the Moorgate WebHelp.
Revision: 1.4.466.105 (22 June 2010)
----------------------------------
- Manual Recon: Details column made removable in Transactions grid
- Grid Filter: Unselected Columns in sorted in alphabetical Order
Revision: 1.4.463.98 (18 June 2010)
----------------------------------
- Sequence functionality added in Setup/Auto Match Rules list screen. Rules will be executed in the order of sequence.
- Description column removed from the Setup/Auto Match Rules list.
- Manual Recon: Selection info from the status bar moved to label below the transaction and confirmation grids,
"Add Selected to Matched Transactions" button renamed to "Match",
"Remove" button in Matched Transactions renamed to "Clear".
- Bug#14458: Filter for the date Column where time is non-zero not fetching records.
- Manual Recon: For all decimal columns, the criteria should be compared only down to the specified number of decimal places specified in the criteria.
- Bug#14477 : Manual Recon: Change Transaction Name Column to Transaction Type
- Preference and Import: Added a new setting on the Setup/Preferences screen, called "SQL Import Timeout (seconds)" having default value of 60.
- Auto match rule editor: Description field made optional.
- New links labelled "Columns" and "Source Key Value Parameter" added in definition editor of transaction, confirmation and transaction details.
- Bug#13400: Reset Product and Account dropdowns in filter if the product company is removed from the logged in user.
- Bug#13950: Display import name and keyfield value When importing transactions, confirmations and transaction details.
- Menus: "Daily Process" renamed to "Process". Dashboard screen's title changed from "Daily Process Dashboard" to "Process Dashboard".
- Dashboard: All process items up to a maximum of the last 20, regardless of the day on which it occurred will be shown.
- Bug# 14014: The FinSwitch date format can only be dd/MM/yyyy.Only this one format from confirmation file imports will be allowed.
- Include all funds, products and accounts in filter dropdowns to which the logged in user has access. Earlier the only criteria in the dropdowns was "All".
Revision: 1.4.412.22 (24 Feb 2010)
----------------------------------
- Report Logging: ReportID, DateTime (when executed) and userID will belogged in database when report is executed.
Revision: 1.4.409.16
----------------------------------
- Filter: Added a "restore default settings" button to the grid filter, which resets it to the install defaults for the respective grid.
- Import: When override balance check is enabled, the import should ignore any balancing entries that come in import and continue creating balancing entries as it did earlier.
- Menu : About dialog added to the menu Help to show the version of the app.
Revision: 736 (22 Dec 2009)
----------------------------------
- Bug: Collapse button effect vanishes after postback
- Market action: Transactions and Account made mandatory field for filter.
- Bug#9966: Configure Date format
Revision: 723 (9 Dec 2009)
----------------------------------
- Do not show filter link if there are no records in database.
- Delete all rollback import definitions if source key field type is changed in transaction definitions.
- All the mandatory columns in filter will be moved to RHS listbox by install.
- Bug: Landing page shows error as "ExternalUnresolved column not found" if filter is already applied.
- Filter: Clear button added on filter control.
- Bug #11369: Import price process does not do anything if the file size is too big.
- Bug #10684: Error on Fund and Account maintenance listing screen before applying the filter.
- File import : Message altered to show how mmany records ignored if MissingAccountActionType is set to ignore.
Revision: 701 (1 Dec 2009)
----------------------------------
- Setting added for confirmation file import to whether fail the import or ignore the row and continue if there is an account in the file which is not found in Moorgate
- Landing page: No of columns reduced to have account heirarchy and transactions older than 2 days only.
- Session timeout: Navigate user to landing page if logged in adfter session is expired.
- Bug: Account selector inv code dropdown loses selection
- Units made mandatory in filter for view transactions and view confirmations.
Revision: 679 (18 Nov 2009)
----------------------------------
- Date format added to Prefernces screen. All date controls will populate date considering these settings.
- Performance improvement in filter control.
Revision: 762 (03 Nov 2009)
----------------------------------
- The uniqueness constraint for tag name changed as follows: the combination of Name, AccountID, TagTypeID and CreateDate must be unique.
Revision: 760 (30 Oct 2009)
----------------------------------
- New column "Details" with hyperlink in manual recon unreconciled transaction grid for loading transaction details.
Revision: 752 (28 Oct 2009)
----------------------------------
- Landing page: Click on any row to select the account in breadcrum.
Revision: 750 (27 Oct 2009)
----------------------------------
- Landing page: Only top 20 records are shown.Unresolved Total column sorted descending by default.
Revision: 741 (22 Oct 2009)
----------------------------------
- Bug: Tags should be refreshed after account change in manual recon
- Bug: Market action grid resizes on menu hover.
Revision: 737 (21 Oct 2009)
----------------------------------
- Added Asset Allocation report to reports folder in Twenty57 installation directory
- Added line number in import price file error
- Bug: Save AS New Tag deletes the original tag in manual recon
- Transaction details: Set up screen for transaction details import definition
Revision: 719 (14 Oct 2009)
----------------------------------
- Transaction details: Mapping screen for mapping fields between internaltransaction and InternalTransactionDetails.
- Preference page as admin functionality to configure following settings in web.config which can be removed from web.config.
<add key="Twenty57URL" value="http://www.twenty57.com"/>
<add key="DashboardRefreshTime" value="10"/>
<add key="AllowEditingOfProposedUnits" value="true"/>
<add key="PriceIncreasePercentage" value="100"/>
<add key="AllowEditingOfProposedPrice" value="true"/>
- Bug: Screens having filter shows EnableEventValidation error. Add attribute enableEventValidation="false" to pages element in web.config
Revision: 713 (12 Oct 2009)
----------------------------------
- Added Tag type and Tag name columns in manual recon screen.
Revision: 711 (09 Oct 2009)
----------------------------------
- Following new fields added in Fund maintenance screen
MaxForeignPercentage
MaxLocalEquityPercentage
MaxForeignEquityPercentage
Revision: 704 (07 Oct 2009)
----------------------------------
- Bug: Can not execute the stored procedure in Transaction import definitions.
- Message to be shown while removing transactions/confirmations if any RBE types associated with market actions are removed.
- Setup screen for adding transaction details import definitions.
- Connection string if not specified in auto recon rule, app connection string will be used.
Revision: 674 (30 Sep 2009)
----------------------------------
- Bug: Tag uniqueness message should be shown on the Tag pop up itself in manual recon.
- Detailed messages shown in dashboard screen for transaction import, auto recon, file imports.
Revision: 670 (25 Sep 2009)
----------------------------------
- Export to excel for transactions and confirmations
- Message shown on manual recon screen if the reconciliation creates a balancing entry.
- Two new columns ReconID and Tags added on the details tab of remove confirmations screen.
- New tab labelled Market Action added in remove confirmations screen.
- Tags count against transactions and confirmations in manual recon screen.
- Proposed price and amount added in market action
- Add following entries appsetting section in web.config file
<add key="AllowEditingOfProposedUnits" value="true"/>
<add key="PriceIncreasePercentage" value="100"/>
<add key="AllowEditingOfProposedPrice" value="true"/>
Revision: 638 (18 Sep 2009)
----------------------------------
- Landing Page showing account status of unresolved transactions
- Grid filters for fund.
- Bug: Few issues related to filter fixed.
- Bug: Can not execute stored procedure in import definitions.
Revision: 620 (11 Sep 2009)
----------------------------------
- Market actions : Add a new column ReconID in initiate market action screen.
- Add many to many standard auto recon rule as part of installation
- Same side matching in Manual recon
- Net allocation amount and mode code fields added in filter for transactions and confirmations.
- Logging the import history while importing transactions.
- Audit Unrecon functionality
- Filter on market action grid. Removed the dropdowns on the screen and moved it to filter.
- Audit Remove confirmations.
- Bug: Account selector loses dependencies.
- Bug: Error not correctly logged for incorrect auto recon XML.
- Bug: Account selector loses dependencies
- Bug: Datetime conversion error in manual recon
- Bug: Performance improvement in manual recon screen.
Revision: 531 (19 Aug 2009)
----------------------------------
- Audit marketaction
- Bug: Change MoorGate to Moorgate
- Asset Allocation
- Bug: Arrange elements alphbetically in List control
- Bug: Image on the Login Screen Not Resizing
Revision: 518 (5 Aug 2009)
----------------------------------
- RBE records to have valuedate = max(valuedate) of transaction/confirmation
Revision: 508 (3 Aug 2009)
----------------------------------
- Market Actions
- Added details link in Dashboard screen
- Made import messages more generic.
- Transactions and confirmations view screen sorted desc by id.
Revision: 462 (17 July 2009)
----------------------------------
- Net allocation amount and mode code in confirmation import
- Renamed table InternalImportBatch to InternalBatch.
- Renamed table ExternalImportBatch to ExternalBatch.
- Few columns realigned in manual recon, auto match, tag details and recon details screen.
Revision: 448 (10 July 2009)
----------------------------------
- Net Allocation amount in transaction import
- View transactions/confirmations screen shows records in descending order by id.
- Tag dropdown in manual recon.
- View Tags including the load tag and view tag.
- Bug: Uninstall does not remove the process service.
- Bug: Account selector does not work properly on manual recon.
- Bug 7417: Manual match multiple record selection
Revision: 419 (26 June 2009)
----------------------------------
- Adding RBE types in batches during reconciliation process.
Revision: 408 (22 June 2009)
----------------------------------
- Reports
- Add following in Web.config under <httpHandlers> to run the reports if installation is in upgrade mode.
<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
- Install "Microsoft Report Viewer" Redistributable on the web server to view the reports.
- Add the standard reports in SetUp|Reports by browsing the RDL files at location "C:\Program Files\Twenty57 Moorgate\Reports"
- Remove Confirmations for the selected account from specified date.
- Only active import definitions will be shown in Import Transactions/Confirmations screen.
Revision: 361 - 395 (16 June 2009)
----------------------------------
- Changes made in transaction and confirmation import to save the balancing entries in batches.
- Capture Confirmations : Balancing entries shown above the grid. Type dropdown loads extended types. Closing balance valuedate = latest valuedate of all the confirmations.
- Price = zero not allowed for Purchase transactions and confirmations import.
- Role based access
- Extending transaction types: Changes made in imports to consume the extended transaction types.
- Fixed filter issue.
- Dashboard: Add following key in Web.config setting under <appSettings> to configure the auto refresh time.
<add key="DashboardRefreshTime" value="20"/>
- Dashboard: Paging applied.
- Capture Confirmations : Save the balancing entries in batch table.
- Run following query if “Update 2009-05-25 16h12 VS - Add New Columns To Hold Balance Values And Create Relationship In ExternalImportBatchTable Table.sql” script file fails
DELETE FROM ExternalBatch
WHERE ID NOT IN
(SELECT ExternalBatchID FROM ExternalTransaction WHERE ExternalBatchID IS NOT NULL)
- Run following query of still build fails
UPDATE ExternalTransaction
SET ExternalTransaction.ValueDate = CurrentTransactionWithPrevValueDate.valueDate FROM
(SELECT ExternalTransaction.ValueDate,CurrentID
FROM ExternalTransaction INNER JOIN
(SELECT ID AS CurrentID,
(SELECT MAX(ID)
FROM ExternalTransaction AS a
WHERE (ID < tra.ID)) AS prevID
FROM ExternalTransaction AS tra
WHERE (TransactionCaptureTypeID = 2) AND (TransactionTypeID = 2) AND (ValueDate IS NULL)) AS PrevTransaction ON
ExternalTransaction.ID = PrevTransaction.prevID) AS CurrentTransactionWithPrevValueDate
where ExternalTransaction.ID = CurrentTransactionWithPrevValueDate.currentID
Revision: 343 - 361 (21 May 2009)
----------------------------------
- Extend transaction types. Types used by application (i.e RBEP, RBEN etc) not editable. (Standing data)
- Release note creation and inclusion.
- Capture/Edit confirmations : Warning message if amount is not exact multiple of units and product.
- Bugs:
- Confirmation Capture: Cancel Button.
- Ability to remove standard columns in filter.
- Account selector to show only those product companies to which logged in user is associated with.
- Account filter should reset if the user is de-associated with the product company belonging to the selected account.
Revision: 270 - 336 (13 May 2009)
----------------------------------
- Edit last manually captured confirmation batch.
- Reconid in view transactions and confirmation screen.
- Remove reconcilication. Removes all the RBE types before removing the reconciliation.
- Change password in user maintenance screen. (Admin functionality)
- Tags
- Add tag in manual recon screen.
- View tags (basic view).
- Tag Types maintenance screen. (Standing data)
- Import definitions: Override balance check if balancing entries not present in source data.
- Capture Confirmations: Warning message if amount is not exact multiple of units and price.
- Bugs:
- Web.config setting under <appSettings> to configure the url for text "Powered by twenty57".
<add key="Twenty57URL" value="http://www.Twenty57.com" />
- Clear selected transactions and confirmations when account is changed.
- When all the confirmations are deleted in edit confirmations, whole batch should be removed.
- Move columns not working on transaction view screen.
- Edit User: Product Company assigned to the user should not appear in the Available product company box.
- Confirmation Capture: Price and Amount should be blank for balances
- Connection String TextBox limit extended to 200 characters
- File Import
- File should have balancing entries.
- Opening balance for account should be equal to previous closing balance.
- Opening balance + transactions = Closing balance.
- Opening balance record should be immediate next to closing balance record of the account.
Revision: 270 (20 March 2009)
-----------------------------
Functionality included in release 1:
- Transaction SQL import
- View Transactions with filter.
- Confirmation SQL import
- View Confirmations with filter.
- Confirmation file import
- The file layout is as follows (tab delimited)
Message Type Code
Message Type Name
Type Code
Type Name
ManCo Code
ManCo Name
Fund Code
Fund Name
Bulked Investor Code
Bulked Investor Name
Product Code
Product Name
Account No
Reference No
Value Date
Price
Units
Currency
Amount
Cycle Date
FinSwitch Reference No
Status
Validation Status
Agents Commission
Management Fee
VAT
Net Allocation Amount
- Confirmation manual capture
- Manual recon, with balancing entries
- Run auto recon
- Daily Process Dashboard: Status of all the imports run today by the logged in user.
- Static data inclusion : Standard transaction types.
- Standing Data Maintenance
- User Profiles. User product company mapping.
- Product Companies
- Products
- Management companies
- Funds
- Accounts
- Transactions import definitions
- Confirmations import definitions
- Auto match rules. Test the rules and display the records to be reconciled.
-Default rule by the name "Match by Account,TransactionType, Units, ValueDate and a 10 day date range" already added during installation.
- Format of auto match rule as below
<ReconDefinition xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" Name="Match by Account,TransactionType, Units, ValueDate and a 10 day date range">
<LeftDataset Name="leftDataset">
<Command OrderFields="1,4" UniqueFields="0" Name="leftDataset" CommandType="Text">
<Fields>
<FieldDefinition Ordinal="0" Name="ID" Key="true" DataType="Int32" />
<FieldDefinition Ordinal="1" Name="AccountID" Key="false" DataType="Int32" />
<FieldDefinition Ordinal="2" Name="HoldingSource" Key="false" DataType="String" />
<FieldDefinition Ordinal="3" Name="ConfirmationDate" Key="false" DataType="DateTime" />
<FieldDefinition Ordinal="4" Name="TransactionTypeID" Key="false" DataType="Int32" />
<FieldDefinition Ordinal="5" Name="ValueDate" Key="false" DataType="DateTime" />
<FieldDefinition Ordinal="6" Name="Units" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="7" Name="Price" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="8" Name="Amount" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="9" Name="ReferenceNumber" Key="false" DataType="String" />
<FieldDefinition Ordinal="10" Name="Reference1" Key="false" DataType="String" />
<FieldDefinition Ordinal="11" Name="Reference2" Key="false" DataType="String" />
<FieldDefinition Ordinal="12" Name="Reference3" Key="false" DataType="String" />
<FieldDefinition Ordinal="13" Name="Reference4" Key="false" DataType="String" />
<FieldDefinition Ordinal="14" Name="Reference5" Key="false" DataType="String" />
<FieldDefinition Ordinal="15" Name="DateReference1" Key="false" DataType="DateTime" />
<FieldDefinition Ordinal="16" Name="DateReference2" Key="false" DataType="DateTime" />
<FieldDefinition Ordinal="17" Name="AgentCommission" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="18" Name="ManagementFee" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="19" Name="VAT" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="20" Name="ReconciliationID" Key="false" DataType="Int32" />
<FieldDefinition Ordinal="21" Name="InternalCode" Key="false" DataType="String" />
<FieldDefinition Ordinal="22" Name="ExternalCode" Key="false" DataType="String" />
<FieldDefinition Ordinal="22" Name="ExternalCode" Key="false" DataType="String" />
<FieldDefinition Ordinal="23" Name="InstructionDate" Key="false" DataType="DateTime" />
</Fields>
<Database DbType="Sql">
<ConnectionString Name="">Data Source=server;User ID=user;Password=password;Initial Catalog=database;</ConnectionString>
</Database>
<CommandText>SELECT InternalTransaction.ID, AccountID, HoldingSource, ConfirmationDate, TransactionTypeID, ValueDate,
Units, Price, Amount, ReferenceNumber, Reference1, Reference2, Reference3, Reference4, Reference5, DateReference1,
DateReference2, AgentCommission, ManagementFee, VAT, ReconciliationID, InternalCode, ExternalCode, ValueDate AS
InstructionDate FROM dbo.InternalTransaction INNER JOIN dbo.Account ON InternalTransaction.AccountID = Account.ID
WHERE (TransactionTypeID NOT IN (1, 2)) AND (ReconciliationID IS NULL) AND (Account.ProductID &lt;&gt; 1) ORDER BY
InternalTransaction.AccountID, TransactionTypeID</CommandText>
</Command>
</LeftDataset>
<RightDataset Name="rightDataset">
<Command OrderFields="1, 4" UniqueFields="0" Name="rightDataset" CommandType="Text">
<Fields>
<FieldDefinition Ordinal="0" Name="ID" Key="true" DataType="Int32" />
<FieldDefinition Ordinal="1" Name="AccountID" Key="false" DataType="Int32" />
<FieldDefinition Ordinal="2" Name="HoldingSource" Key="false" DataType="String" />
<FieldDefinition Ordinal="3" Name="ConfirmationDate" Key="false" DataType="DateTime" />
<FieldDefinition Ordinal="4" Name="TransactionTypeID" Key="false" DataType="Int32" />
<FieldDefinition Ordinal="5" Name="ValueDate" Key="false" DataType="DateTime" />
<FieldDefinition Ordinal="6" Name="Units" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="7" Name="Price" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="8" Name="Amount" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="9" Name="ReferenceNumber" Key="false" DataType="String" />
<FieldDefinition Ordinal="10" Name="Reference1" Key="false" DataType="String" />
<FieldDefinition Ordinal="11" Name="Reference2" Key="false" DataType="String" />
<FieldDefinition Ordinal="12" Name="Reference3" Key="false" DataType="String" />
<FieldDefinition Ordinal="13" Name="Reference4" Key="false" DataType="String" />
<FieldDefinition Ordinal="14" Name="Reference5" Key="false" DataType="String" />
<FieldDefinition Ordinal="15" Name="DateReference1" Key="false" DataType="DateTime" />
<FieldDefinition Ordinal="16" Name="DateReference2" Key="false" DataType="DateTime" />
<FieldDefinition Ordinal="17" Name="AgentCommission" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="18" Name="ManagementFee" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="19" Name="VAT" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="20" Name="ReconciliationID" Key="false" DataType="Int32" />
<FieldDefinition Ordinal="21" Name="InternalCode" Key="false" DataType="String" />
<FieldDefinition Ordinal="22" Name="ExternalCode" Key="false" DataType="String" />
<FieldDefinition Ordinal="23" Name="InstructionDate" Key="false" DataType="DateTime" />
<FieldDefinition Ordinal="24" Name="TransactionCaptureTypeID" Key="false" DataType="Int32" />
</Fields>
<Database DbType="Sql">
<ConnectionString Name="">Data Source=server;User ID=user;Password=password;Initial Catalog=database;</ConnectionString>
</Database>
<CommandText>SELECT ExternalTransaction.ID, AccountID, HoldingSource, ConfirmationDate, TransactionTypeID,
ValueDate, Units, Price, Amount, ReferenceNumber, Reference1, Reference2, Reference3, Reference4, Reference5, DateReference1,
DateReference2, AgentCommission, ManagementFee, VAT, ReconciliationID, InternalCode, ExternalCode, ValueDate AS InstructionDate,
TransactionCaptureTypeID FROM dbo.ExternalTransaction INNER JOIN dbo.Account ON ExternalTransaction.AccountID = Account.ID
WHERE (TransactionTypeID NOT IN (1, 2)) AND (ReconciliationID IS NULL) AND (Account.ProductID &lt;&gt; 1)
ORDER BY ExternalTransaction.AccountID, TransactionTypeID</CommandText>
</Command>
</RightDataset>
<Matches>
<MatchDefinition Name="" Expression="(LHS.GetInt32(1)==RHS.GetInt32(1))" />
<MatchDefinition Name="" Expression="(LHS.GetInt32(4)==RHS.GetInt32(4))" />
<MatchDefinition Name="" Expression="(LHS.GetDecimal(6)==RHS.GetDecimal(6))" />
<MatchDefinition Name="" Expression="Math.Abs(LHS.GetDateTime(5).Subtract(RHS.GetDateTime(5)).Days)&lt;=10" />
</Matches>
</ReconDefinition>
- Logout
Release 1 extras:
- UnitRecon data migration script (import definitions copied, but update will be manual)
- Sample database migrated from UnitRecon obfuscated data (login is admin/password)
Release 1.15.1272.1907 (08 February 2022)
----------------------------------------
Support
- ZEN11296 - Updated DB Indexes.
- ZEN11142 - Corrected spelling error - Manual Recon (Consolidated) - When the user selects a tag in the Load a Tag drop down, then changes the selection, the message: "Clearing the selected records before loading the tagged records to selected selection. Please confirm to proceed."
Release 1.15.1269.1898 (06 April 2022)
----------------------------------------
Support
- ZEN9563 - Reports - Fixed message 'Fetching more reports...' displaying incorrectly after all reports have loaded when displaying 40+ reports
Maintenance
- Upgraded application to .Net 4.8
- Added browser support for MS Edge (Chromium) and Google Chrome
Release 1.15.1267.1890 (22 February 2021)
----------------------------------------
Support
- ZEN9808 - Remove Confirmation - updated to allow empty batches to be removed.
Release 1.14.1264.1883 (30 November 2021)
----------------------------------------
Features
- ZEN9300 - Added option on Product Company to restrict unreconciliation based on Linx web service validation.
- ZEN9299 - Added option on Product Company to restrict reconciliations to 1 to 1 matches only.
Support
- ZEN9363 - Fixed issue with link for paging to last page on the Process Dashboard.
Release 1.14.1259.1870 (11 June 2021)
----------------------------------------
Support
ZEN8449 - Process Dashboard - Updated page to display older records
Release 1.14.1258.1868 (29 March 2021)
----------------------------------------
Improvements
- ZEN7893 - Added Product Company configuration to optionally validate Amount (Rand) = Units x Price (cents) on Confirmation import
Release 1.14.1254.1848 (03 March 2021)
----------------------------------------
Maintenance
- MG282 - Encrypted passwords at rest for connection strings. The following configurations to need to be updated:
Re-save the configuration - Auto Recon Rules
If using SQL Login, remove the credentials from the connection string and capture into the Username and Password fields - Confirmation Import Definitions, Transaction Import Definitions, Transaction Detail Import Definitions
Fixes
- ZEN7857 – Fixed issue with duplicate transactions on Confirmation Import when Override Balance Check = True, and the data contains balance records
- MG291– Fixed issue with duplicate transactions on Transaction Import when Override Balance Check = True, and the data contains balance records
- MG293 - Fixed issue with Delete button error (since v1.14.1250.1848) following pages:
Account List
Asset Allocation List
Balancing Entry Type List
RDL Data Source List
RDL Report List
Tag List
Tag Type List
Transaction Type List
Release 1.14.1250.1848 (19 November 2020)
----------------------------------------
Fixes
- ZEN7470 - Fixed issue with Remove Confirmations removing TagExternalTransaction records for all accounts (since v1.13.1241.1824)
- ZEN7331 & ZEN7379 - Fixed various issues with the Process Queue.
Fixed issue with Process Queue not starting when Process Service starts.
Added a support page for Process Queue clean up and force start (Refer to notes on the page).
Fixed issue with Process Errors that occur after the work has been done and committed but before the Status and Logs are updated. All processes will now update the status and update the logs inside the SQL transaction to either complete all work or non. Auto Recons will still commit in sub batches, and can be rerun to complete the remainder of recons after a failure or abort.
All processes have been updated:
File Confirmation Import.
File Confirmation Re-import.
Transaction Import.
Confirmation Import.
Transaction Import History Rollback.
Transaction Details Import.
Confirmation Import History Rollback.
Transaction Details Import History Rollback.
Bulk Initiate Market Action.
Auto Reconciliation.
Service Asset Allocation.
File Asset Allocation.
Service Price Import.
File Price Import.
Remove Confirmation.
Release 1.13.1246.1840 (06 October 2020)
----------------------------------------
Features
(v1.13.1241.1824)
- MG219 - Added Asset Allocation Reports
Asset Allocation Not Totaling 100% (Standard)
On upgrade, DB and Reports folder will be updated with these reports.
Support
(v1.13.1241.1824)
- ZEN6391 - Optimization - Bulk Initiate Market Action improve processing time
- ZEN5479 - Optimizations
Confirmations Rollback
Internal Transaction Rollback
Internal Transaction Details Rollback
- MG268 - Fixed bug with saving Asset Allocation when decimals fields are empty. Defaulted empty fields to 0.00 on data load.
- MG269 - Fixed bug on Manual Capture page where Clear button would not clear selected Confirmations.
- MG239 - jQuery upgrade
(v1.13.1243.1834)
- ZEN6679 - Transaction Import Definition - Added option to set batch closing balance date to last sequential transaction (default) or closing balance date. Refer to tooltips for more info
- (v1.13.1246.1840)
- MG279 - Added database indexes:
IX_ExternalTransaction_ExternalBatchID
IX_ExternalBatch_AccountID
IX_ExternalBatch_ClosingBalanceDate
jQuery upgrade notes:
Upon upgrade, some sites may need to add this setting on the web.config
<globalization culture="en-US" uiCulture="en-US" />
------Pages Affected------
1. userList.aspx
2. UserEditor.aspx
3. TransactionTypeList.aspx
4. TransactionTypeEditor.aspx
5. TagTypeList.aspx
6. BalancingEntryTypeList.aspx
7. ProductCompanyList.aspx
8. ProductList.aspx
9. FundCompanyList.aspx
10. FundList.aspx
11. AccountList.aspx
12. InternalTransactionImportDefinitionList.aspx
13. InternalTransactionImportDefinitionEditor.aspx
14. ExternalTransactionImportDefinitionList.aspx
15. PriceImportDefinitionList.aspx
16. AssetAllocationImportDefinitionList.aspx
17. InternalTransactionDetailsImportDefinitionList.aspx
18. AutoMatchRuleList.aspx
19. AutoMatchRuleEditor.aspx - JS error
20. BulkInitiateMarketActionFilterList.aspx
21. ProcessScheduleEditor.aspx
22. RDLReportList.aspx
23. RDLDataSourceList.aspx
24. AssetAllocationList.aspx
25. AssetAllocation.aspx
26. ImportDashboard.aspx
27. LandingPage.aspx
28. InternalTransactionDetailsImportList.aspx
29. ExternalTransactionImportList.aspx
30. FailedConfirmations.aspx
31. RemoveConfirmations.aspx
32. ReconciliationDetails.aspx
33. RollbackInternalTransactionImport.aspx
34. RollbackInternalTransactionDetailsImport.aspx
35. RollbackExternalTransactionImport.aspx
36. MarketAction.aspx
37. BulkInitiateMarketAction.aspx
38. TagList.aspx
39. InternalTransactionAllAccountsList.aspx
40. ExternalTransactionAllAccountsList.aspx
41. AutoReconciliation.aspx
42. ViewTagDetails.aspx - non-unique IDs
43. ManualReconConsolidated.aspx - JSONParse changes and other jquery event calls
44. RDLActiveReportList.aspx
45. RDLReportView.aspx
Note: Release 1.13.1241.1824 (10 June 2020) and Release 1.13.1243.1834 (18 June 2020) have been retracted due to a dependency on a SQL Server 2017 feature. The following features have been retracted from v1.13.1241.1824:
Features
- MG219 - Added Asset Allocation Reports
Asset Allocation Quarterly Report (Standard)
Asset Allocation All Data (Standard)
Release 1.12.1225.1784 (14 April 2020)
----------------------------------------
Support
- MG256 - Fixed issue with New Profiles and Restore Default button resetting Account filter to 0 instead of All
- ZEN6197 - Remove Confirmations - moved the the execution to a process to prevent UI timeouts when working with large datasets.
- ZEN6078 - Consolidated Recon Screen - Prevent Apply & Hide button from being clicked until column change scripts have completed
- ZEN6402 - Bulk Initiate Market Action config - added Balancing Entry Type to Test button filtering. Optimized the Bulk Initiate Market Action process
Release 1.10.1220.1772 (30 March 2020)
----------------------------------------
Features
- ZEN6087 - Account Selector - updated from "starts with" lookup, to "like" lookup condition.
- ZEN6032 - New Recon Page - Account Filter - updated to "like" lookup condition.
Support
- ZEN6090 - Updated the below configurations to encrypt passwords at rest
Upon upgrade, the following configurations must have the password recaptured and re-saved
- Price Import Definition
- Confirmation Import Definition
- Asset Allocation Import Definition
Release 1.9.1215.1761 (03 February 2020)
----------------------------------------
Features
- ZEN4843 - New Recon Screen - updated labels
- MG199 - Asset Allocation - Added Process Definitions and Source Key by quarter for web service imports, updated manual run dates to display quarters
Support
- ZEN5358 - Added a validation on the recon step to check if any transaction from the reconciliation group has already been reconciled. Manual Transactions will display a warning prompt for this scenario, Automated Transactions will skip the reconciliation.
- ZEN5479 - Optimized queries on Confirmations Rollback
Large datasets may require a system level config change to the transaction timeout
File:
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config
Add Key:
<system.transactions>
<machineSettings maxTimeout="04:00:00" />
</system.transactions>
Release 1.8.1210.1749 (17 January 2020)
----------------------------------------
Features
- ZEN5621 - Updated the account selector to include a direct search for account by ([Account Number] - [Product Name] - [Fund Name] )
- ZEN4856 - Added a Finswitch WebService API for Asset Allocation Imports
- ZEN5285 - Added a link to the Process Dashboard to display data from Successful Confirmation imports
- ZEN4843 - Added Manual Recon (Consolidated) screen
- ZEN5265 - Added Web Services to invoke the following processes:
ImportConfirmations
ImportTransactionDetails
ImportTransactions
RunAutoReconciliation
The webservices are access via the URL
http://[Instance]/Services/WebServices.asmx
http://[Instance]/Services/WebServices.asmx?wsdl
The following must be added to the web config if upgrading from an older version of Moorgate:
<location path="Services/WebServices.asmx">
<system.web>
<authorization>
<allow users="*" />
</authorization>
</system.web>
</location>
Support
- MG247 - Fixed issue with Home (Unresolved Transactions) page displaying accounts where user does not have access
Release 1.5.1165.1592 (16 August 2019)
----------------------------------------
Features
- ZEN4857 - Unresolved Transactions screen - added count of accounts being displayed
Support
- ZEN4858 - Fixed issue errors loading tag that has been disabled, prevent user from saving tags that have been marked as inactive
- ZEN4862 - Corrected heading labels when editing an Asset Allocation
- ZEN4878 - Added additional details to process log for Confirmation SQL Import
Release 1.5.1160.1579 (20 June 2019)
----------------------------------------
- Asset Allocation enhancements
Imported FinSwitch asset allocation records with status = CORRECTED now update appropriately in the Moorgate database.
FinSwitch file imports no longer fail for multiple records in the file and where there is at least one record with a validation error. Valid records are updated in the Moorgate database and invalid records return an error message viewable per the Dashboard details link.
Release 1.5.1158.1575 (07 June 2019)
----------------------------------------
- Asset Allocation feature
The old Asset Allocation feature was updated to accommodate the current SARB format
The Moorgate application now allows for the importing of FinSwitch Asset Allocation file types as well as allows for capturing and editing of fund asset allocations manually via the Moorgate front-end
For FinSwitch Asset Allocation imports, the following fields are calculated and not validated if the fields are not populated in the FinSwitch file
> Local - Actual % of Portfolio
> Foreign - Actual % of Portfolio
> Total %
For manual capture via the Moorgate front-end, the following fields are calculated and by Moorgate:
> Local - Actual % of Portfolio
> Foreign - Actual % of Portfolio
> Total % - (also validated to equal 100.00%)
> Equities (sub-total)
- Fixed an issue where an inactive user was able to access the application when Windows Authentication is applied
- Enhanced the Moorgate FinSwitch web service call functionality to accommodate FinSwitch TLS 1.2 security upgrades and TLS 1.0 and TLS 1.1 deprecation
Release 1.5.1143.1538 (07 March 2019)
----------------------------------------
- Fixed an issue where including the Last Tag Type and/or Last Tag filter columns on the manual recon causes an error when dragging transactions down for matching
- Fixed an issue when a new user created logs in without selecting the account and navigates to the Manual Recon page
- Fixed an issue when clicking on an account on the LandingPage.aspx, which navigates to the ManualRecon page and the Filter not being applied - where LastTag, LastTagType column is selected within filter
- Fixed an issue when clicking 'Export to CSV' button where multiple aliased references were included in the filter
Release 1.5.1141.1534 (05 February 2019)
----------------------------------------
- Fixed an issue where selecting a filter profile did not update the records returned
Release 1.5.1140.1532 (23 January 2019)
----------------------------------------
- Fixed an issue where selecting all market action items, subsequently deselecting a few market action items and clicking authorise results in all market action items in the filter being authorised
Release 1.5.1138.1528 (10 January 2019)
----------------------------------------
- Fixed an issue where the incorrect column name was displayed on the Capture Confirmation page
Release 1.5.1137.1526 (12 December 2018)
----------------------------------------
- Fixed an issue when using Internet Explorer, where viewing a report containing a high amount of data resulted in the data being displayed outside the report frame
- Fixed an issue where viewing details of a recon related to MarketActionIDs greater than a certain threshold resulted in an error
- Improved the FinSwitch Confirmation web service functionality to now also allow downloading of Calastone confirmation files (fileType = CCT)
- Calastone Confirmation files can also be imported manually
- Improved the account selector filter dropdown for funds to display data #Internal Code# - #External Code# - #Fund Name#
- Field Aliases (References 1-5) per Product Company are now configurable on Product Company editor page
- User role 'Support' added with the following page rights:
Setup - Transaction Types
Setup - Transaction Import Definitions
Setup - Confirmation Import Definitions
Setup - Price Import Definitions
Setup - Transaction Detail Imports
Setup - Transaction Detail Mapping
Setup - Auto Match Rules
Setup - Bulk Initiate Market Action Filters
Setup - Process Schedule
Setup - Reports
Setup - Preferences
Setup - Audit Log
Release 1.5.1126.1501 (6 September 2018)
----------------------------------------
- Proxy settings are now configurable in Setup>Preferences.
- FinSwitch web service confirmation and price import definitions now have an additional parameter called 'Enable Proxy' for proxy settings applied to the call.
Release 1.5.1122.1493 (10 July 2018)
----------------------------------------
- Process Dashboard now correctly filters for the last 20 items per the filter criteria set.
- Market Action error on authorisation "Input string was not in a correct format" has been addressed
- Market Action 'Initiate Market Action' button is no longer incorrectly greyed out when selecting all entries and then deselecting an entry on another page.
Release 1.5.1119.1487 (14 May 2018)
----------------------------------------
- Confirmation Import Definition now includes a FinSwitch web service call import type
- Bulk Initiate Market Action feature has been added
- Price Import Definition has been improved to allow filedate parameter to be set to current date or previous day's date
- Market Action page has been improved with a check box to select all check boxes across all pages
Release 1.5.1094.1427 (13 September 2017)
----------------------------------------
- Fixed a bug where paging disappeared when clicking on # of entries and closing the pop-up on Failed confirmations page
- Fixed an bug where loading a tag from the ViewTagDetails page resulted in a page load error
- Fixed an issue where attempting to delete an unreconciled tag from the ViewTagDetails page had no effect
- Fixed a bug where details link on Manualreconciliation page resulted in a page load error
- Fixed a bug where clicking a specific ReconID on the InternalTransactionAllAccountsList page would navigate the user to the incorrect ReconID
- Fixed a bug where clicking the 'Cancel' button would navigate the user to the incorrect page
- Fixed a bug where clicking 'Cancel' for Save Tag had no effect
- Fixed a bug where clicking 'Cancel' from the ReconciliationDetails page navigated to the incorrect page
- Fixed a bug where paging on ReconciliationDetails page was not working correctly
- Fixed a bug where paging for Transactions and Confirmations on the TagEditor page was not working correctly
- Fixed a bug where paging for Marketactions page was not working correctly
- Fix applied to prevent Manual reconciliation page from refreshing when using the Account Selector link to select a different Product, Management Company and Fund
- Fixed a bug where authorising an Initiated Market action did not change the status
- Fixed a bug where filtering Price, Units or Amounts with 'Like' condition would result in a page load error
- Fixed a bug on the TagEditor page. The message popup for 'Send Email' checkbox no longer loops when the user has no email address.
- Fixed a bug where the Email field was not validated on the UserEditor page
- Queries loading data for pages InternalTransactionList, InternalTransactionAllAccountsList, ExternalTransactionList, ExternalTransactionAllAccountsList improved to increase page loading speed
- Current Reconciliation Status Report calculated fields updated
- Internal and external transactions are now validated that all the transactions are in the same account.
- Deleting and paging improvements made where the option to delete or select different page numbers are available
- Test function in Transaction Import definition editor now works for Oracle queries with sub-queries
- Added the following setting to web.config
<add key=""CommandTimeout"" value=""3600""/>
- Chrome browser - Landing page. Grid links now show an icon on mouse hover.
- Chrome browser - Landing page. Fixed a bug where clicking an Account number would result in an JS error
- Chrome browser - Failed Confirmations page. Fixed a bug preventing failed confirmations from being removable.
- Chrome browser - Failed Confirmations page. Fixed a bug preventing the filter popup from being displayed.
- Chrome browser - TagEditor page. Fixed a bug where 'Save as New Tag' was incorrectly enabled but should have been disabled
- Internet Explorer 9 browser - Import Confirmations page. Fixed a bug where 'Choose File' button was not visible.
Release 1.4.1060.1340 (28 September 2016)
----------------------------------------
- Rollback Transaction Detail Imports
- Assign the default balancing entry type to small differences created through the auto-reconcile functionality on the Manual Recon screen
- HO/HC balance codes now supported on all Import Definitions
- Fix: Product Company setting Confirmation File Import Missing Account Action is honoured
- Fix: Batch ordering and processing handled correctly when the Finswitch file contains incomplete batches
- Fix: Filters on Failed Confirmation Screen
Release 1.4.1056.1331 (29 February 2016)
----------------------------------------
- Processing of Finswitch Files containing Holding Opening (HO) and Holding Closing (HC) balances
- Hide Inactive accounts on the Home Screen
- Default Fund Price Field added for Amount Type Funds
- Product, Fund and Account information included in the Tag Email
Release 1.4.1047.1311 (18 January 2016)
----------------------------------------
- Check to ensure already reconciled items cannot be reconciled again
- Data Refresh is complete and consistent when working on multiple tabs
- Pop-up Warning that the account change is going to happen has been removed
- If the account is changed while on the Edit Tag screen, the user is navigated to the Home Screen without the tag being saved
Release: 1.4.1044.1304 (10 December 2015)
-----------------------------------------
- Moorgate now installs on Windows 10/IIS 10
- More readable messages when an error occurs during install
- If the install fails you can select to view the log file directly from the msi.
- Remove and Rollback functionality has been separated out from the Capturer Role into a new role Remove Data
- Recons now match to the 6th decimal place and Balancing entries are created accordingly
- Update to the stored procedure Rpt_ConsolidatedReportStandard to use the Internal Batch Closing Balance rather than calculating it
- Ensure data integrity is maintained when a user has 2 tabs open at the same time
- Test Oracle Import Definition now works correctly. You will need to add the following settings to your config files
- appSettings section of the web.config file:
<add key="OracleImporterURL" value="tcp://localhost:8090/OracleImporter" />
- services section of the ProcessService.exe.config file
<wellknown type="Twenty57.Moorgate.API.OracleImporterProxy, Twenty57.Moorgate.API" mode="SingleCall" objectUri ="OracleImporter" />
- Oracle Stored procedures are now supported for all Import Definitions
- The release notes have been moved to this page
- The Release notes link under the Help Menu will direct you here
Release: 1.4.1029.1264 (20 January 2015)
---------------------------------------
- SMTP settings moved to the Preferences screen and stored in the database
- Unit Difference between transactions and confirmations displayed alongside the amount difference on the Add/Edit Tag Screen
- Better handling of failed Finswitch Confirmation batches that don't have codes
- New Setting per Product Company: Confirmation File Non-Zero First Balance Action
- Transaction Import Tolerance extended to Opening Balance = Previous Closing Balance check
- Help link navigates to http://help.moorgate.twenty57.com
- Fixed: Finswitch File Import and Capture Confirmations works independently of Regional Date Format
- Fixed: Instruction Date not lost when additional rows added on the Capture, Edit and Failed Confirmations Screen
- Fixed: Menu spelling typo:
Revision: 1.4.1017.1237 (18 June 2014)
---------------------------------------
- Allow for a tolerance (for rounding errors) on internal transactions when checking opening balance + nett transactions = closing balance.
Revision: 1.4.1016.1235 (17 April 2014)
---------------------------------------
- New standard report, User Activity Report (Standard).
- New standard report on failed confirmations.
- Management Companies now have a new setting Confirmation Source which specifies where the confirmations will come from. Options are Finswitch and Confirmation Import Definition. Only data from the selected source will be processed for the management company.
- Transaction Imports will now show all failures and not just the first one.
- Audit Trail for Static Data Changes.
- The new Holdings Balance message type on Finswitch Confirmation file will be ignored.
- The entire Finswitch Confirmation import can now be rolled back.
- Added Created by and Created Date to the Market Action screen.
- Instruction Date displayed on Failed Confirmation Screen.
- Cycledate is now mandatory on Transaction Import Definitions.
- Consolidated report logic changed to calculate closing balances from opening balance + sum(transactions) on both transactions and confirmations.
- Email notification on saving a tag.
- Removed the results limit on the unresolved Transactions Screen.
- Allow for internal names to be displayed on the Failed confirmations page.
- Allow filtering on the dashboard page.
- Update Reports to report viewer 2012.
Bug Fixes:
- Manual Recon Account selector was empty under certain conditions.
- Recon balancing entry "disappearing" from manual recon screen.
- Prevent the Object reference error on matching a single confirmation where there is no transaction batch. An empty transaction batch will be created and the balancing entry will be put in it.
- Prevent rerunning a transaction import while once it has been started.
Revision: 1.4.948.1116 (4 October 2013)
---------------------------------------
- Automatically import prices using the Finswitch Web service.
- Same side auto match rules are allowed.
- Limit Internal codes to the first four in the account selector pop-up.
- Bug Fix: Failed Confirmation Screen error when the opening balance is zero.
- Fixed Manager role permissions.
Revision: 1.4.918.1068 (3 June 2013)
----------------------------------
- View transaction: Fixed error while export to excel.
- Updated database import error message.
- Market Action Screen: Add Columns Created By and Created Date.
- Consolidated Report enhancements.
- Report view enhancements.
- Fixed List screen errors related to VirtualItemCount.
Revision: 1.4.907.1046 (18 Mar 2013)
----------------------------------
- Market Acton screen:
- Allow paging through the grid once market action is initiated.
- Populate the proposed Units column with the Initiated value.
- Activate the Recon link.
- Report List Screen: No paging to be displayed.
- Reports: Included these Reports as Standard Reports:
- Captured Confirmations Report
- Consolidated Report To Date
- Bug: Auto Match Rules: The test button is not working.
- Failed Confirmation screen: Show the difference between the FS and Moorgate Closing balances.
Revision: 1.4.888.1001 (5 Nov 2012)
----------------------------------
- Bug: Manual Recon Screen: The Last tag type and Last Tag columns are not shown when the transaction is loaded into the Matched Section.
- Bug: Confirmation Import process: Imports process is creating the Opening and Closing balance records in the External Transaction.
- Market Acton screen: Prevent multiple clicks of Initiate Market Action button.
- Failed Confirmation screen:
- Confirmation records were Opening balance units not match due to decimal places issue.
- Add a filter to the Failed Confirmations Screen.
- Export to CSV.
- Account Selector: Display Products dropdown in alphabetical order.
- Tag Types menu: Place Tag Type menu between Transaction Types and Balancing Entry Types.
- User Maintenance User Role: Access to User screen.
- Static Data Maintenance User Role: Access to following Screens;
Tag Types
Balancing Entry Types
Product Companies
Products
Management Companies
Funds
Accounts
- Filters: make filters movable.
- Bug: Balancing entries not deleted when unreconclied.
- Reports: Included these Reports as Standard Reports:
Unresolved Transaction Report
Last Closing Balance Report
Current Reconciliation Status Report
Current Reconciliation Status Report Per Fund
- Remove Reconciliation: Don't show the Confirm removal with reason pop-up if Reconciliation can't be removed
- Manual Recon Screen Filter: Remove the Market Action ID column and add a Market Action Status column.
Revision: 1.4.851.945 (12 Oct 2012)
----------------------------------
- Installer: Add the test Database connection string functionality.
- Filter: dd/MM/yyyy format issue fix.
- Manual Recon screen: Error while adding Last Tag or Last Tag Type columns to the selected Internal Transaction grid.
- Error screen: Show error information.
- Bug: FS Confirmation Imports creating Opening and Closing Balance records in External Transaction
Revision: 1.4.842.927 (04 Oct 2012)
----------------------------------
- Improved the performance of Imports from definitions for large volumes of data.
- Account Selector:
- Display the External Fund Code in Fund Dropdown.
- Move the popup if long list of Fund Managers is not visible.
- Display the External Fund Code in the Account Selector ribbon.
- Captured Confirmations Report: Formatting and functional changes.
- Installer: Allow User to choose between Forms and Windows authentication.
- Upgrade Moorgate to .net Framework 4.
- Application upgraded to .net 4.0 framework. Please make following changes to configuration files.
- 1) Open the properties window of virtual directory and change the ASP.NET Version to 4.0 in ASP.NET tab.
- 2) Change the Web.config file as mentioned below:
- Delete configSections tag
- Add following attribute in the compilation tag: targetFramework="4.0"
- Delete assemblies tag
- Add following attributes in pages tag: controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID"
- Delete below section from controls tag
<add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
- Delete below section from httpHandlers tag
<remove verb="*" path="*.asmx" />
<add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false" />
- Delete httpModules section
<httpModules>
<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
</httpModules>
- Delete system.codedom section
<system.codedom>
<compilers>
<compiler language="c#;cs;csharp" extension=".cs" warningLevel="4" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
<providerOption name="CompilerVersion" value="v3.5" />
<providerOption name="WarnAsError" value="false" />
</compiler>
</compilers>
</system.codedom>
- Delete below tags from system.webServer section
<modules>
<remove name="ScriptModule" />
<add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
</modules>
<handlers>
<remove name="WebServiceHandlerFactory-Integrated" />
<remove name="ScriptHandlerFactory" />
<remove name="ScriptHandlerFactoryAppServices" />
<remove name="ScriptResource" />
<add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
</handlers>
- Delete runtime section
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0" />
</dependentAssembly>
</assemblyBinding>
</runtime>
- 3) In the Twenty57.BankRecon.ProcessService.exe.config file change Version to 4.0.0.0 in add attributes of <system.web> tag.
- Add below startup tag in the Twenty57.BankRecon.ProcessService.exe.config file after </system.web> tag.
<startup><supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/></startup>
- 4) Restart the process service.
Revision: 1.4.831.904 (18 Sep 2012)
----------------------------------
- Reprocess Failed Confirmations: Use CycleDate instead of ValueDate.
- Account Selector: Allow second account number selection.
- Allow Import Balance only batches on the FS file.
- Failed confirmations screen: Allow manual capture of Opening Balance and Valuedate if its the first batch.
- Failed confirmations screen: The batches which cannot be imported as they are not in a valid format and fail correctly with the correct reasons are displayed in the Process Details Message.
- Include the ReconId column in the Default filters.
- Failed Confirmations: Allow fixing of the error Combination of codes cannot be mapped uniquely.
- Process Log Details:
- Show failed/rejected batches and transaction before the list of successful imports and order the list by Account Code.
- Keep the popup open and allow the user to work with Moorgate and other open tabs.
- Account screen filter: Include the Active Flag, Product and Fund External and Internal Codes in the filter and grid.
- Capture and Edit of confirmations: Auto Calculate the units if an amount and price are given.
- Setup guidelines on Import Definition screens: make the into boxes/pop-ups which allow the user to continue working and to reference them at the same time.
- Bug: Confirmations Import error Value was either too large or too small for an Int32.
- Import Transactions should also work with only mandatory columns.
Revision: 1.4.799.846 (23 Aug 2012)
----------------------------------
- Bug: Error in account selector when new Fund Company Added.
- Market Action Screen: Paging applied.
- Market Action screen: If Fund has 2 different Internal Codes then duplicate record is displayed on screen.
- Default rule "Group Internal and External by Account, TransactionType and ValueDate" changed.
- Balancing Entry process: when deleting the Recon having balancing entries If the other side of the BE is reconciled. Do not delete it.
- Filter: Use of the quotation symbol (") in the names.
- Filter: Show distinct values in the account filter dropdowns.
- Filter: Show distinct values in the product filter dropdowns.
- Confirmation import : Change the ordering logic for FS files to use Cycle Date instead of Value Date to determine the batches.
- Failed confirmation screen: Error when saving either the first or second batch from the failed confirmation screen.
- Fund Company screen: When a new Fund Company is added, automatically assign users who are assigned to the Product Company to which the Fund Company is linked access to the Fund.
- Edit Failed Confirmations Screen: Add Cancel Button.
- Failed Confirmations Screen: FS transaction with the Account, Product and Fund Codes without balances into Moorgate
The transaction is imported
Please check for accounts first and if it passes then check for balances.
- FS Import Balance Tolerance:
Apply the tolerance to check if the previous closing balance in Moorgate falls in the tolerance limit with the FS opening balance.
- Failed Confirmation: If it is the first import into Moorgate for the account use the FS balances as the Moorgate balances
- Failed Confirmations screen: displayed single entry when duplicate external codes but unique account mapping.
- Save Failed Confirmations: displayed confirmation message on the Failed Confirmations screen.
- Import definitions screens: Add Test button to test the import query.
Revision: 1.4.753.748 (14 Jun 2012)
----------------------------------
- View Transactions/View Transactions Across Accounts: Include details link.
- Bug: Negative transactions captured through Capture a Confirmation screen shown as positive on the Manual Recon screen.
Revision: 1.4.750.743 (25 May 2012)
----------------------------------
- Market Action Screen: Include Internal Fund Code in the grid and filters.
- View Transactions/Confirmations across account screen: Allow saving User Filter Profiles.
- Auto Recon Rules screen: Use default connection string provided in config file.
- Reconciled Transactions screen: Log the unreconciled entries as cancelled with timestamp, user detail and reason.
- User screen: Assign Users to Mancos.
- Bug: Apply a format mask for ValueDate in Confirmation Capture screen.
- Bug: Apostrophe in a filter value causes error.
Revision: 1.4.715.689 (09 Apr 2012)
----------------------------------
- FS File Import changes: An interface is provided to edit the balance and static data errors for the failed confirmations.
- A new screen 'Failed Confirmations' provides the view of all the failed batches.
- A new manual capture screen to edit the failed balance errors is provided which can be navigated to from 'Failed Confirmations' screen.
- Product Company: If there are no balance records in FS file and the ‘Confirmation File Missing Balances Action’ is set to Fail then the error is shown in Failed Confirmations summary screen otherwise balances will be created automatically and message will be shown in Dashboard screen as batches did not had balances.
- Bug: Auto match rules was creating recons with multiple transaction types.
- Bug: Match note was not populating auto match rule name.
- Bug: Balancing entry type ID was shown in Matched Section of the manual recon screen instead of Balancing entry type.
- Bug: Few funds were getting populated in account selector for which there were no accounts.
- Bug: When trying to capture the first transaction for an account an error is returned.
Revision: 1.4.691.637 (15 Mar 2012)
----------------------------------
- Landing page: Balancing entries exlcuded from unresolved transaction count.
- View Trasactions Across Accounts: Static codes for product company, product, fund company and fund added in grid and filters.
- View Confirmations Across Accounts: Static codes for product company, product, fund company and fund added in grid and filters.
- Confirmation file import: Files without balance records will be process and Moorgate will create balance records.
- COnfirmation file import: Files with incorrect ordering of transactions will be ordered to ensure the accounts and transactions are grouped together correctly and then process the file.
Revision: 1.4.681.616 (16 Feb 2012)
----------------------------------
- Recon Details: Balancing entry type is shown on Transactions grid in recon details screen.
- Imports: Transactions, transaction details and confirmations can be imported from oracle database.
- Market Action: Users with Manager role can reject the initiated market actions.
- Account filter: Associated product, fund company and fund will be populated when product company is selected in the account filter pop up.
- Tags: Users can delete the tags created by other users.
- Capture Confirmations: The review screen showing the balancing entries and confirmations has been removed. On click on Save the confirmations will be saved directly.
- View transactions: Market actionID is added to grid and filter in view transactions screen.
- Capture Confirmations: If two users capture the confirmations for an account at same time, while saving the batch a check is added to verify whether that the batch's opening balance is still the same as the previous batch closing balance and if not a message about the new opening balance is shown to user.
- Edit Confirmations: When the last confirmations is deleted then a message is shown to user as 'Batch removed successfully.' which is faded after 30 seconds.
Revision: 1.4.673.595 (19 Jan 2012)
----------------------------------
- Transaction Import: Balance check done on previous imported batch only if the latest batch is of reconciliation type.
- 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.
Revision: 1.4.668.583 (23 Dec 2011)
----------------------------------
- Manual Recon: Added provision to have same side confirmation matching when the unit difference is within the specified fund tolerance.
- Manual Recon: Added provision to allow single transactions on both the Confirmation and Transaction side to be reconciled with a balancing entry if the unit value is within the tolerance of the fund.
Revision: 1.4.666.579 (08 Dec 2011)
----------------------------------
- Manual capture: A new column added to capture management fee.
- Preferences: The URL for webhelp updated in 'WebHelp URL' field in Preferences screen.
- Landing page: User will be navigated to manual recon screen after they select any account in landing page.
- Calendar control: Today's date will be default highlighted.
- Profiles: Last used profile will be loaded by default.
- Bug: 'Clear All' button in manual recon gets disabled when any action is performed after transactions are moved to match area.
- Bug: If the database connection is down when the service is restarted, the process definitions are not loaded into the service and thus do not run. A force restart of the service is then required to get it working 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.
Revision: 1.4.650.543 (03 Nov 2011)
----------------------------------
- Landing page: Changes made to improve the performance of the landing page.
Revision: 1.4.649.541 (17 Oct 2011)
----------------------------------
- Tags: Bug - Delete Tag functionality not working.
- Tags: Create Date column added to Tag listing screen. This column is available in filters as well.
- Tags: Tags are listed by ID in descending order.
Revision: 1.4.643.529 (09 Sep 2011)
----------------------------------
- Filter: Criteria column for Balancing Entry Type changed from textbox to dropdown.
Revision: 1.4.633.507 (25 Aug 2011)
----------------------------------
- Market Action: Following changes are made to market actions:
- Added a new screen to setup Balancing Entry Types
- Added two new status as 'Completed' and 'Authorised'
- Added a new Manager role for authorising the Initiated market actions.
- Managers will get a checkbox next to Initiated market actions to authorise the market actions.
- Added a balancing entry type dropdown to manual recon screen. It is mandatory to select balancing entry type for recons creating balancing entries.
- Add ‘Balancing Entry Type for Differences:’ dropdown to the Auto Match Rule setup screen.
- Filter has been defaulted to <>'Completed' and profiles added.
- Manual Recon: Clicking on a tag link from the manual recon screen will navigate users to tag details screen directly, not the tag listing screen.
- Confirmation Import Rollback: Last batches (as per the last key date of the import definition) imported with a confirmation import definition will be roll backed.
- Bug: Export data from Transactions, Confirmations, View across Accounts screen has duplicate columns.
- Bug: When wide reports are viewed, the heading bar is stretched very far with the logo and user being off the screen and accessible by scrolling.
Revision: 1.4.616.462 (30 Jun 2011)
----------------------------------
- Bug: ReconId on the 'Initiate Market Action Screen' doesn't display link to allow the user to view the reconciliation.
Revision: 1.4.615.460 (28 Jun 2011)
----------------------------------
- Market action: Added filter to initiate market action screen.
Revision: 1.4.611.454 (20 Jun 2011)
----------------------------------
- Filter: The filters will be dependent on the items (Product company,product,fund company,fund & account) with Product company least dependent and Account most dependent.
- Bug: When the Preferences is set to "dd/MM/yyyy", the Asset Allocation screen gives error while trying to view the allocation for captured date having date greater than 12.
- Bug: Report data source screen gives error when trying to add new data source.
Revision: 1.4.604.441 (06 Jun 2011)
----------------------------------
- Profiles: Users can save their filters as profiles. There is a provision to save multiple filters for a grid and edit/delete these profiles.
Revision: 1.4.601.435 (19 May 2011)
----------------------------------
- Filter: Records can be filtered on two different Tag Types/ Tags at the same time. The 'OR' condition on the Last Tag Type and Last Tag filter fields will be by default enabled.
- Added a new screen 'View Transactions Across Accounts' to view transactions across accounts associated with product companies users are assigned to.
- Added a new screen 'View Confirmations Across Accounts' to view confirmations across accounts associated with product companies users are assigned to.
- Manual Recon : Added 'Auto-Reconcile' checkbox next to the match button which when clicked will automatically reconcile the records when Match button is clicked in case of exact match. If there is a difference, the transactions will be handled as normal.
Revision: 1.4.588.408 (26 Apr 2011)
----------------------------------
- Manual capture: A new column added to show running total.
- Manual capture: Negative sign will be shown in front of the unit text box when any negative transaction type is selected.
- Manual capture: Balancing entries formatted to make them consistent with the rest of the app.
- Filter on View transaction, confirmation and manual recon changed to accept BETWEEN criteria for dates. Please enter the dates separated by comma for the BETWEEN condition.
- Tag Screen Enhancements: Filter added to Tag screen. Included TagID column.
- Dashboard: Added the file name in Import Name column for price file imports. For multiple transaction rollback definitions, column name will show text as 'Multiple Definitions'
- All references to Fund Manager changed to Management Company.
- Report name will be displayed when reports are executed.
- Filter: Fund names ordered alphabetically.
Revision: 1.4.578.380 (01 Apr 2011)
----------------------------------
- Manual capture: Instruction date will be saved as valuedate and holding source as 'Unit Register'.
- Manual capture: Opening balance value date will not be changed if the confirmation is backdated. If the latest confirmation is before the opening balance then the closing balance value date will be the same as the opening balance.
- Filters: Only Transaction Type will always be mandatory.
If fund type of selected account is 'Units' then Units will be mandatory but Amount will be optional.
If fund type of selected account is 'Amount' then Amount will be mandatory but Units will be optional.
Revision: 1.4.575.373 (25 Mar 2011)
----------------------------------
- Added date format DD/MM/YYYY in Preferences screen.
- Account filter: Associated Fund company and Fund will be populated when product company is selected in the account filter pop up.
- Price Import: The status in dashboard screen will be shown as 'Warning' if a line cannot be imported but other lines are imported without error.
- Transaction Import Rollback: The details pop up on dashboard screen will show more details like no of transactions, initiated market actions and recons removed for a given valudate.
- Bug: The confirmations on the manual recon screen reflect as positive for all transaction types.
Revision: 1.4.569.359 (14 Mar 2011)
----------------------------------
- Multiple internal codes for fund company and fund.
- Manual capture: Unit and price restricted to 6 decimals and amount to 2 decimals.
- Bug: All values in manual capture should be displayed as absolute values irrespective of the sign in the database.
- Rollback Transactions: Older imports should be allowed to be rollbacked if newer imports do not have data for accounts imported in older imports.
- User: Filter added on user screen. Default columns will be LoginName, Name and Surname.
- Bug: In manual capture screen, Price is displayed in cents but treated as Rands when calculating the amount
- Bug: The '>' and '>=' and the '<' and '<=' operators are swapped around for all date filters on the Manual Match Screen.
Revision: 1.4.561.343 (02 Mar 2011)
----------------------------------
- Manual Capture: Units and price allowed upto 6 decimals and amount upto 2 decimals only.
- Edit Manual Confirmation: All values will be displayed as absolute values irrespective of the transaction type.
- Fund Manager maintenance: Multiple internal codes are allowed.
Revision: 1.4.558.334 (24 Dec 2010)
----------------------------------
- Manual Recon: Tagged filter column renamed to Tags and added provision to filter on transactions and confirmations which are having 0, 1 or more than 1 tags.
- Manual Recon: Filter link removed from the matched section grids.Filter in top grids will be applied to grids in matched section as well.
- Numeric Value Display Format : All numeric values will be shown with a single space as the thousands separator.
- Fund maintenance: Following fields are added : Max Foreign Percentage, Max Local Equity Percentage, Max Foreign Equity Percentage
- Manual Capture: Added provision to capture backdated confirmations. It will be driven by preference setting called "Validate Value Date in Manual Confirmation Capture".
Revision: 1.4.548.313 (17 Dec 2010)
----------------------------------
- Manual Capture: Manual Capture will use the Transaction Type to determine and store the Transaction values with correct sign.
- Bug : Active process schedule with disabled scheduling runs at scheduled time. The Process has to be made inactive to stop it running.
- Bug: Initiate market action throws error sometimes.
- The HoldingSource field for manually captured confirmations will be saved as empty.
- Manual Recon: Provision to filter transactions and confirmations for tagged or untagged items only.
- Manual Recon: Added a "Show tags for all users" check box, on the right hand side of the "Load Existing Tags" drop down list, to load tags created by other users.
- Filter: Column 'Transaction Name' renamed to 'Transaction Type' for consistency.
- Increased the loading performance of RollBack Transaction screen.
- Asset Allocation: Added dropdowns for 'Management Company' and 'Fund'.
- Fund maintenance: Following fields are removed : Max Foreign Percentage, Max Local Equity Percentage, Max Foreign Equity Percentage
- Manual Recon: Provision for selection and ordering of the columns in the Matched Section for selected transactions and confirmations.
- Manual Recon: Provision for de-selecting all the checked transactions or confirmations by clicking 'Clear All' button placed next to 'Match' button.
Revision: 1.4.534.282 (24 Nov 2010)
----------------------------------
- Bug: Manual Recon Filters were not displayed correctly.
Revision: 1.4.532.278 (15 Nov 2010)
----------------------------------
- Bug: Report fails if there are XML special characters in parameter values
- Asset allocation: Delete button added to delete existing asset allocations
Fund Manager and Fund dropdowns removed. The asset allocation will be shown for the selected account's fund.
Revision: 1.4.528.268 (08 Nov 2010)
----------------------------------
- Bug: Internal and external transactions that have grouping give error while executing.
- Asset Allocation : Provision added to enter asset allocation for any date. User can edit existing asset allocations for selected fund.
- Dashboard screen refresh will be paused when the account selector window is active.
- Unresolved Transactions : Numbers in Transactions, confirmations and total columns will be shown as integers.
: Default column order in the filter will be - Account Fund Product Transactions Confirmations Total
: Contents of Account column hyperlinked with tool tip "Select account."
Revision: 1.4.524.259 (22 Oct 2010)
----------------------------------
- Bug: Inactive auto recon rules should not be available for run.
- Bug: User should not be able to click on import button again once clicked on Import Transactions,Confirmations,Transaction Details and Auto recon screen.
- Select all functionality added in import confirmations screen.
- Dashboard: File name will be shown in 'Import Name' column for file import.
Revision: 1.4.522.254 (14 Oct 2010)
----------------------------------
- Nulls suported in Internal Transaction Details Mapping.
Revision: 1.4.520.250 (04 Oct 2010)
----------------------------------
- Filter: Performance improved for loading Account dropdown.
Revision: 1.4.518.246 (27 Sep 2010)
----------------------------------
- Logout and change password link will not be shown if windows authentication is on.
Revision: 1.4.516.241 (24 Sep 2010)
----------------------------------
- Bug: Javascript error on loading accounts in filter screen when no of accounts is large.
Please add following section to web.config
<system.web.extensions>
<scripting>
<webServices>
<jsonSerialization maxJsonLength="2147483647"/>
</webServices>
</scripting>
</system.web.extensions>
- Bug: Product company, product and fund dropdowns are empty sometimes in filter screen.
Revision: 1.4.515.237 (15 Sep 2010)
----------------------------------
- Bug: Cancel button on manual recon does not stop the reconciliaton process and reconciliation is done.
- Bug: If the matched difference in manual recon screen is shown as zero after applying the rounding then no balacing entries will be created.
- Market Action: If the proposed amount/unit is less than 0.005 then market action can not be initiated.
- Exception logging: A preference setting 'Log StackTrace To EventLog' if set to true will log all the inner exceptions in event log of the installed machine.
- Asset Allocation: Three new columns added to show the calculated percentages.
- Dashboard: A new intermediate state 'Aborting' will be shown when user clicks on Kill Process link for Busy process.
- Dashboard: Kill Process link is shown next to pending processes so that they can be aborted.
- Menu: Setup Transaction Details menu items moved up level.
Revision: 1.4.507.216 (02 Sep 2010)
----------------------------------
- Bug: Filter fails or duplicates funds and accounts
- Asset Allocation: Screen accepts input as values instead of percentage. All values rounded to 2 decimals.
- Bug: User is not navigated to dashboard screen immediately after Rollback button is clicked in Rollback transactions screen.
- Account Breadcrumb: Internal codes are shown next to product and fund. Product company and fund manager removed from account breadcrumb.
- Authentication: "Access is Denied" message will be shown if windows authentication is on and user is not found in database.
- Bug: Grid scrollbar visible when no scrolling is required.
Revision: 1.4.503.202 (18 Aug 2010)
----------------------------------
- Asset allocation: Addded a new label to show users, the total of all entered Asset Allocations.
Revision: 1.4.500.196 (12 Aug 2010)
----------------------------------
- Auto scheduling: A new setting "Process Schedule User" added in Preferences screen to set the name under which the auto schedule shoud run.
Auto scheduling can be set only for those who have either admin or daily process rights.
- Manual Recon: Label renamed from "Matched Balance" to "Matched Amount".
Revision: 1.4.495.184 (06 Aug 2010)
----------------------------------
- Recon by amount : Fund having reconciliation type set to amount can be reconciled using amounts.
- A new screen added in Dashboard menu to manually run the schedules made for auto run.
Revision: 1.4.487.169 (28 July 2010)
----------------------------------
- ReconID filter column added in fund listing screen.
- Auto scheduling import process:
- The AppSetting ProcessServiceURL is deprecated from the config, and is replaced by the preference setting Moorgate Service URL
- Add following element to the ProcessService Config file under the <Service> section
<wellknown type="Twenty57.Moorgate.API.SchedulerProxy, Twenty57.Moorgate.API" mode="SingleCall" objectUri="Scheduler" />"
Revision: 1.4.487.160 (22 July 2010)
----------------------------------
- Auto scheduling import process:
Preferences screen: Added a new field "MoorgateServiceRoot URL" for configuring the service url
- Manual Recon: Clear All button added to clear all the transactions and confirmations from the match area
- Manual Recon: Tags hyperlinked in all four grids for navigating user to tag listing screen.
- Tags column added in view transactions and confirmations screen.
- Bug: Report extensions in exported reports solved.
- ReconID filter column added in view transactions and confirmations screen.
Revision: 1.4.475.128 (05 July 2010)
----------------------------------
- Manual Recon: Round Price and Amount Columns to 2 Decimal Places
- Import: Confirmation Import Truncates Balances to 4 decimals
- Import: Allow Transaction and Confirmation Imports to have empty batches with no transactions
- Bug: Transaction detail import losses transactions.
- Link for source data rules in transaction, confirmation and transaction details edit screen.
Revision: 1.4.470.116 (25 June 2010)
----------------------------------
- A new textfield called "WebHelp URL" added in Setup/Preferences to link the Moorgate WebHelp.
Revision: 1.4.466.105 (22 June 2010)
----------------------------------
- Manual Recon: Details column made removable in Transactions grid
- Grid Filter: Unselected Columns in sorted in alphabetical Order
Revision: 1.4.463.98 (18 June 2010)
----------------------------------
- Sequence functionality added in Setup/Auto Match Rules list screen. Rules will be executed in the order of sequence.
- Description column removed from the Setup/Auto Match Rules list.
- Manual Recon: Selection info from the status bar moved to label below the transaction and confirmation grids,
"Add Selected to Matched Transactions" button renamed to "Match",
"Remove" button in Matched Transactions renamed to "Clear".
- Bug#14458: Filter for the date Column where time is non-zero not fetching records.
- Manual Recon: For all decimal columns, the criteria should be compared only down to the specified number of decimal places specified in the criteria.
- Bug#14477 : Manual Recon: Change Transaction Name Column to Transaction Type
- Preference and Import: Added a new setting on the Setup/Preferences screen, called "SQL Import Timeout (seconds)" having default value of 60.
- Auto match rule editor: Description field made optional.
- New links labelled "Columns" and "Source Key Value Parameter" added in definition editor of transaction, confirmation and transaction details.
- Bug#13400: Reset Product and Account dropdowns in filter if the product company is removed from the logged in user.
- Bug#13950: Display import name and keyfield value When importing transactions, confirmations and transaction details.
- Menus: "Daily Process" renamed to "Process". Dashboard screen's title changed from "Daily Process Dashboard" to "Process Dashboard".
- Dashboard: All process items up to a maximum of the last 20, regardless of the day on which it occurred will be shown.
- Bug# 14014: The FinSwitch date format can only be dd/MM/yyyy.Only this one format from confirmation file imports will be allowed.
- Include all funds, products and accounts in filter dropdowns to which the logged in user has access. Earlier the only criteria in the dropdowns was "All".
Revision: 1.4.412.22 (24 Feb 2010)
----------------------------------
- Report Logging: ReportID, DateTime (when executed) and userID will belogged in database when report is executed.
Revision: 1.4.409.16
----------------------------------
- Filter: Added a "restore default settings" button to the grid filter, which resets it to the install defaults for the respective grid.
- Import: When override balance check is enabled, the import should ignore any balancing entries that come in import and continue creating balancing entries as it did earlier.
- Menu : About dialog added to the menu Help to show the version of the app.
Revision: 736 (22 Dec 2009)
----------------------------------
- Bug: Collapse button effect vanishes after postback
- Market action: Transactions and Account made mandatory field for filter.
- Bug#9966: Configure Date format
Revision: 723 (9 Dec 2009)
----------------------------------
- Do not show filter link if there are no records in database.
- Delete all rollback import definitions if source key field type is changed in transaction definitions.
- All the mandatory columns in filter will be moved to RHS listbox by install.
- Bug: Landing page shows error as "ExternalUnresolved column not found" if filter is already applied.
- Filter: Clear button added on filter control.
- Bug #11369: Import price process does not do anything if the file size is too big.
- Bug #10684: Error on Fund and Account maintenance listing screen before applying the filter.
- File import : Message altered to show how mmany records ignored if MissingAccountActionType is set to ignore.
Revision: 701 (1 Dec 2009)
----------------------------------
- Setting added for confirmation file import to whether fail the import or ignore the row and continue if there is an account in the file which is not found in Moorgate
- Landing page: No of columns reduced to have account heirarchy and transactions older than 2 days only.
- Session timeout: Navigate user to landing page if logged in adfter session is expired.
- Bug: Account selector inv code dropdown loses selection
- Units made mandatory in filter for view transactions and view confirmations.
Revision: 679 (18 Nov 2009)
----------------------------------
- Date format added to Prefernces screen. All date controls will populate date considering these settings.
- Performance improvement in filter control.
Revision: 762 (03 Nov 2009)
----------------------------------
- The uniqueness constraint for tag name changed as follows: the combination of Name, AccountID, TagTypeID and CreateDate must be unique.
Revision: 760 (30 Oct 2009)
----------------------------------
- New column "Details" with hyperlink in manual recon unreconciled transaction grid for loading transaction details.
Revision: 752 (28 Oct 2009)
----------------------------------
- Landing page: Click on any row to select the account in breadcrum.
Revision: 750 (27 Oct 2009)
----------------------------------
- Landing page: Only top 20 records are shown.Unresolved Total column sorted descending by default.
Revision: 741 (22 Oct 2009)
----------------------------------
- Bug: Tags should be refreshed after account change in manual recon
- Bug: Market action grid resizes on menu hover.
Revision: 737 (21 Oct 2009)
----------------------------------
- Added Asset Allocation report to reports folder in Twenty57 installation directory
- Added line number in import price file error
- Bug: Save AS New Tag deletes the original tag in manual recon
- Transaction details: Set up screen for transaction details import definition
Revision: 719 (14 Oct 2009)
----------------------------------
- Transaction details: Mapping screen for mapping fields between internaltransaction and InternalTransactionDetails.
- Preference page as admin functionality to configure following settings in web.config which can be removed from web.config.
<add key="Twenty57URL" value="http://www.twenty57.com"/>
<add key="DashboardRefreshTime" value="10"/>
<add key="AllowEditingOfProposedUnits" value="true"/>
<add key="PriceIncreasePercentage" value="100"/>
<add key="AllowEditingOfProposedPrice" value="true"/>
- Bug: Screens having filter shows EnableEventValidation error. Add attribute enableEventValidation="false" to pages element in web.config
Revision: 713 (12 Oct 2009)
----------------------------------
- Added Tag type and Tag name columns in manual recon screen.
Revision: 711 (09 Oct 2009)
----------------------------------
- Following new fields added in Fund maintenance screen
MaxForeignPercentage
MaxLocalEquityPercentage
MaxForeignEquityPercentage
Revision: 704 (07 Oct 2009)
----------------------------------
- Bug: Can not execute the stored procedure in Transaction import definitions.
- Message to be shown while removing transactions/confirmations if any RBE types associated with market actions are removed.
- Setup screen for adding transaction details import definitions.
- Connection string if not specified in auto recon rule, app connection string will be used.
Revision: 674 (30 Sep 2009)
----------------------------------
- Bug: Tag uniqueness message should be shown on the Tag pop up itself in manual recon.
- Detailed messages shown in dashboard screen for transaction import, auto recon, file imports.
Revision: 670 (25 Sep 2009)
----------------------------------
- Export to excel for transactions and confirmations
- Message shown on manual recon screen if the reconciliation creates a balancing entry.
- Two new columns ReconID and Tags added on the details tab of remove confirmations screen.
- New tab labelled Market Action added in remove confirmations screen.
- Tags count against transactions and confirmations in manual recon screen.
- Proposed price and amount added in market action
- Add following entries appsetting section in web.config file
<add key="AllowEditingOfProposedUnits" value="true"/>
<add key="PriceIncreasePercentage" value="100"/>
<add key="AllowEditingOfProposedPrice" value="true"/>
Revision: 638 (18 Sep 2009)
----------------------------------
- Landing Page showing account status of unresolved transactions
- Grid filters for fund.
- Bug: Few issues related to filter fixed.
- Bug: Can not execute stored procedure in import definitions.
Revision: 620 (11 Sep 2009)
----------------------------------
- Market actions : Add a new column ReconID in initiate market action screen.
- Add many to many standard auto recon rule as part of installation
- Same side matching in Manual recon
- Net allocation amount and mode code fields added in filter for transactions and confirmations.
- Logging the import history while importing transactions.
- Audit Unrecon functionality
- Filter on market action grid. Removed the dropdowns on the screen and moved it to filter.
- Audit Remove confirmations.
- Bug: Account selector loses dependencies.
- Bug: Error not correctly logged for incorrect auto recon XML.
- Bug: Account selector loses dependencies
- Bug: Datetime conversion error in manual recon
- Bug: Performance improvement in manual recon screen.
Revision: 531 (19 Aug 2009)
----------------------------------
- Audit marketaction
- Bug: Change MoorGate to Moorgate
- Asset Allocation
- Bug: Arrange elements alphbetically in List control
- Bug: Image on the Login Screen Not Resizing
Revision: 518 (5 Aug 2009)
----------------------------------
- RBE records to have valuedate = max(valuedate) of transaction/confirmation
Revision: 508 (3 Aug 2009)
----------------------------------
- Market Actions
- Added details link in Dashboard screen
- Made import messages more generic.
- Transactions and confirmations view screen sorted desc by id.
Revision: 462 (17 July 2009)
----------------------------------
- Net allocation amount and mode code in confirmation import
- Renamed table InternalImportBatch to InternalBatch.
- Renamed table ExternalImportBatch to ExternalBatch.
- Few columns realigned in manual recon, auto match, tag details and recon details screen.
Revision: 448 (10 July 2009)
----------------------------------
- Net Allocation amount in transaction import
- View transactions/confirmations screen shows records in descending order by id.
- Tag dropdown in manual recon.
- View Tags including the load tag and view tag.
- Bug: Uninstall does not remove the process service.
- Bug: Account selector does not work properly on manual recon.
- Bug 7417: Manual match multiple record selection
Revision: 419 (26 June 2009)
----------------------------------
- Adding RBE types in batches during reconciliation process.
Revision: 408 (22 June 2009)
----------------------------------
- Reports
- Add following in Web.config under <httpHandlers> to run the reports if installation is in upgrade mode.
<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
- Install "Microsoft Report Viewer" Redistributable on the web server to view the reports.
- Add the standard reports in SetUp|Reports by browsing the RDL files at location "C:\Program Files\Twenty57 Moorgate\Reports"
- Remove Confirmations for the selected account from specified date.
- Only active import definitions will be shown in Import Transactions/Confirmations screen.
Revision: 361 - 395 (16 June 2009)
----------------------------------
- Changes made in transaction and confirmation import to save the balancing entries in batches.
- Capture Confirmations : Balancing entries shown above the grid. Type dropdown loads extended types. Closing balance valuedate = latest valuedate of all the confirmations.
- Price = zero not allowed for Purchase transactions and confirmations import.
- Role based access
- Extending transaction types: Changes made in imports to consume the extended transaction types.
- Fixed filter issue.
- Dashboard: Add following key in Web.config setting under <appSettings> to configure the auto refresh time.
<add key="DashboardRefreshTime" value="20"/>
- Dashboard: Paging applied.
- Capture Confirmations : Save the balancing entries in batch table.
- Run following query if “Update 2009-05-25 16h12 VS - Add New Columns To Hold Balance Values And Create Relationship In ExternalImportBatchTable Table.sql” script file fails
DELETE FROM ExternalBatch
WHERE ID NOT IN
(SELECT ExternalBatchID FROM ExternalTransaction WHERE ExternalBatchID IS NOT NULL)
- Run following query of still build fails
UPDATE ExternalTransaction
SET ExternalTransaction.ValueDate = CurrentTransactionWithPrevValueDate.valueDate FROM
(SELECT ExternalTransaction.ValueDate,CurrentID
FROM ExternalTransaction INNER JOIN
(SELECT ID AS CurrentID,
(SELECT MAX(ID)
FROM ExternalTransaction AS a
WHERE (ID < tra.ID)) AS prevID
FROM ExternalTransaction AS tra
WHERE (TransactionCaptureTypeID = 2) AND (TransactionTypeID = 2) AND (ValueDate IS NULL)) AS PrevTransaction ON
ExternalTransaction.ID = PrevTransaction.prevID) AS CurrentTransactionWithPrevValueDate
where ExternalTransaction.ID = CurrentTransactionWithPrevValueDate.currentID
Revision: 343 - 361 (21 May 2009)
----------------------------------
- Extend transaction types. Types used by application (i.e RBEP, RBEN etc) not editable. (Standing data)
- Release note creation and inclusion.
- Capture/Edit confirmations : Warning message if amount is not exact multiple of units and product.
- Bugs:
- Confirmation Capture: Cancel Button.
- Ability to remove standard columns in filter.
- Account selector to show only those product companies to which logged in user is associated with.
- Account filter should reset if the user is de-associated with the product company belonging to the selected account.
Revision: 270 - 336 (13 May 2009)
----------------------------------
- Edit last manually captured confirmation batch.
- Reconid in view transactions and confirmation screen.
- Remove reconcilication. Removes all the RBE types before removing the reconciliation.
- Change password in user maintenance screen. (Admin functionality)
- Tags
- Add tag in manual recon screen.
- View tags (basic view).
- Tag Types maintenance screen. (Standing data)
- Import definitions: Override balance check if balancing entries not present in source data.
- Capture Confirmations: Warning message if amount is not exact multiple of units and price.
- Bugs:
- Web.config setting under <appSettings> to configure the url for text "Powered by twenty57".
<add key="Twenty57URL" value="http://www.Twenty57.com" />
- Clear selected transactions and confirmations when account is changed.
- When all the confirmations are deleted in edit confirmations, whole batch should be removed.
- Move columns not working on transaction view screen.
- Edit User: Product Company assigned to the user should not appear in the Available product company box.
- Confirmation Capture: Price and Amount should be blank for balances
- Connection String TextBox limit extended to 200 characters
- File Import
- File should have balancing entries.
- Opening balance for account should be equal to previous closing balance.
- Opening balance + transactions = Closing balance.
- Opening balance record should be immediate next to closing balance record of the account.
Revision: 270 (20 March 2009)
-----------------------------
Functionality included in release 1:
- Transaction SQL import
- View Transactions with filter.
- Confirmation SQL import
- View Confirmations with filter.
- Confirmation file import
- The file layout is as follows (tab delimited)
Message Type Code
Message Type Name
Type Code
Type Name
ManCo Code
ManCo Name
Fund Code
Fund Name
Bulked Investor Code
Bulked Investor Name
Product Code
Product Name
Account No
Reference No
Value Date
Price
Units
Currency
Amount
Cycle Date
FinSwitch Reference No
Status
Validation Status
Agents Commission
Management Fee
VAT
Net Allocation Amount
- Confirmation manual capture
- Manual recon, with balancing entries
- Run auto recon
- Daily Process Dashboard: Status of all the imports run today by the logged in user.
- Static data inclusion : Standard transaction types.
- Standing Data Maintenance
- User Profiles. User product company mapping.
- Product Companies
- Products
- Management companies
- Funds
- Accounts
- Transactions import definitions
- Confirmations import definitions
- Auto match rules. Test the rules and display the records to be reconciled.
-Default rule by the name "Match by Account,TransactionType, Units, ValueDate and a 10 day date range" already added during installation.
- Format of auto match rule as below
<ReconDefinition xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" Name="Match by Account,TransactionType, Units, ValueDate and a 10 day date range">
<LeftDataset Name="leftDataset">
<Command OrderFields="1,4" UniqueFields="0" Name="leftDataset" CommandType="Text">
<Fields>
<FieldDefinition Ordinal="0" Name="ID" Key="true" DataType="Int32" />
<FieldDefinition Ordinal="1" Name="AccountID" Key="false" DataType="Int32" />
<FieldDefinition Ordinal="2" Name="HoldingSource" Key="false" DataType="String" />
<FieldDefinition Ordinal="3" Name="ConfirmationDate" Key="false" DataType="DateTime" />
<FieldDefinition Ordinal="4" Name="TransactionTypeID" Key="false" DataType="Int32" />
<FieldDefinition Ordinal="5" Name="ValueDate" Key="false" DataType="DateTime" />
<FieldDefinition Ordinal="6" Name="Units" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="7" Name="Price" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="8" Name="Amount" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="9" Name="ReferenceNumber" Key="false" DataType="String" />
<FieldDefinition Ordinal="10" Name="Reference1" Key="false" DataType="String" />
<FieldDefinition Ordinal="11" Name="Reference2" Key="false" DataType="String" />
<FieldDefinition Ordinal="12" Name="Reference3" Key="false" DataType="String" />
<FieldDefinition Ordinal="13" Name="Reference4" Key="false" DataType="String" />
<FieldDefinition Ordinal="14" Name="Reference5" Key="false" DataType="String" />
<FieldDefinition Ordinal="15" Name="DateReference1" Key="false" DataType="DateTime" />
<FieldDefinition Ordinal="16" Name="DateReference2" Key="false" DataType="DateTime" />
<FieldDefinition Ordinal="17" Name="AgentCommission" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="18" Name="ManagementFee" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="19" Name="VAT" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="20" Name="ReconciliationID" Key="false" DataType="Int32" />
<FieldDefinition Ordinal="21" Name="InternalCode" Key="false" DataType="String" />
<FieldDefinition Ordinal="22" Name="ExternalCode" Key="false" DataType="String" />
<FieldDefinition Ordinal="22" Name="ExternalCode" Key="false" DataType="String" />
<FieldDefinition Ordinal="23" Name="InstructionDate" Key="false" DataType="DateTime" />
</Fields>
<Database DbType="Sql">
<ConnectionString Name="">Data Source=server;User ID=user;Password=password;Initial Catalog=database;</ConnectionString>
</Database>
<CommandText>SELECT InternalTransaction.ID, AccountID, HoldingSource, ConfirmationDate, TransactionTypeID, ValueDate,
Units, Price, Amount, ReferenceNumber, Reference1, Reference2, Reference3, Reference4, Reference5, DateReference1,
DateReference2, AgentCommission, ManagementFee, VAT, ReconciliationID, InternalCode, ExternalCode, ValueDate AS
InstructionDate FROM dbo.InternalTransaction INNER JOIN dbo.Account ON InternalTransaction.AccountID = Account.ID
WHERE (TransactionTypeID NOT IN (1, 2)) AND (ReconciliationID IS NULL) AND (Account.ProductID &lt;&gt; 1) ORDER BY
InternalTransaction.AccountID, TransactionTypeID</CommandText>
</Command>
</LeftDataset>
<RightDataset Name="rightDataset">
<Command OrderFields="1, 4" UniqueFields="0" Name="rightDataset" CommandType="Text">
<Fields>
<FieldDefinition Ordinal="0" Name="ID" Key="true" DataType="Int32" />
<FieldDefinition Ordinal="1" Name="AccountID" Key="false" DataType="Int32" />
<FieldDefinition Ordinal="2" Name="HoldingSource" Key="false" DataType="String" />
<FieldDefinition Ordinal="3" Name="ConfirmationDate" Key="false" DataType="DateTime" />
<FieldDefinition Ordinal="4" Name="TransactionTypeID" Key="false" DataType="Int32" />
<FieldDefinition Ordinal="5" Name="ValueDate" Key="false" DataType="DateTime" />
<FieldDefinition Ordinal="6" Name="Units" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="7" Name="Price" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="8" Name="Amount" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="9" Name="ReferenceNumber" Key="false" DataType="String" />
<FieldDefinition Ordinal="10" Name="Reference1" Key="false" DataType="String" />
<FieldDefinition Ordinal="11" Name="Reference2" Key="false" DataType="String" />
<FieldDefinition Ordinal="12" Name="Reference3" Key="false" DataType="String" />
<FieldDefinition Ordinal="13" Name="Reference4" Key="false" DataType="String" />
<FieldDefinition Ordinal="14" Name="Reference5" Key="false" DataType="String" />
<FieldDefinition Ordinal="15" Name="DateReference1" Key="false" DataType="DateTime" />
<FieldDefinition Ordinal="16" Name="DateReference2" Key="false" DataType="DateTime" />
<FieldDefinition Ordinal="17" Name="AgentCommission" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="18" Name="ManagementFee" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="19" Name="VAT" Key="false" DataType="Decimal" />
<FieldDefinition Ordinal="20" Name="ReconciliationID" Key="false" DataType="Int32" />
<FieldDefinition Ordinal="21" Name="InternalCode" Key="false" DataType="String" />
<FieldDefinition Ordinal="22" Name="ExternalCode" Key="false" DataType="String" />
<FieldDefinition Ordinal="23" Name="InstructionDate" Key="false" DataType="DateTime" />
<FieldDefinition Ordinal="24" Name="TransactionCaptureTypeID" Key="false" DataType="Int32" />
</Fields>
<Database DbType="Sql">
<ConnectionString Name="">Data Source=server;User ID=user;Password=password;Initial Catalog=database;</ConnectionString>
</Database>
<CommandText>SELECT ExternalTransaction.ID, AccountID, HoldingSource, ConfirmationDate, TransactionTypeID,
ValueDate, Units, Price, Amount, ReferenceNumber, Reference1, Reference2, Reference3, Reference4, Reference5, DateReference1,
DateReference2, AgentCommission, ManagementFee, VAT, ReconciliationID, InternalCode, ExternalCode, ValueDate AS InstructionDate,
TransactionCaptureTypeID FROM dbo.ExternalTransaction INNER JOIN dbo.Account ON ExternalTransaction.AccountID = Account.ID
WHERE (TransactionTypeID NOT IN (1, 2)) AND (ReconciliationID IS NULL) AND (Account.ProductID &lt;&gt; 1)
ORDER BY ExternalTransaction.AccountID, TransactionTypeID</CommandText>
</Command>
</RightDataset>
<Matches>
<MatchDefinition Name="" Expression="(LHS.GetInt32(1)==RHS.GetInt32(1))" />
<MatchDefinition Name="" Expression="(LHS.GetInt32(4)==RHS.GetInt32(4))" />
<MatchDefinition Name="" Expression="(LHS.GetDecimal(6)==RHS.GetDecimal(6))" />
<MatchDefinition Name="" Expression="Math.Abs(LHS.GetDateTime(5).Subtract(RHS.GetDateTime(5)).Days)&lt;=10" />
</Matches>
</ReconDefinition>
- Logout
Release 1 extras:
- UnitRecon data migration script (import definitions copied, but update will be manual)
- Sample database migrated from UnitRecon obfuscated data (login is admin/password)
