Adagio FX 9.3A

General New Features

·   Compatible with Adagio DocStore. The links to PDF documents are retrieved from Ledger, including Ledger databases in different locations. The documents are not copied.

·   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.

·   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 retrieving data from Ledger and purging the fiscal year. You can choose the number of these backups that will be saved.

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

·   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.

·   Messages are now centered on the main form, rather than on the main monitor.

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

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

·   The Find button on the grid in the Edit/View Accounts functions is now enabled when a filter is applied. You can use the Finder and Smart Finder to search within the filtered grid.

·   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.

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

·   Installs an updated version of the AdagioPDF driver. The updated driver name is AdagioV2PDF and will appear in Windows Control Panel, Devices and Printers.

·   Installs \Softrak\System\AdagioLauncher.EXE and associates the application with “ADB”, “SAM” and “AMC” extensions. AdagioLauncher will automatically launch the correct Adagio module if an Adagio file is double-clicked in a Folder. The user will be prompted to log in.

Problems fixed

·   The Department finder for adding to the restricted departments list in the Edit Retrieve Template function now shows Departments from the source Ledger rather than from FX.

·   In FX 9.2A, when retrieving from Sage 50, there was an error unless ‘Retrieve all years’ was selected.

·   In FX 9.2A, all departments were retrieved even when the option ‘Selected only’ was used.

·   Corrected an error when doing an Auto Retrieve with ReplaceDepartment=1.

·   In FX 9.2A if the grid was sorted by Department, the Find Transaction function did not locate transactions correctly.

·   The Departments report was blank if you did not have a Retained Earnings account with a blank Department.

·   Added ‘Process Imports’ on startup in the User Preferences. The ‘Auto-import on startup’ option in import templates did not work without the option in User Preferences.

·   The %cmp command did not strip commas from the Company Name used to form the path when reports were printed to PDF with ePrint.

·   In FX 9.2A the Chart of Accounts report produced an error when the report was previewed.

·   The “Opening Balance” label did not print on the Detail Listing report for some accounts when printed with certain report options selected.

·   There was an error when creating a new database in FX 9.2A.

·   When report options were restored in User Preferences for All Users, the ExcelDirect filename in any report favorite for the Detail Listing was changed when it should not have been.

·   Corrected a problem setting the fiscal period and year for Trial Balance and the Detail Listing report favorites.

·   After retrieving from Ledger, if you edited the Retrieve Template used and enabled the option to Replace Existing Departments (which enables the option for Append to Existing Data), then retrieved again (without closing FX), there were errors during the retrieve.

·   You could not select a Fiscal Year ending with a letter (eg. 2017A) on a Source Journal report.

·   Corrected problems and errors that occurred in Edit Source Journals if you added fields, if you first removed all Selected fields.

·   Printing a report to ExcelDirect displayed the error “Failed to launch” when Ledger was run over a Remote Desktop Connection.

·   Import functions had an Access Violation error when importing a CSV file where the last record is missing the end of record indicator (a CR/LF).

New Features in Financial Reporter

·   New SmartSheet commands “.Sort”, “.SortCase” and “.SortEnd” are available to sort a section of a financial statement into alphabetical (or some other) order. The sort is case sensitive when “.SortCase” is used. The sort is in ascending order. Place the text “Start” in the column on which the sort is to be performed. Multiple sort blocks in a sheet are supported.

·   New SmartSheet commands, “.RangeAccountDept” and “.RangeAccountByDept” have been added that expands wildcard and department ranges differently from “.Range”. “.RangeAccountDept” creates a row for every account in a range, for every department specified in the Toolbar in account sequence. “.RangeAccountByDept” produces the same list, but sorted by department.

·   “ExportSheetName(“name”)” in cell A3 will override the default name for the statement when a workbook is sent to Excel. The string specified in the function can be an expression. This allows you to specifically name each sheet in a workbook when it is sent to Excel.

·   Statement Groups now allow you to specify a specific name for the ExcelDirect workbook. Right Mouse Click on the Statement Group name to set the Export name.

·   When setting up a Statement Group with a Custom Range, you can now suppress the summary sheet which used to print after all the ranges.

·   Holding down the Shift key while clicking the ExcelDirect button will result in the entire workbook being sent to Excel.

·   When sending transactions to Excel using the ExcelDirect button and including the "Doc Link" column, the resulting spreadsheet will have hyperlinks to the documents in the DocStorage Folder. This allows you to see the source documents from the Excel spreadsheet.

