•When the Security Group restricted access to Maintain Financial Reports, after opening Print Financial Statements, Maintain Financial Reports became available.

•If the Company Profile is set to use “North American Address?, Import Projects will validate State/Province. If Country is imported, it will also be validated.

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

•The Country list that will be normalized when 'North American Address?' is selected has been expanded to include more countries.

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

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

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

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

· In Import, the On Start Up option: Process Imports, is working for Projects, Account Projects, Account Notes, Departments, Source Codes, Account Statistics, and Account Reallocations.

· Crystal Reports used in printing Adagio Reports was not fully compatible with the Windows 22H2 update for Windows 11 and for Windows 10, in some cases.

· In Import, 'Delete import file on success?' has been added to the File Information tab for Account Budgets and Account Forecasts.  This is to work with the On Start Up option: Process Imports.

· Setting a Report Set Destination to use AdagioV3PDF as the printer caused an Access violation, in some cases.

· Designed for Adagio subledger retrieval has been updated to support “Super extended” files which includes new fields for: Docstore document link and Ledger Project code.

· If a Statement Group name contained an ampersand, the ampersand would be stripped when the Statement Group was added to a Report Set.

·          Financial Reporter 2.1.8.2771 shipped with Ledger 93B  (220404) Service Pack, did not correctly retrieve the Department code/description in some cases.

Note: for this command to work, the System date must be included in a Fiscal Calendar.

·For data sets that had created Next Fiscal Year Budgets for future years beyond Next Year, new budget/forecast records were not being added correctly from new account, copy account, copy department, or import account. This caused an error when you tried to update the Budgets or Forecasts using the Financial Reporter.

 · When Subledger batches were provisionally retrieved and the previous provisional posting information was not cleared before further posting, the retrieve function exited. However, the batches created, ready for provisional posting, were not being deleted. This caused Data Integrity errors.

·          Ledger was reporting Data Integrity errors for Error batches with Multi Currency details for Single Currency Accounts.

·          When the Detail Listing report with the option, 'Hide Transaction Details', was exported to Excel using ExcelDirect, the Account and Department were combined in column A of the Excel file.

·    Valid entry dates were incorrectly flagged as being in closed periods in Ledger and subledgers when Next Year and a subsequent budget year(s) were created. This not longer occurs and the integrity check fixes the problem for data in which the problem is already present.

·    When attempting to use the Grid Search procedure on the View Transactions grid and use the dash character in the search criteria, an error, ‘\\\"-\\\" is not a valid integer value’ would appear. The error no longer appears and the search is successful.

·    If the filter Styles list was saved with the App Specific and Generic setting, this would cause the Manual Style field within Edit Vendors to show an incomplete list of styles and result in a List index out of bounds error. Now, the complete Styles list is always shown in the finder and no error occurs.

·    When the integrity check detects a missing SmartFinder data file, Rebuild gives a more detailed message for the problem.

·    Printing reports is now logged in the Application log, in addition to when the user opened and closed the report screen.

·    When Editing properties for Text-type Optional Fields, a new Import button is now available to populate the list of possible values for this field. Only one-column Excel sheets without a header row are supported.

·   Detail only Batch import in Ledger 9.3B(21.02.25) an earlier required the account and department field to both be imported or defaulted.  This is no longer required.

·   Export transactions did not find any records if the first account/department in the selected range did not have any transactions and the department for the next account/department in the range had a lesser value.

·   After printing the Detail Listing report, the data files containing the Account Net Changes were not properly released, until the user closed the program.  This caused errors and potentially corrupted data if another user performed a function that required reading or writing to those data files.  The release is correctly performed now.

·   When an Accounts grid was set to show Active Records only and was changed to remove that setting, Inactive accounts were not correctly refreshing to the correct position and displayed at the end. The View Transactions/Budget did not display any accounts. Both of these situations have been fixed.

·   If Company Profile options for Post Invalid Entry to Error Batch and Require Batch Print Before Posting are both disabled, a warning message will appear at sign-on to indicate this is no longer a supported configuration and you need to change either option.

·   In the initial release of Adagio Ledger 9.3B, the new templates for Import Projects and Import Account Projects did not auto-import on startup if the option was enabled. This has been fixed.

·   The option on the Project Transactions report for Show Acct/Dept (or Project) Totals was not loaded from the Favorite settings when printing from the menu or a report set.

·   An error message will now appear if you attempt to save the Company Profile and options for Post Invalid Entries to Error Batch and Require Batch Print Before Posting are both disabled. This is no longer a valid combination of options.

·   When running Close Current Fiscal Year, the value for the next Prior Year Posting sequence is not reset to 1 as with all the other posting sequences.

·   When using either the Copy or Clear processes within either Edit Budgets or Forecasts, a new screen appears to allow selection of the Fiscal Year for updating values. Locked fiscal years are not available for selection.

·   When creating new data, the option for enabling MultiCurrency is now immediately available, rather than having to first create the data and then re-edit the Company Profile.

·   In View Transactions/Budgets and budget inquiry, changing the first fiscal year for Net Changes comparison did not update the fiscal period net change values for the selected year. This has been fixed.

·   DocLinks for documents attached to a batch were not being retained when the batch was Copied and Moved.

·   Printing Financial Statement Groups to the AdagioV2PDF driver incorrectly used 197001 as the value for the %SYM PDF code, rather than the login year and month. This has been corrected when printing to the AdagioV3PDF driver.

·   The batch listing button is now correctly disabled when multi-selecting batches from a grid that is sorted by Description. Changing the batch sort will reset the selection to a single row.

·   Retrieving subledger batches to Ledger in the cloud was not properly reading the subledger path.  This has been fixed.

·   Fixed a problem wherein, when neither DocStore nor ePrint were used and a user selected a Report Set Destination of Pinter=AdagioV2PDF or AdagioV3PDF, they were not being prompted for where to create the file.

·   When unposting a batch and auto-printing the unpost posting journal report, the default sequence number for the report was being read from the current year when the unpost number was the larger value. This has been fixed.

·   In some cases, emailing a Report Set did not include the PDF for Statement Groups. With AdagioV3PDF now controlling this procedure, this problem no longer occurs.

·   A standard listing report for Projects is available to print.

·   DocLinks for documents attached to a batch were not being retained when the batch was Copied and Moved.

·   The backup made during Close Income and Expense Accounts is now prior to the function being run.

·    Close is now the default on the confirmation message: “Batch entry is out of balance”. This allows Adagio XConsole to close a batch if a user is editing a batch that is not in balance. The batch will be saved in the out of balance condition.

·    In Ledger 9.2A and 9.3A, the ‘Restrict to Subledgers’ option in an account was not working properly for JobCost.

·    Source Journals did not print all the entries when the periods span 2 years and the second year has an A.

·    When ExcelDirect printing the Detail Listing report, the date format used in Excel is now from the User Preferences, Report Options tab 'Date format (Detail)' field.

·    Printing Statement Groups to PDF through report sets was displaying an AdagioV2PDF message even though 'Lock PDF setup?' was enabled in the Company Profile. It no longer displays the message.

·    Printing the Trial Balance report using a Favorite with the 'Current year/period only' option did not make the Fiscal Period uneditable.

·    Printing the Detail Listing report using a Favorite with the 'Current year/period only' or 'Curr. year/prev period only' option did not set the starting and ending Fiscal Periods properly. When printing from a Report favorite, the Fiscal Periods defaulted to 1 to 12 instead of the Current period or Previous period. Printing from a Report set or the Print/Delete Favorites function worked properly.

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

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

·    Corrected error that occurred in rare cases at some sites when retrieving batches containing transactions with links to DocStore documents from subledgers.

