·    Added an option to print a General Ledger Distribution Summary on the Posting Journals.

·    Added a subtotal of Units by period on the GL Detail Listing.

·    Added Email Setup function to support Direct email for Adagio Console users, allowing them to use Direct for the EmailPDFLog command in automation batches rather than MAPI, which requires operator input.

·    For multicurrency datasets, Import Batches and Import Transactions does not require that Rate type or Rate date be in the import template. These fields will default based on settings in the Company Profile and MultiCurrency data.

·    Additional Application Log entries are made by Ledger. The log can be viewed with GridView or Adagio Console.

·    The Data Integrity Check has an enhancement to check the next posting sequence and transaction uniquifier in the Company Profile against the posted transaction and posting journal files and attempt rebuild if required.

·    GridView view templates for Adagio Ledger have been updated. They are installed in the \Softrak\Ledger\ViewTemplates folder.

Problems fixed

·    In the Edit Departments function in Ledger 9.2A, if you created accounts using the New Department process, selected the Clone Account option but not the ‘Clear budget/forecast figures’ options, selected income accounts that had budgets to clone, integrity errors resulted.

·    If ‘Active records only’ was enabled in the Column Editor, the Clear function in Edit Budgets and Edit Forecasts was not clearing amounts if hidden inactive accounts were included in the range of accounts selected.

·    In Ledger 9.1A and 9.2A, copying multiple batches to a single new batch created multiple new batches instead.

·    Resource locking changes have been made in Ledger and the Financial Reporter. You are no longer restricted from posting batches when the Financial Reporter is open on the same station for a different database. Posting continues to be restricted when the Financial Reporter is open on the same station for the same database. Posting is permitted when the Financial Reporter is open on other stations for the same database.

·    Retained Earnings account option, ‘Restrict To Subledgers’, was incorrectly preventing posting batches to Current Year.

·    Closing the posting confirmation message with the X in the window title bar posted the batch(es) instead of closing the message.

·    In MultiCurrency data in some cases, edits to text fields in revaluation batches caused the Home amount to be recalculated to 0.

·    In the View Transactions/Budgets inquiry, when viewing the Budget/Forecast, Fiscal Year dropdown showed every year twice.

·    The Posting Journal when printed in detail form and sorted by account now displays the full Description field.

·    Printing a Report set to PDF failed when there was a Posting Errors Posting Journal.

·    When the Posting Journal report was saved as a Favorite, the Print Error Posting Journal option was always enabled.

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

·    In Ledger 9.2A’s Posting Journal report, a date field of 12/31/1899 printed on the G/L Summary.

·    The Posting journal in detail form, sorted by Account, with ‘Print Units’, printed a blank line when the second entry description was not blank.

·    For multicurrency datasets some totals were not aligned correctly on the Detail Listing report.

·    Source currency amounts were incorrectly suppressed in Source and Home Batch Listings, in the G/L Summary.

·    The Source Journal Profile Report in Ledger 9.2A printed several Unused sorts in the ‘Sorted by’ column.

·    In the Export Transactions function, if you exported a range that did not include any transactions, the message “Error code: 1001 on ToXLAutoFitRange” was displayed instead of a message saying there were no records to export in the range.

·    Export of files to Excel format from File | Export functions displayed an error if you had opened the database using a UNC path (for example:
\MYSERVER\Adagio\SOFTRAK\DATA).

·    Export of files to Excel format from File | Export functions did not create the export .xlsx file in some cases if Excel 2013 or higher was open on the stations.

·    Automation no longer stops if set to Retrieve by Application when there is no batch to retrieve.

·    If the size of text was set higher than 100% on Windows 10, Ledger froze when opened in some cases.

·    Corrected problems converting from version 8.1A databases.

·    The Data Integrity Check did not include the Adagio Common Files (SD*) when a backup was made prior to rebuilding errors.

·    Corrected a problem where, after a workstation install was completed, it cycled requiring another workstation install (sometimes cycling without user intervention). This happened in isolated cases on some workstations for systems where Adagio 9.2A/B modules dated in December 2015 or later were installed for the first time at a site, depending on the workstation environment and/or the order in which upgrades and Service Packs were installed.

Enhancements in Financial Reporter

