Enhancements & Revisions

Adagio SalesAnalysis 9.0A

March 23, 2011

The changes and improvements to Adagio SalesAnalysis 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.

Generic New Features

A charting subsystem has been added to Adagio SalesAnalysis to help analyze trends from sales transactions or statistics. Charts can be displayed, printed or exported. Charts can be automatically opened when SalesAnalysis is launched. Pie, Bar and Trend Line charts can be defined and the definitions imported and exported. Chart security is available by Group membership.
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.
You can now specify a desktop background color, image and/or text constant to display on the Adagio desktop. Use this feature to display your company logo. Use the text strings to make the company name prominent on the desktop. Any JPG or other graphic image can be centered or stretched to fit on the main program desktop. These settings are made on the Appearance tab in the new User Preferences function.
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 select each item in turn through the found list. Turn it off if you usually want to search by 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. When the smart finder Grid is opened, you can toggle the focus between the Grid and the selection criteria by pressing F6.
The option 'Alphabetically sorted field list' has been added (in the User Preferences function). Turn this option on if you want field lists in the Column Editor and Filters fields sorted alphabetically.
Column Editor settings are now saved by grid by user by database.
Added the option 'Exclude Ranges' to Report Options (now in the new User Preferences function). If 'Remember report options' is on and 'Exclude Ranges' is also on, field ranges in general (including date ranges) are not remembered but other report settings are remembered.
Optional fields have been added to SA transactions records. Added Header Optional Field Titles and Detail Option Field Titles on the Options tab in the Company Profile. Optional fields can be shown in Online Inquiries, Edit Sales Data, GridView and Crystal Reports for Adagio. Optional field values are retrieved from Adagio Invoices and OrderEntry. You can specify which Optional fields are sent to SA from Invoices and OrderEntry in the Company Profile of those modules. The Scan Sales Data function also supports optional fields.
Header and Detail optional fields to send to SalesAnalysis have been added to the SA Opt. Fields tab added to the Company Profile in Adagio Invoices which appears when SA 9.0A data is present. Header optional fields to send to SalesAnalysis have been added to the SA Interface tab added to the Company Profile in OrderEntry which appears when SA 9.0A data is present.
Optional Fields have been significantly improved with the addition of edit controls to validate optional field entry within and across an Adagio module(s). Users can control whether a text field, combo box or Finder field is used to validate optional field entries. Data can be restricted as to length and case. Fields shared between modules (customer and item optional fields) will automatically inherit the same validation rules. Module by module control of field entry and validation is available.
You now have explicit control of how a document record is displayed in the Edit Sales Data grid. File | Edit Styles allows the creation of named styles with a colored background and font color. User control of font attributes bold and italic are also supported. Named styles may be assigned to individual transactions by editing a record or importing the style you wish to use. The style controls the display of a transaction in the grid. For example, use this feature to highlight transactions where the invoice has not been paid. Adagio Styles are shared globally between all Adagio modules and company datasets. Display Styles settings, Manual and Automatic, have been added to the edit order screen. The manual style has been added to the import orders function.
Display just the records you need in Edit Sales Data grid. User defined filters can select and instantly display transactions that meet specific criteria in a user specified sequence. Column settings are saved by grid for each filter by user by database. Up to 5 selection rules can be defined per filter. Compare data elements to a constant value (Total Invoice > $10,000), another data element (Amount <= Cost) or, in the case of dates, to a “floating date range” (Date is This Week). Grid Filters also allow you sort grids by multiple fields. Grid Filters may be public or private. Filters are refreshed automatically when transactions are retrieved or scanned, and when a Data Integrity Check is performed (including in DataCare) or on demand. Styles can be automatically applied to records that belong to a specific group, making it easy to identify important records according to criteria that you choose. The Display Style may also be set manually in the document. The Apply Styles function in the Maintenance menu allows you to apply multiple filter styles simultaneously. Filters can be toggled on/off on the grids.
Data Integrity Check (DIC) will automatically reset all filter Styles used based on the Style priority set in the transaction filter. For transactions that no longer meet any filter criteria, any filter style previously assigned to them is removed and reset to the Standard style. No messages or warnings are given in DIC.
Styles and Grid Filters for customer and item grids are supported in the Customer and Item inquiry functions when Adagio Receivables is 9.0A or higher and Adagio Inventory is 8.1C or higher.
Item Number segments are available as separate fields in grids, finder, smart finder and GridView.
Added an Excel Direct button to the Edit Sales Data function. Use the 'Enable SF Export' option in Edit User to enable or disable the Excel Direct button.
New toolbar icons provide a cleaner look and differentiate this new version visually.
Grids, filters, and finders now show the lookup values instead of the raw data values for typed fields. For example in SA Transactions: Type shows Line, Misc. Charge and Tax instead of L, M or T; RecordSource shows OrderEntry, Invoices, Imported, etc. instead of OE, QI and IP; and ItemSource shows Inventory, Invoices, Tax, etc. instead of IC, QI, or TX. Lookup values are also shown for customers and items.
The performance of standard reports has been improved.

