Adagio Ledger
9.0D | 2011-10-17 (Oct '11)
Go to top Release Notes Print This
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.
Adagio Ledger
9.0D | 2011-06-29 (Jun '11)
Go to top Release Notes Print This
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
- Styles and Account Filters are available to display accounts in different colors and Filter accounts that meet specific criteria. Use Colors to instantly identify miscoded accounts.
- Grids, filters, and finders now show the lookup values instead of the raw data values for typed fields. For example Account Type shows as 'Balance', 'Income' or 'Retained' instead of B, I, or R.
- Report Favorites allow saving Reports with specific options chosen. Click the Favorite button (a star icon) on any report dialog to create a Favorite. Added Favorite Reports and Print/Delete Favorites functions to the Reports menu. Multiple favorites can be defined for the same report. Favorites can be private to the Adagio user or public for use by all users.
- Installs the AdagioPDF printer driver. All reports and printouts from Adagio can be printed to the AdagioPDF printer to create a PDF document in the data folder.
- Adagio Ledger and Financial Reporter fully support the features in Adagio ePrint. When ePrint is installed you can print reports to PDF files in configurable folders determined by the Report Type (General, Transaction or Audit). Financial Statements and Statement Groups print to a separate, configurable folder. Fields can be embedded to establish the file and folder names (User, Session Date, System Date, Time, Batch Number, Posting Sequence). Click the ePrint button (red "EP" icon) on any report dialog to print the report to PDF. The Paperless Reports option forces all reports to be printed to PDF. Reports can be printed to PDF and attached to an email (MAPI) with a single button click.
- Report Sets allow the grouping of Report Favorites and Statement Groups into a single print job that will run unattended. Report Sets may be printed to printer or PDF files. Report Sets may be launched from a command file or a scheduled Windows task by running Ledger.exe with the parameter /R followed by the Report Set (ex. /RMonthEnd). A progress dialog lists the reports in the Report Set, the printing status of each, the destination folder, filename and conflict strategy. A log is generated that records the printing status of each report in the set. Use Report Sets to automate the printing of all your month end reports.
- The User Preferences function has been updated. The Appearance tab, 'Alphabetically sorted field list' option and 'Exclude Ranges' option have been added.
- Added validation of account optional fields in the Edit Accounts function.
- On the Open database dialog you can now use Alt-B to open the browse and Alt-F (for Favorites) to open the previously opened list. In previous versions you had to use the mouse to select the folder buttons.
- Alt-X now selects the Excel Direct button on grids where it is available. In previous versions you had to use the mouse to select Excel Direct.
- The vitalEsafe upload progress dialog has been improved and the progress bar now accurately shows the percentage. It is no longer necessary to install the vitalEsafe patch.
- New functions added in 9.0D default to being disallowed in Security Groups when you upgrade from an earlier version, rather than allowed, as was previously the case in new versions.
Reports
- The Reports menu has been reorganized and a General Reports sub-menu added.
- Added ExcelDirect Financial Statements to the Reports menu to send statement groups directly to Excel without having to launch the Financial Reporter.
- You can now print a distribution summary by account on batch listings. Added the 'Print G/L summary' option to the Print Batches dialog.
- Added the option 'Include closing amounts' to the Detail Listing. It allows you to reprint the Detail Listing at any time without showing the 'Closing Entries' section. It is visible only if you restrict the period range to the last period.
- Added the 'Entries in error only?' option on the batch listing to select only batch entries for the report that have at least one error. This allows you to quickly isolate entries in error that must be corrected before posting, without having to print and review the entire (potentially very large) batch listing.
- Added the 'Opening balances for period' option to the Trial Balance report dialog to allow you to print the opening balances for the selected period rather than the closing balances.
- Added the option 'Exclude 0 balance accts' to the Trial Balance report dialog. Use this option to exclude accounts that might have had activity but ended up with a $0.00 balance, potentially reducing the amount of paper in a Trial Balance with a lot of clearing accounts. This new option is slightly different than the existing option 'Include accounts with no activity', which includes accounts that fall within the selected range and have had no transaction activity within the fiscal period for the report.
- Added the 'Current year/period only' option on the Detail Listing and Trial Balance report dialogs. Select this option to default the fiscal year starting and ending period from the session date used to log into Ledger. The option can be particularly useful when printing the report as a favorite.
- After printing the Batch Status report you can clear the information for the posted and deleted batches in the range printed. A warning has been added indicating that if you do clear this batch information you will not be able to un-post, reverse or recover these batches.
- Reports use the newer Crystal Reports 8.5 print engine. This allows exporting reports to PDF format from the report preview window and is another way (separate from AdagioPDF) to print reports to PDF.
Import / Exports
- Added Import/Export Departments, Import/Export Source Codes, Import/Export Account Notes and Import/Export Reallocations functions. The Import/Export Reallocations functions allow you to readily change reallocation percentages without having to manually edit Reallocations.
- The Import Budgets and Import Forecasts functions include the Account Description 1 and 2 fields. This allows you to use import to change the description for a new year without having to manually edit accounts afterwards or make the change by running the import accounts function as well.
- The Import Budgets and Import Forecasts functions now support importing a single annual budget figure and automatically allocating the amount over 12 or 13 periods.
Edits
- Added the option 'Spread over first 12 periods' in the Edit Budgets and Edit Forecasts functions to allow you to spread the annual budget total out over the first 12 of 13 fiscal periods. The annual total is determined for just the first 12 periods, and the amount for period 13 is set to 0.00.
Inquiries
- Added the option 'Display period n only?' to the View Account Transactions function (where n is the period selected at the top of the screen).
- Added an Excel Direct button to View Account Budget History grid.
Batch Entry
- New options have been added on the copy batch dialog. The 'Revise date fields' option now allows you to set a date rather than using the login date. Added Revise Reference, Revise Description 1 and Revise Description 2 fields, allowing you to set new constant text for these fields during the copy.
Miscellaneous new features
- The Retrieve Subledger Batches function uses the full product name rather than a 2 character code in the resulting batch description when retrieving batches from third-party applications.
- Added the option ''Open all periods?' to the Create Next Year and Create Next Year Budgets functions. Turn this option off to have all periods default to closed. In previous versions the periods all defaulted to open for the next year.
- The Data Integrity Check now detects and rebuilds orphan header and/or detail records in batches.
Problems fixed
- Export / Import functions have been updated for field lengths that should have defaulted to 40 characters instead of 30.
- The Export Transactions function did not find any records to export if the starting Account/Department did not exist.
- The Import Accounts function now prevents you from changing the Account Type.
- Import templates could not be processed on start-up using the 'Auto import on start-up' option if the import file was a .xlxs file, even though the template was set up with the correct filename and could be imported manually.
- The Export Transactions function incorrectly displayed the error "Estimated record count n exceeds capacity of your Excel version (65534 rows). Export aborted." when you exported to older versions of Excel and had 65535 or more records in your GL Posted transactions file.
- In the Export Account Net Changes function, the Opening Balance and Current Balance fields exported were from the current year regardless of the fiscal year selected.
- Several other fixes have been made to the import and export functions.
- You could not create a reallocation batch for a fiscal period in next year if the period was closed in the current year. Ledger was checking the period in the wrong year and you incorrectly received a warning saying the period was closed.
- When the batch listing dialog is opened from the batch list, the focus is now on the Print button rather than the Batch Number field, allowing Alt-P to be used immediately to print that batch. This allows Alt-L and then Alt-P to be used to quickly print a batch you just edited and is now consistent with other Adagio modules.
- When a batch is deleted the Last Edited Date, Time, and User fields are updated.
- If you posted from the Retrieve Subledger Batches function all open batches in current were posted, not just the batch or batches you retrieved, if you were in Next Year and there were no next year batches.
- When a batch containing entries with Statistic Units was copied with 'Reverse Entries' selected the sign on the units was not reversed. The sign of the units was also not reversed when Auto Reverse batches were created.
- If you printed the Detail Listing for a Retained Earnings account for a range of periods that did not include period 1, the report total was incorrect and could not be reconciled to the Trial Balance.
- When the Detail Listing was printed with the 'Batch/entry nos.' option the Batch Entry No. field was partially cut off.
- The Source Net Changes fields were off by one period and the Home Net Changes were off by 2 periods in custom reports created in Crystal Reports for Adagio.
- The Edit Budgets and Edit Forecasts functions refresh the Ending dates column for the year selected. In previous versions the Budget, Forecast and Net Changes columns were updated but not the Ending column.
- For MultiCurrency databases, if an Account Source Currency existed for an account in Next Year, a false error message was being displayed when the Account Source Currency was added to the account in the Current Year.
- When using the next/previous keys in the View Accounts function, the reallocation grid was not refreshed correctly in some cases and displayed information from the previous account you just viewed.
- The Data Integrity Check now detects out-of-sequence errors in the Posting Journal file.
- After printing source journals the backup function could not backup the GL Account Master files (GLMAST*).
Financial Reporter
- You can now force a statement to “Fit to page” either by column or row. File | Page Setup allows you to fit the statement columns or rows to a specific number of pages. The printout will be scaled to fit the space available.
- Editing a SmartSheet is now disabled if the sheet is expanded to prevent you making changes that will be discarded when the statement is refreshed. This disabling includes moving columns.
- You can now hide inactive departments in the Department View. The Right-mouse menu on the Department title includes Hide Inactive / Show Inactive options. Selecting the Ignore Inactive button on a financial statement now also ignores inactive departments (as well as inactive accounts). Inactive departments are suppressed in the department drop-down, and will not be shown in the list of available departments when defining a Statement Group. File | Departmental Print will also ignore inactive departments.
- A new function =ISEXPANDED() (returns TRUE() if the Smartsheet is expanded, otherwise returns FALSE()) has been added so that a formula can test the state of the financial statement.
- 'Include Y/E Adj' and 'Ignore inactive accts' options have been added in statement groups. This information will be printed if “Statement Group” is selected in File | Send to sheet.
- The current row and column is now easier to determine with the column and row number highlighted.
- You can now protect the Excel worksheet that is created when you ExcelDirect a financial statement. This option is enabled in View | Customize | Settings.
- Remove Row and Remove Column on the Edit menu have been renamed Delete Row, Delete Column for consistency.
- Speed keys have been added to most Menu choices.
- The Verify SmartSheet command now ignores inactive accounts.
- You can now enter hyperlinks such as web addresses into cells in a financial statement and these hyperlinks will be preserved when a statement is sent to Excel.
Adagio Ledger
9.0C | 2011-01-31 (Jan '11)
Go to top Release Notes Print This
- In version 9.0C (2010.11.24) the Detail Listing printed an incorrect 'Report Balance' in some cases if the range of accounts printed included Balance Sheet accounts.
Adagio Ledger
9.0C | 2010-11-24 (Nov '10)
Go to top Release Notes Print This
General Ledger
- If Next Year has been created, a retained earnings account can no longer be changed from single to multi-currency and the retained earnings account can no longer be changed in departments or in the company profile, as doing so resulted in incorrect balances after posting or unposting. These changes are allowed again once the current year has been closed.
- When you copied an account to a new account with a lower account number (higher in the grid) than the account being copied, the account you were copying from was opened for edit instead of the new account.
- When editing budgets using '% increase' for the Update Method, or using Moving Values by '% increase', the resulting figures were 100% larger than they should have been.
- A warning message was added in Ledger 9.0C batch entry if the date of a transaction is outside the date range of the fiscal period it is assigned to. This warning now only displays once per entry rather than for each detail.
- If 'Edit retrieved entries' was set to 'No editing permitted' in the Company Profile and you attempted to edit a retrieved batch, if after getting the warning saying modification is not allowed you tried to view a detail anyway, an error message was displayed.
- If you had Next Year open and had posted transactions to an account, then changed that account from single to multi-currency, further postings to the account caused an integrity error that could not be rebuilt by the Data Integrity Check.
- An error occurred if you provisionally posted more than 20 batches at one time.
- An access violation error message was displayed by the Batch Unpost function if you closed the function without unposting or if the 'Auto print posting journal after post' option was on and you unposted (note: the batch was correctly unposted in these cases).
- The Unpost Batch function now handles the case where it previously gave an error if an unposting journal file existed for next year but next year was not open. This likely occurred due to an improper restore procedure (all GL data files were not deleted before restoring).
- Some accounts did not show an opening balance on the Detail Listing when printed in Source and Home format.
- The Report Balance total field at the bottom of the Detail Listing report was incorrect in some cases when it was printed for multiple departments and it included accounts for which the only transactions were from prior years.
- If you posted to the YE Adjustment Period for the prior year, an error batch was created if the period specified in the batch was for a closed period in the prior year. This no longer occurs.
- The new import/export engine used to interface with Excel in Ledger 9.0C gave an error during import if the number of columns in the import file and the template did not match. The error is no longer given if the number of columns in the import file is greater than the number in the template, as users may create a spreadsheet with more columns initially and then delete the values in the columns rather than deleting the actual columns.
- In version 9.0C, if you defined the Amount field incorrectly as string instead of number in a batch import template using the ASCII Fixed Length format, all credits were imported as debits.
- Importing the 'Multicurrency' flag set to true to change existing accounts to multi-currency caused a database integrity error when posting to these accounts.
- When you exported accounts containing an "E" in the Account number to an Excel file (e.g. "21E082"), they were interpreted as an exponential number in Excel (e.g. 2.1E+83). Accounts are now formatted as strings rather than numbers when exported to Excel.
- If an Adagio User belonging to a Security Group that does not permit them to log in attempts to log in, messages are no longer displayed related to retrieving batches on start up.
- An entry as been added to the end of the Data Integrity Check (DIC) log when a rebuild has been done. It now says "After doing a Rebuild you must run the Data Integrity Check again to ensure all errors have been rebuilt". In particular if a rebuild is done and the log contains the entry "Posting file merge completed", you need to run the DIC one more time to complete the rebuild. In general, it is good practice to run another DIC after a rebuild. In cases where the DIC cannot rebuild the database, the entry " Data may require repair. Call your dealer or Softrak Systems for Data Repair Service." is added to the end of the log. Although the data may still be useable, you may want to restore from backup or have the data repaired, as errors in the database may cause problems at a future date.
- The workstation install (WKSETUP.EXE) and the auto-workstation install for Ledger 9.0C (2010.05.11) incorrectly set the path to the Ledger.EXE file in both the Windows start menu and desktop icon to the local C drive instead of to the network drive in some cases.
- The workstation install did not add entries for the Ledger program in the Windows start menu if you installed 9.0 and Ledger 8.1A or older was also installed.
Financial Reporter
- You can now display the Chart of accounts summarized by any text field, as well as in account number order. By populating an option field with an alternative account number, you can choose to display your chart in another sequence. This may be useful in creating statements according to a different coding structure.
- Users with Print Only access can now reset their toolbars and access the options on the View | Customize menu. The fiscal period and year will always be displayed on the Toolbar.
- GLUPDATE did not work for the last column in the statement (usually period 12 or 13).
Adagio Ledger
9.0C | 2010-05-11 (May '10)
Go to top Release Notes Print This
General Ledger
- After converting to 9.0C, there was a data integrity error whenever you posted to an account that had not been posted to yet in
9.0C. There was no data loss and the Data Integrity Check rebuilt the error. The Data Integrity Check now also detects and
rebuilds the problem caused by the conversion, preventing any further problems in posting.
- The data dictionaries required by 9.0C were not installed in some cases on some machines due to an unknown lock on these files
by the OS. The install now detects this problem if it occurs and displays a warning. In addition, the program now detects when the
data dictionaries are not correct and displays the error "Incorrect data dictionary for this version of Ledger. Please re-install
Ledger." when started.
- You can now optionally turn off creating a Table in Excel 2007 when using Excel Direct from grids and finders. If you don't have
one already, create an ssi2xl.ini file in your x:SoftrakSystem folder (where 'x' is the mapped drive Adagio is installed to) and enter
the following setting, where <windows user name> (without the angle brackets) is your Windows login name (not your Adagio user
initials):
[DisableTableCreate]
<windows user name>=1
- If the Security Group restricted access to Edit Accounts but Edit Accounts was selected for On Startup, Edit Accounts opened
when it should not have.
- The Import Transactions function required that the import file contain the 'Transaction No.' field and it could not be set as a field
default. It is still a required field but it can be (and must be) set as a default so it will be auto-generated if it is not included in the
import file.
- The Export Source Currencies function only exported the current year even when a different year was selected.
- If posting failed in Ledger 9.0C, you got the error "Incomplete posting. Only Data Integrity Check will be available." when you
attempted to open the database. However, the Data Integrity Check displayed an error and could not be run.
- In rare cases a user opening the Ledger database while another user was posting could get a false error message indicating there
was an incomplete posting.
Financial Reporter
- A new property, 'Edit On Print', has been added to the context menu when cells are selected. Cells with this property may be
changed by a user when a statement is opened in “Print only” mode. For example, this allows a user who is restricted from editing
statements by security Group to be able to enter and update budget / forecast figures. Cells marked with this property have a pale
yellow background. This default may be changed under View | Properties. The chosen color shows up when viewing the spec but
does not appear on Print Preview or when printing to paper.
Adagio Ledger 9.0C 2 of 4
AL20100511 11-May-2010
- In some circumstances in 9.0C, a financial statement would fail to generate a row for the ending account in a range, when a
statement was expanded for a single department.
- GLUPDATE() failed to report some errors on evaluation and incorrectly handled a leading minus sign. This has been fixed.
Adagio Ledger
9.0C | 2010-04-05 (Apr '10)
Go to top Release Notes Print This
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 softraksystemssi2xl.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.
Adagio Ledger
9.0B | 2009-07-13 (Jul '09)
Go to top Release Notes Print This
- An option to open the Account Transactions inquiry on startup has been added to the company profile.
- Closing the year in Ledger 9.0A did not update the budget total in the account master resulting in an incorrect amount in the account
grid (only the grid was affected). The Data Integrity Check now detects and corrects the budget total.- The smart finder on the Department in the Edit Department function gave a field number out of range error in Ledger 9.0B.
- When you deleted a transaction from a batch the cursor was repositioned to the bottom of the batch and the grid lost focus. It now
positions correctly on the transaction following the deleted one.- The option to print landscape oriented multi-currency reports on scaled printers was not working reliably and has been replaced with
an option to ‘Fit to paper size’ (your printer / driver must support ‘Fit to paper size’). Under File | Options, the ‘Multi-currency Report
Printer / Orientation Landscape’ option ‘Letter on dedicated scaled printer’ (and in some modules, ‘A3’ and ‘A4’) has been replaced
with ‘Legal fit to other’ option. Use this option to print landscape oriented reports such as the Detail Listing report in ‘Source and
home’ on letter instead of legal size paper. International companies can use this option to print on A4 or A3 paper. A Tech Tip is
available from Softrak describing how to fit legal size reports on letter.- The Trial Balance in Ledger 9.0A/B (for any period except period 12) was incorrect when there had been year end adjustments
(whether or not ‘Include YE adjustments’ was selected).- Added the ‘Show Description’ option to the Trial Balance report, allowing selection of Primary, Secondary or Both.
- The Account Balance total on the Detail Listing in Ledger 9.0B was double when printed with ‘Include prior year postings’ selected.
- Ledger 9.0B could not retrieve a multi-currency sub-ledger batch into a single currency GL and displayed the message 'Home and
source amount differ on a home currency entry. This batch cannot be retrieved'. This has been fixed.- ExcelDirect from the View Accounts function now creates a table in Excel® version 2007 or higher rather than simply populating
cells.- The F5 and F6 keys were not launching the Find in the View Accounts function.
- The Data Integrity Check now detects and removes corrupt budget records that have a blank fiscal year.
Adagio Ledger
9.0B | 2009-04-30 (Apr '09)
Go to top Release Notes Print This
Sign-on
- The Adagio Open Data Dialog has been significantly improved. The Previously Opened database list is now saved by Adagio User rather than for all users. The first time an existing user or a new user logs into Adagio Ledger 9.0B they will be asked “Would you like your historical company access list set up?” Answer yes to have all entries from the Previously Opened list from your prior use of Ledger copied for your use. The Open Data screen and Previously Opened database list now show the date the database was last opened by the user. You may also elect to have Adagio save your Adagio User Id and Password and default them when logging into Adagio. The saved information is based on your Windows authenticated user name. This option may be turned off by editing \softrak\system\ADS.INI and adding the lines:
[Options]
RememberUser=0
RememberPassword=0- Options have been added to open several different functions when the program starts up, including Account Edit, Account Inquiry, Current Year Batch Edit, Archive Batch Edit. External batch management is improved with options to “Auto Retrieve Batches” and “Warn Retrieve Batches”. “Auto Retrieve” launches the external batch retrieve dialog from which the user may cancel if desired. Turning the retrieve options off allows you to prevent certain users from being able to retrieve sub-ledger batches.
Accounts / Departments- When creating a new department you can create accounts for the department by multi-selecting either the entire chart of accounts or selected accounts. This is particularly useful when creating your first department since you cannot copy an existing department and the accounts belonging to it.
- Copy Account allows control of ‘Additional files to copy’, including Notes, Budgets, Forecasts, Reallocations and Currency buckets, and places you directly in account edit for the newly created account.
- You can now make a department "inactive". When a department is made “inactive” you can optionally makes all accounts in the department inactive as well.
- You can now copy budgets to forecasts and vice versa. If you are editing budgets, then the copy function will move the figures to the forecasts. By sorting the Edit dialog into department-account sequence and multi-selecting all the accounts in a range, you can easily copy all the figures for a single department.
- Copying Source Codes and Source Journals automatically places you in edit for the newly created item.
Inquiries- The View GL Entry screen is now sizable.
- An Excel button has been added to the View Account Transactions function, allowing you to send accounts, transactions or entries to Excel with one mouse click.
Batch Entry- Default batch description text can be automatically created with user initials (%usr), date (%dat) and time (%tim) created in a user specified format. Multiple date and time formats are supported. These options are set on the Options tab in the Company Profile. The batch description can still be edited as required when the batch is created.
- Added ‘Auto-balance entry’ option to batch entry. This option automatically fills either the debit or credit side of the transaction with the amount necessary to balance the entry. The cursor is automatically placed in the debit or credit. The auto-balance option is best used when journal entries have pairs of details, with one debit and one credit of equal amount. The setting you choose is remembered for the next entry.
- The copy batch function now updates the last date and user information if any of the revise options (date, period, reverse debit/credit, etc) are selected. It does this when copying or moving batches or entries, and when copying to the same batch, a new batch or a specific other batch. If none of the revise options are selected, then information for the copied entries remains the same as the original entries. Note that the batch control also independently stores created by user/date and last edited by user/date, and this information is always updated to the new user/date as appropriate when creating a new batch or adding to an existing batch.
- Added the Account Description to the list of fields available in the Column Editor for the details grid in batch entry. The ‘Unit Amount’ field is now available in the Column Editor to allow you to show statistical units in the details grid in batch entry.
Posting- You can now un-post batches from the Next Year.
Reports- Added ‘Allow Post Journal Purge’ option to Company Profile. If this option is off you cannot clear the regular posting journals after printing them. This prevents accidental purging of posting journals. If this option is off the posting journals will be purged as part of Year End. The Unposting Journal can still be purged after printing.
- The Chart of Accounts report now has an option to exclude Inactive accounts from the report.
- Added total debits and total credits fields for all Inactive accounts not included on the Trial Balance report to prevent confusion when inactive accounts have a balance on file.
- Accounts with activity are not printed on Trial Balance if the activity nets to 0 in each period. This will help reduce the number of clearing accounts that are listed on the report.
- Added option ‘Close report dialog after print’ on the Print/Post tab in the Company Profile. Set this option off if you often print reports multiple times with different settings or ranges.
- The list of printers available from Windows is now refreshed immediately before printing reports and receipts. When a user with a shared local printer logs in under Terminal Services the list of printers available to Windows changes because one more printers has in effect been added. If other users were in Adagio applications this resulted in the selected printer being changed in Adagio in some cases. If the user did not notice this and reselect the correct printer before printing then their report randomly and unexpectedly printed on a different printer.
- The right-hand edge of some reports was cut off on A4 paper. In version 9.0A the program no longer forces the form size (i.e. override the setting in customized reports). This allows users to use the ModRP feature to change the standard reports to make them narrower.
- Report printing performance has been improved on some reports.
- The Active field is now shown on the Chart of Accounts report.
Edits- Edit Budgets and Edit Forecasts have been significantly improved to speed the entry of budget figures. Speed keys have been made available on several frequently accessed fields, and the tab order has been modified to more accurately conform to the expected field entry. When “stepping through” a range of accounts or departments, Adagio Ledger remember the previously used method for allocating the budget and automatically changes the method. If you “step into” an account with non-zero entries and there is no previously used budgeting method on file for the account, you will be placed into “manual entry” mode to prevent inadvertently changing the previously set budget figures. If the method results in updated budget or forecast figures, these amounts will be displayed in red to highlight the change. For accounts where the budget / forecast has never been edited the function defaults the entry method to the last you used for the company. If the program will be saving changed figures, the “Ok” button text will be changed to say “Apply”.
- When editing the fiscal calendar, the starting date of next period is automatically set on exit of the previous period’s ending date.
- You can now change the Type in an Account in some cases. In cases where it is not allowed it is now prevented. Refer to the help for specific details.
Retrieve Sub-ledger Batches- Retrieve sub-ledger batches now supports the Accounting Date field introduced in Receivables 9.0A. This field is used to force individual transactions into a period other than the period of the transaction date. You can now retrieve a batch to a specific period in the Next Fiscal Year. If Next Year is created, then a Fiscal Year is editable when the Specific Period option is selected. If Next Year is not active, then the fiscal year is visible but not editable.
Import / Export- Imports may be selected to process automatically when Adagio Ledger is started. An import template must be marked for automatic processing, and the corresponding start-up option selected in the Company Profile.
- A new function, ‘Clone Company’, has been added to the Export Menu. Clone Company allows you to quickly create a new company, choosing the parts of the existing database that will be useful (such as departments, budgets, financial reports, and source journals). If accounts are moved to the new database, their transactions will be deleted and the account balance set to zero. The home currency code can be changed for the target company.
- Export batch function added (Detail-only format). This allows remote sites to export a batch and send the file to a head office to be imported. The ability to do this was lost in Ledger 9.0A because archive batches are in one file rather than individual files. Export batch also adds the ability to update archive batches by exporting, making changes and importing. The copy batch function allows you to revise the period and date but you may also want to update other fields such as the amount, description or reference.
- A log of records skipped and the reason is stored in the import log file GLIMPERR.dat.
- Export/import with a path greater than 65 characters resulted in an Access Violation error. You now get a message explaining the problem.
Data Integrity Check- The Data Integrity Checker (DIC) can rebuild from an incomplete posting in many cases. NOTE that the incomplete posting flag is not reset until you do another DIC after the rebuild and it is clean (i.e. you have to rebuild twice). You cannot get to other functions until the DIC is clean. You must also check that your account balances are correct. Although the integrity check has rebuilt all the errors and accounts are in balance it is possible the amounts are not correct or that there are missing transactions. These will have to be entered and posted in another batch.
- Adagio Ledger will optionally create a backup of related data whenever a Data Integrity Check completes without errors. Adagio Ledger will always create a backup of a database prior to applying any “fix” as a result of the “Rebuild” option being selected to repair damaged data. Backup details are written to the log file.
Maintenance- You can now run the Revalue Accounts function for the Next Year.
Generic- Date entry has been improved by recognizing a single number as a day and defaulting the month and year of the entry. Four digit numbers default the year. Entering “12” into the date control with the sign-on date being Feb 26, 2009 will result in February 12, 2009 being returned to the application.
- The options ‘Enable SF Export’ and ‘Enable SF Printing’ have been added to the Edit User screen to allow you to disable Excel Direct in Smart Finders to help safeguard your sales data, customer list and other information in your database.
- The performance of the SmartFinder over a network has been improved significantly. The SmartFinder on Accounts is 2-4 times faster.
- When Adagio GridView 9.0A or higher is opened from the Adagio menu, Adagio Ledger 9.0B will be displayed as the first line on the Select Module screen so you do not need to scroll down to find it.
- The Help Menu has been modified to allow the user to launch the Adagio System Status utility (chksys.exe) and print the Adagio Lanpak registration form.
- WebSafe changed to vitalEsafe™ in Backup function to reflect the 3rd party name change.
- The multi-currency files for single currency databases are now backed up when you backup a ‘Complete Dataset’.
- Updated the help, including adding a Year End Processing Checklist.
- Automatically copies help files (*.chm) to the local drive so that Service Packs do not require a workstation install just to update the readme help file.
- Install, workstation install and Service Pack install now support installing to a LINUX server without a special command line parameter.
- Several minor changes have been made when creating a new database.
Adagio Ledger
9.0A | 2008-04-02 (Apr '08)
Go to top Release Notes Print This
- When installing the GL 9.0A (2008.03.07) Service Pack (but not a full product or upgrade) and you are running anti-virus software, if you elected to install the sample data the install performance became extremely slow in some environments.
- Scrolling in the grid of Accounts in the View Transaction/Budgets function was slow on large databases on a network drive in Ledger 9.0A (2008.01.22) and 9.0A (2008.03.07).
- Scrolling in the grid of transactions in the View Transaction/Budgets function did not work correctly if there were a large number of transactions for the account and depending on where you were positioned in the grid.
- The Source Journals could not be printed in Ledger 9.0A (2008.03.07).
- Additional fields from the transaction are now included on the transaction dialog in the View Transaction/Budgets function.
- When editing several existing entries in a batch (not entering new entries) an Access Violation occurred in some cases.
Adagio Ledger
9.0A | 2008-03-07 (Mar '08)
Go to top Release Notes Print This
- The look of disabled buttons on the toolbar has been improved.
- In View Accounts you can now sort the View into Department/Account sequence. Use the right-mouse button to select the sort.
- The Posting Complete message screen appeared under the Merging Transactions screen in some cases when posting a very large batch with data on a network drive and you topped another window during posting. This made it appear that the posting was hung, although simply topping the Adagio Ledger and pressing ENTER would clear the problem.
- If you tried to post an entry to an account that does not exist, the Posting Errors report showed 'Error in Entry x in batch y. Placed in batch z. Net Change record missing.' The error is now correctly shown as 'Error in Entry x in batch y. Placed in batch z. Invalid Account.'
- Detail Listing can now be printed in a 'Condensed' format. This format allows for more transactions per page. The condensed format more closely resembles the Detail Listing in previous versions. Use the 'Units' or 'Batch/entry nos.' formats to show the additional information available in Ledger 9.0A. To reduce the number of pages even further, select Report Options under the Reports menu and turn off the option 'Show parameters on all pages' (there are more options in Ledger 9.0A than in previous versions, making the header section larger).
- The pennies were cut off of the right most column of the Detail Listing fro some printers in some cases.
- Some corrections have been made to the Detail Listing when sorted by Department / Account.
- The 'Import Source Currencies' function reported errors when you tried to save a new template in some cases. These errors should only have been displayed when the import was actually run. This prevented you from saving the new template.
- The import function now remains open after completing an import. This is convenient if you have several imports to perform.
- When you ran "Close Current Fiscal Year', a list of 'Procedures to complete before running Change Fiscal Year' appears. This has been changed to 'Procedures to complete before running Close Current Fiscal Year'. In addition, the item 'Close year - must perform function first' has been changed to 'Close Income/Expense Acct - must perform function first'. These changes should help clarify the steps required before closing the year.
- The error 'Floating point division by zero' occurred when retrieving prior year data in a multi-currency database if a multi-currency transaction had a source amount but the home amount was zero.
- Help and Financial Report Help have been updated.
Adagio Ledger
9.0A | 2008-01-22 (Jan '08)
Go to top Release Notes Print This
- Printer Setup button added to the print preview window. Allows you to select a different printer after previewing a report.
- Copy batch from Next Year now defaults the period based on the date rather than always setting it to period 12.
- The Edit Batches grid has some improvements and corrections to the copy and move functions when in use by multiple users.
- The final balance was not printing for the last Department on the Detail Listing.
- Pressing the Listing button displayed the message "Incomplete posting. Only Integrity Check and backup will be available" if at batch was posted by another user when you had the batch list open.
- The subtotal amount on the Batch Listing was cut off when the amount was in the billions.
- On the Trial Balance screen, if the Report style was set to 'Worksheet', the screen was screen was not displayed correctly.
- The Detail Listing did not show the closing entry correctly after posting to a Prior Year income statement account.
- In Edit Accounts, equity accounts that are Balance Sheet accounts rather than Retained Earnings accounts (such as paid in capital) could not have their Account Group set to C10 'Equity - Share Capital'.
- If you added a prior year in the Edit Fiscal Calendar function and then edited account history for that year it caused an integrity problem in some cases.
- The period description was coming from the current year instead of the selected year in the View Transactions function.
- You could not import Accounts, Budgets, Forecasts, Statistics or Transactions in Adagio Ledger 9.0A (2007.12.19) and received an error saying you were blocked by another user (yourself).
- If the 'Report missing departments as errors' was enabled in the Company Profile, then importing accounts for which the department code did exist resulted (correctly) in an error. However, this was also preventing import of accounts that don't have a department at all.
- The Export Transactions function incorrectly gave the error message 'starting period is greater than last period' when the range did not start at period 1.
- Importing new accounts when Next Year was active cause integrity errors in some cases.
- Importing transactions for accounts in a prior year caused integrity errors in some cases.
- Swapping back and forth between import account templates without first closing the import function caused the fields to get mixed up in the template.
- The Import Account Net Changes function reported errors when you tried to save a new template in some cases. These errors should only have been displayed when the import was actually run. This prevented you from saving the new template.
- If both fields Fiscal Date and Fiscal Period are imported in a batch, the Fiscal Period now takes precedence unless it is zero, in which case the Fiscal Date is used to determine the period. This is the way it worked in earlier versions of Ledger. In GL9 however, the Fiscal Date was always used and the Fiscal Period in the import file was ignored.
- The Create Next Year function allowed you to cancel. If you canceled it caused integrity errors in some cases. Cancel is no longer permitted.
- You were permitted to close year to an account that was not a Retainage account. This caused errors when a new year was created. This is no longer permitted in the Close Income/Expense Account and Create Next Fiscal Year functions.
- The DataCare check of Ledger multi-currency data incorrectly reported the error: 'Retained Earnings account does not accept currency'. The Data Integrity Check in Ledger itself did not report this error.
- When multiple instances of Adagio Ledger were run on the same machine, the window title did not show the instance number (for example: Adagio Ledger (2) - Adagio Corporation).
- The cursor remained displayed as an hourglass in some cases after the program displayed a message indicating the Financial Reporter was locked by another user or instance.
Adagio Ledger
9.0A | 2007-12-19 (Dec '07)
Go to top Release Notes Print This
- You could not paste serial numbers and install codes into the install screen using the right mouse menu, although Ctrl-V worked fine.
- The currency files were deleted in some cases if you elected to uninstall your old version of Ledger when installing the Ledger 9.0A upgrade to a network drive. This could happen on single currency databases and it prevented you from opening Adagio databases until the files were restored. In addition, the SSINST32.DLL file was uninstalled in some cases if you installed your Adagio 8.0 or earlier products from a different workstation than one used to uninstall your old version of Ledger. This prevented you from running Adagio 8.0 and earlier modules.
- The sub-ledger batch could not be retrieved from some third-party products in some cases if it included comment lines. The products affected included Purchase Orders for Adagio and 21st Century Payroll.
- The sub-ledger batch could not be retrieved from Adagio JobCost 8.1A if transactions had been posted in JobCost prior to and after upgrading to Ledger 9.0A before retrieving.
- When the Next year is activated, the retrieve function displayed a screen with Yes/No choices to post sub-ledger batches for the Next year, when retrieved batches do not default as Ready to Post, thus posting should not yet be available. The Yes/No choices have been replaced by an OK button.
- If you had the View Transactions/Budgets screen open when you posted a batch, the posting did not complete in the 2007.11.02 release. In the 2007.12.17 Hot Fix you received the message: 'Unable to merge posted transactions, file currently in use by another process.'
- The export Account Budgets function did not insert the appropriate value for the account or department in the range fields in some cases, causing the error message 'No records to export in that range.' to be displayed.
- You could not import a batch in the 'Detail-only' format that had only 1 entry when running the 9.0A (2007.11.30) Hot Fix.
- A failed import created an empty batch in some cases.
- The values for the Account Sign showed 'Debits' as blank in GridView when the 'Translate coded fields' option was enabled. Grids within Adagio Ledger displayed 'D' correctly.
- The Active/Inactive ('A'/'I') values showed as reversed in GridView. Grids within Adagio Ledger displayed correctly.
- The Description field showed as blanks on the batch entry details grid when added to the grid with the column editor.
- The Comments field showed as blanks on the batch entry grid when added to the grid with the column editor.
- Using the finder in the Edit Account Forecast Data function caused an access violation error.
- The Smart Finder was not working on Account / Department fields in Adagio 8.1A sub-ledger programs after installing Ledger 9.0A.
- The 'Description 2' field is now available in the column editor on the batch entry details grid.
- Added the composite table 'GL Net w/Budgets & Master (Read Only)' to make it easier for GridView users to get Account Master, Balances and Budgets on a single view.
- The Reference, Date, Account and Department fields from the first detail line of the entry can now be shown in the batch entry grid.
- When editing Archive or Next Year batches, the window title of all screens now includes 'Archive' or 'Next Year' to differentiate them from current batch screens.
- Editing a provisionally posted batch did not reset the status to Open.
- The error message displayed if the Retained Earnings account was invalid showed the wrong department.
- Some field labels and button names were incorrect in the Backup Options, Security Group Setup and Security Group Listing functions.
- If you have the Company Profile option 'Report missing department errors' selected, this will now prevent creating a new account-department pair for which the department code does not exist. Previously this was only reported as a warning in the Integrity Check. This affects creating, copying or importing new accounts.
- Options for A3 and A4 paper added for the Multi-currency Report Printer in File | Options. Available only on multi-currency databases. The report formats remain unchanged. Users with Crystal Reports for Adagio can modify canned reports for A3 and A4 paper and place in \Softrak\Ledger\ModRP.
- The Detail Listing report prints now prints subtotals for the account net change and the account balance in the footer section for each account. The report footer section contains the Report net change and the Report balance. Labels have been included to identify the amounts. Previously the Total account balance was not printing on the report.
- When printing the Detail Listing report for departmentalized accounts and the last department had no transactions, the account totals section was incorrectly suppressed.
- The Account Description was not fully displayed on the Detail Listing report for long descriptions.
- The GL Listing and Trial Balance reports now have 2 options to control selection of accounts: 'Include accounts with no activity' and 'Include inactive accounts'. The former refers to accounts with no postings and the later refers to the 'Account active?' setting in the account. Note that when 'Include inactive accounts' is off, accounts with a balance can be excluded and therefore the report may not be in balance.
- Printing Next Year batches did not set the status to Printed.
- The Batch Listings for Next Year incorrectly reported errors that the period was closed if instead the same period in the current year was closed.
- The Posting Journal report did not print if it contained consolidated entries and you selected to sort by Account.
- When the Posting Journal was sorted by Account the prior year report did not print "Prior Year", and the current year report did print "Prior Year".
Adagio Ledger
9.0A | 2007-11-02 (Nov '07)
Go to top Release Notes Print This
- Smooth Year End. Close Year is now Close Income / Expense Accts. Change Fiscal Year is now Close Current Fiscal Year. Create Next Fiscal Year function added. Transactions can be posted in either the current and last fiscal year, or current and next fiscal year (when the next year has been opened).
- Multiple Years of History including transactions are now supported. Closing a year does not clear the transactions for the year being closed. Detail transactions are available for drill down in the financial reporter, and G/L detail listings can be printed for prior years.
- Prior years can be retrieved from backups of Adagio Ledger databases from previous years (the data to be retrieved MUST NOT be converted to 9.0A prior to retrieval) or ACCPAC® PlusT G/L (except version 7.0A) including net changes (balances) and transactions. Use the 'Retrieve prior year data' function in File | Import. Your prior year data must be a snapshot of a point immediately after completing year end, and if prior year postings were made in the current year they should also have been made in the backup database. The database to retrieve should not have any integrity errors. The retrieve has a mandatory check integrity button to check posted and net change balances in the database before retrieving. If these conditions are not met, the prior year figures may not be correct and data integrity errors may be reported. Once prior year data is retrieved, it is not included in further integrity checks done in Adagio Ledger V9.0A.
- Account Groups can be defined as non-contiguous ranges, and these ranges can be enforced when new accounts are added to the chart of accounts.
- Archive batches can be entered just like current batches. Batches are archived and restored by copying between current and archive. Old style archive batches from previous versions are retrieved into the new archive batch system when data is converted to 9.0A, if they reside within the same folder as the data being converted.
- The Account Description field has been increased from 30 to 40 characters. Accounts also have a second description field. You can print the primary, secondary or both descriptions on the Chart of Accounts report.
- The Transaction Description has been increased from 30 to 40 characters. Transactions also have a second description field. The second description can be entered in batch details and will be retrieved from 8.1A or 9.0A subledgers. You can print the primary, secondary or both descriptions on the Batch Listing, Posting Journal, and Detail Listing.
- A Find has been added on View Transaction/Budgets.
- View GL Entry displays all transactions that made up an entry (unless consolidated).
- View Account Transactions has Debit and Credit columns instead of one column with positive and negative amounts. An Amount field is also available in Column Editor and GridView if you do not want to separate debit and credits.
- Edit Fiscal Calendar is a separate function instead of part of the Company Profile.
- Fiscal Calendar screen has been improved. The pop-up calendar is now available in the period start and end date fields. The date in the period description field can be formatted automatically using the period start or period end date.
- The Fiscal Calendar can be printed.
- Post to Prior Year can have transactions written to a separate 'YE Adjustments' period so that they are kept separate from actual postings from the year. Reports and Financial Statements have options to exclude these posting to the YE Adjustment period.
- Statistics fields in Account/Department can be used to track units such as hours, gallons, pieces, etc. Enter the Type of Units when the account is created or edited. Quantity of units is entered in batches for those accounts that have an associated unit. Adagio subsidiary ledgers up to and including V8.1 do not send statistical information to any accounts. Statistics units and quantities can be shown on financial statements and optionally printed on the G/L Detail Listing.
- Forecasts feature added. Forecasts are similar to Budgets. Use Budgets to hold your original figures and Forecasts for revised budget figures. Both figures are available in the Financial Reporter.
- Improvements to Budget entry and display. The column editor can be used to choose display fields for source and target accounts. The source can be any fiscal year. You can edit budgets for any fiscal year and use net changes, budgets or forecasts for the source. Auto advance by account has been added. You can also auto-advance by department. Next / Previous buttons added to speed moving to new account to edit. Column totals have been added to the Display Account budget amount fields.
- Drill-down to subledger ready. Retrieve is ready for subledgers to send fields required to allow drill-down. Future releases of Adagio sub-ledgers may support drill-down from Ledger. Adagio 8.1A subledgers are already sending the information necessary for drill-down to Ledger 9.0A when it is installed.
- Retrieve ready to support Fiscal Periods specified in the subledger transactions. Future releases of Adagio sub-ledgers will allow the fiscal period to be specified in batch entries.
- Retrieve ready to support statistical, such as hours, gallons, pieces, etc. units entered in subledgers. Future releases of Adagio subledgers post units to the G/L transaction batch.
- Open database not only warns if there are subledger batches to retrieve, it now also offers to retrieve them at that time. If the 'Require print before posting' is off, the retrieve will also offer to post the batches. The posting journal will be printed after posting batches during the retrieve if the 'Auto print posting journals after print' option is on.
- When installing an upgrade there is a warning that a database conversion will be required. The conversion suggests you do a backup first and offers to do it there and then. Once a database has been converted, it cannot be accessed by earlier versions of Adagio Ledger or ACCPAC Plus General Ledger.
- Added View Accounts in Inquiries menu (i.e. Edit without ability to save). Security Groups can be used to allow users to view but not edit accounts.
- Optional fields have been added on Accounts (3 strings, 2 dates, 2 dollar and 2 unit amounts). Field titles are set in the company profile.
- User and date stamp fields have been added on batch entries. Use the Column Editor to select the 'Date Edited' and 'User Edited' fields.
- Grids and finders support the 'Account active?' flag in Accounts. Inactive accounts can optionally be hidden on grids and finders. To hide inactive accounts, set the 'Active records only' option in the Column Editor for the grid or finder. This option also prevents you from editing inactive accounts or entering them in a batch.
- Ready to Post indicator on batches. Selecting a range of batches to Post will skip those with this indicator set "off". Company profile options control the default setting for this flag when batches are created. You cannot post an out of balance batch regardless of the setting of this flag.
- Unposting batches now respects the open/close flag of the fiscal calendar when you delete the transactions from the file. You cannot delete transactions using Unpost batch from closed periods.
- Earlier versions of Ledger have the ability to remember fields during batch entry but only until you close the batch. Ledger now has the ability to remember fields from an existing entry without having to first add a new entry. To do this, open an existing entry and tab through the fields in a detail. You might use this if you were in the middle of a big batch, closed GL and returned to complete it later. This saves you from rekeying the reference and a possibly lengthy description fields.
- The Data Integrity Checker now has warnings as well as errors. Note that Adagio DataCare counts warnings as errors and warnings will cause a fail status on a DataCare job. You can set the 'Application errors to ignore' equal to the number of warnings to cause a pass in the job. Account balances with the wrong normal sign (set when the account is created) generate warning messages.
- You can now adjust the home currency amount for a source currency balance without touching the source currency amount for cases when the subledger source amounts agree with the Ledger but the home amount does not.
- Added Import/Export Transactions functions. Import functions for Net Changes, Budgets, Forecasts, and Statistics/Net Changes have been added. They are separate from Import Accounts function.
- Added 'Account normal sign' field in accounts to indicate the type of balance the account should normally have. It can be set to Credit, Debit or Both. The Data Integrity Checker will give a warning if an account balance is not 'normal'.
- Security Group Setup has a listing report to print allowed/disabled menu choices.
- Inquires menu added. View Batch Status function added to the new menu. The Display Accounts function has been moved to the new menu and now displays only the account information. View Transactions/Budgets is a separate function in the menu. Custom GridView views appear in this menu now, rather than the reports menu.
- The Posting functions have been consolidated into a single function, so you can select to post to current year, post to prior year or post provisionally, without having to close and re-open a different function.
- The Print Posting Journal functions have been consolidated into a single function, so you can select regular, provisional or unpost journal, from the current or prior year, without having to close and re-open a different function.
- The Close Current Fiscal Year menu choice is hidden until it is valid to use.
- Fields are always verified during entry. The Field Verification option previously found under File | Options has been removed.
- Improved the program icon and toolbar buttons for a cleaner look and better scaling on Vista.
- If menus have been disabled because of an integrity error so that only the Data Integrity Check menu choice is available the Backup menu is now also available.
Adagio Ledger
8.1A | 2007-09-23 (Sep '07)
Go to top Release Notes Print This
- If you had ACCPAC Plus General Ledger open when you started Adagio Ledger 8.1A (2007.06.01) on the same database you received an error message saying "Your current version of Adagio Ledger is not compatible with the version of Adagio Ledger database you are currently using".
- Doing an export to Excel Direct (using menu or button) exported numbers which display as negative values in the Financial Reporter as zeroes in Excel.
- The toolbar buttons AutoSum, AutoFit Rows, and AutoFit Columns were not visible on the Format toolbar on a new install. You had to go into View | Customize and click Reset it to get all the buttons.
- In Adagio Ledger 8.1A (2007.06.01) backup up to some removable devices, such as a USB Key, reported the error "Cannot update an existing spanned disk set" and the backup could not be completed.
- The search criteria for smart finder were not remembered in Adagio Ledger 8.1A (2007.06.01) after closing the program.
Adagio Ledger
8.1A | 2007-06-01 (Jun '07)
Go to top Release Notes Print This
- Compatible with Windows® VistaT.
- Compatible with Adagio Lankpaks 8.1A. Lanpaks must be 8.1A for all Adagio 8.1A modules.
- Smart Finder can now search on multiple criteria.
- Contents of disabled fields are shown in blue rather than dimmed gray. This may be easier to read on some monitors at higher resolutions.
- Adagio download files, installs, workstation installs, all workstation install (\softrak\allwkst\allwkst.exe), and the Adagio Check System utility (chksys.exe) are now signed with a digital certificate using VeriSign to allow you to verify the Publisher is Softrak Systems Inc.
- Vista does not support the old style Windows Help (.HLP files). All .HLP files were converted to compiled HTML help (.CHM files), which are supported by Vista.
- For security reasons Windows does not permit .CHM help files to be run from a network drive. This is true in XP as well as Vista. The .CHM files must be run from a local drive. Adagio 8.1A installs all .CHM help files to your local hard drive and loads them from there. The workstation install also copies .CHM files to the local drive.
- When switching window/task in Vista with Alt-Tab or the new Flip 3D (Windows-Tab) an image of the current Adagio screen is shown rather than just the icon of the Adagio program.
- You can now backup Adagio data in zip form to WebSafe, a web-based storage facility. WebSafe is a service which allows you to store your important information in a secure location that you can access from anywhere in the world. See www.websafe.com for details.
- Currency symbols other than $ are now supported in reports.
- The formatting of dates and text containing numbers sent to Excel from Smart Finder results has been improved.
- The formatting of dates and text containing numbers sent to Excel from the drill down in the Financial Reporter has been improved.
- Adagio Sub-ledgers are Adagio Ledger 9.0A ready. Fields in 8.1A sub-ledger transaction batches required for future drill-down from Ledger to sub-ledgers are being retrieved now in Ledger 8.1A.
- Attempting to add a duplicate multi-currency GL account caused integrity errors in the original account, even though the program prevented you from adding the duplicate.
- Financial Statement Designer:
- Two new functions =GLFPSD() and =GLFPED() are available that return the fiscal period starting period and fiscal period ending period (respectively) as a date type. The new functions expect a .ColSpec line to determine the specification code. You may apply any of the standard date formatting rules to the cell, or pass the function to =DATESTRING() to specifically format a date (although changes to =GLFPS() and =GLFPE() should minimize the need for this - see below).
- =GLFPS() and =GLFPE() now take an optional second string parameter to override the default fiscal period date format set in View | Customize. The values in the string are the same as those used in the =DATESTRING() function to format dates according to your requirements. Specification codes exist to display just the year, month or day portion of the date in all formats. Examples of 2nd parameter:
"MMM" Jan
"YYYY-MM-DD" 2007-01-01
"YYYY-MMM-DD" 2007-Jan-01
"YYYY-MMMMM-DD" 2007-January-01
"MMMMM DD, YYYY" January 01, 2007- Added Column Page Break to the Financial Reporter for better control of pagination when printing statements.
- An option was added under View|Customize|Settings to force Excel Direct to send values rather than formulas.
- In version 8.0D (2006.10.20) a new feature allows you to send sends formulas to Excel, not just values. Fixed problems with Excel Direct when using $D, <<, >> and ==.
- Users with a Departmental Restriction can no longer View or Print Statement Groups, for those groups that reference a department to which they do not have rights.
- When creating a new financial statement using drag and drop, Use Colspec format is now the default choice.
- Drill down to Tx Details is now available when using the ColSpec format.
- Drag and Drop using the ColSpec format "freezes" to top rows of the statement. Printing will include these rows on each page.
- In some cases, Row Formatting and Zero Suppress when used together did not apply the proper formatting. This has been fixed.
- Covered cells prevented selecting columns for copy and format. You can now select the column though the cells in the top rows are under a 'Cover'.
- File\Import Spec was creating a filename with the prefix AF! instead of GL!.
- You can now duplicate columns from the right-click pop-up menu when a single row is selected.
- Corrected problem in Excel Direct decimal precision in 8.0D (2006.10.13)
Adagio Ledger
8.0D | 2006-10-13 (Oct '06)
Go to top Release Notes Print This
- Unposting a batch now has a "busier" status bar to reassure users that it is working.
- The batch number and batch entry number did not print on the Posting Journal when printed in detail format sorted by account.
- The Trial Balance and Chart of Accounts reports did not print if the 'Remember report settings' option was on when you set the 'Enable departments' option.
- Financial Statement Designer:
- When creating a financial statement, you can now select to have the resulting statement use the new ".ColSpec" SmartSheet command for its formulas.
- Several new functions have been added and can be placed on a statement from the context menu.
- Three new financial statements have been added to the sample data.
- AF!FunctionExamples and AF!DateFunctionExamples have been updated to include more examples.
- An AutoSum button has been added to the format menu.
- You can force the user to specify a fiscal period for printing a Statement Group.
- File | Import from ExcelDirect has been added to allow the creation of a SmartSheet financial statement directly from a formatted Excel spreadsheet.
- Sending a statement to Excel using the ExcelDirect button now sends the Excel compatible formulas (=SUM(), etc.) where appropriate.
- When a single row is selected, it can be duplicated in a single action by selecting "Duplicate row" from the right mouse button menu.
- In the Header/Footer of a statement, you can now use "$U" for the User Initials and "$L" for the full user name of the person who printed the statement.
- Importing a financial statement from ACCPAC Plus now creates a SmartSheet and its results more closely mirror the original DOS specification.
- A user restricted to viewing certain departments is now no longer able to create departmental ranges and masks.
- A covered cell now shows the focus if it is selected.
- Expanding and collapsing a SmartSheet would sometimes result in rows that should have been hidden, being displayed.
- Turning on "blank when zero" would sometimes prevent the pop-up (context) menu from displaying the total of selected cells.
Adagio Ledger
8.0D | 2006-05-12 (May '06)
Go to top Release Notes Print This
- You can now send a complete set of financial statements to an Excel workbook.
- View | Customize | Settings also allows you to change the text for a consolidated statement, and what is displayed for a $0.00 value on a statement.
- You can now restrict which departments (or department groups and ranges) a user is permitted to see.
- The functions ACCOUNTGROUP() and ACCOUNTGROUPDEPT() have been added to allow linking between a financial statement and the Account Group tree.
- Alt-up arrow and alt-down arrow are now active to re-order the department print sequence in Edit Report Item from a Statement Group.
- View | Departments | Edit Departmental Range has been added to allow you to directly change both the range and description of a departmental grouping.
- The functions USERINITIAL() and USERNAME() have been added to allow printing of this information on a financial statement.
- The functions ADNOTE("acct-dept" [,"user id"]) and ADCOMMENT("acct-dept") have been added.
- Account Data mnemonics have been added to directly retrieve the provisionally posted figures from a dataset.
- You can now easily determine which accounts have not been referenced on a financial statement.
- Double clicking on a cell in a financial statement now drills down to the details rather than editing the cell contents.
- The QUERYSHEET() function now switches to the specified sheet and recalculates it prior to returning any value.
- Blank departments are now handled correctly.
- Corrections have been made to Expand/Collapse with zero suppress and/or RowFormat where it appeared that rows were lost.
- Improvements have been made to Excel Direct, such as the ability for a single Excel workbook to contain multiple statements.
- You could not open the Financial Report when running on some machines if Adagio Ledger was started from an icon where the password parameter (/p) was in lower case.
- In some cases when Adagio Lanpak was not licensed, although still within the initial 60 day grace period, you received a message saying there were not enough Lanpak licenses available when starting the Financial Reporter.
- Multi-currency reports can now be printed on 8.5x11 paper if your printer supports report scaling.
- The Posting Journal can now printed in summary form when sorted by account.
- Subtotals of Debits and Credits have been added to the Detail Listing.
- Printing batches to file in Word format was not working.
- The Comment field on comment detail lines was truncated on the Posting Journal.
- When printing the Detail Listing sorted first by Department, the finder on Department field now shows only the departments rather than all the account/department pairs.
- Importing of batches no longer requires all other users to be out of batch entry.
- You could not import the net change figures for the 13th period.
- When entering a transaction for a single-currency account defined in your database, the rate description displayed as "Rate Type Deleted".
- Posting to Reallocation accounts created extra zero amount transactions in some cases.
- When the Edit Accounts grid was sorted by Department you got an error saying the record was not found when selecting any record from the finder.
- When the Edit Accounts grid is sorted by Department, the field name changes to Department/Account.
- The error message displayed when you reach the limit of 50 Source Codes in a Source Journal has been corrected.
- The setting of the 'Report missing department errors' option in the Company Profile was not retained in some cases.
- On the Copy Department dialog, if you selected a Retained Earnings account with a department from the finder, the account field displayed both the account and department in the same field.
- On the Copy Department dialog, if you tabbed through the Retained Earnings account field you got an error saying the account was invalid if you had Field Verification on, even though the account was in fact valid.
- You could not retrieve GL batches from Property Manager DOS and possibly other third-party DOS sub-ledger applications that used an integer rather than characters for the fiscal period.
- If you retrieved a sub-ledger batch while another user was consolidating it in the sub-ledger the batch could be retrieved twice in some cases.
- When working in a copy of your Ledger data at year end, it was possible to accidentally retrieve sub-ledger batches from the live data for some third-party products that use the "Designed for Adagio" interface.
- Fixed problems when you provisionally retrieved a batch but did not post it and other batches had also been provisionally posted.
- The Status field always showed as blank the account grid, finder and smart finder. Now shows as 0 for Active and 1 for Inactive and can be searched in the smart finder.
- Multi-currency fields in the Posted Transactions file are now available in Adagio GridView.
- The Company Profile option 'Allow unpost/reverse batch' is now enabled by default when a new dataset is created.
Adagio Ledger
8.0C | 2005-03-21 (Mar '05)
Go to top Release Notes Print This
- 'Active Users' has been added to the Help menu.
- GridView has been added to the Adagio menu.
- Users of Adagio GridView can add views to the Reports menu.
- Multi-currency sample data has been added and is installed in \softrak\alwin\mcsamdata.
- Compatible with Adagio MultiCurrency 8.0B. Adagio Ledger 8.0A and 8.0B were compatible with Adagio MultiCurrency 8.0A only and not higher versions.
- There was an error in the Financial Reporter in some cases if Adagio Ledger was started from a shortcut or icon using lower case values for the /U and /P parameters.
- When the Posting Journal was auto-printed (after posting) and then cleared, the entire journal was cleared, not just the sequence posted.
- When a GL batch created by posting a revaluation in a multi-currency sub-ledger (for example AR) was retrieved and posted in Adagio Ledger, the source amounts for the revaluation transactions were converted from home when they should have remained zero dollars.
- Single-currency batches retrieved into a multi-currency GL from ACCPAC® PlusT Payroll, Job Costing, or Adagio JobCost did not update the source amounts when posted and the source amounts were incorrect on the Detail Listing. There were no integrity errors unless the accounts were switched to multi-currency.
- In a multi-currency database, the Detail Listing incorrectly reported an error if the debits and credits for the current year netted to zero for an account but there were transactions for the account. The report printed correctly in spite of the incorrect error message.
- The Financial Reporter now correctly handles a "blank" department code when generating a financial report.
- A $X command has been added as a parameter for the Header/Footer section and returns the data path of the statement being printed. The header/footer section now supports the following codes:
- $A - Application.
- $C - Company name.
- $D{format} - Print Date{=DATESTRING() specs}.
- $F - Specification file name.
- $R - The sheet name.
- $X - The path to the specification file.
- The order of sheets in a workbook can be changed.
- You can multi-select rows or columns to insert or delete rows or columns.
- New functions have been added:
- =YEARL(date).
- =ToWords(n[,IsCurrency]).
- =FISCAL(1).
- Placing ".ShowAccounts" in cell B1 of a SmartSheet will print the account ranges (only hiding column A prior to print). ".AutoUpdate" and ".RowFormat" have been added to the right button mouse menu when the cursor is positioned over the correct cell.
- Toolbar buttons have been added to change the orientation from portrait to landscape, and autofit selected rows and columns.
- The "Useful text string" formulas on the right mouse button now use the DATESTRING function when inserting fiscal calendar references.
- Find/Next has been improved. Zero suppression now works more reliably. Copy and pasting formulas between worksheets is now supported.
- The .Verify command has been improved and will now report "duplicate" accounts.
- Ctrl-< and Ctrl-> will decrement or increment the fiscal period respectively.
- The account group tree would not display if the username and password were not specified in uppercase. This has been fixed.
- Alt-UpArrow and Alt-DownArrow now moves an item in Statement Groups. Statement Groups can now be printed by selecting "Send to sheet | Statement Groups. The option "All departments" has been added to Statement Group print. Departments added to the ledger will automatically have their statement printed. Statement Group Print allows you to restart page numbering on a specific statement. The starting page number for a statement is specified in File | Header/Footer.
- The designer now supports up to 16 sheets in a workbook.
- The function =QUERYSHEET("sheetname","Cell" [,Fiscal period] [,"Department"]) has been added.
Adagio Ledger
8.0B | 2004-10-05 (Oct '04)
Go to top Release Notes Print This
- Statement Group Print was not always doing a complete "recalculation" before printing This has been fixed.
- Statement Group Print has been enhanced to allow you to Open all or selected statements from within the group.
- Statement Group Print allows you to choose "Previous" as a fiscal period.
- Statement Group Print allows you to select "Consecutive page numbering".
- Excel Direct link in the Financial Reporter sends more formatting information to Excel and handles "frozen" rows and columns.
- ADSELECT has been updated to correct an occasional problem when using wildcards.
- The DEPARTMENT function has been enhanced to return the Department description associated with a wildcard or department range.
- The Departmental Drag and Drop has been modified to make use of the new DEPARTMENT function capability.
- The Department View now allows you to control the order in which the departments are shown.
- A new function called ADTITLE("symbol") has been added which returns the description associated with a symbol.
- New symbols for Prior Period Net Change have been added to the Account Data tree. These symbols are of the form NET_{symbol} and are useful in producing "rolling" statements.
- $C in the Header/Footer section will insert the Company Name from the company profile.
- A new toolbar button has been added to easily switch between portrait and landscape.
- You can edit the [Override] section AFFinRep.Ini file to change the text that is associated with "DEPARTMENT(1)".
- Opening more than 10 Financial Statements at once resulted in the ADGET fields reporting an error.
- You are now able to set the order of the department view in the Financial Reporter.
- Drill down has been improved in the Financial Reporter.
- When printing a Group of financial statements, the page orientation of the individual statements was not correct if the some statements were landscape and others were portrait.
- When launching other modules from the Adagio menu in Adagio Ledger, the session date is passed to the module.
- Added an extension to the Adagio menu to allow Adagio Developer Partners to add their products to the Adagio menu in Adagio Ledger.
- You could not retrieve sub-ledger batches containing foreign currency transactions, where the home amount converted to the same value as the source amount. This could occur for small amounts (typically $0.01 or $0.02).
- GL!SuperSpec.sam has been updated to show the new symbols for Prior Period Net Changes.
- In GL!FunctionExamples.sam, the Header/Footer parameters sheet has been updated to add $C, Company name.
- GL!AllSymbols.SAM has been updated to show the new symbols for Prior Period Net Changes.
- GL!DeptDemo.sam has been updated to use the new DEPARTMENT function to return the FR Department description instead of the GL Department Description.
- GL!RollingIncomeStatementNET.sam has been added to show a rolling monthly Income Statement using the new symbols for Prior Period Net Change.
- The browse button on some dialogs in the Financial Reporter and on the EZTasks dialog did not work on some Windows 98 machines.
- Links to the web from help are now working in all cases.
Adagio Ledger
8.0B | 2004-06-18 (Jun '04)
Go to top Release Notes Print This
- The F2 key now supports Windows standard behavior by editing the line selected on a grid.
- The F6 key now opens the smart finder directly from any grid where you can do a find.
- The date of the last data integrity check is now displayed in the status bar.
- The Windows calculator can added to and launched from the toolbar by selecting 'Calculator button' in File | Options.
- The install now checks to ensure the current user has rights to write to the Adagio program directories.
- You can now define entire groups of financial statements to print without operator intervention.
- A new SmartSheet command ".RowFormat" allows you to apply any formatting desired to generated rows.
- When creating a departmental comparative, you can now create a column that sums just the departments you have selected.
- ".RangeDept" in column A of a Smartsheet will expand the specified account range once for each department in the range, without altering the account range specified.
- "GL!RangeDept" for an example of its use.
- An option has been added to the drag-and-drop format dialog to insert a thin column between numeric columns.
- When turning on "Zero suppress", the Financial Reporter now also hides the zero rows on the financial statement you are viewing, not just on the print preview.
- The Financial button on the toolbar launches the Financial Reporter in maintain mode unless security prevents it.
- Financial statements now automatically have "GL!" added to the name, if it is not specified by the user. The "data selector" will also be added too if necessary.
- File | Import now allows you to retrieve specifications created in Adagio FX.
- Expand, drill down and .Range now respect the department ranges and masks chosen from the departmental drop-down.
- File | Send to sheet | Departments now sends all department ranges and masks to the sheet.
- The department select drop down box now behaves better when there are large numbers of departments to choose from.
- Changing the formatting of a column or row works more logically when the entire column or row is selected.
- In Ledgers with 13 fiscal periods, the drill down to the detail transactions was off by one period. This has been fixed.
- Dragging and dropping single accounts or departments onto a sheet would sometimes result in the Financial Reporter "hanging".
- When expanding a row containing covered cells, the cell coverage was not copied to the generated rows.
- The financial reporter toolbars are better positioned the first time the reporter is opened.
- VSUM() would sometimes not correctly sum the specified range.
- Some issues with page breaks have been resolved in the Financial Reporter.
- The sample data has been enhanced.
- In some cases you were not able to delete Departmental Masks within the Department View of the Financial Reporter.
- When printing the Batch Posting Journal in Account order, the consolidated entries did not print in some cases.
- Entering a negative credit amount by mistake (credits are entered as positive) and then editing it to change it to positive caused the batch to be out of balance.
- The Data Integrity Check in Adagio Ledger 8.0A (2004.02.23) incorrectly reported an error when single character Source Codes were used.
- The 'Visit All Fields' checkbox now stays enabled between entries in all cases.
Adagio Ledger
8.0A | 2004-02-23 (Feb '04)
Go to top Release Notes Print This
- Can now retrieve (not just import) GL batches from third party products that do not use an Adagio database, such as Paymate® Platinum from AK Microsystems.
- The Check System utility now contains just a brief summary, and there is a "View Details" button to see the full details of the scan, which previously could only be seen by examining the log file.
- The Data Integrity Check rebuild function recovers more data from corrupt IDT type files that have File Integrity errors reported.
- The Data Integrity Check can now rebuild the posted transaction file when it is not correctly sorted.
- The Data Integrity Check option 'Report missing department errors' has been added to the Company Profile. When this option is off, errors are not reported for accounts that do not have a department on file.
- The option 'Post invalid entries to error batch' has been added to the Company Profile. When this option is on, you can post a batch even if errors have been reported in the batch listing.
- The initial position of the menu bars in the Financial Reporter is better for the first time it is launched.
- The "look" of the menus and menu bars has been updated in the Financial Reporter.
- Single character department codes now work in the Financial Reporter.
- Print preview magnification settings are remembered between sessions in the Financial Reporter.
- You can now drag individual Account-Department pairs from the Account view onto a Smartsheet.
- Adding or editing accounts while another user was in the Financial Reporter caused an error in some cases.
- The provisional posting journal could not be reprinted in some cases.
- When adding details to a batch entry with 'Auto add batch entry details' on, the details grid was not refreshing in the background in earlier releases of Adagio Ledger 8.0A.
- Inserting a detail inside an entry caused an error in earlier releases of 8.0A in some cases.
- Copying a batch containing period 99 entries now leaves the Period as 99 in the resulting batch rather than changing it to 12.
- The calculator did not work on earlier releases of Adagio Ledger 8.0A.
- Import / export templates created by the user in earlier versions of Adagio Ledger were missing when the database was opened in Adagio Ledger 8.0A in some cases.
Adagio Ledger
8.0A | 2003-12-16 (Dec '03)
Go to top Release Notes Print This
- Now supports multi-currency accounting. The Adagio MultiCurrency module is required.
- Allows you to unpost a batch or generate a reversing batch for batches posted in the current year. An Unpost Journal report is provided.
- You can now insert graphics onto your financial statement for company logos.
- When creating financial statements using drag&drop, an additional option is available to create a departmental comparative.
- New short cut keys have been added in the Financial Reporter to automatically display or hide the various Views.
- Recalculation of financial statements is now faster, and much faster when changing the consolidation or fiscal period.
- When financial statements are created as SmartSheets, Financial Reporter automatically adds an empty column and row to facilitate the insertion of additional rows and columns.
- The following functions in the Financial Reporter now optionally take a third parameter to multiply the result by a value: ADGET(), ADCREDIT(), ADDEBIT(), ADCRONLY(), ADDRONLY(), ADAVERAGE(), ADAVG(), ADMAX(), and ADMIN().
- New fields have been added to the transaction drill down in the Financial Reporter for multi-currency transactions to display the Source Currency Amount, Exchange Rate and Date.
- You can now drag individual account / department pairs from the Account Tree onto a SmartSheet.
- Two new financial statements have been added to the sample data. GL!RollingNet gives the last 12 period net changes for the P&L accounts. GL!BudgetForecast shows the current year posted figures for those periods where amounts exist, otherwise it shows the budget amount.
- Data Integrity Checker memo now shows the date the integrity check was run, the starting and ending time, the path and extension of the data and the user name.
- Data Integrity Checker now writes full details of the integrity check into the log file.
- Source files for all reports in Adagio Ledger are installed in the StandardRP sub-directory rather in the program directory \Softrak\ALWin. You can modify the built-in reports using Crystal Reports for Adagio and place them in \Softrak\ALWin\ModRP. Adagio Ledger will print the modified version of the report from ModRP directory.
- Posting journals can now be printed automatically after posting.
- The options and ranges chosen on report dialogs when you print a report are saved by company and recalled the next time the report is printed.
- File | Options are now saved by workstation rather than globally.
- Smart Finder search is now saved for the next time you use Smart Finder.
- The size and position of the Adagio Ledger main window is now saved when the appropriate options are selected in the File | Options menu.
- Screens now open at a more logical position on dual monitor systems.
- When printing reports to file, you can now choose from four different formats on the print dialog: Excel, HTML, Text, or Word.
- When printing reports to file, the filename defaults to the name of the report rather than the generic filename ADAGIO.TXT.
- A function has been added to allow you to purge Account Notes.
- The Account Notes report prints much faster when a range of notes is selected on a database with a very large number of notes.
- When you start Adagio Ledger, it now checks the "Opportunistic Locking" settings to ensure they are correctly set on the workstation.
- The install and workstation install now check the "Opportunistic Locking" settings to ensure they are correctly set on the workstation.
- When the program is started, it now checks that the Report Tables Drive is correct and up to date.
- The install now checks to be sure the user has installation privileges to local machines running XP, 2000 or NT.
- The Chksys utility (\softrak\system\chksys.exe) scans the list of recently opened databases for each Adagio application and checks that they have the same path to the EZTasks file.
- Default fields in import templates now have finders and drop-down fields where appropriate.
- Added a Print button to allow you to print import / export templates.
- You can now enter account and department numbers in the Financial Reporter without preceding them with a single quote (') and they will be correctly interpreted as strings.
- Copying rows and columns in the Financial Reporter now preserves the formatting in the destination.
- The .Range and .Verify commands in the Financial Reporter now work correctly for ranges that use an asterisk in the department.
- When you click the 'select all' and right-click, you now have the option to unhide, as well as hide columns.
- The SmartSheet expand in the Financial Reporter now works correctly when no accounts are found in the range.
- When creating a SmartSheet using drag and drop, some sub-totals were missing in some cases.
- Single department ranges in the Financial Reporter are now processed properly.
- Accented characters now display properly in the Financial Reporter when retrieved from the General Ledger.
- If a series on non-contiguous accounts were used in a range in the Financial Reporter, and they were not specified in ascending order, or a reference was made to an account above the last account in the Chart, then the accounts did not total properly. This has been fixed, and accounts may be specified in any order.
- Financial Reporter crashed in some cases if you dragged a new account from the Account Tree onto a SmartSheet into a cell containing an account / department.
- New import / export templates default to having no fields selected and the terminology for available and selected fields is clearer.
- The default import / export account templates have been changed to be more generic.
- New sample import files and matching templates have been added to the sample data.
- Import functions write errors to a log file.
- Defaults fields in import templates are now validated during import.
- If you copy your database to another directory, the path to the import file in the default import template is automatically updated to the new path.
- Default file names for import and export templates have changed.
- Option to turn column headings on/off is now allowed for detail only type import templates.
- When importing Detail Only type batches, the 'Entry number' field is no longer required to be in the import file.
- Export Accounts no longer permits you to set the option "Export figures as" when not appropriate.
- When importing accounts with 'Add new records' off, the 'Account type' field is no longer a required field in the import file.
- Import functions now show the field name and other details in error messages even if 'Validate before importing' is not set.
- When importing batches, only the 'String' type worked for date fields. The 'ASCII - YYYYMMDD' and 'Date' types now work.
- If the 'Validate before importing' option was on, and there was an error in the import file, the program closed in some cases.
- The 'Entry number' in 'Detail Only' import files had to be formatted as a string. It now also accepts a number.
- If Account Code is invalid in an import batch, the error message said the Department Code was invalid.
- Import batch files containing comment lines can now be imported.
- Import functions now check for invalid dates in all cases.
- When importing accounts from an import file not containing the currency code field, the currency code was not set to home and was left blank.
- Importing accounts to a departmentalized GL with the 'Validate' option on and where the import file did not include the current balance caused a integrity error.
- When importing a Detail Only type batch that does not contain the "E" record type field, you can now set a default value for the Record Type.
- Import failed in some cases if the last field on a line in the import file was empty quotes.
- In some cases, the progress bar displayed during import batches was not advancing, making it appear that nothing was happening.
- Import now detects an unbalanced import batch when amounts with more than 2 decimal places cause an out of balance condition.
- Import functions now strip leading zeros from account and department fields in the import file.
- In some cases, files containing a comma in a string field could not be imported.
- In some cases, there was an error when importing when string fields contained a comma.
- In some case on XP, 2000 and NT machines, the Auto-workstation install ran when you started the program, even though a workstation install had already been done and was not needed.
- After adding entries to a batch, blank lines appeared in the grid in some cases, and you had to scroll up and down to refresh the grid.
- The number of entries shown in the batch status was one less than the actual number in the Close Year batch if you closed the year for a single department.
- It was possible to accidentally enter an amount with more than 2 decimal places in a batch detail. In some cases this caused the batch to be out of balance in such a way that the posting did not detect the out of balance condition and the unbalanced batch was posted. The posting function performs additional checks to ensure each detail is in balance and that the total debits and credits of all the entries matches the total debit and credits in the batch control total.
- Additional Comments in Account Notes did not print on the Account Notes report unless there were also time stamped notes for the account.
- If the Company Name in the Company Profile contained double quote characters, some reports would not print.
- After printing the Account Notes report, you could not run a Data Integrity Check without exiting the program first.
- Grids flickered in some cases when the cursor was positioned over the vertical slider bar on the grid.
- Accounts with history but no current transactions could be deleted in some cases.
- On slower machines on a network, an Access Violation error occurred in batch entry if you pressed the "Enter" key twice in rapid succession.
- Close Year function now automatically prompts you to print the posting journal for the retained earnings posting if the 'Auto-print posting journal after post' option is set in the Company Profile.
- The Budget and Posted Transactions fields are now available in Adagio GridView by selecting Adagio Ledger 8.0A when creating a view.
Adagio Ledger
6.8B | 2003-01-31 (Jan '03)
Go to top Release Notes Print This
- When the program is started, it now checks that a workstation install has been done and that it is current.
- Reports would not print if the data files had a 1 or 2 character extension.
- Column titles on the Source Journal Profile report were cut off when the shading option was used.
- An Access Violation error occurred in some cases when a hint was displayed on a grid and you tabbed to a button at the side of the grid and pressed the Enter key.
- When an Account Note was edited and the time changed, a note with the new time was created but the original note was not deleted.
- Pennies on the credit column were cut off in the details grid in the Edit Batches function when there were enough details to cause the vertical scroll bar to appear.
- When you deleted an import/export template, it appeared to be deleted but was not actually deleted.
- FixITT could not be run on Adagio Ledger databases converted from ACCPAC Plus General Ledger 7.0 databases.
- 'Enable provisional posting' and 'Enable prior year posting' options in the Company Profile were re-enabled by the program in some cases, even though you had disabled them.
- When importing accounts or batches in 'Detail only' in ASCII Fixed Length format on Windows 98 machines, a message incorrectly indicating that the import file was not the correct format occurred in some cases.
Adagio Ledger
6.8B | 2002-11-20 (Nov '02)
Go to top Release Notes Print This
- Excel Direct feature in Financial Reporter allows you to click a single button to launch Excel® and export a financial statement to a workbook.
- Excel Direct feature added to Smart Finder.
- Adagio Ledger now allows you to run multiple instances on the same workstation.
- Background color of the main window can be set by company in Edit Company Profile.
- Users of Crystal Reports for Adagio can create custom reports and have them appear on the Reports menu in Adagio Ledger.
- Sample data has been expanded and improved.
- A 12 period income statement has been added to the sample data.
- A sample import file for importing accounts has been added to the sample data.
- Two new Formatting Options (Regional Currency and Regional Numbers) that use the Windows Regional Settings have been added to the Financial Reporter.
- List of recently opened databases has been expanded from 10 to 25 entries. Duplicate entries where the characters of the path have a different case are now removed.
- Printing the Posting Journal is much faster when printing a range of sequences on a large database, where the posting journals have not been cleared.
- Multiple users can now print the same report at the same time.
- Data Integrity Checker handles additional types of corruption in the database.
- Crystal Reports Text Object Support library (CRPaig32.DLL) is installed.
- The chksys.exe utility has been enhanced to check for incorrect Opportunistic Locking settings on workstations running NT4.0, W2K or XP.
- Install now checks for Adagio programs in use by other workstations on a network.
- Open batch files have been added to the Adagio Ledger Crystal Reports tables.
- Financial Reporter could not be launched if there were spaces in the path to the database.
- Financial Reporter no longer allows you to make changes to financial specifications when launched from the Print Financial Reports menu choice or from the "Financial" button on the toolbar; you must start the Financial Reporter with the "Maintain Financial Reports" function in the "Maintenance" menu.
- Only one user can open the Financial Reporter to maintain financial reports from the same database.
- If you did a Smart Finder search, then changed the criteria but escaped before doing another search, the next time you invoked Smart Finder, it would show the result from the first search but with the changed criteria.
- When a new department is added, the 'Close dept to' now defaults to the default retained earnings account in the Company Profile.
- Financial Reporter included with Adagio Ledger 6.8B (2002.06.19) stopped running on August 31st, 2002, displaying an error message indicating that you were not running the correct version of Adagio Ledger (when in fact you were).
- Changes to the Help | About dialog have been made.
- Source Code is now remembered for the next entry during a batch entry session.
- Provisional Retrieve batches option now allows you to also provisionally post all open batches at the same time the retrieved batches are provisionally posted.
- When importing from an Excel® spreadsheet, blank cells in the import caused an error instead of resulting in an empty string field.
- When importing a batch, if the Fiscal Period is set to 0 in the import file, the fiscal period for the entry is now assigned based on the date field and the Fiscal Calendar.
- When importing a batch in the 'Detail Only' format, and the 'Delete import file on success' and 'Validate before importing' options where selected, the batch was not imported.
- Help for the Adagio Ledger and the Financial Reporter has been updated and expanded.
- There was an error during posting if another user was in the Financial Report and had drilled down to the transaction level.
- A very large number of errors would overflow the memo field in the Data Integrity Checker.
- The Detail Listing report was missing the last detail of each section when printed in the 'Extended' style.
- An error occurred when printing the Trial Balance in the 'Worksheet' style.
- Adagio Ledger did not successfully convert an ACCPAC Plus General Ledger 7.0A database if there were no archived batches.
- A database could not be opened in Adagio Ledger if the F9T financial reporter was already open on the same database.
- Overlapping fields in the Properties window for Account Groups have been fixed in the Financial Reporter.
- Drilldown for ADCREDIT now works in all cases in the Financial Reporter.
- Hide/Unhide of rows/columns is now recognized as a change in the Financial Reporter and the Save Icon is active.
- In some cases, the Provisional Posting Journal could not be printed.
- There was an error in the posting journal generated by Close Year if the Posting Format option in an account was set to post Consolidated.
- Export format for exporting reports to file has been changed from Text to Microsoft® Word, as the result is superior in Word.
Adagio Ledger
6.8B | 2002-06-19 (Jun '02)
Go to top Release Notes Print This
- Departmental print function has been added to the File menu in the Financial Reporter.
- Major enhancements have been made to drag and drop from the Group view in the Financial Reporter.
- SmartSheetT technology has been added to implement range processing in the Financial Reporter. ".Range" lines automatically pick up new accounts added to the Chart of Accounts.
- Overall performance has been significantly improved for copy, insert and recalculate.
- Insert with multiple columns or rows selected results in the insertion of that many columns or rows.
- Blank when zero button added to toolbar. See addendum.
- New sample financial statements have been added to the sample data. GL!BalanceSheet.SAM, GL!IncomeStatement.SAM, and GL!TrialBalanceWorksheet.SAM are examples of SmartSheet.
- Many usability enhancements have been made in the Financial Reporter, including more familiar response to single and double clicks on cells. The default directory for Open is now the data directory for the current Ledger. Multi-select is active on insert, delete and hide. Insert of a row or column no longer results in the addition of an extra row or column.
- DATESTRING() and CONCATENATE() functions have been added to format dates and join strings respectively.
- Reset has been added to the View | Customize | Views menu in the Financial Reporter to deal with the eventuality of financial reporter windows being moved from the screen view.
- You can now type the account ranges directly into the Properties dialog for a Range displayed upon right mouse click.
- You can have a page break automatically generated for a "drag and drop" view.
- Phantom page break problems have been solved.
- If you export a financial statement to Excel with rows suppressed on zero, these rows were previously exported. This is no longer the case.
- The Canada Customs and Revenue Agency (CCRA) GIFI short form financial statement is now included in the sample data. See GL!GifiShort.SAM.
- You can multi-select cells and then right mouse click to show the sum of the selected cells in the Financial Reporter.
- Added the ability to hide a column/row when printing a financial report while still leaving the column/row visible in the financial reporter.
- Color is user selectable for 'Page breaks' and 'Hide when printed' indicators.
- A function has been added to check that all accounts in a user-specified range are referenced in the statement. To use, right click on a blank cell in column A and select 'Make .Verify', or type '.Verify' directly into the cell. Enter the range in column B on the same row.
- The drop down portion of the departmental combo box has been expanded to show the department description field.
- Adagio Ledger will now automatically convert an ACCPAC® PlusT General Ledger 7.0 database to a compatible format.
- Notes have been added to accounts.
- The Account grid can now be displayed in either account or department order.
- Enhancements have been made in the Data Integrity Checker.
- When you delete a department, Adagio Ledger will now delete all the accounts associated with that department.
- The description field in the batch entry form has been widened to allow display of all 30 characters without scrolling in the field.
- Header / detail format batches can now be imported.
- Validate on import batches caused the program to crash. Importing a batch with blank entry number fields caused the program to crash.
- Retrieved batches can now be copied if 'Edit retrieved entries' is set in the company profile.
- The Retrieve sub-ledger batch function now detects problems with the currency codes.
- If another application installed the Crystal Reports 8.5 print engine, there were intermittent problems printing reports on some machines.
Adagio Ledger
6.8A | 2001-11-06 (Nov '01)
Go to top Release Notes Print This
- Sample import batch files and associated import templates have been included with the sample data.
- 6.8A (20010911) release fixed a problem with reallocation accounts. However, there was still a problem in some cases where an account had several reallocation accounts with percentages to hundredths of a percent. This has been corrected.
- An error occurred when printing reports to file on Windows 2000 stations. This has been corrected.
Adagio Ledger
6.8A | 2001-09-11 (Sep '01)
Go to top Release Notes Print This
- Number of reallocation accounts was incorrectly limited and in some cases an error was displayed indicating 100% of the account was not allocated. This has been corrected.
- During importing of batches on Windows NT/2000, an error 'Invalid data for Entry number' was displayed and the batch could not been imported. This has been corrected for creation of new databases. Existing databases can be fixed by deleting the template files from the database, or by changing the data type of Entry Number from Number to String.
- Smart Finder (F6) in Find function in batch entry was not working and displayed an error. This has been corrected.
Adagio Ledger
6.8A | 2001-07-09 (Jul '01)
Go to top Release Notes Print This
- Drill Down has been added to the Financial Reporter.
- A new function called RngMerge has been added. It does a concatenate between commas.
- In some cases, drop-down menus in the Financial Reporter did not work on NT and Windows 2000 in Adagio Ledger 6.8A (010514). This has been corrected.
- In some cases, the Batch Status report showed the wrong total for the batch count in the summary if there were batches posted to prior year. This has been corrected.
- In some cases, the error message "Batch number is out of range" was incorrectly displayed when the batch range was edited in the print dialog after choosing the Listing button on the Batches screen. This has been corrected.
Adagio Ledger
6.8A | 2001-05-14 (May '01)
Go to top Release Notes Print This
- Adagio Ledger now uses the Adagio Data Source (ADS) to interface to the database rather than the Softline Database Interface (DBI).
- Adagio Ledger now uses Adagio Lanpaks to increase the number of licenses available to access the database in multi-user installations rather than the Softline Multi-User Packs (MUPs).
- Menu level security has been added.
- A Backup feature has been added to the File menu.
- The results list for the Smart Finder is now persistent.
- The results list from the Smart Finder can now be printed.
- An Adagio menu choice has been added to allow you to start other Adagio applications directly from within Adagio Ledger.
- A problem posting batches when running the Adagio Ledger programs on some Windows 2000 machines has been corrected. The source of the problem was the DBI. This is not a problem in ADS.
- A sub-ledger batch could not be retrieved if the first 2 letters of the batch resource file (xxBRSCGL) were not capital letters. This has been corrected.
- Running the Close Year function left the database locked, preventing you from using certain functions until the program was closed and the database reopened. This has been corrected.
- An error message was displayed by the "Change Fiscal Year" function in some cases when there was no error. This has been corrected.
- A warning message is now displayed if you accidentally try to run the Change Fiscal Year function a second time (before posting a batch in the new fiscal year).
- An archived batch could not be restored to batch 1. This has been corrected.
- A problem occurred when importing accounts if the import file did not include a Department Code field (even if departments were not used). This has been corrected.
- When first setting up reallocation on an account, the Edit and Cancel buttons are no longer active until at least one detail has been entered. Clicking these buttons before there was at least one detail line caused errors. This has been corrected.
- In some cases when saving an account where reallocation details used more than 2 decimal places, the error "100% of the account must be allocated" was displayed when in fact the account had been fully allocated. This has been corrected.
- A problem inserting the Department from the smart finder on some screens has been corrected.
- The Data Integrity Check now checks for accounts with invalid account type.
- The 'Posted Prior Year' figure in the summary statistics on the Batch Status report was always zero. This has been corrected.
- Accounts were missing in the Trial Balance if the opening balance was not zero, the current balance was zero and there was a provisional posting to the account. This has been corrected.
- The Financial Reporter can now export to HTML.
- The Financial Reporter can now export to Excel.
- You are now prevented from opening a different database while the Financial Reporter is running.
- Defining a range such as Account-Department:Department (4000-100:200) or Account:Account-Department (4000:5000-100) in the Financial Reporter now works correctly. Previously the values returned were unpredictable.
- In rare situations, some cells in the Financial Reporter intermittently did not recalculate correctly. This has been corrected.
Adagio Ledger
6.6A | 2000-11-09 (Nov '00)
Go to top Release Notes Print This
- New sample Financial Reporter spec file demonstrating "side-by-side" departmental statements added to sample data.
- Financial Reporter zero suppression now only suppresses accounts with zero balances, not sub-totals with zero balances.
- Multi-select copy, move, and delete of batches or batch entries now works properly.
- Adding new entries to batches while another entry is open is no longer a problem.
- Error no longer occurs when editing multiple entries from multiple batches at the same time.
- Sub-ledger batches with gaps in entry numbering no longer cause problems upon retrieval to AL.
- Batches from sub-ledgers using a different home currency than AL can now be retrieved into AL.
- Batch status report no longer shows posting sequence for provisional posted batches; now correctly displays error count instead.
- Users created without a password can now long into the AL database.
- When creating AL data, currency code is now set to Default Currency Code instead of "DOS".
- Problems with new users logging in have been corrected.
- Data Integrity Checker now reports an error if a batch file is physically missing from database but shows in batch status.
- In Edit Accounts, Department finder now shows a list of departments correctly.
- You can no longer delete accounts with zero balances if they have current year transactions.
- Using Edit Accounts to enter reallocation details for an account no longer results in data corruption or errors.
- If using all four command line parameters, the path for retrieving GL transactions was incorrect. This has been fixed.
Adagio Ledger
6.6A | 2000-03-03 (Mar '00)
Go to top Release Notes Print This
- All reports in Adagio Ledger have been extensively enhanced, and a Report Options function has been added.
- Print departments has additional range and sort selections.
- Maintain Recurring Batches function has been extensively updated for ease of use.
- You can now select batches to archive directly from the batch list.
- Print batches now includes an option to page break on change of batch.
- Edit Source Journals function has been extensively updated for ease of use.
- When copying or moving batches, you now have an option to reverse debits and credits in the entries of the target batch.
- Additional information is shown on the Edit Accounts screen, including the net posted amount for the current year periods.
- Help is now context sensitive.
- When importing an ACCPAC® PlusT G/L specification that used \ACCT and \DESC on same line, the field values were incorrect. This has been corrected.
- In some cases, the year on financial statements would print as "100" instead of "00". This has been corrected.
- When starting the Financial Reporter after "Float In Main Window" had been used in one of the views during a previous session, an illegal operation error would sometimes occur. This has been corrected.
- After printing and purging the Batch Status report, the report dialog did not close. This has been corrected, and a message indicating completion is now displayed.
- If a batch with deleted entries was archived, any recurring batch created from the archived batch could lose entries during post. You would also get an error if you tried to add an entry to the batch after it was restored. This has been corrected.
- If you pressed ENTER after changing fields on the batch entry screen without tabbing out of the field first, the updated field was not saved. This has been corrected.
- After reaching the end of the chart of accounts using the Next button when viewing Transactions or Budget/History in Display Accounts, the Previous button would not work. This has been corrected.
- The Post choice in the right mouse button pop-up menu is now working.
- Batch status was incorrectly set to 'Printed' when batches were included in the range to print but were excluded from printing by some other range selection. This has been corrected.
- Accounts were not printing on the Trial balance in some cases if they only had provisionally posted amounts. This made the report appear to be out of balance. This has been corrected.
Adagio Ledger
6.5A | 2000-01-18 (Jan '00)
Go to top Release Notes Print This
- Data Integrity Checker was incorrectly reporting the error "Total credits do not equal total debits" after importing accounts in some cases. This has been corrected.
- Data Integrity Checker was incorrectly reporting errors in databases that had previously been converted from older versions of General Ledger. This has been corrected.
- Problems importing/exporting accounts have been corrected.
- Problems importing batches have been corrected.
- Problem where reallocation details did not sum correctly when editing reallocation accounts has been corrected.
- Printing a GL Listing when there are no transactions caused an error. This has been corrected.
- The department finder in Edit Account now shows the available departments instead of the Accounts/Departments already on file.
- A problem renaming batches has been corrected.
- Problems on the GL Listing in extended format have been corrected.
- After copying/moving batch entries while other batches were open, the batch grid was not correctly refreshed. This has been corrected.
- Retrieving sub-ledger batches with the option set to assign entries to a specific period retrieves the sub-ledger prefix instead of the period resulting in an error such as "AP is not a valid integer value". This has been corrected.
- Problem retrieving batches with more than 999 entries has been corrected.
- Reports would not print if the data had a 1 or 2 character extension. This has been corrected.
- When creating a recurring batch, the period is now defaulted based on the date you select.
- Problem setting the date while logging in when outside the current fiscal year has been corrected.
- Period range selection in Print Source Journals is now working correctly.
- A "memory full" error when printing the Chart of Accounts in Budget/History format has been corrected.
Adagio Ledger
6.5A | 1999-10-14 (Oct '99)
Go to top Print This
- Initial release.