·    Grids may be “banded” with a User Selectable color and banding frequency set under File | User Preferences. Filter Styles may be disabled and replaced with regular banding if desired.

·    Added Filter criteria 'Before today' and 'After today' for Floating Date Range.

·    The status bar at the bottom of the main window now shows activity of various steps when the program is starting up and the database is opening.

·    The Column Editor screen can be sized. The size is remembered by module on the workstation.

·    Supports Transport Layer Security (TLS) / Secure Socket Layer (SSL) for secure email servers when emailing check advices. Added option 'Use TLS/SSL' added to Email Setup function.

·    Updated splash screen with new Adagio logo and colors. Updated icon and toolbar button images.

Vendors

·    You can now find vendors by Document Number.

·    The Find by vendor Phone now shows formatted phone numbers.

·    Vendors now have aging buckets on the Transactions tab, similar to Receivables. They are auto-calculated without having to click a button. Note that these aging fields do not display the values determined by Calculate Vendor Aging -- exactly the same as AR, which does not show the values determined by Calculate Customer Aging. Rather, the values are strictly based on being aged by Due Date as of the session date.

·    A Find Document field and Document Type have been added to the Transactions tab in the Vendor to allow you to search for a particular document using Finder or Smart Finder.

·    Vendor and Payee address fields are formatted, including dedicated fields for City, State/Prov and Country. Addresses can also be unformatted, as may be required for international vendors. The ‘Format Address’ setting is by individual vendor and controlled by default in the Company Profile. If the option ‘North American address’ is enabled, State and Province codes will be validated for North America and the country field will be populated automatically. A final option controls whether the Home country (user specified) is displayed on printed addresses. The company address in the Company Profile may also be formatted.

·    The vendor master record has many new fields and fields have been made larger. New fields include:

Second vendor Name field.
Second Comment line
Last Maintenance User, Date and Time stamp fields available in vendor grids and finders, custom reports and in GridView.

Larger fields include:

Name increased from 30 to 40 characters
Address lines from 30 to 40
Contact from 18 to 30
Comments from 30 to 40.

·    Added Tax Group and Tax Status default fields (used when adding new vendors) to the Company Profile, Batch/Vendor tab.

·    Vendor current and history transactions are now located in a single file rather than 2 separate files. This allows all transactions to be shown on the vendor transaction grid, on a single view in GridView, or on a single custom report.

·    A ‘Both’ option has been added when viewing transactions in the Vendor to allow you to view current and historical transactions in the same grid.

·    Added an option to sort transactions in ascending or descending order by date in the edit and view vendor functions for Current, Historical transactions or both. In previous versions, transactions were always sorted ascending.

·    Added an option to sort transactions by Date or by Type/Doc No. In previous versions, transactions were always sorted by Type/Doc No.

·    Added ‘Total Forced’ and ‘Total On-Hold’ amount fields to the vendor. These fields appear on the Transactions tab in the vendor and can be useful in filters, grids, finders, GridView views and custom reports.

·    Vendors can now have multiple alerts, and alerts can be set to display in specific functions in a specific module. Options on an alert allow them to be disabled once they are displayed, or require a user to acknowledge the alert. User ID’s are stored when alerts are disabled. All alerts for a vendor can be disabled in a single tick box.

·    The vendor Notes grid in the vendor edit and view functions can be sorted to display the most recent notes at the top by right-clicking on the grid and selecting 'Sort Descending'. The selection is remembered.

Edits

·    You can now edit Control Account Sets or change a vendor’s Account Set without having to first purge all the posting journals. For Adagio MultiCurrency databases the new Account Set must have the same currency, unless the vendor has no transactions.

·    You can now edit Banks without having to first purge all the posting journals.

Batch Entry and Posting

·    You can now find vendors by Document Number in batch entry.

·    A unique, incrementing, invoice number can be auto-generated for invoice batch entries by using the %n code in the Invoice Number Format field on the Accounting tab in the vendor. A Next Invoice No. field has been added to enter/show the starting/current value. The number is up to 4 digits and is trimmed. Copy batch, copy entry, import and export vendor, import invoice batch and import manual check batch (cash invoices) are supported.

·    When the ‘Auto-assign document number’ option is enabled in the Company Profile, the document number generated for invoice and adjustment batch entries now includes the year. The format is year, batch and entry number (YY-BB-EE). This avoids potential duplicate numbers with transactions entered in previous years.

