Enhancements & Revisions

Adagio FX 8.0D

March 14, 2005

Compatible with QuickBooks 2005 and Simply Accounting Pro 2005. Does not support 7 or 8 digit account numbers at this time.
You can now delete a department from a combined ledger.
New options have been added to the retrieve.
Retrieving a new dataset from Adagio or ACCPAC Plus used to reset the account groups.
Budgets are now properly retrieved in QuickBooks datasets where the fiscal calendar is not January - December.
You can now retrieve transactions from QuickBooks or Simply Accounting into a 13 period fiscal calendar (Pro Version only).
The Financial Reporter now correctly handles a "blank" department code.
A $X command has been added as a parameter for the Header/Footer section and returns the data path of the statement being printed. The header/footer section now supports the following codes:.

$A - Application.

$C - Company name.

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

$F - Specification file name.

$R - The sheet name.

$X - The path to the specification file.
The order of sheets in a workbook can be changed.
You can multi-select rows or columns to insert or delete rows or columns.
New functions have been added.

=YEARL(date).

=ToWords(n[,IsCurrency]).

=FISCAL(1).

=QuerySheet("Sheet","Cell"[,Fiscal],"Dept"]).
Placing ".ShowAccounts" in cell B1 of a SmartSheet will print the account ranges (only hiding column A prior to print).
".AutoUpdate" and ".RowFormat" have been added to the right button mouse menu when the cursor is positioned over the correct cell.
Toolbar buttons have been added to change the orientation from portrait to landscape, and autofit selected rows and columns.
The "Useful text string" formulas on the right mouse button now use the DATESTRING function when inserting fiscal calendar references.
Find/Next has been improved. Zero suppression now works more reliably. Copy and pasting formulas between worksheets is now supported.
The .Verify command has been improved and will now report "duplicate" accounts.
Ctrl-< and Ctrl-> will decrement or increment the fiscal period respectively.
The account group tree would not display if the username and password were not specified in uppercase.
Alt-UpArrow and Alt-DownArrow now moves an item in Statement Groups.Statement Groups can now be printed by selecting "Send to sheet | Statement Groups. The option "All departments" has been added to Statement Group print. Departments added to the ledger will automatically have their statement printed. Statement Group Print allows you to restart page numbering on a specific statement. Statement Groups are only available in the Pro version..
PRO ONLY: The designer now supports up to 16 sheets in a workbook.
PRO ONLY: =QUERYSHEET("sheetname","Cell" [,Fiscal period] [,"Department"]) has been added.