·    Import Header Detail batches was requiring the Det-Source Code to be in the import file or a message would appear: 'Default currency code is invalid.'.

·    Importing with Field offset was trimming the import field on the right instead of the left.

·    Export transactions failed for record counts exceeding 256,000.

·    Using an automation command to import transactions indicated success but did not actually write the new records to the transactions file. This has been fixed.

·    Automation has been updated to support importing batches from other systems that may have Unbalanced entries. For Automation imports, the Unbalanced Batch Warning message will default to 'Yes to All'.

·    Merging DocStore files inside the Maintain Documents window will now correctly merge the selected files into 1 document.

·    There was an error when creating a new database in Ledger 9.3A (2018.04.22).

·    The Data Integrity Check now corrects (removes) orphaned provisional posted batches from the current batch.

·    If you posted in Ledger while DataCare was open, then checked the database in DataCare without first closing it, DataCare falsely reported an error in Ledger.

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

·    The process which emails the Automation Log was modified to use the Display name of the Email setup instead of the Account name. The subject line was also changed to indicate whether reports are attached or not.

The Automation command EmailPDFAutoLog within modules did not work when you used the Office 365 SMTP server as your Mail Server for Direct.

·    For a MultiCurrency account, if a posting to prior year is for a Source currency that has not been posted to in the Current fiscal year, viewing the Account History did not show the Source currency amount for the new Source currency.

·    The Doc Link column on the View Account Transactions grid now shows ‘Linked’ when there is a DocStore PDF attached.

·    PDF documents attached for DocStore on the View Account Transactions grid did not remain attached to the transaction.

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

·    In Ledger 9.2A and higher, the Batch Status report for provisionally posted batches was blank.

·    When you printed a Report Set that has a Statement Group in it to a PDF file, the AdagioV2PDF Save PDF file screen displayed before the Statement Group PDF was generated, making it hard to print the Report Set unattended.

·    Printing a Report Set to PDF used the older AdagioPDF printer driver rather than the newer AdagioV2PDF printer driver. This caused a problem if an older version of some Adagio module that installed older AdagioPDF had not been installed at a site.

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

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

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

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

Problems fixed

·    Default file name was incorrect for the Detail Listing within a Report Set if the destination was to ExcelDirect.

·    The Restore button in User Preferences, Report Options, now restores all of the ExcelDirect print option defaults as well as PDF print options.

·    Favorites with long names were not retaining the ExcelDirect print options. You may need to edit and resave your favorites with 93A.

·    When importing batches, if the Det-Transaction Date field is blank in the import file, or if the Transaction Date field in not selected for importing, then the Session date is the value used for the imported detail. Previously, it was set to 12/31/1899.

·    The 'Open spreadsheet' option for ExcelDirect Print in User Preferences was being ignored.

·    Similar to other posting journals, after printing the Unpost Journal you are no longer asked if you want to clear it.

·    If a batch for zero dollars was retrieved and posted in an automation job, a message was displayed that halted the job. This no longer happens.

·    On the Detail Listing printed in ‘Source and home’ format for MultiCurrency databases, the Account Description overwrote the Transaction Description in some cases.

·    On Adagio Cloud, in some cases, an ExcelDirect print of a report when an unrelated workbook was open on the local machine overwrote the content of the open spreadsheet, which was lost if you saved the workbook.

·    On Adagio Cloud, retrieval of a third-party product batch (ex. PayDirt Payroll) from the local machine, after another retrieve had just been done, duplicated or mixed transactions from the first batch retrieved.

·    Consolidate Posted Transactions consolidated transactions outside of the range selected in some cases.

Enhancements & Revisions in the Financial Reporter

·    AdagioLauncher will automatically launch the Financial Reporter when an Adagio financial statement file is double-clicked in a Folder. The user will be prompted to log in.

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

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

·    Handles file name on the command line that is enclosed in double quotes.

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

·    In Ledger 9.2B, in the Financial Reporter, when a Department List that included ranges or masks was selected, amounts were incorrect.

·    In Ledger 9.2B (2018.02.18), in the Financial Reporter, when switching from Consolidated to departmental display, the amounts for the original department were incorrect for rows with account ranges.

·    The ‘Expression Notepad’ has been enhanced to allow its use when editing an account range in Column B. Double-click in the formula bar in the toolbar, or Right click on the cell containing the formula or account range and select the option from the pop-up menu.

·    Resolves a problem in the Financial Reporter where transaction details were not displayed and some rows were suppressed when a statement was expanded.

·    Resolves a problem in the Financial Reporter where a statement using .AutoUpdate was saved as expanded and contained thousands of rows was not properly refreshed (i.e. opened and immediately closed again).

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

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

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

·    When making a department and all associated accounts inactive, any retained earnings accounts in that department are not made inactive. This allows you to make a department inactive to prevent accidental use without having to make retained earnings active in order to run Next Year. Retained earnings accounts with departments must still be active when creating the Next Year, and can be edited manually as needed.

·    Empty batches no longer post. If an empty batch is included in a range of batches it is left unposted.

·    In Ledger 9.2A and higher, if you were in the View Transactions/Budgets function when batches were posted, the transaction details were not refreshed until you closed and re-entered the function.

·    If the Current Balance, Budget or Forecast columns were removed from the View Transactions screen and later re-added without using Reset, when you changed the fiscal period, the column amounts did not refresh the numbers for the selected fiscal period.

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

·    PurchaseOrders transactions with a vendor document number less than 9 characters did not display the PDF in the View Transactions function.

·    In Ledger 9.2B, the Posting Journal did not print entries in the order entered or show on the Batch Listing in some cases.

·    After installing Ledger 9.2B (2016.08.10) or SysUpdater (160809), temporary files created on workstations by printing reports were not deleted in some cases, although this did not cause any problems.

·    When printing a Report Set containing a posting journal for an empty batch, an error occurred. This could cause an automation job to fail to complete. The error no longer occurs.

·    In Ledger 9.2A and higher, the Chart of Accounts report did not and there was an error when the report was previewed.

·    In some cases, the sequence for the Provisional Posting Journal was not set properly if Next Year was open.

·    Ledger on Adagio Cloud now supports retrieval of batches from third-party applications (for example PayDirt Payroll™) running on the local machine.

·    When cloning a company if you changed the fiscal year, posting a batch to a prior year caused data integrity errors.

·    Ledger now renders dialogs properly on Ultra High Resolution displays when the font size is anything other than 100% of normal on Windows 8.1 or higher.

·    The Data Integrity Check now shows the Account in the error for any orphaned transactions.

·    If a user who had Ledger open ran a Data Integrity Check (DIC) after another user had posted a batch and then exited the program, the DIC reported false errors. If Ledger was closed and reopened, the errors are no longer reported.

·    Installing the 9.2B (2016.08.10) Service Pack displayed the error “x:\Softrak\Ledger\LedgerFinRep.exe is not a valid previous version and could not be upgraded.” in some cases.

·    Station logs had blanks in remote entries if the Adagio application was logged in with a UNC rather than a mapped drive. The Remote Device and Remote Platform entries are now populated in this case.

·    Station logs always showed Remote Platform as the generic OS type, usually \\\"Win NT\\\". It now shows the actual server OS, such as “Windows Server 2012 R2”.

·    Station logs have new entry Remote OpLocks Setting that shows the Oplocks setting on the server as “Enabled” or “Disabled”. If unable to connect to remote registry it will show \\\"”.

Enhancements & Revisions in Financial Reporter

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

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

  $A - Application (LedgerFinRep.exe)
  $C - Company Name
  $D - Date - can have parameters in {}
  $F - File title
  $G - UTC Date - can have parameters in {}
                    %z is always utc,%Z is always UTC
  $N - Number of pages
  $P - Current page number
  $R - Sheet Name
  $U - User Id
  $V - Filter value
  $X - Path Name
  $Y - Date string - \\\"As of ...\\\"