·    The Distribution field is now hidden on the invoice batch detail screen if there are no Distributions on file. This speeds entry by eliminating an extra tab key or mouse click on each detail if you do not use Distributions. The Dist. Set button is hidden on the invoice batch entry screen if there are no Distribution Sets on file.

·    Adagio JobCost users can now control the information sent to the Reference and Description fields in JobCost batches created by Payables, including vendor number, vendor description, Document Number, and Document Reference and a User Defined format. The fields ‘Send to A/J reference’ and ‘Send to A/J desc.’ have been added to the Integration tab in the Company Profile. The 'User defined' option allows you to format the fields using a combination of fields from the transaction, batch information (posting sequence, batch number, entry number), Job/Phase/Category, Time&Billing fields and free form text. Click on the field in Help for the list of codes.

·    Added the option ‘Allow posting to control account’ to the Integration tab in the Company Profile. It is disabled by default to prevent you from (accidentally) entering GL accounts used in Control Account Sets GL account during batch entry. Batch posting also checks this.

·    You can now add Vendor Name and other fields from the vendor to the batch grids using the Column Editor. The Vendor Name is included by default.

·    The Job Description and Estimate Description can be shown in the Job/Phase/Category finder in batch entry.

Ledger Interface

·    Payables 9.2A is fully compatible with the new feature in the Ledger 9.2A Retrieve Subledger Batches function that allows separation of subledger batches on retrieve by Posting Sequence or Batch Number. For earlier versions of Payables, if the subledger batch contains transactions for system checks, reversed checks, checks cleared with error, or NSF Checks, revaluations or period end clearing entries, the Retrieval file cannot be separated by Batch.

Specification Designer and Printing Checks, 1099s and  T5018s

·    Added ‘Print one check per invoice’ option to the Accounting tab in vendors. Set this option to cause the System Check Run to print one check per invoice for the vendor rather than one check paying multiple invoices.

·    You can now add Vendor Name and other fields from the vendor to the grid on the Payments tab for System Checks using the Column Editor. The Vendor Name is included by default.

·    The check specification designer has been updated to support new vendor formatted address fields and increased length of some fields. Your existing checks and other forms will print without requiring any change. However, you may want to change your existing specifications to use address formatted fields or adjust the widths of the fields on the forms.

·    The description of specification codes V02 to V06 and V14 changed from “vendor” to “check” to reflect that these codes actually print fields from checks not vendors.

·    Added new codes to the specification designer for formatted addresses and other new fields in vendors:
     Vendor address line 1..7 (compressed)                          Vendor City
     Vendor address 1..7 (formatted)                                   Vendor State/Province
     Vendor Name 1                                                            Vendor Country
     Vendor Name 2                                                            Vendor Comments 2
     Vendor Name 1 + 2                                                      Vendor I.D. number – partial

·    The new Vendor formatted codes make it easier to remove blank address lines and have the Zip/Postal Code on the same line as other fields.

·    Added new spec codes for formatted address from Company Profile:
     M27..33 Company address line 1..7 (compressed)
     M34..40 Company address 1..7 (formatted)
     M41 Company City
     M42 Company State/Province
     M43 Company Country

·    New specification codes added to show the user who printed checks, advices, 1099s and T5018 forms:
     M44, current user code
     M45, current user name

·    Add specification code "V66 Vendor I.D. number - partial" to print the last 4 digits of the Taxpayer ID Number on 1099s. The last 4 digits are printed and the rest are asterisks.

·    If a System Check Run is in progress and the EFT status is changed for a vendor, clicking the EFT/Post button will detect that a vendor status has changed and present a message stating a new payment list will be generated.

Reports

·    Added Aged Open Payables report. The report is similar to the Aged Overdue Payables report but for Open Payables. It can be aged by document date as well as due date and can be calculated as of a prior date. There is an option to include Applied Details.

·    Posting Journals can no longer be cleared after printing. This avoids accidental clearing. Posting Journals are cleared at year end. The 'Allow Post Journal Purge?' option has been removed from the Company Profile.

·    Running Period End no longer precludes the printing of the Aged Overdue Payables report or the new Aged Open Payables reports for an earlier period.

·    A new ePrint code %CDT is available to put the Calculate/Aged as of date into either the PDF filename or folder name for reports such as Open Payables and Aged Overdue Payables.

