Adagio Payables 9.3C

§   %usr - for User ID

§   %unm - for User name

§   %sdt - for Session Date

§   %syr - for Session Year

§   %smh - for Session Month

§   %sdy - for Session Day

§   %dat - for Actual Date

§   %tim - for Actual Time

§   %bat - for Batch Number

Edit

·    Additional contact information for Cell Phone and Toll Free Phone numbers have been added to Edit Vendors, Import/Export Vendors, and the Vendor List and Statistics report.

·    Project codes created in Adagio Ledger can be assigned as default values to Distribution Codes and Distribution Set details.

·    Distribution Sets that use 'Auto-distribute?' may have distributions with blank Account/Departments. When the Distribution Set is added to an Invoice entry, the Vendor's Default Acct/Dept will be used. If the Vendor's Default Acct/Dept has been left blank, the Distribution Set Details will be added to the Invoice Batch entry with the blank Acct/Dept. The entry cannot be saved until the Invoice Detail has been updated.

Designer

·    Check specification codes for new Vendor fields: V95 Cell Phone V96 Toll Free Phone

·    New specification code for Payments that are Cash Invoices: G16 for Project name 2

System Check Runs

·    The Vendor Summary grid within System Check Runs on the Payments tab now has a new Net Issued column that can be added. This value will display 0.00 if a check will not be printed for the vendor, if the Net Payment amount is negative or outside the specified Vendor Payment range to match with the Pre-check Register report results.

·    The Net Issued value for System Check Runs, calculated from the Pre-check Register report, is now also displayed on the Payments tab in addition to the Selection/Status tab. This makes it easier to see what the total check run amount will be when selected vendors have negative outstanding balances.

DocStore

·    When using Adagio DocStore, printing the Pre-check Register report now correctly uses the %CDT code in eP Options to translate the Check Date of the System Check Run as part of either the PDF file name or save folder. Previously it was using the sign-on date.

Reports

·    Printing reports is now logged in the application log, in addition to accessing the print report screen from the menu.

·    For vendors that have been set up to track either 1099 or T5018 payments, a new statistic for Last Year payments is now accumulated in addition to Current and Next year amounts.

·    When integrated with Adagio DocStore, the Email Queue Listing report now supports all the Print to PDF features.

·    The Tax Tracking report now has floating date range options for This Month and Last Month, that can be used as part of Favourite Report settings and printing the report unattended from report sets. There is another new option to suppress records that have zero tax amounts, printing only transactions with tax.

·    When a report is printed and the data file either purged or consolidated, a record of this action is now saved in the Application Log.

EFT

·    For Telpay EFT and Conversion to Payables 93C, conversion will strip the dashes out of the 'Bank ID' on the Vendor's Accounting tab. In previous versions of Payables, the dashes were required. If the 'Bank ID' is not blank, it will be displayed on the EFT tab as the 'Bank account' formatted with dashes. If the 'Telpay EFT only?' option is set on the EFT tab, the 'Bank ID' may be left blank. System Check runs also recognize the 'Telpay EFT only?' option. If the 'EFT code' for the Bank is not set to use 'Telpay format' for the 'EFT batch format', then vendors which have 'Telpay EFT only?' selected are skipped when 'Select Vendors' is set to EFT.

·    A CIBC 1464 format USD EFT Provider has been added for the CIBC EFT 1464 Byte File Layout. The Currency Identifier is USD for US dollars.

·    An RBC ACH094 Credit PDS EFT Provider has been added for the Royal Bank ACH094 Credit File Format Specification. Please note: If this format is used, the related fields on the Vendor's EFT tab must be updated: Transaction Type, Bank Dest. Country.

·    An RBC 152 format US ACH EFT Provider has been added for the Royal Bank ACH Direct Deposits (PDS) Service, RBC Standard 152 STD Credit File Format Specification. Please note: If this format is used, the related fields on the Vendor's EFT tab must be updated: Transaction Type, Bank Dest. Country, US Trans. Code and Company Entry Desc.

·    System Check Runs now have the EFT vendor selection option extended for a new choice to generate payments for vendors that do not have EFT processing enabled. This provides a clearer division for paying some vendors by EFT and others with printed checks.

·    A VanCity 1464 format USD EFT Provider has been added for the VanCity EFT 1464 byte file layout.  The Currency Identifier is USD for US dollars.