·    Expression Notepad added to improve the entry of complex formulas. Right Button Mouse on a formula cell or double click in the Formula Bar launches the Notepad. Text is entered in a monospace font and multilines are supported.

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

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

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

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

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

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

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

·    Department masks with leading blanks now work correctly.

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

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

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

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

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

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

·    DataCare now maintains the size of the application log (SDAPPLOG) when checking Ledger data, similar to the Data Integrity Check in Ledger and other modules.

·    The All Workstation Installer incorrectly created shortcuts in some cases if pre-9.2A versions of Adagio existed, such as creating a Time&Billing shortcut even though that module is not installed.

·    Installs a new Adagio Data Source (ADS) that prevents resource locking problems at large Adagio sites running 9.2 versions and improves application performance at these sites.

NOTE: All third-party applications from Adagio Developer Partners must use the new ADS. You must check with your Adagio consultant or the developer to confirm their application is using ADS 1.12. 66.3503 or higher. Failure to ascertain this risks corrupting data if the application is writing to the Adagio data files concurrently with Adagio modules.

Enhancements & Revisions in the Financial Reporter

·    In the Ledger 9.2B Financial Reporter, the ‘Don’t show this message again’ option on the Watch Me video prompt screen did not work when the Financial Reporter was launched from Ledger. It was not a problem when the Financial Reporter program was launched directly from Windows Explorer or a shortcut.

·    In Ledger 9.1A and higher, the ‘Organize by Field’ function opened from the right-click pop-up menu on the View Chart of Accounts window displayed a blank screen rather than a list of Account Master fields.

·    In Ledger 9.2B, changes to the Display settings on the Settings tab in View | Customize were not saved.

·    Statement Group printing or exporting to Excel Direct had pages by department sorted in an unexpected way, with the All Departments selection. Now pages are sorted as defined on the Statement Group item department list.

·    In Ledger 9.2B on Adagio Cloud, if you double-clicked on a file in the Open Financial Statement Template function you received the error “Windows can't open this type of file (.fst).”; although, if you selected the file and clicked the Open button, the template was opened.

·    In Ledger 9.2B, leading spaces in Departments were not correctly handled when expanding a statement.

·    Printing and Excel Direct Statement Groups now maintain the defined order.

·    In Ledger 9.2A and 9.2B, the Account Description on the Details grid drill-down displayed an “A” rather than the description.

·    Corrections and improvements made to spec codes: U, PRO, and ENC return full year and period ranges implemented for all V codes. GLTITLE() returns the correct text description.
V(|B|F|U|PRO|ENC)[(P)Sp:Ep]
Note that there is nothing allowed after the final ']' and that V* functions are independent of fiscal period.

·    The name of a financial statement file opened in the Financial Reporter individually or within a statement group is written to the Application Log.

·    Added an option to print a General Ledger Distribution Summary on the Posting Journals.

·    Added a subtotal of Units by period on the GL Detail Listing.

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

·    For multicurrency datasets, Import Batches and Import Transactions does not require that Rate type or Rate date be in the import template. These fields will default based on settings in the Company Profile and MultiCurrency data.

·    Additional Application Log entries are made by Ledger. The log can be viewed with GridView or Adagio Console.

·    The Data Integrity Check has an enhancement to check the next posting sequence and transaction uniquifier in the Company Profile against the posted transaction and posting journal files and attempt rebuild if required.

·    GridView view templates for Adagio Ledger have been updated. They are installed in the \Softrak\Ledger\ViewTemplates folder.

Problems fixed

·    In the Edit Departments function in Ledger 9.2A, if you created accounts using the New Department process, selected the Clone Account option but not the ‘Clear budget/forecast figures’ options, selected income accounts that had budgets to clone, integrity errors resulted.

·    If ‘Active records only’ was enabled in the Column Editor, the Clear function in Edit Budgets and Edit Forecasts was not clearing amounts if hidden inactive accounts were included in the range of accounts selected.

·    In Ledger 9.1A and 9.2A, copying multiple batches to a single new batch created multiple new batches instead.

·    Resource locking changes have been made in Ledger and the Financial Reporter. You are no longer restricted from posting batches when the Financial Reporter is open on the same station for a different database. Posting continues to be restricted when the Financial Reporter is open on the same station for the same database. Posting is permitted when the Financial Reporter is open on other stations for the same database.

·    Retained Earnings account option, ‘Restrict To Subledgers’, was incorrectly preventing posting batches to Current Year.

·    Closing the posting confirmation message with the X in the window title bar posted the batch(es) instead of closing the message.

·    In MultiCurrency data in some cases, edits to text fields in revaluation batches caused the Home amount to be recalculated to 0.

·    In the View Transactions/Budgets inquiry, when viewing the Budget/Forecast, Fiscal Year dropdown showed every year twice.

·    The Posting Journal when printed in detail form and sorted by account now displays the full Description field.

·    Printing a Report set to PDF failed when there was a Posting Errors Posting Journal.

·    When the Posting Journal report was saved as a Favorite, the Print Error Posting Journal option was always enabled.

·    For the %CMP code (Company Name) used by Adagio ePrint for folder names, spaces and other allowable punctuation characters are no longer stripped out.

·    In Ledger 9.2A’s Posting Journal report, a date field of 12/31/1899 printed on the G/L Summary.

·    The Posting journal in detail form, sorted by Account, with ‘Print Units’, printed a blank line when the second entry description was not blank.

·    For multicurrency datasets some totals were not aligned correctly on the Detail Listing report.

·    Source currency amounts were incorrectly suppressed in Source and Home Batch Listings, in the G/L Summary.

·    The Source Journal Profile Report in Ledger 9.2A printed several Unused sorts in the ‘Sorted by’ column.

·    In the Export Transactions function, if you exported a range that did not include any transactions, the message “Error code: 1001 on ToXLAutoFitRange” was displayed instead of a message saying there were no records to export in the range.

·    Export of files to Excel format from File | Export functions displayed an error if you had opened the database using a UNC path (for example:
\MYSERVER\Adagio\SOFTRAK\DATA).

·    Export of files to Excel format from File | Export functions did not create the export .xlsx file in some cases if Excel 2013 or higher was open on the stations.

·    Automation no longer stops if set to Retrieve by Application when there is no batch to retrieve.

·    If the size of text was set higher than 100% on Windows 10, Ledger froze when opened in some cases.

·    Corrected problems converting from version 8.1A databases.

·    The Data Integrity Check did not include the Adagio Common Files (SD*) when a backup was made prior to rebuilding errors.

·    Corrected a problem where, after a workstation install was completed, it cycled requiring another workstation install (sometimes cycling without user intervention). This happened in isolated cases on some workstations for systems where Adagio 9.2A/B modules dated in December 2015 or later were installed for the first time at a site, depending on the workstation environment and/or the order in which upgrades and Service Packs were installed.

Enhancements in Financial Reporter

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

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

·    The Financial Report now writes to the Application Log when opened and closed. The log can be viewed with GridView or Adagio Console.

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 the General Ledger.

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

·    Print Financial Statements for Sub Groups of a Statement Group printed the incorrect Sub Group in some cases.

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

·    When the Chart of Accounts report in Ledger 9.2A was printed in Profile style, if you printed Optional Fields, dates that are blank in the data printed as 12/31/1899.

·    In Ledger 9.2A, the Batch Listings and GL Summary on Posting Journals sorted accounts without departments ahead of other lower account numbers if the account number did not use the full 6 characters.

·    On the Detail Listing in Ledger 9.2A, ‘Page break on change of department’ option did not work for a range of a single account.

