• For DocStore related data. For newly created FX datasets that are not in the same location as the Ledger and DocStore data, the first retrieve from Ledger did not capture all of the DocLinks.

·          Financial Reporter was inserting Page Breaks when Ranges on Financial Statements were expanded.

·          New functions have been added to Account Groups: Expand All and Collapse all.

·        When the GLATREE file is corrupt and cannot be deleted by FinancialReporter, a message warns the user that they need to exit and delete the file manually.

•Custom Reports that used the Crystal report option to Hide a detail section, which permits drill down, did not work properly.

•Custom Reports with sub-reports could not be printed. This error was received : The table could not be found.

•The SSI2XL.DLL and SSI2XL64.DLL have been updated to 1.12.26.577 to correct a problem in Ledger and FX with printing Report Sets that contain Statement Groups to PDF. With earlier versions, either the Report log would show that the ‘Print Failed’ with an ‘Initialization error: 1000’ or there would be no PDF created and no message in the Report Log.

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

•If the Company Profile is set to use “North American Address?, Import Projects 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.

A new option has been added to the Company Profile, System Options tab to work with ‘North American Address?’: ‘Normalize Country To’. The options are: Full name, 2 character ISO, 3 character ISO and Never.

For editing or importing Projects, if the Country is recognized, variations on Country codes are standardized based on this setting.

Eg. For the Default setting: Full name, CA or CAN become Canada.

Fixes in Financial Reporter

•An Export password equal to the User ID is no longer being applied to new Statement Groups.

•When Rows and Columns were moved, the Page Break indicators were being moved so that it appeared that the Page Break had been moved. Page Breaks are not moved. Recalculate will correct the display of the indicator.

•Added ‘Borders' button to the Format toolbar. Use the Borders button to access the functions available from the Borders tab of 'Format Cells'. You may need to reset your toolbars after upgrading to show the new buttons. To do this, go to View | Customize, Toolbars tab, select Format in the list and click the Reset button.

·          If View Transaction Budgets is set to ‘Sort by Department’, ‘View Account Transactions’ and ‘View Account Budget History’ did not work properly.

·          FX was not displaying the linked documents properly when there were Associated Doc Links.  This is fixed in the updated ADFILER 1.1.24.389. Note: In existing datasets, the SDDOC files for the FX dataset must be recreated to get the correct links.

·          When printing the Detail Listing, the option to “Include Inactive Accounts” could not be updated.

·          For DocStore related data, a ‘Retrieve Aborted’ error received when retrieving data from Ledger has been corrected by updated ADFILER files.

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

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

·    Project codes can now be created to attach to transactions, with user-defined terminology. Retrieve Transactions from Adagio Ledger with project values. Import project codes on Transactions. Print a Project Transactions report to list posted details to specified projects.

·    When Project Tracking is enabled, Optional Fields are available to include with Project Codes. Optional text field values can be edited from the File menu.

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

·    For sites that choose to use Import Transactions instead of Retrieve Database to populate the transaction records, there is a new Maintenance function to Create Next Fiscal Year. This creates the fiscal calendar year and associated Net Changes and Budget records for each account. A separate function Change Current Fiscal Year sets this Next Year as the new Current Year. To make these function active, a Company Profile option Manual Fiscal Year Handling must be enabled.

·    A new Find Transaction function has been added to the transaction list screen within a viewed account. Now, you can use a Smart Finder search within a specific account that will work much faster when you know the account to search within. This is in addition to the existing Find Transactions process that searches all accounts.

·    When Adagio FX has data maintained strictly through Import Transactions and not Retrieve Data, you can now set the Current Fiscal Year from a new Maintenance menu selection. You must first enable Manual Fiscal Year Handling in the Company Profile to allow access to this menu selection.

·    When Importing Transactions for company data that is integrated with Adagio DocStore, using transactions that originated in Adagio Ledger that have PDF attachments, you can now import the Document Link value with the FX transactions. This allows you to view DocStore PDFs with transactions in FX that already have the PDFs correctly configured for viewing in Ledger. It is still possible to import transactions using Attach PDF, for referencing the path to PDF files that have not yet been attached in Adagio Ledger or FX.

