BankRecon: Release Notes

Bank Reconciliation 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.
Only revisions that impact on the application are listed in the release notes. Revisions that relate to builds, etc. are not included in the release notes.
Additional details can be found in the relevant blog post for the release

Version 4.28.1276.3929 (30 Nov 2023)

-------------------------------------

ZEN14417 - Feature - New bank statement: Ecobank CSV.

ZEN14619 - Feature - New bank statement: GTB Bank XLS. The parser supports Microsoft Excel file versions 2.0-2007.

ZEN14501 - Support - Fixed an issue where clicking the KeyCount link when testing a recon rule threw an error.

ZEN11699 - Support - The report "Current Reconciliation Report Historical Data (Standard)" was broken. It has been removed after confirming that no clients were using it.

ZEN14700 - Support - There was an edge case where it was possible for the the Citi Bank statement import to hang when an incomplete file was received. It now fails the import in this scenario.

ZEN13956 - Support - Added better error logging for developers to use to diagnose similar problems in the future.

BR-655 - Maintenance - 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.

</dependentAssembly>

</dependentAssembly>

</assemblyBinding>

</runtime>

- In the <httpHandlers> element, change this line:

to this line:

i.e. change the Version from 11 to 15

- In the <handlers> element, change this line:

to this line:

i.e. change the Version from 11 to 15.

Version 4.27.1264.3894 (14 March 2023)

-------------------------------------

Support

- ZEN12733 - Fixed issue with Auto Close Accounting Periods from a process - Accounts list will correctly filter based on Domain and Domain Group process types. Corrected process log details.

Version 4.27.1259.3883 (13 February 2023)

-------------------------------------

Support

- ZEN11293 - Updated DB Indexes

Version 4.27.1258.3881 (26 October 2022)

-------------------------------------

Features

- ZEN11695 - Added option on Accounts to "Show warning when bank statement contains transactions older than [x] days.

Version 4.25.1255.3873 (05 October 2022)

-------------------------------------

Features

- ZEN10470 - Updated Daily Process with option to Close Accounting Periods.

- ZEN10674 - Added Domain setting to allow a user to capture a GL Account on Journal Creation, and option to Validate GL Accounts with a Web Service.

- ZEN10672 - Added Domain setting to Restrict User Access to Accounts. When enabled, every non admin user must have explicit access granted to an Account in the User config.

Version 4.24.1248.3857 (12 May 2022)

-------------------------------------

Features

- BR631 - Created new web services for user management - GetUserList, GetUserGroupsAndDomains, AddUser, UpdateUser, AddUserToUserGroup, RemoveUserFromUserGroup

Maintenance

- BR631 - Fixed issue with User Edit when saving data for First Name, Surname and Email on Admin users.

Version 4.23.1245.3850 (11 April 2022)

-------------------------------------

Support

- ZEN10247 - Updated Export on pages to exclude data from Inactive Bank Account when searching across accounts (View Cashbook Transactions, View Bank Transactions)

- ZEN10274 - Fixed issue with Cashbook Import Definition Editor Change Password flag not allowing updates in some cases.

Maintenance

- Upgraded application to .Net 4.8

Version 4.23.1243.3844 (01 March 2022)

-------------------------------------

Support

- ZEN9844 - Added an index to GeneralLedgerExport to improve performance of GL Export process - IX_GeneralLedgerExport_GeneralLedgerExportBatchID

ZEN9354 - Removed index -IX_CashbookTransaction_ID_CashbookBatchID_Amount

Version 4.22.1242.3840 (23 July 2021)

-------------------------------------

Improvements

- Official support added for Chrome and Edge (Chromium) browsers.

Maintenance

- ZEN6841 - Removed known MSDTC dependencies. Impact:

Creating balancing entries

Manual and Auto Recons

Reconciliation across Accounts

Cashbook Transfers

Cashbook Allocations

Notes

Due to the nature of the changes in this version, we strongly advise a comprehensive test plan before a Production release, with coverage for all business cases on site and volumes testing.

Version 4.22.1240.3816 (06 May 2021)

-------------------------------------

Improvements

ZEN8246 - Cashbook Reference 11 to 20 are now displayed on the UI

Version 4.22.1238.3810 (23 April 2021)
-------------------------------------

Support

- ZEN8126 - Fixed error message on report - Current Reconciliation Report (Standard)

- ZEN8303 - Fixed Test button on Easy Recon Rule when filtering on CashbookTransactionType

Version 4.22.1237.3793 (19 February 2021)
-------------------------------------

Improvements

- ZEN7667 - Added Date Picker for all date fields on filters

Support

- ZEN7774 - Fixed issue with GL Account names longer than 50 characters.

Version 4.22.1234.3781 (17 December 2020)
-------------------------------------

Improvements

- ZEN7417 - Updated MT940 to use a generic sequence rollover to reset sequence to 1 when the bank statement reflects 1 and the opening balance matches the last closing balance.

Support

- ZEN7464 - Fixed issue posting balancing entries with XML characters

Version 4.21.1230.3772 (22 October 2020)
-------------------------------------

New Features

- ZEN7252 - New plugin - FNBPACSStmnt3

Version 4.21.1227.3767 (12 October 2020)
-------------------------------------

Improvements

- ZEN7350 - Optimizations

Updated ExceptionCountView used on Dashboard page

Manual Recon screen - Removed Tag Name Cashbook and Bank queries (removed Tag Name tooltip on Tag Count column)

Version 4.20.1226.3764 (31 August 2020)
-------------------------------------

Improvements

- ZEN7219 - Cashbook Import Config - Ordered configurations alphabetically

Fixes

- ZEN7030 - Fixed issue with Recon Rule using Group By or Having, without a Where condition

- BR608 - Fixed issue with Exports on Manual Capture when using Group By with Tags column selected.

Version 4.19.1224.3757 (28 June 2020)
-------------------------------------
Support
- ZEN6909 - Encrypt passwords on rest for Cashbook and Bank Detail Import Definition connection strings.

Note: Upon upgrade all Cashbook and Bank Detail import definitions must have the username and password captured in the respective fields and removed from the connection string.

Version 4.19.1221.3748 (26 June 2020)
-------------------------------------
Features
- ZEN6436 - Added WebService - IsServiceRunning?

Support
- BR565/BR566 - Optimization of SQL queries
Cashbook Transaction List - Loading data and paging
Bank Transaction List - Loading data and paging
Tag Comment editor - Save, Save and Send Mail, Send Old Mail
Manual Recon - Search for Transactions - load of Bank and Transaction list
- BR578 - jQuery upgrade
- ZEN6597 - Fixed Current Reconciliation with Tag Type Summary Report when viewing all accounts
- ZEN6607 - Fixed datagrids not displaying multiple spaces in succession
Transactions - BankBatches - AllBankBatches - ‘Entries’ Link in Grid
Transactions - CashbookBatches - AllCashbookBatches - ‘Entries’ Link in Grid
Transactions - BankBatches - OpenBankBatches - ‘Entries’ Link in Grid
Transactions - CashbookBatches - OpenCashbookBatches - ‘Entries’ Link in Grid
Transactions - BankTransactions
Transactions - CashbookTransactions
Reconciliation - ManualReconciliation
Reconciliation - ManualReconciliation - 'Save Tag' button
Reconciliation - ManualReconciliation - 'TagCount' link in Grids
Reconciliation - Tags - Click '<Tag Name>'

Version 4.17.1200.3714 (26 March 2020)
-------------------------------------
Support
- ZEN6091 - Fixed issue with Dashboard reflecting End Time while process is still running

- BR590 - Optimization - CashbookTransactionUnreconciled Delete

- BR553 - Optimized recon sub query - Compare expected recon counts with actual recon counts within Reconcile process

- BR551 - Optimization of Unreconciled Queue Processor
a. Recon Rule (ReconRule.cs), both at the start of the Ruleset, and for each Rule that gets processed
b. Process Service Start (ProcessService.cs).
c. If the application starts up successfully, it will move the Unreconciled Transactions once.
d. Queue Process Run (QueueProcessRunner.cs). Runs after any Process completes its work, but before the process is marked complete. This does mean that for a Daily Process, this step will run once for every child process it runs, plus the one after the Daily Process
e. BankBatch - after Import and Delete.
f. BankTransaction - on Add, Update and Delete
g. CashbookImporter - after transactions are committed
h. CashbookTransaction - after Add and Update
i. ReconCommands - after Cancelling Recons
j. JournalRuleExecutor - after executing and closing the transaction.
k. Recon - after the ManualRecon process.
l. RollbackBankStatement - after the Rollback process.
m. RollbackCashbookImport - after the Rollback process.
n. TransactionTransferer - after Transfer, TransferCashbookTransactions and TransferBankTransactions.

- BR550 - Performance Optimizations - Updated Site Configuration data to use a cached object on IIS instead to reduce DB queries
UI:
1. Accounting Period List [Load]
2. Accounting Periods Maintenance Editor [DateFormat from SiteConfig]
3. Adjust Opening Balance [Load]
4. All Bank Batch List [Grid Currency format]
5. All Bank Batch Transaction List.aspx [Grid Currency format]
6. All Cashbook Batch List [Grid Currency format]
7. All Cashbook Batch Transaction List [Grid Currency format]
8. Audit Log [Date format for Calendar extender]
9. Bank Batch Transaction List [Grid Currency format]
10. Bank Details Import Definition Editor [Grid DateTime Format]
11. Bank Group Detail (Group By logic) [Grid Currency format]
12. Bank Transaction Editor [Date format for Calender extender]
13. Bank Transaction List [Grid Currency format]
14. Cashbook Batch Transaction List [Grid Currency format]
15. Cashbook Group Detail (Group By logic) [Grid Currency format]
16. Cashbook Import Definition Editor [Grid DateTime Format]
17. Cashbook Transaction Allocation [Script Update | Grid Currency format]
18. Cashbook Transaction Editor [Date format for Calender extender]
19. Cashbook Transaction List [Grid Currency format]
20. Classic Recon Rule Editor [Grid DateTime Format]
21. Current Accounting Period List [Grid Currency format]
22. Daily Process Wizard [Date Format]
23. Default Master Page - Menu DB Calls reduced to one by loading all the menus which user had access and then filter as per the rendering. Site configuration static object used to get details.
24. Easy Recon Rule Data Selector Test Output Popup [DateFormat]
25. Easy Recon Rule Editor [DateFormat]
26. Manual Recon [Grid DateFormat & Currency format | EnableManualLogging]
27. Open Bank Batch List [Grid Currency format]
28. Open Cashbook Batch List [Grid Currency format]
29. Recon Viewer [Grid Currency format]
30. Site Configuration Editor [Load from static object| save Update static object at API]
31. Tag Comment Editor [SMTP settings | Currency | DateFormat]
32. Tag Editor [SMTP settings | Currency | DateFormat]
33. Transfer Cashbook Transactions [Grid Currency format]
34. Authenticating Page (generic class managing authorization to all pages) [DateTimeFormat]
35. Tag Helper (Used on TagEditor page to display Tagmails earlier sent) [DateFormat]
36. Allocation Display (User on All Cashbook Batch Transaction List and Cashbook Transaction List) [Grid Currency format]
37. Data Grid Filter (used in multiple pages such as Manual Recon) [DateFormat]

API:
1. Archive Recon
2. Audit Log Data Pager
3. Bank Transaction (Export to Excel DateFormat)
4. Batch Match Processor (Get Auto Recon Batch Size from Site Config)
5. Cashbook Importer [DateFormat]
6. Cashbook Transaction (Export to Excel DateFormat)
7. Cashbook Transaction Allocation (Export to Excel DateFormat)
8. Configuration
9. Easy Recon Rules [DateFormat]
10. Manual Recon Bank Selection (Export to Excel DateFormat)
11. Menu (Optimized user access rights lookup)
12. Recon Rule (settings lookup from cache instead of multiple DB queries)
13. Site Configuration (Update cache on Save)
14. Accounting Period Status [DateFormat]

Version 4.17.1193.3701 (17 February 2020)
-------------------------------------

Support

- ZEN6050 - Optimized performance of Recon to resolve issues with very large recons

Version 4.17.1192.3698 (14 February 2020)
-------------------------------------
Features
- ZEN5726 - Added an option to run a daily scheduler to automatically Clean Up Tags

Version 4.17.1189.3693 (20 December 2019)
-------------------------------------
Support
- ZEN5578 - Manual Reconciliation - fixed issue with loading reference field aliases after toggling a filter profile. Aliases are now loaded directly from the Account config, instead of the Filter Profile config.
- ZEN5579 - Updated Tag Editor page to concatenate error messages when multiple errors are thrown
- ZEN5552 - Fixed issue with missing General Ledger Export data when a batch is closed while the export process is running.
- ZEN5598 - Fixed 'Input string was not in a correct format.' issue on Journal Rule configuration when using 'bankrecon.glaccount.dropdownlimit' config

Version 4.17.1185.3675 (18 October 2019)
-------------------------------------
Support
- ZEN5471 - SQL Optimization and fix - ExceptionCountView
- ZEN5413 - Fixed domain/domain group process 'Warning' message when step not configured

Version 4.17.1181.3664 (17 September 2019)
-------------------------------------
Support
- ZEN5321 - Tag Editor screen - Ordered Tag Type alphabetically
- Tag Editor screen - Added logic to handle an existing Tag where the Type was changed to inactive

Version 4.16.1176.3655 (26 August 2019)
-------------------------------------
Features
- ZEN5029 - Dashboard - added additional information

Support
- Added option to enable performance logging on Manual Capture screen

Version 4.16.1166.3632 (24 June 2019)
-------------------------------------
Features
- ZEN4621 - Added user right and option to run recon rules after an import

Support
- ZEN4781 - Fixed Select All and Clear All buttons on Daily Process Configuration
- ZEN4886 - Fixed process log to reflect correct Domain when a rollback is applied to an import

Version 4.16.1157.3612 (22 May 2019)
-------------------------------------
Features
- Added DateTime data type for Cashbook and Bank Import key values

Support
- ZEN4738 - Corrected spelling of Cashbook in process log (Running process with no cashbook import)

Version 4.16.1155.3608 (29 April 2019)
-------------------------------------
Features
- GL Allocation splits - updated to apply Details field as per Journal Rule config
- Added a custom timeout configuration for Closing Cashbook Batch and Bank Batch ("Microsoft.ApplicationBlocks.Data.CommandTimeout")

Support
- Fixed issue where service users could not be saved due to blank password message when using windows authentication
- Fixed issue with administrator checkbox mapping to DB on Users page
- Fixed incorrect Manual Transactions count on User Reconciliation Activity Recon report
- Fixed Process Definition issue - Scheduling Intervals grayed out on page load for Interval configurations
- Added no lock conditions to some read queries
- Optimized query joins (Cashbook Load) - Manual Recon, Suggestions, Cashbook Batch, Cashbook Transaction Allocations
- Optimized query for DB locks (Cashbook Allocations) - Cashbook Import, Journal Rules Execution, Cashbook Transfers, Cashbook Batch Screen, Manual Recon Screen, Suggestion Screen, Cashbook Transaction Allocation Editor Screen

Notes
- This upgrade will require you to uninstall the previous version of Bank Recon and install this as a clean version. Config files in program files will need to be backed up and restored as a result. The new install should not impact the existing database, however a backup is recommended before the upgrade.

Version 4.16.1148.3592 (25 March 2019)
-------------------------------------
Features
- GL Allocation splits - updated to apply Details field as per Journal Rule config

Support
- Fixed issue where service users could not be saved due to blank password message when using windows authentication
- Fixed issue with administrator checkbox mapping to DB on Users page

Version 4.16.1144.3584 (7 March 2019)
-------------------------------------
Features
- GL Allocation splits - removed rule to enforce unique account numbers

Support
- GL Accounts - added message to prevent user from disabling GL account if linked to an active journal rule
- Journal rules - updated config to not show accounts marked as inactive

Version 4.16.1141.3578 (21 February 2019)
-------------------------------------

Support
- Added audit entry when cashbook transactions are deleted from the system
- Fixed bug on Current Reconciliation with Tag Type Summary Report and updated percentage fields to 2 decimal places

Version 4.16.1137.3570 (8 February 2019)
-------------------------------------
Features
- Added Bank Statement upload setting per Domain

Support
- Fixed issue with Easy Rules where the Edit button would not work on the Other Match section
- Updated Process Definitions to show warning instead of error if there is an inactive Journal Rule assigned to the process definition
- Daily Process messages have been updated to provide more info

Version 4.16.1129.3553 (9 January 2019)
-------------------------------------
- Manual Recon screen - fixed filter when using Group By option where Tag Name was added to the grouping

Version 4.16.1128.3551 (4 January 2019)
-------------------------------------
- Query optimization to address timeouts on: Load Tag button, Tag Editor screen, Added paging on TagDetails screen to address large data sets

Version 4.16.1125.3545 (12 November 2018)
-------------------------------------

- Improvements: Tags Screen
o Error messages improved to be more meaningful and user friendly. and
- Fixed: Tag Screen
o 'Save and Send Later' bug resolved.

Version 4.16.1123.3540 (6 November 2018)
-------------------------------------

