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.