·    If Vendors were updated by importing changes for enabling and setting up access to TelPay and the EFT Country field was not included, that field would be blank on vendors and caused TelPay EFT to not work correctly. Data integrity check detects this condition and Rebuild will insert the correct value when missing.

·    EFT: for CIBC First Caribbean CSV files, if 'Include Reference' is selected and the 'Check Number' is being sent, the check number will have the first dash trimmed to fit the 10 character Reference field. In the file, the Check Number will now be: EFT{sequence}-{check number}.

·    For the Caribbean, an RBC Royal Bank (Barbados) CSV EFT Batch Format has been added to the list of EFT Batch Formats. It is for Direct Payments in CSV format for the RBC Royal Bank (Barbados) Limited.

Notes: For the Vendor, on the Accounting tab, the first 3 characters of the Bank ID field are the Bank Code. The next 5 characters are the Branch Code. The rest of the Bank ID is the Destination/Customer Acct #.

Controls-Grids

·    When a grid that supports the Grid Search feature has focus, a hint will appear at the left in the Status bar to indicate that the Ctrl-F keyboard shortcut can be used to open the search, and the Ctrl-Z shortcut for removing the last search level. When the mouse is used within the Grid search window to click an arrow button and change the column, the cursor will remain anchored on the clicked arrow to make it easier to move multiple columns over.

Import/Export

·    Importing Invoices now allows setting the Control Payment Status of Forced, On Hold or Normal as long as security rights to Control Payments is granted.

·    When Optional Fields are defined for either Vendors or Batches, the field titles now display in Import and Export template field lists, rather than a generic Optional Text 1 or similar label. This will make using optional fields easier to use.

·    When Editing properties for Text-type Optional Fields, a new Import button is now available to populate the list of possible values for this field. Only one-column Excel sheets without a header row are supported,

·    Import Vendors has new EFT related fields:

Telpay EFT only?

EFT account type/Bank Acct Type (Savings or Checking),

EFT Bank country code/vendor EFT tab Bank Dest. Country (USA or CAN)

EFT Company entry desc

Also, for non EFT methods, the Telpay EFT validation email has been renamed: EFT validation emails. If this field is non-blank, it will be used. If it is left blank, Emailing EFT advices will use the Advice email or the Contact email.

·    In Import Manual Checks, Hdr-Addr. Remittance Note will default from the Vendor's record if it is not imported.

·    Vendor Notes can now be Imported and Exported in the same way as Customer Notes in Adagio Receivables.

Inquiry

·    The GL Disbursement file now stores the second Description field that gets sent to the GL Retrieval batch, for use when inquiring on vendor transactions.

File 1099 Express Forms

·    Payables now has integration with 1099 Express for paperless e-filing to the IRS for NEC and MISC 1099s. If this Company Profile option is selected, the 1099 form types that have been assigned to Vendors should be updated to set the 1099 Express Options. There is a new function on the Maintenance menu to File 1099 Express Forms.

·    In Payables 9.3B, a new feature was added to allow sorting printed checks by various methods. A new sort option for Entry Number has been added in AP9.3C when printing checks from a Manual Check batch. It allows printing checks in the same order as in versions prior to 9.3B.

Posting

·    When integrated with Adagio JobCost, posting a transaction with a job detail now writes the job, phase and category values to the GL Disbursement data file. This information can be added to the grid within vendor transaction inquiry for GL distribution lookup.

·    When integrated with Adagio BankRec, posting manual check batches writes the Reference, 2nd Description and Batch Optional Fields to the batch retrieved into BankRec.

·    When Adagio BankRec is integrated and is at version 9.3A or higher, posting manual checks now writes the AP Reference, second Description and batch optional fields to the batch entries retrieved into BankRec.

Problems Fixed

·    Fixed a problem where, if a transaction entry amount was greater than 0.00 and the Distribution code it used was changed, the transaction entry amount would be changed also. Note that, if the transaction entry amount is 0.00 and the Distribution code is changed to one having a default amount of greater than 0.00, the transaction entry amount will be changed to be that of the Distribution code selected.

·    In Invoice Batch Entry, 'Auto-Distribute' was not setting the Tax Base to 0.00 in Invoice Details that were not Tax related.