- Improvements: Tags Screen
o Emails contents have been made consistent, and now include a link to navigate the user directly to the tag screen.
o Additional validations have been included for the email address field.

Version 4.16.1120.3533 (17 September 2018)
-------------------------------------

- Improvement: General Ledger Accounts search functionality and usability improved.
- Improvement: Installer now capable of putting windows authentication into config files if so selected on installation.
o This requires the underlying user and rights to be provisioned on the OS to work properly.

- Fixed: Standard Reports displayed incorrect % values when exported to Excel.
- Fixed: AD Authentication using users without email addresses specified no longer cause an error on the New Tag Screen.

Version 4.16.1117.3525 (28 June 2018)
-------------------------------------

Improvements
- Changed deprecated database column types (Text, NText, Image) to appropriate supported types (varchar, nvarchar, varbinary)
- Added 'Page Timeout' to 'Site Configuration' page (default value: 90 sec). This allows pages that take long to load, like when doing large volumes of group by queries on the manual recon screen to complete in the time set, before giving a timeout.
- Long running open cashbook batches query tied to 'Command Timeout' value on 'Site Configuration' page to allow large volumes to load in the time set, before giving a timeout.

Version 4.16.1115.3520 (9 November 2017)
-------------------------------------

Feature
- Bank Statement import validations can now be done across bank statement types by enabling the setting on the specific account. You can for example import a SBSA file, followed by a CATS file, and the bank statement validations will be triggered. If the setting is not enabled, the current logic which prevents bank statement validation across types remains in place.

Version 4.16.1113.3515 (19 July 2017)
-------------------------------------

- Fixed: Fixed bug on starting the service - The following functionality was failing on some service starts
o process items that have been killed (in the busy state) will be updated to Error, and
o items in the Pending State will be re-initiated.

Version 4.16.1111.3511 (21 June 2017)
-------------------------------------

- Performance: Journal Rule Speed Improvement (Underlying query simplification and performance improvement)

- Fixed: Service Recovery Improvements. Upon starting the service,
o process items that have been killed (in the busy state) will be updated to Error, and
o items in the Pending State will be re-initiated.
Previously these status updates would not occur automatically and pending processes would not automatically be re-initiated.

Version 4.16.1110.3508 (7 June 2017)
------------------------------------

- Feature: Suggest Functionality now includes a configuration option to disable the MOD (10) rounding exclusion for exact matches.

Version 4.16.1109.3506 (9 April 2017)
-------------------------------------
- Fixed: Last Key Value can now be larger than 2^32 - 1

- Fixed: Using OR conditions in journal rules no longer allows selecting transactions from accounts other than the currently selected account

Version 4.15.1108.3502 (24 February 2017)
-----------------------------------------
- Feature: When manually creating a bank batch, there is an option to use the last statement type of the account
o When selected, the specific statement validations for the statement number will be enforced
o When unselected, the standard validations will apply (Opening/Closing balance)

- Feature: Tag transaction removal
o Cashbook/Bank transactions can be removed from Tags by any user with the "Save/Edit" tags right for the related domain

- SWIFT MT940: The SWIFT MT940 parser has been extended to parse the new 2016 Account identification tag (:25P:)
o Existing documents are parsed as per usual

- Fixed: Object reference error on the Recon Viewer screen has been resolved
o The error would occur when a user without the ReconciliationDelete right navigated to the ReconViewer screen by selecting
a ReconID link from a cashbook / bank transaction

- Fixed: Object reference error occurring when deleting a bank batch no longer occurs and the audit process log is created successfully

Version 4.14.1101.3480 (19 January 2017)
----------------------------------------
- Feature: A new process type has been added, 'Bank Batch Delete'
o Manually deleting a bank batch creates a process log with a message showing the original batch details
o This allows the event to be audited
o Even though this event is audited, it should only be used for deleting manually created bank batches
o Bank batches created by way of bank statement import should be rolled back, since multiple batches can be created for a single bank statement

- Fixed: Manual Recon totals bar displays correctly when using comma as decimal separator
- Fixed: Configurable columns on the Domain Group/Domain/Account selection screen are now correctly aligned and consistent with the standard columns

Version 4.13.1098.3469 (15 December 2016)
-----------------------------------------
- Feature: Bank enrichment amount condition
o When applying Bank enrichments, an optional condition can be specified for the amount which will determine whether to apply the enrichment
o Supported conditions include None, Amount zero, Amount negative and Amount positive

- Feature: Process Log
o The Process Log can now be filtered by Process Type, StartTime, EndTime and/or Process Status

- Improvement: Import definition test function
o When executing import definitions, numeric parameters used with a greater than condition are not incremented before applying the query
o Date parameters used with the equals condition or the greater than or equal to condition are incremented before applying the query
o The "Test" function on the import definition page was not applying the logic above leading to a difference in the data displayed by the test function
and the data which would be returned on the next run of the import definition
o The actual value of the @keyValue parameter is now displayed when using the "Test" function
o The results returned by the "Test" function will match the results returned by the import definition on the next run

- Improvement: Bank batches
o Statement Date has been added to the Bank batches grid

Version 4.12.1093.3456 (05 December 2016)
-----------------------------------------
- Fixed: Cashbook Import error: "invalid column length from the bcp client for colid..."
o Truncating the Cashbook transactions details (300 -> 100) for insertion in the Allocation table has been fixed
o When a cashbook import returns data larger than the cashbook table can accommodate, the value is truncated to the maximum length
prior to inserting (200 characters for reference fields and 300 characters for the description)

- Fixed: Cashbook imports ending in a warning now appear on the Rollback cashbook screen
o The process cannot end in a warning unless transactions were committed

- Improvement: MSDTC is no longer required on the TagEditor screen

- Feature: Bank Statements list
o There is a new menu item available to Site Administrators
o Setup > Site Configuration > Bank Statements
o Individual Bank statements can be selected/deselected for use by the application
o The goal for the future is to allow installation of plugins without requiring a new version of the application

- Feature: Swift Parser
o There is a new plugin 'Swift'
o This plugin will parse MT940 and MT950 files and ignore other swift messages (900,910,...) without failing
o The main benefit is that the plugin will parse a file containing a mixture of message types
o It is off by default
o To activate, navigate to the Bank Statements list, deactivate both of 'Twenty57.BankRecon.BankStatements.SWIFTMT940.dll' and
'Twenty57.BankRecon.BankStatements.SWIFTMT950.dll'. Then activate 'Twenty57.BankRecon.BankStatements.SWIFT.dll'
o Without deactivating the SWIFTMT940 and SWIFTMT950 plugins, they will always detect and attempt to parse the Swift file first

- Feature: AutoRecon transfer consolidation
o There are 2 new configuration options on the ReconRule editor:
o 'Consolidate Transfers':
- When selected and the rule is run across accounts, transactions will be consolidated and reconciled per account prior to transfer
- This may avoid the creation of many transactions, since only 2 transactions will be created for the transfer
per account instead of 2 transactions created for each transferred transaction
- The default setting is off
o 'Transfer Account' = [Use first Bank Account] or [Use Account with most transactions]
- When reconciling across accounts, Bank Recon must choose an account to transfer transactions to
- A new option is available to limit the number of transferred transactions by selecting the transfer account as the account
with most transactions meaning that fewer transactions need to be transferred
- The default is [User first Bank Account]
o The major gain in reducing the number of transactions created when transferring across accounts is by selecting the 'Consolidate' option

- Improvement: Unreconciled table maintenance
o The maintenance of the unreconciled tables (CashbookTransactionUnreconciled and BankTransactionUnreconciled) can now be switched off
o The process has been adjusted so as not to interfere with other processes and to ensure that only one update of the tables is running at any one time
- This will reduce load on the server as well as resolve some concurrency issues associated with updating the tables
o The unreconciled tables are used by the Suggest process and may be used by the Recon rules themselves
o To turn off the unreconciled table maintenance, you must have the Suggest process switched off and ensure that none of your Recon rules
reference the unreconciled tables directly (since they will then not match anything)
- Any recon rules using the unreconciled tables directly can be changed as follows:
1. Any reference to CashbookTransactionUnreconciled should be changed to CashbookTransactionUnreconciledView
2. Any reference to BankTransactionUnreconciled should be changed to BankTransactionUnreconciledView
- Then add the following application setting to the process service configuration file:
1. add key="bankrecon.unreconciledtables.active" value="false"

Version 4.11.1088.3433 (26 October 2016)
----------------------------------------
- Fixed: "Reconciliation done successfully" message displays immediately after reconciling directly without a balancing entry
o Previously, the message would only show on returning to the manual reconciliation screen
o This message still display when returning to the Manual Reconciliation screen after creating a balancing entry

- Fixed: Bank transaction - Bulk import bug for bankstatements with no statement number has been resolved
o When multiple statements are found in the import directory, Bank Recon needs to order the statements to import correctly.
It does this by using the associated Statement number / Statement date
o In the case that a bank format does not use a statement number and the statement dates are equal, Bank Recon will use the
ordering of the selected files as shown on the Bank Transaction import screen (top to bottom).

- Feature: Flexcube transaction reversals are now parsed and reflected on the BankTransaction as Reference3 = 'Reversal'

- Feature: MT940 / MT950 reversals are imported as BankTransaction.Reference9 = 'Reversal'

- Feature: Individual reconciliations created when reconciling across accounts can be individually unreconciled or the entire batch can be unreconciled
o These are created when transferring transactions from source accounts to the Recon account

- Fixed: When reconciling across accounts and using Helper data, the ReconID's attached to Helper data rows were incorrectly assigned to the transfer Recons
instead of the Recon in the working account
o This has been resolved and the ReconID assigned to matched helper data will match the BankTransaction account (Recon account)

- Improvement: GL Account names are displayed on the Journal rule list and editor screens in addition to the GL account number
o <Account Name> - <Account Number>

Version 4.10.1086.3422 (28 September 2016)
------------------------------------------
- Fixed: Manual Reconciliation balancing entry error (Cashbook Transaction ID 0 does not exist)
o Bank Recon can fail to create a balancing entry due a number of reasons including:
i. the user does not have create cashbook batch / auto journal permissions
ii. there are no open batches
o Previously, the actual error was being swallowed and "Cashbook Transaction ID 0 does not exist" was displayed

- Fixed: "One of the Recons does not balance.". A scenario was discovered when a rule returns matches using multiple ReconHelpers, BankRecon was
not mapping the correct ReconHelpers to the correct match. This meant that importing the missing Helpers from the data set
would retrieve helpers from the wrong data set and the result would not balance. This has been resolved

- Improvement: Oracle cashbook imports were failing on first connection and subsequently succeeding due to an as yet unknown cause
o To mitigate this, the Oracle cashbook import definition supports retrying the connection a configurable number of times
using a configurable interval between retries
o A cashbook import will show a warning on the process log when the connection needed to be retried and fail if the number
of retries exceeds the configured setting

- Feature: Auto journal entries can now be consolidated in the same way as with manual entries
o To use this feature, the Consolidate option should be selected on the Journal rule

- Feature: When testing a classic Recon rule with Helper data, the matched Helper data can be viewed along with the cashbook / bank data

Version 4.9.1082.3412 (26 August 2016)
--------------------------------------
- New Bank Statements:
- SAP
- FlexCube
- Montran

- Performance: Unreconcile performance improvements have been made to support unreconciling a larger number of transactions
o This will be most noticeable when unreconciling a recon involving many transferred transactions from different source accounts

- Performance: Account save performance has been improved and will be more noticeable in domains with a large number of GL accounts

- Performance: Manual Recon transaction selection performance has been improved
o This mainly affected IE 8 users

- Usability: GL accounts
o When an account has many linked GL accounts, asides from being difficult to locate GL accounts, the application may become slow or
even exceed the limitations of the web server as specified in the web.config file
o The GL Account list includes a search box with autocomplete
o The Account editor will show an inclusion/exclusion list of GL accounts with an autocomplete selector instead of the full list
in the case that the number of GL accounts for the domain is larger than the web.config setting "bankrecon.glaccount.dropdownlimit"

- Fixed: MT940 / MT950 parser now compares statement numbers correctly when importing a batch of statements
with alternate formats of <StatementNumber> and <StatementNumber>/<SequenceNumber>
o Statement number is the :28C: tag

- Fixed: The IE Status bar dependency has been removed
o The text previously shown on the status bar is now shown on a web control
o This avoids having to allow javascript to update the status bar in IE (as well as display it in the first place)
o The control totals are now available to Chrome users. (There is no status bar in Chrome)
o This affects the Manual Recon, Cashbook/Bank and Transfer Cashbook transactions screens

- Fixed: Manual Recon suggest undo command no longer times out

- Fixed: Export to excel bug with control characters
o Excel files underlying structure is xml and so invalid xml characters are converted to blanks prior to creating the export

- Fixed: The Cashbook transaction allocation editor "Save & Reconcile" double-click bug has been fixed.
o The button will no longer submit multiple requests when double-clicked (It will disable after the first click and enable after)

- Fixed: The Report viewer control Oracle parameter bug has been fixed

- Structure changes: ReconCancelBankDetailsTransaction table has been removed
o This table was previously used for unreconciling a recon linking Bank transactions directly to Helper Bank transactions
o Direct Bank transaction to Helper bank transaction recons were removed in 2014

Version 4.8.1068.3360 (1 July 2016)
-----------------------------------
- Easy Recon rule batch processing has been removed

Version 4.8.1067.3358 (30 June 2016)
------------------------------------
- Accounting Periods
- The Accounting Period list screen has been updated to allow multiple consecutive accounting periods to be closed.
- Each period up until the selected period will be closed consecutively.

- Compatibility Headers
- Compatibility headers have been added for users of Internet explorer who use a default document mode prior to IE9.
- The header will ensure that pages render using IE9 document mode.

- GenericCSV parser
- The Generic CSV parser now supports both of ‘dd/MM/yyyy’ and ‘dd-MM-yyyy’ as date formats.
- The GenericCSV statement number validation bug has been resolved. Statement number is no longer validated.

- Unreconciled table concurrency improvements
- Unreconciled table maintenance concurrency has been improved.
- AutoRecon and Cashbook import processes will no longer fail when the unreconciled table maintenance process fails, but the process will end in a warning.

- Helper Data (Bank <-> ReconHelperBankTransaction match)
- This fix affects Recon rules using Helper data with the the option to create journal entries for missing Cashbook transactions selected.
Previously, at least one Cashbook transaction would need to match to a ReconHelperCashbookTransaction for the match to succeed.
This is because the underlying ReconHelper set was determined by the Cashbook <-> ReconHelperCashbook match.
- Now, the ReconHelper set can be determined by the Bank <-> ReconHelperBankTransaction alone and no Cashbook transactions need to match
for journal entries to be created using the linked ReconHelperCashbook transactions.
See the http://bankrecon.blog.twenty57.com/ for more information

- Recon failure error messages
- After a reconciliation fails due to an imbalance between the cashbook and bank when using Helper Data, it has frequently been
due to one or more cashbook transactions matching to more than one ReconHelperCashbook transaction.
In this case, Bank Recon will show the first 10 duplicates, so that they can be excluded from the match or used to update the Recon rule appropriately.

- Easy Recon rule performance
- The Easy recon rule editor now generates rules using Batch processing by default.
This results in performance improvements in the case that grouping is used and the rule returns many groups.

- Recon viewer
- The Recon viewer screen has been updated to account for a large number of transferred transactions.
When Reconciliations are run across accounts and a large number of transactions are transferred, displaying them all on one screen may result in timeouts,
server errors (maxRequestLength exceeded) or generally poor performance.
- We have added paging on the ReconViewer to handle this case
- The page size is a web config application setting,
<configuration>
...
<appSettings>
...
<add key="bankrecon.reconviewer.pagesize" value="10"/>
...
</appSettings>
...
</configuration>

- Increasing the value will affect performance and may require the maximum request length to be increased when the value is large.
- The default value is 10 items.

- Services User
- A new user type has been added. Existing users who login to the front-end are known as end-users.
- The new user type is a service user.
- Service users cannot login to the front-end.
- Service users must have a password set, as they are used for the webservice integration.
- The Service user details are not updated by Active Directory

- Manual Recon balancing entries
- There is a new web configuration setting:
<configuration>
...
<appSettings>
...
<add key="bankrecon.glaccount.dropdownlimit" value="1000"/>
...
</appSettings>
...
</configuration>
- The setting affects the cashbook transaction allocation screen, when creating a balancing entry.
- When an account is linked to more GL accounts than specified by the value, the GLAccount dropdown becomes an autocompleting textbox.
- The default value is 1000
- Setting the value to 0 will always use the autocomplete textbox
- Setting the value to a very large number will always use the dropdown

Release 4.7.1059.3321 (20 May 2016)
-----------------------------------
Features
-Bank Recon now supports Chrome Browser
-MT940 parser now imports a statement date using the last intermediate (62M) or final (62F) closing balance of the SWIFT message
-SWIFTMT940/SWIFTMT950 parsers both populate Reference1 with the TransactionTypeIdentifier field and Reference2 with the AccountOwnerReference field

Fixes
-Recon rule preview now works correctly when using the Batch processing feature
-The Recon rule description length has been increased to 300
-The AutoRecon Batch processing mode now processes all matches of a batch instead of skipping the last one in the batch