·    "Pin" fiscal periods and Department choices so that they are applied to every sheet in the financial statement. Click on the push pin to the left of the Fiscal Period selector to have that period used for every sheet in the statement. Click the push pin a second time to revert to fiscal period selections on each sheet. The same operation works for the Department selector.

Note:     In order to have the push pin appear, you may need to select View | Customize | Settings | Toolbars, and click "Reset" on each toolbar in turn.

·    Conditional cell formatting is supported. Highlight the cell you wish to conditionally format and select Format | Conditional Styles. The conditional format formula is entered into the Formula box. The formula is a regular "IF()" function with the name of the Style you want applied if the condition is TRUE and the Style you want applied if the condition is FALSE. Use an empty Style ("") if you want the default formatting applied if the condition is not met.

The Preview window will show you the contents of the selected cell formatted according to the conditional Style. Until the formula is syntactically correct, the OK button will be disabled, and the Preview window will be blank.

IF() formulas may be nested. Normal cell references may be used. "#" is used to reference the current cell (as illustrated).

Conditional Cell Formatting may be Enabled/Disabled for the entire sheet from the Conditional Styles Dialog, or from the Formulas | Conditional Styles menu choice.

·    Allow an arbitrary selection of fiscal periods from the currently selected and previous years to sum amounts. Net Changes, Budgets, Forecasts, Statistical Units and Provisionally posted amounts can now be easily summed over arbitrary fiscal periods.

Previously, a specific period could be included in a Specification Code. For example [11]M would provide the Net Changes for Fiscal Period 11. You can now place starting and ending periods between the []M separated by a colon (":"). For example, [3:5]M would sum the Net Changes to an account for periods 3 to 5.

The Starting period must be less than the Ending period, unless it is preceded by "P". NET[3:5]M and [3:5]M sum the Net Posted transactions for periods 3 to 5. NET[P10:3]M and [P10:3]M sum the Net Posted transactions from Period 10 in the prior year to period 3 in the currently selected year.

The following modifiers change the summed value:

   NET    =    Net Changes (assumed if no specifier)
   B       =    Budgets
   F        =    Forecasts
   U       =    Units
   PRO   =    Provisionally Posted Amounts
   ENC   =    Encumbrance Amounts

·    GLUPDATE() has an optional additional parameter to select the Budget Year to update. "1" updates the previous year's budget figures.

·    When drilling down into transactions, the displayed Grid will be banded according to the User Preference settings for color and banding frequency.

·    The Financial Reporter status bar now displays Company Name, data path and extension, and the Adagio and Windows user.

·    Performance improvements have been made to speed the loading and printing of statements.

·    Updated all Financial Reporter specifications in the sample data that used =AD formulas to use .ColSpec. The SuperSpec has a sample for the [n:n] Net Changes. Added new specification GL!CellFormat.sam showing simple cell formatting.

·    The financial statement templates have been updated. Use File | Open Template to open one of these basic statement templates provided in the \SOFTRAK\FSDesigner\Templates folder.

·    The /t command line parameter is supported when starting the Financial Reporter program directly from a shortcut. This allows you to set a session date in the format of YYYYMMDD.

·    The Financial Report now writes to the Application Log when opened and closed. The log can be viewed with GridView or Adagio Console.

Problems fixed in Financial Reporter

·    ExcelDirect no longer includes a trailing decimal point when amounts are rounded to the nearest dollar.

·    "Blank" departments are now correctly handled in Statement Groups.

·    Revised department descriptions are now correctly loaded in the Financial Reporter when User Department Restrictions are in effect.

·    When Users are restricted from printing a Statement Group, that Statement Group will no longer be available to send to Excel from the General Ledger.

·    When a Statement Group contained sheets with different paper sizes and orientation, the correct page selections were not done if the Statement was open in the Designer. This has been fixed.

·    Print Financial Statements for Sub Groups of a Statement Group printed the incorrect Sub Group in some cases.

·    When a new account was added to the chart of accounts, that account would not be reflected on a financial statement until the user collapsed and expanded the statement. This is no longer required when ".AutoUpdate" is specified.

·    Hidden rows at the bottom of a statement were not being hidden when exported to Excel.

·    Inactive Departments were not suppressed when ‘Skip Inactive Departments’ was set on a Statement Group item with a Custom Range of departments.

·    The Save As Template function now requires the template to be saved in the \SOFTRAK\FSDesigner\Templates folder so that will be found by the Open Template function.