·    In Ledger 9.2A, if while exporting you browsed to any folder other than the data folder where the output file did not already exist and said Yes to create the file, there was an Access Violation error if you did not also include the file extension in the filename.

·    The Data Integrity Check in Ledger 9.2A (2015.05.16) no longer reports a warning when a batch is out of balance. DataCare also no longer reports this as an error.

·    In Ledger 9.2A (2015.05.16) the auto-workstation install on a new workstation that had not had vitalEsafe installed by a previous install, ran again each time you started Ledger. Note: the vitalEsafe web based file storage service has been discontinued and this function has been removed from Ledger. See the Upgrading section in the Release Notes for further information.

·    When starting Adagio 9.2A versions, the Crystal Reports Runtime (used to print reports) intermittently displayed an error such as “The program can't start because TraceLog-4-0.dll is missing from your computer.” when in fact the DLL file was present and reports did print without problem. Installing Ledger 9.2A should correct this for all 9.2A modules.

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

·    If your fiscal year is not the calendar year and you had next year open, the Period finder on the Detail Listing report dialog displayed the correct period but for the earliest fiscal year on file if you did not physically select the Fiscal Year.

·    When printing a Detail Listing across multiple fiscal years, in some cases extra transactions for Income Statement Accounts would print with the description ‘Details Missing’.

·    When printing a Detail Listing across multiple fiscal years, for the last account printed, details were missing and in some cases extra transactions were printed instead.

·    The Detail Listing report title now shows “Listing calculated from” followed by the starting and ending year and period in the format “YYYY-PD”. The dates are also shown in the format MMM DD YYYY on the second line of the report title.

·    The Detail Listing printed in Condensed format did not break out the closing entries by year.

·    While the Print Preview window was open it used 100% of the available cycles for one CPU when that CPU was not being used for other tasks by the OS. While this did not actually reduce performance on the machine, it depleted battery charge on laptops if the preview was left open.

·    New export templates created for Excel format default the file extension to .XLXS rather than .XLS as in prior versions.

·    Account Description fields were added to the Export Net Changes and Export Statistics functions for Ledger 9.2A.

·    When the All Workstation install included with Ledger 9.2A was used to install other pre-9.2A modules, it did not install some files required to print reports in those modules. This caused problems printing reports on stations that had never run any Adagio versions prior to installing Ledger 9.2A.

·    The System Status function (chksys) and its Snapshot function have been improved.

·    When Adagio 9.2A programs are started, additional checking of the reporting environment is performed, including the ODBC drivers and related settings.

·    The Ledger install does additional checking of the install packages downloaded the first time an Adagio 9.2A module is installed at a site. It attempts to re-download the packages in certain cases and the messages displayed in the case of problems have been improved.

Financial Reporter

·    The hidden rows (Hide When Printed) at the bottom of a financial statement were not being hidden when exported to Excel in prior versions.

·    In Ledger 9.1A and 9.2A (2014.11.20), for financial statements with multiple sheets, QuerySheet had screen refresh problems or caused a crash.

·    Fixed a problem in the Financial Reporter where the Departmental print would lose the font in some cases.

Enhancements and revisions in Adagio Ledger 9.1A (2014.02.21)

   The Retained Earnings account could not be set and the Company Profile change saved, in some cases, if Auto-fill option is or had been on.

   After canceling an edit in batch entry, the Cancel button incorrectly maintained the default, leading to potential loss of the next entry made.

   If the 'Default Ready to Post' option is on in the Company Profile, when the spacebar was pressed on the batch grid the prompt to mark the selected batch(es) Ready to Post displayed when it should not have. If you then marked the batch(es) not ready, and you also ticked the option 'Don't show this message again' on the prompt, the batch(es) could not be posted.

   If a Retained Earnings account was single currency in a multicurrency database, you could not post an Income account entry in source currency for an Entered batch. An error was displayed and an error batch was created.

   The option 'By department' was missing in the Edit Account Budget function in Ledger 9.1A if Filters were enabled on the grid but the filter itself was blank.

   The 'Acct Description' field could be added to the View Account Transactions window but was always blank in Ledger 9.1A.

   Added Account Group as the last field in the Accounts Default Import and Export Templates. This encourages the use of Account Groups and solved a problem where if you imported accounts in sample data, the import failed because Account Group is missing.

   Import Accounts now displays an error during import if the Account Type doesn't match the type associated with the Account Group when the 'Enforce Account Groups' option is enabled in the Company Profile.

   When importing Source Currencies to update only the Revaluation information, the Net Change values are now correctly ignored and not changed to zero for Current Year and Next Year.

   The 'Allow post journal purge' option in the Company Profile was removed in Ledger 9.1A to avoid accidental clearing. However, when a new database was created, this option was enabled and could not be turned off. This caused Ledger to prompt you to Print and Clear posting journals and the batch status after the current year was closed in some cases.

   The Next Year Posting Journal was not empty when Next Year was created if there had been an improper restore procedure (all GL data files were not deleted before restoring). The Create Next Fiscal Year function now checks for and corrects this condition.

   The Change Fiscal Year function was not purging the Provisional Posting Journal. If this occurred the Provisional Posting could not be printed for sequence 1 (only) after provisionally posting.

   The Trial Balance for Report Style of Provisional Worksheet, with ‘Exclude Zero Balance Accounts’, was incorrectly suppressing accounts when the Provisional Balance for the account was zero. This report has been changed to suppress an account when the balance is zero before and after provisional posting. The Trial Balance for Report Styles of Worksheet or Report, with ‘Exclude Zero Balance Accounts’, and ‘Provisional Postings’ set to ‘Separately From Balance’ was incorrectly suppressing accounts if the balance prior to the provisional posting was zero, and it was not suppressing accounts that were zero after the provisional posting. The ‘Exclude Zero Balance Accounts’ option may have caused Report Totals and Net Income for Accounts Listed to be incorrect.

   The Detail Listing report did not print the opening balance for Retained Earnings accounts when printed in 'Source and home' format.

   In Ledger 9.1A when a new database was created, it contained integrity errors.

   The number of Previously Opened databases was increased from 25 to 100 per user in Ledger 9.1A but this was not working.

   Some minor fixes have been made to Automation in Ledger.

   Installs an updated Ledger DataCare DLL compatible with Adagio xConsole.

Enhancements and revisions in Adagio Ledger 9.1A (2013.07.26)

   Added GL!BudgetUpdateNY.SAM for use when updating Next Year amounts, rather than current year.

   In Ledger 9.1A (2013.05.23), the Ledger program lost the focus when the View Account Transactions inquiry screen was closed.

   Corrected problems with the Find and Transactions functions when the grid in the View Transactions/Budgets function was sorted by Department in Ledger 9.1A (2013.05.23).

   If you viewed several batches from the Batch Inquiry function in Ledger 9.1A (2013.05.23) the error "Critical Error: [3000] too many open windows" was displayed, even though you had closed all the view batch screens.

Financial Reporter

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

   Import Workbook was not working in Ledger 9.1A (2013.05.23).

   In Ledger 9.1A (2013.05.23), Undo and Redo after editing a formula placed an apostrophe before the formula, changing it to text.

   The FIND function now returns zero rather error if nothing is found.

   In Ledger 9.1A (2013.05.23), copy from the formula field on the toolbar was copying the value rather than the text of the formula.

   In Ledger 9.1A (2013.05.23), Print Report Set with financial statement group crashed the Financial Reporter in some cases if a statement used the 'Fit columns to Page' option.

Enhancements and revisions in Adagio Ledger 9.1A (2013.05.23)

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 changes and improvements are listed below, separately from General Ledger.

