Release 7.11
October, 2021

New Features and Enhancements - Release 7.11.0

A summary of enhancements made in updates since Release 7.10 is also included in this document. These include Update 7.10.5.3 whic fixes some problems with SCM price exceptions.

ERP Materials Management and Financials

Sourcing and Contract Management (SCM)

ERP Materials Management and Financials Enhancements

You can now create separate requisitions that generate separate POs at the header level, and not just at the line level.

Currently, on purchase orders generated from requisitions, the field Separate PO by Requisition can be selected on a requisition line. When the field is selected, the requisition line is entered on a separate PO for the vendor. With this enhancement, an entire requisition (and all its lines) can now be designated as "separate." This feature allows separate POs at the requisition header level, and prevents lines from multiple requisitions to be combined on a purchase order. Also, for requisitions whose lines are all "Separate PO," it avoids having to select the field on each line.

Here are the details of this enhancement. (See Figures 1- 4 )

  • The Separate PO By Requisition checkbox has been added to the requisition header edit panel.
  • The checkbox is available when creating a requisition or creating a requisition from an Order Guide.
  • The Separate PO By Requisition checkbox is available to be set for Regular, Bill-Only, Standing, and Blanket POs.
  • On each requisition line, the Separate PO By Requisition value defaults from the requisition header setting. On any requisition line, you can override this setting if needed. To change the setting, edit the line. The line will then go on another PO for the vendor.
  • The Separate PO By Requisition checkbox cannot be changed for bill-only requisitions.
  • The Separate PO By Requisition box appears on requisition lists, and is sortable and filterable.

Below are examples:

Editing a Regular Requisition Header with the New Separate PO Field

Materials Management main Contents > Requisitioning > Requisitions > New

Editing an Order Guide Requisition Header with the New Separate PO Field

Materials Management main Contents > Requisitioning > Order Guides for Requisitioning > Create Requisition from Order Guide

Separate PO Field Value on the Header Defaults to the Requisition Lines

Separate PO Column on the Requisitions List

Here are the PO lines on the unauthorized PO created for the requisition above (Figure 5). If another requisition is created for the same vendor, its lines will not migrate to the same PO as the PO generated using Separate PO By Requisition at the header level.

PO Lines Generated from Above Order Guide Requisition: Separate PO By Requisition

You can change the status of individual lines by editing the requisition (Figure 6) and unselecting Separate PO By Req.

Changing the Separate PO by Requisition Status on Two Lines

SCM Enhancements

Mouse over the blue shaded area on an expiring supply contract to display spend on the contract.

  1. From the Sourcing and Contract Management main Contents, select Contracts > Contract Workbench.
  2. Click the Contracts Expiring tab.
  3. Mouse over any blue shaded area. The blue shading indicates that the contract has spend, and the relative spend, compared to other contracts.
    With the mouse-over in this release, you can see a more precise value for spend. You can see prior spend on the contract for the previous 12 months, and total spend on the contract. Figure 7 is an example.

Displaying Spend on an Expiring Contract by Mouse-Over on the Shaded Area

 Previously, for an expired contract users could "unreject" and "accept" an item with rejected prices. That capability has been removed in this release.

You can display rejected items on a contract using the link on the "Work With Contract" page Actions panel (Figure 8).

Opening the List of Rejected Items on an Expired Contract

  • Click View Rejected Items. The list of rejected items appears (Figure 9). The figure displays rejected items on an expired contract.

Items with Rejected Prices: Disabled Unreject for Expired Contracts

For unexpired contracts, you can "unreject" any item by selecting the box Unreject & Accept. However, with this release, you can no longer do so for expired contracts. The box is grayed out and cannot be selected.

 The indicator Exp that a contract has expired is now visible on all panels that display the contract number.