·    Statement Groups printed from Report Sets now supports the ExcelDirect setting for generating an Excel file.

·    Standard 93A and higher feature is for phone numbers to display as formatted on grids, if the Format Phone Number option is enabled in the Company Profile. Works for Edit Projects.

Problems fixed

·    Installs a new version of the printer driver used to print documents and reports to PDF. The new driver name is AdagioV3PDF. This driver uses novaPDF version 10.

·    When printing a report set directly to the AdagioV3PDF driver and you choose to cancel printing for a particular report from the PDF Save As screen, you are now prompted to cancel printing either just that report or the entire report set. This choice is written to the report log.

·    Setting up data Retrieve templates no longer gives an error for not being able to find the database file when the Adagio Ledger data file extension is numeric.

·    In View Transaction/Budgets, from the Find Trans button, the Finder / SmartFinder was showing a Character string instead of 'Linked' for the Doc Link field.

·    To accommodate the creation of future years specifically for budgets, the Import Transactions function will no longer be able to allow selection of the Next Fiscal Year retrieved from Adagio Ledger. You likely do not to require doing this in any event when data is retrieved from Ledger.

·    When the DocStore catalog data files are missing Doc Link attachment records for Adagio Ledger transactions, retrieving that data into Adagio FX would give an error 'DocGUID not found in source (10084)\\\" for each transaction detail affected. Now these errors no longer appear, and the transactions that would have given the errors are retrieved without a Doc Link.

·    When printing Report Sets using either AdagioV2PDF or AdagioV3PDF as the specific printer, instead of using PDF Document as the destination, the report log now stores the PDF file name and save location instead of simply 'Printed to AdagioV2PDF'.

·    If the data path folder name contained a period, browsing to the folder and double clicking on the global file caused the application to try to create a new dataset with the extension set to the part of the folder name following the period character.

·    Refresh sample data is hidden when on Adagio Cloud.

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.

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

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

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

·    Added option to the Company Profile to create a backup of related data whenever a Data Integrity Check completes without errors. Adagio FX will always create a backup of a database prior to rebuild.

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

·    Added ‘Week starts at’ to the Company Profile to allow you to specify the beginning day of the week for grid filters.

Edit / View Accounts / Departments

·    When an Account is edited or created, you can require it be assigned to an Account Group by setting the new ‘Mandatory Account Groups’ option in the Company Profile.

·    Account Groups can be defined as non-contiguous ranges and these ranges can now be enforced when accounts are added to the chart of accounts by setting the new ‘Mandatory Account Groups’ option in the Company Profile.

·    You can now make a department "inactive". When a department is made “inactive”, you can optionally makes all accounts in the department inactive as well.

·    Account Groups can now be added to the Account Group table. A warning will be displayed that changes to this table will necessitate edits to the basic default Balance Sheet and Income Statement included with the Financial Reporter; however, you can now create ranges for specific Due to/Due from and clearing accounts.

Edit / View Budgets

·    Accounts with current or historical values can now be deleted from Edit Accounts.

·    Edit Budgets and Forecasts functions are the same as in Ledger. These functions have been significantly improved to speed the entry of budget figures. Speed keys have been made available on several frequently accessed fields, and the tab order has been modified to more accurately conform to the expected field entry. When “stepping through” a range of accounts or departments, Adagio FX remembers the previously used method for allocating the budget and automatically changes the method. If you “step into” an account with non-zero entries and there is no previously used budgeting method on file for the account, you will be placed into “manual entry” mode to prevent inadvertently changing the previously set budget figures. If the method results in updated budget or forecast figures, these amounts will be displayed in red to highlight the change. For accounts where the budget / forecast has never been edited the function defaults the entry method to the last you used for the company. If the program will be saving changed figures, the “Ok” button text will be changed to say “Apply”.