Inquiries

   The View Batch Status function now includes the ability to View batches (both open and posted, with multi-select). It also allows you to print Batch Listings (both open and posted, with multi-select), print Posting Journals (open and printed, with multi-select), and Recover posted batches (with multi-select).

   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 Detail #. 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.

   Ledger now maintains an index into the posted transactions file that allows the full Entry Details for a transaction to be shown immediately in the View Transactions function. In previous versions, each user had to click the 'View GL Entry' button each time they used View Transactions to view entry details, then wait while the program generated an index. There is a new option 'Auto build TX inquiry index' on the Posting/Report tab in the Company Profile. If this option is on, the index is generated after posting batches, allowing immediate viewing of entries the next time you use the function. This option is defaulted on when converting from prior versions. Having the option on may significantly increase the time taken to post batches. For very large databases on a network drive, or if you often post several batches individually, you may want to set the option to off. When the option is off, the index is deleted by posting and generated when you open the View Transactions function if batches have been posted since the last time the function was used. Set the option to on if generation of the index is fast enough or you are prepared to wait for a longer post time in lieu of waiting when you wish to view entry details, otherwise set it off. The index is available to all users, whereas in previous versions, each user had to wait for an index to be built for them after clicking 'View GL Entry'.

   The View Entry Details grid has been moved from a separate window opened by the 'View GL Entry' button, to the Account screen, allowing this information to be viewed immediately whenever a transaction is viewed.

   When viewing transactions, the application name is shown beside the 2 character Application (source) code. For example, "Adagio OrderEntry" is shown for "OE".

Edit Accounts

   You can now restrict posting to an account by subledger(s). Click the new option 'Restrict to subledger' in the Edit Account function. A new tab will display. On this tab, select the sub-ledgers that are allowed to be posted to the account. The list includes Ledger itself. Batch entry warns you if you create an entry that is not permitted and the entry cannot be saved. Posting to the account is prevented if the restriction is make after the fact and an error batch will be created. Note: Entry and posting is not prevented in the sub-ledgers, only in Ledger itself.

   The format and entry of Account (and Department) codes can be controlled by several new options on the Options tab in the Company Profile. ‘Uppercase account codes?’ forces all codes to upper case. ‘Auto-fill account codes?' allows you to set all account codes to the same length by automatically filling the entry field to the specified length. The fill character can be specified. An account code format can be used to make sure that new account codes conform to a company standard. The valid characters may include:

      A   –   Uppercase alphabetic only “A-Z”
      a   –   Upper or lowercase alphabetic only “A-Z, a-z”
      B   –   Uppercase alphabetic only “A-Z” and blank
      b   –   Upper or lowercase alphabetic only “A-Z, a-z” and blank
      9   –   Numeric only “0-9”
      N   –   Uppercase alphanumeric only “0-9, A-Z”
      n   –   Upper or lower case alphanumeric only “0-9, A-Z, a-z”
      S   –   Uppercase alphanumeric only “0-9, A-Z” and blank
      s   –   Upper or lower case alphanumeric only “0-9, A-Z, a-z” and blank
      .    –   (period) Any case alphanumeric and “! - / ”
      ~  –   (tilde) Any printable
      _   –   (blank) for leading spaces

   If you add an account that is likely set to the wrong type accidentally, for example adding a Balance Sheet account in the range of Income accounts, the warning "The account type of the previous and next acct/dept is different. Do you want to proceed?" is displayed. Note: If the Enforce Account Group Range option is on then it prevents you from doing this in the first place.

   Added Excel Direct to the grid in the Edit Departments function.

Batch Entry and Posting

   When copying a batch you can now revise the batch name, saving you from having to rename it after copying.

   You can now post to any year in the fiscal calendar that is open, rather than only to the 2 most recent years (either Current Year and Prior Year, or Next Year and Current Year). For example, this allows you to post an auditor's adjustments to the Prior Year after you have created the Next Fiscal Year. The 'To Prior Year' posting function is always available (provided it is enabled in the Company Profile). The fiscal year is now a drop-down field on the Posting dialog, showing all available years. Warnings are displayed if you post to a year more than 1 year prior to the current year.

   The Spacebar now toggles the Ready to Post status on the batch grid.

   Added the option 'Don't show this message again' on the confirming message when batches are set Read to Post, or Not Read to Post.

Maintenance / Retrieve

   Added the option 'Discard $0.00 trx' to the Retrieve Subledger Batches function. Set this option to discard zero amount transactions.

   The original 'Recover' batches functionality was to be able to restore a deleted or posted Current Year batch, with no options for affecting the new batch. The Recover batch process now available within Batch Status inquiry allows for many different options for updating the batch, including reversing the entries.

   The Purge Fiscal Year function now optionally removes accounts and departments that are no longer required after the fiscal year has been purged. In order for accounts to be deleted, the Opening Balance, Current Balance and Total Net Changes must be zero, and there must be no posted transactions for the account. Deleted accounts are logged in the Application Log, which lists deleted master records from all Adagio modules, and can be viewed with GridView.

Reports

   A 'Report set' button has been added to the toolbar.

   Posting Journals can no longer be cleared after printing. This avoid accidental clearing (and there are no performance or space issues related to saving them). Posting Journals are cleared at year end. The 'Allow purge posting journal' option has been removed from the Company Profile.

   Batch status information can no longer be cleared after printing the Batch Status report. Doing so prevents un-posting, reversing and recovering batches. Batch Status is cleared at year end.

   Added the option 'Summarize by account' to the Trial Balance report. This prints one line for each account rather than one line for each Account / Department.

   You can now create a Favorite report for posting journals even when there is nothing to print.

   Added the %FPD option (Fiscal Period) for the Trial Balance and Detail Listing Report Favorite filenames for Adagio ePrint users.

   The legend line "e: Retrieved batch was edited." is now printed at the bottom of the Batch Listing report if you have edited entries in a retrieved batch and an 'e' appears beside the total for any entries. This avoids any confusion that such entries are in error.

   When the GL Detail Listing is printed with the 'Page break on change of account' option enabled, the grand totals are printed on a separate page.

Data Integrity Checker

   The Data Integrity Check now reports an error if an account has the multi-currency option on but the database is not multi-currency. This error caused problems when the Close Income/ Expense Account function was run.

   The Data Integrity Check now detects a damaged fiscal calendar.

General New Features

   The Ledger program icon is more consistent with the look of other Adagio icons and the size of the "gl" letters has increased, making the icon easier to recognize at a glance.

   New splash screen with an updated look.

   In earlier releases of Adagio we added the ability for Excel Direct to create a CSV file for use by other spreadsheet applications, such as Apache OpenOffice^TM Calc, for sites that did not have Excel installed. The spreadsheet program was launched and opened the CSV file created. Excel Direct can now use Windows "automation" (inter-process communication) to send data to other spreadsheet applications, the same way it interfaces to Excel, allowing all formatting to be retained in the resulting sheet. OpenOffice 3.3 or later and LibreOffice® 3.3 or later are supported. This interface must be manually enabled. The file SSI2XL.INI must exist in \softrak\system and must contain the section [Initialization] with an entry <computer name>-UseOpenOffice=1, where <computer name> is the name of the machine that this entry references. Refer to the Readme Help for further details.

   The Help | About function now has a Consultant tab showing the contact information for your Adagio consultant if they have enabled this option at your site. In addition, the 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.

   When Ledger 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.

   The Adagio menu now includes Ledger, allowing you to quickly open another instance of the program.

   The F1 key now launches Help when no windows are open.

   When sites with Adagio ePrint sign on to a new dataset for the first time, the question "Do you want to turn on Allow PDF printing for this dataset, and enable PDF Printing for all users? is now asked.

   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) has been increased from 25 to 100.

   The warning message "New date is more than one week later than old date. Accept new date?" on login now has the option 'Don't show this message again'.

   The session date is now passed to GridView views (workspaces) loaded from the Inquiries menu.