·   You can specify an Open and Write password on a Statement Group Workbook that is sent to Excel. The passwords are specified on the context menu for the Statement Group.

·   ExcelDirect uses.xlsx if that is the default Excel extension.

·   It is now easier to locate "Cycle!" and "Error!" values.

·   View | Customize | Settings (Tx Details) now only shows the actual selected columns, and has a "Restore to defaults" choice to quickly revert to the default columns display.

·   Right Mouse Button on the "Doc Link" column offers to "Copy Files". Clicking "Paste" in a Folder will result in the attached documents being copied into the Folder.

·   When running in Adagio Cloud, the file extension in a statement group is automatically changed to "ADB" removing the need to edit Statement Groups when migrating from On Premise to a Cloud deployment.

·   Hidden cells will not be considered when "Zero Suppress" is being processed.

·   Expression Notepad added to improve the entry of complex formulas. Right Button Mouse on a formula cell or double click in the Formula Bar launches the Notepad. Text is entered in a monospace font and multilines are supported. The ‘Expression Notepad’ has been enhanced to allow its use when editing an account range in Column B. Double-click in the formula bar in the toolbar, or Right click on the cell containing the formula or account range and select the option from the pop-up menu.

·   The new Header/Footer code “$G” is now available to print the UTC date and time in the section. Here is the complete list of supported Header/Footer codes:

·   The behavior of the Department Selection Combo Box has been significantly improved for sites with a large number of departments.

·   Items in the Department View can be re-ordered (moved) using Alt-UpArrow and Alt-DownArrow key presses.

·   In the “Specify Fiscal Period” dialog, the Description, Fiscal Start and Fiscal End dates are now displayed.

·   The Financial Reporter now records the name of the statement being loaded in the application log (SDAPPLOG).

Problems Fixed in Financial Reporter

·   The function GLFPE() returned the incorrect ending period date when used with the "BAL" specifier. It now returns the end date of the selected fiscal period. "CURBAL" always returns the last day of the fiscal year.

·   Statement Groups sent to Excel from Adagio Ledger were not respecting the setting of the “Values only” flag.

·   Reducing the number of entries in the "Most recently accessed" statement list might cause the financial reporter to crash on start up.

·   When multisheet statements were saved with a department range selected, the department range was not restored when the sheet was next opened.

·   Department masks with leading blanks now work correctly.

·   The Financial Reporter now starts without a blank statement open. This avoids an unnecessary question asking if you want to save your changes.

·   The Most Recently Used list in the File menu is now restricted by company database and user.

·   File names on the command line enclosed in double quotes are now handled correctly.

·   In some circumstances, inactive accounts/departments would display even though the sheet option to hide them was enabled.

·   A user now receives a “Permission denied.” message if they do not have access to a department used in a statement group.

·   Using “Fit to page” is working more reliably.

·   In some datasets, the View Statement Group pane would not stay open. This has been fixed.

·   The “.Verify” Smartsheet command now lists all account-department pairs not referenced in the section. Use this validation command in circumstances where the general ledger has specific account-department pairs hard coded on a financial statement.

·   Corrected issues with dialogs on Ultra High Resolution displays when the font size is anything other than 100% of normal on Windows 8.1 or higher.

·   When a Department List that included ranges or masks was selected, amounts were incorrect.

·   When printing a Statement Group for several departments, the order of the statements appeared to be random. The Group will now print in the order selected.

·   Specification codes “U”, “PRO” and “ENC” now return the full year value, regardless of the fiscal period selected.

·   The “Accounting $$” format now works correctly when the first row(s) of an expanded range are hidden.

·   Statement expansion now works reliably when the statement contains user department restrictions.

·   Updating budgets when next year was open used to generate a data integrity error in the general ledger. This no longer occurs.

·   Choosing “Save as…” for a statement loaded from a Folder other than the Company data now changes the Folder destination to the Company data Folder and the extension of the Statement.

·   Transaction details were not displayed and some rows were suppressed when a statement was expanded.

·   A statement using .AutoUpdate that was saved as expanded and contained thousands of rows was not properly refreshed when it was closed and opened again.

·   When switching from Consolidated to departmental display, the amounts for the original department were incorrect for rows with account ranges.

·   Corrected problems in the Department dropdown when large department lists exist.

·   Starting the Financial Reporter with all 4 parameters no longer stops at the signon screen.

·   User Departmental Restrictions permit user to see all of their enabled departments only.

·   Automation will now ExcelDirect a Statement group.

·   File | Export to Excel menu choice has been removed. Use ExcelDirect in its place.