·    Added an option to print a General Ledger Distribution Summary on batch listings.

·    Added finder and smart finder on the Vendor Name on report dialogs to allow look up by name for a range of vendors.

·    The Posting Journals were changed to use a single format regardless of whether Payables is interfaced to JobCost, Time&Billing or neither. This allows the same GridView views and custom reports to be used for any AP data regardless of interfaces.

·    A Batch Description field has been added to Posting Journal records for use by custom reports or GridView.

·    The Distribution Sets Report now prints the Job/Phase/Category for Job cost type Distribution Set Details.

·    Adagio Payables’ standard reports are now created using Crystal Reports 2013, replacing the Crystal Reports 8.5 Print Engine (CRPE32.dll). The module’s management reports are now stored in \Softrak\ Payables\StandardReports. Revisions to these reports should be placed in \Softrak\ Payables\ModifiedReports. Custom reports to be added to the Reports menu should be stored in \Softrak\ Payables\CustomReports. Reports must be edited or created using Crystal Reports 2011 or 2013 and Adagio ODBC for access to the data files. Users will notice minor changes to some of the visual elements in the module and a new Print Preview window. The size and position of the Print Preview window are now remembered between sessions by user, so the Workstation Options controlling this function have been removed. Exporting to an Excel spreadsheet from the print preview window has been significantly improved. The Report Tables Drive settings and Crystal tables in the \QRASP folder are not used by version 9.2A modules.

·    An updated version of Adagio PrintTool (PT) is installed in \Softrak\PrintTool. PT allows you to print / preview custom reports without needing to run Crystal Reports itself or without placing the report on the Custom Reports menu in an Adagio module, and allows reports to be placed on the Windows desktop. PrintTool 9.2A prints custom reports created with Crystal Reports 2011 or 2013 only. Adagio ODBC must be installed to create custom reports but is not required to print custom reports. Your Adagio dealer or consultant can create custom reports for you and deploy them at your site. PT allows you to specify a report to print on the command line using the /r parameter. This allows Adagio automation batches to print custom reports (to printer – a future release of PT will allow automation batches to print custom reports to PDF). PT does not require registration with Softrak Systems but does use Adagio Lanpak licenses. Note: PT does not print reports created with Crystal Reports 8.5 for Adagio. Existing version 8.5 custom reports must be converted before they can be printed by 9.2A.

Maintenance and Miscellaneous

·    Added Delete Inactive Vendors function. The option ‘Exclude vendors with historical transactions’ allows you to delete vendors with history transactions (vendor history does not need to be purged first) or conversely use it to delete only vendors with no history. The ‘Select vendors already flagged as inactive’ option can select vendors based on the ‘Active’ flag in the vendor.

·    Added Date/Time/User Created and/or Last Maintained fields to vendor and other files, including adding batch fields from the batch status to transactions. These fields can be used in grids, finders, GridView and custom reports.

·    When revaluing your accounts payable in an Adagio MultiCurrency site, prepayments are now included in the revaluation.

·    The Data Integrity Check (DIC) saves results for the last 9 previous runs in files APWINERR01..09.dat (where .dat is your company data file extension). The current DIC information will always be in APWINERR. If you do check/rebuild/check without closing the DIC function the results are appended to the same file.

·    Adagio Checks databases can be converted to Payables, including Vendors, Banks, Distributions and Check Specifications. When creating a Payables database, if Adagio Checks database is present, it will ask if you want to convert it. A default Control Account ‘CHECKS’ and default Terms Code ‘CHTRMS’ are created. These defaults can be changed during creation. The Checks 'Default bank code' is transferred into the 'Default bank for manual checks' in Payables.

Import / Export

·    Import Vendors now allows updating the Control Account Set without having to first purge all the posting journals. The vendor balance must be zero and for multicurrency databases the new Account Set must have the same currency, unless the vendor has no transactions.

·    New export templates created for Excel format default the file extension to .XLXS rather than .XLS as in prior versions.

Problems Fixed

·    When the Transaction details for an Invoice were changed through Vendor Edit, an invalid date message would appear on tab out of the Discount Date field if it was blank.

·    When the first document in the Current transactions list is an Invoice and the Transaction details are edited to change the Document status, the Status in the list of documents did not immediately display the new Invoice Status