Problems Fixed

   Editing a batch that has a mismatching amounts error, where the sum of the details do not equal the total on the batch header or the batch control, now displays a warning dialog that allows you to correct the mismatching amounts. The Batch Listing report also detects these problems.

   When copying a batch that originated in Purchase Orders, the 'Recalculate period based on date' option did not work if batch contained comment lines.

   When a batch was Unposted and the option 'Delete entries from posted?' was selected, the units were not increased/decreased by the unposting.

   If a Retained Earnings account is set to post in 'Specified Currencies' and Next Year is open, posting a batch in the current year in a new currency will not be permitted until retained earnings is updated.

   In the Edit Budgets and Edit Forecasts functions, when a filter was applied to restrict the accounts on the grid and the 'Account/department sequence' option was used, if you clicked the 'By Department' option the underlying account grid repositioned to the end, thereby breaking the sequence for editing.

   Corrected a problem displaying the grid showing the periods in the Edit Account Budgets function, that occurred in some cases where a period became missing when the Next button was clicked.

   The Alt-X key (vs. clicking the Excel Direct button) exported the grid contents to Excel even if user security prevented it.

   On the Batch Listing report in Ledger 9.0D, when the 'Show Description' option was set to 'Primary', the Description 1 field partially wrapped onto the next line if was too long to fit in the available space on the report.

   Printing a Report Set containing a statement group caused the program to hang if you had the Financial Reporter open.

   If a fiscal year end is changed and a new fiscal year created, (e.g. 2012A), the title on the Trial Balance report did not print the "A".

   When the Trial Balance was printed with the option 'Exclude zero balance accounts' (added for Ledger 9.0D), if an account had a zero balance prior to provisionally posting it was suppressed when it should not have been.  Note: if a provisional posting to an account that had a balance makes the new balance for that account zero, then the account will be suppressed.

   The Batch Listing Report was remembering the range of Starting and Ending dates. They are no longer remembered, and instead are defaulted to Jan 1, 1980 and Dec 31 of the year 10 years from today.

   In Ledger 9.0D, the Report Balance on the Detail Listing report was not zero in some cases.

   When the Posting Journal was printed in 'Source and home' format, sorted by Account, any comment lines were printed at the top of the report instead of being suppressed.

   The report filename codes (ex. %FYR) were not being saved in report favorites.

   Import templates for Budgets, Forecasts, Net Changes, Statistics, and Source Currencies, no longer have the 'Add new records' option available because you cannot add new amounts to non-existent accounts.

   The Import batch function now detects multi-decimal amounts in Excel import files (incorrect amounts that should only have been 2 decimal) that previously caused rounding and data integrity errors.

   The First Date field in the G/L Batch Control File was always blank when shown on the grid in the Batch Status function or in GridView.

   When the Data Integrity Check reported an out of balance error in a batch, the error message had the debit and credit amounts backwards in some cases.

   Installs an updated version of the Adagio Data Source (ADS) that corrects the OpLocks Setting shown in station log files <computer name>.log in \Softrak\System\StationLogs. It was reported as Enabled instead of Disabled in some cases.

Financial Reporter