For example, in Figure 8 above, Exp appears on the Contract Info panel.

  SCM Problem Resolutions

  • Local supply contracts cannot be extended using the Extend Until link on the Work with Contract page.
    This problem occurred primarily with Integrated Catalog customers where date alignment logic in contracts is enabled.
    Any supply contract may have an Extendable Until Date that can be displayed and edited on the Edit Contract panel of the "Work with Contract" page. The Edit panel allows changing or removing the Extended Until Date. However, with the Extend Until pop up, users could not change or remove the Extended Until Date.
    This problem has been resolved so that the Extend Until pop up panel works the same as editing the Extend Until Date field on the contract edit. The pop up now allows deletions and changes to the date. For Integrated Catalog sites, a confirmation window has also been added to get user confirmation for changing to a new date, since these contracts are subject to data alignment logic. The Submit button submits the confirmation.
  • Documents could not be added to a services contract when the documents tab was accessed from the documents icon on the "Services Contract Workbench" or "Supply Contracts Workbench" list (Figures M). The images below display the problem. However, if you were to open the contract and go to the documents tab and add the document there, no error would occur.
    Here are the problem images (Figure 10):
   
 

    Getting an Error When Trying to Add a Contract Document from the "Workbench" List

    This problem has been resolved so that documents can be added to a contract whether the user selects the "Workbench" icon, or opens the contract for editing.

    Enhancements and Problem Fixes from Updates

    The following changes were covered in previously released Notes for each hotfix or update.

    • Update 7.10.1

    ERP

    - In some cases, 810 Invoices show "No Data" when edited under the 810 Exceptions menu.

    Analysis shows-that records for the invoice were incorrectly unavailable to the edit. This problem has been resolved so that editing of these invoices works as designed.


    - Invoices created from 810s were ending up with a Quantity exception if the relevant item was not received and the 810 listed the same item multiple times for the same PO and PO line.

    When ERP creates an invoice match detail record from an 810, the received quantity is set as the invoiced quantity and the invoice goes into receipt exception. Later, when the item is received, the receipt exception clears. However, the received quantity was being set incorrectly, and not visible to the user. When the user noticed that the invoiced quantity was incorrect and changed it, the invoice had a quantity exception.
    Since the problem of duplicate items is a vendor issue, we cannot influence it. However, we have made the following changes to help users avoid the effects of the problem.

    • When an 810 is processed, and before the invoice match header is created, ERP checks the 810 details for duplicates. A duplicate is another 810 detail with the same PO line number, item number, invoiced UOM,vendor item number, and invoice unit cost.
    • ERP finds a duplicate 810 detail, the values for the invoice quantity and invoice line amount are summarized into one 810 detail, and the duplicate 810 detail line(s) deleted.

      The processing then continues normally, allowing the invoice to match as originally designed.

    Users were able to select a vendor’s suspended AP location for a check request. A vendor’s AP location for check payments was suspended because the vendor had an alternate AP location set up for ACH payments. However, when check requests were entered, users could select the suspended location. This problem has been resolved so that in situations like this, validations are in place for the suspension so users cannot select the suspended AP location for check requests.


    • Update 7.10.2
      ERP

    - The system was able to post journal vouchers whose journal entries were out of balance. The likely source of the problem was that the journal vouchers were created from a GL export, and while the import was running, the system encountered a lock. The system could not update either the debit or credit amount on the journal voucher header. When the JV was later edited, the status changed from incomplete to entered. The code checks that the debits and credits are equal, and if they are, the status of the JV can be changed to entered. Since both the debit amount and credit amount on the JV were zero, the edit allowed this to happen.
    The code and JV processing has been changed so that in situations like this, journal entries created in the system do not post when a journal voucher is out of balance.

     

    - An out-of-balance approved EDI 810 invoice for a blanket PO created an out-of-balance journal voucher that-the system posted. The blanket PO had a single non-file, zero cost, zero quantity line with receipts. In this situation, processing the 810 import normally creates an invoice with a missing line exception, even if the distribution detail line for the matched amount does not yet exist. When clearing the missing line exception on the invoice and selecting the PO's receipt line to match, code should create the match distribution line, if it is not found. That was not happening. As a result, the PO liability GL transaction was not created when the invoice was approved and left a one-sided AP transaction.
    This problem has been resolved by changing the code so that the distribution logic knows that it is clearing a missing line exception, allowing the matched distribution detail line to be created, and ultimately creating the GL transaction for PO liability when the invoice is approved.

     

    - PO Invoices were being set as sales taxable when the vendor's AP location had a tax type of nontaxable.
    When the AP Tax Enabled field was selected at the organization level, ERP was ignoring the AP location
    default tax type. The correct behavior is: when the Tax Enabled field on the organization record is selected. the system should check the AP location to determine if it is taxable or not. Regardless of the hierarchy, when the vendor's AP location is
    non-taxable, ERP should always set the invoice's tax type to non-taxable and the Tax Group field should be
    empty.
    This problem has been resolved. Here are the other tax rules:
    - When the Tax Enabled organization record field is unselected, no tax is applied, and the AP location default tax
    type is ignored.
    - When selected, the Tax Enabled field for the asset location checks the AP location for the default tax type.
    - When selected, the Tax Enabled field for the department checks the AP Location for the default tax type.
    - The Tax Enabled field can be unselected at the organization level, but selected at the asset location.
    - The Tax Enabled field can be unselected at the organization level, but selected at the department level.

     

    • Update 7.10.3
      ERP

    - Blanket requisitions with zero cost/zero quantity lines were dropping the charge override department. When matching the PO to the invoice, users received a message that the GL account was invalid.
    Blanket PO lines are receiptless, and their requisitions are created at the time of invoicing. Zero cost/zero quantity lines flow to the blanket PO created from the requisition. During invoicing, ERP deletes any zero quantity/zero cost lines, and writes a system note indicating the PO number created for the requisition.

    Because the expense code -- but not the override charge department -- was copied to the PO line, the system was trying to validate the expense code against the department/organization, and could not.

    This problem has been resolved. When matching PO invoices generated from blanket requisitions that contain..

    • zero quantity line(s)
    • an Override Charge Department entered on the Overrides tab,

    you will not receive an error message for an invalid GL account.

     

    - When clearing an invoice tax exception for a non-EDI invoice, the invoice would go into EDI Tax Exception status. This problem was traced to the code that sets the EDI Tax Exception flag. The problem has been resolved and clearing non-EDI tax exceptions behaves as designed. The Org Override Charge and the Department Override Charge values are now updated correctly on the PO Line records.

     

    - With some activities, users noted an increase in concurrency errors; for example, changing the buyer on bill-only POs, and then trying to authorize the POs. In general, this problem occurred when modifying information on the PO header for a non-manual / unauthorized PO, and then trying to authorize, authorize later, or save the PO. A long pause could occur, the system would time out and produce an “unspecified error.” Other incorrect behavior could also occur when trying to edit PO lines.
    This problem has been traced to an unintended impact of a previous code fix, and has been resolved. Changing data in a PO header or editing PO lines now behaves as designed when you authorize or save the PO.


    • Update 7.10.4 and 7.10.5
      ERP

    - Inventory transactions for EDI invoices (direct delivery POs) displayed on-hand quantity for non-stock/non-file item lines. (Non-file and non-stock items do not normally have on-hand quantity.) This problem was related to the way ERP completes invoices and multiple receipt records when the first line is non-file/non-stock. The problem was traced to parts of the code that set transaction types for different types of lines. This problem has been resolved so that on-hand quantities display correctly for direct delivery items.

    - In some situations, when a taxable invoice was approved, the invoice went out of balance during the approval process. The Difference for the out-of-balance invoice was twice the tax amount. The problem has been traced to calculations in the code that displays the invoice. This problem has been resolved. Invoices in balance will remain in balance during approvals.

    - Deleting EDI 810 invoices with missing line exceptions was creating an “exception” status on the PO. When ERP processes an 810 invoice that contains one or more missing line exceptions, the invoice is put in exception. ERP updates the PO record with the number of missing lines, which then puts the PO match status in exception. When the invoice was deleted, the PO record was not getting changed to reverse the update, leaving the PO in exception. The exception could not be cleared.
    This problem is resolved so that the match status on the PO record is now correct; e.g., “Part Received” or as appropriate.

    - In some situations, the Invoiced Qty field on a PO line was being calculated incorrectly when the invoice was deleted.
    This problem is unique in that a portion of the received quantity for the PO was previously canceled. An invoice was created for the PO ordered quantity, generating a quantity exception. The exception was cleared. However, when the invoice was subsequently deleted, the Invoiced Qty on the PO line detail showed values other than zero. This problem has been resolved so that in this situation, the correct invoiced quantity appears (zero) on the PO line detail.


    - Some EDI 810 invoices with exceptions were not appearing on the 810 Import Exceptions - All Organizations list. The application now displays imported EDI 810 invoices with a known 810 detail exception
    (present before processing) on the exceptions lists. These invoices have a status of “Ready For Processing.” Previously, these invoices would not appear on the 810 exceptions lists, and you would need to drill into the 810 header, then to the details to find any issues.


    ERP, SCM
    - After adding a new organization, the PO Edit panel was running slowly. This slowness was occurring only for POs in the new organization for sites with SCM (and ERP).
    The problem was traced to an SQL query, and has been resolved for the affected sites.


    • Update 7.10.5.3
      SCM

    - Users could not process large numbers (over 100) of contract Price Exceptions. The system would time out when the Price Exceptions were being worked. This problem has been resolved so that large numbers of exceptions can be resolved without time outs.

    - When the price exception count was clicked on the Contract Workbench's Exception tab, data was displayed, but contained items with a zero price difference. The problem occurred because the system was displaying items on tiers that were manually activated, and whose items should not have appeared as price exceptions. This issue was resolved so that SCM only displays price exceptions for tiers where "Activate All Items" was selected.

    - When a contract appeared on the Contract Workbench Price Exceptions tab and the Exceptions tab of the Work with Contract panel, when the price exception count was clicked, the number of records displayed on the Price Exceptions panel did not match the price exceptions count for that contract. This problem has been resolved so that the counts are consistent.