·    When T5018 was enabled for a vendor, if additional characters were added in the Identity Number field beyond the end of a valid GST number (which is allowed) there was a validation warning in some cases and the vendor could not be saved.

·    When viewing PDFs for Invoices created by PurchaseOrders in a vendor, if a Receipt and Invoice/Adjustment had the same vendor document number, when you viewed the Invoice/Adjustment PDF the Receipt was displayed instead.

·    When entering a GL Account / Department in a batch, validation did not work and no warning was given when you entered a Department that did not exist for an Account -- if that Department did exist for the next highest Account. For example, you had account 8000-150 and the next account in the chart is 8001-250, then entering 8000-250 did not give a warning.

·    If the ‘Calculate base for discount with tax included?’ option is enabled in the Company Profile and a credit note with tax was posted to an invoice, the discount base of the invoice was updated by the full amount of the credit note instead of the amount net of Tax.

·    For Manual Check Payments, the Maximum Payment for invoices was being ignored. The Current Balance was defaulted as the Payment Amount. If the Check date made it eligible, Discounts were calculated. Manual Checks now matches System Checks; the Payment amount is now limited to the Maximum Payment and Discounts are not calculated when the Maximum Payment is not equal to the Current Amount.

·    For Letters, the Email files created in the SOFTMAIL folder did not have the full vendor code in the PDF file name (although the attachments were correctly emailed.)

·    The Vendor Transactions and the aging reports did not include vendors if the Short Name field had an extended character (e.g. French character with accent) in the first character position.

·    The Data Integrity Check checks for and corrects information in address fields used by TelPay that may result from incorrect import of vendors when using export / import to configure vendors for Telpay EFT.

·    In some cases in the Payables 8.1F when a dataset was newly created or converted from DOS versions, the Bank files were not created properly. This caused the Banks grid to show no banks and errors when you tried to add a bank.

·    In some cases in MultiCurrency datasets, period end was not correctly updating the Period End Clearing posting journal with the clearing entries.

·    In some cases, the displayed name of the EFT provider on the EFT tab in the Company Profile did not match the format selected in the System Options tab.

From previous Payables 8.1F Hot Fixes

·    The EFT file for "CIBC 1464 format CAD" was rejected by the bank.

·    When posting batches using automation, if the 'Require batch print before posting?' option was enabled, batches that had not been printed caused the automation job to abort and no batches were posted. Batches that have been printed are now posted, unprinted batches are skipped, and the automation job does not abort. This allows the print status to be used to control which batches will be posted. In a future release of Payables, batches will be able to be marked 'Ready to Post' to control posting during automation, similar to other modules such as Ledger.

·    Adagio JobCost 8.1C users received the error "Unable to find data dictionary Phase @J81APHA, (1212)" when printing an invoice batch listing in Payables 8.1F, if JobCost 8.1A or 8.1B had not been previously installed.

·    In MultiCurrency sites, where the Open Payables or Overdue Payables report were backdated, the home amounts were incorrect even in simple cases. This has been fixed. However, in the event of multiple revaluations against partially paid invoices, it is unlikely that these reports will ever tie to the AP control account for a back dated period.

·    The T5018 form template has been updated and changed from 3-part to a 2-part. A minor change to the T5018 Summary forms templates has also been made. You will need to create a new T5018 specification file for your company database(s) using the new template and adjust as (or if) needed for correct field alignment on your printer. The sample data is not updated by the Hot Fix but you can created new sample specifications from the new templates if needed.

·    The PDF Viewer available to Adagio ePrint users in the vendor edit and inquiry functions did not show PO transactions that were Invoices posted as Invoice/Adjustments, as well as invoices posted as Receipts.

·    Adagio JobCost 8.1C users received the error "Unable to open data file @J65JOB, (1213)" when trying to create an invoice in Payables 8.1F if JobCost 8.1A or 8.1B had not been previously installed.

·    For Crystal Reports for Adagio users, the Custom Reports menu was missing in Payables 8.1F (2013.08.26) when you had custom reports in the \softrak\apwin\customrp folder.

·    In Payables 8.1F (2013.08.26), the Vendor List report printed details multiple times if the vendor had an alert containing more than one line of text.

·    Printing a report caused 'APPublicFavorite' to be inserted in the Style Finder. This caused all the styles listed below to use different colors/styles and could cause vendor styles to be incorrect.