·    Options have been added to the Company Profile to allow you to lock budgets and/or forecasts in the current and/or next year to prevent them from being edited in FX or updated in the Financial Reporter.

Transaction Inquiry

·    The Posted Transactions file structure has changed from a sorted sequential file to an indexed file for version 9.2A. The new structure allows immediate viewing of entries in the View Transaction/Budgets function and drill down within the Financial Reporter at any time. 

·    View Transactions has the entire entry displayed on a grid when viewing a detail.

·    The View Transaction/Budget inquiry grid can now be set to show active accounts only.

·    When viewing the details of a transaction, you can display the PDF of the form that created the transaction (e.g. an invoice) if Adagio ePrint is installed and the PDF is available.

·    In the View Transactions | Budgets function, you can now place the YTD Budget or Forecast totals, or the Budget / Forecast figure for any specific period on the account selection grid.

·    Added the ability to find transactions in the View Transactions function. The ‘Find Trans’ button opens a screen allowing selection of a fiscal year and within that to pick a Batch, Entry and Line # (from postings in Ledger). The smart finder is used to search all transactions within that fiscal year. Selecting from the smart finder result positions to the desired transaction in the grid.

·    All Fiscal Period finders now show all 12 (or 13) periods. This can speed up entry when using the mouse to select the period.

Reports

·    Adagio FX’s standard reports are now created using Crystal Reports 2013, replacing the Crystal Reports 8.5 Print Engine (CRPE32.dll).

·    Print the Trial Balance and Detail Listing reports to Excel using ExcelDirect. Added an ExcelDirect button and ExcelDirect Options button on the report dialogs. Transactions from the report are exported to Excel using the selected ranges, sorts and options (except subtotals and page breaks). The resulting spreadsheet may be more useful than the export produced using Crystal depending on what you are looking for. Select the new ‘Enable ExcelDirect Print’ option and related settings on the Report Options tab in the Company Profile.

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

Import / Export

·    You can now import and export Departments.

·    Many restrictions have been removed when importing accounts and transactions, including checking of dates, requiring balanced entries, allowing import of Current and Opening Balance, and allowing import of transactions for the current year. Account and Department must still be valid for Net changes, Transactions, Budgets, Forecasts, and Statistics.

·    During an automated retrieve using a Retrieve Template or the /R parameter, Access Violation errors are automatically closed without requiring user input in an attempt to allow the retrieve to completed.

Problems fixed

·    Corrected problem retrieving from Adagio Ledger with a “wildcard” Department and departmental restrictions.

·    Corrected problem where budgets were not retrieved correctly from Adagio Ledger when using the 'Use Existing Budgets' option.

·    The Trial Balance report with only the ‘Include YE adjustments’ option enabled omitted accounts in some cases.

·    The Detail Listing report now always defaults to the expected year when Next Year is open and your fiscal year is not the calendar year.

·    The Default file for Import Account Statistics defaulted to GLSTATIM.CSV instead of AFSTATIM.CSV.

·    Automation did not allow selecting an Import Transactions template.

Financial Reporter

·    The Financial Reporter in FX is now at exactly the same revision as the Financial Reporter in Adagio Ledger 9.2B (2016.05.16).

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

·    Supports new budget and forecast lock options in the Company Profile. You cannot update budget or forecast figures for either the current and/or the next fiscal year if locked in the Company Profile.

·    If you retrieve from a multi-currency Adagio Ledger database, the Source Currency code and Exchange Rate fields are available on the drill-down to the transaction details.

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

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

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

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

New Features

   Compatible with Adagio Ledger 9.2A.

   Compatible with Sage 50 2015 – Canadian Edition.

Problems fixed

   The Departmental restriction on the automated retrieve from Adagio Ledger using /R did not work in FX 9.1A (2014.06.19). This has been corrected. There was no problem retrieving from Sage 50 or with retrieves using Adagio Console automation.

Financial Reporter

