Adagio FX Change log


Adagio FX
9.2A | 2016-05-17 (May '16)
  Go to top
Release Notes
Print This

    General Features

    ·    This release is Adagio Cloud ready.

    ·    This release has been updated to use the same features and data structure as Adagio Ledger 9.2B (2016.05.16) wherever applicable, including reports.

    ·    Added Adagio Toolbar.

    ·    Adagio FX now logs user activity within the application. The application log may be viewed with Adagio Console 9.2A or GridView.

    ·    The Edit / View Accounts 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).

    ·    Account Filters can now be displayed in Style Priority sequence. Added ‘Display Priority’ field to the grid in the Edit Account Filters function. This makes it easier to tell the sequence in which Styles will be applied. The setting of the sort option is saved by user.

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

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



Adagio FX
9.1B | 2014-11-26 (Nov '14)
  Go to top
Release Notes
Print This

    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.



Adagio FX
9.1A | 2014-06-19 (Jun '14)
  Go to top
Release Notes
Print This

    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.



Adagio FX
9.0B | 2011-11-24 (Nov '11)
  Go to top
Release Notes
Print This

       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.



Adagio FX
9.0A | 2011-09-23 (Sep '11)
  Go to top
Release Notes
Print This

    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.


Adagio FX
8.1C | 2010-11-29 (Nov '10)
  Go to top
Release Notes
Print This

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

  • Compatible with Simply Accounting 2010.

  • Compatible with Windows 7.

  • Updated Adagio Ledger sample data to 9.0B.

  • You could not open the sample data with the Simply Accounting or QuickBooks versions of FX. For these versions the option Open sample data' has been added to the Open Adagio FX Data screen. This was not a problem in the Pro version or the product Evaluation version.

  • Install, workstation install and Service Pack install now support installing to a LINUX server without the special command line parameter /LINUX. Note: This prevents problems with future installs but if you encounter a problem with read-only files from a previous install you must correct it manually to set all Adagio files to read-write. Financial Statement Designer

  • Duplicate row / column now retains all formatting, including shading.

  • Statement recalculation happens automatically when changing fiscal periods and toggling zero suppress.

  • Expanding a .Range or .RangeDept that is "Hide when printed" now copies that attribute to the expanded rows.

  • User level departmental restrictions have been significantly improved. Users restricted to specific departments may now add, modify and delete statement groups. Additionally, if they have modify access to a statement, they may make changes and still be restricted to the departments they are authorized to view. Statement groups may be flagged as only being available to the “SYS” user.

  • The cell containing the column specifier in a .ColSpec row can now support multiple values. Drag the values you want available at the top of the column from the “Data View” onto the cell. A drop-down will be created containing all the specification codes selected. Users can choose which value they want displayed using the drop down. To reset the cell to an empty value, right mouse click on the cell and select “Clear contents” from the pop-up context menu.

  • In the financial statement, you can now use the $Y parameter in the header or footer of the statement to place the string “As of Month dd, yyyy”. The date will be for the fiscal period of the statement.

  • A "Clear Selections" button has been added to the Select Fields dialogue of the Drag & Drop process to insure that you do not get any unwanted fields.

  • A "Clear" button has been added to the View | Customize | Settings dialogue to clear all of the optional settings.

  • The Select Fields dialogue of the Drag & Drop process now shows which sections have a field selected.

  • The function =GLDESC() no longer reports an error when referring to a blank cell for the account range.

  • When sending a statement to Excel as values, the performance of deleting the hidden rows has been noticeably improved. Also, for large sheets with many rows the same size, the sizing of rows and columns has been noticeably improved. Adagio FX 8.1C 2 of 3 FX20100113 25-Jan-10

  • Import from ExcelDirect now works properly with Vista and Excel 2007.

  • QuerySheet would not return the correct cell value when columns above “AA” were referenced rather than as a named range.

  • Using the ExcelDirect function on strings containing a “-“ resulted in Excel formatting them as dates. This has been fixed.

  • The BAL_M field now reports the correct amount for income statement accounts when printing for fiscal period 1.

  • A damaged chart of accounts group tree would result in the financial reporter hanging. This condition is detected in more cases.

  • The drill-down from the financial statement did not work properly if a transaction description was more than 38 characters.

  • Sending a sheet to Excel now executes the .Verify commands prior to the export.

  • Right Button | Insert formula | Current Date and Current Time correctly formats the cell.

  • Fixed a problem with placement of a graphic when using ExcelDirect from the Financial Reporter.

  • GLAMT now returns 0 (rather than an error) if referencing an empty cell for the account range.

  • VSUM has been changed to ignore hidden cells (zero height or width ). You can now do a VSUM( D11..D19) when collapsed with one or more of the rows being .Range and when you expand you will get the correct total. SUM(D11..D19) when expanded will behave as is and possibly double up the total.

  • Zero Suppress in the Financial Reporter did not work in some cases when a cell displayed as zero but actually contained a very small value.

  • The Excel Direct export from the drill-down to transactions in the Financial Reporter did not correctly format certain fields in the resulting Excel worksheet.


Adagio FX
9.0A | 2010-10-14 (Oct '10)
  Go to top
Release Notes
Print This

    The changes and improvements to Adagio FX with this release are significant. To make it easier to review the various changes that have been made, we have grouped them by function in this release note.

  • Multiple Years of History, including transactions, are now supported and can be retrieved from Adagio Ledger 9.0A or higher and from Simply Accounting.

  • New toolbar icons provide a cleaner look and differentiate this new version visually.

  • Fully compatible with Windows 7.

  • Supports the scaling text feature on Windows 7 (previously referred to as 'Large Fonts'). To increase the font size, from the Windows 7 Control Panel select Appearance and Personalization, Display, and 'Set custom text size (DPI)'. Enter a scale percentage and turn off 'Use Windows XP style DPI scaling'. You must off your computer and log back in for the change to be applied. Note: The option 'Use Windows XP style DPI scaling' must be off, and changing the scaling will cause your Windows desktop to be rearranged. Large Fonts are not supported on earlier versions of Windows.

    Sign-on

  • The 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 FX 9.0A 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 FX 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 FX save your Adagio User Id and Password and default them when logging into FX. The saved information is based on your Windows authenticated user name. This option may be turned off by editing softraksystemADS.INI and adding the lines: [Options] RememberUser=0 RememberPassword=0

    Edits

  • Grids and finders support the 'Account active?' flag in Accounts. Inactive accounts can optionally be hidden on most grids and finders. To hide inactive accounts, set the 'Active records only' option in the Column Editor for the grid or finder. This option also prevents you from editing inactive accounts or entering them in a batch.

  • Added 'Account normal sign' field in accounts to indicate the type of balance the account should normally have. It can be set to Credit, Debit or Both. The Data Integrity Checker will give a warning if an account balance is not 'normal'.

  • The Account Description field has been increased from 30 to 40 characters. Accounts also have a second description field. You can print the primary, secondary or both descriptions on the Chart of Accounts report.

  • Statistics fields in Accounts can be used to track units such as hours, gallons, pieces, etc. Statistics units and quantities can be shown on financial statements and optionally printed on the Detail Listing.

  • Forecasts feature added. Forecasts are similar to Budgets. Use Budgets to hold your original figures and Forecasts for revised budget figures. Both figures are available in the Financial Reporter. Forecasts are retrieved from Adagio Ledger 9.0A or higher.

  • Edit Fiscal Calendar is a separate function instead of part of the Company Profile. The Fiscal Calendar screen has been improved. The pop-up calendar is now available in the period start and end date fields. The date in the period description field can be formatted automatically using the period start or period end date.

  • 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, vendor list and other information in your database.

    Inquiries

  • The View Transactions/Budgets function has been enhanced. View Account Transactions has Debit and Credit columns instead of one column with positive and negative amounts. An Amount field is also available in Column Editor and GridView if you do not want to separate debit and credits. The View GL Entry function shows transactions that make up the entry. A Subledger Information section has been added to the View Detail screen. Forecasts are supported. The Year is selectable on View Budget/Forecast screen.

  • Users of Adagio GridView can add custom views to the Inquiries.

  • Added View Accounts function (i.e. Edit without ability to save). Security Groups can be used to allow users to view but not edit accounts.

  • Inquires menu added. The View Accounts function has been added to this menu. The View Transactions/Budgets function has been moved to this menu. Custom GridView views appear in this menu now, rather than the reports menu.

  • The Transaction Description has been increased from 30 to 40 characters. Transactions also have a second description field. The second description will be retrieved from Ledger 9.0A or higher. You can print the primary, secondary or both descriptions on the Detail Listing.

  • Retrieve Multiple Years of History, including transactions, can be retrieved from Adagio Ledger 9.0A or higher and from Simply Accounting.

  • Retrieves Forecasts from Adagio Ledger 9.0A and higher.

    Reports

  • The Fiscal Calendar can be printed.

  • Listing button added on the Group Setup window prints all options or enabled options only for a range of groups.

    Import / Export

  • Added Import/Export Transactions functions. Import functions for Net Changes, Budgets, Forecasts, and Statistics/Net Changes have been added. They are separate from the Import Accounts function.

    Miscellaneous

  • Added Purge Fiscal Year function.

  • Excel Direct from the financial reporter and smart finders 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 softraksystemssi2xl.ini. Refer to the Readme help file for details.

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

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

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

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

  • The sample data has been updated to current versions.

  • 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. Fixes made in FX 9.0A

  • When accounts were imported, the Opening Balance was set to the Closing Balance instead of zero for Income Statement accounts.

  • The User option 'Edit GridView' correctly prevents the user from editing views if not enabled.

    Financial Statement Designer

  • You can now use the Financial Reporter to enter or edit budget and/or forecast figures and write them back to FX. This is faster, easier and more convenient than using export and import. Write back uses =GLUPDATE(spec code, account, amount) formulas, where: - the spec code can only be a specific budget or forecast period (i.e. B[x]M or F[x]M), - the account can only be a specific account-department pair (or account if departments are not used), a #Range# cell error occurs if multiple account-departments are used, - the amount is the new budget or forecast amount you want to write to the data. There are no restrictions on GLUPDATE. Any fiscal year can be updated. The toolbar needs to be reset to show the 'Update Budget/Forecast' button.

  • =VSUM() has been improved to display only the sum of cells on the sheet that are visible (where the row has not been hidden). This allows the use of =VSUM(cellrange) to include rows which may be expanded by a SmartSheet.

  • Duplicate Row now inherits all the formatting from the duplicated row. Expanding a row with the attribute “Hide when printed” causes all the generated rows to have that attribute set as well.

  • Copying an entire sheet to a new worksheet now copies the formatting as well as the contents of the sheet.

  • A new property, 'Edit On Print', has been added to the context menu when cells are selected. Cells with this property may be changed by a user when a statement is opened in “Print only” mode. For example, this allows a user who is restricted from editing statements by security Group to be able to enter and update budget / forecast figures. Cells marked with this property have a pale yellow background. This default may be changed under View | Properties. The chosen color shows up when viewing the spec but does not appear on Print Preview or when printing to paper.

  • User level departmental restrictions have been significantly improved. Users restricted to specific departments may now add, modify and delete statement groups. Additionally, if they have modify access to a statement, they may make changes and still be restricted to the departments they are authorized to view. Statement groups may be flagged as only being available to the “SYS” user.

  • You can now control which fields are displayed and their order in the display when you drill down to the transactions in the Financial Reporter. In the View | Customize | Settings dialog, select the (Tx) Details button. Use this to set which columns appear and their order, similar to the column editor found on most grids in Adagio. This works in both transaction views. The setting is specific to a company dataset.

  • Added “Ignore Inactive Accounts” toolbar button. When this option is enabled, all accounts marked “Inactive” in your chart of accounts will not be visible in any of the Views or included in any calculations. In order to view the new button you need to reset your toolbars after upgrading. To do this, go to View | Customize, Toolbars tab, select each toolbar in the list and click the Reset button.

  • In the View | Departments panel, you can now click on a department and see which accounts it uses. You can also see the current balances in the View | Chart of accounts panel in Edit mode (but not if the user has departmental restrictions in place). Use the Right button mouse context menu to refresh the figures if you have changed the fiscal period.

  • When using Verify Statement in the View | Chart of accounts panel, duplicate account references will now also be detected and marked with a blue exclamation point. Right mouse click on the duplicated account and click “highlight multiple cells” to see the account ranges where the duplication has been detected.

  • The cell containing the column specifier in a .ColSpec row can now support multiple values. Drag the values you want available at the top of the column from the “Data View” onto the cell. A drop-down will be created containing all the specification codes selected. Users can choose which value they want displayed using the drop down. To reset the cell to an empty value, right mouse click on the cell and select “Clear contents” from the pop-up context menu.

  • In the financial statement, you can now use the $Y parameter in the header or footer of the statement to place the string “As of Month dd, yyyy”. The date will be for the fiscal period of the statement.

  • An optional parameter to the QUERYSHEET() function has been added to allow specification of the fiscal year. Use the 5th parameter to specify the index of the year you are trying to access. 0 is the current year. 1 is last year, 2 is the year before that and so on.

  • Added Active Users and a download link to Help | About.

  • A "Clear Selections" button has been added to the Select Fields dialogue of the Drag & Drop process to insure that you do not get any unwanted fields.

  • A "Clear" button has been added to the View | Customize | Settings dialogue to clear all of the optional settings.

  • The Select Fields dialogue of the Drag & Drop process now shows which sections have a field selected.

  • The NET Changes functions now return the full year net changes, including the Year End Adjustment bucket if needed.

  • A fiscal year drop-down is available to print amounts based on a different year.

  • A number of new fields are available, such as Forecasts and Statistics.

  • ExcelDirect can now send to a sheet the values only in the financial statement. This option is turned on under View | Customize | Settings.

  • Drag and drop automatically freezes rows, so the new form repeats those rows at the top of each printed page.

  • A 'column page break' has been added to force page breaks by columns, just like by rows. Use Ctrl L to set the column page break.

  • Multi-year comparative statements are now supported. Virtually any "code" can take a prefix of the form {n} when n is an integer ( 0 to 9) which indicates a "prior year" relative to the selected year. This means that Y or {0}Y is Current year to date and {1}Y is the prior year, {2}Y is two years prior, etc. and {-1} is next year. You can go back as far as you have data in your database, up to a maximum of 10 years can be reported on at one time.

  • View Account Groups | Reset to default reads the new Account Groups set up in FX.

  • Financial Reporter can save specifications as Templates, which can be used to create new specs. Template preview thumbnails are shown when opening templates. (A JPEG preview of spec also saved with Template).

  • Sample data includes new Financial Report specs to demonstrate prior years (AF!Income3Years and AF!Balance3Years) and next year budgets and forecasts (AF!BudgetFuture). All new fields available in FX 9.0A are shown on AF!SuperSpec90.

  • New sites can use financial statements without modification once they have set up their Account Groups in FX. AF!BasicStatements are based on the default Account Group for FX 90A. It includes a cover sheet, balance sheet, income statement and trial balance. AF!BasicStatements is also available as a Template from FileOpen template.

    Fixes made in FX 9.0A Financial Reporter

  • Zero Suppress did not work in some cases when a cell displayed as zero but actually contained a very small value.

  • Dates displayed when using GLFPS() and GLFPE() are now correct in all cases.

  • Statement Group issues with Excel Direct and adding a new group have been corrected. All users may now create statement groups, not just the SYS user.

  • You can now use Edit ColSpec function on the right mouse menu on a ColSpec cell to delete.

  • SelectedDepartments= and Department= used at the same time now works in the Auto-Retrieve.


Adagio FX
8.1B | 2008-11-10 (Nov '08)
  Go to top
Release Notes
Print This

  • Compatible with QuickBooks 2009.

  • Compatible with Simply Accounting 2009.

  • Error handling has been approved when attempting to connect to a Simply Accounting database with either the wrong credentials or when the user has not been granted access to Third-Party products in Simply's User setup.

  • An issue when retrieving Prior year from Simply Accounting where some values were doubled has been fixed.

  • A problem which could cause the QuickBooks retrieve to fail because of a Data Source Name (DSN) error has been corrected.


Adagio FX
8.1B | 2008-07-25 (Jul '08)
  Go to top
Release Notes
Print This

  • When retrieving from non-Enterprise versions of QuickBooks you were asked to register QODBC. This should not have been required and has been removed.

  • When retrieving from Adagio Ledger 9.0A the error "The fiscal periods do not match the existing data. ..." was falsely displayed.

  • Drill-down issues for restricted users and single accounts have been fixed in the Financial Reporter.

  • An occasional issue with multiple users accessing Adagio FX has been fixed.

  • An unnecessary requirement for Ledger 9.0A dictionaries to be present when retrieving from Ledger 8.x has been corrected.

  • Multiple retrieves from Ledger 9.0A now works as expected.

  • Updated Ledger sample data to Ledger 9.0A.



Adagio FX
8.1B | 2007-12-11 (Dec '07)
  Go to top
Release Notes
Print This

  • Compatible with QuickBooks 2008. The Use Class as Department feature will only work reliably with QB Enterprise.

  • Compatible with Simply Accounting 2008.

  • Compatible with Microsoft Office Accounting 2007 and 2008, Professional editions. (FX is no longer compatible with Microsoft Small Business Accounting 2006).

  • Compatible with Adagio Ledger 9.0A. However, FX only retrieves current and 1 year prior, although Ledger supports multiple prior years. FX 9.0A will support multiple years and will be able to retrieve multiple years from Ledger. Fiscal period 14 in Adagio Ledger 9.0A is added to the last fiscal period in FX to maintain integrity.

  • You could not paste serial numbers and install codes into the install screen using the right mouse menu, although Ctrl-V worked fine.

  • Left side of the Status Line now shows the data path and extension when appropriate.


Adagio FX
8.1A | 2007-10-22 (Oct '07)
  Go to top
Release Notes
Print This

  • The 8.1A (2007.08.24) release of FX only retrieved from QuickBooks Enterprise. When retrieving from non-Enterprise versions you received the message "[QODBC] Only Licensed for use with Enterprise Version. Please contact your dealer for an upgrade." FX now works with all non-Enterprise versions and an upgrade to QODBC is not required.

  • On a newly created dataset the sample specifications were not created and the default Chart of Accounts, Account Groups, Departments, and Statement Groups were not initialized in the Financial Reporter.


Adagio FX
8.1A | 2007-08-24 (Aug '07)
  Go to top
Release Notes
Print This

  • Compatible with Windows® VistaT.

  • Compatible with Adagio Lanpaks 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 (\softrak\allwkst\allwkst.exe), 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.

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

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

  • Many updates, improvements and corrections have been made to the on-line help for the Financial Reporter.

  • The function 'Active Users' has been added to the Help menu. This function lists the users and the applications they have open for the company you have open.

  • Further improvements made to retrieve from QuickBooks 2007 when using Classes as Departments.

  • The "Retrieve prior year" from Simply Accounting now correctly retrieves the prior year budgets.

  • The Source Journal reports could not be printed in version 8.0D, 8.0E and 8.0G.

  • The all workstation install (Allwkst.exe) did not work for Adagio FX. You can now do a workstation install for multiple Adagio products at the same time.

  • The Trial Balance Worksheet now prints only one line per account.

  • The Help | About screen now shows the version of QODBC used to interface to QuickBooks.


Adagio FX
8.0G | 2007-03-08 (Mar '07)
  Go to top
Release Notes
Print This

  • Added Column Page Break to the Financial Reporter for better control of pagination when printing statements.

  • Improvements made to retrieve from QB 2007 when using Classes as Departments.

  • Fixed an issue with the Financial Reporter when expanding a .Range line with multiple segments.

  • When 8.0G (2007.02.09) was installed as an upgrade the splash screen displayed when FX was run said 2006 instead of 2007.


Adagio FX
8.0G | 2007-02-09 (Feb '07)
  Go to top
Release Notes
Print This

  • Compatible with QuickBooks 2007 USA and Canada.

  • Compatible with Simply 2007.

  • Simply Pro users now have the option to retrieve either the current year's data OR the previous year's data.

  • Warning message is displayed when retrieving QuickBooks if the "User defined accounts" option is selected and an "undefined" account is encountered.

  • The method of retrieving Classes as Departments from QuickBooks US has been modified to include the first level of SubClasses. This will impact the assignment of the Department code in FX and you may need to adjust your Financial Statements.

  • Financial Statement Designer:
  • An option was added under View|Customize|Settings to force Excel Direct to send values rather than formulas.

  • Fixed problems with Excel Direct when using $D, <<, >> and ==.

  • Users with a Departmental Restriction can no longer View or Print Statement Groups.

  • When creating a new financial statement using drag and drop, Use Colspec format is now the default choice.

  • Drill down to Tx Details is now available when using the ColSpec format.

  • Drag and Drop using the ColSpec format "freezes" to top rows of the statement. Printing will include these rows on each page.

  • In some cases, Row Formatting and Zero Suppress when used together did not apply the proper formatting. This has been fixed.


Adagio FX
8.0F | 2006-10-20 (Oct '06)
  Go to top
Release Notes
Print This

  • Retrieve from QuickBooks 2006 (US) using Classes as departments now works more reliably.

  • Financial Statement Designer:.

  • When creating a financial statement, you can now select to have the resulting statement use the new ".ColSpec" SmartSheet command for its formulas.

  • Several new functions have been added and can be placed on a statement from the context menu.

  • Three new financial statements have been added to the sample data.

  • AF!FunctionExamples and AF!DateFunctionExamples have been updated to include more examples.

  • An AutoSum button has been added to the format menu.

  • You can force the user to specify a fiscal period for printing a Statement Group.

  • File | Import from ExcelDirect has been added to allow the creation of a SmartSheet financial statement directly from a formatted Excel spreadsheet.

  • Sending a statement to Excel using the ExcelDirect button now sends the Excel compatible formulas (=SUM(), etc.) where appropriate.

  • When a single row is selected, it can be duplicated in a single action by selecting "Duplicate row" from the right mouse button menu.

  • In the Header/Footer of a statement, you can now use "$U" for the User Initials and "$L" for the full user name of the person who printed the statement.

  • Importing a financial statement from ACCPAC Plus now creates a SmartSheet and its results more closely mirror the original DOS specification.

  • A user restricted to viewing certain departments is now no longer able to create departmental ranges and masks.

  • A covered cell now shows the focus if it is selected.

  • Expanding and collapsing a SmartSheet would sometimes result in rows that should have been hidden, being displayed.

  • Turning on "blank when zero" would sometimes prevent the pop-up (context) menu from displaying the total of selected cells.



Adagio FX
8.0E | 2006-03-06 (Mar '06)
  Go to top
Release Notes
Print This

  • Compatible with QuickBooks 2006 in the US.

  • Supports retrieve from Microsoft Small Business Accounting 2006.

  • Account and department numbers have been expanded to support 12 and 12 characters.

  • When creating a new database, you are now prompted for the fiscal period start date.

  • You can now edit both the current and prior year fiscal calendars.

  • You can now delete a single department and all its associated transactions from an Adagio FX database.

  • When retrieving from Adagio or ACCPAC Plus, you may use your existing Group tree by selecting a new option on the retrieve dialog.

  • Retrieving data from Simply Accounting now retrieves the correct department names.

  • A problem using a Regional Language setting other than USA when retrieving QuickBooks data has been fixed.

  • The ZIP file created using File | Backup now uses the prefix "AF".

  • You can now send a complete set of financial statements to an Excel workbook.

  • View | Customize | Settings also allows you to change the text for a consolidated statement, and what is displayed for a $0.00 value on a statement.

  • You can now restrict which departments (or department groups and ranges) a user is permitted to see.

  • The functions ACCOUNTGROUP() and ACCOUNTGROUPDEPT() have been added to allow linking between a financial statement and the Account Group tree.

  • Alt-up arrow and alt-down arrow are now active to re-order the department print sequence in Edit Report Item from a Statement Group.

  • View | Departments | Edit Departmental Range has been added to allow you to directly change both the range and description of a departmental grouping.

  • The functions USERINITIAL() and USERNAME() have been added to allow printing of this information on a financial statement.

  • Account Data mnemonics have been added to directly retrieve the provisionally posted figures from a dataset.

  • You can now easily determine which accounts have not been referenced on a financial statement.

  • Double clicking on a cell in a financial statement now drills down to the details rather than editing the cell contents.

  • The QUERYSHEET() function now switches to the specified sheet and recalculates it prior to returning any value.

  • Blank departments are now handled correctly.


Adagio FX
8.0D | 2005-03-14 (Mar '05)
  Go to top
Release Notes
Print This

  • Compatible with QuickBooks 2005 and Simply Accounting Pro 2005. Does not support 7 or 8 digit account numbers at this time.

  • You can now delete a department from a combined ledger.

  • New options have been added to the retrieve.

  • Retrieving a new dataset from Adagio or ACCPAC Plus used to reset the account groups.

  • Budgets are now properly retrieved in QuickBooks datasets where the fiscal calendar is not January - December.

  • You can now retrieve transactions from QuickBooks or Simply Accounting into a 13 period fiscal calendar (Pro Version only).

  • The Financial Reporter now correctly handles a "blank" department code.

  • A $X command has been added as a parameter for the Header/Footer section and returns the data path of the statement being printed. The header/footer section now supports the following codes:.

  • $A - Application.

  • $C - Company name.

  • $D{format} - Print Date{=DATESTRING() specs}.

  • $F - Specification file name.

  • $R - The sheet name.

  • $X - The path to the specification file.

  • The order of sheets in a workbook can be changed.

  • You can multi-select rows or columns to insert or delete rows or columns.

  • New functions have been added.

  • =YEARL(date).

  • =ToWords(n[,IsCurrency]).

  • =FISCAL(1).

  • =QuerySheet("Sheet","Cell"[,Fiscal],"Dept"]).

  • Placing ".ShowAccounts" in cell B1 of a SmartSheet will print the account ranges (only hiding column A prior to print).

  • ".AutoUpdate" and ".RowFormat" have been added to the right button mouse menu when the cursor is positioned over the correct cell.

  • Toolbar buttons have been added to change the orientation from portrait to landscape, and autofit selected rows and columns.

  • The "Useful text string" formulas on the right mouse button now use the DATESTRING function when inserting fiscal calendar references.

  • Find/Next has been improved. Zero suppression now works more reliably. Copy and pasting formulas between worksheets is now supported.

  • The .Verify command has been improved and will now report "duplicate" accounts.

  • Ctrl-< and Ctrl-> will decrement or increment the fiscal period respectively.

  • The account group tree would not display if the username and password were not specified in uppercase.

  • Alt-UpArrow and Alt-DownArrow now moves an item in Statement Groups.Statement Groups can now be printed by selecting "Send to sheet | Statement Groups. The option "All departments" has been added to Statement Group print. Departments added to the ledger will automatically have their statement printed. Statement Group Print allows you to restart page numbering on a specific statement. Statement Groups are only available in the Pro version..

  • PRO ONLY: The designer now supports up to 16 sheets in a workbook.

  • PRO ONLY: =QUERYSHEET("sheetname","Cell" [,Fiscal period] [,"Department"]) has been added.



Adagio FX
8.0C | 2004-10-25 (Oct '04)
  Go to top
Release Notes
Print This

  • Statement Group Print was not always doing a complete "recalculation" before printing.

  • Statement Group Print has been enhanced to allow you to Open all or selected statements from within the group.

  • Statement Group Print allows you to choose "Previous" as a fiscal period.

  • Statement Group Print allows you to select "Consecutive page numbering".

  • Excel Direct now correctly handles "frozen" rows and columns.

  • ADSELECT has been updated to correct an occasional problem when using wildcards.

  • The DEPARTMENT function has been enhanced to return the Department description associated with a wildcard or department range.

  • The Departmental Drag and Drop has been modified to make use of the new DEPARTMENT function capability.

  • The Department View now allows you to control the order in which the departments are shown.

  • A new function called ADTITLE("symbol") has been added which returns the description associated with a symbol.

  • New symbols for Prior Period Net Change have been added to the Account Data tree. These symbols are of the form NET_{symbol} and are useful in producing "rolling" statements.

  • $C in the Header/Footer section will insert the Company Name from the company profile.

  • A new toolbar button has been added to easily switch between portrait and landscape.

  • You can edit the [Override] section AFFinRep.Ini file to change the text that is associated with "DEPARTMENT(1)".

  • The retrieve from QuickBooks datasets now ignores "forecasts" rather than treating them as "budgets".

  • AF!DeptDemo.sam has been updated to use the new DEPARTMENT function to return the FR Department description instead of the GL Department Description.

  • AF!RollingIncomeStatementNET.sam: has been added to show a rolling monthly Income Statement using the new symbols for Prior Period Net Change.

  • AF!SuperSpec.sam has been updated to show the new symbols for Prior Period Net Changes.

  • In AF!FunctionExamples.sam, the Header/Footer parameters sheet has been updated to add $C, Company name.

  • When retrieving from Adagio Ledger or ACCPAC® PlusT General Ledger databases with FX 8.0C (2004.06.16) you received the error ""Error Internal Error: field [41] of @L68BGLO] is not a Boolean field, occurred when attempting to read next record in AF global.". The retrieve was otherwise successful and FX functioned correctly.

  • The browse button on some dialogs in the Financial Reporter and on the EZTasks dialog did not work on some Windows 98 machines.

  • Links to the web from the Readme help are now working in all cases.



Adagio FX
8.0C | 2004-06-16 (Jun '04)
  Go to top
Release Notes
Print This

  • You can now define entire groups of financial statements to print without operator intervention.

  • A new SmartSheet command ".RowFormat" allows you to apply any formatting desired to generated rows.

  • When creating a departmental comparative, you can now create a column that sums just the departments you have selected.

  • ".RangeDept" in column A of a Smartsheet will expand the specified account range once for each department in the range, without altering the account range specified.

  • An option has been added to the drag-and-drop format dialog to insert a thin column between numeric columns.

  • When turning on "Zero suppress", the Financial Reporter now also hides the zero rows on the financial statement you are viewing, not just on the print preview.

  • Financial statements now automatically have "AF!" added to the name, if it is not specified by the user. The "data selector" will also be added too if necessary.

  • File | Import in the Financial Statement Designer now allows you to retrieve specifications created in Adagio Ledger.

  • The Financial button on the toolbar launches the Financial Reporter in maintain mode unless security prevents it.

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

  • When retrieving from Simply Accounting or QuickBooks, you can have transactions allocated to a fiscal calendar you have adjusted.

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

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

  • Expand, drill down and .Range now respect the department ranges and masks chosen from the departmental drop-down.

  • File | Send to sheet | Departments now sends all department including specially created ranges and department masks to the sheet.

  • The department select drop down box now behaves better when there are large numbers of departments to choose from.

  • Changing the formatting of a column or row works more logically when the entire column or row is selected.

  • In Ledgers with 13 fiscal periods, the drill down to the detail transactions was off by one period.

  • Dragging and dropping single accounts or departments onto a sheet would sometimes result in the Financial Reporter "hanging".

  • When expanding a row containing covered cells, the cell coverage was not copied to the generated rows.

  • The financial reporter toolbars are better positioned the first time the reporter is opened.

  • VSUM() would sometimes not correctly sum the specified range.

  • In some cases you were not able to delete Departmental Masks within the Department View of the Financial Reporter.

  • The importing of accounts and transactions from other systems has been significantly improved.

  • Import functions write errors to a log file (GLIMPERR.xxx, where xxx is your company data extension).

  • Defaults fields in import templates are now validated during import.

  • If you copy your database do another directory, the path to the import file in the default import template is automatically updated to the new path.

  • The default file names for import and export templates have changed.

  • Export Accounts no longer permits you to set the option "Export figures as" when not appropriate. It always defaults to "Net changes'.

  • When importing accounts with 'Add new records' off, the 'Account type' field is no longer a required field in the import file.

  • When importing batches, only the 'String' type worked for date fields. The 'ASCII - YYYYMMDD' and 'Date' types now work.

  • The import functions now show the field name and other details in error messages even if 'Validate before importing' is not set.

  • If the 'Validate before importing' option was on, and there was an error in the import file, the program closed in some cases.

  • If the Account Code is invalid in an import batch, the error message said the Department Code was invalid.

  • The import functions now check for invalid dates in all cases.

  • Importing accounts to a departmentalized GL with the 'Validate' option on and where the import file did not include the current balance caused a integrity error.

  • Import failed in some cases if the last field on a line in the import file was empty quotes.

  • The import functions now strip leading zeros from account and department fields in the import file.

  • In some cases, files containing a comma in a string field could not be imported.

  • In some cases, there was an error when importing when string fields contained a comma.


Adagio FX
8.0B | 2004-05-04 (May '04)
  Go to top
Release Notes
Print This

  • "Use existing fiscal calendar" has been added as an option when retrieving account data; allows you change the fiscal ending dates away from the month end when retrieving data from Simply Accounting or QuickBooks.

  • The account type was being incorrectly set when classes were being retrieved from QB datasets.

  • When retrieving figures from QuickBooks datasets, the COGS account would be out of balance when Inventory was in use.

  • QBB (QuickBooks Backup) files are no longer displayed in the Retrieve dialog.

  • When retrieving budget figures from Simply Accounting, the amounts retrieved are now adjusted when departments are used.

  • Retrieving a new set of figures was resetting the Account Group tree in the Financial Reporter.

  • The install now checks to ensure the current user has rights to write to the Adagio program directories and can access the areas of the Windows registry required to install and run Adagio. The chksys utility also makes these checks for the current user.


Adagio FX
8.0B | 2004-02-19 (Feb '04)
  Go to top
Release Notes
Print This

  • Supports QuickBooks 2004.

  • Problems that occurred when retrieving from COSS Simply ManufacturingT have been corrected.

  • Print preview magnification settings are remembered between sessions in the Financial Reporter.

  • You can now drag individual Account-Department pairs from the Account view onto a Smartsheet.

  • The "look" of the menus and menu bars has been updated in the Financial Reporter.

  • Single character department codes now work in the Financial Reporter.

  • The initial position of the menu bars in the Financial Reporter is better the first time it is launched.

  • The QuickBooks backup files no longer show up in the list of files to retrieve from.

  • When retrieving from QuickBooks using user defined accounts, the account type was incorrect in some cases.

  • The install and workstation install now check the "Opportunistic Locking" settings to ensure they are correctly set on the workstation.

  • The Check System utility now contains just a brief summary, and there is a "View Details" button to see the full details of the scan, which previously could only be seen by examining the log file.


Adagio FX
8.0B | 2003-11-18 (Nov '03)
  Go to top
Release Notes
Print This

  • QuickBooks users may now treat Classes as departments when the data is retrieved.

  • When retrieving data and assigning it to a department, you can now preserve some (or all) of the incoming department identifier, should your ledger already use departments.

  • For QuickBooks users, the financial reporter supports the new field "gldata.TOTPOST" to display the total amount that has been posted to an account across all fiscal years.

  • In the financial reporter, single character department codes now right justify properly, and single department ranges are processed properly.


Adagio FX
8.0A | 2003-07-22 (Jul '03)
  Go to top
Release Notes
Print This

  • A data integrity error occurred after retrieving from a departmentalized GL with the 'Append to existing data' and 'Replace existing departments' options enabled.


Adagio FX
8.0A | 2003-07-03 (Jul '03)
  Go to top
Release Notes
Print This

  • Earlier versions of Adagio FX 2003 8.0A did not support 13 period fiscal calendars.

  • You received an error if you tried to open a Simply Accounting or QuickBooks database directly from FX rather than creating an FX database and retrieving. The error message has been changed to explain the problem.

  • Adagio FX now installs an empty FX database in \SOFTRAK\AFWIN\DATA. This allows you to immediately retrieve your accounting database to FX after installing the product.


Adagio FX
8.0A | 2003-05-31 (May '03)
  Go to top
Release Notes
Print This

  • Full version of Adagio FX 2003 released.

  • QuickBooks is now supported without requiring additional files from Softrak Systems.

  • An error occurred in the FX Financial Reporter if an Adagio Lanpak was installed and had not yet been registered.

  • A floating point error was generated in some cases when retrieving from Simply Accounting if values exceeding 999 million were encountered.

  • Budget figures were incorrect in some cases when retrieving departmentalized budgets from Simply Accounting.

  • Accented characters were not displayed correctly in the FX Financial Reporter.

  • When retrieving Adagio Ledger / ACCPAC Plus General Ledger data from a directory containing other Adagio / ACCPAC Plus application data, an error was received (e.g. "Unable to load the dictionary $R65A.").


Adagio FX
8.0A | 2003-05-12 (May '03)
  Go to top
Release Notes
Print This

  • Initial release. Released as an Evaluation version only.