Edit and View functions
The View Customer function in SalesAnalysis supports the option to sort transactions and notes added in Receivables 9.0B.
Listing button added on the Group Setup window prints all options or enabled options only for a range of groups.
Display Styles settings, Manual and Automatic, have been added to the edit sales data screen. The manual style has been added to the import transactions function.
Edit Data supports new the fields in transactions, including Document Number, Customer and Item Report Group, Optional Fields, Original Invoice, PO Number and Display styles.
The Edit Sales Data function remembers (globally) the choice for sorting the grid.

Transactions file
Added a 12 character Document Number field to transactions, allowing for the full 12 character document number from Adagio Invoices and in future versions of OrderEntry to be recorded in SalesAnalysis. The document number fields (invoice and credit note number) were sent to the Reference field in SalesAnalysis in previous versions. The Reference field was only 8 characters in SalesAnalysis, causing the document number from Invoices to be truncated in some cases.
The Reference field has been increased from 8 to 12 characters and is now populated from the Reference field in Adagio Invoices and OrderEntry rather than being set to the invoice/credit note number.
The Order Number field has been increased from 8 to 12 characters to support a future increase in size of the order number field in OE.
QI Item field added to accommodate "Composite View" capability in GridView 9.0C and higher.
Added Item Description field to transactions. Turn on the option 'Use Desc. in SRTRANS' in the Company Profile to use this field. It can be used in the Online Inquiry function, Edit Data, GridView and Crystal Reports for Adagio. The conversion to 9.0A sets it to the item description saved by SA the last time the item was on a document retrieved into SA (i.e. from SA's Item Description file).
Added Original Invoice field from credit notes to transactions. Conversion sets this new field to blank.
Added PO Number field to transactions. It is populated on retrieve and scan from customer's PO Number field in Adagio Invoices. It will be used in future versions of OrderEntry. For the current version of OE users typically enter the customer's purchase order number in the Reference field on the order. The conversion sets this new field to blank.
Added JobCost Job, Phase and Category fields to the transaction file. They are populated by the retrieve and from Adagio Invoices functions. They can be shown in on-line inquiries and the Edit Sales Data function. The conversion sets these fields to blanks.
Add Customer and Item Report Groups fields to trans file, and Inquires and Edit. The conversion sets these fields to blanks.

On-line Inquiry
Added 'Use desc. in SRTRANS' option to the Options tab in the Company Profile. If set, online inquiries in SA will use the new item description field in the transaction file. It is set to the actual description from the OE document (which could have been modified from the default IC item description during entry), rather than the item description saved by SA, which comes from OE the last time the item was on a document retrieved into OE. Previous versions of OE did the latter.
The Date Paid indicator field is now available in On-line Inquiry function allowing you to create inquiries showing transactions for which invoices have or have not been paid.
On-line Inquiry supports new fields in transactions: Reference, cust and item report group, manual and auto style, Original Invoice, PO Number.

Maintenance functions / Retrieve and Scan Sales Data
The OrderEntry transaction batch file for SA is now created and updated by Day End in OE, rather than requiring you to print and clear the OE shipment and credit note audit lists before you can retrieve OE transactions into SA. This feature requires OrderEntry 8.1D or higher.
Added the 'Skip 0 qty/amts lines on Invoices retrieve?' option to the Options tab in the Company Profile. If set, SA does not retrieve detail lines that have zero quantity, amount and cost from Adagio Invoices. Use this option if you do not want Adagio Invoices items that that are text only (no numeric fields) to be retrieved or scanned into SA.
The Retrieve Sales Data and Scan Sales Data functions support the new fields in transactions when retrieving from Adagio Invoices and OrderEntry support.
Added 'Update desc. from OrderEntry' and 'Update desc. from Invoices' functions in the Utilities menu. These functions are enabled when you turn on the option 'Use Desc. in SRTRANS' in the Company Profile to use the Item Description field added to transactions.

Archive and Restore
Archive and Restore functions support all new fields in SA transactions. Note: not all fields can be used as ranges in Archive/Purge/Restore templates but all new fields are archived and restored.

Import and Export
Import/Export supports Excel® 2007 format (.xlsx) allowing for more than 65,535 rows in import and export files. Spreadsheets no longer need to be re-saved in Excel 97-2003 format (.xls) before they can be imported.
Import / Export transactions functions support new fields in transactions: Reference, Customer Report Group, Item Report Group, Manual style, Original Invoice, PO Number, and Item Description.

Install Changes
This version moves toward our goal of a more Windows 7 friendly environment for installation. If you are installing to a mapped network drive that is normally accessible, but you cannot see it during the install when attempting to select a drive or folder, you can now install by browsing to the correct folder using the Universal Naming Convention (UNC), for example myserveraccounting. This avoids having to adjust the User Account Control settings, which requires you to restart your computer and temporarily grant Administrative privileges to the user if they are not an administrator.
This version simplifies installation by removing any consideration of the location of the Report Tables Drive (RTD) by the install and program in virtually all cases. Therefore the install no longer prompts for the RTD.
The install writes to the master install log file "AdagioMasterInstall.log" in the softraksystem folder. An entry is written to this log when any full, upgrade or SP for any Adagio module (with a release date of March 2011 or later) is installed. It shows the version installed and the version being replaced, the name of the Windows user who did the install and the rights for that user. An entry is also written to the log when an updated version of the Adagio Data Source (ADS) is installed, showing the version installed and the version being replaced. This log can be used to quickly determine the install history for all Adagio programs.
When you select the 'Backup Files' option during an install, the replaced files are now saved in a subfolder named YYYYMMDD in the BACKUP folder, under the programs destination folder (rather than the BACKUP folder itself, where extensions need to be changed to .001, .002, etc. when there are multiple versions of the same file).
The install includes an option allowing you to skip creating entries under Windows Start for cases where you will be manually creating an icon for the user to start Adagio and do not want them starting from Windows Start. During the install, uncheck the option 'Start Menu programs'. This avoids having to delete or change the Windows Start entry that would have been created.
The install no longer checks the Opportunistic Locking setting (Oplocks) on the workstation.
The Opportunistic Locking setting (Oplocks) on the workstation is no longer checked when the program is started.
The System Status function in the Help menu (chksys.exe) no longer prompts you to disable Oplocks. It displays the current Oplocks setting and allows you to change it. The 'Check R/W Status', 'Check Specific Folder' function now supports UNC browse, whereas before you would have had to turn UAC off to use it.
SetServerForAdagio and SetReportsTablesDrive utilities have been updated. The latter should virtually never be needed at an Adagio site once any Adagio module dated March 2011 or later has been installed.
Problems Fixed
If 'Purge from Current after days' was set to 0 days in OrderEntry the Ship To code was blank for invoices retrieved into SalesAnalysis.
The Territory field contained only 2 of 6 characters when transactions when retrieved from OrderEntry and you were using Receivables 9.0A or higher.
Fixed problems that may occur in Online Inquiries if the Adagio Data Sources (ADS) is version 1.12.54.2681 or 1.12.54.2689. These versions of ADS were installed by Adagio Receivables 9.0B (2010.09.10) and GridView 9.0C (2010.10.14). You can check the version of ADS in the Help | About function from any Adagio module.
Date fields are now shown (rather than being blank) on the summary in Online Inquiry if the Prefixed Document number has been selected to summarize, as this guarantees the date field will be unique for each document. Otherwise asterisks are shown in the date on the summary.
When you sent results from an Online Inquiry to Excel, if the Customer field was an exported column, that column heading in Excel wrapped incorrectly.
When exporting transactions and selecting to export only Items, the very last line of the export was a misc. charge or tax detail.
Corrected calculation of certain fields that are not included in the import file when importing transactions to a multi-currency database.
On a multi-currency database, if your import file included the Price List but not the Base Price and the item was not in the alternate price list, the Base Price in source currency is now set to zero rather than the home currency price from the master item.
A user who does not have access to Item Inquiry with Sales/Costs will have the item costing fields automatically hidden so that access to the column editor may be granted without compromising the confidentiality of these figures.
A user that does not have access to 'Enable SF Export' could still see the Excel Direct button on both the Summary and Detail screens in the Online Inquiry.