·    Adjustments that affected retainage could be entered and posted without an Original document number. Batch Entry has been updated so that an Adjustment that updates Retainage can no longer be saved without an Adjusted document number.

·    Adding Manual Check Payment Entry, the new entry did not have cursor in the Vendor code field in some cases.

·    In Adjustment batch entry with MultiCurrency enabled, selecting a source currency vendor would not immediately populate the Exchange Rate value until an Adjusted Document number was selected. Now the current rate is initially loaded if the adjustment won't be applied, and replaced if an Adjusted Doc number is chosen.

·    Entry templates for Manual Check batch entry were not correctly hiding the Invoice Date field for cash invoices.

·    The Integrity errors \\\"Error: Payments have been over applied to Vendor nnnnnn document nnnnnn\\\" caused by changing the Vendor code on an existing Manual Check batch Payment entry won’t occur.

·    Manual Check Batch Payments can no longer be applied to Invoices if the Max payment is 0.00. System Check runs or other Manual Checks in progress may have set the Max Payment to 0. If the Max payment is 0 and there are no Checks in progress, use Payment Control to update the Max Payment for the invoice.

·    If a Manual Check batch Payment entry was attempted to be saved with neither the Print Check option nor a check number, and Auto Add Batch Entry was enabled, confirming the blank check number error would open a second batch entry screen before the first was complete. This has been corrected.

·    When viewing printed Cash Invoices or Prepayments in a manual check batch, previously you could view the details and the fields would be editable. However, nothing was able to be changed and saved, as an error would occur. Now the fields are correctly not editable in the first place.

·    When unsupported user defined codes were in the Send to GL Description setting in the company profile for Other entries, an access violation error when posting Check Reconciliation reversals could occur.

·    GL Description codes for Batch Optional and Time & Billing fields could be saved in the Company Profile for Other transaction types, even though these values are not supported. Now, these codes will give a verification error when editing and saving the Company Profile.

·    When selecting multiple batches on a grid sorted by Description, the Batch Listing report button is no longer active so that it is clear that the report only prints a single range of consecutive batches. If multiple batches are selected and the sort order is changed, the selection is cleared and a single row is highlighted.

·    If the filter Styles list was saved with the App Specific and Generic setting, this would cause the Manual Style field within Edit Vendors to show an incomplete list of styles and result in a List index out of bounds error.

·    An Error message appears instead of an Access Violation if a Favorite for the Pre-Check Register is printed from the Reports menu or added to a Report Set.

·    When printing System Checks, if the starting check number was changed from the default bank value, posting would write an audit sequence value with 18991230 to the Check Number Audit List report, rather than using the check date. This has been fixed.

·    In rare cases due to rounding, in System Check Processing, pressing the space bar on a vendor record to restore generated payments from zero would not do so.

·    After creating and saving a System Check Run, the Payables program window could be sent to the back of the Windows desktop and other open windows would appear on top.

·    System Check Runs now print the correct check amount when an invoice with a negative amount and Terms that calculate a Discount is selected to be included for the vendor payment. The Pre-check Register report was already correct.

·    Posting System Check Runs did not write a value to the Accounting Date field for the Ledger retrieval batch. This could potentially cause an error if the Payables batch was retrieved using the Subledger Period option.

·    The Bank ID field no longer allows non-numeric characters. If this field had been used for something other than a Bank Account number, it should be moved somewhere else. The data is not cleared during conversion but the field will be stripped if the vendor is edited and the field is visited.

·    If Telpay is the only EFT Provider, the 'Telpay EFT Only?' option on the vendor’s EFT tab will be enabled during data conversion.

·    When integrated with Adagio DocStore, deleting all attached PDFs from a batch entry but cancelling without saving changes would result in not clearing the Doc Link from the entry. This has been fixed.

·    Docstore errors appeared when attaching xlsx or JPG files in some cases. The related errors fixed are: 1) Error: User canceled path selection (5124) during call to ADocFilerPDFBrowse2. 2) Error: File name has unknown extension (10151) during call to ADocfilerCreateW

·    Drag and drop from an email was broken.

·    In version 9.3B, when integrated with Adagio DocStore, the ability to attach PDFs to printed manual checks was lost. Now, not only has the feature been restored, but there are 2 separate View PDF buttons - one for the manual check batch entry and the other for viewing attachments on posted invoices for Payments.