New Features

   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(), NEXTCREATED(), 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 'Past 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 GL!BudgetUpdate.sam statement allows entering an annual budget and amounts will be divided equally across all 12 fiscal periods. The GL!BudgetUpdateMonths.sam statement allows entering monthly budgets into columns and amounts will be written to the respective fiscal periods.

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

   A new sample financial statement (GL!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.

General Ledger

New Features

   Favorites for a report are now available on the report dialog in a drop-down field. Private Favorites are yellow, Public Favorites are blue. Users with many favorites may find it easier to locate and print them from the report dialog. Users with only a few favorite reports that they print frequently may find it easier to print them from the Favorite Reports fly-out menu under the main Reports menu. The ability to print Favorites from the report dialog allows users to print the Posting Journal from a Favorite when posting batches with the 'Auto print posting journal after post' option enabled.

   Added ePrint embedded codes for Session Year Month (%SYM) and Actual Year Month (%DYM) for PDF folders and filenames (these codes expand to YYYYMM).

   Added ePrint embedded code Form Type (%FRM) for PDF folder names (expands to "Financial Statements" for Statement Groups and financial statements).

   The default Favorite name and default PDF filename for the Favorite, have been changed for certain reports so that at year end Favorites names to not need to be changed. The fiscal year (%FYR) is embedded in the PDF filename but not in the Favorite name. For example, the PDF filename for Posting Journals defaults to GL%FYRPostingJournal%PJN (would expand to "GL2011PostingJournal 100.pdf" for sequence 100). The Favorite name defaults to GLyyPostingJournal (where: yy is PY-Previous Year, CY-Current Year, or NY- Next Year). The reports affected are: Batch Listings, Posting Journals, Batch Status, Detail Listing and Trial Balance.

   Report Favorites now remember the printer selected if it is not the Default printer. If you print a Favorite and the stored printer for it doesn’t exist, you get an error message and the printer is reset to the appropriate Default printer (for single or multicurrency).

   Ledger 9.0D eliminated unnecessary (redundant) workstation installs for the AdagioPDF printer driver and vitalEsafe if these features had already been installed by the workstation install for another Adagio module. This is now also the case when installing Adagio for use with Remote Desktop Services (Terminal Services in Windows Server 2008 and previous versions).

Problems Fixed

   The Folder paths in the company profile for the ePrint are no longer forced to uppercase.

   The default PDF report filenames for Posting Journals and Batch Listings now include the %PJN and %BAT replacement strings (respectively) when ePrint is installed so that the files are easier to identify and do not overwrite previous files.

   Several minor problems related to ePrint functionality in Ledger have been corrected in this release. If you are using ePrint you should have this Ledger Service Pack installed.

   When printing Posting Journals and the Batch Status Report to a file, if the destination path did not exist the report was not written to file and you were not prompted to clear the information. If this happens you are now shown the path and the folder is created on the fly.

   In Ledger 9.0D, the Trial Balance printed the Department Description instead of the word "Total" if the 'Page break on change of account' option was selected.

   The prior year opening balance on the Detail Listing was reported as “Opening balance” when the 'Include Prior Year Postings' option was checked and there were no current year postings. It should have reported the current year opening balance.

   If your fiscal year is not December 31, when you signed-into Ledger with a date that is not equal to the fiscal year identifier (for example, if your yearend is July 31, and you logged in with date between August 1 and December 31), the Current Period/Year used for reports did not pick the actual period, but instead used period 12 from the prior year.

   When a posting journal was auto-printed after post, you could not post another batch until you first opened and closed the Ledger database. Instead you received the error message "Unable to access selected function, currently being accessed by [nnn] in [G/L Posting]".

   After using the Import Transactions function you were not able to do a backup until you closed and reopened that database.

   Purging Batch Status report in Ledger 9.0D was slow in some cases across a network for larger databases. This was related to allowing the recovery of batches. The speed has been improved and a progress bar has been added.

   If you un-posted a batch in Next Year, the Current Year Unpost Journal was the journal auto-printed.

   In Ledger 9.0D the error count at the bottom of the batch listing was incorrect when the batch contained an error due to a missing account.

   When you attempted to add a Report Favorite for a report showing 'Home and Source' to a Report Set you got the error message "Favorite report <name of favorite> requires a multicurrency printer".

   If an auto-reversing batch generates an error batch because the next period is closed, the auto-reversing option is now on in the error batch.

   The Print/Delete Favorites menu choice was missing from the Reports menu after you deleted a Report Set.

   Ledger no longer displays a warning about closed periods when entering Archive batches as you are often preparing a batch for a period that has not yet been opened. Dates are checked when batch is posted after being copied or moved to a Current batch.

   The Export Reallocations function added in Ledger 9.0D did not work if you specified a range of a single Department.

   The Import Reallocations function added in Ledger 9.0D only imported a small number of records and there were errors for a larger file.

   Ledger 9.0D was updated from version 7 to version 8.5 of the Crystal Reports print engine. When installing Adagio for use with Remote Desktop Services (Terminal Services in Windows Server 2008 and previous versions) this necessitated manually copying the crystal folder from the main windows folder to the windows under each user. For example, on Server 2003 you had to copy the crystal folder from C:\windows\ to C:\Documents and Settings\username\windows. This is no longer required. The install and workstation installs will do the copy. The Ledger program will also do the copy if possible, which will avoid the need to do a workstation install in some cases.

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

   When running any Adagio module that installs vitalEsafe (or WebSafe as it was previously known as) on a Windows 7 (or Vista) station, in some cases the auto-workstation install ran every time you started the application, even if you had done a workstation install. This happened if the user was not an Administrator on their own machine (the default for a new computer) but rather a Standard user, and User Account Control (UAC) was on, and you had not installed any module with a release date of October 2011 or later and done a workstation install for it on the station. This has been resolved. To resolve this problem for ALL other modules, install any module with a release date of October 2011 or later and do a workstation install for it on the station.

Financial Reporter

New Features

   Added .RangeAccount function, for which the SmartSheet will expand the specified account range once for each account in the range, without altering the department range specified. This is useful in cases where you wish to create a row for every account in a range, summarized to the department mask used.

   The Adagio Styles (File | Styles in Adagio modules) are available in the Financial Reporter (Format Cells, Based On tab). The Financial Reporter's own Styles, available in earlier versions, are included in the list.

Problems Fixed

   A problem occurred in some cases where the QuerySheet function caused cells to display !Error and values returned were incorrect when Next Year was created before closing the Current Year.

   The Financial Reporter now detects corruption in the Account Data tree (file GLATREE) and recreates the file. In prior releases this type of corruption caused the error "Adagio Financial Reporter has stopped working".

   In Ledger 9.0D, the Financial Reporter was not correctly setting the Paper Size or Orientation of individual statements when printing Statement Groups to printer if the statements had different Paper Sizes and/or Orientations.

   Fixed a problem in printing statement groups where multiple copies of the same statement are produced when “All departments” is selected as an option.

General Ledger

Financial Reporter

General Ledger

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 changes and improvements are listed separately from General Ledger.

General Ledger

• Fully compatible with Windows 7.
  
  
• Added new function 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 from the Company Profile (company background color and On Start-up functions). 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 an Excel Direct button to more grids, including Edit Accounts, Edit Account History, Edit Budgets, Edit Forecasts and View Accounts. Use the 'Enable SF Export' option in Edit User to enable or disable the Excel Direct button.
  
  
• Excel Direct now has a progress bar and cancel for use on grids with a very large number of rows.
  
  
• Excel Direct (from finders, smart finders and from grids in some modules) 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 \softrak\system\ssi2xl.ini. Refer to the Readme help for details.
  
  
• The Help | About dialog now has a 'System Info' tab showing the version and path to various DLLs used by the program.
  
  
• The Source Code GL-JE is automatically created when a new databases is created. Adagio Ledger 9.0C 2 of 8 AL20100405 08-Apr-2010
  
  
• The warning message displayed when opening a database with a date outside the Fiscal Year now indicates the current Fiscal Year.
  

  Edit Accounts

• The Edit and View Account screen is now sizeable, allowing for more lines to be shown on notes, reallocations and currencies grids.
  
  
• Alt Keys have been added for tabs on the Edit and View Account screens.
  

  Edits

• Options have been added to the Company Profile, Options tab, to allow you to lock budgets and/or forecasts in the current and/or next year to prevent them from being edited. Depending on what is locked you may not see the Clear or Copy button on the Edit budgets/forecasts grid. If you are editing then years which are locked cannot be selected in the edit budgets target fiscal year screen. Import will display an error if you attempt to import budget or forecast figures when they are locked.
  
  
• Update budget by Annual Total or Constant Amount changes the amount to zero when the when next account is accessed.
  

  Inquiries

• The View Transaction/Budget inquiry grid can now be set to show active accounts only.
  
  
• In the View GL Entry in the View Transactions function. In the View Transactions function, the performance to view the first GL entry in the session has been significantly improved and may be 10 times or more faster across a network on a large database.
  

  Batch Entry

• A Recover Batch function has been added to the Maintenance menu. This function can be used to recover a batch in the current year that was accidentally deleted or one that was previously posted.
  
  
• Added the option 'Recalculate period based on date' to the copy batch and copy batch entry functions. This is useful at year end when you may have transactions where the dates are correct but the fiscal period has been set to 99 or 12 because the Next Year has not been created yet.
  
  
• Added the option 'Warn if entry days away' to the Company Profile, Batch Options tab. Batch entry warns you if a transaction date varies more than this number days from the date used when starting Adagio Ledger.
  
  
• The background color of the Edit Batches screens can be set for the Current and Next Year to help differentiate them and prevent accidentally entering (and posting) in the wrong year. The background color of the Edit Archive Batches screen can also be set. The colors are set in the Company Profile on the Batch Options tab. In addition, if the Next Year is open, the Fiscal Year is displayed in the window title of the Current and Next Year edit batches screens.
  
  
• In the Batch Unpost function, if you are not deleting the transactions originally posted with the batch (i.e. the 'Delete entries from posted?' option is off), the UnPost button changes to Restore, to indicate you are restoring (i.e. making a copy of) the original batch.
  
  
• The Description 2 field from the first detail is now available in the Column Editor for the Edit Batch Entries grid.
  
  
• A warning is now displayed in batch entry if the date of a transaction is outside the date range of the fiscal period it’s assigned to.
  
  
• A message can now be displayed in batch entry if the transaction date is in a closed period. The option 'Validate closed periods' in the Company Profile, on the Batch Options tab, can be set to 'Warn only', 'Disallow', or left blank. 'Warn only' will display a warning when the transaction is saved and allow you accept or change the date. 'Disallow' will display an error and you will not be able to save the transaction. If the option is left blank no warnings or errors will be displayed. Note: Posting always respects fiscal period that have been closed.
  
  
• A batch can be set to 'Auto Reverse'. Auto Reverse batches automatically post a reversing entry into the next period. They are useful for payroll and other accruals. The date is set to first day of the next period. The option can be set when you create a new batch or on the Rename Batch dialog. Note: You may not create an Auto Reverse batch for the last period in the fiscal year.
  
  
• Added the option 'Skip 2nd entry description' in the Company Profile, Batch Options tab, to help speed up batch entry by not visiting the second description field (added in Ledger 9.0A) while tabbing through fields on the batch detail entry screen. The field can still be visited by clicking on it.
  
  
• When you click OK on entry that is out of balance, the warning displayed now allows you to say OK accept it or Edit to allow you to change it, rather than just closing the entry after the warning.
  
  
• Added new option 'Auto Advance' on the batch entry screen to help speed up entry by auto editing the next existing detail if you say OK to the current one (if say Cancel it stays on the same entry). This new option does the same thing that turning on 'Auto add batch entry details' in File | Options did in previous versions, plus it auto advances to the next detail when an entry is being Adagio Ledger 9.0C 3 of 8 AL20100405 08-Apr-2010 edited. Therefore the original option has been removed and is not included in the new User Preferences function that includes the options previously found in File | Options.
  
  
• Added new option 'Visit amounts first?' on the batch entry screen to help speed up entry when editing existing details and you are just changing the amounts in an archive or restored archive batch.
  
  
• The 'Visit all fields?' and 'Auto-balance entry' settings in batch entry, as well as the new 'Auto Advance' 'Visit amounts first' options, are now remembered (by Adagio user).
  

  Posting

• Users can now post batches while other users are entering batches or printing reports (only while a report is printing or being previewed, but not while the work file is being created).
  
  
• Batches can now be provisionally posted without having to be set 'Ready to Post'. Forcing a batch to be set 'Ready to Post' in order to post it provisionally allowed a batch that you probably didn't want to post for real to be exposed to exactly that possibility.
  
  
• Running Debit and Credit totals of all entries in the batch are now shown on the batch entry screen.
  

  Reports

• Added 'Report Preview Options' in the File | 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).
  
  
• Report printing performance has been improved when data is on a network drive.
  
  
• The 'Ready to Post' status now appears on the Batch Listing report. The status of the new 'Auto Reverse' setting is also shown.
  
  
• The focus is now on the Starting field on the Detail Listing and other report dialog screens, rather than the Print button.
  
  
• The Active status field has been added to the Departments report.
  

  Maintenance