New Features

   The Financial Reporter in FX is now at the same revision as the Financial Reporter in Adagio Ledger 9.2A (2014.11.20).

   The Financial Reporter drill-down now has Amount-Source, Source Currency Code and Exchange Rate columns when data has been retrieved from Adagio Ledger multi-currency databases. Note: Adagio FX is not a multicurrency module and functions such as Edit Accounts, Reports and Source Journals do not support multicurrency.

   You can now open the Financial Reporter from its own shortcut. The usual command line parameters are available. The Financial Reporter must be started with the /a parameter to show the Symbol column in the Account Data view. Therefore it should always be run from a shortcut if being run independent of FX. The shortcut needs to have /a in the Target field (Softrak\FX\FXFinRep.EXE /a). You can only launch the Financial Reporter once Adagio FX has been registered. Opening the program directly consumes Lanpaks.

   New toolbar buttons have been added to generate double underlines and fixed position dollar signs (“$”) for dollar amounts. Another formatting button will format a cell as a date. To display the new buttons, select View | Customize | Toolbars | Reset for each of your toolbars.

   You can mark a column “Auto-hide” which will cause the column to be automatically hidden if all the amounts in the column are 0.00. Choose the option from the pop-up context menu when a column is selected.

   Arbitrary departments can now be grouped together as a Department List. From the View | Departments panel, select the departments you wish to group using ctrl-click. Right mouse button and select “Create department List” from the pop-up context menu. Verify that the correct departments are selected, give the list of departments a meaningful name and select “Ok”. The Department List will appear in the list of departments you may choose from the Toolbar.

   Department Custom Ranges can be created in Statement Groups. Specifying a Custom Range results in the chosen statement being printed for each individual department found in the range.

   Statement Groups can now be separated into sections, making it easier to organize them. In Adagio FX, you can select either the top level name to print all the statements in a group or select an individual statement group for printing. While duplicate group names are permitted, only the first group with a duplicate name will be accessible from FX. Cut / Copy and Paste as Subgroup are available on the pop-up context menu to manage subgroups in the Statement Group View. An item in a Statement Group can now be opened with its default settings from the pop-up context menu in the Statement Group View. Set the default Open behavior by ctrl-left clicking on the option you want.

   The entire financial statement is now calculated when it is loaded. This will result in longer load times for large statements, but means that the entire statement can be scrolled through without delays as cells are recalculated.

   The financial reporter will now Autosave a statement if you have been working on it for a long time. Set the Autosave frequency under View | Customize | Settings.

   The Most Recently Accessed File List is now managed by user, by company. Opening or Printing a Statement Group does not add the referenced statements to the Most Recently Accessed list.

   Inactive departments can now be suppressed from the View | Department pane.

   Inactive accounts will be suppressed if they have no balance or have no transactions posted in the fiscal year being printed. Otherwise, they will continue to be available to print.

   When the Financial Reporter is opened after installing an upgrade, a dialog is displayed with a link to a short video highlighting the new features. The dialog is displayed for each user until they tick 'Don't show this message again'. The video also be viewed anytime by visiting the Softrak website. Note: the dialog also appears when Adagio is installed at a new site.

