Adagio BankRec Change log


Adagio BankRec
9.3A | 2023-11-06 (Nov '23)
  Go to top
Release Notes
Print This

    ·         If a BankRec Payment entry had multiple details and the Cash Invoice number was identical except for the case, not all of the details went to the Payables Manual Check Batch.

    ·         Multi-selecting and emailing Receipts sent from an open batch, from the email queue, caused an \\\"Attempting to perform operation on unopened Batch Header file” error message.  This fix will only work for new emails sent to the email queue.

    ·         If 'Consolidate Bank Transactions?' was not selected in the Company Profile, the Batch Description was replacing the Entry Header Description line 1 as the 'Doc. Description' in the Send to G/L Description fields.

    ·         If 'North American Address?' is selected, the states for Mexico will be normalized to the 2 character state.

    ·         Receipts retrieved from Receivables will have formatted Receipt addresses and if ‘North American Address?’ has been selected, the Country will be normalized.

    ·         Entry Templates have been updated.  Delete is the only batch entry option that affects the Open Batches window and the Batch Entry List.  If Disable or Hide have been enabled for this button, it will affect the button on these windows only, effectively preventing a user from deleting an entire batch or any entries within the batch.  As long as the Button: Edit is made available, a distribution within an entry may be deleted.

    ·         For JobCost 93A: Customer Name has been added to the list of fields available to display in the finders/smartfinders for Job, Phase and Category.

    ·         If the Company Profile is set to use “North American Address?, Import Receipts will validate State/Province. If Country is imported, it will also be validated.

    ·         The Country list that will be normalized when 'North American Address?' is selected has been expanded to include more countries.

    For editing Payables Vendors, if ‘North American Address?’ has been set in the BankRec Company Profile, Options tab and in Payables 9.3C on the System Options tab, Vendor Addresses will be normalized based on the setting for ‘Normalize Country To’.  If these options are not set in Payables, the Country will be normalized to ‘Full Name’.

    For editing Receivables Customers, if ‘North American Address?’ has been set in the BankRec Company Profile, Options tab and in Receivables 9.3B on the System Options tab, Customer Addresses will be normalized based on the setting for ‘Normalize Country To’.  If these options are not set in Receivables, the Country will be normalized to ‘Full Name’.

    For the addresses in Bank edit and Edit Company Profile as well as the Edit or Import of Receipt Addresses, the Receivables setting for ‘Normalize Country To’ will be used if Receivables Interface is selected.  If Receivables is not interfaced, the Payables setting for ‘Normalize Country To’ will be used. If Receivables and Payables are not interfaced, then Country will be normalized to the ‘Full Name”.



Adagio BankRec
9.3A | 2023-02-20 (Feb '23)
  Go to top
Release Notes
Print This

     
    • Crystal Reports used in printing Adagio Reports was not fully compatible with the Windows 22H2 update for Windows 11 and for Windows 10, in some cases.


Adagio BankRec
9.3A | 2023-01-10 (Jan '23)
  Go to top
Release Notes
Print This

    • Posting batches retrieved from Payables does not halt for Inactive Vendors.

    • With Receivables 9.3B, Customer email addresses are now available for finding customers, either from the customer list or within transaction entry. This includes using the Contact, Ship-to or any email field on the customer. If multiple emails separated by semi-colons are stored in a single email field, then any one can be used for finding the customer

    • In the Designer, Properties for Amount fields has a new option for the Thousands separator: None.

    • The Customer Transactions viewed from BankRec did not show the DocStore Viewer for SalesCQ Quotes.

    • Posting in BankRec 93A did not update the transaction type in the Receivables Retrieval file, in some cases. Receipt details retrieved in Receivables were not applied properly.

    • Print Receipts will now print D09 Description for Receivables Receipt Details and not just Misc Receipt Details.

    • When Reconciliations were posted, the NSF Posting Journal posting sequence was being incremented incorrectly when no NSFs were included in the Reconciliation posting.

    • In Automation, the SetSessionDate command has a new noun for: Yesterday.

    • Posting batches from the Post menu was not checking the 'Ready to Post' status of Batches.  This affected the Post command in Automation.



Adagio BankRec
9.3A | 2022-04-05 (Apr '22)
  Go to top
Release Notes
Print This

    ·          In BankRec 9.3A (2022.03.22) Service Pack, a field default could not be saved for any Import Template. This error message would appear: Application/task handle has not been set.

    ·          Import and Export templates now have the same ability as the Column Editor to restrict the Available Field list to those of selected data types and/or contain specified characters.

    ·          The Available field list can also be sorted alphabetically.

    ·          The Batch Listing transaction type summary printed the 'Total receivables' amount doubled for unapplied receipts.

    ·          The Posting journal had unbalanced General Ledger Distribution summaries for receipts with an unapplied amount, in some cases.

    ·          If a Deposit that had been set to a Pending Cleared status was split during Reconciliation, the updated Deposit and the new Deposit both inherited the Pending Status. The updated Deposit had the correct Total Receipt but the Cleared Amount was not updated properly. The 'To Clear' amount for the Reconciliation was inaccurate. Now both Deposits are set to Status: Outstanding.

    ·         Conversion from 9.2A failed if it found orphan detail batch files without the associated header files. Conversion now completes and removes the orphan files.



Adagio BankRec
9.3A | 2022-03-22 (Mar '22)
  Go to top
Release Notes
Print This

    ·          Import and Export templates now have the same ability as the Column Editor to restrict the Available Field list to those of selected data types and/or contain specified characters. The Available field list can also be sorted alphabetically.

    ·          The Batch Listing transaction type summary printed the 'Total receivables' amount doubled for unapplied receipts.

    ·          The Posting journal had unbalanced General Ledger Distribution summaries for receipts with an unapplied amount, in some cases.

    ·          If a Deposit that had been set to a Pending Cleared status was split during Reconciliation, the updated Deposit and the new Deposit both inherited the Pending Status. The updated Deposit had the correct Total Receipt but the Cleared Amount was not updated properly. The 'To Clear' amount for the Reconciliation was inaccurate. Now both Deposits are set to Status: Outstanding.

    ·          Conversion from 9.2A failed if it found orphan detail batch files without the associated header files. Conversion now completes and removes the orphan files.



Adagio BankRec
9.3A | 2021-12-15 (Dec '21)
  Go to top
Release Notes
Print This

    ·        New Transfer Entries created during reconciliation no longer have a Pending status in the Transfer Bank set in Edit Bank Statement Detail.

    ·        Posting BankRec Payment entries for Payables Vendors that included details for multiple Cash Invoice or multiple Prepayment Invoice numbers did not update Payables Manual Check batches with all of Cash Invoice or Prepayment entries. 

    ·        When the details for Payments were entered and then the Entry type was changed to Receipts, BankRec did not clear all of the Payment's information. This caused unexpected Miscellaneous Receipts to be passed on to Receivables and then to Ledger.

    ·        For datasets using 6 digit Customer codes, the NSF Receipts List and NSF Listing truncated the Customer code.

    ·        Entering a cash invoice Payment now supports the uppercase document number option defined in the Payables company profile

    ·        Editing transactions paid with Online Credit Cards did not display the most up to date Credit Card information in BankRec, in some cases.

    ·        In Receipt Entry with Adagio Payments, Credit Card fields were overlapping Entry Description 2, in some cases.

    ·        There is a warning if a payment is applied to an Invoice that is on hold in Payables.

    ·        For a Bank with 'Automatic transfer on posting' selected and a batch with multiple Entry type: Transfer entries that increase and decrease the Bank Balance, the sum of the transfer was not being calculated properly during posting, leaving a balance in the Auto Transfer Bank.

    ·        New Transfer Entries created during reconciliation no longer have a Pending status in the Transfer Bank set in Edit Bank Statement Detail.

    ·       After converting data to BankRec 9.3A, the new Error GL account on transactions was still blank if in reconciliation an unposted Cleared with Error status existed. This resulted in a blank account value in the GL batch if the bank is set to not post reconciliation changes to Payables. Now attempting to post the reconciliation will give an error for the blank Error GL account, and editing the reconciliation transaction will populate the error account from the bank. When a reserved Windows character is part of the Bank Reference field, the message ‘Found’ was displayed before printing the report.

     

     



Adagio BankRec
9.3A | 2021-04-07 (Apr '21)
  Go to top
Release Notes
Print This

    ·         When a reserved Windows character is part of the Bank Reference field, the message ‘Found’ was displayed before printing the report.

    ·          If the Reconciliation Match Progress data fil is larger than 4,000 records, this caused problems determining record uniquifiers and caused extreme slowness in opening, closing and using the Bank Reconciliation function.  The performance has been improved significantly.

     ·        When the Accounting Date option in the Company Profiles was not enabled, posting transactions that had the default transaction type edited could result in a blank or incorrect Accounting Date value in the batch.  This caused errors or an incorrect fiscal period for the retrieved Ledger batch.

    ·          Printing the Batch Listing report to paper or PDF was incorrectly changing the status of other batches with lower batch numbers from Open to Printed, when those batches had not been selected to be printed.

    ·          Posting Payments to Miscellaneous Vendors caused an Access Violation in some cases.

    ·          If a Bank Reconciliation is Reset to remove the Matched and other pending status changes after Unmatched transactions have been created in a batch, the New status from the imported records is now reset. This allows the user to rematch the transactions if they were posted or to delete the imported transactions and the batch to start the reconciliation process again.  It also makes it easier to get the To Clear value to zero in order to post the reconciliation when completed.

    ·          In the BR9.3A (2020.12.30) service pack, a problem was introduced where posting payments entered directly in BankRec were incorrectly creating zero dollar detail transactions  to be retrieved into Adagio Ledger. This has been corrected.



Adagio BankRec
9.3A | 2020-12-30 (Dec '20)
  Go to top
Release Notes
Print This

    ·          Posting Payments to Miscellaneous Vendors caused an Access Violation in some cases.

    ·          When a new dataset was created, Company Profile options were not being retained properly. Batch numbering started at 0 instead of 1.

    ·          For datasets with DocStore but no Payables data, there was an Access violation during Payment Posting.

    ·          In Batch Entry for Payments, Edit Cash Detail did not correctly disable the Tax Base field in some cases. In Batch Entry for Payments, 'Auto-Distribute' was not setting the Tax Base to 0.00 in Cash Details that were not Tax related.

    ·          Fixed a problem where, if a transaction entry amount was greater than 0.00 and the Distribution code it used was changed, the transaction entry amount would be changed also. However, if the transaction entry amount is 0.00 and the Distribution code is changed to one having a default amount of greater than 0.00, the transaction entry amount will still be changed to be that of the Distribution code selected.

    ·          The tab sequence on the Enter Payments batch entry form has been changed to tab from the vendor code field to the vendor name field.

    ·          If the data was not integrated with Receivables, there were posting and printing errors related to missing Payment Types.  This also affected viewing Receipt History and import.

    ·          When transactions are matched to an imported bank statement and reconciled, these transaction no longer incorrectly print in the Outstanding section of the Bank Reconciliation report when backdating to a previous report date.

    ·          Speed improvements have been made to Purging Deleted records not having a check number in the Reconciliation window.

    ·          Description data did not print on the Bank Reconciliation report for outstanding payments.

    ·          The summary of the Bank Reconciliation report has an improved and more traceable flow. Backdating to the last statement is reporting more clearly.

    ·          In the Company Profile, when Receipt printing was not enabled but North American address was, an error 'Cannot focus a disabled or invisible window' would appear as the Home Country field is suppressed with the Receipt options. This error no longer appears.

    ·          In the Bank Reconciliation List, the Bank As Of Balance was not being updated based on the As of Date when Reconcile Bank was closed.

    ·          Printing a Report Set directly to the AdagioV3PDF printer driver will now display a prompt to Save the PDF file to a specified name and location.  This Save As prompt is not optional; if you want to save PDFs to previously specified names and locations, then you must use PDF Document as the destination.  PDF Document appears as a Report Set Destination option when Adagio DocStore is integrated.

    ·          Printing a Report Set directly to the AdagioV3PDF printer driver and cancelling from the Save As screen will now prompt the user to cancel either just the Favorite or the entire Report Set.  The choice will be written to the report log.



Adagio BankRec
9.3A | 2020-09-29 (Sep '20)
  Go to top
Release Notes
Print This

    ·        When integrated with Adagio DocStore, you can now Attach and/or View PDFs in the following places: Current and Archived batches, Receipt History Inquiry, Transaction Inquiry, Bank Reconciliation, NSF Receipt entry, Batch Status inquiry. Attachments will flow with transactions written to or retrieved from other applications that support DocStore. Printing customer receipts will create and attach an archived PDF copy of the spec form. Importing deposit or payment batches support include a PDF attachment.

     

    ·        The Adagio Login dialog permits browsing to a UNC.

     

    ·        The Create database button is hidden unless “/C” is included on the command line. New databases are created with the extension “ADB” or the extension used by existing modules in the selected Folder.

     

    ·        User preferences have been added to control the behavior of double clicking in a dialog field.  You can also choose to apply banding to those grids that do not display Styles and choose a date format to use in the Adagio grid.  Telephone numbers are now formatted in the grid according to the Company Profile option.

     

    ·        Only a single instance of Calculator will be launched when the Calculator button is clicked.

     

    ·        A “Backup” button has been added to the Adagio Toolbar. Backup Options select whether the button saves the module data, related data or the entire database and whether exclusive access is required for the backup to proceed. The backup now includes the Automation Batch Folder. Backup options enable automatic or prompted backups prior to performing any critical function such as batch posting or period end functions. You can choose the number of these backups that will be saved.

     

    ·        Refresh Sample Data function has been added to the Help menu. It allows you to refresh single and multi-currency sample data to its original state at install time.

     

    ·        It is easier to choose the correct field from tables with large numbers of fields in the Column Editor. You can now sort the list, restrict the list using the data type you are searching for (Text, Date, Amount and Value), and type in some text likely to identify the field. Use the Select the Type option on the Select Fields dialog to show fields of that type.

     

    ·        When Adagio DocStore is integrated, attachments can be made at the batch level in addition to the transaction level. Attachments to batches will automatically be assigned to each entry when the batch is posted.

    ·        The 64-bit version of Adagio GridView (if available) is launched from the Adagio menu and for custom Views added to the Inquiries menu. The 64-bit version makes use of more memory (if available) allowing for views on larger databases and it can be faster.

    Company Profile

     

    The Company Profile has received a number of updates, including:

     

    ·        These fields have been added to the Company Profile, Profile tab information: Company ID number, Company DUNS number and Contact email.

     

    ·        The second batch entry description field can be selected to write to the Ledger retrieval batch and one of the GL descriptions either from the selection list or with the %ds2 user defined code.

     

    ·        There are new User Defined codes that may be passed to the G/L Description fields:

    %dst - for Distribution code

    %dds - for Detail description

    And if Batch Options Field Titles have been defined in the Receivables and/or Payables Company Profiles, you may also use:

    %bs1 - for Batch Optional string 1

    %bs2 - for Batch Optional string 2

    %bs3 - for Batch Optional string 3

    %bd1 - for Batch Optional date 1

    %bd2 - for Batch Optional date 2

    %ba1 - for Batch Optional amount 1

    %ba2 - for Batch Optional amount 2

    %bu1 - for Batch Optional unit 1

    %bu2 - for Batch Optional unit 2.

    ·        When posting receipts for Receivables customers and creating a cash batch for Receivables, you can now send information with user defined codes to either or both description fields on the cash entry.

    ·        The Default Batch Description has been expanded to 40 characters.

     

    Batch Entry

     

    ·        If Batch Options Field Titles have been defined in the Receivables and/or Payables Company Profiles, they are available in Receipt and Payment entry.

     

    ·        Batches may be sorted by Batch number or Description.

    ·        Supports Online Credit Card Payment Processing with new add-on module Adagio Payments 9.3A.

    ·        When a distribution set in Adagio Payables has been defined with Tax Included or Taxable distribution codes and blank Ledger purchase accounts, creating a Payment batch entry in BankRec will use the Default Purchase account and department from the vendor if one has been defined.

    ·        Copying batch entries now requires selecting the Increment document number option, to prevent creating new entries with duplicate document numbers. Moving batch entries does not require incrementing the document number.

    ·        When creating a payment for an AP vendor, using a Distribution Set will load the vendor default value if one was selected.

    ·        Screen colors for Current and Archive batches may be chosen in the Company Profile to help ensure you are editing the desired batch type.

    ·        A ‘Ready to post’ status has been added to the Batch Status. Default settings for Entered, Retrieved or Imported batches can be set in the Company Profile. Batches written directly to Adagio BankRec from other ledgers such as Receivables or Payables will be considered to have been Retrieved rather than Entered.

    ·        When reversing a cash invoice for an Adagio Payables vendor in bank reconciliation, the option for reversing the invoice portion now follows the setting in Payables for Prompt in addition to Always or Never. This allows the user to choose whether the entire cash invoice is reversed or just the payment portion.

    ·        A second description has been added to batch entry. Both batch descriptions have been increased in size from 30 to 40 characters.

    ·        Customer receipt entry now supports the Adagio Payments add-on for using online credit card processing.

    ·        When customer receipts are entered in Adagio Receivables with a credit card payment method, the credit card information is now retrieved into the BankRec deposit batch for the receipt entries.

    ·        Receipt entries will default the Check number as {year yyyy}-{batch}-{entry}. This also applies to the Bank Reference when the batch is a Standard batch instead of a Deposit batch.

    ·        Customer receipt batch entry now supports Payment Methods defined in Adagio Receivables for categorizing receipts and revealing credit card field information for methods of credit card type.

    ·        When Tax Tracking is enabled, all posted transaction distributions are always saved in the report data file, without an option to exclude any. The Tax Tracking report now has the option to print all distributions or just those with a specific distribution code. Also, it is now possible to print distributions just for receipt or payment transactions for separate reporting.

    ·        Statistical Units can be entered in batches and will be posted through to Ledger (if the account tracks Statistical Units)

    ·        The Ready to Post batches process may be disabled with a security group option.

    ·        Distribution Sets now allow you to distribute a single amount to multiple expense accounts based on a percentage rather than calculating and entering the amounts manually. An ‘Allocation %’ field has been added to the Distribution Set Detail screen. In addition, you can specify a default Allocation Amount in the Distribution Set to be allocated for each detail based on the percentage. You may now configure Distribution Sets to Skip Zero Detail Lines, so that details for a zero amount will not be added to the batch entry.

    ·        Tax can be calculated automatically on amounts entered on 'Misc' receipts and payments. Added ‘Taxable purchase’ option in the Tax Type in Distribution Codes. This is supported in both batch entry and importing batches. You can now recover a percentage of tax to multiple expense accounts on invoices and cash invoices. The field ‘Tax recoverable %’ has been added to Distributions. The percentage is to 5 decimals. This is useful for some Not-for-profit organizations.

    Archive Batch Systems

    ·        An archive batch system is available to store recurring transactions using the same entry procedures as for active batches.

    ·        Archive Batches have been implemented to better facilitate creation of recurring batches.

    ·        Batches can be imported directly to the Archive Batch list, instead of the Current Batch list.

    Inquiries

    ·        Batch Status Inquiry has been enhanced to permit Recovery of batches along with printing of Batch Listings and Posting Journals in most cases.

    ·        The Batch Status Inquiry grid can display either the list of current or archived batches.

    ·        The Batch Status Inquiry grid now sorts the batches in reverse batch number order so that the newest batch is positioned at the top.

    ·        The Batch Status Inquiry grid now supports ExcelDirect

    ·        For Recover batches, retrieved batches and archived batches that had been deleted may be recovered.  Retrieved batches should be recovered, if possible, in the module from which they were retrieved.

    ·        Receipt History can now be sorted either by Customer number or Receipt Date, in addition to Receipt number. When sorting either by Receipt number or Date, receipts are listed in descending order, meaning the newest receipts are at the top.

    ·        More information is now displayed in the Receipt History inquiry, such as Formatted address fields, Optional fields and Credit Card information.

    ·        The Find button on the View Transactions grid within the Bank Inquiry function is now enabled when a filter is applied. You can use the Finder and Smart Finder to search within the filtered grid.

    Reconciliation

    ·        When bank statements are imported into Reconciliation, it is now possible to edit the description fields of transactions that won't be matched and instead will be included in the created batch.

    ·        More Reconciliation processes and user actions are now saved in the Application Log.

    ·        When a payment is marked as Cleared with Error in Bank Reconciliation, the source code for the GL Transaction is now BR-CE instead of BR-RC. When an NSF Receipt is processed in a multi-currency company and REGL amounts are calculated, this portion now has the source code for the GL transaction as BR-NS instead of BR-DP. The rest of the GL Transactions created by posting batches will continue to use the BR-DP source code.

    ·        When a deposit or receipt is reversed from bank reconciliation, behavior is now similar to processing NSF Receipts but with no extra charges. Paid invoices or other applied transactions are now restored for Receivables customers, and a batch is created to reverse the accounting created by the customer receipts.

    ·        NSF Processing for customer receipts has been removed from the Bank Inquiry function and is now available as a separate Maintenance function for NSF Receipts. Customer receipts can be searched for and NSF transactions can be created as part of a list, and printed on a NSF List report. NSFs can be multi-selected from the grid for creating the BankRec batch with NSF Fees and receipt reversal transactions, and a posting journal report is available to print the NSFs processed.

    ·        In Reconciliation for Cleared with Error entries, an Error account may be set on the Reconciliation detail. NOTE: If the detail is for an entry that came from Payables, the BankRec Bank, Interface tab must be set to 'Update Payables Check Reconciliation' with 'Completed' or 'None'.  If the setting is 'Pending Status', the Bank Error account from the Payables Bank will override the account selected in BankRec Reconciliation.\\\\\\"

    ·        For the purpose of reconciling a portion of the deposit instead of the entire deposit, deposit transactions can now be Split into two transactions within the Reconciliation window.

    ·        When a bank statement was imported into Bank Reconciliation and some transaction matching performed, closing the Reconciliation window would delete the matched transactions. Now all imported transactions with pending status changes will remain until the reconciliation is posted. A new Purge Deleted button is available to remove imported bank transactions that you have Deleted without having to wait until a reconciliation is posted. This is useful when an import was done in error and has to be removed and redone.

    ·        An option is now available to suppress the question for immediately posting the batch created from non-matched reconciliation transactions imported from the bank.

    ·        Bank Reconciliation now allows entering a Cutoff date to hide all transactions with a more recent date. This will assist when reconciling and matching imported bank transactions and only display records likely to be matched.

    ·        When reconciling an imported bank statement, pressing the F9 key will automatically refresh and hide all matched transactions, without having to use the mouse to click the Hide pending status checkbox.

    Edits

    ·        Vendor email addresses are now available for finding vendors, either from the vendor list or within transaction entry. This includes using the new advice or alternate payee email addresses and, if multiple emails separated by semi-colons are stored in a single email field, then any one can be used for finding the vendor.

    ·        Distribution Sets now allow you to distribute a single amount to multiple expense accounts based on a percentage rather than calculating and entering the amounts manually. An ‘Allocation %’ field has been added to the Distribution Set Detail screen. In addition, you can specify a default Allocation Amount in the Distribution Set to be allocated for each detail based on the percentage. You may now configure Distribution Sets to Skip Zero Detail Lines, so that details for a zero amount will not be added to the batch entry.

    ·        You can now leave the GL Account/Department fields blank in a Distribution set, similar to a Distribution, and the Acc/Dept will default from the vendor.  This saves you from having to set up a different Distribution Set for each expense Acct/Dept pair used.  NOTE:  The ‘Auto-distribute’ option cannot be used if the Acct/Dept is blank for any Distribution in the Distribution Set.

    ·        In Edit Styles, it is now possible to limit the list of Adagio Styles to those that are App specific and Generic. Make sure the program prefix is the first 2 characters of Style code description. If this option is selected, when you create a new filter, the Style codes available will be limited to match the application prefix.

    ·        Email Cover sheets have new fields available for updated customer and receipt addresses and company profile information.

    ·        SalesCQ quotes are now shown on the Transactions tab in Edit and View Customer if SalesCQ data is present. Notes: Drilldown to SalesCQ transactions screens is not available - that is only available in Edit Customer in SalesCQ. item numbers are not formatted and show quantities with 2 decimals. The Quotes tab is only available in Edit Customer in SalesCQ.

    ·        If a period end date is changed to a date later than the system date, a warning message will appear to confirm this before allowing you to continue.

    Printing forms & Designer

    There are many new specification codes with this upgrade to BR9.3A.  Please refer to the BR$AllSpec.sam  (!ALL codes to June 2020) spec.

    ·        User Preferences now has 'Remember form settings?' for printing receipts. Another feature is that Favorites can be created Receipt form printing.

    ·        In the Form Designer, added Blank on Zero (property on amount fields). Corrected a problem where the preview of checks to an Ultra High-Resolution screen displayed shrunken in the upper left of the screen. The preview from the Specification Designer was also corrected.

    ·        In Print Receipts, the last Email Cover Sheet used to print Receipts is now remembered by User.

    ·        ** DO NOT ADD TO DOCSTORE ** has been added to the ALL specification so that test prints are not added to DocStore.

    ·        For Receipt Printing, Formatted Address specification codes have been added to the Designer for the Company Profile, Banks and Receipt Addresses.

    ·        Addresses in bank records and receipt batch entries now support the Formatted Address configuration, which can also be printed on receipt forms.

    ·        Receipt Printing Specification Codes,

    H48, address line 1 (formatted)

    H49, address line 2 (formatted)

    H50, address line 3 (formatted)

    H51, address line 4 (formatted)

    H52, address line 5 (formatted)

    H53, address 6 (formatted)

    H54, address 7 (formatted)

    H55, Optional text 1

    H56, Optional text 2

    H57, Optional text 3

    H58, Optional date 1

    H59, Optional date 2

    H60, Optional amount 1

    H61, Optional amount 2

    H62, Optional units 1

    H63, Optional units 2

    H64, CC Last 4 digits

    H65, CC Short name

    H66, Expiry date

    H67, Vault ID

    H68, CC Trans Id

    H69, CC Authorization

    H70, Name (line 2)

    H71, Name 1 + 2

    H72, Comments 2\\\\\\"

    H73, City

    H74, State/Province

    H75, Country

    H76, City, State/Province, ZIP/Postal (formatted)

     

    ·        New Spec Code for APS Payments - H81, Payment Method.

    ·        New Spec code for Credit Card Name - H82, CC Name.

    ·        New Spec code for Detail Units - D20, G/L unit amount.

    Reports

    ·        Finders have been added to the Receipt number fields for the Receipt Audit List report, to look up records found in Receipt History and more easily select the receipts to print.

    ·        For PDF report printing, the %btt Expansion code for Batch Type may be used to differentiate between Open and Archive Batches for Batch Listings and Batch Status reports.

    ·        The batch listing report supports printing either the first, second or both descriptions from each entry.

    ·        When Adagio DocStore is integrated, report sets can now be emailed to selected recipients, with PDF or Excel file attachments for each report.

    ·        Receivables Payment methods are now printed on the Batch Listing.

    ·        The Tax Tracking report has been improved.  Receipts and Payments can be reported separately. 

    ·        Printing the second description field on the Ledger Transaction Batch report can now be selected as an option.

    ·        Added an option to print a General Ledger Distribution Summary on batch listings.

    ·        Suppressing the Home Equivalent Balance on the Bank Reconciliation report now also suppresses the Home amount column of the Cash Balances Summary section.

    ·        The Deposit Slip report now separates Checks from Cash in Payment method groups and totals.

    Miscellaneous

    ·        If a user has access to the Maintain Automation Log feature, they also can view all the automation logs for any user.

    ·        New automation command nouns have been added to allow attaching report set PDF/Excel files to the email with the automation log results, to allow reports from multiple applications to be attached on a single email. The EmailPDFAutoLog has Overwrite/Attach and Append/Attach nouns to include PDF/Excel files from report sets. The 9.3A release of Adagio Console is required to use this feature.

    ·        If a Period End date is changed to a date later than the system date, a warning message will appear to confirm this before allowing you to continue.

    ·        Year End will clear the Batch Status report and Re-sequence archive batches automatically, along with resetting Current batches to 1.

    Import/Export

    ·        Importing bank statements in Reconciliation now supports defining Excel formatted files in addition to CSV and OFX formats in Edit Banks. Previously, an Excel-formatted file was imported directly from the Import Bank Statements menu only.

    ·        Import Deposits has new fields to support Receipt Printing: Hdr-Print Receipt and Hdr-Receipt Number as well as Receipt Address and Contact fields.  Please refer to the Import File Format Requirements in the online Help or the Tech-tip.

    ·        Import Payments has also been enhanced with new fields, etc..  Please refer to the Import File Format Requirements in the online Help or the Tech-Tip.

    Problems Fixed

    ·        When the Bank Transactions report was sorted by Date, the running Balance column values may have been out of synch with the respective transactions, depending on the transaction groupings. This has been fixed.

    ·        When entering a check reversal in reconciliation, saving the change now warns about the date if it is within a closed Ledger fiscal period, in addition to the same warning that is given when posting reversals.

    ·        NSF Receipt entry and posting now correctly supports the Validate closed periods option in the Company Profile.

    ·        When entering an NSF Receipt for a customer that has a different currency than Home, and the NSF Date is changed, the exchange rates are now updated for the customer and bank fees based on the new NSF Date.

    ·        The spec code B16 for the Bank email address has been expanded to 160 characters.

    ·        Entry of Company number in the Company Profile will now be limited to 6 characters. To 8match, in the Receipts Designer, M17 Company I.D number has been renamed M17 Company number. A new specification code has been added for the new ID number field: M24, Company I.D. number.

    ·        When searching for posted transactions using the Find procedure, if you typed an invalid Bank Reference value for searching, a transaction would still be highlighted or viewed and likely was not the desired transaction to find. Now, an error message will appear indicating that the Bank Reference value does not exist.

    ·        Entering an invalid Bank Reference value in the Find procedure for posted transactions now gives a message indicating this.

    ·        A View button has been added to the Statement Rule Validation screen, to give the same functionality as when double-clicking on a row in the grid, but with more visibility and clarity of results.

    ·        The Matched reconciliation status is maintained when comparing posted transactions to imported bank transactions in Bank Reconciliation. When a Matched record pending status is reset, the matching records from the other side of the Reconciliation window are automatically reset at the same time.

    ·        The Receipt Audit List report now prints the correct receipt amount if a discount had been taken for one or more paid invoices.

    ·        When Deposit batches are copied and the bank supports a deposit ID by incrementing sequence number, the new batch will use the next sequence number for the deposit ID.

    ·        Printing the Batch Status report no longer gives a prompt to purge the batch status data.

    ·        When the new option to set Retrieved batches as Ready to Post is not enabled, this does not allow auto-posting batches after retrieval and will suppress the question that gives the user the choice to do so.

    ·        The Alt-X accelerator for ExcelDirect did not work from within a Payment or Receipt Entry.

    ·        Selecting ExcelDirect from within a batch entry was opening 2 Excel Workbooks.

    ·        If a check reversal was posted while other imported bank transactions had already been matched, those matched imported transactions would have been purged. Now only the check reversal is processed, and the rest of the reconciliation remains untouched.

    ·        You may choose to select more than one send method when printing receipts, and create forms in all selected methods for Print, Email, Fax and PDF when you don't choose to Match the customer's Preferred Send Method.

    ·        The Bank Transfer batch entry screen has changed, where both the From and To bank codes can be selected, instead of using From/To radio buttons, for greater clarity. Verification is in place to ensure that one of these selected banks is the same one associated with the batch.

    ·        Finder / Smartfinder was showing a Character string instead of 'Linked' for the Doc Link field in some cases.

    ·        Statement Rules now have an option to exclude imported bank transactions that match this rule from being auto-matched to posted transactions, even when the dates and amounts are the same, to prevent accidental matching to wrong transactions.

    ·        If Allow Check Reconciliation is disabled in Adagio Payables, opening the BankRec Bank reconciliation function will automatically enable check reconciliation in Payables. It is an incorrect setup to use BankRec and not also use Check Reconciliation in Payables.

    ·        Receipt and Payment batch entries now support the Ledger statistical unit field on distribution details, including using a default value assigned to the distribution code or set detail.

    ·        An error occurred if you had more than 9,999 batches in the same year. NOTE: The maximum number of batches allowed in a year is 99,999.

    ·        If the Receivables Payment method was set to Batch by date/type, the entries retrieved by BankRec 9.2A did not create a batch based on the type as well as the date.

    ·        Importing with Field offset was trimming the import field on the right instead of the left.

    ·        If a user retrieved Payables transactions in Adagio BankRec at the same time as another user was posting in Payables, it was possible for a second batch for the same transactions to be created. User resource locking has been enhanced so that either posting Payables payment transactions or retrieving into BankRec will prevent the other procedure from starting until it has finished.



Adagio BankRec
9.2A | 2018-12-16 (Dec '18)
  Go to top
Release Notes
Print This

    ·    If Adagio Receivables is 9.3A (2018.11.09) or higher, the BankRec interface in Payment Methods within A/R includes the new option ‘Batch by date/type’.  This option replaces and has the same functionality as what the old ‘Batch by date’ option in previous versions of A/R did (i.e. batches retrieved to BankRec are separated by date and payment method type). Enable the new ‘Batch by Date’ option if you want 'credit card' receipts posted in Receivables to be retrieved into BankRec batches separated by date only. A credit card deposit batch will contain entries for credit card receipts having the same transaction date. This will facilitate bank reconciliation.

    ·    If Adagio Receivables is 9.3A (2018.11.09) or higher, the BankRec interface in Payment Methods within A/R includes the new option ‘Deposit Only’. Enable the ‘Deposit Only’ option to have the individual deposit entries consolidated into a single amount on the bank reconciliation. For a bank deposit, consolidating these amounts can make the bank reconciliation easier. Disable the ‘Deposit Only’ option to have the debit entries pass to the bank reconciliation in detailed form (for example one amount per entry). For credit cards, there may be benefit in keeping the entries separate when the Payment Processor's cut-off does not coincide with the end of your organization's business day.

    ·    If Adagio Receivables is 9.3A, you can now use the Finder and Smart Finder on the customer grid in the Edit/View Customer functions when a filter is applied to search within the filtered grid.

    Problems fixed

    ·    When Receivables 9.3A is used, an error was displayed by the Find on the customer grid with a filter applied when you entered a customer code of less than 6 characters and pressed ENTER rather selecting the customer from the finder.

    ·    When Adagio DocStore is used, editing a customer and changing the Customer Name caused the error “DocStore error 10008” to be displayed.

    ·    When Adagio DocStore is used, copying a customer with PDF documents attached to it no longer copies the attachments to the new customer.

    ·    If a user was in the Retrieve Receipts function but had not retrieved from Adagio Receivables and another user posted cash in Receivables, transactions were missed by the retrieve in some cases.

    ·    If you open the Bank Inquiry function and view the details of a deposit, there is an ExcelDirect button but the button was missing when you viewed by opening the Reconciliation function.

    ·    If you enabled the TLS/SSL setting in Email Setup, it was disabled the next time you opened BankRec.

    ·    Importing a bank statement in the Bank Reconciliation function failed with errors on some records if you had imported a statement for a different bank with a lower sequence number.

    ·    The retrieve of batches to BankRec from PayDirt Payroll (or other third-party applications) showed no batches for retrieval when such applications were installed on a private Adagio Cloud. This was not a problem when the third-party application was installed on the local station and batches were retrieved to the cloud from the station.



Adagio BankRec
9.2A | 2018-02-09 (Feb '18)
  Go to top
Release Notes
Print This

    ·    Compatible with future release of Adagio Receivables 9.3A.

    ·    BankRec now supports transactions with Adagio DocStore links retrieved from Payables 9.3A and future release of Receivables 9.3A. It passes the DocStore document links in retrieved batches through to Adagio Ledger when the batches are posted in BankRec.

    ·    BankRec did not retrieve entries from Cash Batch postings in Receivables, in some cases, when there were consecutive miscellaneous (blank customer code) customer receipts with duplicate Check Numbers.

    ·    If ‘Validate closed periods’ is set to ‘Warn Only’ or ‘Disallow’, posting in Reconcile Bank will warn when there are ‘Reversed’, ‘Cleared with error’ or ‘Cleared with diff.’ transactions for closed Ledger periods.

    ·    The backup after a Data Integrity Check did not put the backup zip file in the correct folder in some cases.

    ·    Corrections were made to the Smart Finder for the Ship to Code on the Invoicing tab in Edit Customer when it did not find any records.

    ·    The tab key did not move to the buttons in the Edit Customer function after tabbing through fields on Customer or Accounting tabs.

    ·    Changes made to the grid on the Purchase Orders tab in the IC Item with Sales and Costs inquiry with the Column Editor were lost when the Edit or View Vendor functions were used in BankRec.

    ·    Import Bank Statements had an Access Violation error when importing a CSV file where the last record is missing the end of record indicator (a CR/LF). Previous versions of BankRec were able to import such files that are produced by some banks.



Adagio BankRec
9.2A | 2017-07-20 (Jul '17)
  Go to top
Release Notes
Print This

    ·    Compatible with and required by future release of OrderEntry 9.3A.

    ·    Compatible with Payables 9.3A and required by Payables 9.3A for compatibility.

    ·    The finder on the GL Department field is now restricted to the departments for the account selected.

    ·    The GL Department Description is now available to be added to the GL Account finder with the Column Editor.

    ·    Installs an updated version of the AdagioPDF driver. The updated driver name is AdagioV2PDF and will appear in Windows Control Panel, Devices and Printers. When installs are performed from a Remote Desktop Services connection to Microsoft Server 2016 or from a Windows 10 station, the security warning related to the AdagioPDF printer driver no longer appears.

    ·    Dialogs are rendered properly on Ultra High Resolution displays when the font size is anything other than 100% of normal on Windows 8.1 or higher.

    ·    Corrects a problem where the preview of receipts to an Ultra High Resolution screen displayed shrunken in the upper left of the screen. The preview from the Specification Designer was also corrected.

    ·    When Payables 9.3A is used, posting a reconciliation that includes a reversal of a Payables check when the Update Payables Check Reconciliation in the Bank was set to ‘Completed’ caused an error when retrieving the Payables batch in Ledger 9.3A and the batch could not be retrieved. If the option was set to ‘Pending Status’ or ‘None’ there was no problem.

    ·    When you are in the middle of printing and/or consolidating/clearing the GL Transaction batch report, other users are prevented from retrieving the batch in Ledger until you complete the process.

    ·    For the %CMP code (Company Name) used by Adagio ePrint for folder names, spaces and other allowable punctuation characters are no longer stripped out.

    ·    When Payables 9.2B or 9.3A is used, the Payables Bank Code finder in the BankRec Bank did not show any of the banks in Payables and displayed the error: “There is no data for this field”.

    ·    Corrected problems on Adagio Cloud that occurred in some cases when retrieving batches from PayDirt Payroll™ on your local machine.

    ·    When importing payments, if the import file contained different values in the Application field (which is not permitted), the import did not complete successfully. The import now checks for multiple different values in the Application field and will fail verification and refuse to import.

    ·    The setting 'Ignore last x footer lines' in import bank statements was also affecting import deposits.

    ·    If a Bank does not have the ‘Electronic reconciliation’ option enabled, importing a bank statement to validate statement rules for it anyway resulted in damaged data. This is now prevented.



Adagio BankRec
9.2A | 2016-11-21 (Nov '16)
  Go to top
Release Notes
Print This

    ·    Corrects problem in BankRec 9.2A (2016.10.29) when used with Payables 9.2A. The message "Error 1212 occurred when attempting to check existence of Check Rec Posting Journal." occurred when posting a Reversal if the option to update Payables Check Reconciliation was enabled for the Bank. The reversal completed and updated BankRec, Payables and Ledger. However the reversal was missing in the Payables Check Reconciliation Posting Journal. The problem did not occur for Payables 8.1x or future Payables 9.2B.

    ·    When entering a payment in BankRec 8.1B (2010.08.18) or higher, if you typed over “AUTOASSIGN” in the Check Number using more than 10 characters and saved the entry, when you added another entry to the batch an error was displayed.

    ·    When Adagio ePrint is used, if the Lock PDF option was on, the ePrint option ‘Open PDF document’ for reports did not work. The PDF did not open when you clicked the ePrint button.

     ·    Installs a new Adagio Data Source (ADS) that prevents resource locking problems at large Adagio sites running 9.2 versions and improves application performance at these sites.


    NOTE: All third-party applications from Adagio Developer Partners must use the new ADS. You must check with your Adagio consultant or the developer to confirm their application is using ADS 1.12. 66.3503 or higher. Failure to ascertain this risks corrupting data if the application is writing to the Adagio data files concurrently with Adagio modules.



Adagio BankRec
9.2A | 2016-10-29 (Oct '16)
  Go to top
Release Notes
Print This

    ·    BankRec 9.2A (2016.10.29) supports future release of Adagio Payables 9.2B and will be required by Payables 9.2B for compatibility.

    ·    Added ExcelDirect in Vendor Edit/View on Transaction Details grids for Applied Details and G/L Distribution Details. Available only if you have Payables 9.2A or higher.

    ·    The Column Editor is now available in Vendor Edit/View on Transaction Details grids for Applied Details and G/L Distribution Details. Available only if you have Payables 9.2A or higher.

    ·    The Edit/View Vendor functions in PurchaseOrders now respect the ‘Edit Vendor SIN/FIN’ option in Security Groups.

    ·    Copying text containing a tab character to the Reference field is prevented in batch entry.

    ·    Reference numbers auto-generated for payments and receipts in batch entry now include the year to avoid duplicates from previous years.

    ·    BankRec 9.2A (2016.06.06) added support to interface to a locally installed version of PayDirt Payroll™ from BankRec on Adagio Cloud.This required a resource file to be manually placed in the data folder on Adagio Cloud. The resource file is now automatically recognized by BankRec when it exists on the local machine. PayDirt Version 2016.Jul.v08 or later is required to create the required resource file in the correct folder on the local machine.

    ·    Reversing a check in BankRec where there was a duplicate check in Payables for the same vendor, date and check number reversed both checks in Payables in some cases.

    ·    Statement Rules for vendors now correctly support Distributions from Payables.

    ·    After installing Ledger 9.2B (2016.08.10) or SysUpdater (160809), temporary files created on workstations by printing reports were not deleted in some cases, although this did not cause any problems.

    ·    For MultiCurrency databases, the batch listing showed the total of all entries in the Total Payments line, rather than separated into the various payment types.

    ·    The email password for servers that require authentication is now encrypted in the file containing email settings for the ‘Direct’ email method.

    ·    Installs a new Adagio Data Source (ADS) that prevents resource locking problems at large Adagio sites running 9.2 versions and improves application performance at these sites.

    NOTE: All third-party applications from Adagio Developer Partners must use the new ADS. You must check with your Adagio consultant or the developer to confirm their application is using ADS 1.12. 66.3503 or higher. Failure to ascertain this risks corrupting data if the application is writing to the Adagio data files concurrently with Adagio modules.



Adagio BankRec
9.2A | 2016-06-06 (Jun '16)
  Go to top
Release Notes
Print This

    ·    Updated for Adagio Cloud.

    ·    Supports interface to local PayDirt Payroll from BankRec on Adagio Cloud.

    ·    The bank statement from BMO Bank of Montreal in OFX format could not be imported.

    ·    The ‘Skip first X lines’ and ‘Ignore last X lines’ options did not work for Bank Statement imports if the import file was an Excel file.

    ·    If you had multiple checks for the same vendor, with the same check number and date (which is allowed but would usually be a data entry error), the first instance of the check could be reversed but other instances could not and there was an error incorrectly stating the check was not on file.

    ·    In BankRec 9.2A, reversing a Payables check did not reinstate the invoice(s) it paid if they were in Payables history, and caused the Data Integrity Check to report errors that could not be rebuilt.

    ·    The Bank Account Number did not display on the Balances Inquiry or Reconciliation grids.

    ·    If you have PurchaseOrders 9.2B, the Vendor Edit / Inquiry functions did not display the purchase order details on the Transactions tab. 

    ·    Additional comments on the Notes tab in View Customer did not refresh properly in when using Next/Previous.

    ·    Added ExcelDirect to the batches and batch details grids.

    ·    When the deposit exchange rate was changed on the New Batch dialog, the rate in batch entries within the batch did not default to the changed rate.

    ·    The date entered on the New Batch dialog is now used to form the Bank Reference for Deposit Only batches rather than the session date.

    ·    When entering a miscellaneous cash payment (i.e. no vendor code), if you added a detail with a G/L Account/Department then added a detail using a Distribution Code, the Account/Department on the first detail was overwritten by the Account/Department from Distribution.

    ·    The Customer Name was blank on the Cash Batch Listing in Adagio Receivables for batches created by BankRec.

    ·    If you attempted to print the Reconciliation Posting Journal after running Year End which clears posting journals, the error “Unable to open data file Check Reconciliation Posting Journal” was displayed instead of a message saying there is no posting journal to print.

    ·    The Cash Balances Summary at the bottom of the Bank Reconciliation report, when printed backdated, had incorrect amounts for source currencies if there were transactions cleared with error.

    ·    Several minor corrections were made to various reports in BankRec 9.2A.



Adagio BankRec
9.2A | 2015-06-30 (Jun '15)
  Go to top
Release Notes
Print This

    ·    The Edit and View Customers/Vendors functions have been updated to the most current functionality in Receivables and Payables 9.2A.

    ·    BankRec 9.2A did not show transactions for Invoices9.2A in the Edit / View Customer functions.

    ·    In the Edit and View Customer functions, when used with future 9.2A version of Receivables, changing the Sort By selection on Transactions tab from Date to Type/Doc No did not sort the grid.

    ·    In Edit Vendor, when used with future 9.2A version of Payables, BankRec gave an error when the vendor was saved if the Invoice Number Format fields contained certain formatting characters.

    ·    In BankRec 9.2A when integrated with Payables 9.2A, if the option to show Active Records Only was set on the Edit Vendors grid, the wrong vendors were displayed.

    ·    When adding a vendor for Payables 9.2A in BankRec 9.2A, the finder on the Tax Group field in PO Options displayed the error ‘There is no data available for this field’.

    ·    Viewing a PDF of an invoice that was created by Adagio PDF and then appended with scanned documents caused the Adagio PDF Viewer to crash in some cases. This has been corrected. However, the Viewer may not show the scanned PDF correctly. This will be corrected in a future release. In the interim, the document can be opened from your default PDF viewer by clicking the lower leftmost button on the Adagio Viewer.

    ·    An error occurred if you had 2 copies of BankRec open with both in the retrieve function.

    ·    If a user retrieved Payables transactions in Adagio BankRec at exactly the same time as another user was posting in Payables, it was possible to for two batches for the same transactions to be created in some cases. This is now prevented providing Payables is 9.2A (2015.06.09).

    ·    A Payment Reversal included as part of a Reconciliation and not posted separately using Post Reversal created Ledger entries for the Reversal entry using the Statement instead of the date option selected for the Reversal (Check date or Login date).

    ·    If the ‘Update Payables Check Reconciliation’ option in a bank is set to ‘Completed’, the Reconciled Checks Posting Journal in Payables showed the session date from BankRec as the reconciliation date instead of using the Statement date for a Cleared with Error transaction.

    ·    The performance of the Bank Reconciliation report has been significantly improved when printed for a large number of transactions across a network and in particular when backdated.

    ·    In BankRec 9.2A, the Bank Transactions report displayed Changed Date of 12/31/1899 if the field was blank.

    ·    In BankRec 9.2A, the Reconciliation Worksheet report printed 12/31/1899 for Last Statement Date if the field was blank.

    ·    In BankRec 9.2A, the Reconciliation Posting Journal displayed an error and did not print if the ‘Print G/L dist summary’ option was not enabled.

    ·    BankRec allowed posting journals to be cleared. This is now prevented until Year End, as in other modules.

    ·    In BankRec 9.2A for multi-currency databases, the Home amounts on the Bank Transactions report printed too small by a factor of 100.

    ·    In BankRec 9.2A, the G/L Transaction report and the G/L Summary on the Batch Listing and Posting Journal were sorted incorrectly if you use G/L Departments, depending on the configuration of your Chart of Accounts.

    ·    In BankRec 9.2A, some reports displayed an error similar to “Cannot open file \\\"\DATA\BRxxnnnnR.DAT\\\". The system cannot find the file specified.” on systems with many Windows users (approximately more than 100).

    ·    Added new specification code for receipts:
       C75 City, State/Province, ZIP/Postal (formatted)

    ·    The ‘Print BR Receipts’ option in the customer and the ‘Request Receipt’ (for all customers) option in the Receivables Company Profile were not respected if the ‘Print receipts by default’ option was disabled in the BankRec Company Profile. This was also corrected when importing a deposit batch.

    ·    If the ‘Check for duplicates’ option is enabled, when multiple NSF transactions are to be created where the same check number is used on separate receipts, there is now a warning that there is a duplicate Reference that must be corrected before generating the NSF batch.

    ·    In BankRec 9.2A, if you previewed receipts and then printed them from the preview, there was an Access Violation error.

    ·    In BankRec 9.2A, printing a receipt for a specification file with ‘# of Copies’ set to more than 1 displayed the error “List index out of bounds”.

    ·    A fix made in the BankRec 8.1E (2013.11.27) Hot Fix that corrected problems importing bank reconciliation files in OFX format from certain banks in some cases was not included in BankRec 9.2A.

    ·    BankRec 9.2A installed the Designer help for 8.1E.

    ·    Creating a new database now sets the 'Prompt to consolidate GL' option to disabled.

    ·    The Data Integrity Check (DIC) saves results for the last 9 previous runs in files BRWINERR01…09.dat (where .dat is your company data file extension). The current DIC information will always be in BRWINERR. If you do check/rebuild/check without closing the DIC function the results are appended to the same file.



Adagio BankRec
9.2A | 2014-12-18 (Dec '14)
  Go to top
Release Notes
Print This

    ·    Compatible with and required by future release of Adagio Payables 9.2A. Earlier versions of BankRec will not open if Payables 9.2A data is present. The Edit and View Vendor functions in BankRec support vendor changes in Payables 9.2A. These functions and payments in Batch Entry support the module and function-specific Alerts added for 9.2A. BankRec 9.2A remains downward compatible with earlier versions of Payables.

    ·    Adagio BankRec 9.2A now installs to the \Softrak\BankRec folder and the program name is BankRec.exe. Previous versions were installed in \Softrak\BRWin and had program name BRWin.exe.

    ·    You can now start other Adagio modules from toolbar buttons showing the icon for the module. This allows easy switching between Adagio modules. If a module is running against the same company data, Adagio will now just switch to that running instance, rather than launching a second instance. Toolbar buttons can be rearranged under File | User preferences, or by dragging the buttons around or off the toolbar itself.

    ·    Adagio BankRec now logs user activity within the module, including login, menu choices and batch New, Edit, Copy, Delete and Post. Audit logs may be viewed with GridView.

    ·    The Edit / View Customers / Vendors grids now display the total number of records, as well as a count of the displayed records when a Filter is active. An Ignore Style Color button has also been added. Click this button to toggle the grid between no color and Style colors or no color and banding (if it is enabled in User Preferences).

     


    ·    Grids may be “banded” with a User Selectable color and banding frequency set under File | User Preferences. Filter Styles may be disabled and replaced with regular banding if desired.

    ·    The status bar at the bottom of the main window now shows activity of various steps when the program is starting up and the database is opening.

    ·    Supports Transport Layer Security (TLS) / Secure Socket Layer (SSL) for secure email servers when emailing receipt documents. Added option 'Use TLS/SSL' added to Email Setup function.

    ·    The number of Previously Opened databases (saved by user) has been increased from 25 to 100.

    ·    Updated splash screen with new Adagio logo and colors. Updated icon and toolbar button images.

    Batch Entry and Posting

    ·    For Deposit Only batches, the receipt date was used as the date for GL transactions. The Deposit date is now used. If ‘Consolidate Bank Transactions’ is enabled in the Company Profile, there will be a single distribution to the Bank Account for the Deposit amount and multiple transactions to the offsetting accounts for each receipt. This allows easier reconciliation from Ledger to BankRec.

    ·    If you edit a Deposit Only batch and add a new receipt with a date later than the original Deposit Date, the Deposit Date of the batch will be automatically updated to the later date. The Deposit Date is also updated if you edit the date of an existing entry to a later date and if you retrieve and append transactions with later dates to an existing batch. Import Deposits also uses the latest receipt date as the deposit date.

    ·    For multi-currency databases, foreign currency banks can have a different Rate Type for deposits and payments. The Bank tab in Edit Banks now has Bank/Payment Rate Type and Deposit/Receipt Rate Type fields. Batches retrieved from Receivables, imported batches and batches created in reconciliation for imported bank statements (that cannot be edited to adjust the rate) now use the new Deposit/Receipt Rate Type.

    Ledger Interface

    ·    BankRec 9.2A is fully compatible with the new feature in the Ledger 9.2A Retrieve Subledger Batches function, allowing separation of subledger batches on retrieve by Posting Sequence or Batch Number. For earlier versions of BankRec, if the subledger batch contains transactions for reversed checks, checks cleared with error, or NSF Checks, the Retrieval file cannot be separated by Batch.

    Receivables and Payables Interfaces

    ·    For Adagio ePrint users, the Edit/View Vendor and Edit/View Customer functions in BankRec now support viewing PDFs of purchase orders and invoices.

    ·    If you retrieve receipts from Receivables to a ‘Deposit-Only’ batch, the Deposit Date of the batch will be set to the latest date of any transaction retrieved.

    ·    Supports new ‘Batch by entry’ option in Payment Methods in future 9.2A version of Receivables when receipts are retrieved (including payments originated in Adagio OrderEntry and Invoices). A new deposit batch is created for each receipt. Use this option to separate payments received by EFT into individual batches in BankRec.

    ·    Supports new ‘Print BR receipts?’ option on the Invoicing tab in customers added in future 9.2A version of Receivables. This enables the ‘Print Receipt’ option for receipts retrieved from Receivables, transactions entered in BankRec or generated in reconciliation, allowing you to selectively control which customers will have receipts printed in the BankRec batch.

    ·    Supports new ‘Sort by’ option on the Transactions tab in customers added in future 9.2A version of Receivables. This new option allows you to sort by date when transactions for both current and history are selected for display.

    ·    The Edit Customers function supports the new option ‘Require PO?’ on the Invoicing tab added for future 9.2A version of Receivables. Used to require you to enter a purchase order number in the PO Number field on the Header tab when entering an invoice in other modules.

    Reports

    ·    Adagio BankRec’s standard reports are now created using Crystal Reports 2013, replacing the Crystal Reports 8.5 Print Engine (CRPE32.dll). The module’s management reports are now stored in \Softrak\BankRec\StandardReports. Revisions to these reports should be placed in \Softrak\BankRec\ModifiedReports. Custom reports to be added to the Reports menu should be stored in \Softrak\BankRec\CustomReports. Reports must be edited or created using Crystal Reports 2011 or 2013 and Adagio ODBC for access to the data files. Users will notice minor changes to some of the visual elements in the module and a new Print Preview window. The size and position of the Print Preview window are now remembered between sessions by user, so the Workstation options controlling this function have been removed. Exporting to an Excel spreadsheet from the print preview window has been significantly improved. Refer to the online Crystal help for details. The Report Tables Drive settings and Crystal tables in the \QRASP folder are not used by version 9.2A modules.

    ·    An updated version of Adagio PrintTool (PT) is installed in \Softrak\PrintTool. PT allows you to print / preview custom reports without needing to run Crystal Reports itself or without placing the report on the Custom Reports menu in an Adagio module, and allows reports to be placed on the Windows desktop. PrintTool 9.2A prints custom reports created with Crystal Reports 2011 or 2013 only. Adagio ODBC must be installed to create custom reports but is not required to print custom reports. Your Adagio dealer or consultant can create custom reports for you and deploy them at your site. PT allows you to specify a report to print on the command line using the /r parameter. This allows Adagio automation batches to print custom reports (to printer – a future release of PT will allow automation batches to print custom reports to PDF). PT does not require registration with Softrak Systems but does use Adagio Lanpak licenses. Note: PT does not print reports created with Crystal Reports 8.5 for Adagio. Existing version 8.5 custom reports must be converted before they can be printed by 9.2A.

    ·    New ePrint code %CDT is available to put the Calculate/Aged as of date into either the PDF filename or folder name for reports such as Bank Reconciliation, Bank Transactions and Cash Flow.

    ·    You can now have a Report Favorite for the Deposit Slip report. This allows you to save the Bank and the printer location. However, as a Bank Reference must be entered when the report is printed, the report cannot be used in a Report Set.

    ·    The System Status function (chksys.exe) does additional checking of the Crystal Reports runtime and Adagio ODBC drivers used to print reports in Adagio 9.2A.

    Problems Fixed

    ·    BankRec 8.1E (2013.11.27) corrected the message BankRec displayed if you attempted to import a bank reconciliation file in OFX format where a block within the file exceeded a size limit. This happened for some banks that removed CR/LFs from their version of the file. However, this caused a problem with size limits of the file that could be imported. The limit has now been removed and most or all large files can now be imported.

    ·    BankRec 8.1E (2013.11.27) corrected a problem in earlier releases of 8.1E when Importing Payments where the GL Account and Department, and the Distribution Code could not be imported (were set to blank). The correction did not work in some cases.

    ·    For checks reversed in BankRec, the G/L distribution details for transactions viewed in the vendor were displayed 100 times larger than actual. This was a display issue only.

    ·    When using the Validate function within Statement Rules to import a bank statement file, if you used Make Rule for an imported record, the finder was not active on the GL account, Distribution, bank, customer or vendor fields.

    ·    When entering a GL Account / Department, validation did not work and no warning was given when you entered a Department that did not exist for an Account if that Department did exist for the next highest Account. For example, you had account 8000-150 and the next account in the chart is 8001-250, then entering 8000-250 did not give a warning.

    ·    If a Payables check was reconciled with a Cleared with Error status using the Completed integration option in the Bank, and you logged into BankRec with a date different than the reconciled statement date, the date of the transaction sent to Ledger from Payables was incorrect. This could result in the date of transactions sent to Ledger by BankRec and Payables being in different periods or fiscal years.

    ·    Checks cleared with error in BankRec for banks configured with Update Payables Check Reconciliation set to ‘Completed’ caused the Data Integrity Check in Payables to report orphan details in the Transaction GL Details file.

    ·    Payment and receipt entries in batches created in reconciliation for vendors / customers that are not in the bank currency, used currency information from the bank rather than the vendor / customer and thus were not converted from the bank currency in some cases.

    ·    Import in header/detail format of receipts for customers not in the bank currency used the wrong rate type if these fields were not contained in the import template.

    ·    Email codes were not expanding in the email subject.



Adagio BankRec
8.1E | 2013-11-27 (Nov '13)
  Go to top
Release Notes
Print This

    Enhancements and revisions in Adagio BankRec 8.1E (2013.11.27) SP2

       Reversed checks now appear (or not) correctly on the Bank Reconciliation Report in all cases when the report is backdated.

       When you attempt to import an OFX file that is too large (greater than 65 Kilobytes), BankRec now displays a message saying the file is too large rather than a message indicating an error in the file.

       In BankRec 8.1E, when Importing Payments, the GL Account and Department, and the Distribution Code could not be imported (were set to blank).

       When a backdated or future dated receipt more than 30 days from the deposit date is entered in a batch, you now get the warning message "Deposit date will be Date displayed in View Bank Transactions & Reconcile Bank Transactions". If the date is also 30 days from session date, a second warning message is displayed indicating the date is more than 30 days from today's date (this message was already in previous versions of BankRec).

       BankRec 8.1D and 8.1E, importing Detail Only Deposits was affected by the Import Bank Statements option 'Skip first n lines'. This has been corrected.

       The bank transfer 'From' batch created by Reconciliation was updating the incorrect accounts. The debit or credit was correct for the bank generating the transfer (that is the bank that is being reconciled), but the GL account for the other side of the entry that should been the account for the other bank was set to the AR BankRec Clearing account.



Adagio BankRec
8.1E | 2013-08-28 (Aug '13)
  Go to top
Release Notes
Print This

    Enhancements and revisions in Adagio BankRec 8.1E (2013.08.28)

    Problems Fixed

       The Data Integrity Check no longer reports an error if the Receipt History or Statement Rules files do not exist.



Adagio BankRec
8.1E | 2013-08-11 (Aug '13)
  Go to top
Release Notes
Print This

    Enhancements and revisions in Adagio BankRec 8.1E (2013.08.11)

    New Features

       Several new options to control auto-matching of transactions imported electronically from your bank have been added.  Set these options in the Edit Bank function on the Interfaces tab. In previous versions, as long as the amount matched and the clearing date was after the check date, and there was only one outstanding check with that amount, the entry was auto-matched. However, in some cases checks could be incorrectly auto-matched and cleared. The new auto-matching rules can be set to prevent this from occurring and, in some cases, provide more auto-matching flexibility.

       BankRec can post reconciled Payables checks directly to the Payables Check Reconciliation. On the Interface tab in Edit Bank, select 'Completed' option in the 'Update Payables Check Reconciliation' section. In previous versions BankRec could update Payables with the pending status. Now it can post the reconciliation directly in Payables so you do not need do so manually. Reversed checks are therefore automatically reinstated in Payables when posted in BankRec.

       You can now edit the Last Statement Date for any previously posted reconciliation. This allows you to correct a mistake made where the wrong statement date was entered, even after posting the reconciliation. If a future date was accidentally entered as the statement date you could not post your next reconciliation with the its correct statement date as that date would be older. Use the new Update Statement Date function in the Maintenance menu.

       You can now edit both the Opening Balance and Last Statement Balance for a newly created bank as long as there has not yet been any transaction processing.

       Added the Next Sequence field on the Series tab in the Edit Bank function for use when 'Auto transfer on posting' is enabled for the bank (often used for your Amex or Telpay banks). In previous versions, posting an auto-transfer batch created a Reference number in the format "AT-{Batch number}/{Entry number}" in the batch for the target bank. With this method it was possible for a duplicate of a reference number for a previous year to be generated, creating an error when the batch was posted. To avoid the possibility of a duplicate reference enter a sequence number in the new field. Sequences must in different ranges if multiple banks auto-transfer to the same target bank. If Next Sequence is set to zero, the existing format (old method) will be used instead of a sequence number.

       BankRec now supports the option 'Alphanumeric manual check numbers?' on the Batch/Vendor tab in the Company Profile in Adagio Payables.

       Added default fields for the Payroll Bank and Payroll Clearing Acct on the Interfaces tab in the Company Profile. Entering defaults for these fields save you from having to enter them each time you retrieve from payroll in cases where the retrieve file does not contain them.

       Adagio ePrint users can view the customer copy PDF of invoices from transactions in the Edit/View Customer functions and PDFs of Adagio PurchaseOrders documents from the transaction grids in the Edit / View Vendors functions.

       You can attach documents (such as a promotional offer) to receipts in the email queue. Attachments are shown in a tree view on the Edit Email Entry dialog. Right-click on the tree to PDF, Word, Excel or other types of documents. Multi-select is supported, allowing you to add documents for all receipts in the queue.

       Supports Automation when Adagio Console is installed. Automation allows you to automate many functions in Adagio modules, including retrieving, posting, importing, printing reports and forms, backup and integrity check, etc. across modules, and view, print or email the results from an automation log. Adagio Console will be released at a later date.

       A 'Report set' button has been added to the toolbar.

       New splash screen with an updated look.

       Supports the Auto-fill GL account and department options in Ledger 9.1A.

       Batch entry supports Estimate styles in finders for Adagio JobCost 8.1C.

       Added 2 new expansion codes for Report Favorite filenames for Adagio ePrint users: %CMP (company name), %CNO (company number).

       Added BankRec specific Styles for use in filters. The default Filters (used when a new database is created) have also been updated. The sample data includes new Filters that make use of the new Styles. You can recreate any of the sample filters you find useful in your own live databases.

       The Data Integrity Check results now include the version/date of the program, for example: "Adagio BankRec 8.1E (1307??)".

       The Help | About function now has a Consultant tab showing the contact information for your Adagio consultant if they have enabled this option at your site.

       Excel Direct can now use Windows "automation" (inter-process communication) to send data to other spreadsheet applications, the same way it interfaces to Excel, allowing all formatting to be retained in the resulting sheet. OpenOffice 3.3 or later and LibreOffice® 3.3 or later are supported. This interface must be manually enabled. The file SSI2XL.INI must exist in \softrak\system and must contain the section [Initialization] with an entry <computer name>-UseOpenOffice=1, where <computer name> is the name of the machine that this entry references. Refer to the Readme Help for further details.

    Problems Fixed

       You could not import a statement in the Reconcile Bank function dialog if there are where no outstanding transactions to reconcile. The Import Stmt button was disabled unless there was at least one un-reconciled transaction on file.

       If you entered an incorrect password in the Open screen while logging into BankRec the program closed rather than allowing another attempt to login.

       Job Alerts did not pop up in batch entry in BankRec 8.1B, 8.1C or 8.1D.

       After saying 'No' to adding customer on the fly in batch entry, the program now returns to the Customer Number field.

       When entering a distribution detail for a cash invoice in batch entry the program allowed you to save the entry with a blank GL Account / Department.

       When creating a new multi-currency database or enabling multi-currency you must now enter a Default Rate Type.

       The %FPD and %FYR codes were not being saved in filename codes for Report Favorites.

       The posting journal for a payments batch retrieved from Payables, the entry type summary section had a Total Receivables field with an amount equal to the Total Payables rather than 0.00.

       The Description field entered in when reconciling (clear, clear with error or reverse) a Payables check in BankRec now flows to the Payables Check Reconciliation.

       Added the option 'Ignore last [xx] footer lines' to the Import Bank Statements function. This allows BankRec to import files that include trailing lines after the transactions.

       Added the option 'Ignore trans types not in file' to the Import Bank Statements function. This allows BankRec to import CSV files that include a variable number of records that must be skipped (such as Balance and Totals records) and therefore the 'Skip first [xx] lines' and 'Ignore last [xx] footer lines' are not sufficient. To use this option you must create a file containing allowable transaction record types. The file is BRImportTransTypes.ddd (where ddd is the company data file extension) and must be located in the data folder. You must also define a matching import template. Press F1 on this option in the import template to see the Importing Bank Statements topic in the help for further details. This topic includes a sample of the file contents for BMO Bank of Montreal. To use this sample, open Notepad, copy and paste the sample content, then save the file with the required filename in your data folder.

       You received an Access Violation error in the Import Payment function when importing in the Detail-only format in some cases if the Entry Number field was included in import the file (there was no problem if the field defined as a default in the template).

       The Bank Reconciliation report in 8.1D printed an extra row, just under the Opening Balance, containing 2 date fields and a Boolean, that should not have been there.

       The %BAT code was not being retained as part of the filename in a report favorite for the Batch Listing for Adagio ePrint users.

       In BankRec 8.1C and 8.1D, importing a bank statement from within the Reconciliation function (Import Stmt button) failed if negative amount fields used a leading minus or were enclosed in parentheses. Likewise, import failed from the Import Bank Statement function if negative amount fields used a leading minus (but worked for parentheses). Importing with a trailing minus or in OFX format worked in all cases.

       In BankRec 8.1D, if you opened a Bank Statement import template containing a date field with a 'User-specified' format, the format field became blank in some cases and your format was not remembered. When you did an import from the template screen it failed on the date field (although importing from the Reconciliation function worked using the same template).

       For Adagio ePrint users, the Report Type field was not displayed on report dialog screens for any user except SYS.



Adagio BankRec
8.1D | 2011-11-08 (Nov '11)
  Go to top
Release Notes
Print This

       Installs the AdagioPDF printer driver. All reports and printouts from Adagio can be printed to the AdagioPDF printer to create a PDF document in the data folder.

       Supports the features in Adagio ePrint. When ePrint is installed you can print reports to PDF files in configurable folders determined by the Report Type (General, Transaction or Audit). Receipts print to a separate, configurable Forms folder. Fields can be embedded to establish the file and folder names (User, Session Date, System Date, Time). Click the ePrint button (red "EP" icon) on any report dialog to print the report to PDF. The Paperless Reports option forces all reports to be printed to PDF. Reports can be printed to PDF and attached to an email (MAPI) with a single button click.

       Report Favorites allow saving Reports with specific options chosen. Click the Favorite button (a star icon) on any report dialog to create a Favorite. Favorites for a report can be accessed from the report dialog in a drop-down field. Private Favorites are yellow, Public Favorites are blue. Added Favorite Reports and Print/Delete Favorites functions to the Reports menu. Multiple favorites can be defined for the same report. Favorites can be private to the Adagio user or public for use by all users.

       Report Sets allow the grouping of Report Favorites into a single print job that will run unattended. Report Sets may be printed to printer or PDF files. Report Sets may be launched from a command file or a scheduled Windows task by running brwin.exe with the parameter /R followed by the Report Set (ex. /RMonthEnd). A progress dialog lists the reports in the Report Set, the printing status of each, the destination folder, filename and conflict strategy. A log is generated that records the printing status of each report in the set. Use Report Sets to automate the printing of all your daily or month end reports.

       BankRec supports the new 'Append by type' option for Payment Methods that will be added in Receivables 9.0C: Payment methods set to ‘Batch by date’ always created batches by date and by payment method. Now, if you have ‘Append to existing batch’, but do not have ‘Batch by date’, you can choose ‘Append by type’. This allows you to separate out the checks you deposit into two separate batches – checks drawn on the depositor’s (your) bank and checks drawn on other banks. It also allows you to separate checks and EFT payments of the same date for the same bank.

       The Retrieve from Payroll function now allows you to retrieve reversed checks. The entry in the resulting retrieved batch will have a negative amount. If a negative amount exactly matches the check number and amount of an existing check record on file, that record will be marked as “Reversed” during the posting of the batch. Otherwise, the negative amount will be written to the reconciliation file. If the check that is being reversed had already been reconciled, the reversal is not matched. Note that retrieved batches cannot be edited.

       Account Styles were added in Ledger 9.0D. They are now supported in GL account finder grids in BankRec.

       On the Open database dialog you can now use Alt-B to open the browse and Alt-F (for Favorites) to open the previously opened list. In previous versions you had to use the mouse to select the folder buttons.

       Alt-X now selects the Excel Direct button on grids where it is available. In previous versions you had to use the mouse to select Excel Direct.

       The vitalEsafe upload progress dialog has been improved and the progress bar now accurately shows the percentage. It is no longer necessary to install the vitalEsafe patch.

       New program icon and toolbar buttons provide a cleaner look and differentiate this new version visually.

    Problems Fixed

       If a filter is based on a range for any field that is right-justified (such as customer number, single segment item number, vendor number, etc.) then additional records will be selected by the search that should not have been. For example, if the range is from 1 to 2, then not only would records 1 and 2 be selected, but also 10, 11, 100, 101 etc.

       A Cash Invoice payment for a tax only AP Distribution generated an extra G/L transaction to the tax payable account for zero dollars.

       When converting to BankRec 8.1C the conversion message indicated that the new version would be 9.0A (rather than 8.1C). The message now says 8.1D.

       In BankRec 8.1C, the Date for Receipts transactions in a Deposit Only batch changed to the batch date when the entry was saved.

       The Find did not work correctly for selecting a customer with a leading zero in the Name field, such as for a numbered company. As result a receipt transaction could not be created for the customer.

       The date for the reversing entry generated for the originating bank when using the 'Automatic transfer on posting' feature (typically used for EFT) was set to the session date. The date is now set to the highest date found in transactions in the batch. Deposit batches will use the Deposit date.

       If your Ledger data was created with version 9.0x and you never used Ledger 8.1A or earlier versions, after printing the G/L Transactions report in BankRec, the Consolidate G/L Transactions dialog did not show the 2 options to consolidate by Fiscal Period.

       The Create Batch function in Reconcile Bank creates batch entries where the Reference contains a hyphen. For example "ER110628-3" (which stands for Electronic Reconciliation, transaction date in YYMMDD format, dash, 3rd entry in the batch). If 'Alphanumeric manual check numbers?' was off in the Payables company profile, you got the error "The check number is invalid" if you edited an entry and saved it. A hyphen is now ignored in all cases.

       There were errors when opening DataCare if you used BankRec but did not have Receivables.

       When importing a Detail Only deposit batch, if consecutive records had the same Check Number they were consolidated into a single entry in some cases, depending on whether other fields were imported and the values in those fields. The behavior changed in 8.1C from earlier versions and in some cases was not desired behavior. The import now determines a break between entries using the following logic. If Entry Number is imported it signals the change of entry, else if Bank Reference is imported it signals the break, else if Check Number is imported it signals the break, else Customer Number signals the break.

       When a new Bank was created in BankRec, with a Last Statement Balance as of the Last Statement Date, when the Bank Reconciliation report was run as at the Last Statement Date it showed an incorrect balance and Last Statement Date.

       BankRec 8.1C did not print transaction reports with correct Region/Language settings for French (Canada).

       When batches or entries were copied or moved to an existing batch that had a status of 'Printed' the status of that batch was not changed to 'Open'.

       BankRec suppressed "Canada" in the address print on Receipts if the Home Country in the Receivables Company Profile was "USA" and the 'Suppress home country on forms' option was selected. It also suppressed "USA" if the Home Country was "Canada". The fields from the Customer

       The Bank Reconciliation report as of a prior date correctly calculates the 'Cash Balance' and 'Report balance' when Reversals are present.

       When entries are copied into a printed batch, the print status should change on batch copied.

       The statement file for BMO Bank of Montreal could not be imported until the dollar symbol $ was deleted from amount fields by manually editing the file. The import now handles this. However, the final 'T' record at the end of the file must still be deleted manually. This file is a non-standard structure, using variant record formats, which cannot be by the Adagio import object at this time.

       BankRec 8.1C was updated from version 7 to version 8.5 of the Crystal Reports print engine. When installing Adagio for use with Remote Desktop Services (Terminal Services in Windows Server 2008 and previous versions), this necessitated manually copying the crystal folder from the main windows folder to the windows under each user. For example, on Server 2003 you had to copy the crystal folder from C:\windows\ to C:\Documents and Settings\username\windows. This is no longer required. The install and workstation installs will do the copy. The BankRec program will also do the copy if possible, which will avoid the need to do a workstation install in some cases.

       When installing Adagio to a computer or server where no Adagio modules had previously been installed, if you installed an Adagio module that does not use the Crystal print engine first (such as Lanpak or GridView), when you installed BankRec you received the error "Adagio has been established on destination folder: [x:\SOFTRAK]. Yet the install cannot detect the corresponding Reports Tables..." and were unable to proceed. If the first module installed uses the Crystal print engine there was no problem.

       The install (full/upgrade, NFR, Evaluation and Service Pack) no longer allows you to proceed if other users have Adagio programs running. This was previously allowed to avoid having to get all users to exit Adagio before installing, in cases where you knew the files that could not be updated because they were open by other users had in fact already been updated. However, in practice it was found this caused problems because sites proceeded with the install when they should not have.

       The updated version of vitalEsafe no longer triggers a workstation install if it has already been installed by the workstation install for another Adagio module. This is also the case when installing Adagio for use with Remote Desktop Services (Terminal Services in Windows Server 2008 and previous versions).

       When running any Adagio module that installs vitalEsafe (or WebSafe as it was previously known as) on a Windows 7 (or Vista) station, in some cases the auto-workstation install ran every time you started the application, even if you had done a workstation install. This happened if the user was not an Administrator on their own machine (the default for a new computer) but rather a Standard user, and User Account Control (UAC) was on, and you had not installed any module with a release date of October 2011 or later and done a workstation install for it on the station. This has been resolved. To resolve this problem for ALL other modules, install any module with a release date of October 2011 or later and do a workstation install for it on the station.



Adagio BankRec
8.1C | 2011-05-12 (May '11)
  Go to top
Release Notes
Print This

    Generic New Features

    • Added new function User Preferences under the File menu. It allows you to set certain options by user that were previously global, including options previously found under File | Options, Reports | Report Options and the Company Profile (company background color and On Start-up functions). The preferences can optionally be set for all users and preferences can be printed. If no individual user preferences have been set up for a user, all preferences originally set for the Adagio System Administrator, user SYS, will be used.
    • You can now specify a desktop background color, image and/or text constant to display on the Adagio desktop. Use this feature to display your company logo. Use the text strings to make the company name prominent on the desktop. Any JPG or other graphic image can be centered or stretched to fit on the main program desktop. These settings are made on the Appearance tab in the new User Preferences function.
    • The option 'Auto-advance smart finder' has been added (in the User Preferences function). It controls whether the focus is on the previously found grid or on the search criteria field when the smart finder is opened. Select the option if you want focus to be on the next row in the grid, allowing you to press F6, Enter and select each item in turn through the found list. Turn it off if you usually want to search by new criteria each time the smart finder is invoked. In either case the position is advanced in the grid each time the finder is opened. When the smart finder Grid is opened, you can toggle the focus between the Grid and the selection criteria by pressing F6.
    • The option 'Alphabetically sorted field list' has been added (in the User Preferences function). Turn this option on if you want field lists in the Column Editor and Filters fields sorted alphabetically.
    • Column Editor settings are now saved by grid by user by database.
    • Added the option 'Exclude Ranges' to Report Options (now in the new User Preferences function). If 'Remember report options' is on and 'Exclude Ranges' is also on, field ranges in general (including date ranges) are not remembered but other report settings are remembered.
    • Added Styles and Filters to transactions displayed in the View Transactions grid in the Balances function.
    • Styles and Grid Filters for customer and vendor grids are supported in the Customer and Vendor edit and inquiry functions (Adagio Receivables 9.0B or higher, Adagio Payables is 8.1C or higher).
    • Added an Excel Direct button to several grids, including View Transactions, Reconcile Bank and Edit/View Vendors. Use the 'Enable SF Export' option in Edit User to enable or disable the Excel Direct button.
    • Grids, filters, and finders now show the lookup values instead of the raw data values for typed fields. For example in the Reconciliation and View Transactions grids, Entry Type shows Deposit, Payment and Transfer, instead of 0, 1, or 2. Lookup values are also shown for customers and vendors.
    • Listing button added on the Group Setup window prints all options or enabled options only for a range of groups.

    Edits and Inquiries

    • Edit Customer and Edit Vendor functions have been added. Customers and vendors can also be edited from within batch entry. These edit functions use a Lanpak license and if another user is already in AR or AP would thus require Adagio Lanpak to be installed. The existing view functions do not use a license.
    • The Edit and View Customer functions in BankRec support the option to sort transactions and notes added in Receivables 9.0B.
    • Copy Banks and Copy Distribution Sets functions place you directly in the edit for the newly created record.
    • The Edit Banks screen is sizable. This allows more note lines to be shown in the grid.
    • The 'View all' and sort setting on the View Transactions screen in Balances are now remembered by Adagio user.
    • Added File | Optional Fields function to allow you to edit optional field settings for customers and vendors from BankRec.
    • The field names 'Unmatch debit GL' and 'Unmatch credit GL' on the Interface tab in Edit Banks function have been changed to 'Unmatch increase GL' and 'Unmatch decrease GL' to avoid potential confusion of debit/credit being from the point of view of your GL or that of your banking institution.

    Batch Entry

    • 'Auto-transfer banks' allow TelPay or other EFT entries to be posted to an EFT 'bank' then automatically reversed and re-posted to a different operating bank. The EFT Bank entry is posted in detail and the operating bank is posted as a single consolidated entry for reconciliation. The Auto-transfer happens on post of any batch to the designated bank. In the EFT Bank (Series tab) the option 'Automatic transfer on posting bank' is set and the 'Transfer to bank' is entered. The Reference and Description for the transaction are automatically generated as "AT-bbbb-eeee" (batch-entry) and "Auto Tsfr: BANK1 to BANK2". Automatic fees associated with the transfer can be generated at the same time, either as a flat fee or a percentage, by transaction or as a lump sum per transfer. Auto-transfer batches may also be used to automatically transfer from a payroll bank account to your operating bank. This feature can also be used to handle daily credit card deposits with automatic accounting for credit card merchant fees.
    • You can now add customers and vendors "on the fly" in batch entry.
    • The following fields have been added to the batch status and are available in batch grids, the batch inquiry, and Adagio GridView: Created by User, Time Last Edited, Last Edited by User, Date Posted, Time Posted and Posted by User. The date fields are the system date (computer date) rather than the session date (Adagio login date). BankRec supports similar fields in the Adagio Payables batch status when sending batches to AP.
    • Added a Find button for Payments in batch entry to allow you to locate a vendor by entering their name or telephone number (Payables 8.1B or higher).
    • Supports the „ctive‟flag in customers in Receivables 9.0A and higher. Grids and finders can optionally be set to hide customers. Note: Entering an inactive customer in batch entry does not force you to make the customer active because you must always be able to accept a payment from customers.
    • Supports the 'Reverse cash invoice with check?', Uppercase vendor code, Auto-fill and Vendor code format options in Payables 8.1B or higher.
    • Supports the 'Auto-generate invoice number' option in vendors (Payables 8.1B or higher) for vendors who send you a statement rather than an invoice.
    • Retrieved batches now cannot be deleted if the 'Allow edit of retrieved batches?' option is turned off.
    • When cash invoices are entered for existing vendors, Distributions and Distribution Sets defined in Payables are now used rather than those defined in BankRec. Miscellaneous vendor payments continue to use BankRec-defined Distributions and Distribution Sets.

    Retrieve Transactions

    • Added options to automatically post batches retrieved from Payables, Receivables and payroll. These options are on the Options tab in the Company Profile.

    Posting

    • The Job, Phase and Category (%job) can be used in the User Defined description format send to the GL. For receipts the only the job is sent. For payments, only the job of the first payment detail is sent.
    • The Receipt Number has been added to the Send to Description in for Receivables on the Interfaces tab in the Company Profile and is sent to the cash batch entry in AR.

    Reconciliation

    • Many-to-many matching is now supported during reconciliation. Use shift or ctrl-click to select the transactions from the bank statement and outstanding transactions. Drag the transaction in either direction when the amounts match. If the amounts of the selected transactions are unequal, then "Cleared with error" may be selected, but the difference in the reconciliation amount will be assigned to the "first" transaction in the selected set if you drag from the account to the statement. If you drag from the statement to your account transactions, then the error amount will be assigned to the transaction on which the "drop" occurs. All the transactions will be marked "Cleared with error", even though the other transactions will have an error amount of $0.00.
    • Improved handling of unmatched downloaded items in the generated batch is now possible by defining a set of rules in the Edit Statement Rules function in the Edit menu. Create rules based on transaction description, amount, reference or date to automatically assign an imported statement item to a vendor, customer, or general ledger account. Distributions can be selected to automatically break out tax credits from the amount imported. Use this facility to automatically distribute credit card expenses to your vendors and/or expense accounts. Drive accounting entries back from the imported statement into Adagio automatically to handle credit card expenses, account pre-authorized debits or EFT transfers.
    • Added Bank Reconciliation function in the Maintenance menu and 'Recon' button on the toolbar. This allows you to access the reconciliation function without having to open the Balances function (although you can still also access it from there).
    • The Reconciliation function displays a warning if the statement date entered is more than 30 days from the date of the last reconciliation.
    • When reversing a check you can now specify the date of the reversal transaction (RC) or select an option to use the issue date of the check. In previous versions the session date (login date) was always used. Reversing a check as of the issue date is useful when reversing postdated checks and simplifies reconciliation by listing a reversal in the same period as the check. The right-mouse popup menu has 2 choices for reversing a check: Reversed (login date) and Reversed (check date).
    • You can process NSF checks for cash receipts in deposits that have been reconciled. In previous versions you could not do an NSF if the deposit had been reconciled.

    Reports

    • The Bank Reconciliation report can now be re-printed as of any prior day, provided that transactions have not been purged. Backdating the „ank Reconciliation report in prior versions only affected today‟ outstanding transactions. Now, you can reprint a bank reconciliation as it was on a given day.
    • BankRec now uses the Crystal Reports 8.5 print engine. This allows exporting reports to PDF format.

    Print Receipts and the Specification Designer

    • Added new spec codes for customer, including the new name field 2 appended to the customer name, and additional address lines to handle addresses requiring many fields (city, state, country and zip/postal code): C70, Name 1 + 2 C71, address 6 (formatted) C72, address 7 (formatted) C73, address 6 (compressed) C74, address 7 (compressed)
    • Added new spec code to show the customer balance, after the payment is taken into account: H47, Balance - Receipt

    Import and Export

    • If the Entry number and the Check number are being defaulted for Detail Only deposits, the imported details are all in the same entry. In this case the import now separates the details into separate entries by change of customer.
    • When importing payments, if the Tax Code is not imported, it is now defaulted from the Distribution Code (If there is one).
    • The AP Reference field has been added to import templates.
    • Import/Export supports Excel® 2007 format (.xlsx) allowing for more than 65,535 rows in import and export files. Spreadsheets no longer need to be re-saved in Excel 97-2003 format (.xls) before they can be imported.

    Maintenance Functions

    • Period End has been improved to help prevent accidentally purging of history. The Date field has been renamed to 'Clear reconciled transaction history up to' and is not editable. Transactions are purged based on this un-editable date (which is calculated from the number of days to keep history in the profile). If the 'Statement Cleared Date' of a reconciled transaction is after the purge date, it is not purged, regardless of what the transaction date is.

    Install Changes

    • This version moves toward our goal of a more Windows 7 friendly environment for installation. If you are installing to a mapped network drive that is normally accessible, but you cannot see it during the install when attempting to select a drive or folder, you can now install by browsing to the correct folder using the Universal Naming Convention (UNC), for example \myserveraccounting. This avoids having to adjust the User Account Control settings, which requires you to restart your computer and temporarily grant Administrative privileges to the user if they are not an administrator.
    • This version simplifies installation by removing any consideration of the location of the Report Tables Drive (RTD) by the install and program in virtually all cases. Therefore the install no longer prompts for the RTD.
    • The install writes to the master install log file "AdagioMasterInstall.log" in the softraksystem folder. An entry is written to this log when any full, upgrade or SP for any Adagio module (with a release date of March 2011 or later) is installed. It shows the version installed and the version being replaced, the name of the Windows user who did the install and the rights for that user. An entry is also written to the log when an updated version of the Adagio Data Source (ADS) is installed, showing the version installed and the version being replaced. This log can be used to quickly determine the install history for all Adagio programs.
    • When you select the 'Backup Files' option during an install, the replaced files are now saved in a subfolder named YYYYMMDD in the BACKUP folder, under the programs destination folder (rather than the BACKUP folder itself, where extensions need to be changed to .001, .002, etc. when there are multiple versions of the same file).
    • The install includes an option allowing you to skip creating entries under Windows Start for cases where you will be manually creating an icon for the user to start Adagio and do not want them starting from Windows Start. During the install, uncheck the option 'Start Menu programs'. This avoids having to delete or change the Windows Start entry that would have been created.
    • The install no longer checks the Opportunistic Locking setting (Oplocks) on the workstation.
    • The Opportunistic Locking setting (Oplocks) on the workstation is no longer checked when the program is started.
    • The System Status function in the Help menu (chksys.exe) no longer prompts you to disable Oplocks. It displays the current Oplocks setting and allows you to change it. The 'Check R/W Status', 'Check Specific Folder' function now supports UNC browse, whereas before you would have had to turn UAC off to use it.
    • SetServerForAdagio and SetReportsTablesDrive utilities have been updated. The latter should virtually never be needed at an Adagio site once any Adagio module dated March 2011 or later has been installed.

    Problems fixed

    • You could not retrieve more than 20 batches from Receivables into BankRec. If more than 20 batches existed the Retrieve Receipts function displayed the error "Record locking. Unable to access record in banks. This record is in use by [symbols] in window [symbols]." and some batches were not retrieved or were corrupt.
    • BankRec now prevents you from reversing a Transfer if the transfer transaction is not outstanding in both banks affected by the Transfer.
    • If you entered a mix of receipts and payments into a deposit only batch, when a receipt, a payment and then another receipt was entered, the Bank Reference from the payment was used as the default for the second receipt rather than the Bank Reference from the first receipt. The Batch Listing showed the Bank Reference for the second receipt as a check number, although the batch correctly posted a single entry for the deposit.
    • A negative receipt copied to an existing batch added to the Batch total instead of subtracting.
    • The AP Reference field was not remembered between batch entries when the 'Remember Batch Entry Fields' was set.
    • When posting a batch and the „onsolidate bank transactions‟option is enabled, the consolidated information retrieved into Adagio Ledger is more accurately reflected.
    • When batch(es) containing errors were posted, after an error message was displayed, the message "Posting Complete" was displayed. The message has been changed to "Posting complete. One or more batches were not posted due to errors".
    • You are now prevented from posting a batch if it contains any entries for inactive vendors. A message is displayed indicating the entry and the reason.
    • If you imported a Bank Reconciliation, used the Auto-Match function, then clicked the Reset button to remove all the pending statuses, clicking the Auto-Match button again did nothing until you closed and re-opened the Reconciliation function.
    • If you imported a reconciliation and used either the Auto-Match or the drag-and-drop method of matching the imported file to reconcile transactions, the Last Status Date field was not set.
    • Last Status Date was not set when a batch was generated from unmatched imported transactions. It is now set to the sign-on date.
    • The 'Bank Statements Default' import template was corrupt and contained 2 Bank fields on the Field Defaults tab. To correct this problem for existing databases you must manually delete the files beginning with "BRIO" from your data directory. BankRec will re-create them. However, any custom templates you have created will be lost and must be reentered. Therefore you should print all templates before deleting the files.
    • In Import Payments, only Cash Invoice type transactions can be imported. However, the Transaction Type was a required field.
    • In Import Payments, only Cash Invoices can be imported. Therefore the GL Distribution or GL Account/Department are now required fields.
    • An error occurred when importing deposits if Adagio Receivables was not used.
    • Copy Bank function no longer copies the Last Statement Balance, Last Statement Date and Current Bank Balance.
    • The Source field in the Batch Inquiry was blank instead of 'Generated' for batches generated for batches created by unmatched import bank reconciliation or the NSF function.
    • The Posting Journal did not include the unapplied portion of partially Unapplied receipts in the document summary or in the General Ledger Distribution Summary in some cases.
    • The Receipt Date range on the report dialog screen for the Receipt Audit List was filtering on the Transaction Date instead of the Receipt Date.
    • The Bank Notes Detail table was not available in GridView.


Adagio BankRec
8.1B | 2010-05-06 (May '10)
  Go to top
Release Notes
Print This

  • Compatible with Adagio Invoices 9.0A (although BankRec does not interface directly with Invoices). Compatibility with earlier versions of Adagio Invoices is maintained.

  • Fully compatible with Windows 7. Supports MAPI email interface to Outlook and other mail clients on Windows 7.

  • Added an Excel Direct button to various grids, including View Customer and the customer transaction tab for Receivables, OrderEntry, Invoices and Time&Billing transactions. Use the 'Enable SF Export' option in Edit User to enable or disable the Excel Direct button.

  • Excel Direct from grids now has a progress bar and cancel for grids with a very large number of rows.

  • When retrieving payroll into BankRec your batch can contain checks from multiple payroll banks and they will be separated into batches by bank. In previous versions sites with multiple payroll bank accounts had to retrieve into BankRec between payroll runs for each bank.

  • Supports the 'Implied decimal' option added in Ledger 9.0C and Invoices 9.0A (in the User Preferences function). The setting is by Adagio user, for all companies, and when set in any Adagio module it is set for all Adagio module versions that support it. Turn the option on if you want a decimal automatically entered before the last two digits. For example, typing 400 in an amount field and tabbing to the next field will result in the number being changed to 4.00; typing 400.00 and tabbing to the next field will leave the number as 400.00. With the option off, typing in 400 will result in the number being changed to 400.00 (the behavior in previous versions). Percent fields and exchange rate fields are not affected by this setting.

  • The Help | About dialog now has a 'System Info' tab showing the version and path to various DLLs used by the program. DONE

  • The Designer supports UNC paths. If you open Invoices data with UNC path (rather than a mapped drive) then the Open Receipts Specification dialog changes and does not have a folder view but uses a browse instead. In previous versions the dialog gave an error. If a mapped network drive is used the dialog is the same as in previous versions.

  • Excel Direct (from finders, smart finders and from grids in some modules) can be configured to export an ASCII CSV file (instead of sending data direct to Excel) and start an application that automatically opens the file. This allows export when Excel is not installed and provides support for other spreadsheets such as OpenOffice.org. Note that unlike Excel Direct there is no formatting with CSV. To enable this functionality, entries must be made manually in the file \softrak\system\ssi2xl.ini. Refer to the Configuring Excel Direct to Export to CSV topic in the Readme help for details.

  • Added 'Report Preview Options' in the File | Options function to allow you to set the default preview zoom factor (percentage) and preview window state (full screen or partial screen) for previewing reports to screen. These settings are saved by workstation. Note: this applies to previewing reports only (but not previewing orders, invoices and credit notes).

  • Old formats such as Lotus, Dbase and Clipper that are almost never used any more have been removed from import templates, leaving Excel, ASCII CSV (Delimited), ASCII Fixed Length and PSV Delimited. The old formats may be manually turned back on for sites that need them. See the Upgrading section below for details.

  • If there are errors during any import function, the error message dialog displaying the error (e.g. "Errors have been written to the log file C:\softrak\data\xxIMPERR.ddd.") now allows you to view or print the log file.

  • If you accidentally double-clicked on the Customer button (only a single click is required) in toolbar, in some cases it was possible to Adagio BankRec 8.1B 2 of 3 BR20100506 3-May-10 open 2 instances of the Edit Customer function, which in turn caused errors.

  • You could not post a reconciliation for a bank that had no activity and had no outstanding transactions.

  • When receipts were printed on A4 paper, vertical lines in the detail section extended through the footer in some cases.

  • Typing the Adagio user password on the Open dialog displayed the characters very slowly when on a network in rare cases.

  • If you reversed a Cash Invoice from Payables the Reconciliation Posting Journal was unbalanced.

  • If your bank was set to increment batch deposit descriptions by number (not date), when you copied or moved a single deposit entry from an existing batch to new batch, the batch deposit description and reference within the new batch were retained from the original batch rather than incrementing as expected.

  • If you enter negative cash in Receivables (such as for a bank service charge) the negative miscellaneous receipt now reduces the Deposits total instead of showing up as a Payment.

  • When you selected Historical transactions for Receivables on the Transactions tab in view customer, loading the grid was noticeably slow when across a network. In addition, if the Transactions tab was the last tab you visited in the customer, the next time you opened a customer it was noticeably slow.

  • The 'Last access' date was not updated if the program was started from the Adagio menu of another application or from an icon with parameters that bypassed the login screen. Therefore the field was not up to date on the login screen the next time you started the program.


Adagio BankRec
8.1B | 2009-05-14 (May '09)
  Go to top
Release Notes
Print This

  • Compatible with Adagio Receivables 9.0A and earlier versions. Address blocks in Adagio BankRec receipt documents do not yet support the North American formatting available in Adagio Receivables V9.0A. Customer addresses will be moved into the four unformatted address lines in the document as space permits.

  • Cash receipts can be entered in a Receivables 9.0A cash batch and retrieved in Adagio BankRec. In previous versions cash had to be entered in BankRec (you can still enter cash in BankRec and post through to Receivables if you prefer). Cash retrieved from Receivables is automatically placed in separate BankRec batches by Bank and the default may be set to create a new batch or appended to an existing open batch, depending on the Payment Method. Payments entered in Adagio Invoices (8.1B or higher) and OrderEntry (8.1C and higher) flow through AR to Adagio BankRec.

  • The Adagio Open Data Dialog has been significantly improved. The Previously Opened database list is now saved by Adagio User rather than for all users. The first time an existing user or a new user logs into Adagio BankRec 8.1B they will be asked “Would you like your historical company access list set up?” Answer yes to have all entries from the Previously Opened list from your prior use of BankRec copied for your use. The Open Data screen and Previously Opened database list now show the date the database was last opened by the user. You may also elect to have Adagio save your Adagio User Id and Password and default them when logging into Adagio. The saved information is based on your Windows authenticated user name. This option may be turned off by editing \softrak\system\ADS.INI and adding the lines:

    [Options]
    RememberUser=0
    RememberPassword=0

  • Batch entry forms are now sizeable. This allows the more transactions lines to be shown on the screen at one time.

  • The Customer Inquiry function supports the new features in the Customer in Adagio Receivables 9.0A wherever possible.

  • Splitter bars have been added on all screens in View Customer that have 2 or more grids to allow you to size each of the grids individually. The ratio is maintained when sizing the entire screen. The setting is remembered.

  • The Adagio BankRec Batch Header now records last edited by Date, Time and User. This information can be shown in Grids and using Adagio GridView. These fields are posted through to reconciliation transaction file. In addition, the posted by Date, Time and User have been added to the transaction file.

  • You can now prevent or give a warning when the date entered in a batch is for a closed period or year in the GL. The option 'Validate closed periods' on the Integration tab of the Company Profile can be set to 'Allow, Warn only, or Disallow'.

  • The Smart Finder performance has been significantly improved across a network.

  • You can have database fields in the email subject line in Email covers. For example you may want to include a contact name when emailing a receipt to a generic email address for a customer or you may want to include the amount of the receipt.

  • Date entry has been improved by recognizing a single number as a day and defaulting the month and year of the entry. Four digit numbers default the year. Entering “12” into the date control with the sign-on date being Feb 26, 2009 will result in February 12, 2009 being returned to the application.

  • Adagio BankRec will optionally create a backup of related data whenever a Data Integrity Check completes without errors. Adagio BankRec will always create a backup of a database prior to applying any “fix” as a result of the “Rebuild” option being selected to repair damaged data. Backup details are written to the log file.

  • Emailing setup (“reply to” etc) is now stored by company and optionally by user. The SYS user can copy settings to all users for a company. The default E-mail port number 25 can now be changed to another port if necessary when sending directly. Some ISPs require use of port number 587 for SMTP transfers. Emails will now have the correct transmission time regardless of e-mail client. The fax queue files have been renamed to SDFAX.

  • The Bank of Montreal changed the format of the OFX file used by BankRec to retrieve a bank statement. Their new format is now supported.

  • A new field ‘Amt. type(0/C=Payt., 1/D=Dep.)’ has been added to Import Bank Statement to support banks using reverse logic from the existing field ‘Amt. type(1/D=Payt., 0/C=Dep.)’ Note that the terms Payment/Deposit and Debit/Credit in the field names are from the point of view of Adagio, not the banking institution. Also note that the field type defaults to Number and must be changed to String if the import field contains “D” or “C” (rather than 0 or 1).

  • Default batch description text can be automatically created with user initials (%usr), date (%dat) and time (%tim) created/edited in a user specified format. Multiple date and time formats are supported. These options are set on the Options tab in the Company Profile. The batch description can edited as required when the batch is created.

  • When ‘Deposit Only’ is turned off for a batch the Bank Reference in each entry is automatically replaced by the Check Number or set to batch-entry.

  • When a ‘Deposit Only’ batch is copied, the Bank Reference (Deposit ID) is incremented or set to today’s date if the ‘Use date for sequence’ is selected for the Bank.

  • When Adagio GridView 9.0A or higher is opened from the Adagio menu, Adagio BankRec 8.1B will be displayed as the first line on the Select Module screen so you do not need to scroll down to find it.

  • Install, workstation install and Service Pack install now support installing to a LINUX server without a special command line parameter.

  • There is a new way to extend vertical lines through the Detail section(s) on receipt specifications. Place the vertical line object at the position where it should begin printing, right click and select ‘Extend’.

  • The options ‘Enable SF Export’ and ‘Enable SF Printing’ have been added to the Edit User screen to allow you to disable Excel Direct in Smart Finders to help safeguard your sales data, customer list and other information in your database.

  • The Field Verification option has been removed from File | Options. Fields are always verified during entry.

  • WebSafe changed to vitalEsafe™ in Backup function to reflect the 3rd party name change.

  • The multi-currency files for single currency databases are now backed up when you backup a ‘Complete Dataset’.

  • The Help Menu has been modified to allow the user to launch the Adagio System Status utility (chksys.exe) and print the Adagio Lanpak registration form.

  • Added option ‘Prompt to consolidate’ on the Integration tab in the Company Profile. Disabling this option ensures you do not accidentally consolidate transactions after printing the ‘Print/Consolidate G/L transactions’ report.

  • Added option ‘Close report dialog after print’ on the Print/Post tab in the Company Profile. Set this option off if you often print reports multiple times with different settings or ranges.

  • Added ‘Allow Post Journal Purge’ option to Company Profile. If this option is off you cannot clear the posting journals after printing them. This prevents accidental purging of posting journals. If this option is off the posting journals will be purged as part of Year End.

  • Job Alerts are popped in batch entry if selected in the alert.

  • Report printing performance has been improved.

  • Added ‘Increment document number’ option when copying a batch. This allows you retain the original document number rather than having it replaced with automatically with the new batch number and entry number.

  • Transactions in receipt cash entry can be multi-selected to show the total amount outstanding for the selected transactions.

  • In batch entry, selecting an inactive G/L account now generates a warning message.

  • Options have been added to open several different functions when the program starts up, including Balance Inquiry, Batch Edit, and Customer inquiry. Imports can be automatically processed. External batch management is improved with options to “Auto Retrieve Batches” and “Warn Retrieve Batches”. “Auto Retrieve” launches the external batch retrieve dialog from which the user may cancel if desired.

  • Automatically copies help files (*.chm) to the local drive so that Service Packs do not require a workstation install just to update the readme help file.

  • The BankRec Application Integrity Check (also known as phase 2) is now supported in DataCare. To enable this feature in existing DataCare jobs that check BankRec, edit the Job Detail for BankRec and select ‘Perform application integrity check’.

  • Many new specification codes have been added to the specification designer. Specification codes are available to print the formatted address information from the Adagio Receivables V9.0A customer record.

    C59 – 63 address 1-5 (formatted)
    C64 Name (line2)
    C65 City
    C66 State/Province
    C67 Country
    C68 Comments 2
    C69 DUNS
    C146 Salesperson name
    H44 Last edited by user
    H45 Last edited by date
    H46 Last edited by time
    M20 Current Date
    M21 Current Time

  • The sample data has been updated. The Adagio Ledger and Adagio Receivables sample data has been updated to 9.0A. Issues resolved in this release

  • The list of printers available from Windows is now refreshed immediately before printing reports and receipts. When a user with a shared local printer logs in under Terminal Services the list of printers available to Windows changes because one more printer has in effect been added. If other users were in Adagio applications this resulted in the selected printer being changed in Adagio in some cases. If the user did not notice this and reselect the correct printer before printing then their report or receipt randomly and unexpectedly printed on a different printer.

  • When you size a screen containing a grid, the size is automatically adjusted so that an entire line will be visible for the last grid line. This corrects a problem where double-clicking on a partially displayed last line selected a different line than the one intended.

  • The default template for Import Bank Statement previously contained the field ‘Account Number’. This field was never used and has been removed from the default template.

  • Remember batch entry was not saving Description for the next transaction entry.

  • You could not save a Distribution Set if it contained more than 9 Distributions.

  • In a multi-currency database the Bank Reconciliation, Bank Transactions and the Reconciliation Worksheet reports now print the Home Equivalent amount using the exchange rate based on the report date rather than on the sign-on date (session date).

  • The right hand edge of some reports was cut off on A4 paper. In version 8.1B the program no longer forces the form size (i.e. override the setting in customized reports). This allows users to use the ModRP feature to change the standard reports to make them narrower.

  • Export/import with a path greater than 65 characters resulted in an Access Violation error. You now get a message explaining the problem.

  • When you created a new Receipt specification the default sections for header, details, footer and end page were not created automatically.

  • The G/L distribution summary on the Posting Journal was out of balance for Cash Invoices with discounts entered directly in BankRec.

  • Importing a bank statement in OFX format from some banks displayed the error “No CRLF at buffer offset 0”.

  • The G/L tax entry for a miscellaneous payment with a tax-only distribution entered in BankRec was incorrect.

  • Posting a reconciliation when the Payables checks already have a the pending status caused an error in some cases.


Adagio BankRec
8.1A | 2007-09-22 (Sep '07)
  Go to top
Release Notes
Print This

  • 1048 If you had data for Adagio Invoices 6.8B (2005.09.22) or older in your company data directory, or data for any version of Quik Invoice Plus for DOS, when you started Adagio BankRec 8.1A (2007.06.05) you received the error message saying "Your current version of Adagio BankRec is not compatible with the version of Adagio Invoices database you are currently using. If your Adagio Invoices was version 8.0A (2005.12.27) or higher this error did not occur.

  • If you are using ACCPAC® PlusT General Ledger 7.0A you received the error message saying "Your current version of Adagio BankRec is not compatible with the version of Adagio Ledger database you are currently using. If you are using any version of Adagio Ledger this error did not occur. Note that Adagio Ledger converts Plus G/L 7.0A databases to a compatible format.

  • If you started Adagio BankRec (2007.06.05) from the Adagio menu in another Adagio module, and your BankRec main window was set to full screen, you received the error "System error: 1400. The window does not have scrollbars. " on some machines.

  • Some settings such as bin and paper size made in the printer Setup where ignored when printing forms (receipts).

  • If you had ACCPAC Plus Accounts Receivables or General Ledger open you could not open Adagio BankRec 8.1A (2007.06.05) on the same database.

  • Retrieve from payroll now refreshes the batches grid (if open) to show the retrieved batch.

  • The G/L Transaction batch could not be retrieved in Ledger for new databases created with Adagio BankRec 8.1A (2007.06.05).

  • In Adagio BankRec 8.1A (2007.06.05) backup up to some removable devices, such as a USB Key, reported the error "Cannot update an existing spanned disk set" and the backup could not be completed.

  • The search criteria for smart finder were not remembered in Adagio BankRec 8.1A (2007.06.05) after closing the program.


Adagio BankRec
8.1A | 2007-06-05 (Jun '07)
  Go to top
Release Notes
Print This

  • Compatible with Windows® VistaT.

  • Compatible with Adagio Lankpaks 8.1A. Lanpaks must be 8.1A for all Adagio 8.1A modules.

  • Smart Finder can now search on multiple criteria.

  • Contents of disabled fields are shown in blue rather than dimmed gray. This may be easier to read on some monitors at higher resolutions.

  • Adagio download files, installs, workstation installs, all workstation install (softrakallwkstallwkst.exe), main program files, and the Adagio Check System utility (chksys.exe) are now signed with a digital certificate using VeriSign to allow you to verify the Publisher is Softrak Systems Inc.

  • Vista does not support the old style Windows Help (.HLP files). All .HLP files were converted to compiled HTML help (.CHM files), which are supported by Vista.

  • For security reasons Windows does not permit .CHM help files to be run from a network drive. This is true in XP as well as Vista. The .CHM files must be run from a local drive. Adagio 8.1A installs all .CHM help files to your local hard drive and loads them from there. The workstation install also copies .CHM files to the local drive.

  • Fax document image files were created in earlier versions using the Softfax printer driver. This driver is not compatible with Vista. In 8.1A versions, faxing documents created with the Specification Designer (invoices, checks, statements, etc.) creates a fax image file directly. The Softrak Softfax driver is no longer used or installed. Third party products that use this driver must be updated. If they do not install the driver and wish to run on XP or earlier Windows versions they must install the driver themselves. Note that to run the Adagio fax server (Fax/Email | Fax Queue) you must have a 'true' fax card (with an on-board fax chip) rather than a Win Fax modem (which emulates a chip in software).

  • When switching window/task in Vista with Alt-Tab or the new Flip 3D (Windows-Tab) an image of the current Adagio screen is shown rather than just the icon of the Adagio program.

  • You can now backup Adagio data in zip form to WebSafe, a web-based storage facility. WebSafe is a service which allows you to store your important information in a secure location that you can access from anywhere in the world. See www.websafe.com for details.

  • Currency symbols other than $ are now supported in reports.

  • The formatting of dates and text sent to Excel from Smart Finder results has been improved.

  • A 'User defined' field has been added to the G/L Description 'Send to' options in the Company Profile. This allows you to format the G/L Description field sent to the GL using a combination of fields from the original transaction, batch information (posting sequence, batch number, entry number), and free form text.

  • Adagio BankRec is Adagio Ledger 9.0A ready. Fields required for future drill-down from Ledger to BankRec are included in the GL transaction batch and will be retrieved by Ledger 8.1A.

  • The Designer Toolbar now fits on one rather than 2 lines at most common screen resolutions.

  • The Designer allows you to open statement specifications by using the spec Title under File | Specification Options. This is the same list of titles displayed in the Payables when selecting a statement specification to print, fax or email. Previously you could open the specification by its file name only.

  • Batches of checks from third-party payroll programs can now be retrieved (as well as imported). Retrieving is simpler than importing and BankRec warns you when there is a payroll batch ready to be retrieved. Check with the payroll developer to determine if their product can create a retrieval batch for BankRec.

  • You could not edit and save a Bank that was interfaced to Adagio Checks in BankRec 8.0A.

  • When you posted an imported bank reconciliation the left side of the form (showing the imported transactions) closed, even there were unmatched transactions.

  • The debit/credit indicator ("D" and "C") in banks statement import templates was from the company's point of view rather than the bank's point of view. This has been reversed. Scotia Bank used this format.

  • The header description field was always blank when a statement is imported or defaulted in the import template.

  • Importing a bank statement transaction for zero dollars caused an error. Now a zero dollar transaction is detected when the import file is validated.

  • Printing a receipt from within the entry after making changes caused an integrity error in some cases.



Adagio BankRec
8.0A | 2006-09-20 (Sep '06)
  Go to top
Release Notes
Print This

  • Added the ability to print, fax and/or email receipts.

  • A Bank Reconciliation Worksheet report added.

  • Import bank statement templates can now handle bank statement import files where the payments and deposits are in the same column, both as positive numbers.

  • Comment lines at the top of a Bank Statement import file in CSV form can now be skipped to allow files of this format to be imported.

  • The customer name and check number are no longer required fields when importing receipts/deposits.

  • The field 'Delete import file on success' on import bank statement templates is now editable.

  • Fixed a problem when importing a bank statement that included an unmatched check for the same amount as another check that was matched.

  • The multi-currency fields in the batch, batch posting journal, reconciliation, and reconciliation posting journal files have been added to the Crystal Reports for Adagio table.

  • In version 8.0A, the GL Summary on the Posting Journal was out of balance if you had a prepayment amount from entering a receipt amount greater than the total of applied documents.

  • The currency code showed as the home currency instead of source currency on the Reconciliation Posting Journal for transactions cleared in error.

  • After converting from BankRec 6.8B, the Posting Journals from postings in 6.8B showed an entry total of zero for AP transactions.

  • Multi-currency Peresoft® Cashbook for DOS databases were not correctly converted in some cases.

  • Auto Match did not work if check numbers in the imported statement had leading zeros and two checks had the same amount. Leading zeros in check numbers are now fully supported.

  • Processing an NSF check in a single currency database in version 8.0A did not complete properly in AR if the interface was the retrieval method.

  • A BankRec database could only be created for home currencies with 2 decimal places.

  • Receipts in a batch created by the Reconciliation function created GL entries for zero dollars instead of the correct amount in some cases..

  • Payment entries in a batch generated from reconciliation did not create a manual check batch in Payables when the batch was posted.

  • Batches generated from reconciliation are now given a batch description.



Adagio BankRec
8.0A | 2006-06-23 (Jun '06)
  Go to top
Release Notes
Print This

  • Adagio BankRec now supports multi-currency accounting.

  • You can import bank statements downloaded from your bank for automated reconciliation.

  • Transactions can be optionally posted as reconciled for bank service charges and interest.

  • A Cash Flow report has been added.

  • Checks can now be reversed without having to post the bank reconciliation.

  • A Batch Status Inquiry function has been added.

  • When you enter a cash receipt for a customer who is 'On Hold', a warning can now be displayed indicating the on hold status, and you can take the customer off hold at that time.

  • The reconciliation grid can now be sorted by Sort recon by date and amount, as well as by reference.

  • In the Reconcile Bank function you can now hide pending transactions to show only the outstanding transactions.

  • BankRec now Interfaces to Adagio Checks. Adagio Checks version 8.0A is required.

  • The G/L summary on the Posting Journal can now optionally be summarized by Account/Department. Set this option on the Options tab in the Company Profile.

  • View Customer in BankRec supports the new fields and features found in customers in Adagio Receivables 8.0A and higher.

  • View Vendor in BankRec supports the new fields and features found in vendors in Adagio Payables 8.0A and higher.

  • Alerts entered for customers in Adagio Receivables and vendors in Adagio Payables will pop-up when a transaction is entered or edited.

  • The Active flag in Vendors in Adagio Payables 8.0A and higher is supported.

  • Sample data has been updated to demonstrate the new features.

  • Multi-currency sample data has been added and is installed in \softrak\BRWin\mcsamdata.

  • The function 'Active Users' has been added to the Help menu.

  • Users of Adagio GridView can add views to the Inquiry menu.

  • The F2 key now supports Windows standard behavior by editing the line selected on a grid.

  • The F6 key now opens the smart finder directly from any grid where you can do a find.

  • The Windows calculator can added to and launched from the toolbar by selecting 'Calculator button' in File | Options.

  • The date of the last data integrity check is now displayed in the status bar.

  • The Data Integrity Checker memo now shows the date the integrity check was run, the starting and ending time, the path and extension of the data and the user name.

  • The source files for all reports in Adagio BankRec are installed in the StandardRP sub-directory rather in the program directory \Softrak\BRWin.

  • On the batch entry screen for entering a receipt, the field name for the amount has been changed from Payment to Receipt so as not to be confused with payment entry.

  • The Bank Reconciliation report now shows the Payee Name (vendor) in the Description field for payments.

  • The fields in the BankRec G/L Transaction Batch file are now available in GridView.

  • When you added a tax or tax included entry to a receipt, the tax rate was correctly displayed but if you edited the distribution it was redisplayed divided by 100.

  • Deleting the detail for a payment with a distribution code caused unrelated details to be deleted from the entry.

  • When entering receipt transactions in a non Deposit Only batch, the customer number is remembered between entries but appeared in the vendor field if you switched to entering payment transactions. The vendor number is now blanked in this case.

  • When you add a batch entry using a Distribution Set, the cursor now returns to the amount field after each entry when appropriate to speed up entry.

  • The Transaction Info screen in the View Transactions function has be changed to improve readability.

  • The sort sequence on the Batch Listing report was incorrect in some cases when you printed multiple batches for different banks on the same report.

  • Two of the subtotals on the Bank Reconciliation report now have names (Net Pending and Net Outstanding) beside them to better indicate their purpose.

  • An NSF for a receipt with a miscellaneous distribution did not reverse correctly.

  • For receipt entries with miscellaneous distribution, if you created a distribution using a tax only or tax Included distribution and then edited it to use a sale (purchase only) type distribution, the tax base was not cleared to 0. The reverse was also true.

  • More error conditions are checked for when importing with the Verification option.

  • Totals on the Bank Reconciliation report were incorrect if there were reversed bank transfers pending.

  • Reversals of receipts entered without using Distribution Codes were not reflected in the Tax Tacking report.

  • Reversed payments were added rather than subtracted on the Tax Tracking report.



Adagio BankRec
6.8B | 2005-09-13 (Sep '05)
  Go to top
Release Notes
Print This

  • Import Deposits has been added.

  • Renaming a batch now changes the status from Printed to Open if you change the description, deposit number or deposit date.

  • If the option 'Allow edit of tax code' is set in Receivables, and you changed the tax default code on a receipt and saved the entry, the tax code reverted to the default if you edited the entry.

  • When you printed and cleared the Batch Status report, any batches of type 'Generated' were not cleared.

  • You could not print reports to file in Word format.

  • The finder in the Batch Number on the Batch Status report dialog contained blank lines in some cases.

  • The message "Note: AP Vendor transactions only update accounts for Cash and A/P Clearing" was appearing on multiple lines on the posting journal in some cases when it should not have.

  • The New Bank Statement Balance is now printed on the Bank Reconciliation report when printed in summary form.

  • When printing the Bank Reconciliation or Bank Transactions reports to file you got the error message "Error:524 Print Job Busy".

  • In some cases when printing the Batch Posting Journal to file you got the error message "Error:524 Print Job Busy".

  • When printing the Batch Posting Journal to file you got the error "Critical Error 1." in some cases.

  • When importing payments, the leading zero was trimmed from the Bank Code field in the import file, even though BankRec allows leading zeros in the Bank Code. As a result, the file could not be imported.


Adagio BankRec
6.8B | 2004-11-30 (Nov '04)
  Go to top
Release Notes
Print This

  • Now multi-user and multi-instance.

  • Historical Transaction report has been added.

  • Bank Reconciliation report has been improved.

  • Bank Transaction report has been improved.

  • Payments can now be applied to transactions in Adagio Payables.

  • Cash batches can be created directly in Adagio Receivables.

  • When you log in to a BankRec database and receive the warning that there are batches to retrieve from Adagio Payables, you can now retrieve the batches right then and there.

  • GridView has been added to the Adagio menu.

  • When you viewed a cash receipt and made it an NSF, there was no indication the NSF was accepted until the inquiry was closed. Now the title of the Bank Inquiry screen indicates when that NSF entry is pending.

  • If you retrieved a batch from Payables that contained any transactions for a bank that is not defined in BankRec you received an error. Transactions for the existing bank(s) were retrieved but the batch was not cleared.

  • You can no longer leave check number blank when entering a receipt. This caused a problem when you retrieved the batch into Adagio Receivables and attempted to post it.

  • An import template for Paymate Platinum is automatically created when a new BankRec database is created.

  • Manual checks to miscellaneous vendors (vendor code blank) reconciled in BankRec are now reconciled in Adagio Payables.

  • If a retrieved batch was copied, the Data Integrity Checker reported an error in the batch copied to and that batch could not be posted. Retrieved batches and entries in retrieved batches can now only be copied or moved to other retrieved batches. Entered batches and entries in entered batches can now only be copied or moved to other entered batches.

  • If copying at the entry level and the selected entries contained a bank transfer that was not the first entry, it did not copy properly in some cases.


Adagio BankRec
6.8B | 2004-08-29 (Aug '04)
  Go to top
Release Notes
Print This

  • When entering batches, fields from the previous entry (including date) are now remembered.

  • Added a template ('Paymate Platinum detail only") and sample file (PRPayPlat.csv) to the sample data for interface to Paymate Platinum.

  • When creating a new batch, the default is now 'Deposit Only'.

  • Receipt batch entry and posting now test for duplicate check numbers in Adagio Receivables current and history for the customer.

  • Transactions displayed in the grid during receipt entry were not correctly sorted by document number in some cases.

  • When a Deposit Only batch was copied and the dates revised, the deposit date was set to the session date. It is now set to the revised date.

  • 'Auto print posting journal after post' option did not work if you used the post button on the toolbar rather than the post button on the Open Batches screen.

  • A warning is now displayed in all cases if you reverse a check for which no transaction exists in the Adagio Payables check reconciliation file. The Check Reconciliation Posting Journal now also shows the error.

  • Cleared with error and reversal GL transactions created by posting a bank reconciliation now use the statement date rather than the session date.

  • The error "Attempting to perform operation on unopened transactions file." occurred during posting if BankRec was not interfaced to Adagio Receivables.

  • If the 'NSF customer charge' is zero, a zero dollar transaction is no longer sent to Adagio Receivables.

  • If the 'Bank NSF fee' is zero, a zero dollar transaction is no longer added to the BankRec batch.

  • In some cases, you could not reverse a transaction for an NSF check.

  • Reversing a transaction for an NSF check only reversed one invoice in cases where the check paid multiple invoices.

  • Making a check NSF on an unapplied receipt did not reverse correctly and caused an error when the receipt was posted in Adagio Receivables.

  • The payment batch retrieved from Adagio Payables was not purged in some cases if it contained checks for an AP bank that was not defined in BankRec. The undefined checks were rejected but this resulted in duplicate checks in the next retrieval.

  • The batch type 'Generated' has been added to the Print Batch Status report dialog.



Adagio BankRec
6.8B | 2004-06-25 (Jun '04)
  Go to top
Release Notes
Print This

  • If a Deposit Only batch contained a transaction with a duplicate Bank Reference number but no deposit transactions (only payments), an error resulted when the batch was posted. Posting now detects duplicates and the batch is not posted. Data Integrity Check now detects and rebuilds this type of error.

  • When a batch was copied, the revised date in the copied batch was blank.

  • When you posted a copied batch, the batch appeared to post correctly but nothing was actually posted.

  • When entering a miscellaneous payment, the Check Number finder now shows only transactions for the bank selected for the batch.

  • If you change the Deposit Reference for a deposit only batch, the change is now reflected in the details of the Batch Listing. The Deposit Reference and Deposit Date have been added to the header details for the batch on the Batch Listing report.

  • When AP checks cleared with error were posted in bank reconciliation and updated the check reconciliation in Payables, duplicate GL transactions resulted when the check reconciliation was posted in Payables.

  • If you are reconciling a bank and have made pending status changes but have not closed the reconciliation function yet, the Bank Transactions and Bank Reconciliation reports warn you the pending status changes will not be reflected on the reports. If you print the batch listing or click OK to close the bank reconciliation dialog, the changes are saved and reflected on the reports.

  • The 'Changed' date was not updated correctly in the Bank Reconciliation report if you multi-selected transactions and cleared them during reconciliation. Only the first one would have the date on it.

  • When transactions cleared with error checks were transferred to the Check Reconciliation in Adagio Payables, the error amount was incorrect.

  • When an AP check is reversed in BankRec but the vendor's transactions or check reconciliation transaction have already been purged in Payables, a warning is displayed to indicate the check must be reversed manually in Payables. The Reconciliation Posting Journal also flags the transaction with the warning "Check nnnn is not on file in Payables and cannot be reversed.".

  • In the reconciliation function, the finder and smart finder in the Bank Reference field did not show any transactions if the bank code was less than 6 characters.

  • The Find in the reconciliation function now includes an option to Edit as well as Highlight and View a transaction.

  • The NSF button is now disabled on reconciled checks, as by definition, a check on your bank statement must have cleared.

  • The GL Summary on the Batch Listing and Posting Journal did not include unapplied amounts triggered by early payment discounts on receipts.

  • The Bank Transactions report did not include transactions dated prior to the last statement date if multiple banks were printed at the same time.

  • The Batch Listing could not be printed and an error was displayed if the batch contained a Miscellaneous Cash Receipt and Adagio Time&Billing data was present in the data directory.

  • The running balance on the Bank Transactions report is now correct when sorted by Bank Reference.

  • The Bank Reconciliation report now prints the correct information when you have a check marked to clear with error but have not yet posted the reconciliation.

  • The total discount taken was incorrect on the Posting Journal in some cases.

  • The 'Toolbar raised' option was not retained after the program was closed.

  • When you copy a bank, the Opening Balance, Bank Statement Balance and Last Statement date are no longer copied to the new bank.

  • Fixes have been made for missing help links.

  • Clicking the Help button on the New Batch dialog caused the dialog to close.

  • Users where able to access functions not permitted for their security Group in some cases.

  • Clicking the View button in the Bank Inquiry List caused an error if no banks where defined yet. The View button is now disabled in this case.


Adagio BankRec
6.8B | 2004-05-10 (May '04)
  Go to top
Release Notes
Print This

  • Initial Release.