Enhancements & Revisions



Adagio Ledger 9.2A


November 20, 2014



    The changes and improvements to Adagio Ledger 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. The Financial Reporter features and fixes are below, listed separately from General Ledger.

    General Features

    ·    You can now start other Adagio modules from toolbar buttons showing the icon for the module. This allows easy switching between Adagio modules. If a module is running against the same company data, Adagio will now just switch to that running instance, rather than launching a second instance. Toolbar buttons can be rearranged under File | User preferences, or by dragging the buttons around or off the toolbar itself.

    ·    Adagio Ledger now logs user activity within the module, including login, menu choices and batch New, Edit, Copy, Delete and Post. Audit logs may be viewed with GridView.

    ·    The Edit Accounts, View Accounts, Edit Forecasts and Edit Account History grids now display the total number of records, as well as a count of the displayed records when a Filter is active.

    ·    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

     


    ·    Added an Ignore Style Color button on the Edit Accounts and other edit grids. 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). Edit Styles and Edit Filters grids always display with Style colors.

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

    ·    Added a Status button to the toolbar for the Batch Status Inquiry.

    ·    Added Filter criteria 'Before today' and 'After today' for Floating Date Range.

    ·    Added several new Ledger specific Styles for use in Filters.

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

    ·    Updated sample data including subledgers to demonstrate new features in Ledger 9.2A and changed the Fiscal Year from 2007 to 2008.

    ·    The System Status function (chksys.exe) will now examine existing references to the Adagio area (such as Adagio System Drive, Reports Tables Drive, etc.) and attempt to check that the corresponding UNCs all refer to the same server. If not, it will provide a warning and details of all such references in the Status.txt file and the Detail portion of the screen. This is to try to identify server-reference issues if an entire Softrak folder area has been copied to another server (which violates recommended practices – modules should always be reinstalled on the new server). It does not guarantee integrity of such a move; it only assists in identifying possible issues.

    Edit Functions

    ·    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, but you can now create ranges for specific Due to/Due from and clearing accounts.

    ·    Implied decimal functionality is now disabled during budget and forecast data entry. A message is displayed saying “Implied decimal is disabled for this function.” The warning can disabled by ticking the ‘Don’t show this message again’ option on the dialog.

    Inquiries

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

    ·    Added ExcelDirect to the Batch Status Inquiry grid.

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

    ·    The 'Display period N only' option on the View Account Transaction screen has been moved from below the grid to above the grid to make it more prominent.

    Retrieve

    ·    Retrieve transactions from subledgers now allows the creation of multiple batches by either Posting Sequence or subledger batch within the general ledger. This allows automatic creation of a general ledger batch for each batch posted in a subledger, or for each posting run performed. Note: the new options do not separate batches in some cases for current versions of some modules as of the date of this release of Ledger 9.2A. See the Upgrading section below.

    ·    The Fiscal Year and Period are now hidden unless the “Specific period” option is selected.

    Batch Entry and Posting

    ·    You can now post transactions while you or another user have View Transactions or Financial Reporter open.

    ·    The Posted Transactions file structure has changed from a sorted sequential file to an indexed file. The new structure allows immediate viewing of entries in the View Transaction/Budgets function and in drill-down within the Financial Reporter at any time. The option 'Auto build TX inquiry index' added for 9.1A is no longer needed and has been removed.

    ·    Individual entries can now be inserted into the middle of a batch by pressing the Insert key on the transaction you want to appear after the newly inserted transaction (so you can insert a transaction at the beginning of a batch).

    ·    The Batch Control grid for Current, Archive and Next Year batches can now be displayed in Description as well as batch number sequence. The option is saved by user by company.

    ·    Added ‘Remember Account/Dept’ option to the Batch Options tab in the Company Profile. Enable it to remember the account and department (if used) codes entered on the prior detail to speed entry.

    ·    Restore and Add/Edit/Delete options for Archive batches can now be set separately in Security Groups. This can be used to allow a user to restore but not edit Archive batches.

    ·    A security option has been added to allow users to mark batches “Ready to Post”.

    ·    In previous versions of Ledger, there was only one posting sequence allowed at a time for the Unpost Batch journal. To be able to Unpost a second batch, the first journal had to be printed and purged. You can now have multiple Unpost sequences. Unpost journals can no longer be purged when printed and instead are purged at year end the same as other posting journals. A Posting Sequence field has been added to the Posting Journal.

    ·    Adagio ePrint users can now use %PJN code to embed the posting sequence in the Unpost Journal to prevent overwriting one sequence with another when printing to PDF.

    Reports

    ·    Adagio Ledger’s standard reports are now created using Crystal Reports 2013, replacing the Crystal Reports 8.5 Print Engine (CRPE32.dll). The module’s management reports are now stored in \Softrak\Ledger\StandardReports. Revisions to these reports should be placed in \Softrak\Ledger\ModifiedReports.  Custom reports to be added to the Reports menu should be stored in \Softrak\Ledger\CustomReports. Reports must be edited or created using Crystal Reports 2011 or 2013 and Adagio ODBC for access to the data files. Users will notice minor changes to some of the visual elements in the module and a new Print Preview window. The size and position of the Print Preview window are now remembered between sessions by user, so the Workstation options controlling this function have been removed. Exporting to an Excel spreadsheet from the print preview window has been significantly improved. Refer to the online Crystal help for details. The Report Tables Drive settings and Crystal tables in the \QRASP folder are not used by version 9.2A modules.

    ·    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, and allows reports to be placed on the Windows desktop. PrintTool 9.2A prints custom reports created with Crystal Reports 2011 or 2013 only. Adagio ODBC must be installed to create custom reports but is not required to print custom reports. Your Adagio dealer or consultant can create custom reports for you and deploy them at your site. Note: PT does not print reports created with Crystal Reports 8.5 for Adagio. Existing version 8.5 custom reports must be converted before they can be printed by 9.2A. PT allows you to specify a report to print on the command line using the /r parameter. This allows Adagio automation batches to print custom reports (to printer – a future release of PT will allow automation batches to print custom reports to PDF). PT does not require registration with Softrak Systems but does use Adagio Lanpak licenses.

    ·    The GL Detail Listing now permits fiscal ranges that span fiscal years. The report will print on a single page if only one account is listed. The ‘Curr. Year/prev period only’ option prints details for the period immediately prior to the login session date. This is useful as a report favorite to ensure the report is always based on the session date, even if the session date is in the next fiscal year. The ‘Hide transaction details’ option suppresses the individual transactions from being listed on the report if desired to just print out the net change amounts between periods. The ‘Include closing amounts’ option includes the closing amounts on any report that includes period 12 (or 13). This option is only available if the last period is included in the range.

    ·    The Unpost Journal report now supports all the standard posting journal report options, such as: Print a specific or range of sequences, Print just the last posting sequence, and Sort by posting sequence or account (detail or summary).

    Import/Export

    ·    Import templates for Excel file format now default the import file extension to .xlsx.

    Problems Fixed

    ·    Fixed a date field refresh problem in the 'Inquiry on Budget for' section in Edit Budget Data.

    ·    The Import Accounts function did not get a validation error when the import record had the wrong Account Type if the ‘Mandatory Account Groups’ was enabled in the Company Profile.

    ·    Workstation Options listed specific printers in reverse alphabetical order.

    ·    The size and position of Edit Account window were not remembered.

    ·    You can now select the 'Delete accounts with no activity' option from Purge Fiscal Year, and not have to select any of the other options to purge any data. This allows you to delete these accounts without having to purge an entire year.

    ·    In Ledger 9.1A, importing a Retained Earnings account immediately before an Income account caused an error.

    ·    When posting batches using automation, if the 'Require batch print before posting?' option was enabled, batches that had not been printed caused the automation job to fail and no batches were posted. Batches that have been printed are now posted, unprinted batches are skipped, and the automation job does not fail.

    ·    When a batch originating from a subledger and having comment lines is provisionally posted the Provisional Posting Journal had extra blank lines.

    ·    If a user tried to post batches to Prior Year when the batch was open the error “Format '%s' invalid or incompatible with argument” was displayed.

    ·    Ledger 9.1A did not remember the correct size when opened if the window had been maximized.

    ·    The Retained Earnings account set in the Company Profile or on a Department can no longer be an inactive account.   If it was made inactive, there are new warnings in the Data integrity Check.  Next Year cannot be created until the Retained Earnings accounts are active.  If Next Year had been created prior to making the retained earnings account inactive, in a prior version, new postings to income or expense accounts will fail.

    ·    When printing Favorite reports, the Current year/period and Prior year/period options now respect the login date when it falls in the Next Fiscal Year.

    ·    When non-contiguous batches were selected in the Batch Status Inquiry an error was displayed when you printed in the Posting Journal. Print PJ and Listing buttons are now disabled when a non-contiguous selection of batches has been made.

    ·    When the Multi Currency Detail Listing was printed in Source and Home a balance was shown under Home even when there were no details for the period.

    Enhancements in Financial Reporter

    ·    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 Ledger. The shortcut needs to have /a in the Target field (\Softrak\Ledger\LedgerFinRep.EXE). You can only launch the Financial Reporter once Adagio Ledger has been registered. Opening the program directly consumes a lanpak. The financial reporter will respect security settings set in Ledger.

    ·    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 Ledger, 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 the general ledger. 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 field “Amt – Source” has been made available for display in the transaction drill down.

    ·    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 added the referenced statements to the Most Recently Accessed list.

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

    ·    Inactive accounts are now managed the same way as in Ledger. They 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 can 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 in the general ledger.

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



© Copyright Softrak Systems Inc. All rights reserved.