Highlights of V5.6 – New Features and Enhancements
Arbutus SmartApps is a free add-on for supported users of Analyzer Version 5.6 that is a powerful suite of pre-built audit tests covering five key areas: General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, and Inventory.
The 57 SmartApps have straightforward dialog boxes that make it easy for all levels of users to quickly achieve meaningful audit analysis and reporting.
As shown below, to make your SmartApps available through the ‘Applications’ menu, simply place them in a shared folder.
Every Arbutus SmartApp is fully interactive. All required parameters are entered by the user when the SmartApp is run.
2. New SQL Command
In Analyzer V5.6, support for SQL has been extended with the new SQL command. This allows you to embed SQL Select queries directly into your Arbutus procedures or scripts. If you already know and use SQL, you can take advantage of the capabilities offered by SQL and run any queries from Arbutus, to get the benefits of both worlds.
If you receive SQL queries as part of your audit validation process, you can now avoid the time-consuming, error-prone challenge of translating the queries, and instead, just run them from Arbutus. In version 5.6, you can now confidently request and receive SQL from any part of your organization.
Screenshot of the new SQL command in Analyzer:
Watch the ArbutusAudit tutorial video, The SQL Command in Arbutus Analyzer Audit Software, on YouTube:
3. Monitoring/Scheduling Admin Tool
The new Monitoring/Scheduling Admin tool, which, when used with the Arbutus Enterprise Edition, supports viewing and managing all scheduled scripts for individuals, teams, and departments.
4. Enhanced Protect Program
- The Protect program is no longer a separate application. It can now be used from within Analyzer to prevent unwanted viewing and/or edits of your scripts
- The new Protect dialog in the Tools menu enables individual scripts to be protected using a specified key so they can be run, but not viewed or edited. This is useful for those building applications for other users or clients to ensure that the work is protected and cannot be unintentionally or erroneously modified
Watch the ArbutusAudit tutorial video, The Protect Command in Arbutus Analyzer Audit Software, on YouTube:
5. ALL LIKE and ALL EXCEPT
Commands that use the ALL parameter now include EXCEPT and LIKE to enable wildcard exceptions or matching. For example: Extract ALL LIKE “budget*” will extract just the field names beginning with “budget”, while DELETE ALL LIKE “V_*” can be used to delete all temporary variables. Similarly, DELETE ALL EXCEPT “_*” can be used to delete all variables except permanent variables.
6. Improved PDF Converter
The Arbutus PDF converter has been enhanced to provide even better conversion accuracy and reliability.
7. RECOFFSET() Optimized
The RECOFFSET() function has been optimized to improve speed performance. RECOFFSET() in Arbutus is now hundreds, or even thousands, of times faster than in competing audit software products.
8. Enhanced Integration with Windows Explorer
You can now drag-and-drop any data file from Windows Explorer into Analyzer to automatically start the Data Definition Wizard. Analyzer will access the file and launch the Wizard with the correct File Format selected.
9. Unicode Improvements
Analyzer audit software now supports Unicode print, numeric, and date data better than before, including UTF-8. In addition, exports to spreadsheets and other sources automatically use the Unicode source data.
10. Other Improvements and Enhancements
- GOMONTH() function calculates the date, in months, from the specified date
- TODAY() function returns today’s date, which is particularly useful for real-time applications
- NOW() function returns the date and time right now, also useful for real-time applications
DATA DEFINITION WIZARD
- The Wizard now features enhanced definition capabilities to better distinguish true numbers from number-coded data that should be treated as character data
- The SAP private file format is once again supported, offering yet another means of accessing SAP data
- The EXPORT command has been enhanced in three significant ways:
- You can now use the Append option when exporting via ODBC to relational tables
- When exporting columns containing UNICODE data (UTF 16 only) to Excel, Access, or via ODBC, the data will be exported as Unicode and not converted to ASCII
- You can now export fields longer than 255 to Excel (the maximum field length is now set to 32,760 bytes)
- NOTIFY now supports automatic fail-over to alternate mail servers, should your primary email server be unavailable. In conjunction with this feature, the command now displays any failed connections in the log
- The SET FATAL NEXT command allows you to test for critical script errors, but then continue execution, rather than return to the calling script
- DISPLAY PRIMARY has been enhanced to output lengths and decimal places for computed fields
- SET SOURCE allows the user to specify the default data source to use when issuing SQL commands. The following example sets the default local data sources as being the SQL Server DSN on the machine:
SET SOURCE “LOCAL,SQL Server”
SQL SELECT Orders.CustomerID, Orders.OrderID, Customers.CustomerID, Customers.CompanyName FROM Orders LEFT JOIN Customers ON Customers.CustomerID=Orders.CustomerID ORDER BY Customers.CompanyName;
- DISPLAY SOURCE displays the default database that was established if the user issued the SET SOURCE command
PROCEDURE EDITING OPTIONS
- The Procedure Editor now features unlimited undo options for easier corrections of typos or deletions. Use Edit/Undo from the main menu, or use CTRL-Z. Unlimited undo actions can be undertaken sequentially in reverse step mode from the last (most recent) edit to the first edit
- The Overview now uniquely identifies shared folders of different types (Personal, Team, or Enterprise)
- The new optional VariablesWindow will display the current values of all existing variables. In addition to showing the values, the window automatically highlights any values that have changed since the last command, so you can be sure to see the changes. The Variables Window appears at the bottom of the Overview window and is re-sizable; it can be opened in two ways:
- Automatically opens when using step-mode in scripts
- Click “Show/Hide Variables Window” option in the Windows menu
- The Variables Window is particularly useful when running scripts in Step Mode to assess the changing values of all variables at each step in the script. The Variables Window also allows constant monitoring of variable values. Whenever a value changes, it is highlighted, for easy identification
- Field picker speed search allows you to quickly locate the required field, particularly with long field lists.
- Simply type any portion of the desired field name (or title) into the new “Search” text box to locate the field. Only fields that contain the search string will be shown
- The View now supports horizontal scrolling via mouse, if your mouse supports this