Improvements
-Login page enhancements + autofocus on the username textbox
-Display issue affecting the Bank Keys view from the Recon rule test feature has been resolved
-The AutoRecon Batch processing mode no longer requires GetKeys commands for the left/right datasets

Performance
-The Batch size used for the AutoRecon batch processing mode is now configurable (default: 1000)

Release 4.6.1050.3285 (30 March 2016)
--------------------
-There is a new user right applicable to the creation of balancing entries for manual Recons. The right, "Split balancing entries into multiple allocations", governs a user's ability to create multiple allocations for a balancing entry. When the setting is off, then any balancing entry created will be associated to a single GL account.

-Fixed: The Manual Recon group detail view bug has been fixed. Selecting "Group By" and manually deselecting columns no longer shows an error when viewing the underlying transactions. Using the "Clear all" function to achieve the same result works as usual

-Fixed: The Manual Recon dynamic view can now be used with the @Date parameter

-Fixed: AutoRecons configured across accounts which also use Helper transactions now correctly reconcile transactions in the target account and create any missing cashbook entries
in the target account

-Fixed: On the Easy Recon rule screen, the "Other Match" editor can now correctly distinguish between the Reference1 field and any of the Reference10-Reference19 fields

-Fixed: The Manual Recon profile list now works correctly on IE9 with an updated ContentType

-Fixed: SWIFT MT950 bank statements with country codes matching Zimbabwe (ZW) / Malawi (MW) now import correctly

-Open Bank / Cashbook batches can be reordered using the DateCreated column to show earliest / latest entry first

-The export to Excel functionality has been added to the following screens:
-Cashbook allocations
-Grouped Cashbook transactions (Manual Recon)
-Grouped Bank transactions (Manual Recon)

-Auto Reconciliation performance improvements have been made for Reconciliations across accounts

Release 4.4.1019.3187 (6 November 2015)
--------------------
- Process Queuing has been implemented. This will ensure only one process log item runs at a time, minimising concurrent calls to the database
- Speed improvements to the Cashbook Import process
- Bank Statement support for a number of Zimbabwean banks
- Sorting of the transactions in the Matched section of the Manual Recon screen
- Install on Windows 10/IIS 11
- Better error messages and an easier to read error pop-up if something goes wrong during the install
- Logging of install errors to the install log
- View the install log from the msi failure screen
- Swift parser handles a file padded with spaces to make it fixed length
- Process Log message time stamp is saved in 24-hour format
- The release notes have been moved to the blog
- The Release notes link under the Help menu has been updated
- Fixed: Test Oracle Import definition with a Date KeyValue
- Fixed: Across account recons and table locking
- Fixed: SMTP password isn't overwritten with an empty value every time you Save the Site Configuration settings
- Fixed: SMTP password value is stored encrypted in the database

Release 4.2.983.3100 (27 August 2015)
--------------------
- Display Bank Account Currency and Account ID columns on the Account List screen
- SWIFT MT940 parser enhancements: Process Statement number Tag 28 as well as 28C
- BAI Parser enhancements: process Custom Codes correctly, better handling of Post dated transactions, handle a comma in the 16 tag Text field
- Across account recons must contain at least one transaction from the loaded account
- Allow editing of last accounting period name if added manually
- Allow delete of last accounting period if no data is linked to it
- Fixed: Multiple Import of Bank Statements shows Error Status if the import fails
- Fixed: Daily Process Schedule Log item shows Error if one of the processes inside of it failed
- Fixed: Correct Cashbook Transaction Type used when transferring transactions across accounts
- Fixed: Display correct Batch Create User when viewing cashbook transactions through the All Batches screen
- Fixed: GetKeysCommand in Easy Group By rules created correctly
- Fixed: Move same side cashbook transactions created by the Helper process to the Unreconciled tables
- Fixed: Correct columns shown in the Manual Recon Cashbook Filter View
- Fixed: Alignment of grids on the Daily Process Setup and Run Screens
- Fixed: Order by RowNumber clause applied to the query that generates the manual recon screen

Release 4.2.963.3056 (10 February 2015)
--------------------
- New Parser PNB Paribas csv formant
- Less strict MT940 statement check implemented. The import will work if the next statement is greater than the last one, not just sequential.
- MT940 import in a new year works when the statements are not generated daily and the numbering is reset to 1
- Remove a binary null character in a CATS Statement
- Automatically create the next accounting period if the expected accounting period for a bank statement is closed
- Account Table now includes Bank Account Currency column
- Email Tags can be used with Forms Authentication
- Site Config Settings explanations
- Fixed: General Ledger Export rights persist correctly when assigned to a User Group
- Fixed: Correct Accounting Period is used when a bank statement contains a backdated transaction and there are multiple open periods
- Fixed: Test Cashbook Import Definition when the query has an inner select statement

Release 4.2.949.3024 (6 November 2014)
--------------------
- MT940 parser enhancements: Statement Check ensures the next statement is sequential, Multiple Import supported, parser strips out a newline character in the details field, all characters in the 86 continuation field are imported split over Reference 3,4 and 5 if needed
- BAI Reports enhancements: Statement Date included in the statement correctness checl
- Allow Remove Setting on the Batch Type is honoured when deleting a cashbook batch
- Rollback of Bank Statement removes empty statements
- Rollback Cashbook Imports
- Prevent duplicate Cashbook Imports from running
- Manual Recon across accounts now creates one transfer transaction per account rather than transferring each transaction individually
- Additional information fields on the User table: First Name, Surname, Email, Last Logged in Time
- If using Windows Authentication this information will sync automatically from Active Directory
- Display First Name instead of User Name if available
- Suggest Configuration Settings moved out of Site Config and can be accessed by Admins, Site Admins and any other user with sufficient rights
- SMTP settings moved from the config file to the Site Config screen and saved to the Database
- CashbookBatchType and CashbookTransactionType included in CashbookTransactionUnreconciledView to help with writing Recon Rules
- Setup and Admin tables styling improved

Release 4.2.917.2930 (12 August 2014)
--------------------
- Create a Bank Statement in the next Open Period if the one matching its date is closed
- Imports, Recons, etc work with different Server number and date formats
- Install doesn't fail if the Reports cannot be inserted into the database

Release 4.2.910.2909 (21 July 2014)
--------------------
- Swift Parser accepts slightly different format
- Fixed: Correct GL Account is shown on the Cashbook Transaction Allocation screen
- Fixed: Search across Accounts and Group By on the Manual Recon Screen
- Fixed: Search across accounts on the Bank Transaction Screen
- Performance Improvement: Manual Reconciliation across Accounts

Release 4.2.902.2893 (27 June 2014)
--------------------
- Only the balances and statement date are checked when a new statement type is imported into an existing account that contains data. The Statement Number check is not executed
- BAI Parser update: support a different time format, additional fields in the Gropu Header row, commas in the tect field in an 88 continuation record, files which contain a closing balance but no opening balance

- Fixed: Bug preventing Suggest from running
- Fixed: Bank Details Import Definition Test works if the query contains a temp table
- Fixed: Easy Rule Group By working when there is a filter on a field not included in the Group By clause

Release 4.2.877.2832 (15 April 2014)
--------------------
- Reconciliations across accounts are linked
- FNB PACS Transaction Code mapped to Reference7
- Install or update the Standard Reports by selecting the Report feature in the msi
- Helper Linking and new Manual Recon screen has been removed

Revision 2617 (03 Oct 2013)
-------------
- Linked Parent Bank Details available on the Old style Manual Recon Screen if the underlying details are not reconciled.
- Fixes and Updates on the New Manual Recon Screen.
- Better handling of the linking between Parent Bank Transactions and Bank Details
- New Views for Reporting:
- Reporting_BankDetailsViewStandard
- Reporting_BankTransactionViewStandard
- Reporting_CashbookTransactionsViewStandard
- Reporting_BankAndBankDetailsTransactionViewStandard
- Reports upgraded to Report Viewer 2012: Please make following changes to web.config file
- Add below tag to system.webServer section
<trust legacyCasModel="true" level="Full"/>
- Update below section from httpHandlers tag
Update Version=9.0.0.0 to Version=11.0.0.0 and PublicKeyToken=b03f5f7f11d50a3a" to PublicKeyToken=89845dcd8080cc91" of Microsoft.Reporting.WebForms.HttpHandler
<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" validate="false"/>
- New Web Service Method to import a single Bank Details File: BankDetailsSingleFileImport
- Suggest Error Fix: Cannot access a closed stream
- Nedbank CSV parser included
- Better error message on Bank Statement import when the specified Network user is invalid

Revision 2499 (06 May 2013)
-------------
- New Manual Recon screen to cater BankDetails/helper reconciliations.
- Update the Site configuration screen's IndexPath field to a valid directory with write access.
- Run the Search index through Index Management screen.
- Added new view BankDetailsUnreconciledView to be used in Recon rules.
- Manual Recon Screen: Added default Easy rule to match Bank Details Transactions.
- Bug Fix: Bank Statements created in the incorrect accounting period.
- Cashbook Transaction Allocation Editor: GL account Number included in GL Dropdown.

Revision 2229 (22 Nov 2012)
-------------
- Fixed: Suggest Memory Usage
- Auto Recon across accounts:
- Create balancing entry transactions.
- Created Cashbook Batches display 'Auto Recon Transfer: [Rule Name]' for the balancing entries.
- Auto Recon rules: When Run Across accounts not ticked match transactions in same accounts.
- Manual Recon Screen: The Transactions Group Details link click fixed.

Revision 2206 (16 Oct 2012)
-------------
- Update the webhelp url to the valid path.
- Popups: Allow users to interact with the screen while they are open.
- Manual Recon screen:
- Show a tooltip with the associated tags names when user hovers Tag count.
- Fixed the Tag Count link error.
- Remove column 'Tag Name' in the Bank and Cashbook filters.
- Fixed the error displayed when we click Group By and click on "Don't show again".
- Dashboard screen: Auto refresh the screen and remove Refresh button.
- Reconciled Transactions screen: Remove vertical scroll bar in the grid.
- Left Side Data Selection and Criteria screen on easy recon rule: Added link, Using Group by.

Revision 2140 (30 Aug 2012)
-------------
- Search across Accounts: Matched Selected transaction on Search across Accounts.
- Easy Recon rules: Add Group By and Having columns.
- Transfer Cashbook Transactions Manually performance issue.
- Reconciliation Rule: Only show active accounts in the Recon Rule Map GL account per Account list.
- Accounting Period:
- Automatically create a new Accounting period id it does not exist.
- Allow editing of last manually added Accounting period.
- Remove the menu items Domain Group Wizard and Domain Wizard.

- Cashbook Batches screen: Show the actual batch create user in Created By.
- Daily Process Dashboard: Display user who initiated the daily process if the process is scheduled display 'ScheduleUser'.

Revision 2101 (18 Jul 2012)
-------------
- Bank Details Import Definition: Test SQL case in-sensitive.
- Manual Recon screen:
- Move transaction to matched section without refreshing the entire screen.
- Remove vertical scroll bar from transaction frames.
- Balancing Entry: Easier Allocation/s process.
- View Cashbook Transactions in Open Batch:
- Show allocated amount in Red if it does not match Transaction Amount.
- Delete icon appears next to ID column.
- Display Unreconciled items at top, followed by Incorrect allocations, then remaining by date.
- Open Cashbook batches screen:
- Show Allocated amount in red if it does not equals the Batch Amount.
- Show Approve tick if the Allocated amount equals the Batch Amount.
- Remove Reconciliation from Open Cashbook Batch screen: enable back button.
- Cashbook Transactions: Enable the checkboxes and 'Match Selected' functionality when Search across accounts is ticked.

Revision 2065 (03 Jul 2012)
-------------
- Tag Screen: Error when no email setup in Active directory.
- Fixed Bug: Balancing Entry created when back button clicked.
- Rollback Bank Statement: New screen to rollback imported Bank Statements.
- Fixed Auto Recon error "Recon contains items already reconciled" on same side auto recon rules.
- Fixed Bank and Cashbook Transaction Screen when Search across accounts.
- Bank Statement Import: Process a bank statement across a domain group.
- Bug: When Test button clicked on Bank Details Import Definition Screen error is displayed.

Revision 2017 (21 May 2012)
-------------
- Import Bank Transactions: Import button is disabled once clicked, to prevent duplicate imports.
- Bankstatement import: wording changed for error message related to out of sequence statement number.
- SWIFTMT940 & SWIFTMT950 Bank Statement import: If PRDT exists, use Use PRDT as Value Date, else use Transaction Date .
- Reconciliation Rule: Name field length changed to 100 characters.
- Save Tag: Tab heading renamed to 'New Tag'.
- Fixed the Dashboard Suggestion count.
- Suggest: Added a pop-up when the 'x' to ignore an option is clicked.
- General Ledger Detailed Report added From and To Date parameters.
- Following standard Reports are added :
- Current Reconciliation with Tag Type Summary Report.
- Historical Unmatched Transaction Details with Tag info Report.
- Historical Current Reconciliation Report.

Revision 2004 (24 April 2012)
-------------
- Import Bank Transactions: Import button is disabled once clicked, to prevent duplicate imports.
- Bankstatement import: wording changed for error message related to out of sequence statement number.
- Reconciliation Rule: Name field length changed to 100 characters.
- Save Tag: Tab heading renamed to 'New Tag'.
- Fixed the Dashboard Suggestion count.
- Suggest: Added a pop-up when the 'x' to ignore an option is clicked.
- Following standard Reports are added :
- Current Reconciliation with Tag Type Summary Report.
- Historical Unmatched Transaction Details with Tag info Report.

Revision 1978 (21 March 2012)
-------------
- Landing page: Tables added to show the number of pending unreconciled transactions, suggestions and tags.
- Bug: When we remove the already imported Batches, few references to Suggest are not removed. Thus when we reimport the batches, Suggestions gives error.
- Bug: When a recon rule creates a batch for the balancing entry it is defaulting the Create User for the Batch to UserID '1'.

Revision 1952 (20 February 2012)
-------------
- View Transactions: A message will be popped up when user ticks the checkbox to select the transactions. It can be hidden by clicking "Don't Show again" link on this pop up.
- View Transactions: A tooltip has been added on Matched Selected Button on the Cashbook and Bank Transaction Screens.
- View Transactions: Search criteria specified in manual recon screen will be shown on view transaction screens if user is navigated from manual recon screen. If user selects any other criteria then this search criteria will be vanished.
- Bug: users with administrator and site administrator privilege gets error on Process Log and Audit Log Screens.

Revision 1941 (07 February 2012)
-------------
- Reconciliation details: Back button on this screen will retain the search criteria set in view cashbook/bank transactions screen.
- Cashbook & bank transactions: Added ability to select transactions & load directly into matched section of manual recon screen.
If selected transactions are reconciled, provision to unreconcile them.
- Manual recon: Added ability to search both reconciled and unreconciled cashbook/bank transactions for the given match criteria
so that user can directly navigate to either view cashbook/bank transactions screen.

- Recon rules modified to improve the performance. Please make the changes to existing rules to take advantage of new approach.
- Tag screen:
- Tag type change will not be logged in Comments section.
- For each email created a record will be added to Comments section.
- Import definition: Following additional checks added on test button of Bank & Cashbbok import definition screens:
- Check whether all the mandatory columns are included in the query.
- Check whether the KeyFieldName matches with any field in the target table.
- Check whether the type of Data key type matches with the value in Last Key field.
- If user has selected date parameter then comparision operator next to KeyFieldName in query should be =.
- If user has selected number parameter then comparision operator next to KeyFieldName in query should be >.
- Landing page: Search box added to search the accounts through the list of accounts the user has access to, based on the phrase typed into the box.

Revision 1882 (14 December 2011)
-------------
- Spaces are allowed in columns alias in setup Accounts screen.

Revision 1857 (01 December 2011)
-------------
- Webservices: Following webservices have been removed - GetDetail, GetExceptions, GetHistory, UpdateException, DeleteDetail, AddDetail
- Reports: Totals dataset in Current Reconciliation Report updated to return correct percentages.
- Exception Management: Description and comments as well as the totals per side and the tag difference amount
included in email sent from edit tag screen.
- Tag details: ReconID link and totals of each side and difference added to Tag details screen.
- Recon details: The data on recon details screen is aligned in the same way as other screens.
- If user selects either of the multiple files in Import Bank Transactions screen, the 'Multiple Files' radio button will be auto selected.
- Bug: There is no option to update existing profile name as you can only save a new profile or update the profile that was previously loaded.

Revision 1840 (17 November 2011)
-------------
- Exception Management:
- Please add following SMTP settings in the web.config of the webserver and replace the content within <>.
<add key="Host" value="<SMTP Host settings>"/>
<add key="Port" value="<Port number>"/>
<add key="EnableSSL" value="false"/>
Add following settings only of the email sending does not work.
<add key="UserName" value=""/>
<add key="Password" value=""/>
- Added ability to send emails directly for Tags with tagged transactions included automatically in the mail body.
- Provision to see sent or drafted emails in edit tag screen with ability to resend the emails. - This works for windows authentication only.
- Tag listing screen has an additional column to show status whether email has been sent, not sent or blank(not composed)
- Bug: Cleanup Tags button gives timeout error sometimes.
- Bug: If the database connection is down when the service is restarted, the process definitions and suggest settings 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.BankRecon.ProcessService.exe
<add key="ServiceStartMaxAttempts" value="3"/>
<add key="DelaySecondsBetweenAttempts" value="60"/>

