IFS IDEAS Release Notes

Release Overview

Release Date

January 20, 2023

Release Type

Minor

Summary of Changes

IDEAS 6.23.0.0 has the following new Features:

Accounts Payable

Allow Multiple Banks per Vendor Record

• IDEAS is now able to record multiple banks for the same Vendor record.  Each bank must be for a different currency.  The payment currency of the check will dictate which bank record is used.  This impacts information printed to a physical check if Vendor Bank information is indicated on the Check Format used to print the check.  It also impacts ISO 20022 ACH payments.  The correct Vendor Bank information will be included in the XML file that is sent to the bank so that the paying bank has the correct information to process payments on to the Vendor Bank.

• Existing Vendor Bank information will have NA inserted for the currency.  With NA, the process will work as before.  If no Vendor Bank records have specific currency designations, then the payment process will use the NA currency bank record.  There is a copy function included in the Vendor Bank Codes screen that allows the user to copy the NA record to an actual currency

• The Vendor Bank Codes screen has been moved to the Utilities>>User Tables menu.  In the Vendor Maintenance and Vendor Inquiry screens, only the bank names and currencies are listed.  Editing of the Vendor Bank record must now be done in the new Vendor Bank Codes screen.  This allows for more security around the information in the Vendor Bank record as the screen can be menu secured from users that have access to the Vendor Maintenance and Vendor Inquiry screens.

Purchase Documents

Validation of Stock POs

• It has been reported that the validation of stock number FQA’s does not occur until the invoicing step.  If there are problems with the stock number FQA, there are a lot of steps to rectify the condition at the invoicing stage.

• A new flag has been added to the Purchasing Parameter Setup screen, Stock Tab, in the Purchase Document module.  The flag Require Valid FQA to Approve PO, when set, will cause an FQA validation of each Purch and Non-Purch item in a Stock PO during approval.  If an FQA is invalid or missing for any line, the user will not be able to approve the Purchase Document.  This validation will occur in the following screens:

  • Purchase Documents

    • Purchase Document Entry (Separate Approval Off)

    • Batch Purchase Document Approval (Separate Approval On)

    • Amendment Approval

  • iApprove

    • Purchase Document Listing Screen

    • Purchase Document Detail

Currency Conversion

Additional Rate Service Banks

• In 6.22.0.0, a Rate service was added to IDEAS to automatically download daily Fx Exchange Rates directly into the IDEAS database from the following banks and web rate services.

  • Bank of Canada

  • Bank of Turkey

  • ExchangeRate.host

• In 6.23.0.0, the following bank and web services have been added.

  • Bank of Israel

  • Bank of Romania

  • Bank of Hungary

  • OANDA Forex Trading

Key Maintenance

Accounts Payable

Invoice Entry

• With the option to journalize by vendor set in Entity Maintenance, the Conversion check box in the Defaults tab of the Invoice Entry screen was not automatically checked.  Corrected the process to get this information from the journalize by vendor table instead of the journalize by entity table.

• Corrected an issue where the tax basis for VAT tax codes was not calculated correctly after selecting the VAT tax code

Aged Open Payable Report

• Resolved an issue where the Aged Open Payable Report gave an Invalid column name ‘tax_basis’ when the Include WH Tax option was selected for the report.

Auto Invoice

• If an invoice imported through Auto Invoice was related to a PO, then the taxes associated with the invoice were not registered.  A correction was made to properly import the taxes when the invoice was related to a PO.

General Ledger

Reverse Batch Utility

• Corrected a data conversion error when reversing batches that use the Post_User1 or Post_User2 fields to update volume segments.  If these batches needed to be reversed, the error was preventing the reversing journals from being created.

Inventory Accounting

Process WH Transactions

• Corrected a performance issue when processing WH Transactions.  Modified a Trigger used to calculate SAP at the point of receipt instead of after entry of the invoice to improve performance.

See the 6.23.0.0 Risk Assessment for the full list of maintenance items included in this release.

Compatibility Matrix

Product Certification

Interoperability Certification

Minimum System Requirements

Hardware

This section identifies the recommended hardware requirements for each machine.

Client

Server

Software

Server Machine

• MS .Net Framework 4.8
• SQL Server
• Excel
• Crystal Reports (Installed)
• PDF Viewer (Optional)
• Web Browser (Optional)
  
  

Client Machine

• MS .Net Framework 4.8
• Excel
• Crystal Reports (Installed)
• PDF Viewer
• Web Browser

Web Server

• ASP.net 4.6
• ,net Framework 4.8
• .net Core Hosting Bundle 3.1