tag:blogger.com,1999:blog-26416085212165693652024-02-02T10:00:08.532+02:00BankReconBank account reconciliation software by <a href="http://www.twenty57.com">Twenty57</a>Anonymoushttp://www.blogger.com/profile/15628476634920958723noreply@blogger.comBlogger60125tag:blogger.com,1999:blog-2641608521216569365.post-75103233068117093182019-08-26T11:50:00.000+02:002019-08-26T11:50:08.237+02:00Bank Recon v4.16.1176.3655 is availableVersion 4.16.1176.3655 (26 August 2019)<br />
-------------------------------------<br />
Features<br />
- ZEN5029 - Dashboard - added additional informationKeeganhttp://www.blogger.com/profile/01727959238226948644noreply@blogger.com1tag:blogger.com,1999:blog-2641608521216569365.post-20394668177395137982019-05-22T08:25:00.003+02:002019-05-22T08:25:37.167+02:00Bank Recon v4.16.1157.3612 is availableVersion 4.16.1157.3612 (22 May 2019)<br />
-------------------------------------<br />
Features<br />
- Added DateTime data type for Cashbook and Bank Import key values<br />
<br />
Support<br />
- ZEN4738 - Corrected spelling of Cashbook in process log (Running process with no cashbook import)Keeganhttp://www.blogger.com/profile/01727959238226948644noreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-55613829001614107832019-04-29T13:48:00.003+02:002019-04-29T13:48:49.734+02:00Bank Recon 4.16.1155.3608 is now availableVersion 4.16.1155.3608 (29 April 2019)<br />
-------------------------------------<br />
Features<br />
- GL Allocation splits - updated to apply Details field as per Journal Rule config<br />
- Added a custom timeout configuration for Closing Cashbook Batch and Bank Batch ("Microsoft.ApplicationBlocks.Data.CommandTimeout")<br />
<br />
Support<br />
- Fixed issue where service users could not be saved due to blank password message when using windows authentication<br />
- Fixed issue with administrator checkbox mapping to DB on Users page<br />
- Fixed incorrect Manual Transactions count on User Reconciliation Activity Recon report<br />
- Fixed Process Definition issue - Scheduling Intervals grayed out on page load for Interval configurations<br />
- Added no lock conditions to some read queries<br />
- Optimized query joins (Cashbook Load) - Manual Recon, Suggestions, Cashbook Batch, Cashbook Transaction Allocations<br />
- 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<br />
<br />
Notes<br />
- 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.<br />
<br />Keeganhttp://www.blogger.com/profile/01727959238226948644noreply@blogger.com1tag:blogger.com,1999:blog-2641608521216569365.post-29617865116723592412019-03-07T10:45:00.002+02:002019-03-07T10:45:25.271+02:00Bank Recon 4.16.1144.3584 is availableVersion 4.16.1144.3584 (7 March 2019)<br />
-------------------------------------<br />
Features<br />
- GL Allocation splits - removed rule to enforce unique account numbers<br />
<br />
Support<br />
- GL Accounts - added message to prevent user from disabling GL account if linked to an active journal rule<br />
- Journal rules - updated config to not show accounts marked as inactiveKeeganhttp://www.blogger.com/profile/01727959238226948644noreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-87495342759883805332019-02-21T08:27:00.003+02:002019-02-21T08:27:25.409+02:00Bank Recon 4.16.1141.3578 is availableVersion 4.16.1141.3578 (21 February 2019)<br />
-------------------------------------<br />
<br />
Support<br />
- Added audit entry when cashbook transactions are deleted from the system<br />
- Fixed bug on Current Reconciliation with Tag Type Summary Report and updated percentage fields to 2 decimal places<br />
<div>
<br /></div>
Keeganhttp://www.blogger.com/profile/01727959238226948644noreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-50258533399787108842019-02-08T08:47:00.001+02:002019-02-08T08:47:35.082+02:00Bank Recon 4.16.1137.3570 is availableVersion 4.16.1137.3570 (8 February 2019)<br />
-------------------------------------<br />
Features<br />
- Added Bank Statement upload setting per Domain<br />
<br />
Support<br />
- Fixed issue with Easy Rules where the Edit button would not work on the Other Match section<br />
- Updated Process Definitions to show warning instead of error if there is an inactive Journal Rule assigned to the process definition<br />
- Daily Process messages have been updated to provide more info<br />
<br />
Bank Recon has been updated to support a bank statement upload folder per Domain or per Domain Group. From a configuration perspective, a folder specified at the Domain level will override the Domain Group default, and where no Domain level folder is specified, the system will use the Domain Group default directory.<br />
<br />
The Daily Process configuration UI has been updated to indicate the default directory from the respective Domain/Domain Group config and the user will now be presented with the option to select either the default option or a custom upload directory.Keeganhttp://www.blogger.com/profile/01727959238226948644noreply@blogger.com2tag:blogger.com,1999:blog-2641608521216569365.post-36845281784893906932018-11-12T14:39:00.001+02:002018-11-12T14:46:32.069+02:00Bank Recon 4.16.1125.3545 is available<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #263238; font-family: "trebuchet ms" , sans-serif;"><b><u>Version 4.16.1125.3545 (12 November 2018)</u></b></span><br />
<span style="color: #263238; font-family: "trebuchet ms" , sans-serif;"> - Improvements: Tags Screen</span><br />
<span style="color: #263238; font-family: "trebuchet ms" , sans-serif;"> o Error messages improved to be more meaningful and user friendly. and </span><br />
<span style="color: #263238; font-family: "trebuchet ms" , sans-serif;"> - Fixed: Tag Screen</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><span style="color: #263238; font-family: "trebuchet ms" , sans-serif;"><span style="color: #263238;"></span></span></span><br />
<span style="color: #263238; font-family: "trebuchet ms" , sans-serif;"> o 'Save and Send Later' bug resolved.</span><br />
<br /></div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-22133089034240811992018-11-06T10:54:00.000+02:002018-11-06T10:54:02.952+02:00Bank Recon 4.16.1123.3540 is available<div dir="ltr" style="text-align: left;" trbidi="on">
<u style="font-family: "trebuchet ms", sans-serif;"><b style="color: #263238;">Version </b><span style="color: #263238;"><b>4.16.1123.3540</b></span><b style="color: #263238;"> (6 November 2018)</b></u><br />
<div>
<span style="color: #263238;"><span style="font-family: "trebuchet ms" , sans-serif;"><b>Improvements and Fixes</b></span></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><span style="color: #263238;"> - Tags Screen</span></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><span style="color: #263238;"><span style="color: black; font-family: "times new roman";"> o </span></span></span><span style="color: #263238; font-family: "trebuchet ms" , sans-serif;">Emails contents have been made consistent, and now include a link to navigate the user directly to the tag screen.</span><br />
<span style="color: #263238; font-family: "trebuchet ms" , sans-serif;"><span style="font-family: "trebuchet ms" , sans-serif;"><span style="color: #263238;"><span style="color: black; font-family: "times new roman";"> o </span></span></span></span><span style="color: #263238; font-family: "trebuchet ms", sans-serif;">Additional validations have been included for the email address field.</span></div>
</div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-35237161533340243212018-09-17T14:42:00.001+02:002018-11-06T10:30:01.644+02:00Bank Recon 4.16.1120.3533 is available<div dir="ltr" style="text-align: left;" trbidi="on">
<u style="font-family: "trebuchet ms", sans-serif;"><b style="color: #263238;">Version </b><span style="color: #263238;"><b>4.16.1120.3533</b></span><b style="color: #263238;"> (17 September 2018)</b></u><br />
<div>
<span style="color: #263238;"><span style="font-family: "trebuchet ms" , sans-serif;"><b>Improvements</b></span></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><span style="color: #263238;"> - General Ledger Accounts search functionality and usability improved.</span></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><span style="color: #263238;">Installer now capable of putting windows authentication into config files if so selected on installation</span></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><span style="color: #263238;"><span style="color: black; font-family: "times new roman";"> o </span></span></span><span style="color: #263238; font-family: "trebuchet ms" , sans-serif;">This requires the underlying user and rights to be provisioned on the OS to work properly.</span><br />
<span style="color: #263238;"><span style="font-family: "trebuchet ms" , sans-serif;"><b>Fixed</b></span></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><span style="color: #263238;"> - Standard Reports displayed incorrect % values when exported to Excel.</span></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><span style="color: #263238;"> - AD Authentication using users without email address no longer cause an error on the New Tag screen.</span></span><br />
<span style="color: #263238; font-family: "trebuchet ms" , sans-serif;"><br /></span>
<span style="font-family: "trebuchet ms" , sans-serif;"><span style="color: #263238;"><br /></span></span></div>
</div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-84085867808263591902018-06-28T11:23:00.000+02:002018-06-28T11:24:06.766+02:00Bank Recon 4.16.1117.3525 is available<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: "trebuchet ms" , sans-serif;"><u><b style="color: #263238;">Version </b><span style="color: #263238;"><b>4.16.1117.3525</b></span><b style="color: #263238;"> (28 June 2018)</b></u></span><br />
<span style="color: #263238;"><span style="font-family: "trebuchet ms" , sans-serif;"><b>Improvements</b></span></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><span style="color: #263238;"> - Changed deprecated database column types (Text, NText, Image) to appropriate supported types (varchar, nvarchar, varbinary)</span><br style="color: #263238;" /><span style="color: #263238;"> - 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.</span></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><span style="color: #263238;"> - 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.</span></span></div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-59635896850388579602017-11-09T14:55:00.001+02:002017-11-09T14:56:01.346+02:00Bank Recon 4.16.1115.3520 is available<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white;"><span style="font-family: "trebuchet ms" , sans-serif;"><span style="font-size: 13.2px;">Bank Recon 4.16.1115.3520 is available for download from the </span></span><a href="https://download.twenty57.com/twenty57/Bankrecon/Download.aspx?product=BankRecon" style="color: #858585; font-family: "trebuchet ms", sans-serif; font-size: 13.2px; text-decoration-line: none;" target="_blank">Twenty57 Partner Portal</a><span style="font-family: "trebuchet ms" , sans-serif;"><span style="font-size: 13.2px;">. Thank you to Shivkant for the development work.</span></span></span><br />
<span style="background-color: white; font-family: "trebuchet ms" , sans-serif; font-size: 13.2px;"><br /></span><span style="background-color: white; font-family: "arial" , "tahoma" , "helvetica" , "freesans" , sans-serif; font-size: 13.2px;"></span><span style="background-color: white; font-family: "trebuchet ms" , sans-serif; font-size: 13.2px;">The following has been included since the previous blog post. All these versions are available for download.</span><br />
<br />
<div class="MsoNoSpacing" style="background-color: white;">
<div>
<b><u><span style="font-family: "trebuchet ms" , sans-serif;"><span style="font-size: 13.2px;">Version 4.16.1115.3520 (9 November 2017)</span></span></u></b></div>
<div style="font-family: "trebuchet ms", sans-serif; font-size: 13.2px;">
<br /></div>
<div style="font-family: "trebuchet ms", sans-serif; font-size: 13.2px;">
<b>Feature</b></div>
<div style="font-family: "trebuchet ms", sans-serif; font-size: 13.2px;">
<div class="MsoNormal">
<span style="font-family: "trebuchet ms" , sans-serif; font-size: 10pt; line-height: 107%;"> - 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.</span><o:p></o:p></div>
</div>
</div>
</div>
Anonymousnoreply@blogger.com1tag:blogger.com,1999:blog-2641608521216569365.post-1921825115173033142017-07-19T13:19:00.003+02:002017-07-19T13:21:51.691+02:00Bank Recon 4.16.1113.3515 is available<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; font-family: arial, tahoma, helvetica, freesans, sans-serif; font-size: 22px; font-stretch: normal; font-weight: normal; line-height: normal; margin: 0.75em 0px 0px; position: relative; text-align: left;">
<span style="font-family: "trebuchet ms" , sans-serif; font-size: 13.2px;">Bank Recon 4.16.1113.3515 is available for download from the </span><a href="https://download.twenty57.com/twenty57/Bankrecon/Download.aspx?product=BankRecon" style="color: #858585; font-family: "trebuchet ms", sans-serif; font-size: 13.2px;" target="_blank">Twenty57 Partner Portal</a><span style="font-family: "trebuchet ms" , sans-serif; font-size: 13.2px;">. </span></div>
<div class="post-body entry-content" id="post-body-522927935442904101" style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px; line-height: 1.4; position: relative; width: 610px;">
<div dir="ltr" trbidi="on">
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span><span style="font-family: "trebuchet ms" , sans-serif;">The following has been included in this version.</span><br />
<div class="MsoNoSpacing">
<br />
<div>
<b style="font-family: "trebuchet ms", sans-serif;"><u>Version 4.16.1113.3515 (19 July 2017)</u></b></div>
<span style="font-family: "trebuchet ms" , sans-serif;"><br /><b>Fixed</b></span></div>
<div class="MsoNoSpacing">
<div class="MsoNoSpacing">
- Bug on starting the service - The following functionality was failing on some service starts</div>
<div class="MsoNoSpacing">
<span style="font-family: "trebuchet ms" , sans-serif; font-size: 13.2px;"> o</span><span style="font-family: "trebuchet ms" , sans-serif; font-size: 13.2px;"> </span>process items that have been killed (in the busy state) will be updated to Error, and </div>
<div class="MsoNoSpacing">
<span style="font-family: "trebuchet ms" , sans-serif; font-size: 13.2px;"> o</span><span style="font-family: "trebuchet ms" , sans-serif; font-size: 13.2px;"> </span>items in the Pending State will be re-initiated.</div>
</div>
</div>
</div>
</div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-5229279354429041012017-06-21T06:57:00.000+02:002017-06-21T06:57:24.751+02:00Bank Recon 4.16.1111.3511 is available<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: "trebuchet ms" , sans-serif;">Bank Recon 4.16.1111.3511 is available for download from the <a href="https://download.twenty57.com/twenty57/Bankrecon/Download.aspx?product=BankRecon" target="_blank">Twenty57 Partner Portal</a>. Thank you to Russell and Shivkant.</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span><span style="font-family: "trebuchet ms" , sans-serif;">The following has been included in this version.</span><br />
<br />
<div class="MsoNoSpacing">
<span style="font-family: "trebuchet ms" , sans-serif;"></span><br />
<div>
<b style="font-family: "trebuchet ms", sans-serif;"><u>Version 4.16.1111.3511 (21 June 2017)</u></b></div>
<span style="font-family: "trebuchet ms" , sans-serif;"><br />
<b>Performance</b><br />
- Journal Rule Speed Improvement (Underlying query simplification and performance improvement)<br />
<br />
<b>Fixed</b><br />
- Service Recovery Improvements. Upon starting the service, <br />
o process items that have been killed (in the busy state) will be updated to Error, and<br />
o items in the Pending State will be re-initiated.<br />
Previously these status updates would not occur automatically and pending processes would not automatically be re-initiated.</span></div>
</div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-11095319846109812192017-06-07T09:24:00.000+02:002017-06-07T09:24:53.073+02:00Bank Recon 4.16 is available<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: "trebuchet ms" , sans-serif;">Bank Recon 4.16.1110.3508 is available for download from the <a href="https://download.twenty57.com/twenty57/Bankrecon/Download.aspx?product=BankRecon" target="_blank">Twenty57 Partner Portal</a>. Thank you to Shivkant for the development work.</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span>
<span style="font-family: "trebuchet ms" , sans-serif;">The following has been included since the previous blog post. All these versions are available for download.</span><br />
<br />
<div class="MsoNoSpacing">
<span style="font-family: "trebuchet ms" , sans-serif;"><div>
<b><u>Version 4.16.1110.3508 (7 June 2017)</u></b></div>
<div>
<br /></div>
<div>
<b>Feature</b></div>
<div>
- Suggest Functionality now includes a configuration option to disable the MOD (10) rounding exclusion for exact matches.</div>
<div>
<br /></div>
<div>
<b><u>Version 4.16.1109.3506 (9 April 2017)</u></b></div>
<div>
<br /></div>
<div>
<b>Fixes</b></div>
<div>
- Last Key Value can now be larger than 2^32 - 1</div>
<div>
- Using OR conditions in journal rules no longer allows selecting transactions from accounts other than the currently selected account</div>
<div>
<br /></div>
<div>
<b><u>Version 4.15.1108.3502 (24 February 2017)</u></b></div>
<div>
<br /></div>
<div>
<b>Features</b></div>
<div>
- When manually creating a bank batch, there is an option to use the last statement type of the account</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o When selected, the specific statement validations for the statement number will be enforced</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o When unselected, the standard validations will apply (Opening/Closing balance)</div>
<div>
- Tag transaction removal</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o Cashbook/Bank transactions can be removed from Tags by any user with the "Save/Edit" tags right for the related domain</div>
<div>
- SWIFT MT940: The SWIFT MT940 parser has been extended to parse the new 2016 Account identification tag (:25P:)</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o Existing documents are parsed as per usual</div>
<div>
<br /></div>
<div>
<b>Fixes</b></div>
<div>
- Object reference error on the Recon Viewer screen has been resolved </div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o The error would occur when a user without the ReconciliationDelete right navigated to the ReconViewer screen by selecting</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> a ReconID link from a cashbook / bank transaction</div>
<div>
- Object reference error occurring when deleting a bank batch no longer occurs and the audit process log is created successfully</div>
<div>
<br /></div>
<div>
<b><u>Version 4.14.1101.3480 (19 January 2017)</u></b></div>
<div>
<br /></div>
<div>
<b>Feature</b></div>
<div>
- A new process type has been added, 'Bank Batch Delete'</div>
<div>
o Manually deleting a bank batch creates a process log with a message showing the original batch details</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o This allows the event to be audited</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o Even though this event is audited, it should only be used for deleting manually created bank batches</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> 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</div>
<div>
<br /></div>
<div>
<b>Fixes</b></div>
<div>
- Manual Recon totals bar displays correctly when using comma as decimal separator</div>
<div>
- Configurable columns on the Domain Group/Domain/Account selection screen are now correctly aligned and consistent with the standard columns</div>
<div>
<br /></div>
<div>
<b><u>Version 4.13.1098.3469 (15 December 2016)</u></b></div>
<div>
<br /></div>
<div>
<b>Features</b></div>
<div>
- Bank enrichment amount condition</div>
<div>
o When applying Bank enrichments, an optional condition can be specified for the amount which will determine whether to apply the enrichment</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>o Supported conditions include None, Amount zero, Amount negative and Amount positive</div>
<div>
- Process Log</div>
<div>
o The Process Log can now be filtered by Process Type, StartTime, EndTime and/or Process Status</div>
<div>
<br /></div>
<div>
<b>Improvements</b></div>
<div>
- Import definition test function</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o When executing import definitions, numeric parameters used with a greater than condition are not incremented before applying the query</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o Date parameters used with the equals condition or the greater than or equal to condition are incremented before applying the query</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> 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</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> and the data which would be returned on the next run of the import definition</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o The actual value of the @keyValue parameter is now displayed when using the "Test" function</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o The results returned by the "Test" function will match the results returned by the import definition on the next run</div>
<div>
- Bank batches</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o Statement Date has been added to the Bank batches grid</div>
<div>
<br /></div>
<div>
<b><u>Version 4.12.1093.3456 (05 December 2016)</u></b></div>
<div>
<br /></div>
<div>
<b>Fixes</b></div>
<div>
- Cashbook Import error: "invalid column length from the bcp client for colid..."</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o Truncating the Cashbook transactions details (300 -> 100) for insertion in the Allocation table has been fixed</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o When a cashbook import returns data larger than the cashbook table can accommodate, the value is truncated to the maximum length</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> prior to inserting (200 characters for reference fields and 300 characters for the description)</div>
<div>
- Cashbook imports ending in a warning now appear on the Rollback cashbook screen</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o The process cannot end in a warning unless transactions were committed</div>
<div>
<div>
- Bank Statements list</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o There is a new menu item available to Site Administrators</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o Setup > Site Configuration > Bank Statements</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o Individual Bank statements can be selected/deselected for use by the application</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o The goal for the future is to allow installation of plugins without requiring a new version of the application</div>
<div>
- Swift Parser</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o There is a new plugin 'Swift'</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o This plugin will parse MT940 and MT950 files and ignore other swift messages (900,910,...) without failing</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o The main benefit is that the plugin will parse a file containing a mixture of message types</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o It is off by default</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o To activate, navigate to the Bank Statements list, deactivate both of 'Twenty57.BankRecon.BankStatements.SWIFTMT940.dll' and</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> 'Twenty57.BankRecon.BankStatements.SWIFTMT950.dll'. Then activate 'Twenty57.BankRecon.BankStatements.SWIFT.dll'</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o Without deactivating the SWIFTMT940 and SWIFTMT950 plugins, they will always detect and attempt to parse the Swift file first</div>
<div>
- AutoRecon transfer consolidation</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o There are 2 new configuration options on the ReconRule editor:</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o 'Consolidate Transfers':</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>- When selected and the rule is run across accounts, transactions will be consolidated and reconciled per account prior to transfer</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>- This may avoid the creation of many transactions, since only 2 transactions will be created for the transfer</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> per account instead of 2 transactions created for each transferred transaction</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>- The default setting is off</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o 'Transfer Account' = [Use first Bank Account] or [Use Account with most transactions]</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>- When reconciling across accounts, Bank Recon must choose an account to transfer transactions to</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>- A new option is available to limit the number of transferred transactions by selecting the transfer account as the account</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> with most transactions meaning that fewer transactions need to be transferred</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>- The default is [User first Bank Account]</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o The major gain in reducing the number of transactions created when transferring across accounts is by selecting the 'Consolidate' option</div>
</div>
<div>
<br /></div>
<div>
<b>Improvements</b></div>
<div>
- MSDTC is no longer required on the TagEditor screen</div>
<div>
- Unreconciled table maintenance</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o The maintenance of the unreconciled tables (CashbookTransactionUnreconciled and BankTransactionUnreconciled) can now be switched off</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> 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</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> - This will reduce load on the server as well as resolve some concurrency issues associated with updating the tables</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o The unreconciled tables are used by the Suggest process and may be used by the Recon rules themselves</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o To turn off the unreconciled table maintenance, you must have the Suggest process switched off and ensure that none of your Recon rules</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> reference the unreconciled tables directly (since they will then not match anything)</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> - Any recon rules using the unreconciled tables directly can be changed as follows:</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> 1. Any reference to CashbookTransactionUnreconciled should be changed to CashbookTransactionUnreconciledView</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> 2. Any reference to BankTransactionUnreconciled should be changed to BankTransactionUnreconciledView</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> - Then add the following application setting to the process service configuration file:</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> 1. add key="bankrecon.unreconciledtables.active" value="false"</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<b><u>Version 4.11.1088.3433 (26 October 2016)</u></b></div>
<div>
<br /></div>
<div>
<b>Features</b></div>
<div>
<div>
- Flexcube transaction reversals are now parsed and reflected on the BankTransaction as Reference3 = 'Reversal'</div>
<div>
- MT940 / MT950 reversals are imported as BankTransaction.Reference9 = 'Reversal'</div>
<div>
- Individual reconciliations created when reconciling across accounts can be individually unreconciled or the entire batch can be unreconciled</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o These are created when transferring transactions from source accounts to the Recon account</div>
</div>
<div>
<b><br /></b></div>
<div>
<b>Fixes</b></div>
<div>
- "Reconciliation done successfully" message displays immediately after reconciling directly without a balancing entry</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o Previously, the message would only show on returning to the manual reconciliation screen</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o This message still display when returning to the Manual Reconciliation screen after creating a balancing entry</div>
<div>
- Bank transaction - Bulk import bug for bankstatements with no statement number has been resolved</div>
<div>
o When multiple statements are found in the import directory, Bank Recon needs to order the statements to import correctly.</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> It does this by using the associated Statement number / Statement date</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> 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</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> ordering of the selected files as shown on the Bank Transaction import screen (top to bottom).</div>
<div>
- When reconciling across accounts and using Helper data, the ReconID's attached to Helper data rows were incorrectly assigned to the transfer Recons</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> instead of the Recon in the working account</div>
<div>
o This has been resolved and the ReconID assigned to matched helper data will match the BankTransaction account (Recon account)</div>
<div>
<br /></div>
<div>
<b>Improvement</b><span class="Apple-tab-span" style="white-space: pre;"> </span> </div>
<div>
- GL Account names are displayed on the Journal rule list and editor screens in addition to the GL account number</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o <Account Name> - <Account Number></div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> </div>
<div>
<br /></div>
<div>
<b><u>Version 4.10.1086.3422 (28 September 2016)</u></b></div>
<div>
<br /></div>
<div>
<b>Features</b></div>
<div>
<div>
- Auto journal entries can now be consolidated in the same way as with manual entries</div>
<div>
o To use this feature, the Consolidate option should be selected on the Journal rule</div>
<div>
- When testing a classic Recon rule with Helper data, the matched Helper data can be viewed along with the cashbook / bank data</div>
</div>
<div>
<b><br /></b></div>
<div>
<b>Fixes</b></div>
<div>
- Manual Reconciliation balancing entry error (Cashbook Transaction ID 0 does not exist)</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o Bank Recon can fail to create a balancing entry due a number of reasons including:</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> i. the user does not have create cashbook batch / auto journal permissions</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> ii. there are no open batches</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o Previously, the actual error was being swallowed and "Cashbook Transaction ID 0 does not exist" was displayed</div>
<div>
- "One of the Recons does not balance.". A scenario was discovered when a rule returns matches using multiple ReconHelpers, BankRecon was</div>
<div>
not mapping the correct ReconHelpers to the correct match. This meant that importing the missing Helpers from the data set</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> would retrieve helpers from the wrong data set and the result would not balance. This has been resolved</div>
<div>
<br /></div>
<div>
<b>Improvement</b></div>
<div>
- Oracle cashbook imports were failing on first connection and subsequently succeeding due to an as yet unknown cause</div>
<div>
o To mitigate this, the Oracle cashbook import definition supports retrying the connection a configurable number of times</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> using a configurable interval between retries</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> o A cashbook import will show a warning on the process log when the connection needed to be retried and fail if the number</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> of retries exceeds the configured setting</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> </div>
<div>
<br /></div>
<div>
<br /></div>
</span></div>
</div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-29091104361344126382016-08-26T13:12:00.000+02:002016-08-26T13:12:28.261+02:00Bank Recon 4.9 is available<span style="font-family: "trebuchet ms" , sans-serif;">Bank Recon 4.9.1082.3412 is available for download from the <a href="https://www.twenty57.com/twenty57/BankRecon/Download.aspx?product=BankRecon" target="_blank">Twenty57 website</a>. Thank you to Shivkant and Shaun for the development work.</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span>
<br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><b>New Bank Statements</b></span><br />
<span style="font-family: Trebuchet MS, sans-serif;"><b><br /></b></span>
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>- SAP</span><br />
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>- FlexCube</span><br />
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>- Montran</span><br />
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span>
<span style="font-family: Trebuchet MS, sans-serif;">For more information on these formats, contact the Digiata office for assistance.</span><br />
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span>
<span style="font-family: Trebuchet MS, sans-serif;"><b>Performance</b></span><br />
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span>
<span style="font-family: Trebuchet MS, sans-serif;">Unreconcile performance improvements have been made to support unreconciling a larger number of transactions. </span><span style="font-family: "Trebuchet MS", sans-serif;">This will be most noticeable when unreconciling a recon involving many transferred transactions from different source accounts.</span><br />
<span style="font-family: "Trebuchet MS", sans-serif;"><br /></span>
<span style="font-family: "Trebuchet MS", sans-serif;">The account save performance has been improved and will be more noticeable in domains with a large number of GL accounts.</span><br />
<span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Trebuchet MS, sans-serif;"> </span></span><br />
<span style="font-family: Trebuchet MS, sans-serif;">Manual Recon transaction selection performance has been improved. </span><span style="font-family: "Trebuchet MS", sans-serif;">This mainly affected IE 8 users.</span><br />
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span>
<b style="font-family: "Trebuchet MS", sans-serif;">GL Account usability</b><br />
<b style="font-family: "Trebuchet MS", sans-serif;"><br /></b>
<span style="font-family: "Trebuchet MS", sans-serif;">When an account has many linked GL accounts, asides from being difficult to locate GL accounts, the application may become slow or </span><span style="font-family: "Trebuchet MS", sans-serif;">even exceed the limitations of the web server as specified in the web.config file (maxRequestLength).</span><br />
<span style="font-family: "Trebuchet MS", sans-serif;"><br /></span>
<span style="font-family: Trebuchet MS, sans-serif;">The GL Account list includes a search box with autocomplete:</span><br />
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-Gf0nRm9EcBY/V8ADjrLXTJI/AAAAAAAAAVw/NZNP16ZiokUCclOEmv0u7LN3c9iBmNCXACLcB/s1600/gl%2Baccount%2Bsearch.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="227" src="https://4.bp.blogspot.com/-Gf0nRm9EcBY/V8ADjrLXTJI/AAAAAAAAAVw/NZNP16ZiokUCclOEmv0u7LN3c9iBmNCXACLcB/s320/gl%2Baccount%2Bsearch.png" width="320" /></a></div>
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span>
<span style="font-family: Trebuchet MS, sans-serif;">In the case that the number of GL accounts for the domain is larger than the web.config setting </span><span style="font-family: "Trebuchet MS", sans-serif;">"bankrecon.glaccount.dropdownlimit", t</span><span style="font-family: Trebuchet MS, sans-serif;">he Account editor will show an search control from which GL accounts may be added to the list:</span><br />
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/--FejR5bSDXQ/V8AFhbOZ3II/AAAAAAAAAV8/Ky1KHh9vRT4RUntWENAXg_b1ydaUhMutQCLcB/s1600/account%2Beditor%2B-%2Bsearch%2Bgl%2Baccount.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="116" src="https://2.bp.blogspot.com/--FejR5bSDXQ/V8AFhbOZ3II/AAAAAAAAAV8/Ky1KHh9vRT4RUntWENAXg_b1ydaUhMutQCLcB/s400/account%2Beditor%2B-%2Bsearch%2Bgl%2Baccount.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<span style="font-family: "Trebuchet MS", sans-serif;">The selected GL accounts may be associated with the account be unchecking the "ALL" checkbox. In this case, only the GL accounts displayed are are associated with the account.</span><br />
<span style="font-family: "Trebuchet MS", sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-KKQ9Im-8eo4/V8AF0JvwnFI/AAAAAAAAAWA/hDLS7eWlzdYk-R5Udg18R2KokaqUg3uEACEw/s1600/account%2Beditor%2B-%2Bassociate%2Baccounts.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="118" src="https://2.bp.blogspot.com/-KKQ9Im-8eo4/V8AF0JvwnFI/AAAAAAAAAWA/hDLS7eWlzdYk-R5Udg18R2KokaqUg3uEACEw/s640/account%2Beditor%2B-%2Bassociate%2Baccounts.png" width="640" /></a></div>
<span style="font-family: "Trebuchet MS", sans-serif;"><br /></span>
<span style="font-family: Trebuchet MS, sans-serif;">The selected GL accounts may be disassociated with the account by checking the "ALL" checkbox. In this case, all GL accounts are associated with the account except for the selection.</span><br />
<span style="font-family: "Trebuchet MS", sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-O5mMyocj8Cw/V8AGA2NH6kI/AAAAAAAAAWE/5Q2NxWX3xfwXRBb_dZCcAa2ravblkK8uQCLcB/s1600/account%2Beditor%2B-%2Bdissociate%2Bgl%2Baccounts.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="142" src="https://2.bp.blogspot.com/-O5mMyocj8Cw/V8AGA2NH6kI/AAAAAAAAAWE/5Q2NxWX3xfwXRBb_dZCcAa2ravblkK8uQCLcB/s640/account%2Beditor%2B-%2Bdissociate%2Bgl%2Baccounts.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<b style="font-family: "Trebuchet MS", sans-serif;">Fixes</b><span class="Apple-tab-span" style="font-family: "Trebuchet MS", sans-serif; white-space: pre;"> </span><span style="font-family: "Trebuchet MS", sans-serif;"> </span><br />
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span>
<br />
<ul>
<li><span style="font-family: Trebuchet MS, sans-serif;">The MT940 / MT950 parsers now compare statement numbers correctly when importing a batch of statements w</span><span style="font-family: "Trebuchet MS", sans-serif;">ith alternate formats of the Statement number tag (:28C)</span></li>
</ul>
<ul><ul>
<li><span style="font-family: "Trebuchet MS", sans-serif;">Statement number only:</span></li>
</ul>
</ul>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-bZZquMGrzr0/V8AIBS7-S_I/AAAAAAAAAWQ/mUyY4S3jQ0UxYL8XLFYwxIM0oAba4fAiACLcB/s1600/mt940%2B-%2Bstatement%2Bnumber%2Bonly.png" imageanchor="1" style="display: inline !important; margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" src="https://4.bp.blogspot.com/-bZZquMGrzr0/V8AIBS7-S_I/AAAAAAAAAWQ/mUyY4S3jQ0UxYL8XLFYwxIM0oAba4fAiACLcB/s1600/mt940%2B-%2Bstatement%2Bnumber%2Bonly.png" /></a></div>
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span>
<br />
<ul><ul>
<li><span style="font-family: "Trebuchet MS", sans-serif;">Statement number and sequence number:</span></li>
</ul>
</ul>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-d67bUDZQRRs/V8AIBSbohpI/AAAAAAAAAWU/ec5Y0o_YOU44s-6wBzLzGVgS0CGJNtXbACEw/s1600/mt940%2B-%2Bstatement%2Band%2Bsequence%2Bnumber.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://4.bp.blogspot.com/-d67bUDZQRRs/V8AIBSbohpI/AAAAAAAAAWU/ec5Y0o_YOU44s-6wBzLzGVgS0CGJNtXbACEw/s1600/mt940%2B-%2Bstatement%2Band%2Bsequence%2Bnumber.png" /></a></div>
<br />
<br />
<ul>
<li><span style="font-family: "Trebuchet MS", sans-serif;">The IE status bar dependency has been removed. </span><span style="font-family: "Trebuchet MS", sans-serif;">The text previously shown on the status bar is now shown as HTML.</span></li>
</ul>
<br />
<span style="font-family: "Trebuchet MS", sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-Oy7my33BQfY/V8AJbOsVE7I/AAAAAAAAAWg/Qg-NfrVGpoAdGPsZbhstnOXQWIG3HkZoACLcB/s1600/manual%2Brecon%2B-%2Bcontrol%2Btotals.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="313" src="https://1.bp.blogspot.com/-Oy7my33BQfY/V8AJbOsVE7I/AAAAAAAAAWg/Qg-NfrVGpoAdGPsZbhstnOXQWIG3HkZoACLcB/s640/manual%2Brecon%2B-%2Bcontrol%2Btotals.png" width="640" /></a></div>
<br />
<br />
<ul><ul>
<li><span style="font-family: "Trebuchet MS", sans-serif;">This avoids having to allow javascript to update the status bar in IE (as well as display it in the first place).</span></li>
<li><span style="font-family: "Trebuchet MS", sans-serif;">The control totals are now available to Chrome users. (There is no status bar in Chrome)</span></li>
<li><span style="font-family: "Trebuchet MS", sans-serif;">This affects the Manual Recon screen, Cashbook/Bank transaction screens and Transfer Cashbook transactions screen.</span></li>
</ul>
</ul>
<br />
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span> </span><br />
<br />
<ul>
<li><span style="font-family: "Trebuchet MS", sans-serif;">The Manual Recon suggest undo command no longer times out</span></li>
</ul>
<br />
<br />
<ul>
<li><span style="font-family: "Trebuchet MS", sans-serif;">Export to excel bug with control characters</span></li>
<ul>
<li><span style="font-family: "Trebuchet MS", sans-serif;">E</span><span style="font-family: "Trebuchet MS", sans-serif;">xcel files underlying structure is xml and so invalid xml characters are converted to blanks prior to creating the export</span></li>
</ul>
</ul>
<br />
<br />
<ul>
<li><span style="font-family: "Trebuchet MS", sans-serif;">The Cashbook transaction allocation editor "Save & Reconcile" double-click bug has been fixed.</span></li>
<ul>
<li><span style="font-family: "Trebuchet MS", sans-serif;">The button will no longer submit multiple requests when double-clicked (It will disable after the first click and enable after)</span></li>
</ul>
</ul>
<br />
<br />
<ul>
<li><span style="font-family: "Trebuchet MS", sans-serif;">The Report viewer control Oracle parameter bug has been fixed</span></li>
</ul>
<br />
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span>
<span style="font-family: "Trebuchet MS", sans-serif;"><b>Structure changes</b></span><br />
<span style="font-family: "Trebuchet MS", sans-serif;"><br /></span>
<span style="font-family: "Trebuchet MS", sans-serif;">The ReconCancelBankDetailsTransaction table has been removed. </span><span style="font-family: "Trebuchet MS", sans-serif;">This table was previously used for unreconciling a recon linking Bank transactions directly to Helper Bank transactions.</span><br />
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span>
<span style="font-family: Trebuchet MS, sans-serif;">Direct Bank transaction to Helper bank transaction recons were removed in 2014.</span><br />
<div>
<br /></div>
<div>
<br /></div>
<div>
<b style="font-family: "Trebuchet MS", sans-serif;">Roadmap</b></div>
<div>
<b style="font-family: "Trebuchet MS", sans-serif;"><br /></b></div>
<div>
<span style="font-family: "Trebuchet MS", sans-serif;">In the immediate future, we will be looking at introducing the Helper data into the front-end. In particular, the Recon rule test functions and recon viewer will display any matched Helper data for verification purposes. The Manual recon screen will be extended to utilise the Helper data for matching in a non-obtrusive fashion.</span></div>
</div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-77445862518105529612016-07-01T11:48:00.001+02:002016-07-01T11:48:34.028+02:00Bank Recon 4.8 has been updated<span style="font-family: Trebuchet MS, sans-serif;">An issue was found with the Easy Recon rule batch processing mode and the changes have been reverted. We will add batch processing for the Easy rules in an upcoming major version. The updated version (4.8.1068.3360) is available on the <a href="https://www.twenty57.com/twenty57/BankRecon/Download.aspx?product=BankRecon">Twenty57</a> website.</span>Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-63291603652075277212016-06-30T13:48:00.000+02:002016-06-30T13:48:20.223+02:00Bank Recon 4.8 is available<span style="font-family: "trebuchet ms" , sans-serif;">Bank Recon 4.8.1067.3358 is available for download from the <a href="https://www.twenty57.com/twenty57/BankRecon/Download.aspx?product=BankRecon" target="_blank">Twenty57 website</a>. Thank you to Shivkant for the development work.</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span>
<div class="MsoNoSpacing">
<span style="font-family: "Trebuchet MS", sans-serif;"><b>Accounting Periods</b></span></div>
<div class="MsoNoSpacing">
<span style="font-family: "Trebuchet MS", sans-serif;"><b><br /></b></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;">The Accounting Period list screen has been updated to allow multiple consecutive accounting periods to be closed.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-t8rZJsjUFz4/V3UBjOlOyxI/AAAAAAAAATo/fnNCrETUXTM2OF5VGJZLQE71qUG-GmepQCKgB/s1600/p1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="328" src="https://4.bp.blogspot.com/-t8rZJsjUFz4/V3UBjOlOyxI/AAAAAAAAATo/fnNCrETUXTM2OF5VGJZLQE71qUG-GmepQCKgB/s640/p1.png" width="640" /></a></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;">Each period up to and including the selected period will be closed consecutively.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"> </span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><b>Compatibility Headers</b></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;">Compatibility headers have been added for users of Internet explorer who use a default document mode prior to IE9. </span><span style="font-family: "Trebuchet MS", sans-serif;">The header will ensure that pages render using IE9 document mode.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"> </span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><b>GenericCSV parser</b></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;">The Generic CSV parser now supports both of ‘dd/MM/yyyy’ and ‘dd-MM-yyyy’ as date formats. </span><span style="font-family: "Trebuchet MS", sans-serif;">The GenericCSV statement number validation bug has been resolved. The statement number is no longer validated.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"> </span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><b>Unreconciled table concurrency improvements</b></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;">Unreconciled table maintenance concurrency has been improved. The </span><span style="font-family: "Trebuchet MS", sans-serif;">AutoRecon and Cashbook import processes will no longer fail when the unreconciled table maintenance process fails, but the process will end in a warning.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"> </span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><b>Helper Data matching (Bank <-> ReconHelperBankTransaction match)</b></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><b><br /></b></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;">This fix affects Recon rules using Helper data with the the option to create journal entries for missing Cashbook transactions selected. </span><span style="font-family: "Trebuchet MS", sans-serif;">Previously, at least one Cashbook transaction would need to match to a ReconHelperCashbookTransaction for the match to succeed.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;">This is because the underlying ReconHelper set was determined by the Cashbook <-> ReconHelperCashbook match.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;">Now, the ReconHelper set can be determined by the Bank <-> ReconHelperBankTransaction alone and no Cashbook transactions need to match </span><span style="font-family: "Trebuchet MS", sans-serif;">for journal entries to be created using the linked ReconHelperCashbook transactions.</span></div>
<div class="MsoNoSpacing">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-gh3F_Q70k94/V3UDlrf8fAI/AAAAAAAAATs/JP5CLHtXiBIQoWue_u9xA_NqTTDVjei9gCLcB/s1600/p2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="129" src="https://1.bp.blogspot.com/-gh3F_Q70k94/V3UDlrf8fAI/AAAAAAAAATs/JP5CLHtXiBIQoWue_u9xA_NqTTDVjei9gCLcB/s640/p2.png" width="640" /></a></div>
<div class="MsoNoSpacing">
<br /></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><b>Recon failure error messages (One of the Recons does not balance)</b></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;">After a reconciliation fails due to an imbalance between the cashbook and bank when using Helper Data, it has frequently been </span><span style="font-family: "Trebuchet MS", sans-serif;">due to one or more cashbook transactions matching to more than one ReconHelperCashbook transaction.</span> <span style="font-family: "Trebuchet MS", sans-serif;">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.</span></div>
<div class="MsoNoSpacing">
<span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Trebuchet MS, sans-serif;"> </span></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><b>Easy Recon rule performance</b></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;">The Easy recon rule editor now generates rules using Batch processing by default. </span><span style="font-family: "Trebuchet MS", sans-serif;">This results in performance improvements in the case that grouping is used and the rule returns many groups.</span></div>
<div class="MsoNoSpacing">
<span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Trebuchet MS, sans-serif;"> </span></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><b>Recon viewer</b></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><b><br /></b></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;">The Recon viewer screen has been updated to account for a large number of transferred transactions. </span><span style="font-family: "Trebuchet MS", sans-serif;">When Reconciliations are run across accounts and a large number of transactions are transferred, displaying them all on one screen may result in timeouts,</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;">server errors (maxRequestLength exceeded) or generally poor performance.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;">We have added paging on the ReconViewer to handle this case.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: "Trebuchet MS", sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-KlQFrYsBOJM/V3UEH1d5spI/AAAAAAAAAT0/eAQ-G05dW8gy4ATxBfx6hz3tYkWBZkl-wCLcB/s1600/p3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="576" src="https://3.bp.blogspot.com/-KlQFrYsBOJM/V3UEH1d5spI/AAAAAAAAAT0/eAQ-G05dW8gy4ATxBfx6hz3tYkWBZkl-wCLcB/s640/p3.png" width="640" /></a></div>
<div class="MsoNoSpacing">
<span style="font-family: "Trebuchet MS", sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: "Trebuchet MS", sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: "Trebuchet MS", sans-serif;">The page size is a web config application setting, </span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span><configuration></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>...</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span><appSettings></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>...</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span><add key="bankrecon.reconviewer.pagesize" value="10"/></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>...</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span></appSettings></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>...</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span></configuration></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;">Increasing the value will affect performance and may require the maximum request length to be increased when the value is large. </span><span style="font-family: "Trebuchet MS", sans-serif;">The default value is 10 items.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: "Trebuchet MS", sans-serif;"><b>Services User</b></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;">A new user type has been added. Existing users who login to the front-end are known as end-users. </span><span style="font-family: "Trebuchet MS", sans-serif;">The new user type is a service user. </span><span style="font-family: "Trebuchet MS", sans-serif;">Service users cannot login to the front-end. </span><span style="font-family: "Trebuchet MS", sans-serif;">Service users must have a password set, as they are used for the webservice integration. </span><span style="font-family: "Trebuchet MS", sans-serif;">The Service user details are not updated by Active Directory.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><b>Manual Recon balancing entries</b></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><b><br /></b></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;">There is a new web configuration setting:</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"> <configuration></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>...</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span><appSettings></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>...</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span><add key="bankrecon.glaccount.dropdownlimit" value="1000"/></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>...</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span></appSettings></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>...</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span></configuration></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Trebuchet MS, sans-serif;">The setting affects the cashbook transaction allocation editor when creating a balancing entry. </span><span style="font-family: "Trebuchet MS", sans-serif;">When an account is linked to more GL accounts than specified by the value, the GLAccount dropdown becomes an autocompleting textbox.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: "Trebuchet MS", sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-va1OnOcqrxI/V3UFuBnbtwI/AAAAAAAAAUE/AsT2b0vDe0M0r-unurf5l_yOEtZlxIpvACLcB/s1600/p4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://2.bp.blogspot.com/-va1OnOcqrxI/V3UFuBnbtwI/AAAAAAAAAUE/AsT2b0vDe0M0r-unurf5l_yOEtZlxIpvACLcB/s320/p4.png" width="297" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="MsoNoSpacing" style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; margin: 0px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<o:p></o:p></div>
<br />
<div class="MsoNoSpacing" style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; margin: 0px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<span style="font-family: Trebuchet MS, sans-serif;">The default value is 1000. </span><span style="font-family: "Trebuchet MS", sans-serif;">Setting the value to 0 will always use the autocomplete textbox. </span><span style="font-family: "Trebuchet MS", sans-serif;">Setting the value to a very large number will always use the dropdown.</span></div>
<div class="MsoNoSpacing" style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; margin: 0px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<span style="font-family: "Trebuchet MS", sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-slZbeezElTk/V3UFuKOfBhI/AAAAAAAAAUI/dv5GDW-39dkSYV1dyv1TB5mwASrb6fzIwCKgB/s1600/p5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://4.bp.blogspot.com/-slZbeezElTk/V3UFuKOfBhI/AAAAAAAAAUI/dv5GDW-39dkSYV1dyv1TB5mwASrb6fzIwCKgB/s400/p5.png" width="326" /></a></div>
<div class="MsoNoSpacing" style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; margin: 0px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<span style="font-family: "Trebuchet MS", sans-serif;"><br /></span></div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-66430816490589053132016-05-20T13:14:00.000+02:002016-05-20T13:16:12.372+02:00Bank Recon 4.7 is available<span style="font-family: "trebuchet ms" , sans-serif;">Bank Recon 4.7.1059.3321 is available for download from the <a href="https://www.twenty57.com/twenty57/BankRecon/Download.aspx?product=BankRecon" target="_blank">Twenty57 website</a>. Thank you to Shivkant for the development work.</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span><span style="font-family: "trebuchet ms" , sans-serif;"><b>New Features</b></span><br />
<br />
<ul>
<li><span style="font-family: "trebuchet ms" , sans-serif;">Bank Recon now supports Chrome Browser</span></li>
</ul>
<ul>
<li><span style="font-family: "trebuchet ms" , sans-serif;">MT940 parser now imports a statement date using the last intermediate (62M) or final (62F) closing balance of the SWIFT message</span></li>
</ul>
<ul>
<li><span style="font-family: "trebuchet ms" , sans-serif;">SWIFTMT940/SWIFTMT950 parsers both populate Reference1 with the TransactionTypeIdentifier field and Reference2 with the AccountOwnerReference field</span></li>
</ul>
<br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span><span style="font-family: "trebuchet ms" , sans-serif;"><b>Fixes</b></span><br />
<br />
<br />
<br />
<br />
<ul>
<li><span style="font-family: "trebuchet ms" , sans-serif;">Recon rule preview now works correctly when using the Batch processing feature</span></li>
</ul>
<ul>
<li><span style="font-family: "trebuchet ms" , sans-serif;">The Recon rule description length has been increased to 300</span></li>
</ul>
<ul>
<li><span style="font-family: "trebuchet ms" , sans-serif;">The AutoRecon Batch processing mode now processes all matches of a batch instead of skipping the last one in the batch</span></li>
</ul>
<div>
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span><span style="font-family: "trebuchet ms" , sans-serif;"><b>Improvements</b></span><br />
<br />
<ul>
<li><span style="font-family: "trebuchet ms" , sans-serif;">Login page enhancements + autofocus on the username textbox</span></li>
</ul>
<ul>
<li><span style="font-family: "trebuchet ms" , sans-serif;">Display issue affecting the Bank Keys view from the Recon rule test feature has been resolved</span></li>
</ul>
<ul>
<li><span style="font-family: "trebuchet ms" , sans-serif;">The AutoRecon Batch processing mode no longer requires GetKeys commands for the left/right datasets</span></li>
</ul>
<div>
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span><span style="font-family: "trebuchet ms" , sans-serif;"><b>Performance</b></span><br />
<br />
<ul>
<li><span style="font-family: "trebuchet ms" , sans-serif;">The Batch size used for the AutoRecon batch processing mode is now configurable (default: 1000)</span></li>
</ul>
</div>
</div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-82971709131286826192016-03-30T15:03:00.000+02:002016-03-30T15:03:22.395+02:00Bank Recon 4.6 is available<span style="font-family: Trebuchet MS, sans-serif;">Bank Recon 4.6.1050.3285 is available for download from the <a href="https://www.twenty57.com/twenty57/BankRecon/Download.aspx?product=BankRecon" target="_blank">Twenty57 website</a>. Thank you to Shivkant for the development work.</span><br />
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span>
<span style="font-family: Trebuchet MS, sans-serif;"><b>New Features</b></span><br />
<br />
<ul>
<li><span style="font-family: 'Trebuchet MS', sans-serif;">There is a new user right applicable to the creation of balancing entries for manual reconciliations:</span></li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-T-fxg1ROfsg/VvvGzo3RiOI/AAAAAAAAARA/vG8hX6Vcv-Eq7iG_hUbQVFpynicFB9xvg/s1600/userright.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://2.bp.blogspot.com/-T-fxg1ROfsg/VvvGzo3RiOI/AAAAAAAAARA/vG8hX6Vcv-Eq7iG_hUbQVFpynicFB9xvg/s1600/userright.png" /></a></div>
<div>
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<ul>
<li><span style="font-family: 'Trebuchet MS', sans-serif;">When the setting is off, then any balancing entry created may only be associated to a single GL account:</span></li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-hA5MTG6NjYs/VvvGgbN-YaI/AAAAAAAAAQ8/rIkZtAwKSOUxcp3LKSUw0b2EzgLRiAe4A/s1600/balancingentry.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="305" src="https://2.bp.blogspot.com/-hA5MTG6NjYs/VvvGgbN-YaI/AAAAAAAAAQ8/rIkZtAwKSOUxcp3LKSUw0b2EzgLRiAe4A/s400/balancingentry.png" width="400" /></a></div>
<div>
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<br />
<div>
<div>
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div>
<b><span style="font-family: Trebuchet MS, sans-serif;">Fixes</span></b></div>
<div>
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div>
<ul>
<li><span style="font-family: 'Trebuchet MS', sans-serif;">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</span></li>
<li><span style="font-family: 'Trebuchet MS', sans-serif;">The Manual Recon dynamic view filter option bug involving the @Date parameter has been fixed</span></li>
<ul>
<li><span style="font-family: 'Trebuchet MS', sans-serif;">Only the equality / inequality operators are supported at this time</span></li>
</ul>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-edaB0K1wy-0/VvvKbsDAk3I/AAAAAAAAARQ/TWyzXSgmeJw2W0yV3iYkfOjAoT9lofbCg/s1600/dynamicdate.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="500" src="https://3.bp.blogspot.com/-edaB0K1wy-0/VvvKbsDAk3I/AAAAAAAAARQ/TWyzXSgmeJw2W0yV3iYkfOjAoT9lofbCg/s640/dynamicdate.png" width="640" /></a></div>
<ul>
<li><span style="font-family: 'Trebuchet MS', sans-serif;">AutoRecons configured to run across accounts which also use Helper transactions now work correctly</span></li>
<ul>
<li><span style="font-family: 'Trebuchet MS', sans-serif;">This involves transferring the original cashbook transactions into the target account and creating any missing cashbook transactions in the target account using the helper transactions</span></li>
</ul>
<li><span style="font-family: 'Trebuchet MS', sans-serif;">On the Easy Recon rule screen, the "Other Match" editor now works correctly when using the Reference1 field and any of the Reference10-Reference19 fields</span></li>
<li><span style="font-family: 'Trebuchet MS', sans-serif;">The Manual Recon profile list now displays correctly on IE9</span></li>
<li><span style="font-family: 'Trebuchet MS', sans-serif;">SWIFT MT950 bank statements with country codes matching Zimbabwe (ZW) / Malawi (MW) now import correctly</span></li>
</ul>
</div>
<div>
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div>
<b><span style="font-family: Trebuchet MS, sans-serif;">Improvements</span></b></div>
<div>
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div>
<ul>
<li><span style="font-family: 'Trebuchet MS', sans-serif;">Open Bank / Cashbook batches can be reordered using the DateCreated column to show earliest / latest entry first</span></li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-OdX9t5RW7cc/VvvM3QoO4QI/AAAAAAAAARc/tWzTPOL0mMwQ2dn195bic_0NR16YPdH2A/s1600/datecreated.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://4.bp.blogspot.com/-OdX9t5RW7cc/VvvM3QoO4QI/AAAAAAAAARc/tWzTPOL0mMwQ2dn195bic_0NR16YPdH2A/s1600/datecreated.png" /></a></div>
<div>
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<ul>
<li><span style="font-family: 'Trebuchet MS', sans-serif;">Export to Excel functionality has been added to the following screens:</span></li>
<ul>
<li><span style="font-family: 'Trebuchet MS', sans-serif;">Cashbook allocations</span></li>
<li><span style="font-family: 'Trebuchet MS', sans-serif;">Grouped Cashbook transactions (Manual Recon)</span></li>
<li><span style="font-family: 'Trebuchet MS', sans-serif;">Grouped Bank transactions (Manual Recon)</span></li>
</ul>
</ul>
</div>
<div>
<b><span style="font-family: Trebuchet MS, sans-serif;">Performance</span></b></div>
<div>
<ul>
<li><span style="font-family: 'Trebuchet MS', sans-serif;">Auto Reconciliation performance improvements have been made for Reconciliations performed across accounts involving transaction transfers.</span></li>
</ul>
</div>
</div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-19047720086380230862016-02-02T13:03:00.000+02:002016-02-02T16:43:05.595+02:00Bank Recon 4.5.1039.3252 is availableBank Recon 4.5.1039.3252 is available for download from the <a href="https://www.twenty57.com/twenty57/BankRecon/Download.aspx?product=BankRecon" target="_blank">Twenty57 website</a>. A big thank you to Ashish, Jai and Shivkant for the development work.<br />
<br />
<b><br /></b><b>Features</b><br />
<ul style="text-align: left;">
<li><u>Import definitions</u></li>
<ul>
<li>BankRecon can now import transactions from Oracle stored procedures</li>
<ul>
<li>Entering the name of a configured stored procedure will return a parameter list</li>
<li>One of the parameters must be selected as the Key value as per regular imports</li>
</ul>
</ul>
<li><u>Tagging across accounts</u></li>
<ul>
<li>Tagging across accounts is now supported to complement searching across accounts</li>
<li>In the case that transactions have been tagged from multiple accounts, the account name is added to transaction grid to disambiguate the source</li>
<li>Tagged cashbook and bank transactions will open in the account in which they were tagged</li>
</ul>
<li><u>Public Recon profiles</u></li>
<ul>
<li>Manual recon profiles can be published to all users on the same account as a public profile</li>
<li>Public profiles will appear in other users' Current Profile dropdowns who have access to the same account</li>
<li>Any profile can be shown in / hidden from the 'Current Profile' list using the 'Manage Profiles' screen</li>
<li>Only the creator of a public profile may edit/delete that profile</li>
</ul>
<li><u>Export to excel</u></li>
<ul>
<li>Cashbook and Bank transaction exports now produce Excel (xlsx) files in addition to csv files</li>
<li>Reconciliations can now be exported in a single Excel workbook with 3 sheets:</li>
<ul>
<li>Details: Shows the Reconciliation details (ID, Account, Accounting Period, User, Description)</li>
<li>Cashbook: Contains the reconciled cashbook transactions</li>
<li>Bank: Contains the reconciled bank transactions</li>
<li>When exporting reconciliations as a csv file, the 3 datasets are zipped into a single archive</li>
</ul>
</ul>
<li><u>Accounting Periods</u></li>
<ul>
<li>There is a new setting on the Account maintenance screen to allow/deny closing an accounting period prior to the period's end date</li>
</ul>
<li><u>Adjust Opening Balance</u></li>
<ul>
<li>Accounting Period opening and closing balances for the Cashbook and Bank are shown</li>
<li>A help dialog has been added to explain the functionality</li>
<li>The earliest available Bank opening balance is displayed to illustrate the procedure and updating the bank opening balance now correctly propagates to all subsequent periods</li>
</ul>
</ul>
<div>
<b>Fixes</b></div>
<div>
<ul style="text-align: left;">
<li><u>Manual Recon screen</u></li>
<ul>
<li>When grouping bank transactions, the filter is now applied to the underlying transactions and not the resulting group</li>
</ul>
<li><u>Reports</u></li>
<ul>
<li>Parameterless reports now display correctly in the browser</li>
</ul>
<li><u>Generic CSV importer</u></li>
<ul>
<li>The Generic CSV importer no longer attempts to validate the statement number when selected as part of a multiple file import since it does not use the statement number</li>
<li>Errors returned by the parser include the transaction number relative to the uploaded file and useful information on how to resolve any errors</li>
</ul>
</ul>
<div>
<b>Performance</b></div>
</div>
<div>
<b><br /></b></div>
<div>
<ul>
<li><u>Classic Recon rules</u></li>
<ul>
<li>The classic Recon rule editor now supports a batch processing mode, which improves performance by executing the GetKeysCommands for a batch of matches instead of one-by-one processing</li>
<li>An example is available in the application to illustrate the procedure and changes required to the Recon rule</li>
</ul>
<li><u>Auto Recon rule performance logging</u></li>
<ul>
<li>In Site Configuration, there is a new setting, "AutoRule Log Enabled"</li>
<li>When checked, the consolidated duration of the left and right side queries of Recon rules are logged in the 'ReconRuleAuditLog' table, so that any poorly performing queries can be identified</li>
</ul>
</ul>
</div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-27334389605264855602015-11-06T14:24:00.000+02:002015-11-06T14:24:03.408+02:00Bank Recon 4.4.1019.3187 is available<div dir="ltr" style="text-align: left;" trbidi="on">
Bank Recon 4.4.1019.3187 is available for download from the <a href="https://www.twenty57.com/twenty57/BankRecon/Download.aspx?product=BankRecon" target="_blank">Twenty57 website</a>. A big thank you to Ashish, Jai and Shivkant for the development work.<br />
<br />
<b><br /></b>
<b>Features</b><br />
<ul style="text-align: left;">
<li>Process Queuing has been implemented. This will ensure only one process log item runs at a time, minimising concurrent calls to the database</li>
<ul>
<li>The process items will execute in the order they have been kicked off </li>
<li>An item will remain in pending state until it is first in the queue</li>
</ul>
<li>Speed improvements to the Cashbook Import process</li>
<li>Bank Statement support for a number of Zimbabwean banks. See the <a href="http://help.bankrecon.twenty57.com/supported-bank-statements" target="_blank">help sit</a>e for a complete list</li>
<li>You can now sort the transactions in the Matched section of the Manual Recon screen</li>
<ul>
<li>The sorting is independent of the transactions list and you can only sort on one column at a time</li>
<li>The sort order is saved to profiles</li>
</ul>
<li>Bank Recon now installs on Windows 10/IIS 11 successfully</li>
<li>Better error messages and an easier to read error pop-up if something goes wrong during the install</li>
<li>All errors are written to the log file and the log file can be opened from the msi directly in the case of install failure</li>
<li>You can read more on the msi logging functionality <a href="https://twenty57.zendesk.com/entries/83850195-Installer-Error-Logs" target="_blank">here</a></li>
<li>Swift parser now handles a file padded with spaces to make it fixed length</li>
<li>Process Log message time stamp is now saved in 24-hour format</li>
<li>The release notes have been moved to a page (Release Notes) in this blog. The Release notes link under the Help Menu will direct you to this page</li>
</ul>
<div>
<b>Fixes</b></div>
<div>
<ul style="text-align: left;">
<li>Test Oracle Import definition now works correctly when the KeyValue type is Date</li>
<li>Ensure Across account recons don't cause table locking issues</li>
<li>Ensure the SMTP password isn't overwritten with no value every time you Save the Site Configuration settings</li>
<li>Ensure the SMTP password value is stored encrypted in the database. <b>PLEASE NOTE: </b> This change requires us to clear any existing SMTP password value out of the database. If you have added SMTP settings to Bank Recon please update the password again after installing this version</li>
</ul>
</div>
</div>
Anonymousnoreply@blogger.com1tag:blogger.com,1999:blog-2641608521216569365.post-91594440956672461692015-08-27T14:41:00.001+02:002015-08-27T14:59:22.500+02:00Bank Recon 4.2.983.3100 is available <div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: inherit;">Bank Recon 4.2.983.3100 is available for download from the <a href="https://www.twenty57.com/twenty57/BankRecon/Download.aspx?product=BankRecon" target="_blank">Twenty57 website</a>. Thank you to Shivkant and Ashish for the dev work</span><br />
<span style="font-family: inherit;"><br /></span>
<b><span style="font-family: inherit;">Features</span></b><br />
<ul style="text-align: left;">
<li><span style="font-family: inherit;">Bank Account currency column displayed on the Account List page</span></li>
<li><span style="font-family: inherit;">Bank Account Id displayed on the Account List page. This is to help with writing Easy Recon Rules</span></li>
<li><span style="font-family: inherit;">SWIFT MT940 Statement parser enhancements - process Statement Number Tag 28 instead of 28C</span></li>
<li><span style="font-family: inherit;">BAI Parser enhancements - process Custom Codes correctly, better handling of post-dated transactions on a statement, handle a comma in the 16 tag text field</span></li>
<li>Only allow an across account recon if at least one of the transactions in the match belongs to the selected account<span style="font-family: inherit;"> </span></li>
<li><span style="font-family: inherit;">Accounting Periods: Allow editing of last accounting period name if manually added and allow delete of last accounting period if no data linked to it</span></li>
</ul>
<div>
<span style="font-family: inherit;"><br /></span></div>
<div>
<b><span style="font-family: inherit;">Fixes</span></b></div>
<div>
<ul style="text-align: left;">
<li><span style="font-family: inherit;">Multiple Import of Bank Statements now shows Error Status and details if the import fails for some reason (files written to the Failed folder)</span></li>
<li><span style="font-family: inherit;">A Daily Process Schedule log item shows error Status if one of the processes inside of it fails</span></li>
<li>Use the correct Cashbook Transaction Type when transferring transactions between accounts</li>
<li><span style="background-color: white; line-height: 20px;"><span style="font-family: inherit;">Display correct Batch Create User when viewing cashbook batch details through the All Batches screen</span></span></li>
<li><span style="background-color: white; line-height: 20px;"><span style="font-family: inherit;">Group by in Easy Recon rules is creating the GetKeysCommand correctly</span></span></li>
<li><span style="background-color: white; line-height: 20px;"><span style="font-family: inherit;">Same side cashbook transactions created by the Helper rule process are being moved to the Unreconciled tables</span></span></li>
<li><span style="background-color: white; line-height: 20px;"><span style="font-family: inherit;">Ensure correct columns appear in the Manual Recon Cashbook filter view. Tag Name was being incorrectly shown and Account Name when searching in a single account</span></span></li>
<li><span style="background-color: white; line-height: 20px;"><span style="font-family: inherit;">Alignment of grids and columns on the Daily Process Setup and Run Screens is fixed</span></span></li>
<li><span style="background-color: white; line-height: 20px;"><span style="font-family: inherit;">Apply an <i>Order by RowNumber</i> clause to the query that generates the manual recon screen to ensure text fields are ordered correctly in all instances</span></span></li>
</ul>
<div>
<span style="line-height: 20px;"><br /></span></div>
</div>
<div>
We're taking a look at Bank Recon performance over the next couple of months. Improving the speed of cashbook imports, ensuring processes run efficiently, and updating queries to generate the screens faster. We'll also be looking at better management of concurrent users to make sure users on different domains and accounts don't block each other.<br />
<br />
<br /></div>
</div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-64470248247120587662015-02-10T14:04:00.000+02:002015-02-10T14:04:34.384+02:00Bank Recon version 4.2.963.3056 is available<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
It can be downloaded from the <a href="https://www.twenty57.com/twenty57/BankRecon/Download.aspx?product=BankRecon" target="_blank">Twenty57 website</a>.<br />
<br />
<b>Features</b><br />
<br />
<ul style="text-align: left;">
<li>New PNB Paribas statement parser. It will accept the csv format</li>
<li>Changes to MT940 statement to apply a less strict statement number check. It will import a statement with a greater than number, not just the next sequential number</li>
<li>Ensure that the MT940 statement number reset in a new year works when statements are not generated daily. Any statement numbered 1,2 or 3 will be accepted</li>
<li>Remove a binary null character if present in a CATS Statement to prevent any errors in viewing the transactions on the UI</li>
<li>Automatically create the next accounting period if the expected accounting period for a bank statement is closed. eg. the statement Date is December, but the December period is closed. January will be created and the batch created in it</li>
<li>New column on Account table: <i>Bank Account Currency</i>. Allows null and accepts any text value up to 50 characters long</li>
<li>Email Tags can now be used with Forms Authentication. There needs to be a valid email address specified for the user sending the tag. Email is now an additional field on the user table</li>
<li>Explanations for some of the Site Config General Settings</li>
</ul>
<div>
<b>Fixes</b></div>
<ul style="text-align: left;">
<li>Ensure General Ledger Export rights are persisted correctly to the Database when assigned to a User Group</li>
<li>Ensure the correct accounting period is used when a bank statement contains a backdated transaction and there are multiple open periods</li>
<li>Test Cashbook Import Definition now works when the query has an inner select statement</li>
</ul>
<div>
Thank you to Jai, Shivkant and Ashish for the dev work!</div>
<br />
<br /></div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-23594966700774274342014-11-06T15:37:00.000+02:002014-11-06T15:37:18.753+02:00Bank Recon 4.2.949.3024 is available<div dir="ltr" style="text-align: left;" trbidi="on">
A bumper release full of fixes and tweaks to existing functionality to make BR even easier to use as well as a couple of cool new features. Bank Recon 4.2.949.3024 can be downloaded from the <a href="https://www.twenty57.com/twenty57/BankRecon/Download.aspx?product=BankRecon" target="_blank">Twenty57</a> website. Thank you to Jai for all the development work!<br />
<br />
<h3 style="text-align: left;">
Features</h3>
<div>
<ul style="text-align: left;">
<li>MT940 parser enhancements - Statement check ensures the current statement is the next sequential statement, Multiple import supported, Parser strips out newline characters in the details fields, all characters in the 86 continuation record are not imported (split over Reference 3, 4 ( and 5 if needed)</li>
<li>BAI Report - Statement Date included in the statement correctness check to help prevent duplicate imports of accounts which always have a zero balance</li>
<li><i>Allow Remove</i> Setting on the Batch Type is honoured when deleting a Cashbook Batch</li>
<li>Rollback of Bank Statements removes empty statements</li>
<li>Rollback Cashbook imports has been implemented. Only the last import per definition can be rolled back. This will delete the transactions from any tags, remove all reconciliations and delete all the transactions and batches created as part of the import</li>
<li>Prevent duplicate Cashbook import running. If there is a process already running for the selected import, the current one won't run</li>
<li>Manual Recon across accounts process has been enhanced. Instead of creating a balancing entry and reconciliation for every transaction that needs to be transferred in order to make the match, the transactions are bulked and one transaction and recon is made per account. Because Recons across accounts are now linked (since version 4.2.877.2832 from April 2014), you can still easily see what the details of the source transactions are. This has resulted in significant performance gains when reconciling many transactions across accounts</li>
<li>Additional information fields have been added to the user table (First Name, Surname, Email and Last Logged in DateTime). If you are using Windows Authentication the name and email values will be synced directly from your Active Directory. The Last Logged in DateTime is updated every time a user logs into Bank Recon</li>
<li>If there is a First Name value for the user, this will be displayed instead of the login name in the Welcome message</li>
<li>Suggest Configuration settings have been moved out of Site Config and are now accessible by Admins and Site Admins (and other users if they have the appropriate rights)</li>
<li>SMTP settings are now in the Site Configuration page and saved to the Database rather than in the web.config file. We first check in the Db, if no smtp settings are found there, the web.config file is checked. If no smtp settings are found at all then user won't be able to email a tag. You need to be using Windows Authentication to send emails from tags</li>
<li>Included Cashbook Batch Type and Cashbook Transaction Type in the CashbookTransactionUnreconciledView for writing Recon Rules. Both these fields are available in the Easy and the Advanced Recon Rule Editor</li>
<li>Setup and Admin tables styling improved to distinguish between columns more clearly</li>
</ul>
</div>
<div>
<h3 style="text-align: left;">
Fixes</h3>
<div>
<ul style="text-align: left;">
<li>Test Import Definitions with >/>= and a Date value now works. Remember, BR always adds on 1 day to the last key value for a Date type when running the process so make sure you don't miss any transactions if you use these operators with a Date Value</li>
<li>Errors when trying to email a tag have been fixed</li>
<li>Better error messages are shown when manually reconciling transactions and the Balancing Entry and Transfer Transactions Domain Settings have not been configured. </li>
<li>The schedule user now has all the necessary rights to import and reconcile data</li>
<li>Expanded menu items are not closed when the Dashboard automatically refreshes</li>
<li>Test Oracle import definitions now working correctly. You need to add the following settings to your config files</li>
<ul>
<li>appSettings section of the web.config file: <add key="OracleImporterURL" value="tcp://localhost:8087/OracleImporter" /> </li>
<li>services section of the ProcessService.exe.config file: <wellknown type="Twenty57.BankRecon.API.OracleImporterProxy, Twenty57.BankRecon.API" mode="SingleCall" objectUri="OracleImporter" /></li>
</ul>
<li>The Framework version check is working correctly on the install. If you don't have .net Framework 4 installed, you won't be able to install Bank Recon</li>
</ul>
</div>
</div>
</div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-2641608521216569365.post-78779094678513514562014-08-12T13:20:00.000+02:002014-08-12T13:20:31.516+02:00Bank Reconciliation 4.2.917.2930 is available<div dir="ltr" style="text-align: left;" trbidi="on">
It can be downloaded from the <a href="https://www.twenty57.com/twenty57/BankRecon/Download.aspx?product=BankRecon" target="_blank">Twenty57 website</a>.<br />
<br />
Release Notes:<br />
<ul style="text-align: left;">
<li>If a bank statement belongs in an accounting period that has closed, it will be created in the next open period instead of failing</li>
<ul>
<li>It is best practice to ensure all transactions for a period have been imported before closing the period but you won't be punished if it happens</li>
</ul>
<li>Work has been done to ensure BankRecon works correctly with different Server Date and Number formats</li>
<li>Install won't fail if the Reports cannot be inserted into the Database. This usually happens when the database was not selected as part of a clean install</li>
</ul>
</div>
Anonymousnoreply@blogger.com0