Revision 1803 (19 october 2011)
-------------
- Bug: Transaction error on suggest screen.
- Bug: Transactions are not showing properly when there is html character in the Suggest screen.

Revision 1785 (10 october 2011)
-------------
- Bug: Clear button in manual recon screen was not removing the last loaded tag's name.
- Tag: Description field is made optional on Add/Edit tag screen.
- Edit Tag: ReconID column will navigate users to view reconciliation screen.
- Bug: An error related to duplicate keys in Suggest process is shown in process log.

Revision 1775 (04 October 2011)
-------------
- Manual Recon: A message will be popped up when Group By checkbox is ticked to notify the changes. It can be hidden by clicking "Don't Show again" link on this pop up.
- Bug: Install fails if windows authentication is selected.

Revision 1740 (05 September 2011)
-------------
- Manual Recon: Export functionality will export the transactions in match section as well.
- Manual Recon: Values (like amount) can be directly copied and pasted into filters without formatting the data.
- Manual Recon: Clear button will remove all the selected ticks as well from both the grids.
- Manual Recon: Following columns removed from filter grid when 'Group By' is ticked:('Group by', 'Having' and 'Having Criteria').
- Suggest Process: Only suggest configuration and match criteria changes will be logged.
- Process Log: A new screen added to display the process log. It can be accessed using menu item 'Process Log' in Admin menu.

Revision 1706 (02 August 2011)
-------------
- Bug: Update Reconciliation Rule: Error when Keys Count link is clicked
- Bug: Auto Recon - Key not found in dictionary error
- Bug: Manual Recon: Group by and match fields error when data contains single quote
- Create User: Always Reload Last Used Profile check box is checked by default
- Tag: Tag Details and Edit Tag Screen Changes

Revision 1699 (21 July 2011)
-------------
- Auto Recon: Performance improved with in-memory processing of recon logic.
- 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 below tag from configSections
<sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
<sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
<section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
<sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
<section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere"/>
<section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
<section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
<section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
</sectionGroup>
</sectionGroup>
</sectionGroup>
- Add following attribute in the compilation tag: targetFramework="4.0"
- Update Version=2.0.0.0 to Version=4.0.0.0 in below assembly tags.
<add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
<add assembly="System.DirectoryServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
- 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>
- Add following tag after <globalization requestEncoding="utf-8" responseEncoding="utf-8"/> tag.
<httpRuntime requestValidationMode="2.0"/>
- 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>
- 3) Add below startup tag in the Twenty57.BankRecon.ProcessService.exe.config file after </system.runtime.remoting> tag.
<startup><supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/></startup>
- 4) Restart the process service.

Revision 1673 (04 July 2011)
-------------
- Reports: Update following reports - Age Analysis of Outstanding Deposits, Unreconciled Item Summary Report and Unreconciled Transaction Detail with Summary.
- Cashbook import definition: Test button added to execute the SQL used in definition and verify the results.
- Bank details import definition: Test button added to execute the SQL used in definition and verify the results.

Revision 1661 (21 June 2011)
-------------
- Manual Recon Suggestion: Reconcile button made more prominent.

Revision 1651 (06 June 2011)
-------------
- Manual Recon Suggestion: Suggestions not having common words will be excluded.

Revision 1624 (03 May 2011)
-------------
- Bug: Manual Recon: Only transactions from the current account where moved down when multiple account transactions were selected.
- Dashboard: Status of the process will be 'Warning' instead of 'Successful' when one or more bank statement imports have the Warning message in the details.

Revision 1588 (21 Apr 2011)
-------------
- Manual Recon Suggestion: Make words removable from suggest screen
- Manual Recon Suggestion: Re-create suggestions if the match criteria is added or modified

Revision 1540 (23 Mar 2011)
-------------
- Manual Recon Suggestion functionality.
- Add following key in appSettings section of web.config.
<add key="ConfigManagerURL" value="tcp://localhost:8087/ConfigManager"/>
- Add following wellknown tag in service secion of App.config of ProcessService
<wellknown type="Twenty57.BankRecon.API.ManualReconSuggestions.ConfigManagerProxy, Twenty57.BankRecon.API" mode="SingleCall"
objectUri="ConfigManager" />

Revision 1524 (31 Jan 2011)
-------------
- Bug: Auto Recon Rule in Process Definition still runs after rule deactivated

Revision 1504 (13 Jan 2011)
-------------
- Bug: Date bug in Manual Cashbook Transaction Capture

Revision 1478 (13 Oct 2010)
-------------
- Bug: Error page is displayed when breadcrumb is clicked while recon editor is open.
- Bug: Breadcrumb not visible in view bank transactions screen if there is horizontal scrollbar.
- Import: If the same file is imported by mistake then balancing entries not match message is shown. Now it will show message related to sequencing of statements.
- Import: When bank statement contains unknown account there will be warning message and file will be moved to processed folder rather than moving to failed folder.

Revision 1470 (28 Sep 2010)
-------------
- Data in Details field splitted accross Reference3 to Reference10 for SWIFT M940 and M950 format.

Revision 1467
-------------
- Label showing supported extensions for file import will be shown in following screens.
Setup daily process - Multiple File Upload
Import Bank Transactions - Multiple File Upload
This setting can be configured in Domain Groups screen. By default all extension files will be imported.
- All the standard reports will be added to Reports folder for fresh install.

Revision 1420
-------------
- Manual recon sorting: Clicking on any header columns will sort the grid by that column only.
- Whenever use comes to Manual recon screen either through menu or by loading tag, whatever profile was earlier selected will be shown instead of showing Last Used Profile
- Bug: If incorrect password is specified in site configuration, a proper error message is shown on the wizard screens.
- Bug: Opening and closing balance are not correctly imported for NedAcad.

Revision 1396
-------------
- Bank Import: Move failed files to a directory called: 'Failed<date>'
- Tagging: Tags can be created on grouped data in manual recon.
- Archive screen gets the date format from Setup | Site Configuration | General screen.
- Menu items under the menu aligned correctly in user group maintenance screen.

Revision 1365
-------------
- Reports: A new report 'Report Usage Report' provided to check the usage of report user wise and report wise.
- Bug: The Details column for the Bank Transactions are not aligned like the Format says is should be.
- Menu:Tools menu will not be shown if no 'external urls'
- Bug: Transaction with zero amount is imported in case of empty statement line.

Revision 1349
-------------
- Bug: Make the account/domain selector wider and expanded by default
- A new setting called "WebHelp URL" added in Setup/Site Configuration/General to link the BankRecon WebHelp into app.
- Report Logging: ReportID, DateTime (when executed) and userID will be logged in database when report is executed.
- Bug: On some admin and setup screens, the headings are not fixed, they move when screen is scrolled down.

Revision 1325
-------------
- Collapsible buttons added in account selection screen to have tree like structure.
- Added import logic for new bank.

Revision 1306
-------------
- Unreconcile reason: Enter unreconcile reason while unreconciling the transactions.
- Bug: Manual Recon - View Format Alignment Error

Revision 1297
-------------
- Bug: Object reference error while saving the easy rule in add/edit mode.
- Bug: Manual Recon: select all on the filters should not include the Account Column in the grid
- Manual Recon : Disable/grey out the Save Tag button unless there are Transactions in the 'Matched Transactions' area.

Revision 1287
-------------
- Bug: Put a label in the control to say when there is no data in Journal Rule.
- Allow removal of reconciliations that have a closed accounting period
- Performance tuning of reports

Revision 1282
-------------
- Bug: In custom install when install path is changed, all folders except UI are in program files folder.
- Give SiteAdministrator access to the admin menu

Revision 1277
-------------
- IE8 compatibility added

Revision 1267
-------------
- If this build is installed in upgrade mode on Digiata BankRecon database then all the profiles will be lost.

Revision 1258
-------------
- Rebranding of BankRecon.

Revision 2348
-------------
- Manual Recon screen grouping bugs have been addressed.

Revision 2341
-------------

- Bank Import Enrichment has been enhanced to include REPLACE functionality.
- Complete audit logging is now included.
- General fixes and enhancements include
- Bank Statement Import error messages have been adjusted to provide more information.
- Filters have been adjusted to provide clearer error messages when invalid date formats are used .
- Menu items can now be clicked on the entire length of the menu - previously one had to click on the word itself .
- The Open Cashbook batches screen has been slightly adjusted to avoid confusion. (Close Batch has a new icon and the tooltip states: Authorise and Close)
- Recon Rules making use of the specified temp table functionality, can now be properly tested using the testing functionality in the Bank Recon application.
- Users with Delete Tag rights can delete tags created by other users. (Any user can delete his/he own tags).

- Command Timeouts specified in rdls are now honoured by reports running in Bank Recon.

- The rights required to successfully run a daily process (Process Definition) are:
- Transactions - Run Import - Cashbook, Bank and Bank Details
- Transactions - Transfer
- Journal Entries/Bank Transactions - Auto Create
- Reconciliation - Auto Create
- Daily Process - Domain Group Process or Domain Process (these are menu rights)
- To configure a daily process (Process Definition), in addition to the above rights the following menu access right is needed:
- Setup - Daily Process

- A Daily Process selection can now be saved and scheduled to run automatically.
- If you do an upgrade, you will need to manually change some config files as follows: (And then restart the service)
- In the Web.config file, in the appSettings section:
Delete the line
<add key="ProcessServiceURL" value="tcp://localhost:8087/ProcessService" />
Add the lines
<add key="ThreadManagerURL" value="tcp://localhost:8087/ThreadManager"/>
<add key="SchedulerURL" value="tcp://localhost:8087/Scheduler"/>
- In the Twenty57.BankRecon.ProcessService.exe.config file
Delete the line
<wellknown type="Twenty57.BankRecon.API.ThreadManagerProxy, Twenty57.BankRecon.API" mode="SingleCall" objectUri="ProcessService" />
Add the lines
<wellknown type="Twenty57.BankRecon.API.ThreadManagerProxy, Twenty57.BankRecon.API" mode="SingleCall" objectUri="ThreadManager" />
<wellknown type="Twenty57.BankRecon.API.SchedulerProxy, Twenty57.BankRecon.API" mode="SingleCall" objectUri="Scheduler" />

Revision 2318
-------------
- Installer has been changed to provide the facility to complete even if the service fails to start.

Revision 2307
-------------
- Cashbook Allocations can now be viewed from the Cashbook Transaction screen, as well as from closed cashbook batches.
o Allocations can however not be edited unless the cashbook batch is still open
- Reconciliations can now be viewed from Closed cashbook batches as well
- Additional checks have been included to ensure that transactions reconciled in closed accounting periods cannot be un-reconciled.
- Selection tables are periodically cleaned up.

Revision 2298
-------------
The MIL99 bank statement format import has been adjusted to include the AFRIKAANS description in the description on Bank Recon, in addition to the English description.

Revision 2291
-------------
- Performance enhancements have been made to the
- Manual Recon screen,
- Cashbook Batches screen, and
- Cashbook Allocation screen.
- Report adjustments include
- Support for fixed parameters (@DomainID and @AccountID)
- Maintenance enhancements (Override and Remove)
- The Auto Recon balancing entry date setting bug has been resolved
- Images not displaying for certain configurations bug has been resolved

Revision 2258
-------------
- Auto reconciliations allow for separate GL Accounts per account and per negative or positive values.
- Remove the reporting services dependency. Reporting services is no longer a prerequisite for BankRecon.
Reports are no longer dependant on Reporting Services.
- 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.
- Session timeout no longer returns an error.
- BAI Statement fix
- Switch Value Date and Entry Date columns
- Allow user to supply custom bank statement parsers.
To do this the user must
1. Create a parser and detector that are derived from BankStatementParserBase and BankStatementDetectorBase in Twenty57.BankRecon.BankStatements.Common.
2. Compile the parser and copy the DLL and all its dependencies into the <InstallFolder>\ProcessService\Bin folder.
3. Add the name of the DLL to the BankStatementParsers Table.
NOTE: Every new parser DLL can only contain 1 detector and 1 parser. The detector must be able to uniquely identify the required statement. The first DLL in the table BankStatementParsers that has a detector that successfully detects the statement will be used. This means that the user will have to remove one of the existing parsers if they wish to replace the parsing of that statement type.

Revision 2240
-------------
- Transaction screens bug resolved - An error occurred when changing column aliases.
- Select All bug resolved - Records were not selected properly when using the Select All button.
- Fix auto recon messages - Some characters were being displayed incorrectly.
- Improved error handling for bulk uploads.
- Include back button on the manual recon view screen.
- Include paging on the Dashboard screen.

Revision 2188
-------------
- Some sub-menu items from the Setup menu have been split out into a new menu item Admin.

Revision 2182
-------------
- Accounting Period closing functionality has been moved to the service and tweaked for better performance
- Profiles bug resolved (Existing profiles would stop working if cashbook-and bank aliases were changed)
- The Import process has been adjusted to increase performance (bulk processing)
- A new web service method for bank statement import has been created to import a single file that spans across domains
- Manual Recon screen show additional summary information for matched items
- User Maintenance Rights separation
- A User Group can now be configured to do allow limited user maintenance (Assign users to a sub-set of the available groups ONLY)

Revision 2141
-------------
'Export to Excel exports ALL columns' setting on Account ensures that export to excel functionality includes all columns, regardless of whether or not they are selected in the specific view.

Revision 2139
-------------
Replaced Solpart menu objects with .Net menus

Revision 2138
-------------
Journal Rules can now be deactivated. Previously they needed to be deleted

Revision 2135
-------------
Application upgrade/conversion
- Framework 3.5 SP1 is now a requirement, as well as
- SQL 2005
- IIS 7 or later
Tools menu extension
- urls can be configured whereby users can navigate out of the application.
ABSA ASCII bank statements can now be imported.

Revision 2104
-------------
A customisable tools menu has been added for users to navigate into different web applications

Revision 2090
-------------
- NedAcad statement import bug was fixed. Multiple statements with the same statement number, date and account number were being created if a file had some transactions of the statement seperated by transactions from another statement. All transactions from the same statement are now grouped into 1 statement.
- BAI Type Code 721 has been changed from a DR to a CR.
- BAI transactions that have a date are now stamped with the transaction date and not the statement date. If a transaction does not have a date then the statement date is used, as before.

Revision 2074
-------------
The Bankbatch table now includes Statement Date

Revision 2063
-------------
Journal Rule bug resolved
- An error was generated if an open cashbook batch did not exist.

Report adjustment: Current Recon Report
- Inactive accounts are excluded from the results.

Nedacad Import adjustment
- Import multiple statements for the same account on the same day.

Archiving adjustment
- Archived data is kept for reporting purposes.

Revision 2048
-------------
BAI import adjustment
- Include transaction types larger than 699
Database naming consistency
- Change BankTransaction.BatchID to BankTransaction.BankBatchID

Revision 2039
-------------
Archiving Functionality has been added to Bank Recon
- Recons and the underlying items are grouped together into single items for the archived period.
- Detailed data is LOST and ONLY summary information remains in Bank Recon.
- Only SiteAdmin users have access to this functionality.

Auto Recon Accounting Period bug resolved
- The incorrect accounting period was being used for the recon if an auto recon was done, and the domain setting to use the current date was off.

Revision 2022
-------------
The recon rule includes an optional TemporaryTableCommand.
Temporary tables must be global - delimit with ##.
All existing rules run as they are, but some can be optimised with the help of a TemporaryTableCommand.