Problems fixed

    “.RangeDept” now properly selects the expected accounts in the range.

   “Fit to page” now works more reliably.

   “Zero suppress” row now works more reliably when other formats are applied to the row. “FormatHidden” now works more reliably.

   The Financial Reporter is now more tolerant of damaged files.

   The “Ignore Inactive” button is now disabled if there are no Inactive Accounts.

   Drill-down now correctly displays all the referenced accounts when complex account ranges include “*” and “`” in the department range.

   The “Extra FP Quarter” option in the Company profile is now respected.

   Regional formatting of numbers is now respected on the export to Excel.

Enhancements and revisions in Adagio FX 9.1A (2014.06.19)

NOTE: Adagio FX 9.1A is NOT compatible with any version of QuickBooks^®.

New Features

   Full compatibility with Adagio Console. Supports Automation when Adagio Console is installed. Automation allows you to automate many functions in Adagio modules, including retrieving, importing, printing report sets, backup and integrity check, etc. across modules, and view, print or email the results from an automation log.

   Retrieve Templates function allows you to define templates for different databases, Departments or retrieve options. Retrieve Templates can be retrieved by Automation File jobs. The Previously Selected Databases remembered in the Retrieve Accounting Data function will be converted to Retrieve Templates. The existing Auto-retrieve function driven from the AFWININI.xxx file continues to function and has not changed.

   The Shade Color for reports found in the Report Options tab in User Preferences now uses the full color pallet rather than just 8 solid colors.

   The Notes window is now sizeable for accounts.

   The Open Data screen can be sized horizontally to allow you to see the full data path.

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

   The Adagio menu now includes the module from which it was selected to allow you to quickly open another instance of the same module.

   Adagio FX now logs any Access Violation errors in an exception log text file. The file is \softrak\fx\fx.error.log.

   The Help | About screen has been redesigned and includes a link to a documentation page for the module that shows New Features, What's New video and manuals. It now has a Consultant tab showing the contact information for your Adagio consultant if they have enabled this option at your site.

   When FX is opened after installing an upgrade, a dialog is displayed with a link to a short video highlighting the new features. The dialog is displayed for each user until they tick 'Don't show this message again'. The video also be viewed anytime by visiting the Softrak website. Note: the dialog also appears when Adagio is installed at a new site.

Problems fixed

   FX 9.0A and higher did not show the number of instances of FX open in the window title, for example "Adagio FX Pro (2)".

   Adagio ePrint users were not prompted to turn on Allow PDF printing and enable for all users when an FX database was created.

   The automated retrieve of a subset of the G/L into a separate data folder using the /R command line parameter did not work in 9.0B (2011.11.24).

Financial Reporter

New Features

   The Financial Reporter in FX is now at the same revision as the Financial Reporter in Adagio Ledger 9.1A (2014.02.21).

   You can drill down to the Entry Details for a transaction, showing both sides of the entry (unless consolidated).

   Added new 'Value’ codes in the Account Data tree for many Groups. They output amounts without considering the fiscal period.

   Added an optional Update parameter "U" to QUERYSHEET. It causes target sheet to be set to the fiscal period, department and year that was passed in. For example: QUERYSHEET(S, C [, F [, D [, Y[,U]) - if Update U is not zero set sheet S to the optional parameters F, D and Y. Note: sheet S cannot not have .AutoUpdate in cell A2.

   Added new functions CURRENTFISCALYEAR(), NEXTFISCALYEAR(), and PRIORFISCALYEAR() to the right-mouse context menu under Insert Formula, Fiscal Information.

   Added ‘Paste Format' and 'Clear Formatting' buttons to the toolbar. Use Copy and 'Paste Format' to copy the format without the content. Also added 'Paste Formatting from Cell' (Alt-V) and Clear Formatting (Alt-DEL) to the Edit menu, and same choices on the right-mouse menu on a cell. You need to reset your toolbars after upgrading to show the new buttons. To do this, go to View | Customize, Toolbars tab, select Edit in the list and click the Reset button.

   A 'Reset' option has been added to View | Properties to restore the original program values.

   ExcelDirect now supports the Scaling options 'Fit columns to' and 'Fit rows to' options in Page Setup.

   File names can be used in Hyperlinks and are sent to Excel.

   The Window title now shows the "Maintain" or "Print" as the first word, depending on how the Financial Report was opened from Ledger.

   Added 'Lock Toolbars' option to View | Customize | Toolbars. Prevents the toolbar from being moved or modified.

   When creating a financial statement it hides the "Departmental Comparative" option in the Layout dialog if you are not using departments.

   When formatting dates, you can suppress leading zeros in the day and month elements by choosing “Precision 0” in the Format Type dialog.

   Increased the period and year drop down to allow all periods and multiple years to be shown.

   Added sample financial statements for updating the budget amounts using GLUpdate formulas. The AF!BudgetUpdate.sam statement allows entering an annual budget and amounts will be divided equally across all 12 fiscal periods. The AF!BudgetUpdateMonths.sam statement allows entering monthly budgets into columns and amounts will be written to the respective fiscal periods.

   Added the new ‘Values’ codes to the SuperSpec template and specification in the sample data. Updated the FunctionExamples and DateFunctionExamples.

   A new sample financial statement (AF!DtlListing2.sam) has been added that allows you to quickly generate the transaction details for a non-contiguous range of accounts into an Excel spreadsheet. Instructions for its use are in the statement.

Problems fixed

   The Clear Contents menu choice on the right-mouse menu on a cell now immediately clears the formula from the edit field on the toolbar.

   VSUM displays the calculation correctly formatted.

   Corrected the column number of Totals in drill down to Details view of posted transactions.

    When using the “.RangeDept” SmartSheet command, the financial reporter now correctly ignores inactive departments if 'Ignore inactive accounts' has been enabled for the sheet.

   Previously, you could not Copy cells when a SmartSheet was expanded. This has been fixed.

   Printing a Statement Group no longer adds the individual statements to the “Most recently opened” list.

   Enabled the arrow and Delete keys for non-generated cells in expanded smart sheets.

   Editing a generated cell from the edit bar behaves the same way as F2 when a sheet is expanded.

   GLFPS("OPEN") now correctly reports the beginning of the fiscal year.

   The drill down to the Entry Details for a transaction now includes the Account, Department and Description fields on the grid.

   The FIND function now returns zero rather than error if nothing is found. In previous versions, the FIND returned the index starting with 0. Now the index starts with 1. Existing financial statements containing formulas using FIND will need to be adjusted when upgrading to 9.1A.

   Compatible with Simply Accounting 2012. Note: Budgets are retrieved as they were entered in Simply - the sign is flipped on Revenue accounts.

   You can now automatically retrieve a subset of the G/L into a separate data folder. This is useful in cases where you want individual Departments to have access to their financial data without having access to the G/L and without seeing other Departments. A Windows scheduled task could be used to perform the retrieve after hours, so that the Department would have current data as of yesterday's closing. In order to implement this functionality, entries must be made to the AFWININI file in the FX data folder and a /R added to the FX shortcut. See Auto Retrieve in the Help file for more detailed instructions.

   Styles and Account Filters are available to display accounts in different colors and Filter accounts that meet specific criteria.

   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.

   Adagio FX and Financial Reporter fully support 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). Financial Statements and Statement Groups print to a separate, configurable 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. Favorites can be private to the Adagio user or public for use by all users. 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.

   Report Sets allow the grouping of Report Favorites and Statement Groups 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 FX.exe with the parameter /W followed by the Report Set (ex. /WMonthEnd). Note: in all other Adagio modules /R is used but /R is used for Auto-retrieve in FX. 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 month end reports. Report Sets can be private to the Adagio user or public for use by all users. This allows you to give a user access to particular Report Sets containing statement groups, but no access to the Financial Reporter, even in print only mode, which would allow them to select/print any financial statement.

   Added 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). Includes new options 'On Start-up', 'Alphabetically sorted field list' and 'Exclude Ranges'. 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.

   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 march through the found list. Turn it off if you usually want to search by a 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.

   The option 'Implied decimal' has been added (in the User Preferences function). 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 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.

   Added 'Report Preview Options' in the File | Workstation Options function to allow you to set the default zoom factor 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 financial statements).

   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.

   Added function to 'Print Financial Statements' to the Reports menu in FX to allow you to print financial statement groups without opening Financial Reporter. If 'Specify Fiscal Period' is set on the statement group you will be prompted to select the fiscal period and fiscal year.

   Added ExcelDirect Financial Statements to the Reports menu to send statement groups directly to Excel without having to launch the Financial Reporter.

Problems fixed

   In the View Transactions/Budgets function in FX 9.0A, if you changed the year in the drop-down from the current to a prior year the View Detail and View GL Entry buttons became disabled until you closed and re-opened the function.

   A problem occurred with data retrieved from Adagio G/L when Next Year was created before closing the Current Year. In this case, the QuerySheet function caused cells to display !Error and values returned were incorrect.

   In Adagio FX 9.0A (2011.09.23) you received an error message when backups were uploaded to vitalEsafe, although the backup file was correctly uploaded.

   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 FX 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 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).

   After installing Adagio FX 9.0A (2011.09.23) at a site running certain other Adagio modules, where no other modules with a release date of October 2011 or later had been installed and run at least once on the station, the auto-workstation install ran every time you started the application in some cases, even if you had done a workstation install. There was not a problem at sites running FX only.

Financial Reporter

   You can now force a statement to “Fit to page” either by column or row. File | Page Setup allows you to fit the statement columns or rows to a specific number of pages. The printout will be scaled to fit the space available.

   Editing a SmartSheet is now disabled if the sheet is expanded to prevent you making changes that will be discarded when the statement is refreshed.

   A new function =ISEXPANDED() (returns TRUE() if the Smartsheet is expanded, otherwise returns FALSE()) has been added so that a formula can test the state of the financial statement.

   'Include Y/E Adj' and 'Ignore inactive accts' options have been added in statement groups. This information will be printed if “Statement Group” is selected in File | Send to sheet.

   The current row and column is now easier to determine with the column and row number highlighted.

   You can now protect the Excel worksheet that is created when you ExcelDirect a financial statement. The Protect option is enabled in the Edit menu.

   Remove Row and Remove Column on the Edit menu have been renamed Delete Row, Delete Column for consistency.

   Speed keys have been added to most Menu choices.

   The Verify SmartSheet command now ignores inactive accounts.

   You can now enter hyperlinks such as web addresses into cells in a financial statement and these hyperlinks will be preserved when a statement is sent to Excel.

Problems fixed

   You are now prevented from changing the relative position of the Description column when creating a drag & drop Smartsheet as this caused problems in the construction of the cell formulas.

   Saving a statement as a template now works correctly if the statement has not yet been given a name. The default directory for the Template is now the System area, not your data directory.

   Selecting “Separate Dr/Cr columns” when creating a drag & drop financial statement now correctly ignores the Revenue sign on accounts.

   It is now possible (or easier) to cancel a Print or Export of a Statement Group.

   User Department Restrictions are now sorted by user code.

   The maximum formula length has been increased. This will reduce the possibility of an error being returned from a formula containing the RNGMERGE function.

   When using Departmental Restrictions, the value returned by the RNGMERGE function was understated.

   When you right-clicked on a range of cells in a financial statement in FX 9.0A, the Copy and other options were missing when the SmartSheet was expanded.

NOTE: Adagio FX 9.0A is NOT compatible with any version of QuickBooks.

• The retrieve from Simply Accounting now respects the 'Use existing budgets/forecasts' option. When enabled it allows sites to import their budgets. FX retrieves budget amounts from Simply exactly as they are stored in the Simply database, flipping the sign on Liabilities and Revenue. If the budget amounts are not what you expected you will need to use the import function available from the File | Import Account Budgets menu.
  
  
• As mentioned, the sign is flipped for Liabilities and Revenue Accounts when retrieving budgets from Simply Accounting. The sign is now the same as for G/L Accounts and Posted Transactions (i.e. stored as credits in FX), making it easier to compare figures or do math in the Financial Reporter. Note: this will require modifying existing financial statements to remove any work-around previously used to adjust for the difference in sign.
  
  
• Corrects other problems with retrieving Budgets from Simply Accounting.
  
  
• Added an Excel Direct button to a number of grid screens. Use the 'Enable SF Export' option in Edit User to enable or disable the Excel Direct button.
  
  
• The Financial Reporter now allows all users to see View | Customize.
  
  
• The Financial Reporter now allows multiple users to be in Maintain Financial Reports at the same time.
  
  
• Corrects a problem in Financial Reporter where duplicate accounts were being reported in the Verify function of Chart of Accounts View.

  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 \\myserver\accounting\. 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 \softrak\system 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.