Enhancements & Revisions

Adagio Payables 8.1C

July 29, 2011

New Features

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.

Supports 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). Statements print to a separate, configurable folder. Fields can be embedded to establish the file and folder names (User, Session Date, System Date, Time). 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.

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.

Grids, filters, and finders now show the lookup values instead of the raw data values for typed fields. For example in vendor grids the Vendor Status shows Normal or On hold, and Aging Type shows Document date or Due date, instead of 0 or 1.

Account Styles and Filters were added in Ledger 9.0D. They are now supported in GL account finder grids in Payables.

Import Manual Checks can auto-generate the Cash Invoice Number so unique numbers do not need to be generated externally and included in the import file. To use this feature, add the 'Hdr-Cash Invoice Number' field in the Field Defaults tab, where the Value will be set to 'Auto-generated'. The Cash Invoice Number will be set to "Batch Number - Entry Number".

In Import Manual Checks if the 'Hdr-Print Check?' field is included in the template and set to True in the default fields the Check Number is no longer a required field in the import and will be generated when checks are printed from the resulting batch.

Added check specification code 'G07 G/L Acct Description' for printing on the check advice. This is useful if the description contains information such as a person's name.

Added the option 'One detail per entry' to Import Manual Checks. It can be used when the 'Header fields on each record?' option is on. Use it when an import file may contain multiple checks in a row for the same vendor. In previous versions the checks would be consolidated into a single check entry in this case. Note that if this option is used then checks with multiple distributions cannot be imported as they would be split into separate check entries. In addition, if the Cash Invoice Number field is included in the import it can be used to split multiple checks in a row for a vendor for a batch of Cash Invoices.

You can now optionally send the Check Number instead of the Cash Invoice Number to the Reference field of the GL expense transaction for cash invoices. Added the option 'Send check instead of cash invoice?' to the Integration tab in the Company Profile.

The following fields have been added to the batch status and are available in batch grids, the batch inquiry, and Adagio GridView: Created date, time and user; Last Edited date, time and user; and Posted date, time and user. The date fields are the system date (computer date) rather than the session date (Adagio login date).

The temporary report file used when printing the Invoice Batch Listing now includes the cost of sales GL Account / Department fields for job related details, allowing a modified report (ModRP) to include these fields.

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.
Problems fixed

When importing a Cash Invoice type transaction to a manual check batch the Cash Invoice Number field is now required and cannot be blank. Previously it was possible for an import to result in a blank Cash Invoice Number, resulting in a problem if the transaction was ever reversed.

A manual check batch containing entries with a blank Cash Invoice Number is now prevented from posting.

Import Manual Checks now reports an error if the 'Det-Document Number' field (i.e. the invoice being paid) contains an invoice that does not exist or the invoice has already been fully paid.

In Payables 8.1B and 8.1C, importing vendors to update the vendor name, phone and/or Active/Inactive flag for existing vendors created data integrity errors.

Importing vendors now updates the vendor filters.

The Data Integrity Check detected manual check entries where the check total did not match the total of the details. However, the rebuild corrected the total payable but not the check and batch amount. This type of error is also detected in posting and the batch is prevented from posting until it has been rebuilt.

When opening the vendor edit or inquiry functions it was possible to very quickly press the F5 or F6 keys to open the finder or smart finder before the vendor grid was open, in particular on a network with slower performance. When a vendor was selected from the finder an access violation error was displayed.

After printing a manual check for a Cash Invoice, if you edit the entry you receive a warning stating the check can only be viewed, however, the Cash Invoice Number was editable.

In Payables 8.1B and 8.1C manual check batch entry for a miscellaneous vendor, when you keyed in the GL Account Code and tabbed over to the Department Code field it did not default to the first department that exists for that particular account. This has been corrected.

In Invoice/Cash/Adjustment entry, after adding a new entry, the grid cursor is positioned on the new entry. This is the behavior in the other Adagio modules.

When copying entries from a batch to a new batch the description of the batch created is copied from the description of originating batch rather than being blank.

Telpay EFT transactions generated for Cash Invoices (but not Payments or Prepayments) were rejected.

Send to was not sending the Reference field to the G/L Description 1 or G/L Description 2 fields for Payment entries.

Posting a Reversal for a vendor related Cash Invoice shows the Check Number in the Reference field for the GL transactions rather than the Cash Invoice Number.

After printing or previewing a multi-currency report that prints in landscape, reports that print in portrait printed in landscape instead.

Turning on the 'Delete history transactions' option in both the Period End and Year End functions cleared the transactions but did not clear the related details within the Payables GL Distribution Details table, leaving "orphan" records in the table. (Note: the Maintenance | Purge Vendor History function did clear these details.) The orphan records caused an error if you later posted transactions with the same (i.e. a duplicate) document number to a vendor. The Data Integrity Check (DIC) detected and rebuild these errors after a posting. The DIC (in Payables but not DataCare) now detects ALL orphan records and removes them when you do a rebuild so the error will not be repeated with future postings. While the DIC is rebuilding, progress is not shown (the number of orphans deleted is not updated). This may take several minutes. In many cases, the first DIC run after installing 8.1C (2011.07.29) or higher may detect and rebuild a large number of errors caused by the orphan records. This is not a cause for concern.

Posting Manual checks to 1 time vendors caused integrity errors in the GL Distribution Details table. These errors caused no problems and were not reported by the Data Integrity Check (DIC). The DIC (in Payables but not DataCare) now detects and rebuilds these errors. In many cases, the first DIC run after installing 8.1C (2011.07.29) or higher may detect and rebuild a large number of these errors. This is not a cause for concern.

Moved the fax queue from QIFAX to generic filename starting with SD that is shared by all Adagio modules that send faxes.

If a filter is based on a range for any field that is right-justified (such as customer number, single segment item number, vendor number, etc.) then additional records will be selected by the search that should not have been. For example, if the range is from 1 to 2, then not only would records 1 and 2 be selected, but also 10, 11, 100, 101 etc.

If your Ledger data was created with version 9.0x and you never used Ledger 8.1A or earlier versions, after printing the G/L Transactions report in Receivables, the Consolidate G/L Transactions dialog did not show the 2 options to consolidate by Fiscal Period.

The option to integrate with Cashbook has been removed from Banks as Payables is no longer compatible with the old Cashbook products.