<?xml version="1.0" encoding="utf-8" ?>
<ReconDefinition xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
Name="Example">
<LeftDataset Name="Cashbook">
<TemporaryTableCommand>
<CommandText>
SELECT CashbookTransaction.ID, Details, Amount INTO ##CashbookTransaction FROM CashbookTransaction
INNER JOIN CashbookBatch ON CashbookBatch.ID = CashbookTransaction.CashbookBatchID
INNER JOIN Account ON Account.ID = CashbookBatch.AccountID
WHERE ReconID IS NULL AND Account.DomainID = @CurrentDomainID
</CommandText>
</TemporaryTableCommand>
<Command OrderFields="0" UniqueFields="0" Name="" CommandType="Text">
<Fields>
<FieldDefinition Name="Details" DataType="String" Key="false" Ordinal="0" />
<FieldDefinition Name="Amount" DataType="Decimal" Key="false" Ordinal="1" />
</Fields>
<CommandText>
SELECT Details, SUM(Amount) AS Amount FROM ##CashbookTransaction
GROUP BY Details ORDER BY Details
</CommandText>
</Command>
<GetKeysCommand OrderFields="0" UniqueFields="0" Name="" CommandType="Text">
<Fields>
<FieldDefinition Name="ID" DataType="Int32" Key="true" Ordinal="0" />
</Fields>
<CommandText>SELECT ID FROM ##CashbookTransaction WHERE Details = @Details</CommandText>
</GetKeysCommand>
</LeftDataset>
<RightDataset Name="Bank">
<TemporaryTableCommand>
<CommandText>
SELECT BankTransaction.ID, Details, Amount INTO ##BankTransaction FROM BankTransaction
INNER JOIN BankBatch ON BankBatch.ID = BankTransaction.BankBatchID
INNER JOIN Account ON Account.ID = BankBatch.AccountID
WHERE ReconID IS NULL AND Account.DomainID = @CurrentDomainID
</CommandText>
</TemporaryTableCommand>
<Command OrderFields="0" UniqueFields="0" Name="" CommandType="Text">
<Fields>
<FieldDefinition Name="Details" DataType="String" Key="false" Ordinal="0" />
<FieldDefinition Name="Amount" DataType="Decimal" Key="false" Ordinal="1" />
</Fields>
<CommandText>
SELECT Details, SUM(Amount) AS Amount FROM ##BankTransaction
GROUP BY Details ORDER BY Details
</CommandText>
</Command>
<GetKeysCommand OrderFields="0" UniqueFields="0" Name="" CommandType="Text">
<Fields>
<FieldDefinition Name="ID" DataType="Int32" Key="true" Ordinal="0" />
</Fields>
<CommandText>SELECT ID FROM ##BankTransaction WHERE Details = @Details</CommandText>
</GetKeysCommand>
</RightDataset>
<Matches>
<MatchDefinition Name="" Expression="(Decimal)LHS[1] == (Decimal)RHS[1]" />
</Matches>
</ReconDefinition>
Revision 2012
-------------
Processlog Message displays additional information.
Report results are cleared when parameter adjustments are made.
Collation of all relevant items set to be the same as the server's default collation.

Revision 1995
-------------
Cashbook Transactions have been extended to include an additional 10 reference fields.
- These fields will NOT be displayed in the front-end, and are purely for use in Importing and Reconciling.

Revision 1993
-------------
Column Aliases can now be specified separately for Cashbook and Bank transactions.
- The setting is available on Bank Account.

Revision 1990
-------------
New web service methods added
- SingleCashbookTransferRule
- SingleJournalRule

Revision 1987
-------------
Recon rule priority
- Bug fix when using windows authentication it was not possible to
save the changes to priority order.

Revision 1982
-------------
Recon view screen results limited to 500 records on each side for performance purposes.

Revision 1980
-------------
Export to Excel
- Aliases are now used when exporting from the Manual Match screen, as per the transaction screens.

Revision 1978
-------------
Manual Recon screen
- Group details view has been corrected to include the filter applied on the grouping.

Revision 1972
-------------
ReconHelper Process Streamline
- Helper GetKeys functionality has been replaced by a @ReconHelperId parameter.
- Make sure this is one of the fields in your original query, for the code to implement the performance enhancement.

Revision 1970
-------------
Date Format bug fixed on Filters
- use the format as specified in the web.config setting
- if the setting is not specified, then the application assumes 'dd/MM/yyyy'

The Filters have been upgraded to a later version of the filter component.

Revision 1968
-------------
Additional Web Service method: SingleBankStatementImport

Revision 1965
-------------
A constraint has been added to the database to prevent duplicate accounts from being captured
- Please note that the upgrade script will fail on a database that already contains duplicate Bank Accounts.

Revision 1964
-------------
Increase the performance on Batch screens

Revision 1956
-------------
Accounting Period
- Period determination over month end bug fixed

Revision 1953
-------------
SQLServer sessionstate serialising bug(s)
- Transfer Cashbook Page.

Revision 1948
-------------
Import Cashbook Transactions
- Cashbook Import Definitions can now include an optional integer field, namely GroupID.
This field is used to group Cashbook Transactions. The total amount of all transactions with the same Group ID will
be recorded as one transaction against the given account, but will be allocated to the different General Ledger Accounts
as per the individual records.
- Transactions belonging to the same group must have the same Transaction Date and Account (i.e. will be imported to the
same batch). Exceptions will cause the import to fail, with error messages written to the log.

- EXAMPLE:

1. Source Data That is Imported

ID Date Reference Details Amount AccountKey CashbookTxnTypeKey GlAccountKey VatKey GroupID
1 2006-01-31 Test Reference 1 Details 1 10 AGSF Broker Commission Paid 5600UNITHAGBB 0
2 2006-01-31 Test Reference 2 Details 2.1 10 AGBF Switch In 9700UNITHAGBB 0 1
3 2006-01-31 Test Reference 3 Details 2.2 20 AGBF Switch In 5600UNITHAGBB 0 1
4 2006-01-31 Test Reference 4 Details 3.1 10 AGSF Subscription Reversal 9750UNITHAGMF 0 2
5 2006-01-31 Test Reference 5 Details 3.2 20 AGSF Subscription Reversal 9755UNITHAGEB 0 2
6 2006-01-31 Test Reference 6 Details 3.3 30 AGSF Subscription Reversal 9756UNITHAGBB 0 2
7 2006-01-31 Test Reference 7 Details 4 67 AGSF Fund Account Payment 9850UNITHAGGF 0

2.1 Cashbook Transactions Produced

ID CashbookBatchID Date CashbookTransactionTypeID Amount ReconID Details
1 1 2006-01-31 1 10.00 Details 1
2 2 2006-01-31 2 30.00 Details 2.1
3 1 2006-01-31 1 60.00 Details 3.1
4 1 2006-01-31 1 67.00 Details 4

2.2 Allocations Produced

ID CashBookTransactionID GLAccountID InclusiveAmount VatAmount VatID Details
1 1 64 10.00 .00 1 Details 1
2 2 52 10.00 .00 1 Details 2.1
3 2 64 20.00 .00 1 Details 2.2
4 3 42 10.00 .00 1 Details 3.1
5 3 11 20.00 .00 1 Details 3.2
6 3 91 30.00 .00 1 Details 3.3
7 4 76 67.00 .00 1 Details 4

3. Explanation

Source Transaction [1] is not grouped and therefore only produces one Cashbook Transaction [1] and one
Allocation [1].

Source Transaction [2] and Source Transaction [3] are grouped, with Group ID [1], and produces one Cashbook
Transaction [2] and two Allocations, [2] and [3]. The Cashbook Transactionï¿½s amount is calculated as 10.00 + 20.00 = 30.00.

Source Transactions [4], [5] and [6] are grouped, with Group ID [2], and produces one Cashbook Transaction [3] and
three Allocations [4], [5], and [6]. The Cashbook Transactionï¿½s amount is calculated as 10.00 + 20.00 + 30.00 = 60.00.

Source Transaction [7] is not grouped and therefore only produces one Cashbook Transaction [4] and one Allocation [7].

Daily Process Dashboard
- When killing a process its status is set to ï¿½Errorï¿½ and the message is changed to ï¿½Process aborted by user [username].ï¿½

Revision 1929
-------------
Accounting Period parameter revisited on all reports
- Reports used to fail if the accounting period name could not be converted to a date
- The accounting period End Date is now used.

Revision 1922
-------------
The Date Format setting from the web config is being used to format dates on the front end.

Revision 1911
-------------
Dashboard
- The process log screen now provides interim updates on the progress of various tasks.

Revision 1906
-------------
Current Reconciliation Report with Unreconciled Details
- A single report combining the information from the Current Reconciliation Report, and the Unreconciled items report.

Revision 1902
-------------
Display a warning message when a user attempts to close an accounting period that is not entirely in the past.

Revision 1900
-------------
Multiple CATS statements where the statement number include the maximum statement number, as well as the reset number now works
- previously, these statements had to be imported separately if the statement counter reached its maximum number and was reset.

Revision 1899
-------------
Balancing Entry Accounting Period Determination correction
- Auto recon determined a different period (incorrect) than a manual recon (correct).

Revision 1896
-------------
Wizard Extensions
- Include Bank Detail Import screens to the daily process wizards

Revision 1894
-------------
Bank Detail Import Functionality (Recon Helper Import)
- The field layout for the imports are as follows
- GroupID (Each proposed recon must belong to a separate group)
- IsBankTransaction (1 = Bank; 0 = Cashbook)
- Date
- Amount
- Details
- Reference1
- Reference2
- Reference3
- Reference4
- Reference5
- Reference6
- Reference7
- Reference8
- Reference9
- Reference10
- Rule: The SUM of the Bank Transactions in a group must be EXACTLY EQUAL to the SUM of the Cashbook Transactions in the same group.

Revision 1887
-------------
Manual Recon
- If there are no unreconciled transactions a 'DBNull' would occur

Revision 1884
-------------
Dashboard
- Account name displayed for CashbookImporter and BankImporter details
- Popup details window is bigger

Revision 1883
-------------
NedAcad Bank Statement import enhancement
- Bank Recon can now import single files that contain multiple statements.

Revision 1868
-------------
Generatel ledger export
- Bug fix when selecting General Ledger Export from the menu the process did nothing.

Revision 1866
-------------
Manual recon
- Default search filter on average amount to speed up page display (if there are more than 1000 results).

Revision 1853
-------------
Adjustements have been made to Bank Recon to ensure that reports will work using either Reporting Services 2000, or Reporting Services 2005.

Revision 1834
-------------
BankStatement Import (Add new format: Standard Bank Multiple Accounts)
- Standard Bank Multiple Accounts Statements can now be imported into Bank Recon.

BankStatement Import (Add new format: NedAcad)
- NedAcad Statements can now be imported into Bank Recon.

Revision 1825
-------------
BankStatement Import (Add new format)
- NedInform (Standard Nedbank Format) Statements can now be imported into Bank Recon.

General Ledger Export (External Reference Field)
- The General Ledger Export tables now contain an External Reference field, for external systems to use/update to track which items have been dealt with.

Revision 1822
-------------
Increase size of Details pop-up
- Since Timestamp information was added to the details, the windows size has become insufficient, and seemed cluttered. This has been adjusted/corrected.

Install Maintenance: config timeout settings
- Ensure all timeout settings available in the various configuration files, are included by default.

Revision 1799
-------------
Redo: Approve Cashbook Batches on Domain level
- Implement this functionality again (Was included in Revision 1617, but was somehow removed/excluded).

Revision 1798
-------------
BankStatement fix (SBSAML99 sign adjustment)
- the sign interpretation has been inverted.

Revision 1788
-------------
Install maintenance: Service not starting
- Due to permissions restrictions at some clients to automatically start services, if the service fails to start during the install
the user has the option to complete the install anyway instead of rolling back.

Revision 1777
-------------
Error message update for import bank transactions
- When the opening statement balance is incorrect include the expected value in the error message

Revision 1776
-------------
Domain wizard
- Don't show Finish button on the dashboard when using the wizard

Revision 1775
-------------
Bank details field size increase
- to accomodate details field from BAI statements (max 800 characters)

Revision 1771
-------------
Current Reconcilliation Report
- Accounting Periods parameter dropdown ordered descending.
- Condition adjusted to include the selected Accounting Period.

Process Log enhanacement: Service is down
- A more user-friendly error appears when the service is down.

Revision 1766
-------------
Install multiple instances of the service like this:
- InstallUtil /ServiceName=BankRecon1 /DisplayName=BankReconProcessService1 "C:\Program Files\Bank Reconciliation\ProcessService\Twenty57.BankRecon.ProcessService.exe"
- Give each instance different service names and display names
- For each service, in its config file (Twenty57.BankRecon.ProcessService.exe.config) specify a different port number. Make sure this same port number is in the corresponding web.config.
- Go to the services manager and start each service.

Sessionstate in db: Recon Rules page not serialisable
- Bug introduced as part of the SessionState Adjustments.

Current Reconciliation Report - All Accounts
- Report did not filter Accounts for a selected domain properly.

Revision 1759
-------------
Thread is being aborted message
- Empty GL Export runs would produce this error, as opposed to doing nothing.

Revision 1741
-------------
Use remoting service to run processes
- To prevent problems with ASP.NET automatically killing process threads, run the process threads using a service.
- When upgrading, please do the following steps manually:

In C:/Program Files/BankRecon/ProcessService/Digiata.Reporting.ProcessService.exe.config
-Edit the connection string url to match the one in web.config
- (optional)Add a setting for command timeout:
<add key="Microsoft.ApplicationBlocks.Data.CommandTimeout" value="500" />

In C:/Program Files/BankRecon/web.config
-Add the appSetting
<add key="ProcessServiceURL" value="tcp://localhost:8087/BankReconProcessService" />

Any settings which appear in the both config files should usually have the same value, please remember to update both
config files if any changes are made, especially the ConnectionString url.

In Administrative Tools ->Services, start the Bank Reconciliation Process Service. This only needs to be done once. If the
service fails to start, check the event logs. Any changes to 'Twenty57.BankRecon.ProcessService.exe.config'
require the service to be restarted.

Revision 1754
-------------
Process Log: Details view enhancement
- A timestamp has been added on ALL entries made into the processlog details.

Revision 1736
-------------
Deposit Exception / Detail Notes functionality
- Expose Bank Statement information to external systems using a web service.
- Allow limited Bank Statement Enrichment from external systems using a web service.
- Allow external systems to define notes (example: fund transfers) using a web service.
- The user must have access to the Run BankDetails Import RIGHT to be alble to run these webservices.

Revision 1730
-------------
Helper Import adjustment
- The User Reference field on the file is now handled generically.

Allow SQLServer mode session state.
- To set up the session state database tables, execute the following command:

aspnet_regsql.exe -ssadd -S [SQL server] -U [user name] -P [password]

Then change the sessionState tag in the web.config to:
<system.web>
<sessionState mode="SQLServer" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="Server=[SQL server];User=[user name];Pwd=[password];" cookieless="false" timeout="20"/>
</system.web>

To remove the session state database tables, execute the following command:

aspnet_regsql.exe -ssremove -S [SQL server] -U [user name] -P [password]

Authentication bug
- The Automated Linx user could not access bank statements on the network if Bank Recon was run using windows authentication.
- In this scenario the Network User specified under Setup | Option is now used to access the bank statement directory.

TimeStamp on Balancing Entry
- Balancing Entries no longer contain timestamp information on the Date field

Revision: 1728
--------------
Extend Daily Process wizards (include GL export)
- The Domain wizard and Domain Group Wizard have been extended to include General Ledger Exports.

Bank Import: Special character replacement
- Special character 'ï¿½' that was causing a bank statement import errors is now removed before import.

Bank Import: Error trapping enhancement
- Provide the line number when a parsing error occurs on a PACS bank statement.

Revision: 1689
--------------
Search across accounts (exclude inactive accounts)
- A user could still interact with transactions in an inactive account, by using the search across account facility.
- Inactive accounts were not excluded from cashbook transfers and journal rules

Enhanced Match Details Report
- some minor enhgancments/adjustments to the Match Details Report

Revision: 1686
--------------------
New Report (Monthly Balance Report)
- Include new report in build.

Accounting Period Opening Balance Display bug
- Opening Bank Balance correctly updates as the opening balance of the first batch (as was always the case)
- All previous periods, with no bank statements are also updated with this balance as opening and closing balance.

Revision 1680
-------------
Auto Recon Timeout (config setting)
- Auto recon rules now use the <add key="Microsoft.ApplicationBlocks.Data.CommandTimeout" value="650" /> setting in the web.config

Revision 1678
-------------
Export to Excel bug
- Export to Excel functionality will now allow NULL database values to be exported to csv.

Revision 1677
-------------
Auto Recon Rule Enhancement (determine Balancing Entry Account)
- When creating Journal Entries for Balancing Entries, by selecting 'Use Cashbook Transaction Allocation GL Account', the Cashbook Transaction's Allocation GL Account will be used as the GL Account to book the Balancing Entry against.
- Note that this will only work if the cashbook entries for the reconciliation are all linked to the same GL Account.

Revision 1674
-------------
Balancing Entry Date Setting
- A setting has been added in the Domain Settings, to force the current date as the transaction date of balancing entries.

Revision 1673
-------------
Cashbook Allocation: Paging when searching accross accounts
- With Search Accross Accounts enabled, the user was unable to page on the screen.

Revision 1671
-------------
Mark process as aborted if thread is not alive
- When opening / refreshing the "Daily Process Dashboard", all busy processes with inactive threads will be marked as aborted.

Revision 1668
-------------
Custom Grouping change
- Custom Grouping excludes transaction date, unless expressly specified.

Revision 1666
-------------
Profile Bug
- If no profile(s) exists for the current user, no attempt at loading the 'Last Used Profile' is made.

Revision 1664
-------------
Transfer Grouping bug
- From Account Balancing entry grouping bug corrected for custom grouping functionality.

Revision 1662
-------------
Include new Match Details report
- To remove the sub-reports from the display list in Bank Recon, when using this report, set the 'Hide in list view' setting on the properties of the sub-report rdl's to ON in the Reports Manager site.
- Please note that the export to Excel functionality exposed via Reporting Services does not cope well with exporting reports that include sub reports.

Revision 1660
-------------
Report Maintenance
- Date parameter usage standardized.
- Accounting Period parameter usage standardized.

Revision 1659
-------------
Sort Order on Cashbook Transaction Screen
- TransactionType column sort order function bug fixed

Revision 1657
-------------
Additional info for Processlog Details
- For Domain Group runs, the Domain names are also displayed as part of the Process log Details