• Added 'Close/Open Period' function in the Maintenance menu. Based on the login date, the function will close the period you are in and open the next period, even if it is period 1 of the next year. Works for both 12 and 13 period companies.
  
  
• The 'Close Income/Expense Acct' function now displays a warning if you attempt to run the function and you haven't yet run the 'Create Next Fiscal Year' function?
  
  
• The Close Current Fiscal Year function now offers to backup data before proceeding.
  
  
• Added the option 'Auto open next period days in advance' to the Company Profile, Options tab. If you regularly close periods in the Fiscal Calendar that you don't want to be posted to, set this option to the number of days before you want the next period to be opened for posting.
  
  
• Added option 'Allow G/L Consolidation' to the Company Profile, Options tab. If turned on (the default), the Consolidate Posted Transactions menu option is visible on the Maintenance menu; otherwise, it is not visible even to those users granted access within Security Groups. This prevents users from accidentally running this function.
  

  Data Integrity Check

• The speed of the Application Integrity Check (phase 2) of the Integrity Check is significantly faster.
  

  Import / Export

• The Clone Company function now allows you to change the fiscal calendar of the new database to different new year end and number of fiscal periods.
  
  
• The Export Budgets and Export Forecasts functions now include the Description field.
  
  
• Import/Export supports Excel® 2007 format (.xlsx) allowing for greater than 65,535 rows in import and export files. Spreadsheets no longer need to be saved in Excel 97-2003 format (.xls) before they can be imported.
  

  Fixes in Ledger 9.0C

• The 'Last access' date was not updated if the program was started from the Adagio menu of another application or from an icon with parameters that bypassed the login screen. Therefore the field was not up to date on the login screen the next time you started the program.
  
  
• If there are errors during any import function, the error message dialog displaying the error (e.g. "Errors have been written to the log file C:softrakdataxxIMPERR.ddd.") now allows you to view or print the log file.
  
  
• Reports could not be printed to certain printers at some sites but this was very rare. One in particular was the HP2015. Financial reports were not a problem.
  
  
• Reports could not be printed to file with the AdobePDF printer driver after installing an Adobe® Reader® update released in January 2010.
  
  
• When the Detail Listing report was printed for an account that does not have any posted transactions for the prior year but does have net changes in the Account History it just showed an opening and closing balance but not the net change in each period.
  
  
• Old formats such as Lotus, Dbase and Clipper that are almost never used any more were removed from import / export templates in Ledger 9.0B (2009.07.13). The old formats may now be manually turned back on for sites that need them.
  
  
• When a new database was created with Ledger 9.0B (2009.04.30) or (2009.07.13), the Detail Listing report and the View Transactions drilldown function did not show the first half of the very first posted transaction, resulting in an out of balance condition. The database was correct and subsequent transactions were okay. Previously created databases did not have problem.
  
  
• You could not copy an account where the original and new account were both in the same Account Group range with 'Enforce Account Groups Range' enabled. Furthermore, you could copy an account and use a new account code that was not in any of the Account Group ranges without getting an error.
  
  
• For companies with a non-calendar year end using 9.0B, when you imported budgets to the Current year the prior year was updated instead. The display showed the current year but the previous year was actually updated unless you reselected the current year. Importing to the Next Year did not have a problem. Note: In Ledger 90A, you could import to any year and it didn’t default to the current year.
  
  
• Corrects problems exporting from grids in the View Transaction/Budget function and from drill-down details in the Financial Reporter, to Excel 2007, after installing Receivables 9.0A (2009.09.28), Time&Billing 8.1B (2009.09.27) or Purchase Orders for Adagio 8.1A (2009.29). There was no problem with Excel 2003.
  
  
• When Units where shown on the Detail Listing report the Balance for the final Account/Department before the Account Net Change subtotal line did not print.
  
  
• The Detail Listing report did not print report totals if 'Page break on change of account' was selected.
  

  RESOLVED

• In Ledger 9.0B you are prevented from editing budget and forecast figures in historical years. You can only edit these figures for the Current Year or the Next Year (if created). This ensures you are editing the budgets and forecasts you expected to be editing, as previously it was very easy to be editing the wrong year. You were also prevented from importing budgets and forecasts to historical years. This restriction in the import function has been removed.
  
  
• The Edit Account History function incorrectly changed the opening and closing balances for a retained earnings account if you clicked OK, even without changing any amounts.
  
  
• In multi-currency databases, if the 'Auto-balance entry' option was on you could not tab into the Credits field in batch entry.
  
  
• Typing the Adagio user password on the Open dialog displayed the characters very slowly when on a network in rare cases.
  
  
• The Spread for a detail changed to zero when you edited an existing detail in a multi-currency batch.
  
  
• In Ledger 9.0B you could not create a Department with a blank Department Code as field verification is always on starting with that version. However, some sites needed a blank Department to allow them to report on just it in the Financial Reporter.
  
  
• In Ledger 9.0B, the Batch Description was truncated to 30 characters instead of 40 if you renamed it.
  
  
• Editing a reallocation for an inactive account now displays a warning that the account is inactive.
  
  
• Pressing the Delete or Insert keys when on the Edit Account Budget Data grid screen displayed an access violation error.
  

  Financial Reporter

• You can now use the Financial Reporter to enter or edit budget and/or forecast figures and write them back to Ledger. 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. Notes: Only the latest fiscal year can be updated; Next Year if it exists, otherwise Current Year. You cannot update the figures if the budgets and/or forecasts for either the current and/or the next fiscal year locked in the Company Profile, Options tab. The Adagio Ledger 9.0C 5 of 8 AL20100405 08-Apr-2010 toolbar needs to be reset to show the 'Update Budget/Forecast' button.
  
  
• Added function to 'Print Financial Statements' to the Reports menu in Ledger 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. Note: You must open the Financial Reporter once using the Maintain Financial Reports function in the Maintenance menu and then reopen Ledger before the Print Financial Statements function is shown on the Reports menu.
  

  Fixes in the 9.0C Financial Reporter

• Duplicate Row now correctly increments cell references.
  
  
• Expand recalculates values based on the department selected in the drop down menu.
  
  
• =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.
  
  
• A recalc is now forced whenever the fiscal period or zero suppress settings are changed, or when a user with departmental restrictions opens a new sheet.
  
  
• Copying an entire sheet to a new worksheet now copies the formatting as well as the contents of the sheet.
  
  
• Expanding a .Range or .RangeDept that is "Hide when printed" now copies that attribute to the expanded rows.
  
  
• Zero Suppress 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 did not correctly format certain fields in the resulting Excel worksheet.
  
  
• 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.