·    When printing the Check Number Audit List with a date range that does not have any checks, in some cases, an Access Violation error would occur.

·    The Check Number Audit List report printed the Home Equivalent amount with a value 100 times too large when MultiCurrency was enabled with the data. The data was correct but the report had a problem.

·    The Manual Check Batch Listing report was not printing the Revenue account associated with a Time Billing distribution from cash invoices in the GL Distribution Summary section. This has been corrected and is printing the same information as the Manual Check posting journal report.

·    When printing a report set directly to the AdagioV3PDF driver, and you choose to cancel printing for a particular report from the PDF Save As screen, you are now prompted to cancel printing just that report or the entire report set. This choice is written to the report log.

·    When printing Report Sets using either AdagioV2PDF or AdagioV3PDF as the specific printer, instead of using PDF Document as the destination, the report log now stores the PDF file name and save location instead of simply 'Printed to AdagioV3PDF'.

·    The next sequence number on the EFT Provider is now incremented during EFT Batch Creation when the Generate button is selected.

·    Within batch entry and accessing the Vendor information screens, the EFT Transaction Type field value was not loaded.

·    In Payables 9.3B and with the Adagio EFT add-on integration, the EFT Provider screen for the Montreal 80 format had the Send as Reference field hidden. The data was not affected, only the screen display. The field has been restored.

·    For EFT Vendors, if the Country for the Vendor's formatted address is not Canada or USA, the extra validation specific to Telpay will not be done.

·    The Email Setting for Wait Seconds Between sending emails is now used for sending email, in addition to sending emails from the Queue.

·    Viewing PDFs from the email queue for Letter and Advice forms gave a Failed to Launch error when Adagio DocStore was not integrated. This error no longer occurs.

·    Import Batches now gives a validation error when an optional field that requires a non-blank value, but is not verified against a predefined list, has a blank value in the import file.

·    Import Vendors: 'EFT Trans Type' has been updated to support 2 character Transaction Types for the Caribbean.

·    The Batch Status Inquiry screen incorrectly had an active Print PJ button when 2 or more Open batches were simultaneously selected. Now, the Print PJ button is correctly inactive unless at least one Posted batch is part of the selection.

·    Integrity errors were caused by editing a manual check payment, deleting the payment details and then saving the entry without any invoices being paid. This caused the error: 'Error: Manual checks have been over applied to Vendor...'.

·    Converting data from very old versions could result in Data Integrity Check giving an error ”'-' is not a valid integer value” if particular batch temporary files existed.

·    When a System Check Run has a Parked status but the data incorrectly has an empty Parked Check file, the data integrity check will now reset the Check Run status to Created, so that the payments can be recreated. Previously, the Resume status was available but could not complete the Check Run process.

·    In Adagio Payables 9.3B, printing some reports would log an error 4108 to the ADSError.log file due to a mismatch in the expected file size.

·    MultiCurrency data: Period End and the Open Payables and Aged Open Payables reports have been updated to make backdated reports more accurate.

·    Editing the Payment Control of an invoice now correctly prevents saving a Maximum Payment greater than the Current amount.

·    Changing the transaction clearing date on the Period End screen did not update the date value in the function summary of point E for deleting transactions.

·    User Preferences now has options for Archive Invoice and Manual Check Batches to automatically open on Start up.

·    Posting a batch with non-printed checks now correctly populates the batch (sequence) number for the Check Number Audit List report.

·    When posting a manual check batch with more than one non-printed entries, only the first entry had the audit sequence field of the check number audit list data file populated. This meant that printing the Check Number Audit List report with the Last Sequence option only printed the first check. Posting manual check batches has been fixed to prevent this scenario from happening.

·    If one user was retrieving posted checks into Adagio BankRec at the same time as another user was posting manual checks from the batch entry screen, resource locking didn't correctly prevent this and posting completed. Now, this is prevented. Resource locking was correctly in place if the user tried to post the manual check batch from the Post button on the toolbar.

·    System Check Runs for banks that support EFT processing now display the EFT code assigned to the bank, to assist in seeing what is set up for the bank.

·    Copying or Moving a single Archived Manual Check batch with Payment entries to a new Current Manual Check Batch, without updating either document numbers or dates, did not correctly update the Reserved Payment values on the paid invoice transaction records. This caused integrity errors both after copying and after posting.