Revision 1654
-------------
Transfer Cashbook Transactions Rights
- The close batch right is no longer required for a user with Transfer rights

Revision 1650
-------------
Export to Excel: Date Stadardisation
- Remove timestamps from dates when exporting to excel. (They were always 00.00)
- Add a "DateFormat" configuration key to the <appSettings> web.config file.
<add key="DateFormat" value="dd/MM/yyyy"/>
- Use configuration key to format date selections in reports.

Revision 1647
-------------
Reset Password functionality enhancement
- Disable password reset functionality when Windows Authentication is implemented.

Revision 1643
-------------
Investigate CashbookTransaction screen performance
- Removed binding to grid on page load for Cashbook- and Bank Transactions screens

Revision 1641
-------------
Manual Recon screen: Export to Excel bug for multiple accounts
- Cashbook Export to Excel with Search Accross Accounts checked bug resolved
- Similar fix done for the Bank Export

Revision 1639
-------------
Hide in List View setting in Report Server
- This Reporting Services Setting was not used when displaying the list of available reports

Revision 1635
-------------
SortOrder on Manual Recon screen
- TransactionType column sort order bug resolved

Revision 1632
-------------
Display DomainName in ProcessLog view
- Add the domain name to the process log entry for all processes.

Revision 1630
-------------
Balancing Entry Description
- Allow the user to specify balancing entry details for the description of the transaction.

Revision 1629
-------------
Persist selected items in the Manual Recon screen
- Persist selected items while paging

Revision 1627
-------------
WebService: Error Handling enhancement
- Add a process log entry if there are no files in the directory for a bank statement import.
- Throw a user friendly error message in the case of an invalid username or password.

Revision 1625
-------------
Create Balancing Entries from Manual Recon screen
- Disallow Balancing Entries to be created if the 'Allow Manual Cashbook Transactions' setting on the account is OFF/UNCHECKED

Revision 1624
-------------
Order Domain Groups, Domains and Accounts in the first screen

Revision 1622
-------------
Increase All Reference fields from varchar(50) to varchar(200)

Revision 1620
-------------
Transaction View pages filter bug
- Previously filtering for Tags = 0 returned no results. This bug has been corrected

Revision 1617
-------------
Approve Cashbook Batches on Domain level
- Users can approve cashbook batches on domain level.

Revision 1614
-------------
Cashbook Transfer Rule Bug Fix
- Custom Grouping functionality works correctly when the user is logged in at domain level.

Revision 1579
-------------
Import BAI bank statement format
- New Bank Recon Statements using this standard can now be imported.

Revision 1570
-------------
PACS file import change: file format change
- Adjustment to import Bank Statement Details based on the latest PACS debit order collections file.

Revision 1554
-------------
Reporting Services Timeout
- The timeout setting(s) for Reporting Service Component has been exposed, and can be set in the web.config as follows
- <add key="Digiata.Web.ReportingServices.ReportTimeOut" value="100"/>

Revision 1550
-------------
- UnReconcile web service: A new method was added to the web service, to allow the removal of a reconciliation
- User Rights Maintenance: Certain Maintenance tasks were removed from the Manager User Group.
- Reports Add/Remove: Changes/Adjustments to General Ledger Reports have been made.

Revision 1536
-------------
Manual Recon Screen: Export to Excel bug (on search accross accounts)
- Export to excel functionality did not wrok when searching accross accounts.

Revision 1531
-------------
General Ledger Export Functionality (Run Export)
- A user can execute a previously configured General Ledger Export Rule in order to supply the results to an External General Ledger system.

Revision 1526
-------------
General Ledger Export Functionality (Maintenance)
- A user can configure a General Ledger Export Rule for a set of selected Accounts, based on the Cashbook Batch Type

Revision 1523
-------------
Custom Grouping for Cashbook Transactions Transfer
- The user can now specify the desired grouping of transactions on a Cashbook Transfer Rule.

Revision 1519
-------------
Cashbook Transaction Screen maintenance
- Retain filters and column selections when toggling between normal cashbook view, and search across accounts view
- Export to Excel was not working properly with the search across accounts option ON

Revision 1518
-------------
Performance of manual recon screen
- Performance enhancements applied

Revision 1513
-------------
Bank Statement Import
- Swift 940 messages were not being recognised as a valid format

Revision 1510
-------------
Kill a running Process bug (Also update the status of child processes)
- This ensures that Processes that have been killed/stopped, do not remain as 'busy' in the database, thus disallowing processes of the same type to run.

Revision 1508
-------------
Dashboard rights issue
- Viewing entires in the Dashboard is only depenedant on access to the relevant Menu Item

Revision 1505
-------------
Additional WebServices (Domain Group)
- New Bank Recon webservice methods include DomainGroupCashbookImports, DomainGroupAutoRecons, DomainGroupJournalRules, and DomainGroupCashbookTransfer

Revision 1492
-------------
Order Processes (Auto Recons, and Imports)
- Recon Rules run based on the configured priorities. Cashbook Imports run sequenced by name. Bank Imports run sequenced by Statement Number and Date.

Revision 1489
-------------
User Activity/Productivity Report
- Report on reconciliation statistics per domain and user for a specified date range

Revision 1487
-------------
Prioritise functionality for Auto Recon Rules
- The User can now specify the execution order/priority of Recon Rules in the Recon Rules maintenance page.

Revision 1485
-------------
Update Processlog in smaller chunks
- The processLog will now be updated per Auto Recon Rule and/or Cashbook Import and/or Bank Import that is run, as opposed to a single update per process group.
- The Dashboard screen has also been enhanced to show the Process Type.

Revision 1481
-------------
Kill a busy Process
- A user will with the appropriate rights will be able to kill a process that has a status of busy in the Process Dashboard screen.

Revision 1478
-------------
Restrict Multiple Processes of the same type running at the same time
- A user will not be able to run any process that displays through the Process Dashboard (for example a Cashbook Import), while another process of the same type (in this example a Cashbook Import) is busy running.
- Set <add key="AllowConcurrentProcessExecution" value="false" /> under <appSettings> in the web.config, to disallow multiple processes of the same type from running.
- By default processes of the same type are allowed to run concurrently, and the setting will not automatically be present in the web.config.
- To disallow multiple processes of the same type to run concurrently, this setting has to be added to the web.config file manually.

Revision 1476
-------------
Bank Detail Import Message enhancement
- Standardise Details message for Bank Detail Imports.

Revision 1475
-------------
Bank Import Bug: Invalid file type import should give Error status, not successful
- Enhanced Error Trapping when attempting to import files that are of an invalid format

Revision: 1472
--------------
Reconciled Bank Deposits older than three months
- This new Report identifies Bank Deposits that are three months older than the Reconciliations they form part of.

Revision: 1470
--------------
Manual Recon screen bug (decimals do not display)
- Values in the matching area on the Manual Reconciliation screen, were not displaying decimal values.
Account Maintenance: Cosmetic Changes
- Neaten the Account Maintenance page

Revision: 1459
--------------
Associate Accounts with GL Accounts (when adding a GL Account)
- This allows the user to associate a new GL Account to a number of Accounts.

Revision: 1457
--------------
ReconHelper Import Enhancement
- The Bank Details Import, now also runs in a separate thread, displaying details/progress on the process dashboard screen.

Revision: 1455
--------------
Associate Accounts with GL Accounts
- This allows specific GL Accounts to be associated to Accounts, and only making these associated GL Accounts available when creating Balancing Entries and Manual Cashbook Entries;

Revision: 1446, 1452
--------------------
ReconHelper Import to run via the Dashboard
- Upon bank details import, the user is navigated to the Dashboard screen with an entry for the import.

Revision: 1439
--------------------
Include release notes in build
- Clicking on the version (link button) in the menu bar of Bank Recon, will display the complete Release Notes in a seperate window.

Revision: 1429, 1431, 1435, 1437
----------------------------------------
ReconHelper Import (functionality)
- PACS collections file showing the detailed breakdown of Bank Transactions, can now be imported into the ReconHelper tables.

Revision: 1433
--------------------
Balancing Entry (Allocation) enhancement (Closing batch)
- It was not possible to close a batch that included a balancing entry consisting of multiple allocations. This has been remedied.

Revision: 1427
--------------------
Bank Enrichment enhancement
- Specify additional Input fields and Destination Fields on the Bank Enrichment screen.

Revision: 1416
--------------------
Cashbook Transaction and Bank Transaction paging bugs
- Maintenance after implementing server-side paging

Revision: 1414
--------------------
User Maintenance Enhancement (Reset Password)
- Clicking the rest password button, will reset the user's password to ‘password’

Revision: 1413
--------------------
Balancing Entry (Allocation) enhancement
- Allow multiple Allocations when creating a balancing entry.

Revision: 1412
--------------------
Balancing Entry journals over month end
- Determine the Balancing Entry’s date and accounting period as the greater of the first day of the first open accounting period (and that accounting period), or the date and accounting as the latest transaction in the selection (Cashbook and Bank).

Revision: 1406
--------------------
Server-side paging on Cashbook-and Bank Transaction Screens
- Performance enhancement: Only the relevant page’s information will be retrieved from the server, as opposed to retrieving the entire dataset.
- Page size for ALL the grids on the Cashbook-and Bank Transactions screens, as well as the manual recon screen can be set as follows in the <appSettings> section of the web.config file
<add key="PageSize" value="10"/>
- All other functionality stays in-tact.

Revision: 1403
--------------------
Bank Import enhancement
- If a bank account number is not found on import, the leading zeros are dropped from both the statement and the system in an attempt to find the account.
- This error surfaced due to the fact that some SWIFT statements contain Account numbers with leading zeros.

Revision: 1398, 1402
--------------------
Paging for the Matching Area on the Manual Match screen
- The matching area on the manual recon screen now also contains paging.
- Page size for ALL the grids on the Cashbook-and Bank Transactions screens, as well as the manual recon screen can be set as follows in the <appSettings> section of the web.config file
<add key="PageSize" value="10"/>

Revision: 1401
--------------------
Cashbook Transaction Types Enhancement
- Only Transaction Types marked as ‘Allow Manual Entries’ will be available when manually creating cashbook transactions.
- All Cashbook Transactions Types will initially be defaulted with ‘Allow Manual Entries’ ON, to ensure backward compatibility for clients that do not choose to use this option.

Revision: 1396
--------------------
Manual Recon screen: Cosmetic changes
- Paging can no longer be disabled. The performance losses are too great. With the Implementation of Server-side paging, this was no longer an option.
- Page size for ALL the grids on the Cashbook-and Bank Transactions screens, as well as the manual recon screen can be set as follows in the <appSettings> section of the web.config file
<add key="PageSize" value="10"/>

Revision: 1395
---------------
Investigate Bank Statement error
- File trailer/footer was incorrect, since the file was changed manually.

Revision: 1383, 1387, 1389, 1392
---------------------------------------------
Include Report in bank recon build
- A new Age Analysis Report for Outstanding Deposits generated per domain, from a specific accounting period has been included.

Revision: 1382
--------------------
PACS bank statement import
- Previously, empty PACS statements (statement number = ‘00000’) would give an error, because the statement number validation would fail. Now a Warning is written to the details stating which empty statements were ignored, and the import will complete successfully.

Revision: 1378, 1379, 1380
----------------------------------------
Extend Web Service (Auto Recon Rule)
- Extend the new web service to include the running of Auto Recon Rules. The functionality is the same as selecting the specific Auto Recon Rule on the Front End, and running it. The ProcessLogId is returned on success and failure. This Id can be used to check/confirm the status of the process.

Revision: 1377
--------------------
Extend Web Service (Multiple Bank Statement Import)
- Extend the new web service to include Multiple Bank Statement Imports. The functionality is the same as running the Multiple Bank Statement Import from the front end, selecting all the files in the pre-defined directory. The ProcessLogId is returned on success and failure. This Id can be used to check/confirm the status of the process.

Revision: 1373, 1374, 1375
----------------------------------------
Implement a web service in Bank Recon (Cashbook Import)
- Cashbook Imports can now be done using a new Bank Recon web service. The functionality is the same as selecting the specific Cashbook Import on the Front End, and running it. The ProcessLogId is returned on success and failure. This Id can be used to check/confirm the status of the process.

Revision: 1361
--------------------
Paging bug for Bank Grid with searching Across Accounts resolved.

Revision: 1360
--------------------
Bank Statement Import Across Domains
- Previously, when only a domain Group was selected, an import could be run across domains, on domain group level. The Domain Group Wizard was not working as it should, but now imports on Domain Group level (across domains), regardless of whether or not a domain and or account is selected.

Revision: 1359
--------------------
Export to Excel, and close buttons on the page that views the underlying details of a group when using the group by functionality on the Manual Recon screen.

Revision: 1352
--------------------
Profile bugs when searching across accounts
- Bugs/Errors around the saving/loading of profiles on the manual match screen have been resolved.

Revision: 1348, 1350
--------------------
New Report: Unreconciled Item Detail Report
- Extension of current summary reports

Revision: 1287
--------------------
Bank Statement Import (MT940) bug
- Failed to import messages that had a fund code value populate in tag 61.

Revision: 1346
--------------------
Import PACS bank statements
- PACS bank statements (not to be confused with PACS payment files) can now be imported using the bank statement import in Bank Recon.

Revision: 1317 - 1326, 1328 - 1345
----------------------------------------
Search Across Accounts in the Manual Recon screen, and reconcile across accounts (transaction transfers, etc. happens in the background)
- This functionality is explained in the top of the document.

