Enhancements & Revisions



Adagio Payables 9.2B


November 7, 2016



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

    Vendors

    ·    Vendors now track the total amount and number of transactions in open Invoice and Manual Check batches (but not Adjustments). These fields can be displayed on vendor grids, used in Filters, GridView views and custom reports.

    ·    Added ExcelDirect in Vendor Edit/View on Transaction Details grids for Applied Details and G/L Distribution Details.

    ·    The Column Editor is now available in Vendor Edit/View on Transaction Details grids for Applied Details and G/L Distribution Details.

    ·    Added G/L Account Description field (‘Acct Desc’) to the Vendor Edit/View on Transaction Details grids for G/L Distribution Details.

    ·    The Edit/View Vendor functions in PurchaseOrders now respect the ‘Edit Vendor SIN/FIN’ option in Security Groups.

    ·    Transactions for PurchaseOrders 9.2B are now shown in the Edit / View Vendor functions in Payables.

    Edits and Inquiries

    ·    Added ExcelDirect on grids for Distributions, Distribution Sets, and Email Covers.

    ·    Addresses in Banks support formatted addresses with separate City, State/Prov. and Country fields.

    ·    The View Batch Status function now includes the ability to print Batch Listings (both open and posted, with multi-select), print Posting Journals (open and printed, with multi-select), and Recover posted batches (with multi-select).

    ·    Added a Batch Inquiry button to the toolbar.

    Batch Entry and Posting

    ·    Archive Invoices and Manual Check Batches with full batch edit in the Archive system. Existing Recurring Batches are converted to Archive Invoices Batches.

    ·    In invoice batches for 9.2B, the 'Original invoice' field is above the ‘Document’ field on the entry screen. If the entry is a Credit Note or Debit Note, the first thing you want to do is enter the matching invoice. If the entry is an Invoice the program skips this field automatically. The new order of these fields makes it less likely the Document number will be left blank.

    ·    Tax can be calculated automatically on amounts entered on invoices and cash invoices. Added ‘Taxable purchase’ option in the Tax Type in Distribution Codes.

    ·    You can now recover a percentage of tax to multiple expense accounts on invoices and cash invoices. The field ‘Tax recoverable %’ has been added to Distributions. The percentage is to 5 decimals. This is useful for some Not-for-profit organizations.

    ·    Distribution Sets now allow you to distribute a single amount to multiple expense accounts based on a percentage rather than doing it manually. An ‘Allocation %’ field has been added to the Distribution Set Detail screen. In addition, you can specify a default Allocation Amount in the Distribution Set to be allocated for each detail based on the percentage.

    ·    New Open Documents file maintains a list of invoices in open invoices batches and cash invoices in manual check batches. This is used to help prevent entering duplicate invoices. When an invoice is entered for the same Document Number as a transaction in a different or the same batch a warning is displayed. This will make it more difficult to enter duplicate invoices or payments.

    ·    The total amount of payments in open manual check batches is tracked for the posted invoice transactions they are applied to. This amount is used to calculate the actual Remaining Amount for the invoice. The Remaining Amount is shown on manual check details. This helps prevent duplicate payment or over payment of invoices.

    When BankRec creates a batch in Payables, it updates these amounts. However, payments in open BankRec batches are not reflected in these amounts.

    If a System Check run is created for an invoice with applied amounts in open manual checks, the payment amount for the invoice will be the current amount minus the total payments in manual check batches. However, the Amount Remaining shown in manual check entry does not reflect payments in a system check run in progress. If a manual check is entered for an invoice already in the system check pre-check register you are required to regenerate the run before printing and posting it. For these reasons, you should not create payments using both manual check batches and system checks if you wish to use this feature.

    ·    The total amount and count of payments, as well as the manual check batch number and entry number of the payment (unless there have been 2 or more payments against the invoice) are maintained in posted invoice transactions. These fields can be displayed on the vendor transaction grid, used in Filters, GridView views and custom reports.

    ·    Batch types can have color on their forms, like GL current and next year. Current / archive invoices, current/archive manual checks, and current adjustments.

    ·    Added ExcelDirect on batches grids, batch entries, and batch entry details.

    ·    For Cash Invoices, you can enter an Invoice date that can be different from the Check date.

    ·    An Accounting date can be included on batch entries so that transactions can be retrieved into GL for a different period. For Cash Invoices, there is an Accounting Date for the invoice as well as the payment.

    ·    A Batch Total field has been added to the batch grid screens and shows a running total of all entries in the batch.

    ·    The Address tab in manual check batches now supports formatted vendor addresses.

    ·    Batch Entry Templates have been added. Templates allow you speed up entry and eliminate confusion caused by fields you do not use. Templates allow you to skip, disable or hide fields in invoice, cash and adjustment entry. Entry Templates can be by Group. Define Entry Templates using the Edit Menu.

    ·    Entries in batches can be sorted. You can sort by Vendor Number, Document Date, Document Number, Reference, Entry Number and the optional fields.

    ·    A ‘Ready to post’ status has been added to the batch status. Default settings for Entered, Retrieved or Imported batches can be set in the Company Profile. Batches written directly to Adagio Payables from other ledgers such as BankRec or PurchaseOrders will be considered to have been retrieved rather than Entered.

    ·    Transactions now support an Accounting Date separate from the Document Date. Documents with different accounting dates may be retrieved into Adagio Ledger to the correct period using the ‘Subledger period’ option in the ‘Retrieve Subledger Batches’ function. To use this feature, set the option ‘Allow edit of accounting date’ on the Integration tab in the Company Profile.

    ·    A second description has been added to batch entry.

    ·    Increased the size of the Description fields in batches from 30 to 40 characters.

    ·    Statistical Units can be entered in batches and will be posted through to Ledger 9.0A or higher (if the account tracks Statistical Units).

    ·    Optional fields have been added at the transaction header level. Optional batch fields are posted to the transaction file. Optional fields will flow from batches entered in related modules, such as Adagio PurchaseOrders, in future versions of BankRec.

    ·    Several user and date stamp fields have been added to batches. These fields are posted through to the transaction file. They are available in grids and can be shown on custom reports and in GridView.

    Specification Designer and Printing Checks / EFT

    ·    Payables 9.2B supports multiple EFT providers. Requires Adagio EFT 9.2B to be installed unless you use Telpay. See release notes for Adagio EFT 9.2B for details.

    ·    Specification codes M14..17 (Man chk desc Ln1..4), M18, M19, and M20 were moved from Company Information section to new Manual Check section.

    ·    Added Manual Check section, with these specification codes:
       M47 Man chk Desc 2
       M48 Man chk Invoices Date
       V26..30 Check address line 1..4, Check Zip/Postal code
       V03,4,5,14,6,84 Check address line 1..6 (compressed)
       V78..83 Check address line 1..6 (formatted)
       V85 Check City, State/Province, ZIP/Postal code
       V86 Check City
       V87 Check State/Province
       V88 Check Country

    ·    Added to Advice body (detail) section:
       L7 Transaction desc 2

    ·    Added to Check Information section:
       A24 Currency code
       A25 Currency description

    ·    Added to Bank Information section:
       B07 Bank address line 5 (compressed)
          – was Bank Zip/Postal
       B18 Bank address line 6 (compressed)
       B19..24 Bank address line 1..6 (formatted)
       B26 Bank City
       B27 Bank State/Province
       B28 Bank Country

    Reports

    ·    The ‘Force paperless reports?’ option available to Adagio ePrint users is now respected when printing Import/Export templates, Automation logs, and smart finder results.

    ·    The Adagio ePrint code %BTT (Batch Type) is now supported for Batch Listings.

    ·    Vendor transactions report allows summary by date range

    ·    Print the Aged Open Payables, Aged Overdue Payables and Vendor Transactions reports to Excel using ExcelDirect. Added an ExcelDirect button and ExcelDirect Options button on the report dialogs. Transactions from the report are exported to Excel using the selected ranges, sorts and options (except subtotals and page breaks). The resulting spreadsheet may be more useful than the export produced using Crystal depending on your requirements. Select the new ‘Enable ExcelDirect Print’ option and related settings on the Report Options tab in the Company Profile.

    ·    Added new include options and new formats to the Vendor Transactions report.

    Miscellaneous

    ·    Payables now renders dialogs properly on Ultra High Resolution displays when the font size is anything other than 100% of normal on Windows 8.1 or higher. All Adagio releases dated in September 2016 and later have this problem fixed. For releases prior to this date, the utility program SetScreenForAdagio.EXE is installed in the \Softrak\System folder to correct the problem.

    ·    Payables 9.2B installs an updated version of the AdagioPDF driver. The updated driver name is AdagioV2PDF and will appear in Windows Control Panel, Devices and Printers. When installs are performed on January 1, 2017 or later from a Remote Desktop Services connection to Microsoft Server 2016 or from a Windows 10 station, the security warning related to the AdagioPDF printer driver no longer appears.

    ·    The email password for servers that require authentication is now encrypted in the file containing email settings for the ‘Direct’ email method.

    Problems Fixed

    ·    Many fixes were made for this release which are not listed in these release notes.

    ·    The Aged Open Payables did not print the Original Amount in Home currency in Summary.

    ·    For Manual Check batches and Payment Control, the warning for exceeding maximum payment has been changed and you are now able to proceed.

    ·    If an invoice had been assigned a Forced status and paid, future pre-check registers would continue to select this invoice even though the current balance was zero. This is no longer the case.

    ·    After installing Ledger 9.2B (2016.08.10) or SysUpdater (160809), temporary files created on workstations by printing reports were not deleted in some cases, although this did not cause any problems.

    ·    When browsing for a path in various functions in Payables 9.2A (2016.05.24) on Windows 8 or higher, you had to select a file to select the folder. This was corrected by System Updater (2016.08.09), which is no longer required for this release of Payables.

    ·    The snapshot made by the System Status function (chksys.exe) did not include station log files in some cases.

    ·    When taking a snapshot with the System Status function (chksys.exe), the error “Snapshot is incomplete! The snapshot encountered error (1).” was encountered in some cases, indicating a file was open and could not be included in the snapshot, when in fact that may not have been the case.

    ·    Installs a new Adagio Data Source (ADS) that prevents resource locking problems at large Adagio sites running 9.2 versions and improves application performance at these sites.

    NOTE: All third-party applications from Adagio Developer Partners must use the new ADS. You must check with your Adagio consultant or the developer to confirm their application is using ADS 1.12. 66.3503 or higher. Failure to ascertain this risks corrupting data if the application is writing to the Adagio data files concurrently with Adagio modules.



© Copyright Softrak Systems Inc. All rights reserved.