Enhancements & Revisions



Adagio Receivables 9.2A


April 10, 2015



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

    General Features

    ·    You can now start other Adagio modules from toolbar buttons showing the icon for the module. This allows easy switching between Adagio modules. If a module is running against the same company data, Adagio will now just switch to that running instance, rather than launching a second instance. Toolbar buttons can be rearranged under File | User preferences, or by dragging the buttons around or off the toolbar itself.

    ·    Adagio Receivables now logs user activity within the module, including login, menu choices and batch New, Edit, Copy, Delete and Post. Audit logs may be viewed with GridView.

    ·    The Edit / View Customer grids now display the total number of records, as well as a count of the displayed records when a Filter is active. An Ignore Style Color button has also been added. Click this button to toggle the grid between no color and Style colors or no color and banding (if it is enabled in User Preferences).

    ·    Customer Filters can now be displayed in Style Priority sequence. Added ‘Display Priority’ field to the grid in the Edit Account Filters function. This makes it easier to tell the sequence in which Styles will be applied. The setting of the sort option is saved by user.

     


    ·    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.

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

    Customers

    ·    Added an option to the Transactions tab to sort customer transactions by Date or by Type/Doc No. In previous versions, transactions were always sorted by Date when ‘Current’ or ‘Historical’ were selected and always by Type/Doc No. when ‘Both’ was selected. Also added an option to the screen to sort customer transactions ‘Ascending’ or ‘Descending’. In previous versions this selection had to be made by right-clicking on the grid. And when ‘Both’ was selected, transactions were always sorted ascending.

    ·    Added ‘Require PO?’ option on the Invoicing tab in Edit Customer. Enable to require a purchase order number to be entered in the Reference field on the Header tab in Adagio OrderEntry when entering a new order, and in the PO Number field in Adagio Invoices on the Header tab when entering an invoice. Requires OrderEntry 8.1F (2014. 09.30) or higher and Invoices 9.1A (2014.10.16) or higher. A default for new customers can be set on the Customer tab in the Company Profile.

    ·    Added ‘Print BR Receipts’ option to Invoicing tab in customer. Enable if you want to print a receipt in BankRec when payments for the customer are deposited. This enables the ‘Print Receipt’ option in the BankRec batch for receipts retrieved from Receivables, transactions entered in BankRec or generated in reconciliation. Also added ‘Request Receipt’ option to Integration tab in the Company Profile. Enable if you want a receipt to be printed for cash transactions sent to BankRec from Receivables for all customers. This option must be disabled to be able to enable the ‘Print BR Receipts’ option for individual customers. Requires BankRec 9.2A (2014.12.18) or higher.

    ·    Added ‘Batch by entry’ option in Payment Methods. Enable to create a separate deposit batch when receipts are retrieved in Adagio BankRec (including payments originated in Adagio OrderEntry and Invoices). This is very useful if you want all deposit entries using this Payment Method to appear in the Bank Reconciliation in BankRec as separate deposit entries, such as for payments received by EFT.

    ·    Added option ‘Allow edit of posted desc or reference?’ option to the System Options tab in the Company Profile. Enable the option to allow the Description 1 and 2 fields and the Reference field for posted transactions to be edited on the Transaction Details screen, accessed from the Transactions tab in Edit Customer. Use this option to allow correction or updates to these fields after posting.

    ·    The Terms Description is displayed next to the Terms field in Edit and View Customer. This allows you to see the description in View Customer and to see it in Edit Customer without opening finder on the Terms field.

    Edits and Inquiries

    ·    An Invoicing Specs tab has been added to the Company Profile. This allows defaults for new customers to be set for Print, Fax and Email specifications, as well as Email Covers for Order Confirmations, Invoices and Credit Notes in Adagio OrderEntry, and/or Invoices and Credit Notes in Adagio Invoices. In addition, a default Picking Slip specification can be set for OrderEntry.

    ·    Added ‘Request Receipt’ option to Integration tab in the Company Profile. Set if you want a receipt to be printed in BankRec for cash transactions sent to BankRec from Receivables for all customers. This option must be disabled to be able to enable receipts to be printed for individual customers.

    ·    Added ‘Exch. round. error misc rcpts' to the Integration tab in the Company Profile for multi-currency databases. Miscellaneous receipts are not associated with a customer and, therefore, not to a Control Account Set from which to take the Exchange Rounding Error account. Select the account and department to be used for exchange rounding errors when Miscellaneous Cash Receipts are used.

    ·    The Batch Inquiry functions now include the ability to print Batch Listings (both open and posted), print Posting Journals (open and printed), and Recover posted batches. Batches can be multiselected.

    ·    Excel Direct has been added to the Batch Inquiry functions.

    ·    Added several AR specific Styles for use in customer filters.

    Batch Entry and Posting

    ·    The document number generated for invoice and adjustment batch entries now includes the year. The format is year, batch and entry number (YY-B-E). This avoids potential duplicate numbers with transactions entered in previous years.

    ·    The Payment Total is now displayed at the bottom of the invoice batch screen if any entries include payments.

    ·    The Total Applied is now displayed at the bottom of the cash batch entry screen. In the previous version, only the Total Unapplied was displayed. Knowing how much has been applied is useful when one check is split between two customers.

    ·    Cash batch entry now checks for a negative unapplied amount and displays the message: “Applied payment amount exceeds the check amount. Do you wish to continue and save the entry?” when the entry is saved. This also prevents accidentally leaving the Payment amount field at zero after applying cash to invoices.

    ·    Invoice and adjustment batch entry check for duplicate Document numbers in current and history. Cash batch entry checks for duplicate Check Number. If a duplicate is entered the entry cannot be saved. Posting still also checks for duplicates.

    ·    The customer name can now be edited for miscellaneous cash receipts (blank Customer code in invoice entry). In previous versions, it was set to ‘Miscellaneous Cash Receipts’. The edited name is retrieved in BankRec. It is also retrieved in Ledger when any of the G/L Reference, Description 1 or Description 2 Send To fields are set to Customer Name.

    ·    For credit notes entered directly in Receivables, if the ‘Calculate base for discount with tax included?’ option is disabled in the Company Profile, when credit notes are applied to invoices the amount of the credit note before tax is applied to the Discount Base. In all previous versions, the full amount of the credit note was applied.

    ·    The Distribution field is now hidden on the batch detail screens for all batch types 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.

    ·    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. Most often this field will remain disabled so that posting to the AR control account is done by Receivables only. However, if you periodically post to the control account (say, when an amount is between departments), enable this option so you can do so.

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

    Ledger Interface

    ·    Receivables 9.2A supports the new feature in the Ledger 9.2A Retrieve Subledger Batches function that allows separation of subledger batches on retrieve by Batch Number. The retrieval file cannot be separated by Batch Number for earlier versions of Receivables.

    Specification Designer and Printing Statements

    ·    When printing a statement from within a customer, the Run Date defaults to the last statement date if statements have previously been printed for the customer. If the last statement date is more than 31 days older than the system date, the session date is used. New customers use the session date.

    ·    The ‘Auto-attach unpaid invoices’ option on the Statements tab in the customer has been changed to ‘Auto-attach unpaid documents’. All unpaid (non-zero) documents, including credit notes, are now attached to statements when this option is enabled.

    ·    New specification codes added to show the user who printed statements and the actual date:
         M37, current user code
         M38, current user name
    …..M39, system date

    Reports

    ·    Added ‘Summary only’ option to the Customer Transactions reports. Summarizes transactions and prints one line per customer, showing the total Invoices, Cash, Credit Notes, Debit Notes, Adjustments and Discounts.

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

    ·    All details for the Tax Tracking report are now always tracked. This way they are always available for reporting. The ‘Invoiced on tax tracking report’ option on the Tax Information tab in the Company Profile in previous versions has been removed. The selections for this option (‘Only details with Distribution codes’ and ‘All details’) are now available for on the Tax Tracking report dialog instead.

    ·    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.

    ·    When invoice batches including payments are posted, a cash posting journal is created as well as the invoice posting journal. If the option to auto-print posting journals is selected, the cash posting journal is now also printed.

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

    ·    Adagio Receivables 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\Receivables\StandardReports. Revisions to these reports should be placed in \Softrak\Receivables\ModifiedReports. Custom reports to be added to the Reports menu should be stored in \Softrak\Receivables\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. It 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

    ·    When you elect to clear history when running Period End or Year End, the ‘Clear Customer history up to’ date can now be edited. The date defaults to the last Period End Date less the number of days for which you elected to keep transactions in history. A warning appears if you enter a date newer than the calculated purge date. The date selected is displayed above in the list of functions that will be performed when you proceed.

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

    Import / Export

    ·    Import and export templates created for Excel format now default the file extension to .XLXS rather than .XLS.

    Problems Fixed

    ·    Several fixes were made for this release which will be listed at a later date in a Release Note on our website and the Readme help.



© Copyright Softrak Systems Inc. All rights reserved.