Revision: 1327
--------------------
Import empty SWIFT bank statements
- Swift statements with no transactions (only statement number with opening and closing balance were not importing.

Revision: 1313
--------------------
Auto Match performance enhancements
- Performance enhancements to shorten the time needed/used by Auto match rules.

Revision: 1311
--------------------
Sorting on Transaction Grids (Cashbook-and Bank Transaction screens)
- Increased/Enhanced sorting by clicking on the column headings

Revision: 1304
--------------------
Transfer from Account while searching Across Accounts
- In the transfer, ignore transactions that are already in the destination account. This bug was introduced when we allowed users to select the ‘FROM’ account as the ‘TO’ account when searching across accounts on the Transfer screen (Specific Requirement from Stanlib).

Revision: 1300, 1303
--------------------
Select All with Paging ‘Off’ bug
- On the Manual Recon screen, when turning Paging off, when trying to select all the items, the last item was not being selected.

Revision: 1302
--------------------
Duplication of Allocation Amount when doing multiple allocations in a single transaction.
- Resolved

Revision: 1294
--------------------
Multiple Bank Statement import bug
- When importing multiple files that contain multiple account statements per file, the order

Revision: 1287
--------------------
Bank Statement Import (MT940) bug
- Failed to import messages that had a fund code value populate in tag 61.

Revision: 1285
--------------------
Tag maintenance screen changes – Change button labels
- When changing a Tag from the tag screen, the save buttons have different labels to when changing the Tag from the Manual Recon screen. (Purely a cosmetic change)

Revision: 1282
--------------------
Tag Enhancements
- Different users can now view and add comments to tags. Also, when a tag’s type is changed, a comment is automatically added stating from and to what type it was changed. (This functionality is useful if/when tag types are used to raise/track/resolve specific types of issues.)

Revision: 1277
--------------------
Edit Tag Screen layout (extended Tag functionality)
- Click on the name of a tag in the tag screen, to change a tag and/or to add a comment to a tag
Delete/Cleanup Tags
- - All the comments that are made for a tag are removed along with the tag, once the tag is deleted/removed.

Revision: 1276
--------------------
Account Sweep (Incorporate Dashboard)
- bug fixed that was introduced with the new Account Sweep functionality

Revision: 1275
--------------------
Tag Screen enhancements (extended Tag Functionality)
- Click on headings in the Tag screen, to order the tags listed on the page. Click on the heading again, to toggle the sort order between ascending/descending. (This is basic sorting functionality, and will order only on the single column heading clicked last.)

Revision: 1274
--------------------
Edit Tag Screen layout (extended Tag functionality)
- Click on the name of a tag in the tag screen, to change a tag and/or to add a comment to a tag

Revision: 1272
--------------------
Account Sweep (Incorporate Dashboard)
- When running an Account Sweep (Cashbook Transfer), the result is listed/displayed in the dashboard.

Revision: 1268
--------------------
Implement @CurrentDomain for GetKeys and HelperGetKeys
- allow the use of @CurrentDomainId in the HelperXML for a Recon Rule

Revision: 1267
--------------------
Account Sweep (Part of the Daily Process)
- Daily Process has an additional step/page to do account sweeps

Revision: 1265
--------------------
Account Sweep (Run Cashbook Transaction Transfer)
- Cashbook Transaction Transfer is a new menu item that will run a rule-type account sweep.

Revision: 1263
--------------------
Tag screen changes (extended Tag functionality)
- Name of the tag provides a link button to a screen for capturing comments on the tag, and for changing the tag

Revision: 1262, 1261
--------------------
Rights Changes (extended Tag functionality)
- New Rights in the User Groups to accommodate the new Tag functionality

Revision: 1257
--------------------
Account Sweep (Defined as a Cashbook Transaction Transfer Rule)
- Under setup, there is a new menu item for configuring an Account Sweep Rule.

Revision: 1255, 1252
--------------------
Tags Maintenance (Cleanup functionality)
- Cleanup button on the Tags screen, will remove all tags that are owned by the specific user, AND if all the transactions that are referenced in the tag, have been reconciled.

Revision: 1253
--------------------
Tag Report Maintenance
- bug fix done for Tag Report

Revision: 1250
--------------------
Account Sweep Retain Details - Group Balancing Entry by Account AND Date
- With retain details, group the balancing entry in the FROM account per ACCOUNT per DATE.

Revision 1250
--------------------
Account Sweep Retain Details - Group Balancing Entry by Account AND Date
- With retain details, group the balancing entry in the FROM account per ACCOUNT per DATE.

Revision 1246
--------------------
Inactive Domains visible in Daily Processes
- None of the import definitions, auto match definitions, or journal rules should be visible/available in the Daily Process wizard if the Domain is not active.

Revision 1244
--------------------
Journal Rules (context - domain, account, etc.)
- Only rules for a specific account(cashbook) need to be displayed when the account(cashbook) is selected

Revision 1240
--------------------
Balancing Entries when using ReconHelper records to reconcile
- If a ReconRule references the ReconHelpers(you must specify the Helper GetKeys as well), and the create balancing entry setting is ON, then
- Balancing entries will be created as follows:
1. An exact row for every row present in the Helper, but Not in the Cashbook.
2. A contra-row, which is exactly like the one in no. [1], but with an opposite sign
- A complete example has been supplied as part of a small database backup. This can be used to test/confirm the functionality, and as a template/starting point for creating recon rules of this type.

Revision 1238
--------------------
Account Sweep: Performance Enhancement
- Numerous performance enhancing changes including changes to make the code faster and more efficient, as well as SQL tweaking and enhancements to increase the throughput.
- Bulk Transfers with the ‘Retain Details’ setting ON, will now only create a single balancing entry PER ACCOUNT in the FROM account. In the TO account, each record will be created separately.
- This will be change to create a single entry PER ACCOUNT PER DAY in the FROM account

Revision 1236
--------------------
Add Help Functionality to Other Matches screen
- Functionality to explain usage, and provide examples of how to use the Other Matches editor. (This is part of the Easy Recon Rule Editor)

Revision 1233, 1234, 1235
--------------------
Network user to access multiple bank statements directory
- The network user used to open/connect to the directory/drive specified for the multiple bank statements, will only be used if it is specified.
- To define/specify the network user, navigate setup | site configuration (The Reporting Services Configuration has been included on the same screen, since they both represent site-wide settings)
- You will not be able to save/change the upload directory for a domain group, unless a valid network user has been specified, or if directory is directly accessible by the user currently logged on.

Revision 1231
--------------------
All Bank Batches bug and All Cashbook Batches cosmetic change
- The columns on the All Bank Batches screen where aligned incorrectly for rows that did not have any ReconIds
- Right Align the Allocation Amount, just like Amount. It was left aligned.

Revision 1230
--------------------
Report Maintenance: Items Not Reconciled
- Incorrect column data was given through by the report. This has been corrected

Revision 1228
--------------------
Standardize Reports
- Ensure all .rdl files are sized to fit inside the defined page margins for the report – This ensures that additional empty pages, etc do not occur when printing reports to PDF.
- Place a standard header with a date time stamp on all reports,
- Ensure each Reports description is saved in the .rdl to ensure the description of the report is visible and correct when the .rdl is uploaded. No additional editing is needed.

Revision 1227
--------------------
Account Sweep enhancement
- Retain Details of account sweeps

Revision 1225
--------------------
Remove MODERN recon rule view
- This functionality has been replaced by the Easy Rule editor

Revision 1224
--------------------
Easy Recon Rule: Run Auto Recon
- Execute a recon rule built using the new Easy Rule interface

Revision: 1221
--------------------
Embed Swift schemas in bankrecon code
- Import SWIFT message types 940 and 950 as bank statements

Revision: 1220
--------------------
VB and C# syntax option(s) for Other Matches editor screen

Revision: 1219
--------------------
Easy Recon Rule: same side recon
- Part of new Easy Recon Rule functionality

Revision: 1218, 1217, 1216, 1215, 1214
----------------------------------------
SWIFT Bank Import: MT940
SWIFT bank Import: MT950
Import Multiple swift messages on a single file
- Import SWIFT message types 940 and 950 as bank statements

Revision: 1213
--------------------
Profile save/Load bug
- Specify filters, save a new profile, when the user then selects transactions, the running totals in the status bar gave ‘NotANumber’ values – this has been fixed

Revision: 1212
--------------------
Add Test Functionality to Other Matches screen
- Part of new Easy Recon Rule functionality

Revision: 1210
--------------------
Convert Easy Rule to Classic Rule
- Part of new Easy Recon Rule functionality

Revision: 1207
--------------------
Confirm Test Functionality on Recon Editor screen
- Part of new Easy Recon Rule functionality

Revision: 1206
--------------------
Increase field length for Bank-and Cashbook Transactions
- Description/Details field length increased to 300

Revision: 1204
--------------------
Add Field Selection Functionality to New Rule Editor
Add Exact Match Functionality to New Rule Editor
Add Other Matches Functionality to New Rule Editor
- Part of new Easy Recon Rule functionality

Revision: 1202
--------------------
Remove batch when recons exist
- the user gets a warning, and can decide to delete the batch (including the recons), or not

Revision: 1200
--------------------
Remove batch when recons exists
- the user gets a warning, and can decide to delete the batch (including the recons), or not

Revision: 1198
--------------------
Additional operator options on Filters
Additional Account Sweep requirements
Select page checkbox does not work when search accross accounts is set to ON
Page out of range error
- Transfer transactions from multiple accounts at the same time

Revision: 1197
--------------------
New Recon Rule Screen Layout and basic functionality
- Part of new Easy Recon Rule functionality

Revision: 1195
--------------------
Difference between existing format Recon Rules, and NEW format Recon Rules.
- Part of new Easy Recon Rule functionality

Revision: 1193, 1192, 1191, 1189
----------------------------------------
Install option: Windows Authentication
- See the specific instructions at the top of the release notes

Revision: 1187
--------------------
Go Directly to Dashboard screen after submitting a Cashbook Import
Go Directly to Dashboard screen after submitting a Bank Import
Go Directly to Dashboard screen after submitting a Auto Reconciliation
- Dashboard screen shows the progress of all these processes
- Stops time-out from occurring for extremely large auto match rules and/or imports

Revision: 1186
--------------------
User Maintenance
- Admin user functionality, etc

Revision: 1185
--------------------
Update Digiata.GridFilter.DLL to latest version
- Affects all filters Recon Pages, Transactions Pages, Batch pages, etc.

Revision: 1180
--------------------
Inconsistent with Stylesheet: Format frame on Manual Recon screen
- cosmetic change

Revision: 1177
--------------------
Account Sweep per domain
- search across accounts option added to the Filter on the Transaction Transfer Page

Revision: 1175
--------------------
Cashbook Import: Timeout
- large Cashbook Imports gave timeout errors (resolved)

Revision: 1170
--------------------
Install option: Windows Authentication
- See the specific instructions at the top of the release notes

Revision: 1117 - 1119
----------------------------------------
RELEASE FIX: Maintenance was done on the following report
- Current Reocncilliation Report (Maintenance)
- Tags Report (Maintenance)
- Recon Rule Matching Stats per domain (added recently)
- Non Reconciled Transaction Summary (added recently – name changed to UnReconciled Item Summary on Account Level)

Revision: 1112
--------------------
RELEASE FIX: Reporting Services Always uses localhost
- Server setting was not used, instead, the localhost was used, regardless of the host setting(s)

Revision: 1110
--------------------
RELEASE FIX: Non Reconcilled Transaction Summary
- Report errors/bugs – did not auto populate the selected domain, etc
- Please confirm if this report works correctly, and if it should be limited to a single accounting period only.

Revision: 1108
--------------------
RELEASE FIX: Show user while assigning groups, to show what you're busy with
- Display the Domain and User in the Assign Rights Page

Revision: 1104
--------------------
RELEASE FIX: Save empty profile
- Bug/Error occurred when
o saving an empty profile(no filters applied), especially for a new user, and
o when the filters are never viewed, and only columns are clicked to change the view, and the profile was then saved

Revision: 1101
--------------------
RELEASE FIX: Reporting Services Always uses localhost
- Server setting was not used, instead, the localhost was used, regardless of the host setting(s)

Revision: 1099
--------------------
RELEASE FIX: Refresh LastKey when running Import
- When Running a Cashbook Import, the page did not refresh after completion to show the incremented KeyVale

Revision: 1095 - 1096
----------------------------------------
RELEASE FIX: Reporting Services Config
- Error/Bug when saving settings to the database

Revision: 1086
--------------------
Profiles with Dynamic Filters
- Dynamic filters where never saved correctly as part of a profile, this has been corrected.

Revision: 1032
--------------------
Create additional default groups
- User Security Changes/Enhancements

Revision: 1031
--------------------
Cashbook / Bank Transaction screen paging bug/error
- With paging set to ON, when a user navigates to a specific page, and then defines a filter on the view that returns a total number of pages less that is less than the page number the user was on before applying the filter, an error occurs. This was true for both the Cashbook Transactions, and the Bank Transactions screen(s).

Revision: 1029
--------------------
Implement User Configurable rights (Create Transactions Using Journal Rules)
- User Security Changes/Enhancements

Revision: 1028
--------------------
Manual Recon Group By on View change
- Default ‘Group By’ option to <blank> in stead of ‘Group By’

Revision: 1024
--------------------
Right To Left option on Bank Import Enrichment
- Bank Import Enrichment using regular expressions now has a right to left option included

Revision: 1023
--------------------
Greyscale icons when functionality is unavailable
- User Security Changes/Enhancements

Revision: 1022
--------------------
Create additional default groups
- User Security Changes/Enhancements

Revision: 1020
--------------------
Manual Match Screen bug
- When paging to the last transactions in the cashbook/bank grid, and selecting all the items visible in the grid at that time, and then clicking the match button, an error occurred. This has been corrected

Revision: 1016 - 1019
--------------------
Greyscale icons when functionality is unavailable
- User Security Changes/Enhancements

Revision: 1015
--------------------
Implement User configurable rights (Domain Settings)
- User Security Changes/Enhancements

Revision: 1014
--------------------
User Groups cosmetic changes
- User Security Changes/Enhancements

Revision: 1013
--------------------
Implement User Configurable rights (Cashbook Batches Screen)
- User Security Changes/Enhancements

Revision: 1012
--------------------
Implement User configurable rights (Domain Settings)
- User Security Changes/Enhancements

Revision: 1011
--------------------
Accounting Period bug
- User Security Changes/Enhancements
- Arose as part of the new User Security Implementation – fixed

Revision: 1009
--------------------
Implement User configurable rights (Daily Process Wizard)
- User Security Changes/Enhancements

Revision: 1008
--------------------
User Group Maintenance (Insufficient Rights)
- User Security Changes/Enhancements

Revision: 1007
--------------------
Implement User configurable rights (Daily Process Wizard)
- User Security Changes/Enhancements

Revision: 1006
--------------------
Manual Recon Load Tag access right bug
- User Security Changes/Enhancements

Revision: 1005
--------------------
Implement User Configurable rights (Auto Reconcilliation Screen)
- User Security Changes/Enhancements

Revision: 1004
--------------------
Implement User Configurable rights (Auto Reconcilliation Screen)
- User Security Changes/Enhancements

Revision: 1003
--------------------
Implement User configurable rights (Tag Types)
- User Security Changes/Enhancements

Revision: 1002
--------------------
Implement User configurable rights (Cashbook Transaction Types)
- User Security Changes/Enhancements

Revision: 1001
--------------------
Implement User configurable rights (Domains)
- User Security Changes/Enhancements

Revision: 999
--------------------
Implement User configurable rights (Batch Types)
- User Security Changes/Enhancements

Revision: 998
--------------------
Implement User configurable rights (Domains)
- User Security Changes/Enhancements

Revision: 997
--------------------
Implement User Configurable rights (Transfer Cashbook Transaction Screen)
- User Security Changes/Enhancements

Revision: 996
--------------------
Implement User configurable rights (Domains)
- User Security Changes/Enhancements

Revision: 995
--------------------
Implement User configurable rights (Domains)
- User Security Changes/Enhancements

Revision: 994
--------------------
Implement User Configurable rights (Cashbook Allocations Screen)
- User Security Changes/Enhancements

Revision: 993
--------------------
Implement User Configurable rights (Cashbook Allocations Screen)
- User Security Changes/Enhancements

Revision: 992
--------------------
Implement User configurable rights (General Ledger Accounts)
- User Security Changes/Enhancements

Revision: 991
--------------------
Implement User Configurable rights (Manual Reconcilliation Screen)
- User Security Changes/Enhancements

Revision: 990
--------------------
Implement User configurable rights (Vat Rates)
- User Security Changes/Enhancements

Revision: 989
--------------------
Implement User configurable rights (Bank Import Enrichment)
- User Security Changes/Enhancements

Revision: 988
--------------------
Implement User configurable rights (Vat Rate Map, Cashbook Transaction Type Map, GL Account Map)
- User Security Changes/Enhancements

Revision: 986
--------------------
Implement User configurable rights (Accounts)
- User Security Changes/Enhancements

Revision: 985
--------------------
Implement User configurable rights (Cashbook Import Definitions)
- User Security Changes/Enhancements

Revision: 984
--------------------
Account Map Maintenance (Insufficient Rights)
- User Security Changes/Enhancements

Revision: 983
--------------------
Implement User Configurable rights (Create Transactions Using Journal Rules)
- User Security Changes/Enhancements

Revision: 982
--------------------
Implement User Configurable rights (Bank Batches Screen)
- User Security Changes/Enhancements

Revision: 981
--------------------
Implement User configurable rights (Recon Rules)
- User Security Changes/Enhancements

Revision: 980
--------------------
Write Helper function to Create a User without certain rights
- User Security Changes/Enhancements

Revision: 979
--------------------
Implement User Configurable rights (Import Bank Transaction Screen, Create Transactions Using Journal Rules, Import Cashbook Transaction Screen, Auto Reconcilliation Screen)
- User Security Changes/Enhancements

Revision: 975
--------------------
Implement User Configurable rights (Cashbook Batches Screen)
- User Security Changes/Enhancements

Revision: 974
--------------------
Implement User configurable rights (Journal Rules)
- User Security Changes/Enhancements

Revision: 973
--------------------
Implement User Configurable rights (Bank Transaction Screen, Adjust Opening Balance, Accounting Periods); Sort Functionality bug;
- User Security Changes/Enhancements
- On the Manual Recon screen, sort orders in the cashbook/bank views can be manipulated by clicking on the columns in the respective grids on the Manual Recon screen.

Revision: 969
--------------------
Implement User configurable rights (Current Accounting Periods)
- User Security Changes/Enhancements

Revision: 968
--------------------
Implement User Configurable rights (Cashbook Transaction Screen)
- User Security Changes/Enhancements

Revision: 967
--------------------
Implement User Configurable rights (Tags)
- User Security Changes/Enhancements

Revision: 966
--------------------
Implement User Configurable rights (Bank Transaction Screen); Rights names and other maintenance; Sort Order of Menu Item Rights on the User Groups page;
- User Security Changes/Enhancements

Revision: 964
--------------------
Implement User Configurable rights (Bank Transaction Screen)
- User Security Changes/Enhancements

Revision: 963
--------------------
Implement User Configurable rights (Bank Transaction Screen)
- User Security Changes/Enhancements

Revision: 962
--------------------
Implement User Configurable rights (Bank Transaction Screen)
- User Security Changes/Enhancements

Revision: 958
--------------------
Manual Recon Screen: Export to Excel bug on
- Sort order of output was incorrect when limiting the number of records exported – this bug was introduced with the Export to Excel settings added to the account level – fixed the bug.

Revision: 953
--------------------
Encrypt User passwords in the database
- User Security Changes

Revision: 952
--------------------
Implement User configurable rights (Users)
- User Security Changes

Revision: 951
--------------------
Export to Excel: change format to .csv
- Performance gains writing to .csv versus to .xls

Revision: 950
--------------------
Export to Excel: change format to .csv
- Performance gains writing to .csv versus to .xls

Revision: 943
--------------------
Implement User configurable rights (Users)
- User Security Changes

Revision: 941
--------------------
Having Filter with Group By Functionality

Revision: 940
--------------------
Export to Excel
- Setting on Account level to turn export to excel ON/OFF
- Setting on Account level to limit the total number of transactions exported when exporting to excel.
- Export to Excel loads new browser (User can see the progress, and the user can continue with Bank Recon separately)

Revision: 939
--------------------
Implement User configurable rights (Users)
- User Security Changes

Revision: 937
--------------------
Access to Daily Process menu items
- Domain Wizard not available if a domain is not selected
Current Account Periods to include CloseDate (DateTimeStamp) and User

Revision: 935
--------------------
User Maintenace Filtering based on Groups
Domain Group Administrator Functionality
- User Security Changes

Revision: 933
--------------------
User Maintenace Filtering based on Groups
- User Security Change

Revision: 932
--------------------
User Maintenace Filtering based on Groups
- User Security Changes
Domain Group Administrator Functionality
Implement User Configurable rights (Bank Transaction Screen)
- User Security Changes

Revision: 931
--------------------
Tag Report and Other Report Error(s)
- Reload .rdl files to test (save previous ones if you want to revert back to the previous reports)
- Work done on dependant parameters

Revision: 928
--------------------
User Maintenace Filtering based on Groups
Domain Group Administrator Functionality
New Menu item rights
Implement User Configurable rights (Bank Transaction Screen)
- User Security Changes

Revision: 927
--------------------
Domain Group Administrator
Existing Roles Implementation: change SiteAdmin checks to Admin checks
Create Domain Group enhancement
Domain Group Administrator Functionality
- User Security Changes

Revision: 926
--------------------
Having Filter With Group By Functionality

Revision: 925
--------------------
LastKey column missing from Cashbook Import screen
- bug fix

Revision: 922
--------------------
Daily Process Wizard Enhancements - Availability of Menu Items
- Domain Wizard not available if a domain is not selected

Revision: 921
--------------------
Daily Process Wizard Enhancements
Refactor tests have common data in helper classes

Revision: 920
--------------------
When posting a bank batch check the accounting period date not the id
and update Current Reconciliation Report
- bug fix

Revision: 917
--------------------
Domain Group Administrator
- User Security Changes

Revision: 916
--------------------
SPIKE: Reporting Services Performance Issue(s)

Revision: 915
--------------------
Having Filter With Group By Functionality

Revision: 914
--------------------
Correct Navigate to Dashboard screen directly after Finish on the wizard
- Asynchronous execution (the user is navigated to the results screen, while the process still runs in the background)
- The user can refresh the status of the screen by clicking the refresh button.

Revision: 910, 912
--------------------
Site Admin RIGHTS
- User Security Changes

Revision: 908
--------------------
Correct Item order in the Daily Process Dashboard (Imports, Auto Recon, Auto Journal)
Rework Daily Process Wizard to correct execution sequence
Rework Daily Process Wizard to persist checkboxes between screens
Correct Auto Recon Rule page to show only Active Recon Rules - Refactor Run method

Revision: 907
--------------------
Having Filter With Group By Functionality
Implement the having filter functionality in manual recon
Change the setting of the group by defaults so that they are handled by the DataGridFilter itself

Revision: 905
--------------------
Sort Bank data when clicking on the column heading
Sort Cashbook/Bank data when clicking on the column heading
- Sort in view section for Cashbook/Bank changes as user clicks on Columns in the grids on Cashbook and Bank Transaction screens.

Revision: 904
--------------------
Daily Process Wizard Page FOUR enhancement
Refactor Run method
- Allow closing journal batches after creation (checkbox)

Revision: 903
--------------------
Sort Cashbook data when clicking on the column heading
- Sort in view section for Cashbook/Bank changes as user clicks on Columns in the grids on Manual Recon.

Revision: 902
--------------------
Correct Auto Recon Rule page to show only Active Recon Rules - Refactor Run method
- bug fix: All recon rules displayed, instead of only the active rules

Revision: 900
--------------------
Implement Account Setting to 'Allow transfer of transactions' for Bulk Transfer
- Enable/disable CashbookTransactions [Transfer to Account] button based on account setting

Revision: 899
--------------------
Correct Auto Recon Rule page to show only Active Recon Rules - Refactor Run method
- bug fix: All recon rules displayed, instead of only the active rules

Revision: 898
--------------------
Assign Pre-Defined Groups to users as per assigned roles
- User Security Changes

Revision: 897
--------------------
Correct Auto Recon Rule page to show only Active Recon Rules - Refactor Run method
- bug fix: All recon rules displayed, instead of only the active rules

Revision: 895
--------------------
Implemented reporting services server control. Modified reports to use lowercase parameters for required parameters.
- bug fix

Revision: 894
--------------------
User Maintenance changes for SiteAdmin User
- User Security Changes

Revision: 892
--------------------
SiteAdmin deletes user
- User Security Changes

Revision: 891
--------------------
Correct Auto Recon Rule page to show only Active Recon Rules - Refactor Run method
- bug fix: All recon rules displayed, instead of only the active rules

Revision: 890
--------------------
User Admin done by an Administrator
- User Security Changes

Revision: 888
--------------------
Correct Auto Recon Rule page to show only Active Recon Rules - Refactor Run method
- bug fix: All recon rules displayed, instead of only the active rules

Revision: 885
--------------------
User Admin done by an Administrator
- User Security Changes

Revision: 883
--------------------
Correct Auto Recon Rule page to show only Active Recon Rules
- bug fix: All recon rules displayed, instead of only the active rules

Revision: 882
--------------------
Assign Multiple User-Defined Groups to a User
- Implementation of User Groups

Revision: 881
--------------------
Switch between modern and classic on creation of recon rule
- button on Recon Rule Maintenance screen

Revision: 880
--------------------
Account setting to create a batch for every single journal entry created
Implement the functionality for when the setting is on

Revision: 878
--------------------
Show error message when wrong format bank import file selected
- User friendly error messages for incorrect bank statement files

Revision: 876
--------------------
Reload Last Used Profile Error
Reload Last Used Profile setting on User ON/OFF
Confirm that the last used profile reloads, or does not reload based on the setting for the user

Revision: 875
--------------------
Recons gets the wrong period
- Error corrected (Gawie)

Revision: 874
--------------------
Decimal Places error in ReconHelper tables
- Amount Field to have 2 decimal places (database error/fix)

Revision: 873
--------------------
Export to excel format errors
Format errors occurred
Only the filtered selection is now exported

Revision: 856
--------------------
Assign Multiple User-Defined Groups to a User
- New User Groups functionality
- NB: This functionality is NOT implemented yet – the screen will be meaningless to you for now.

Revision: 854
--------------------
Make Profiles Backward compatible
- Current Profiles must still exist/work after the profile upgrade (reload last used profile [1] and format settings included in profile [2]) is done

Revision: 852
--------------------
Last Used Profile
Confirm that the last used profile reloads, or does not reload based on the setting for the user

Revision: 851
--------------------
TransactionTransfer of lots of items patched for Stanlib
Menu item to do bulk transfers available under transactions
Button also available on Cashbook Transaction screen
Account setting to allow transaction transfer must be ON for both the FROM and TO accounts

Revision: 844
--------------------
Last Used Profile
Reload Last Used Profile setting on User ON/OFF
Confirm that last profile used reloads, or does not reload

Revision: 829
--------------------
Last Used Profile
Reload Last Used Profile setting on User ON/OFF
Confirm that last profile used reloads, or does not reload

Revision: 825
--------------------
Group Bank Transactions on Manual Recon
- Group By functionality on the view filters section of the screen

Revision: 823
--------------------
Classic Recon Maintenance screen to display helperXML
- Recon Rule Maintenance: Classic View (set using button on the bottom of the screen) did not include helper functionality

Revision: 822
--------------------
Change Run ID column to NOT NULL to fix problem with RunID table creation
Automated build failed
If your install works, this problem was solved – so there will be no additional tests

Revision: 821
--------------------
Fix RunID Column Creation problem on build
Automated build failed
If your install works, this problem was solved Â– so there will be no additional tests

Revision: 820
--------------------
Order Profile list on Manual Recon Screen
- Available list of profiles on the Manual Recon Screen ordered alpahabetically

Revision: 819
--------------------
Results feedback on Auto Reconciliation Screen
- When running auto recon rules, a column is displayed showing the number of matches that were created by a specific rule (this was accidentally removed, but has been put back in)

Revision: 818
--------------------
Adjust Opening Balance for accounting periods
- Set/Reset opening balance for first accounting period – change will filter through all the closed accounting periods, to the opening balance of the open accounting period

Revision: 816
--------------------
User setting to allow/disallow the reloading of a last used profile
Reload Last Used Profile setting on User ON/OFF
Confirm that last profile used reloads, or does not reload

Revision: 815
--------------------
Save View Format Settings in Profile
- There is a button on the manual recon screen, to set view format(s)
- Format settings set for bank/cashbook side on the manual recon screen, will now be saved as part of the profile

Revision: 813
--------------------
Report subdirectory support
Reports can now be placed in subdirectories on the Reporting Services site, and referenced from Bank Recon.
Use Â‘/Â’ as separator in the web.config

Revision: 812
--------------------
Save View Format Settings in Profile
- Format setting set for bank/cashbook side on the manual recon screen, will now be saved as part of the profile

Revision: 811
--------------------
Create Groups to substitute/mirror existing Roles
- New User Groups functionality
- NB: This functionality is NOT implemented yet – the screen will be meaningless to you for now.

Revision: 810
--------------------
Fix SQL Script
Relates to a failed build
If your install works, there is nothing to test in this regard

Revision: 807
--------------------
Add User Groups to menu
- New User Groups functionality
- NB: This functionality is NOT implemented yet Â– the screen will be meaningless to you for now.

Revision: 806
--------------------
Fix menu Heirachy
- Daily Process Menu Items and structure changed

Revision: 805
--------------------
Group Bank Transactions on Manual Recon
- Group By functionality on the view filters section of the screen

Revision: 804
--------------------
Group Bank Transactions on Manual Recon
- Group By functionality on the view filters section of the screen

Revision: 803
--------------------
Group Bank Transactions on Manual Recon
- Group By functionality on the view filters section of the screen

Revision: 799
--------------------
User-Defined Groups Screen
- New User Groups functionality
- Maintain (create/add/edit) user groups
- NB: This functionality is NOT implemented yet – the screen will be meaningless to you for now.

Revision: 798
--------------------
Adjust Opening Balance for accounting periods
- Set/Reset opening balance for first accounting period – change will filter through all the closed accounting periods, to the opening balance of the open accounting period

Revision: 795
--------------------
Group Bank Transactions on Manual Recon

Revision: 793
--------------------
Group Bank Transactions on Manual Recon

Revision: 791
--------------------
Look and Feel Changes - incorporate new icon(s)

Revision: 790
--------------------
Return Classic Recon Rule Maintenance screen

Revision: 781
--------------------
Bulk Transfer Cleanup – CAN’T TEST

Revision: 780
--------------------
Create Daily Process Wizard
Extend Daily Process Wizard [Page 2]
Extend Daily Process Wizard [Page 3]
Extend Daily Process Wizard [Page 4]

Revision: 778
--------------------
Bulk Transfer Cleanup – CAN’T TEST

Revision: 776
--------------------
Bulk Transfer Cleanup – CAN’T TEST

Revision: 772
--------------------
Summary of Bulk Transfer Transactions
-Add [View Summary] CheckBox and modify Apply
-Add [Summary] Panel and set visibility

Revision: 765
--------------------
Transfer Groups of Transactions (Functionality) [2]

Revision: 760
--------------------
Transfer Groups of Transactions (Functionality) [2]

Revision: 758
--------------------
Accounting Period Enhancements
Transfer Groups of Transactions (Functionality) [2]

Revision: 757
--------------------
Reports Maintenance - Resolve End Date problem on Current Reconcilition Report

Revision: 754
--------------------
Domain: Daily Process Expansion (menu Items)
Domain: Daily Process (Auto Journal)
Domain Group: Daily Process Expansion (Menu Items)
Domain Group: Daily Process (Auto Journal)
Domain Group: Daily Process (Cashbook Imports)
Domain Group: Daily Process (Bank Statement Imports)
Domain Group: Daily Process (Auto Recon)
Reports Maintenance

Revision: 751, 752
--------------------
Transfer groups of transactions (Create and navigate to the new screen)
-Add [Transfer to Account] button to CashbookTransactionList
-Add [Cashbook View] button and event handler
-Add [Select Account] dropdown - for domain & user - exclude active account
-Add [Cashbook] grid
-Add [Transfer] grid
-Add [Move Down Transfer] [Clear] [Transfer Transaction] buttons
Transfer Groups of Transactions (Functionality) [1]

Revision: 747
--------------------
Accounting Period Enhancements

Revision: 746
--------------------
Accounting Period Enhancements

Revision: 744
--------------------
Accounting Period Enhancements
-Order Setup | CurrentAccounting Periods by AccountPeriod table StartDate column
-[Close Current Period] button click event handler - calculate current closing / next opening balance

Revision: 743
--------------------
UnreconciledItemSummary report - show all
Daily GL Report
Revision: 739
--------------------
Load last manual recon profile used

Revision: 738
--------------------
Handle large strings in description and reference fields
Hover Text/Tool Tip Text on Manual Recon screen
Extend Focus on 'Apply and Hide' button functionality

Revision: 736
--------------------
-Add [View Format] button to ManualRecon [Bank View | Save Profile]
-Add [View Format] section to ManualRecon [Cashbook / Bank View | Grid]
-Add [Apply] [Hide] [Apply & Hide] buttons and event handlers to [View Format] section
Hover Text/Tool Tip Text on Manual Recon screen

Revision: 730
--------------------
Select Profile from a dropdown on the Manual Recon screen

Revision: 729
--------------------
Import Multiple Bank Statements for a single account
Import multiple bank statements for multiple accounts
Tag report
General Ledger Report
Consistent formatting for reports

Revision: 725
--------------------
Include Reports in Reports directory when installing BR

Revision: 722
--------------------
Apply and Hide button must have focus while specifying view options
-Apply & Hide focus - Transactions| CashbookTransactions / ViewCashbookAllocations / BankTransactions
-Apply & Hide focus - Reconciliation | Manual reconciliation - cashbook & bank view

Revision: 719
--------------------
Auto recon using helper tables

Revision: 715
--------------------
Balancing journal cancels view settings

Revision: 713
--------------------
Recon rule: User friendly rule description

Revision: 712
--------------------
Recon rule: User friendly rule description

Revision: 710
--------------------
Hide Tags page cancel button

Revision: 709
--------------------
Load another user's tag

Revision: 708
--------------------
Tags must be visible to all users
-Add 'User' column to TagList
-Add 'Show tags for all users' checkbox and event handler to TagList
-Ensure that there are no delete buttons for other users' tags

Revision: 696
--------------------
Manual Recon: Select All in Cashbook and Bank grids

Revision: 696
--------------------
Manual Recon: Select All in Cashbook and Bank grids

Revision: 695
--------------------
Setting to allow transactions to be tagged only once and Apply and Hide button

Revision: 693
--------------------
Fix build

Revision: 689
--------------------
Setting to force use of a tag type

Revision: 683
--------------------
Bug on Create Balancing Entry, and CANCEL allocation and Delete a previously reconciled cashbook entry

Revision: 678
--------------------
Create Helper Recon Test Case
Extend Helper Recon Test Case (include Recon Helper tables)

Revision: 677
--------------------
Recon rule Page enhancement (GetKeys for Recon Helper Records)

Revision: 673
--------------------
Timeout bug

Revision: 653
--------------------
Recon Rule Page Layout changes
Additional Recon Rules screen changes

Revision: 644
--------------------
Users with domain groups

Revision: 622 - 631
--------------------
Test msi when building

Revision: 608, 609
--------------------
Upgrade database during install

Revision: 604
--------------------
Add Domain Group to Domains

Revision: 595 - 598
--------------------
Domain Groups

Revision: 593
--------------------
Enable/disable transfer of transactions

Revision: 589, 591
--------------------
Add tag type to tag

Revision: 587
--------------------
Tag Types Setup

Revision: 585
--------------------
Cashbook transaction type debit/credit

Revision: 583
--------------------
Manual Recon: Enable/disable create balancing transaction

Revision: 582
--------------------
Key field name must not be case sensitive

Revision: 581
--------------------
Hide GLAccount for manual user

Revision: 579
--------------------
Enable/disable manual cashbook and bank entries

Revision: 578
--------------------
Add accounts settings page AND Enable/disable ability to transfer transactions

Revision: 576
--------------------
CATS statement import

Revision: 567 - 573
--------------------
Import cashbook data based on a numeric key

Revision: 567
--------------------
Change import cashbook data screens

Revision: 563, 565
--------------------
Tag count filter

Revision: 562
--------------------
Show that transactions are tagged in transactions screen

Revision: 561
--------------------
Show that transactions are tagged in the manual recon screen

Revision: 560
--------------------
Fixed cashbook allocation details length error when adding large detail fields.

Revision: 559
--------------------
GL Accounts dropdown to only show active accounts

Revision: 558
--------------------
Check that the Amount field is in the left and right datasets when testing the reconrule

Revision: 557
--------------------
Bug - Load Tag fails

Revision: 556
--------------------
Cashbook transaction details now trimmed

Revision: 553 - 555
--------------------
Apply patterns to populate reference fields

Revision: 551
--------------------
Fixed Current Reconciliation Report

Revision: 550
--------------------
Bug: Transactions are not reconciled because they are not in the same account

Revision: 549
--------------------
CurrentReconciliationReport is not returning correct unreconciled %

Revision: 548
--------------------
Add patterns to populate reference fields

Revision: 546
--------------------
Transfers - refactor transfers

Revision: 543
--------------------
Updated master to point to CPT-Domain

Revision: 542
--------------------
Transfers: Refactor transfers

Revision: 529
--------------------
Bug: Allocations not deleted when deleting a batch